Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1696 | 1696 | 108698 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2922 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774622 | 5999117.98057 | 2118844.23155 | 37.7978903639015 | -122.447131431372 | (37.7978903639015, -122.447131431372) |
| 2487 | 2487 | 33316 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1443-1443X Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | Permit Number 774619 | 6004409.7027 | 2120463.36257 | 37.8026370063559 | -122.42893607346001 | (37.8026370063559, -122.42893607346) | |
| 2731 | 2731 | 49968 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 250 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/2016 12:00:00 AM | 3 | Permit Number 773269 | 6007921.5580400005 | 2112390.20722 | 37.7806682603601 | -122.416211138647 | (37.7806682603601, -122.416211138647) | |
| 3517 | 3517 | 33317 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1443-1443X Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | Permit Number 774619 | 6004424.04227 | 2120465.37019 | 37.8026433303993 | -122.42888659453699 | (37.8026433303993, -122.428886594537) | |
| 4342 | 4342 | 53050 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1024 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767676 | 6009180.15933 | 2118047.86674 | 37.79627351507779 | -122.412257006676 | (37.7962735150778, -122.412257006676) |
| 6582 | 6582 | 58810 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3199 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | Permit Number 772746 | 6002363.40081 | 2119107.0408799998 | 37.7987968652491 | -122.435920192279 | (37.7987968652491, -122.435920192279) | |
| 8004 | 8004 | 110481 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 573 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/12/2016 12:00:00 AM | 3 | 4x4 | 6002115.7966 | 2110416.1461 | 37.7749198214087 | -122.436154715842 | (37.7749198214087, -122.436154715842) | |
| 10783 | 10783 | 109058 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 130 Newton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772785 | 6000981.190219999 | 2087817.6053 | 37.712805054485 | -122.438460096258 | (37.712805054485, -122.438460096258) |
| 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) | |
| 13449 | 13449 | 108720 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 375 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773094 | 6011766.25551 | 2106680.42507 | 37.765205936725295 | -122.40250878917 | (37.7652059367253, -122.40250878917) |
| 13892 | 13892 | 108722 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 375 Rhode Island St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773094 | 6011765.777319999 | 2106711.15345 | 37.765290283256995 | -122.402512604068 | (37.765290283257, -122.402512604068) |
| 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) |
| 14386 | 14386 | 108711 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2000-2038X 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773095 | 6011373.53842 | 2106528.5170299998 | 37.7647668994048 | -122.40385642054 | (37.7647668994048, -122.40385642054) |
| 14688 | 14688 | 108710 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2000-2038X 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773095 | 6011387.70807 | 2106529.33414 | 37.764769934605205 | -122.40380746863998 | (37.7647699346052, -122.40380746864) |
| 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) |
| 15096 | 15096 | 108712 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2000-2038X 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773095 | 6011359.92903 | 2106527.96496 | 37.7647646232249 | -122.40390345328501 | (37.7647646232249, -122.403903453285) |
| 15329 | 15329 | 83441 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 325 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 3 | 3x3 | 6014074.068940001 | 2105534.94834 | 37.7621892769404 | -122.39444634273899 | (37.7621892769404, -122.394446342739) | |
| 15446 | 15446 | 62467 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 710 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/1986 12:00:00 AM | 10 | Permit Number 22636 | 6011241.19795 | 2104960.20112 | 37.760453261625 | -122.404203766595 | (37.760453261625, -122.404203766595) | |
| 15613 | 15613 | 108721 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 375 Rhode Island St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773094 | 6011766.2386 | 2106696.76782 | 37.76525080930121 | -122.402509996945 | (37.7652508093012, -122.402509996945) |
| 16490 | 16490 | 35340 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 806 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/17/2014 12:00:00 AM | 2 | 3x9 | Permit Number 771129 | 6013025.881440001 | 2103324.95192 | 37.7560627857975 | -122.39791661515699 | (37.7560627857975, -122.397916615157) |
| 16561 | 16561 | 108719 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 479 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773098 | 6014398.610859999 | 2104906.56094 | 37.760481897828996 | -122.393279892377 | (37.760481897829, -122.393279892377) |
| 18639 | 18639 | 61241 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3970 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/1984 12:00:00 AM | Permit Number 21113 | 6003879.55901956 | 2104241.51200503 | 37.7580658175007 | -122.42961302050301 | (37.7580658175007, -122.429613020503) | ||
| 18688 | 18688 | 67850 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 485 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1993 12:00:00 AM | Permit Number 31520 | 6002735.666769001 | 2098756.82734478 | 37.742941332905396 | -122.433177202226 | (37.7429413329054, -122.433177202226) | ||
| 19494 | 19494 | 68790 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2339 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/1993 12:00:00 AM | Permit Number 32727 | 5991985.43941061 | 2099518.6478439 | 37.744417405952 | -122.470403648157 | (37.744417405952, -122.470403648157) | ||
| 19619 | 19619 | 35520 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 90 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41442 | 6005793.71652674 | 2102887.49607432 | 37.754456203079705 | -122.422896805421 | (37.7544562030797, -122.422896805421) | ||
| 19635 | 19635 | 36019 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 99 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39165 | 6006729.30953986 | 2099082.13183863 | 37.744060284741295 | -122.419391331569 | (37.7440602847413, -122.419391331569) | ||
| 20468 | 20468 | 62857 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 179 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/18/1986 12:00:00 AM | Permit Number 23225 | 6008674.53760188 | 2097751.18669018 | 37.740515170519295 | -122.412571078994 | (37.7405151705193, -122.412571078994) | ||
| 23023 | 23023 | 32465 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/2013 12:00:00 AM | 1 | 3x3 | Permit Number 769711 | 6000816.86333 | 2105689.19673 | 37.7618669122537 | -122.440308925238 | (37.7618669122537, -122.440308925238) |
| 24230 | 24230 | 31097 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 106 Baden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 7 | 3x3 | Permit Number 34828 | 6000767.82803 | 2094431.0970299998 | 37.730952063077 | -122.439671378748 | (37.730952063077, -122.439671378748) |
| 24658 | 24658 | 69418 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 156 Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 6 | Permit Number 33523 | 6001409.83218 | 2087347.5533200002 | 37.7115387685699 | -122.436944943671 | (37.7115387685699, -122.436944943671) | |
| 25358 | 25358 | 31407 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 4305 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 4 | Permit Number 34997 | 6002016.45582 | 2104087.39785 | 37.7575369877622 | -122.436045390491 | (37.7575369877622, -122.436045390491) | |
| 26133 | 26133 | 71422 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 658 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 6 | 6009722.2927 | 2120212.6608 | 37.802247912275206 | -122.41053404810499 | (37.8022479122752, -122.410534048105) | ||
| 26593 | 26593 | 31486 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 581 Eureka St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 12 | Permit Number 35050 | 6001574.757780001 | 2102471.63758 | 37.7530753962346 | -122.437457255946 | (37.7530753962346, -122.437457255946) | |
| 26851 | 26851 | 49941 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2474@ ULLOA 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/02/2003 12:00:00 AM | 1 | Permit Number 46699 | 5988007.7004 | 2098472.4797 | 37.741314111571796 | -122.48408097239401 | (37.7413141115718, -122.484080972394) | |
| 29469 | 29469 | 33117 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2699 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 4 | Permit Number 37353 | 6000101.0018 | 2118475.17057 | 37.7969331372011 | -122.443703383925 | (37.7969331372011, -122.443703383925) | |
| 30586 | 30586 | 33230 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2740 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/04/2002 12:00:00 AM | 2 | Permit Number 37416 | 6000651.12195 | 2117750.4280000003 | 37.7949745459919 | -122.441747802734 | (37.7949745459919, -122.441747802734) | |
| 30632 | 30632 | 73445 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 900 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1994 12:00:00 AM | 4 | 6007755.78016 | 2114801.18136 | 37.787278888055894 | -122.41695551739201 | (37.7872788880559, -122.416955517392) | ||
| 30917 | 30917 | 34609 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3222 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 5 | Permit Number 38294 | 5999276.61013 | 2116016.0035200003 | 37.7901338623233 | -122.44637896321899 | (37.7901338623233, -122.446378963219) | |
| 31105 | 31105 | 46360 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 514 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/24/2004 12:00:00 AM | 2 | Permit Number 44598 | 5988790.17087 | 2111781.3196900003 | 37.7779021128043 | -122.48235038480101 | (37.7779021128043, -122.482350384801) | |
| 31180 | 31180 | 35375 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 724 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 7 | Permit Number 38833 | 6010961.80116 | 2104934.52019 | 37.7603671317669 | -122.405168267915 | (37.7603671317669, -122.405168267915) | |
| 33624 | 33624 | 35590 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2808 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1998 12:00:00 AM | 6 | Permit Number 38953 | 6000039.2737 | 2114426.5269 | 37.7858131029776 | -122.44362598405701 | (37.7858131029776, -122.443625984057) | |
| 34521 | 34521 | 33116 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2699 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 4 | Permit Number 37353 | 6000083.684859999 | 2118474.07473 | 37.7969291406212 | -122.44376322569299 | (37.7969291406212, -122.443763225693) | |
| 35802 | 35802 | 71599 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 130 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 7 | 5994726.40181 | 2086320.41636 | 37.7083363538073 | -122.45997012143101 | (37.7083363538073, -122.459970121431) | ||
| 36070 | 36070 | 70557 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 20 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 1 | 6004148.34946 | 2093373.6236 | 37.7282403094269 | -122.42790902788 | (37.7282403094269, -122.42790902788) | ||
| 37727 | 37727 | 84237 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 382-384 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/04/2006 12:00:00 AM | 2 | 5988116.70798 | 2113371.1409 | 37.7822281155783 | -122.484796757861 | (37.7822281155783, -122.484796757861) | ||
| 38026 | 38026 | 68360 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 716 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 2 | Permit Number 32180 | 5990389.00128 | 2110476.58792 | 37.774412551740205 | -122.476724178706 | (37.7744125517402, -122.476724178706) | |
| 38109 | 38109 | 30714 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 111 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/2001 12:00:00 AM | 2 | Permit Number 34618 | 6005877.6805 | 2109983.4249 | 37.7739446835862 | -122.423110779148 | (37.7739446835862, -122.423110779148) | |
| 38740 | 38740 | 31479 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 329 Eureka St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 12 | Permit Number 35045 | 6001505.884980001 | 2103717.19104 | 37.75649147012629 | -122.437784632575 | (37.7564914701263, -122.437784632575) | |
| 39184 | 39184 | 71328 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 228 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 9 | 6004151.959980001 | 2089814.42795 | 37.718467747275795 | -122.427643069565 | (37.7184677472758, -122.427643069565) | ||
| 39802 | 39802 | 36959 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 27 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 18 | Permit Number 39589 | 5994225.97611 | 2115422.85475 | 37.7882154815281 | -122.463810552441 | (37.7882154815281, -122.463810552441) | |
| 39819 | 39819 | 64940 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2157 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1995 12:00:00 AM | 5 | Permit Number 25969 | 5997552.9152 | 2109862.9805 | 37.77314067902729 | -122.451898696297 | (37.7731406790273, -122.451898696297) | |
| 40054 | 40054 | 47269 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1463 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 1 | Permit Number 45210 | 5988654.8409 | 2105376.6422 | 37.7603087586576 | -122.482349152365 | (37.7603087586576, -122.482349152365) | |
| 40348 | 40348 | 68689 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 162 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | 4 | Permit Number 32599 | 5992138.9687 | 2114381.7472 | 37.7852364025335 | -122.47095530753 | (37.7852364025335, -122.47095530753) | |
| 41672 | 41672 | 81720 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 998 Indiana St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/27/2004 12:00:00 AM | 3 | 6014948.390319999 | 2104075.36829 | 37.758230150117505 | -122.39132033706001 | (37.7582301501175, -122.39132033706) | ||
| 42253 | 42253 | 80632 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 261-263 Texas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2002 12:00:00 AM | 5 | 6013772.880890001 | 2105882.21581 | 37.763126049457895 | -122.395512375704 | (37.7631260494579, -122.395512375704) | ||
| 42257 | 42257 | 64366 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 540 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1988 12:00:00 AM | 8 | Permit Number 25205 | 6010278.2434 | 2120287.8996 | 37.802485651571004 | -122.408615490868 | (37.802485651571, -122.408615490868) | |
| 42421 | 42421 | 59991 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3760 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/13/1982 12:00:00 AM | 5 | Permit Number 19475 | 5996854.5601 | 2115352.07014 | 37.7881722484941 | -122.45471103001199 | (37.7881722484941, -122.454711030012) | |
| 42616 | 42616 | 95927 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 593 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767624 | 5987807.15035 | 2111962.63313 | 37.7783427176202 | -122.48576426585 | (37.7783427176202, -122.48576426585) |
| 43358 | 43358 | 30913 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 183 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34734 | 5995612.81318116 | 2091099.78305051 | 37.7215103139917 | -122.457252110286 | (37.7215103139917, -122.457252110286) | ||
| 43608 | 43608 | 80804 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 991 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/01/2003 12:00:00 AM | 2 | 6015534.52104 | 2104634.07686 | 37.759796756532005 | -122.38933223909201 | (37.759796756532, -122.389332239092) | ||
| 43730 | 43730 | 110480 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 573 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 6002112.3456 | 2110445.7265 | 37.7750008457371 | -122.436168770849 | (37.7750008457371, -122.436168770849) | |||
| 43803 | 43803 | 34602 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3200 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 2 | Permit Number 38292 | 5999340.98118 | 2116024.12544 | 37.790159839253704 | -122.446156829774 | (37.7901598392537, -122.446156829774) | |
| 44095 | 44095 | 47442 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 635 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 1 | Permit Number 45353 | 5982550.52878 | 2111435.68847 | 37.7765881781327 | -122.50390953033998 | (37.7765881781327, -122.50390953034) | |
| 45013 | 45013 | 31990 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 166 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 6 | Permit Number 35391 | 5994616.66617 | 2114522.79819 | 37.785766676595394 | -122.46239353285499 | (37.7857666765954, -122.462393532855) | |
| 45227 | 45227 | 51261 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 483 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/2004 12:00:00 AM | 2 | Permit Number 47638 | 5991555.867459999 | 2112145.30882 | 37.779062018233 | -122.47280950933902 | (37.779062018233, -122.472809509339) | |
| 45415 | 45415 | 83806 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1401 Jones St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2006 12:00:00 AM | 2 | 4x4 | 6008439.24535 | 2117330.37578 | 37.794261859346 | -122.414769927392 | (37.794261859346, -122.414769927392) | |
| 45486 | 45486 | 40208 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 837 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | 2 | Permit Number 41390 | 5982597.67837 | 2110065.0183099997 | 37.772827489399 | -122.503644899237 | (37.772827489399, -122.503644899237) | |
| 46736 | 46736 | 59996 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 332 Spruce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/13/1982 12:00:00 AM | 8 | Permit Number 19482 | 5997170.21604 | 2115201.8626099997 | 37.7877779191499 | -122.453608069965 | (37.7877779191499, -122.453608069965) | |
| 46793 | 46793 | 78628 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 695 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/2000 12:00:00 AM | 2 | 6011848.41815 | 2105223.54822 | 37.7612102650599 | -122.402122174202 | (37.7612102650599, -122.402122174202) | ||
| 47664 | 47664 | 31712 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 144#8 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 6 | Permit Number 35212 | 5997752.60888 | 2106811.6334 | 37.764773896114 | -122.450987860098 | (37.764773896114, -122.450987860098) | |
| 48945 | 48945 | 72207 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 528 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/19/1988 12:00:00 AM | 7 | 6010331.0847 | 2120296.9733 | 37.8025135249949 | -122.40843327331001 | (37.8025135249949, -122.40843327331) | ||
| 49071 | 49071 | 71315 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 555 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 8 | 6003422.9520000005 | 2090101.24578 | 37.71921402269321 | -122.430183398047 | (37.7192140226932, -122.430183398047) | ||
| 49239 | 49239 | 30713 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 111 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/2001 12:00:00 AM | 3 | Permit Number 34618 | 6005868.3438 | 2109981.6465 | 37.77393927364079 | -122.42314294996001 | (37.7739392736408, -122.42314294996) | |
| 50980 | 50980 | 68700 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 168 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | 4 | Permit Number 32612 | 5991833.50014 | 2114340.31773 | 37.785104977135404 | -122.472009104115 | (37.7851049771354, -122.472009104115) | |
| 52642 | 52642 | 68313 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 125 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/27/1993 12:00:00 AM | 4 | Permit Number 32126 | 5990505.89446 | 2114550.40815 | 37.785604914031296 | -122.476617509135 | (37.7856049140313, -122.476617509135) | |
| 54402 | 54402 | 35350 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1274 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 1 | Permit Number 38813 | 6012220.17315 | 2102475.01339 | 37.753684135633605 | -122.400643336214 | (37.7536841356336, -122.400643336214) | |
| 54908 | 54908 | 35376 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 724 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 3 | Permit Number 38833 | 6010962.01124 | 2104944.83832 | 37.760395474785795 | -122.40516826792 | (37.7603954747858, -122.40516826792) | |
| 55464 | 55464 | 74182 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 138 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 4 | 5994679.00139 | 2086362.0842900001 | 37.7084480379267 | -122.46013695827 | (37.7084480379267, -122.46013695827) | ||
| 55839 | 55839 | 43667 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 335 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 3 | Permit Number 43310 | 5992137.1928 | 2113155.3528400003 | 37.7818689583158 | -122.470872084018 | (37.7818689583158, -122.470872084018) | |
| 55967 | 55967 | 34610 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3230 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 3 | Permit Number 38295 | 5999238.22234 | 2116011.35484 | 37.79011890571871 | -122.44651144684299 | (37.7901189057187, -122.446511446843) | |
| 56751 | 56751 | 40671 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 102 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | 1 | Permit Number 41657 | 6004099.1672 | 2093741.168 | 37.729246721852704 | -122.42810523478201 | (37.7292467218527, -122.428105234782) | |
| 57003 | 57003 | 59618 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1004 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | 2 | Permit Number 31152 | 6015486.09515 | 2104460.8215099997 | 37.759318349579395 | -122.38948762214899 | (37.7593183495794, -122.389487622149) | |
| 57449 | 57449 | 59995 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 311 Spruce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/13/1982 12:00:00 AM | 5 | Permit Number 19480 | 5997122.00089 | 2115229.93413 | 37.7878522319536 | -122.453776912276 | (37.7878522319536, -122.453776912276) | |
| 57615 | 57615 | 71689 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2133 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1995 12:00:00 AM | 2 | 5997637.9995 | 2109872.9453 | 37.773172912724206 | -122.451605099071 | (37.7731729127242, -122.451605099071) | ||
| 58013 | 58013 | 32355 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 455 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/04/2006 12:00:00 AM | 2 | Permit Number 36909 | 5988077.70341 | 2112909.74205 | 37.7809589730845 | -122.484897834483 | (37.7809589730845, -122.484897834483) | |
| 59749 | 59749 | 84260 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 660 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/04/2006 12:00:00 AM | 1 | 5988186.45102 | 2111472.04935 | 37.777017806636 | -122.484416148832 | (37.777017806636, -122.484416148832) | ||
| 59940 | 59940 | 73719 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 86 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/1985 12:00:00 AM | 2 | 6001003.515819999 | 2093592.5404599998 | 37.7286629916874 | -122.43879650116301 | (37.7286629916874, -122.438796501163) | ||
| 60922 | 60922 | 31086 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 30 Pearl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 10 | Permit Number 34822 | 6005604.87213 | 2108833.38623 | 37.770771555801204 | -122.423972672804 | (37.7707715558012, -122.423972672804) | |
| 61281 | 61281 | 68674 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 296 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | 3 | Permit Number 32582 | 5993098.485119999 | 2113599.7938 | 37.783144819263704 | -122.467578817982 | (37.7831448192637, -122.467578817982) | |
| 61502 | 61502 | 32855 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 121 Hoffman Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37205 | 6000624.61627289 | 2102511.57259046 | 37.7531309843157 | -122.440745886867 | (37.7531309843157, -122.440745886867) | ||
| 63117 | 63117 | 69043 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1411 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1994 12:00:00 AM | 5 | Permit Number 33050 | 5983994.9059 | 2105527.4427 | 37.7604506461086 | -122.498476575537 | (37.7604506461086, -122.498476575537) | |
| 63421 | 63421 | 40717 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 360 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/1999 12:00:00 AM | Permit Number 41696 | 6008594.61699406 | 2097088.56935412 | 37.7386912826447 | -122.41280058004801 | (37.7386912826447, -122.412800580048) | ||
| 65128 | 65128 | 73960 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 138 Wilson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 4 | 5994666.9696 | 2086372.6899 | 37.7084764663958 | -122.46017930913601 | (37.7084764663958, -122.460179309136) | ||
| 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) | ||
| 66343 | 66343 | 32205 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1697 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/2001 12:00:00 AM | 8 | Permit Number 35528 | 6009341.58261 | 2099615.8477 | 37.7456725350783 | -122.410396317437 | (37.7456725350783, -122.410396317437) | |
| 66453 | 66453 | 31476 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 282 Eureka St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 7 | Permit Number 35042 | 6001438.63779 | 2104181.90614 | 37.7577636411886 | -122.43805048383699 | (37.7577636411886, -122.438050483837) | |
| 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) | |
| 67723 | 67723 | 44796 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1427 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2001 12:00:00 AM | 1 | Permit Number 43890 | 5989579.5364 | 2105634.5108 | 37.7610705422286 | -122.47916996271002 | (37.7610705422286, -122.47916996271) | |
| 70606 | 70606 | 47674 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 195 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/2002 12:00:00 AM | 2 | Permit Number 45459 | 6012002.6385 | 2107570.85405 | 37.767664048296794 | -122.40175378581301 | (37.7676640482968, -122.401753785813) | |
| 70698 | 70698 | 64371 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 470 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1988 12:00:00 AM | 12 | Permit Number 25210 | 6010591.4795 | 2120329.1807 | 37.8026165373925 | -122.407534445483 | (37.8026165373925, -122.407534445483) |
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");