trees
3,247 rows where qSpecies_id = 22 sorted by PlantDate descending
This data as json, CSV (advanced)
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
80242 | 108622 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 244 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | Permit Number 772819 | 6002313.92049 | 2109316.75363 | 37.7719124170473 | -122.435390704283 | (37.7719124170473, -122.435390704283) | 15 | 5 | 11 | 29492 | 9 | |
57184 | 68938 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 521 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 4 | Permit Number 32923 | 5992494.17103 | 2111890.59208 | 37.7784169086099 | -122.469545019028 | (37.7784169086099, -122.469545019028) | 11 | 6 | 2 | 54 | 11 | |
189175 | 6662 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1550 Evans Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/1992 12:00:00 AM | 6 | 3X3 | 6016012.05161 | 2098330.17252 | 37.7425140162093 | -122.387240954701 | (37.7425140162093, -122.387240954701) | 10 | 3 | 8 | 58 | 1 | ||
17481 | 52506 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 180 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48613 | 6000220.46380878 | 2092503.12984203 | 37.7256271406599 | -122.441425411243 | (37.7256271406599, -122.441425411243) | 9 | 7 | 6 | 28861 | 25 | ||
11309 | 44191 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Harrison St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | 6 | 2 | 9 | 28855 | 6 | |||
37647 | 44195 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | 6 | 2 | 9 | 28855 | 6 | |||
42164 | 44189 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Harrison St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | 6 | 2 | 9 | 28855 | 6 | |||
51369 | 44194 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Harrison St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | 6 | 2 | 9 | 28855 | 6 | |||
72872 | 44190 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Harrison St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | 6 | 2 | 9 | 28855 | 6 | |||
103647 | 44198 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2000 12:00:00 AM | 4 | Permit Number 43651 | 6015613.21564 | 2115159.68111 | 37.7887020993715 | -122.389795273027 | (37.7887020993715, -122.389795273027) | 6 | 2 | 9 | 28855 | 6 | ||
111099 | 44201 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Harrison St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | 6 | 2 | 9 | 28855 | 6 | |||
121191 | 44192 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Harrison St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | 6 | 2 | 9 | 28855 | 6 | |||
132960 | 44196 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2000 12:00:00 AM | 4 | Permit Number 43651 | 6015590.27485 | 2115136.01269 | 37.7886358391193 | -122.389872991572 | (37.7886358391193, -122.389872991572) | 6 | 2 | 9 | 28855 | 6 | ||
142441 | 44193 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Harrison St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | 6 | 2 | 9 | 28855 | 6 | |||
184190 | 44197 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2000 12:00:00 AM | 4 | Permit Number 43651 | 6015604.12637 | 2115150.5006 | 37.7886763877505 | -122.389826079337 | (37.7886763877505, -122.389826079337) | 6 | 2 | 9 | 28855 | 6 | ||
103602 | 68859 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 378 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32822 | 5998916.65569414 | 2094404.18671819 | 37.730772635316 | -122.44606923013 | (37.730772635316, -122.44606923013) | 9 | 7 | 4 | 59 | 40 | ||
149010 | 46119 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2001 12:00:00 AM | Permit Number 44476 | 6015543.8 | 2115940.8 | 37.7908430231508 | -122.390090033136 | (37.7908430231508, -122.390090033136) | 6 | 2 | 9 | 28855 | 6 | |||
124981 | 40943 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 337 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | Permit Number 773706 | 6001124.10704 | 2092689.09329 | 37.726189192361 | -122.438314913304 | (37.726189192361, -122.438314913304) | 9 | 7 | 6 | 28861 | 25 | |
158956 | 108542 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 225 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773703 | 6001152.31796 | 2093187.75047 | 37.7275599956139 | -122.438253097429 | (37.7275599956139, -122.438253097429) | 9 | 7 | 6 | 28861 | 25 |
89821 | 102141 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 53 Wilder St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2012 12:00:00 AM | 3 | 2x3 | Permit Number 769415 | 6002570.6 | 2095528.3 | 37.7340671770771 | -122.433517283514 | (37.7340671770771, -122.433517283514) | 2 | 7 | 5 | 63 | 7 | |
111982 | 102142 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 53 Wilder St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2012 12:00:00 AM | 5 | 2x3 | Permit Number 769415 | 6002570.6 | 2095528.3 | 37.7340671770771 | -122.433517283514 | (37.7340671770771, -122.433517283514) | 2 | 7 | 5 | 63 | 7 | |
77218 | 14417 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 10X Masonic Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/24/2003 12:00:00 AM | 6 | 3X3 | 5998974.44495 | 2113166.80204 | 37.7822934388942 | -122.447219282802 | (37.7822934388942, -122.447219282802) | 15 | 5 | 1 | 54 | 16 | ||
30397 | 31035 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 300 Bennington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2015 12:00:00 AM | 1 | Permit Number 771782 | 6007054.85561 | 2096718.77749 | 37.7375893700518 | -122.418098149219 | (37.7375893700518, -122.418098149219) | 2 | 7 | 7 | 28859 | 2 | ||
125027 | 108519 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1241 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773665 | 5994833.54334 | 2107094.83383 | 37.7653839436153 | -122.461104605949 | (37.7653839436153, -122.461104605949) | 15 | 5 | 11 | 56 | 12 |
192106 | 108516 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 695-699X 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773792 | 5993787.87218 | 2111075.28381 | 37.7762529739024 | -122.465010427519 | (37.7762529739024, -122.465010427519) | 11 | 6 | 2 | 54 | 11 |
5809 | 62467 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 710 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/1985 12:00:00 AM | 10 | Permit Number 22636 | 6011241.19795 | 2104960.20112 | 37.760453261625 | -122.404203766595 | (37.760453261625, -122.404203766595) | 10 | 3 | 8 | 28856 | 29 | |
133240 | 4174 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3809 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/22/2014 12:00:00 AM | 3 | 3x3 | 6005074.45285 | 2100459.68403 | 37.7477493826385 | -122.425211462866 | (37.7477493826385, -122.425211462866) | 2 | 4 | 5 | 63 | 22 | ||
184037 | 55930 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1680 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2009 12:00:00 AM | 3x3 | Permit Number 53115 | 5992813.78045219 | 2104035.719351 | 37.7568679811889 | -122.467867918822 | (37.7568679811889, -122.467867918822) | 1 | 8 | 4 | 56 | 12 | ||
3744 | 39401 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1690 Church St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.7438431217943 | -122.426774196771 | (37.7438431217943, -122.426774196771) | 2 | 7 | 5 | 63 | 22 | |||
17318 | 39391 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1690 Church St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.7438431217943 | -122.426774196771 | (37.7438431217943, -122.426774196771) | 2 | 7 | 5 | 63 | 22 | |||
29930 | 39397 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1690 Church St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.7438431217943 | -122.426774196771 | (37.7438431217943, -122.426774196771) | 2 | 7 | 5 | 63 | 22 | |||
110065 | 39405 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1690 Church St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.7438431217943 | -122.426774196771 | (37.7438431217943, -122.426774196771) | 2 | 7 | 5 | 63 | 22 | |||
112855 | 39393 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1690 Church St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.7438431217943 | -122.426774196771 | (37.7438431217943, -122.426774196771) | 2 | 7 | 5 | 63 | 22 | |||
115675 | 39398 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1690 Church St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.7438431217943 | -122.426774196771 | (37.7438431217943, -122.426774196771) | 2 | 7 | 5 | 63 | 22 | |||
128334 | 39395 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1690 Church St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.7438431217943 | -122.426774196771 | (37.7438431217943, -122.426774196771) | 2 | 7 | 5 | 63 | 22 | |||
135278 | 39400 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1690 Church St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.7438431217943 | -122.426774196771 | (37.7438431217943, -122.426774196771) | 2 | 7 | 5 | 63 | 22 | |||
136039 | 39390 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1690 Church St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.7438431217943 | -122.426774196771 | (37.7438431217943, -122.426774196771) | 2 | 7 | 5 | 63 | 22 | |||
137798 | 39402 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1690 Church St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.7438431217943 | -122.426774196771 | (37.7438431217943, -122.426774196771) | 2 | 7 | 5 | 63 | 22 | |||
143628 | 39394 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1690 Church St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.7438431217943 | -122.426774196771 | (37.7438431217943, -122.426774196771) | 2 | 7 | 5 | 63 | 22 | |||
156544 | 39392 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1690 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.7438431217943 | -122.426774196771 | (37.7438431217943, -122.426774196771) | 2 | 7 | 5 | 63 | 22 | |||
159940 | 39399 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1690 Church St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.7438431217943 | -122.426774196771 | (37.7438431217943, -122.426774196771) | 2 | 7 | 5 | 63 | 22 | |||
161029 | 39389 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1690 Church St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.7438431217943 | -122.426774196771 | (37.7438431217943, -122.426774196771) | 2 | 7 | 5 | 63 | 22 | |||
172309 | 39404 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1690 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.7438431217943 | -122.426774196771 | (37.7438431217943, -122.426774196771) | 2 | 7 | 5 | 63 | 22 | |||
172550 | 39396 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1690 Church St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.7438431217943 | -122.426774196771 | (37.7438431217943, -122.426774196771) | 2 | 7 | 5 | 63 | 22 | |||
176882 | 39403 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1690 Church St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.7438431217943 | -122.426774196771 | (37.7438431217943, -122.426774196771) | 2 | 7 | 5 | 63 | 22 | |||
71987 | 226129 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 468 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2016 12:00:00 AM | 9 | Width 3ft | 6002897.69632 | 2099218.59818 | 37.7442184383445 | -122.432649927259 | (37.7442184383445, -122.432649927259) | 2 | 7 | 5 | 63 | 22 | ||
87656 | 64270 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1649 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/2012 12:00:00 AM | Permit Number 769488 | 6009729.21200973 | 2100183.41630946 | 37.7472526761303 | -122.409095988159 | (37.7472526761303, -122.409095988159) | 2 | 7 | 7 | 28859 | 2 | ||
154256 | 44131 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2820 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/2000 12:00:00 AM | 4 | Permit Number 43633 | 6005248.14777 | 2119695.60909 | 37.8005763744637 | -122.425979944327 | (37.8005763744637, -122.425979944327) | 13 | 9 | 1 | 57 | 17 | ||
194343 | 265044 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 1250 Eucalyptus Dr | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 5x10 | Permit Number 781946 | 5987698.06233 | 2094734.87015 | 37.7310335805158 | -122.484877445397 | (37.7310335805158, -122.484877445397) | 1 | 8 | 4 | 64 | 35 | |
194346 | 265043 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 1250 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 5x10 | Permit Number 781946 | 5987698.06233 | 2094734.87015 | 37.7310335805158 | -122.484877445397 | (37.7310335805158, -122.484877445397) | 1 | 8 | 4 | 64 | 35 | |
132750 | 5491 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 730 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/17/2007 12:00:00 AM | 3 | 3X3 | 6004960.44837 | 2104097.58597 | 37.7577317737189 | -122.425864595473 | (37.7577317737189, -122.425864595473) | 2 | 4 | 5 | 28862 | 3 | ||
182031 | 5198 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 635 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2001 12:00:00 AM | 3 | 3x3 | 6001582.4984 | 2110645.9942 | 37.775520613317 | -122.43801597154 | (37.775520613317, -122.43801597154) | 15 | 5 | 11 | 29492 | 10 | ||
70152 | 57739 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1430 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/1992 12:00:00 AM | 1 | Permit Number 31420 | 6009340.15372 | 2118176.38357 | 37.7966353671694 | -122.411712476165 | (37.7966353671694, -122.411712476165) | 3 | 1 | 10 | 308 | 4 | ||
146429 | 67806 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 867 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31457 | 6000839.18474715 | 2101975.25274037 | 37.751670596488 | -122.439965416077 | (37.751670596488, -122.439965416077) | 2 | 4 | 5 | 28862 | 22 | ||
190998 | 61749 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3849 26TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/1984 12:00:00 AM | 12 | 3x3 | Permit Number 21755 | 6004830.1 | 2100717.5 | 37.7484434784717 | -122.426074773634 | (37.7484434784717, -122.426074773634) | 2 | 4 | 5 | 63 | 22 | |
110749 | 53556 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 155 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/1969 12:00:00 AM | 5 | Permit Number 6468 | 5990822.61349 | 2114386.11588 | 37.7851721782666 | -122.47550976424 | (37.7851721782666, -122.47550976424) | 11 | 6 | 2 | 54 | 26 | ||
154273 | 52406 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 51 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/2005 12:00:00 AM | Permit Number 48525 | 6006289.36692321 | 2098690.46221528 | 37.7429600597297 | -122.420884755481 | (37.7429600597297, -122.420884755481) | 2 | 7 | 7 | 28859 | 2 | ||
107263 | 16534 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1420X Evans Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/2004 12:00:00 AM | 3 | 3X3 | 6016649.3386754 | 2097853.1412174 | 37.7412394571821 | -122.385004155587 | (37.7412394571821, -122.385004155587) | 10 | 3 | 8 | 58 | 1 | ||
94289 | 59558 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 214 Maynard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/1992 12:00:00 AM | 8 | Permit Number 31386 | 6004840.03316 | 2093769.64251 | 37.7293667957293 | -122.42554602055 | (37.7293667957293, -122.42554602055) | 9 | 7 | 6 | 28861 | 5 | ||
29912 | 55609 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 142 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/1972 12:00:00 AM | 1 | Permit Number 11586 | 5992448.32925563 | 2114520.13069232 | 37.7856342525233 | -122.469895103767 | (37.7856342525233, -122.469895103767) | 11 | 6 | 2 | 54 | 11 | ||
162523 | 92855 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1101 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2009 12:00:00 AM | Permit Number 53074 | 6001966 | 2100891 | 37.7487575771252 | -122.435991171851 | (37.7487575771252, -122.435991171851) | 2 | 4 | 5 | 28862 | 22 | |||
114600 | 24370 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 170 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2007 12:00:00 AM | 3 | 3X3 | 6005596.02318 | 2108503.96371 | 37.7698665410346 | -122.423979852088 | (37.7698665410346, -122.423979852088) | 8 | 4 | 5 | 28853 | 19 | ||
192668 | 46083 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 678 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2001 12:00:00 AM | 1 | Permit Number 44461 | 6009646.5972 | 2120203.7861 | 37.8022193006044 | -122.4107953652 | (37.8022193006044, -122.4107953652) | 3 | 1 | 10 | 308 | 23 | ||
8668 | 39268 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 540 Delancey St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40880 | 6015240.80145 | 2113614.13929 | 37.7844377354544 | -122.390975718675 | (37.7844377354544, -122.390975718675) | 6 | 2 | 9 | 28856 | 6 |
18366 | 39267 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 540 Delancey St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40880 | 6015247.62996 | 2113604.71354 | 37.7844122333873 | -122.390951435185 | (37.7844122333873, -122.390951435185) | 6 | 2 | 9 | 28856 | 6 |
68756 | 52343 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 9 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2005 12:00:00 AM | Permit Number 48487 | 5993020.12336705 | 2099071.55255043 | 37.7432495660688 | -122.466793461069 | (37.7432495660688, -122.466793461069) | 1 | 8 | 4 | 59 | 40 | |||
191435 | 71800 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2169 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2008 12:00:00 AM | 3x3 | Permit Number 51966 | 5997498.69727055 | 2109850.09270913 | 37.7731021869441 | -122.45208531215 | (37.7731021869441, -122.45208531215) | 15 | 5 | 11 | 29492 | 16 | ||
42742 | 81988 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 442 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2007 12:00:00 AM | 3 | 3x3 | Permit Number 50000 | 5982237.66367 | 2112787.15702 | 37.7802805115522 | -122.505091982727 | (37.7802805115522, -122.505091982727) | 11 | 6 | 2 | 55 | 26 | |
97347 | 23631 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 57 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/11/2003 12:00:00 AM | 3 | 3X3 | 6006306.857782 | 2098679.9716835 | 37.7429322409736 | -122.420823532183 | (37.7429322409736, -122.420823532183) | 2 | 7 | 7 | 28859 | 2 | ||
48498 | 33757 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 16 Henry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/1996 12:00:00 AM | Permit Number 37810 | 6003402.50922955 | 2107448.70310464 | 37.766844969098 | -122.431491817447 | (37.766844969098, -122.431491817447) | 15 | 5 | 5 | 28862 | 3 | |||
144884 | 66772 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2 Pearl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/10/1994 12:00:00 AM | Permit Number 30031 | 6005583.60582108 | 2109041.70693845 | 37.771342353738 | -122.424061050426 | (37.771342353738, -122.424061050426) | 8 | 2 | 5 | 28853 | 19 | ||
73831 | 31450 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 515 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53997 | 6001863.73934 | 2102822.19649 | 37.754054372127 | -122.436482991608 | (37.754054372127, -122.436482991608) | 2 | 4 | 5 | 28862 | 22 |
97514 | 28491 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1444 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/09/2003 12:00:00 AM | 8 | 3X3 | 6005199.4144851 | 2099918.543192 | 37.7462705927584 | -122.424740860946 | (37.7462705927584, -122.424740860946) | 2 | 7 | 5 | 63 | 22 | ||
6645 | 226161 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 126 Grattan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/09/1993 12:00:00 AM | 9 | Width 4ft | Permit Number 32799 | 5997997.11826 | 2106529.02842 | 37.76401192934 | -122.450121798605 | (37.76401192934, -122.450121798605) | 15 | 5 | 11 | 29492 | 9 | |
90305 | 58586 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 126 Grattan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/09/1993 12:00:00 AM | 4x4 | Permit Number 32799 | 5998027.55181779 | 2106540.68640664 | 37.7640456807087 | -122.450017378701 | (37.7640456807087, -122.450017378701) | 15 | 5 | 11 | 29492 | 9 | ||
177192 | 5603 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1126 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2003 12:00:00 AM | 3 | 3x3 | 6005088.25831 | 2101777.30613 | 37.7513680486157 | -122.425257470357 | (37.7513680486157, -122.425257470357) | 2 | 4 | 5 | 28862 | 22 | ||
135489 | 46068 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2318 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2001 12:00:00 AM | 4 | Permit Number 44453 | 6011842.96838 | 2101888.73185 | 37.7520532897435 | -122.401906592314 | (37.7520532897435, -122.401906592314) | 10 | 3 | 8 | 28856 | 29 | ||
40881 | 5297 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1600 Divisadero St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/07/1995 12:00:00 AM | 3 | 2X3 | 6001162.4866 | 2114099.2454 | 37.7849784685073 | -122.439716519057 | (37.7849784685073, -122.439716519057) | 15 | 6 | 11 | 29490 | 13 | ||
26417 | 66310 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 136 Hamerton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29425 | 6001332.72327258 | 2095407.42415394 | 37.7336649686266 | -122.43778834571 | (37.7336649686266, -122.43778834571) | 9 | 7 | 5 | 63 | 40 | ||
41278 | 66312 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 143 Hamerton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29427 | 6001377.41574875 | 2095374.46813255 | 37.7335770202313 | -122.437631471673 | (37.7335770202313, -122.437631471673) | 9 | 7 | 5 | 63 | 40 | ||
191260 | 66309 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 132 Hamerton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29424 | 6001336.27411679 | 2095419.91678069 | 37.7336994724005 | -122.437776963861 | (37.7336994724005, -122.437776963861) | 9 | 7 | 5 | 63 | 40 | ||
28883 | 34868 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 448 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2007 12:00:00 AM | 3x3 | Permit Number 49951 | 6003547.62609569 | 2096418.61112327 | 37.7365671542892 | -122.430202896046 | (37.7365671542892, -122.430202896046) | 2 | 7 | 5 | 63 | 7 | ||
65840 | 228317 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 119 Germania St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1996 12:00:00 AM | 3 | Width 3ft | Permit Number 37770 | 6003543.43313 | 2108799.052 | 37.7705606845675 | -122.4311007758 | (37.7705606845675, -122.4311007758) | 15 | 9 | 11 | 29492 | 10 | |
61826 | 67724 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1346 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1992 12:00:00 AM | Permit Number 31342 | 5992116.05706304 | 2106274.73338322 | 37.7629754095582 | -122.470443943147 | (37.7629754095582, -122.470443943147) | 1 | 8 | 11 | 56 | 12 | ||
137420 | 33661 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 483 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/03/1996 12:00:00 AM | 2 | Permit Number 37749 | 6005107.1966 | 2110751.602 | 37.7760104013227 | -122.425830703288 | (37.7760104013227, -122.425830703288) | 7 | 9 | 11 | 28852 | 10 | |
191006 | 52307 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 125 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/02/2005 12:00:00 AM | Permit Number 48466 | 6004248.12570039 | 2092925.52836922 | 37.7270155836301 | -122.427532186974 | (37.7270155836301, -122.427532186974) | 9 | 7 | 6 | 28861 | 5 | ||
77760 | 50610 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 307 Spruce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2003 12:00:00 AM | 5 | Permit Number 47207 | 5997118.78265 | 2115251.45908 | 37.7879111492194 | -122.453789601717 | (37.7879111492194, -122.453789601717) | 11 | 6 | 1 | 54 | 31 | ||
150710 | 50609 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 307 Spruce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2003 12:00:00 AM | 5 | Permit Number 47207 | 5997116.52559 | 2115267.78958 | 37.7879558590154 | -122.45379859043 | (37.7879558590154, -122.45379859043) | 11 | 6 | 1 | 54 | 31 | ||
147257 | 114690 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 173 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | 1 | Permit Number 774716 | 6010597.60785 | 2093917.85298 | 37.7300973914745 | -122.405651885519 | (37.7300973914745, -122.405651885519) | 10 | 3 | 7 | 309 | 28 | ||
28328 | 45196 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3379 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/01/2001 12:00:00 AM | Permit Number 44041 | 6005846.47654917 | 2103129.45360257 | 37.7551235392216 | -122.422731541054 | (37.7551235392216, -122.422731541054) | 2 | 4 | 5 | 28859 | 19 | ||
24674 | 12708 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1448 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/1992 12:00:00 AM | 8 | 3X3 | 5990942.238 | 2114788.08158 | 37.7862827977651 | -122.475125259251 | (37.7862827977651, -122.475125259251) | 11 | 6 | 1 | 54 | 33 | ||
164081 | 12702 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1415 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/1992 12:00:00 AM | 6 | 3X3 | 5991067.52539 | 2114735.08687 | 37.7861445496005 | -122.474687932397 | (37.7861445496005, -122.474687932397) | 11 | 6 | 2 | 54 | 26 | ||
142427 | 114668 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 176X Peralta Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | Permit Number 774564 | 6009847.7 | 2100071.6 | 37.7469522901695 | -122.408678376857 | (37.7469522901695, -122.408678376857) | 2 | 7 | 7 | 28859 | 2 | |||
158621 | 14415 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 10X Masonic Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/30/2014 11:00:00 PM | 3 | 3X3 | 5998974.44495 | 2113166.80204 | 37.7822934388942 | -122.447219282802 | (37.7822934388942, -122.447219282802) | 15 | 5 | 1 | 54 | 16 | ||
63259 | 55483 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 541 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1972 12:00:00 AM | Permit Number 11436 | 6002127.49962023 | 2110317.53066038 | 37.774649712906 | -122.436107174272 | (37.774649712906, -122.436107174272) | 15 | 5 | 11 | 29492 | 10 | |||
134329 | 56346 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 615 Front St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/28/2017 12:00:00 AM | 3 | Permit Number 12488 | 6012822.94142 | 2118342.56385 | 37.797286416082 | -122.399672847242 | (37.797286416082, -122.399672847242) | 3 | 1 | 10 | 28860 | 6 | ||
8732 | 261131 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 205 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 3ft | 6002921 | 2092296 | 37.725211886246 | -122.432075099304 | (37.725211886246, -122.432075099304) | 9 | 7 | 6 | 28861 | 5 | ||
42367 | 101840 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 654 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2012 12:00:00 AM | 1 | 3x3 | Permit Number 769499 | 6011223.03061 | 2105283.28605 | 37.7613393654344 | -122.404289339783 | (37.7613393654344, -122.404289339783) | 10 | 3 | 8 | 28856 | 29 | |
21207 | 33596 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 224 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/27/1996 12:00:00 AM | Permit Number 37704 | 6006764.88220944 | 2097872.66772056 | 37.7407413706298 | -122.419182553853 | (37.7407413706298, -122.419182553853) | 2 | 7 | 7 | 28859 | 2 | ||
181157 | 33594 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 208 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/1996 12:00:00 AM | Permit Number 37702 | 6006803.38226824 | 2097943.62645623 | 37.7409383755984 | -122.419054466757 | (37.7409383755984, -122.419054466757) | 2 | 7 | 7 | 28859 | 2 |
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) );