Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
142489 | 142489 | 108622 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 244 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | Permit Number 772819 | 6002313.92049 | 2109316.7536299997 | 37.7719124170473 | -122.43539070428301 | (37.7719124170473, -122.435390704283) | |
67596 | 67596 | 68938 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 521 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 4 | Permit Number 32923 | 5992494.17103 | 2111890.59208 | 37.7784169086099 | -122.46954501902799 | (37.7784169086099, -122.469545019028) | |
16577 | 16577 | 6662 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1550 Evans Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/1992 12:00:00 AM | 6 | 3X3 | 6016012.0516099995 | 2098330.17252 | 37.7425140162093 | -122.387240954701 | (37.7425140162093, -122.387240954701) | ||
66026 | 66026 | 52506 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 180 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48613 | 6000220.46380878 | 2092503.12984203 | 37.7256271406599 | -122.441425411243 | (37.7256271406599, -122.441425411243) | ||
36592 | 36592 | 44200 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2000 12:00:00 AM | 4 | Permit Number 43651 | 6015644.9623 | 2115187.5878 | 37.7887804851876 | -122.389687383164 | (37.7887804851876, -122.389687383164) | ||
53179 | 53179 | 44191 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Harrison St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | |||
60489 | 60489 | 44198 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2000 12:00:00 AM | 4 | Permit Number 43651 | 6015613.21564 | 2115159.68111 | 37.7887020993715 | -122.389795273027 | (37.7887020993715, -122.389795273027) | ||
82358 | 82358 | 44194 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Harrison St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | |||
82887 | 82887 | 44189 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Harrison St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | |||
88797 | 88797 | 44190 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Harrison St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | |||
103387 | 103387 | 44201 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Harrison St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | |||
108462 | 108462 | 44192 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Harrison St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | |||
113372 | 113372 | 44193 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Harrison St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | |||
128614 | 128614 | 44195 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Harrison St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | |||
136336 | 136336 | 44196 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Harrison St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2000 12:00:00 AM | 4 | Permit Number 43651 | 6015590.27485 | 2115136.0126900002 | 37.788635839119294 | -122.389872991572 | (37.7886358391193, -122.389872991572) | ||
157322 | 157322 | 44199 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2000 12:00:00 AM | 3 | Permit Number 43651 | 6015629.81658 | 2115174.24288 | 37.7887430032356 | -122.38973885318899 | (37.7887430032356, -122.389738853189) | ||
170632 | 170632 | 44197 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2000 12:00:00 AM | 4 | Permit Number 43651 | 6015604.12637 | 2115150.5006 | 37.7886763877505 | -122.389826079337 | (37.7886763877505, -122.389826079337) | ||
100817 | 100817 | 68859 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 378 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1993 12:00:00 AM | Permit Number 32822 | 5998916.65569414 | 2094404.18671819 | 37.730772635316 | -122.44606923013 | (37.730772635316, -122.44606923013) | ||
111322 | 111322 | 46119 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | Permit Number 44476 | 6015543.8 | 2115940.8 | 37.7908430231508 | -122.390090033136 | (37.7908430231508, -122.390090033136) | |||
12587 | 12587 | 40943 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 337 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | Permit Number 773706 | 6001124.10704 | 2092689.0932900002 | 37.726189192361005 | -122.438314913304 | (37.726189192361, -122.438314913304) | |
117085 | 117085 | 108542 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 225 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773703 | 6001152.31796 | 2093187.75047 | 37.7275599956139 | -122.43825309742901 | (37.7275599956139, -122.438253097429) |
96532 | 96532 | 102141 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 53 Wilder St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2012 12:00:00 AM | 3 | 2x3 | Permit Number 769415 | 6002570.6 | 2095528.3 | 37.7340671770771 | -122.433517283514 | (37.7340671770771, -122.433517283514) | |
98112 | 98112 | 102142 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 53 Wilder St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2012 12:00:00 AM | 5 | 2x3 | Permit Number 769415 | 6002570.6 | 2095528.3 | 37.7340671770771 | -122.433517283514 | (37.7340671770771, -122.433517283514) | |
92038 | 92038 | 14417 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 10X Masonic Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/24/2003 12:00:00 AM | 6 | 3X3 | 5998974.44495 | 2113166.80204 | 37.78229343889421 | -122.447219282802 | (37.7822934388942, -122.447219282802) | ||
130137 | 130137 | 31035 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 300 Bennington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/23/2015 12:00:00 AM | 1 | Permit Number 771782 | 6007054.85561 | 2096718.7774900002 | 37.7375893700518 | -122.41809814921899 | (37.7375893700518, -122.418098149219) | ||
108103 | 108103 | 108519 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1241 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773665 | 5994833.54334 | 2107094.83383 | 37.7653839436153 | -122.461104605949 | (37.7653839436153, -122.461104605949) |
114715 | 114715 | 108516 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 695-699X 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773792 | 5993787.87218 | 2111075.28381 | 37.776252973902395 | -122.46501042751899 | (37.7762529739024, -122.465010427519) |
21003 | 21003 | 4174 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 3809 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/22/2014 12:00:00 AM | 3 | 3x3 | 6005074.45285 | 2100459.68403 | 37.7477493826385 | -122.425211462866 | (37.7477493826385, -122.425211462866) | ||
144238 | 144238 | 55930 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1680 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2009 12:00:00 AM | 3x3 | Permit Number 53115 | 5992813.78045219 | 2104035.7193509997 | 37.7568679811889 | -122.46786791882201 | (37.7568679811889, -122.467867918822) | ||
77776 | 77776 | 39397 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1690 Church St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.74384312179429 | -122.42677419677099 | (37.7438431217943, -122.426774196771) | |||
101250 | 101250 | 39393 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1690 Church St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.74384312179429 | -122.42677419677099 | (37.7438431217943, -122.426774196771) | |||
102418 | 102418 | 39405 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1690 Church St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.74384312179429 | -122.42677419677099 | (37.7438431217943, -122.426774196771) | |||
108002 | 108002 | 39398 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1690 Church St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.74384312179429 | -122.42677419677099 | (37.7438431217943, -122.426774196771) | |||
108254 | 108254 | 39395 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1690 Church St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.74384312179429 | -122.42677419677099 | (37.7438431217943, -122.426774196771) | |||
114255 | 114255 | 39394 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1690 Church St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.74384312179429 | -122.42677419677099 | (37.7438431217943, -122.426774196771) | |||
115304 | 115304 | 39400 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1690 Church St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.74384312179429 | -122.42677419677099 | (37.7438431217943, -122.426774196771) | |||
115336 | 115336 | 39402 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1690 Church St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.74384312179429 | -122.42677419677099 | (37.7438431217943, -122.426774196771) | |||
116459 | 116459 | 39390 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1690 Church St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.74384312179429 | -122.42677419677099 | (37.7438431217943, -122.426774196771) | |||
118564 | 118564 | 39389 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1690 Church St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.74384312179429 | -122.42677419677099 | (37.7438431217943, -122.426774196771) | |||
119878 | 119878 | 39392 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1690 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.74384312179429 | -122.42677419677099 | (37.7438431217943, -122.426774196771) | |||
122822 | 122822 | 39399 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1690 Church St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.74384312179429 | -122.42677419677099 | (37.7438431217943, -122.426774196771) | |||
123381 | 123381 | 39391 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1690 Church St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.74384312179429 | -122.42677419677099 | (37.7438431217943, -122.426774196771) | |||
124091 | 124091 | 39401 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1690 Church St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.74384312179429 | -122.42677419677099 | (37.7438431217943, -122.426774196771) | |||
140732 | 140732 | 39403 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1690 Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.74384312179429 | -122.42677419677099 | (37.7438431217943, -122.426774196771) | |||
142545 | 142545 | 39404 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1690 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.74384312179429 | -122.42677419677099 | (37.7438431217943, -122.426774196771) | |||
144232 | 144232 | 39396 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1690 Church St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.74384312179429 | -122.42677419677099 | (37.7438431217943, -122.426774196771) | |||
4705 | 4705 | 226129 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 468 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2016 12:00:00 AM | 9 | Width 3ft | 6002897.69632 | 2099218.5981799997 | 37.7442184383445 | -122.432649927259 | (37.7442184383445, -122.432649927259) | ||
95326 | 95326 | 64270 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1649 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/2012 12:00:00 AM | Permit Number 769488 | 6009729.21200973 | 2100183.41630946 | 37.747252676130294 | -122.40909598815901 | (37.7472526761303, -122.409095988159) | ||
14355 | 14355 | 39267 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 540 Delancey St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40880 | 6015247.62996 | 2113604.7135400004 | 37.7844122333873 | -122.39095143518499 | (37.7844122333873, -122.390951435185) |
14892 | 14892 | 39268 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 540 Delancey St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40880 | 6015240.80145 | 2113614.1392900003 | 37.7844377354544 | -122.39097571867501 | (37.7844377354544, -122.390975718675) |
129967 | 129967 | 44131 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2820 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/2000 12:00:00 AM | 4 | Permit Number 43633 | 6005248.14777 | 2119695.60909 | 37.8005763744637 | -122.425979944327 | (37.8005763744637, -122.425979944327) | ||
20497 | 20497 | 5491 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 730 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/17/2007 12:00:00 AM | 3 | 3X3 | 6004960.448369999 | 2104097.58597 | 37.7577317737189 | -122.425864595473 | (37.7577317737189, -122.425864595473) | ||
1174 | 1174 | 5198 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 635 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2001 12:00:00 AM | 3 | 3x3 | 6001582.4984 | 2110645.9942 | 37.775520613317 | -122.43801597154 | (37.775520613317, -122.43801597154) | ||
113930 | 113930 | 67806 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 867 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | Permit Number 31457 | 6000839.18474715 | 2101975.25274037 | 37.751670596488 | -122.439965416077 | (37.751670596488, -122.439965416077) | ||
162300 | 162300 | 57739 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1430 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/1992 12:00:00 AM | 1 | Permit Number 31420 | 6009340.15372 | 2118176.38357 | 37.7966353671694 | -122.41171247616501 | (37.7966353671694, -122.411712476165) | ||
145091 | 145091 | 61749 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3849 26TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/1984 12:00:00 AM | 12 | 3x3 | Permit Number 21755 | 6004830.1 | 2100717.5 | 37.74844347847171 | -122.426074773634 | (37.7484434784717, -122.426074773634) | |
27999 | 27999 | 53556 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 155 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1969 12:00:00 AM | 5 | Permit Number 6468 | 5990822.61349 | 2114386.11588 | 37.7851721782666 | -122.47550976424 | (37.7851721782666, -122.47550976424) | ||
123213 | 123213 | 52406 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 51 Virginia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/2005 12:00:00 AM | Permit Number 48525 | 6006289.36692321 | 2098690.46221528 | 37.742960059729704 | -122.420884755481 | (37.7429600597297, -122.420884755481) | ||
102678 | 102678 | 16534 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1420X Evans Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2004 12:00:00 AM | 3 | 3X3 | 6016649.3386754 | 2097853.1412174 | 37.741239457182104 | -122.38500415558701 | (37.7412394571821, -122.385004155587) | ||
66763 | 66763 | 59558 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 214 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/1992 12:00:00 AM | 8 | Permit Number 31386 | 6004840.03316 | 2093769.64251 | 37.7293667957293 | -122.42554602055 | (37.7293667957293, -122.42554602055) | ||
128052 | 128052 | 55609 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 142 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/1972 12:00:00 AM | 1 | Permit Number 11586 | 5992448.32925563 | 2114520.13069232 | 37.7856342525233 | -122.469895103767 | (37.7856342525233, -122.469895103767) | ||
121261 | 121261 | 92855 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1101 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2009 12:00:00 AM | Permit Number 53074 | 6001966.0 | 2100891.0 | 37.748757577125204 | -122.435991171851 | (37.7487575771252, -122.435991171851) | |||
20217 | 20217 | 24370 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 170 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2007 12:00:00 AM | 3 | 3X3 | 6005596.0231800005 | 2108503.96371 | 37.7698665410346 | -122.423979852088 | (37.7698665410346, -122.423979852088) | ||
35761 | 35761 | 46083 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 678 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2001 12:00:00 AM | 1 | Permit Number 44461 | 6009646.5972 | 2120203.7861 | 37.8022193006044 | -122.4107953652 | (37.8022193006044, -122.4107953652) | ||
84677 | 84677 | 52343 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 9 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2005 12:00:00 AM | Permit Number 48487 | 5993020.12336705 | 2099071.55255043 | 37.7432495660688 | -122.46679346106899 | (37.7432495660688, -122.466793461069) | |||
145348 | 145348 | 71800 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2169 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2008 12:00:00 AM | 3x3 | Permit Number 51966 | 5997498.69727055 | 2109850.09270913 | 37.7731021869441 | -122.45208531215 | (37.7731021869441, -122.45208531215) | ||
171910 | 171910 | 81988 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 442 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2007 12:00:00 AM | 3 | 3x3 | Permit Number 50000 | 5982237.66367 | 2112787.1570200003 | 37.780280511552206 | -122.505091982727 | (37.7802805115522, -122.505091982727) | |
102503 | 102503 | 23631 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 57 Virginia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/11/2003 12:00:00 AM | 3 | 3X3 | 6006306.857782 | 2098679.9716835 | 37.7429322409736 | -122.420823532183 | (37.7429322409736, -122.420823532183) | ||
82562 | 82562 | 33757 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 16 Henry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/1996 12:00:00 AM | Permit Number 37810 | 6003402.50922955 | 2107448.70310464 | 37.766844969098 | -122.431491817447 | (37.766844969098, -122.431491817447) | |||
115684 | 115684 | 66772 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2 Pearl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/10/1994 12:00:00 AM | Permit Number 30031 | 6005583.60582108 | 2109041.70693845 | 37.771342353738 | -122.424061050426 | (37.771342353738, -122.424061050426) | ||
168993 | 168993 | 31450 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 515 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53997 | 6001863.73934 | 2102822.19649 | 37.754054372127 | -122.436482991608 | (37.754054372127, -122.436482991608) |
97671 | 97671 | 28491 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1444 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/09/2003 12:00:00 AM | 8 | 3X3 | 6005199.4144851 | 2099918.5431919997 | 37.7462705927584 | -122.424740860946 | (37.7462705927584, -122.424740860946) | ||
109366 | 109366 | 12852 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2425 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/2001 12:00:00 AM | 6 | 3X3 | 5987893.29403 | 2114620.09876 | 37.785644384199 | -122.48566135129101 | (37.785644384199, -122.485661351291) | ||
92958 | 92958 | 58586 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 126 Grattan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/1993 12:00:00 AM | 4x4 | Permit Number 32799 | 5998027.55181779 | 2106540.68640664 | 37.764045680708705 | -122.450017378701 | (37.7640456807087, -122.450017378701) | ||
21571 | 21571 | 5603 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1126 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2003 12:00:00 AM | 3 | 3x3 | 6005088.2583099995 | 2101777.30613 | 37.7513680486157 | -122.425257470357 | (37.7513680486157, -122.425257470357) | ||
171014 | 171014 | 46068 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2318 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2001 12:00:00 AM | 4 | Permit Number 44453 | 6011842.96838 | 2101888.73185 | 37.7520532897435 | -122.40190659231399 | (37.7520532897435, -122.401906592314) | ||
3464 | 3464 | 5297 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1600 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/07/1995 12:00:00 AM | 3 | 2X3 | 6001162.4866 | 2114099.2454 | 37.7849784685073 | -122.439716519057 | (37.7849784685073, -122.439716519057) | ||
77319 | 77319 | 66310 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 136 Hamerton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1990 12:00:00 AM | Permit Number 29425 | 6001332.72327258 | 2095407.42415394 | 37.7336649686266 | -122.43778834571 | (37.7336649686266, -122.43778834571) | ||
79796 | 79796 | 66312 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 143 Hamerton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1990 12:00:00 AM | Permit Number 29427 | 6001377.41574875 | 2095374.46813255 | 37.733577020231294 | -122.43763147167299 | (37.7335770202313, -122.437631471673) | ||
145975 | 145975 | 66309 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 132 Hamerton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1990 12:00:00 AM | Permit Number 29424 | 6001336.27411679 | 2095419.91678069 | 37.733699472400495 | -122.43777696386101 | (37.7336994724005, -122.437776963861) | ||
127559 | 127559 | 34868 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 448 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2007 12:00:00 AM | 3x3 | Permit Number 49951 | 6003547.62609569 | 2096418.61112327 | 37.736567154289204 | -122.43020289604601 | (37.7365671542892, -122.430202896046) | ||
2959 | 2959 | 228317 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 119 Germania St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | 3 | Width 3ft | Permit Number 37770 | 6003543.433130001 | 2108799.0519999997 | 37.7705606845675 | -122.4311007758 | (37.7705606845675, -122.4311007758) | |
88254 | 88254 | 67724 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1346 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1992 12:00:00 AM | Permit Number 31342 | 5992116.05706304 | 2106274.73338322 | 37.7629754095582 | -122.47044394314699 | (37.7629754095582, -122.470443943147) | ||
164797 | 164797 | 33661 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 483 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/1996 12:00:00 AM | 2 | Permit Number 37749 | 6005107.1966 | 2110751.602 | 37.7760104013227 | -122.425830703288 | (37.7760104013227, -122.425830703288) | |
145546 | 145546 | 52307 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 125 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/02/2005 12:00:00 AM | Permit Number 48466 | 6004248.12570039 | 2092925.52836922 | 37.7270155836301 | -122.42753218697399 | (37.7270155836301, -122.427532186974) | ||
31445 | 31445 | 50609 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 307 Spruce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2003 12:00:00 AM | 5 | Permit Number 47207 | 5997116.52559 | 2115267.78958 | 37.7879558590154 | -122.45379859043001 | (37.7879558590154, -122.45379859043) | ||
69487 | 69487 | 50610 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 307 Spruce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2003 12:00:00 AM | 5 | Permit Number 47207 | 5997118.78265 | 2115251.45908 | 37.7879111492194 | -122.45378960171699 | (37.7879111492194, -122.453789601717) | ||
68133 | 68133 | 114690 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 173 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | 1 | Permit Number 774716 | 6010597.60785 | 2093917.85298 | 37.7300973914745 | -122.405651885519 | (37.7300973914745, -122.405651885519) | ||
125910 | 125910 | 45196 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3379 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/01/2001 12:00:00 AM | Permit Number 44041 | 6005846.47654917 | 2103129.45360257 | 37.7551235392216 | -122.422731541054 | (37.7551235392216, -122.422731541054) | ||
88036 | 88036 | 12702 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1415 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/1992 12:00:00 AM | 6 | 3X3 | 5991067.52539 | 2114735.08687 | 37.7861445496005 | -122.474687932397 | (37.7861445496005, -122.474687932397) | ||
123103 | 123103 | 12708 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1448 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/1992 12:00:00 AM | 8 | 3X3 | 5990942.238 | 2114788.08158 | 37.786282797765104 | -122.475125259251 | (37.7862827977651, -122.475125259251) | ||
115228 | 115228 | 114668 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 176X Peralta Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 774564 | 6009847.7 | 2100071.6 | 37.7469522901695 | -122.408678376857 | (37.7469522901695, -122.408678376857) | |||
122126 | 122126 | 14415 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 10X Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/30/2014 11:00:00 PM | 3 | 3X3 | 5998974.44495 | 2113166.80204 | 37.78229343889421 | -122.447219282802 | (37.7822934388942, -122.447219282802) | ||
85347 | 85347 | 55483 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 541 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1972 12:00:00 AM | Permit Number 11436 | 6002127.49962023 | 2110317.53066038 | 37.774649712906 | -122.43610717427201 | (37.774649712906, -122.436107174272) | |||
183616 | 183616 | 101840 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 654 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/2012 12:00:00 AM | 1 | 3x3 | Permit Number 769499 | 6011223.03061 | 2105283.28605 | 37.761339365434395 | -122.404289339783 | (37.7613393654344, -122.404289339783) | |
124484 | 124484 | 33596 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 224 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/27/1996 12:00:00 AM | Permit Number 37704 | 6006764.88220944 | 2097872.66772056 | 37.7407413706298 | -122.41918255385299 | (37.7407413706298, -122.419182553853) | ||
144166 | 144166 | 33594 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 208 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/1996 12:00:00 AM | Permit Number 37702 | 6006803.38226824 | 2097943.62645623 | 37.7409383755984 | -122.41905446675699 | (37.7409383755984, -122.419054466757) | |||
161901 | 161901 | 65419 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 790 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/27/1989 12:00:00 AM | 7 | Permit Number 28277 | 6010596.9458 | 2116598.4716 | 37.792373224472605 | -122.407252384703 | (37.7923732244726, -122.407252384703) | |
7551 | 7551 | 108147 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3322 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2014 12:00:00 AM | 3 | Permit Number 774253 | 6003296.86852 | 2119720.45859 | 37.800534134189 | -122.43273393652399 | (37.800534134189, -122.432733936524) | ||
20155 | 20155 | 29899 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 584 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2008 12:00:00 AM | 3 | 3x3 | 6002334.75253 | 2104838.51742 | 37.7596174587106 | -122.434998311621 | (37.7596174587106, -122.434998311621) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");