trees
36 rows where Fire Prevention Districts = 5 and qSpecies_id = 97 sorted by Neighborhoods (old)
This data as json, CSV (advanced)
These facets timed out: Fire Prevention Districts
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10858 | 128369 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 843 California St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 15 | Width 4ft | 6010471.73552 | 2116514.30785 | 37.7921351227858 | -122.4076796805 | (37.7921351227858, -122.4076796805) | 5 | 1 | 10 | 28857 | 21 | |||
20155 | 98985 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 847 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009438.4 | 2115684 | 37.7897973999496 | -122.411196371815 | (37.7897973999496, -122.411196371815) | 5 | 1 | 10 | 28857 | 21 | ||||
27124 | 33817 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1201 California St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1997 12:00:00 AM | Permit Number 37831 | 6008598.80477101 | 2116262.85239853 | 37.7913396656633 | -122.414142270961 | (37.7913396656633, -122.414142270961) | 5 | 1 | 10 | 28858 | 21 | |||
30441 | 116039 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1401x Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6008038.31567 | 2116541.76159 | 37.7920739841803 | -122.416101317043 | (37.7920739841803, -122.416101317043) | 5 | 1 | 10 | 28858 | 21 | |||
36271 | 126620 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1430 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6007903.30397 | 2116551.24821 | 37.7920924400618 | -122.416569132658 | (37.7920924400618, -122.416569132658) | 5 | 1 | 10 | 28858 | 21 | |||
37424 | 48789 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1405 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | 5 | 1 | 10 | 308 | 21 | |||
41084 | 48790 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1405 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/21/2006 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | 5 | 1 | 10 | 308 | 21 | ||
41504 | 33816 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1201 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1997 12:00:00 AM | Permit Number 37831 | 6008598.80477101 | 2116262.85239853 | 37.7913396656633 | -122.414142270961 | (37.7913396656633, -122.414142270961) | 5 | 1 | 10 | 28858 | 21 | |||
50226 | 48785 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1405 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | 5 | 1 | 10 | 308 | 21 | |||
58028 | 48791 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1405 Taylor St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | 5 | 1 | 10 | 308 | 21 | |||
83298 | 65478 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 601 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/12/1989 12:00:00 AM | Permit Number 28359 | 6010541.36110634 | 2116214.27782437 | 37.7913152098094 | -122.407417612453 | (37.7913152098094, -122.407417612453) | 5 | 1 | 10 | 28857 | 21 | ||
84852 | 65486 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 801 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1989 12:00:00 AM | Permit Number 28370 | 6009649.36997858 | 2115707.80146662 | 37.7898745823318 | -122.410468114048 | (37.7898745823318, -122.410468114048) | 5 | 1 | 10 | 28857 | 21 | ||
87294 | 99016 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1133 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 29980 | 6008997 | 2116859 | 37.7929988993441 | -122.41280668477 | (37.7929988993441, -122.41280668477) | 5 | 1 | 10 | 28857 | 21 | ||||
107326 | 66869 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 640 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1991 12:00:00 AM | Permit Number 30178 | 6009507.57601331 | 2115392.34348399 | 37.789000460867 | -122.410936420318 | (37.789000460867, -122.410936420318) | 5 | 1 | 10 | 28857 | 21 | ||
129528 | 98986 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 847 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009438.4 | 2115684 | 37.7897973999496 | -122.411196371815 | (37.7897973999496, -122.411196371815) | 5 | 1 | 10 | 28857 | 21 | ||||
148031 | 98988 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 847 Bush St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009438.4 | 2115684 | 37.7897973999496 | -122.411196371815 | (37.7897973999496, -122.411196371815) | 5 | 1 | 10 | 28857 | 21 | ||||
152169 | 65423 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 801 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1989 12:00:00 AM | Permit Number 28281 | 6010517.63649674 | 2116529.16048818 | 37.7921784739149 | -122.407521909343 | (37.7921784739149, -122.407521909343) | 5 | 1 | 10 | 28857 | 21 | ||
170940 | 98987 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 847 Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009438.4 | 2115684 | 37.7897973999496 | -122.411196371815 | (37.7897973999496, -122.411196371815) | 5 | 1 | 10 | 28857 | 21 | ||||
176360 | 53343 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 620 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1995 12:00:00 AM | Permit Number 30179 | 6009598.94591555 | 2115405.06508937 | 37.7890405143898 | -122.410621189952 | (37.7890405143898, -122.410621189952) | 5 | 1 | 10 | 28857 | 21 | ||
178511 | 116038 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1401x Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6008011.06753 | 2116537.17208 | 37.7920598504338 | -122.416195270994 | (37.7920598504338, -122.416195270994) | 5 | 1 | 10 | 28858 | 21 | |||
181146 | 48788 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1405 Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | 5 | 1 | 10 | 308 | 21 | |||
27553 | 97723 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1000X Bay St | 2 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 7x57 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | 5 | 1 | 1 | 28858 | 32 | ||
79131 | 97722 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1000X Bay St | 1 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 7x57 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | 5 | 1 | 1 | 28858 | 32 | ||
80740 | 35236 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1198 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 10 | Permit Number 38733 | 6007268.58471 | 2119527.95161 | 37.8002300077587 | -122.418976495462 | (37.8002300077587, -122.418976495462) | 5 | 1 | 1 | 28858 | 32 | |
91578 | 97725 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1000X Bay St | 4 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 7x82 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | 5 | 1 | 1 | 28858 | 32 | |||
125743 | 35237 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1198 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 8 | Permit Number 38733 | 6007256.14978 | 2119525.96271 | 37.8002238465228 | -122.419019384135 | (37.8002238465228, -122.419019384135) | 5 | 1 | 1 | 28858 | 32 | |
160598 | 34453 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1167 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | 10 | Permit Number 38197 | 6007453.34661 | 2118811.22971 | 37.7982724714417 | -122.418286300874 | (37.7982724714417, -122.418286300874) | 5 | 1 | 10 | 28858 | 32 | |
167189 | 97724 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1000X Bay St | 3 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 7x82 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | 5 | 1 | 1 | 28858 | 32 | ||
23293 | 101516 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 610 Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Permit Number 28301 | 6008387 | 2114552 | 37.7866301828456 | -122.414753982265 | (37.7866301828456, -122.414753982265) | 5 | 1 | 10 | 28858 | 36 | ||
56711 | 100477 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 340 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 781547 | 6009834.90147 | 2114634.4517 | 37.7869378210564 | -122.409750394691 | (37.7869378210564, -122.409750394691) | 5 | 10 | 10 | 28852 | 36 | ||
102755 | 62037 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 395 Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/1985 12:00:00 AM | 14 | 3x3 | Permit Number 781547 | 6009850.4646 | 2114693.00092 | 37.7870994553217 | -122.409700683759 | (37.7870994553217, -122.409700683759) | 5 | 1 | 10 | 28852 | 36 | |
102943 | 100479 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 340 Mason St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 781547 | 6009830.08403 | 2114659.89537 | 37.7870074133103 | -122.409768858656 | (37.7870074133103, -122.409768858656) | 5 | 10 | 10 | 28852 | 36 | ||
145583 | 101515 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 610 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Permit Number 28301 | 6008387 | 2114552 | 37.7866301828456 | -122.414753982265 | (37.7866301828456, -122.414753982265) | 5 | 1 | 10 | 28858 | 36 | ||
158586 | 100476 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 340 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 781547 | 6009833.38685 | 2114620.58318 | 37.7868996565447 | -122.409754655664 | (37.7868996565447, -122.409754655664) | 5 | 10 | 10 | 28852 | 36 | ||
189489 | 100475 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 340 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 781547 | 6009838.89839 | 2114609.02446 | 37.7868682279306 | -122.409734770741 | (37.7868682279306, -122.409734770741) | 5 | 10 | 10 | 28852 | 36 | ||
86785 | 47045 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 111 Maiden Ln | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2002 12:00:00 AM | Permit Number 45035 | 6011125.92683466 | 2115044.13243826 | 37.7881349707775 | -122.405312579096 | (37.7881349707775, -122.405312579096) | 5 | 1 | 10 | 28857 | 6 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );