Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▲ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 93209 | 93209 | 65564 | Permitted Site 1 | Tree(s) :: 17 | 228 Yerba Buena Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/1990 12:00:00 AM | Permit Number 28463 | 6021524.08705829 | 2122941.38889516 | 37.8103949467147 | -122.36988228287599 | (37.8103949467147, -122.369882282876) | |||
| 90246 | 90246 | 65563 | Permitted Site 1 | Tree(s) :: 17 | 255 Yerba Buena Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/16/1990 12:00:00 AM | Permit Number 28462 | 6021766.42970205 | 2122905.90070123 | 37.8103107984086 | -122.36904110347099 | (37.8103107984086, -122.369041103471) | |||
| 143067 | 143067 | 65565 | Permitted Site 1 | Tree(s) :: 17 | 282 Yerba Buena Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/1990 12:00:00 AM | Permit Number 28464 | 6022001.13211196 | 2122805.77301993 | 37.8100487398864 | -122.368221901586 | (37.8100487398864, -122.368221901586) | |||
| 87727 | 87727 | 65566 | Permitted Site 1 | Tree(s) :: 17 | 340 Yerba Buena Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/1990 12:00:00 AM | Permit Number 28465 | 6022030.55852908 | 2122617.11164597 | 37.8095323316173 | -122.368107024455 | (37.8095323316173, -122.368107024455) | |||
| 121276 | 121276 | 66415 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/1991 12:00:00 AM | Permit Number 29546 | 6006760.29248409 | 2122608.12240598 | 37.808658736106 | -122.42095420122601 | (37.808658736106, -122.420954201226) | ||||
| 92486 | 92486 | 84934 | Permitted Site 1 | Tree(s) :: 17 | 101 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2007 12:00:00 AM | Permit Number 49345 | 6008717.0 | 2122460.0 | 37.808362130444706 | -122.41417194996001 | (37.8083621304447, -122.41417194996) | |||
| 98539 | 98539 | 84933 | Permitted Site 1 | Tree(s) :: 17 | 101 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49345 | 6008717.0 | 2122460.0 | 37.808362130444706 | -122.41417194996001 | (37.8083621304447, -122.41417194996) | ||||
| 98748 | 98748 | 84932 | Permitted Site 1 | Tree(s) :: 17 | 101 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008717.0 | 2122460.0 | 37.808362130444706 | -122.41417194996001 | (37.8083621304447, -122.41417194996) | |||||
| 113619 | 113619 | 65287 | Permitted Site 1 | Tree(s) :: 17 | 2701 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/14/1989 12:00:00 AM | Permit Number 28099 | 6008264.52815506 | 2122079.849214 | 37.8072929076287 | -122.41571092092501 | (37.8072929076287, -122.415710920925) | |||
| 145763 | 145763 | 56951 | Permitted Site 1 | Tree(s) :: 17 | 1365 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1974 12:00:00 AM | Permit Number 14203 | 6007207.06542342 | 2121825.08767513 | 37.8065338965346 | -122.41935242715 | (37.8065338965346, -122.41935242715) | |||
| 95971 | 95971 | 56029 | Permitted Site 1 | Tree(s) :: 17 | 765 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/1973 12:00:00 AM | Permit Number 12114 | 6006557.68355005 | 2121805.96639434 | 37.806444799255296 | -122.421598378173 | (37.8064447992553, -122.421598378173) | |||
| 99365 | 99365 | 66294 | Permitted Site 1 | Tree(s) :: 17 | 555 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1990 12:00:00 AM | 3x3 | Permit Number 29405 | 6008080.29465502 | 2121671.77006146 | 37.806162067511 | -122.416319580987 | (37.806162067511, -122.416319580987) | ||
| 124917 | 124917 | 104416 | Permitted Site 1 | Tree(s) :: 17 | 335 Marina Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/2013 12:00:00 AM | Permit Number 770730 | 6001759.6 | 2121793.0 | 37.806137479917 | -122.438202052281 | (37.806137479917, -122.438202052281) | |||
| 144812 | 144812 | 65888 | Permitted Site 1 | Tree(s) :: 17 | 2455 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/1990 12:00:00 AM | Permit Number 28894 | 6008809.73199714 | 2121641.71188951 | 37.8061205259521 | -122.413793104611 | (37.8061205259521, -122.413793104611) | |||
| 98912 | 98912 | 61718 | Permitted Site 1 | Tree(s) :: 17 | 2740 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1984 12:00:00 AM | Permit Number 21718 | 6006913.180537 | 2121680.17299116 | 37.8061194416425 | -122.42035917988999 | (37.8061194416425, -122.42035917989) | |||
| 1659 | 1659 | 251643 | Undocumented 2 | Tree(s) :: 17 | 2701 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6007328.0 | 2121670.0 | 37.8061148757045 | -122.418922903139 | (37.8061148757045, -122.418922903139) | |||
| 79288 | 79288 | 61413 | Permitted Site 1 | Tree(s) :: 17 | 131 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1984 12:00:00 AM | Permit Number 21338 | 6010026.27404793 | 2121590.40064059 | 37.8060478811733 | -122.409579417139 | (37.8060478811733, -122.409579417139) | |||
| 88768 | 88768 | 61630 | Permitted Site 1 | Tree(s) :: 17 | 2552 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/1987 12:00:00 AM | Permit Number 24013 | 6008386.50068862 | 2121576.76295741 | 37.805918415774705 | -122.41525317065201 | (37.8059184157747, -122.415253170652) | |||
| 104821 | 104821 | 66127 | Permitted Site 1 | Tree(s) :: 17 | 185 Marina Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1990 12:00:00 AM | Permit Number 29189 | 6002551.87129632 | 2121689.08916143 | 37.805897195949505 | -122.435452831173 | (37.8058971959495, -122.435452831173) | |||
| 102367 | 102367 | 66139 | Permitted Site 1 | Tree(s) :: 17 | 455 Marina Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1990 12:00:00 AM | Permit Number 29202 | 6000985.89994504 | 2121696.81673664 | 37.805829352726796 | -122.4408726592 | (37.8058293527268, -122.4408726592) | |||
| 119905 | 119905 | 67535 | Permitted Site 1 | Tree(s) :: 17 | 60 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/1992 12:00:00 AM | Permit Number 31074 | 6011134.98167148 | 2121448.73063522 | 37.8057209533484 | -122.405732549389 | (37.8057209533484, -122.405732549389) | |||
| 139959 | 139959 | 52658 | Permitted Site 1 | Tree(s) :: 17 | 501@ SCOTT Marina Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/2006 12:00:00 AM | Permit Number 48739 | 6000588.64966073 | 2121660.78651717 | 37.8057077911166 | -122.44224481223101 | (37.8057077911166, -122.442244812231) | |||
| 116269 | 116269 | 96365 | Undocumented 2 | Tree(s) :: 17 | 2017 Grant Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 06/07/2011 12:00:00 AM | 12 | 3x3 | Permit Number 767883 | 6010284.4 | 2121422.5 | 37.805601328212795 | -122.408674274121 | (37.8056013282128, -122.408674274121) | |
| 84835 | 84835 | 86968 | Permitted Site 1 | Tree(s) :: 17 | 3250 Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 10/27/2007 12:00:00 AM | Permit Number 49934 | 6005499.7 | 2121504.7 | 37.8055578865418 | -122.42523827370701 | (37.8055578865418, -122.425238273707) | |||
| 140517 | 140517 | 86969 | Permitted Site 1 | Tree(s) :: 17 | 3250 Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 10/27/2007 12:00:00 AM | Permit Number 49934 | 6005499.7 | 2121504.7 | 37.8055578865418 | -122.42523827370701 | (37.8055578865418, -122.425238273707) | |||
| 94869 | 94869 | 49318 | Permitted Site 1 | Tree(s) :: 17 | 595 Marina Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2003 12:00:00 AM | Permit Number 46320 | 6000116.71946789 | 2121594.09727993 | 37.805497772658704 | -122.443873196152 | (37.8054977726587, -122.443873196152) | |||
| 122203 | 122203 | 61410 | Permitted Site 1 | Tree(s) :: 17 | 2666 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/1984 12:00:00 AM | Permit Number 21334 | 6006945.26287472 | 2121452.77130571 | 37.805496862495396 | -122.42023200380301 | (37.8054968624954, -122.420232003803) | |||
| 140707 | 140707 | 61639 | Permitted Site 1 | Tree(s) :: 17 | 2653 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1984 12:00:00 AM | Permit Number 21625 | 6006898.77522094 | 2121410.25251795 | 37.8053774972256 | -122.420389861177 | (37.8053774972256, -122.420389861177) | |||
| 105172 | 105172 | 50821 | Permitted Site 1 | Tree(s) :: 17 | 240 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/2011 12:00:00 AM | 3x5 | Permit Number 56957 | 6000836.42503656 | 2121511.47248937 | 37.8053119330456 | -122.441376630841 | (37.8053119330456, -122.441376630841) | ||
| 126006 | 126006 | 50954 | Permitted Site 1 | Tree(s) :: 17 | 240 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2004 12:00:00 AM | Permit Number 47448 | 6000836.42503656 | 2121511.47248937 | 37.8053119330456 | -122.441376630841 | (37.8053119330456, -122.441376630841) | |||
| 126462 | 126462 | 56571 | Permitted Site 1 | Tree(s) :: 17 | 234 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010159.54644349 | 2121315.84330791 | 37.805301481909396 | -122.40909881886002 | (37.8053014819094, -122.40909881886) | |||||
| 115578 | 115578 | 104810 | Permitted Site 1 | Tree(s) :: 17 | 685 Marina Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | Permit Number 770974 | 5999736.8 | 2121509.8 | 37.8052446370698 | -122.445181890463 | (37.8052446370698, -122.445181890463) | ||||
| 94771 | 94771 | 62062 | Permitted Site 1 | Tree(s) :: 17 | 225 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1985 12:00:00 AM | Permit Number 22143 | 6010228.86837932 | 2121272.63837953 | 37.805186735076205 | -122.408855870259 | (37.8051867350762, -122.408855870259) | |||
| 87943 | 87943 | 65850 | Permitted Site 1 | Tree(s) :: 17 | 67 Rico Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/1990 12:00:00 AM | 9 | 3x3 | Permit Number 770220 | 6001319.42927239 | 2121416.09155385 | 37.8050775459314 | -122.439698294296 | (37.8050775459314, -122.439698294296) |
| 92633 | 92633 | 71435 | Permitted Site 1 | Tree(s) :: 17 | 408 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773571 | 6009330.98606375 | 2121202.52490029 | 37.804943887073 | -122.411958155811 | (37.804943887073, -122.411958155811) | |
| 92850 | 92850 | 60424 | Permitted Site 1 | Tree(s) :: 17 | 1554 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/1982 12:00:00 AM | Permit Number 20008 | 6002777.03134735 | 2121327.895592 | 37.8049182387297 | -122.43464778702801 | (37.8049182387297, -122.434647787028) | |||
| 114645 | 114645 | 63939 | Permitted Site 1 | Tree(s) :: 17 | 1580 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1987 12:00:00 AM | Permit Number 24669 | 6002661.34098173 | 2121312.07170737 | 37.80486822214 | -122.43504701329701 | (37.80486822214, -122.435047013297) | |||
| 91832 | 91832 | 114983 | Undocumented 2 | Tree(s) :: 17 | 178 CERVANTES BLVD | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777197 | 6001129.0 | 2121320.0 | 37.8048028635373 | -122.44035039987601 | (37.8048028635373, -122.440350399876) | |
| 80887 | 80887 | 101518 | Permitted Site 1 | Tree(s) :: 17 | 170 Pfeiffer St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2012 12:00:00 AM | 3x3 | Permit Number 769472 | 6010021.5 | 2121128.5 | 37.804779349428294 | -122.409563317566 | (37.8047793494283, -122.409563317566) | ||
| 187762 | 187762 | 101517 | Permitted Site 1 | Tree(s) :: 17 | 170 Pfeiffer St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2012 12:00:00 AM | 15 | 3x3 | Permit Number 769472 | 6010021.5 | 2121128.5 | 37.804779349428294 | -122.409563317566 | (37.8047793494283, -122.409563317566) | |
| 126241 | 126241 | 88995 | Permitted Site 1 | Tree(s) :: 17 | 5 Rico Way | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/24/2008 12:00:00 AM | 3x3 | Permit Number 51744 | 6001709.0 | 2121299.0 | 37.804778209466896 | -122.438341747927 | (37.8047782094669, -122.438341747927) | |||
| 143807 | 143807 | 104293 | Permitted Site 1 | Tree(s) :: 17 | 3665X Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/2013 12:00:00 AM | 3x3 | Permit Number 770442 | 5999151.92915 | 2121319.46506 | 37.8046886279394 | -122.44719219431002 | (37.8046886279394, -122.44719219431) | ||
| 78282 | 78282 | 64008 | Permitted Site 1 | Tree(s) :: 17 | 111 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/1987 12:00:00 AM | Permit Number 24756 | 6011241.81470832 | 2121063.93162535 | 37.8046703636508 | -122.405335720448 | (37.8046703636508, -122.405335720448) | |||
| 105366 | 105366 | 96376 | Permitted Site 1 | Tree(s) :: 17 | 158 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/29/2011 12:00:00 AM | 6x3 | Permit Number 768038 | 6001209.7 | 2121263.4 | 37.8046520495219 | -122.440067068703 | (37.8046520495219, -122.440067068703) | ||
| 117265 | 117265 | 93579 | Permitted Site 1 | Tree(s) :: 17 | 2155 Powell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53401 | 6009385.0 | 2121027.0 | 37.804464969780604 | -122.41175882363399 | (37.8044649697806, -122.411758823634) | |
| 104640 | 104640 | 63947 | Permitted Site 1 | Tree(s) :: 17 | 1690 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1987 12:00:00 AM | Permit Number 24678 | 6002067.98740153 | 2121166.63228799 | 37.804435174751795 | -122.437089954262 | (37.8044351747518, -122.437089954262) | |||
| 78796 | 78796 | 63794 | Permitted Site 1 | Tree(s) :: 17 | 199 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/1987 12:00:00 AM | Permit Number 24481 | 6010854.95421641 | 2120980.25536358 | 37.804418972449 | -122.406668595369 | (37.804418972449, -122.406668595369) | |||
| 106460 | 106460 | 62152 | Permitted Site 1 | Tree(s) :: 17 | 2027 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/04/1985 12:00:00 AM | Permit Number 22266 | 5999521.42662743 | 2121169.12209771 | 37.804296932098296 | -122.445902696817 | (37.8042969320983, -122.445902696817) | |||
| 93666 | 93666 | 87151 | Permitted Site 1 | Tree(s) :: 17 | 4 Bellair Pl | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6010093.0 | 2120950.0 | 37.8042932388788 | -122.409303278994 | (37.8042932388788, -122.409303278994) | ||||
| 104126 | 104126 | 87153 | Permitted Site 1 | Tree(s) :: 17 | 4 Bellair Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2008 12:00:00 AM | 3x3 | Permit Number 50135 | 6010093.0 | 2120950.0 | 37.8042932388788 | -122.409303278994 | (37.8042932388788, -122.409303278994) | ||
| 106839 | 106839 | 87152 | Permitted Site 1 | Tree(s) :: 17 | 4 Bellair Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2008 12:00:00 AM | 3x3 | Permit Number 50135 | 6010093.0 | 2120950.0 | 37.8042932388788 | -122.409303278994 | (37.8042932388788, -122.409303278994) | ||
| 77813 | 77813 | 121321 | Undocumented 2 | Tree(s) :: 17 | 3699X Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003556.0 | 2121083.0 | 37.8042900105203 | -122.431934584375 | (37.8042900105203, -122.431934584375) | ||||
| 83128 | 83128 | 121324 | Undocumented 2 | Tree(s) :: 17 | 3699X Laguna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003556.0 | 2121083.0 | 37.8042900105203 | -122.431934584375 | (37.8042900105203, -122.431934584375) | ||||
| 87246 | 87246 | 121322 | Undocumented 2 | Tree(s) :: 17 | 3699X Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003556.0 | 2121083.0 | 37.8042900105203 | -122.431934584375 | (37.8042900105203, -122.431934584375) | ||||
| 123595 | 123595 | 121323 | Undocumented 2 | Tree(s) :: 17 | 3699X Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003556.0 | 2121083.0 | 37.8042900105203 | -122.431934584375 | (37.8042900105203, -122.431934584375) | ||||
| 78344 | 78344 | 92732 | Permitted Site 1 | Tree(s) :: 17 | 220 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2009 12:00:00 AM | 3x3 | Permit Number 52963 | 6011190.0 | 2120909.7 | 37.8042439844534 | -122.405504162253 | (37.8042439844534, -122.405504162253) | ||
| 87964 | 87964 | 92735 | Permitted Site 1 | Tree(s) :: 17 | 220 Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2009 12:00:00 AM | 3x3 | Permit Number 52963 | 6011190.0 | 2120909.7 | 37.8042439844534 | -122.405504162253 | (37.8042439844534, -122.405504162253) | ||
| 91323 | 91323 | 92736 | Permitted Site 1 | Tree(s) :: 17 | 220 Lombard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2009 12:00:00 AM | 3x3 | Permit Number 52963 | 6011190.0 | 2120909.7 | 37.8042439844534 | -122.405504162253 | (37.8042439844534, -122.405504162253) | ||
| 102927 | 102927 | 98587 | Permitted Site 1 | Tree(s) :: 17 | 200 Lombard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/29/2012 12:00:00 AM | Permit Number 768509 | 6011190.0 | 2120909.7 | 37.8042439844534 | -122.405504162253 | (37.8042439844534, -122.405504162253) | |||
| 119569 | 119569 | 92733 | Permitted Site 1 | Tree(s) :: 17 | 220 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2009 12:00:00 AM | 3x3 | Permit Number 52963 | 6011190.0 | 2120909.7 | 37.8042439844534 | -122.405504162253 | (37.8042439844534, -122.405504162253) | ||
| 143743 | 143743 | 92734 | Permitted Site 1 | Tree(s) :: 17 | 220 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2009 12:00:00 AM | 3x3 | Permit Number 52963 | 6011190.0 | 2120909.7 | 37.8042439844534 | -122.405504162253 | (37.8042439844534, -122.405504162253) | ||
| 144676 | 144676 | 122851 | Undocumented 2 | Tree(s) :: 17 | 742 Francisco St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6007760.0 | 2120975.0 | 37.8042308974981 | -122.417378607523 | (37.8042308974981, -122.417378607523) | ||||
| 53791 | 53791 | 106712 | Permitted Site 1 | Tree(s) :: 17 | 3713 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/28/2014 12:00:00 AM | 3x3 | Permit Number 772877 | 6000611.0 | 2121098.3 | 37.804164627793 | -122.44212706394899 | (37.804164627793, -122.442127063949) | ||
| 126404 | 126404 | 62423 | Permitted Site 1 | Tree(s) :: 17 | 98 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/1985 12:00:00 AM | Permit Number 22580 | 6001470.60482532 | 2121060.78917044 | 37.80411058360271 | -122.43914965364901 | (37.8041105836027, -122.439149653649) | |||
| 9856 | 9856 | 124741 | Undocumented 2 | Tree(s) :: 17 | 1735 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779309 | 6001858.0 | 2121050.0 | 37.804102995233606 | -122.43780827401001 | (37.8041029952336, -122.43780827401) | |
| 113078 | 113078 | 58344 | Permitted Site 1 | Tree(s) :: 17 | 876 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/1978 12:00:00 AM | Permit Number 17369 | 6007146.97201877 | 2120912.72816987 | 37.8040254050262 | -122.419495622457 | (37.8040254050262, -122.419495622457) | |||
| 120250 | 120250 | 66136 | Permitted Site 1 | Tree(s) :: 17 | 3650 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1990 12:00:00 AM | Permit Number 29199 | 5999699.53351647 | 2121049.79254492 | 37.8039794535991 | -122.445277760857 | (37.8039794535991, -122.445277760857) | |||
| 92240 | 92240 | 28968 | DPW Maintained 3 | Tree(s) :: 17 | 2455 Hyde St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6006975.507678599 | 2120876.6023828997 | 37.8039165535698 | -122.420086422377 | (37.8039165535698, -122.420086422377) | ||||||
| 113191 | 113191 | 101358 | Permitted Site 1 | Tree(s) :: 17 | 2201X Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2016 12:00:00 AM | 3 | 5x5 | Permit Number 769392 | 6008936.1 | 2120783.7 | 37.803771736238 | -122.41329507143601 | (37.803771736238, -122.413295071436) | |
| 78405 | 78405 | 40101 | Permitted Site 1 | Tree(s) :: 17 | 1940 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 41326 | 6009956.80858576 | 2120754.29790906 | 37.80374825830479 | -122.40976076012501 | (37.8037482583048, -122.409760760125) | ||||
| 144126 | 144126 | 63620 | Permitted Site 1 | Tree(s) :: 17 | 800 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1987 12:00:00 AM | Permit Number 24262 | 6007490.4861989 | 2120798.53519393 | 37.8037312025077 | -122.418298763986 | (37.8037312025077, -122.418298763986) | |||
| 102474 | 102474 | 55780 | Permitted Site 1 | Tree(s) :: 17 | 2144 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/1973 12:00:00 AM | Permit Number 11820 | 6000057.2433755 | 2120948.7784784 | 37.8037225082525 | -122.44403262379801 | (37.8037225082525, -122.444032623798) | |||
| 105663 | 105663 | 63768 | Permitted Site 1 | Tree(s) :: 17 | 290 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/1987 12:00:00 AM | Permit Number 24447 | 6010878.35626765 | 2120720.07929167 | 37.803705902329796 | -122.40656926482299 | (37.8037059023298, -122.406569264823) | |||
| 97249 | 97249 | 114184 | Significant Tree 6 | Tree(s) :: 17 | 2454 HYDE ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 01/07/2016 12:00:00 AM | 30x30 | Permit Number 776893 | 6007060.0 | 2120781.0 | 37.8036588138585 | -122.41978724303999 | (37.8036588138585, -122.41978724304) | ||
| 81063 | 81063 | 66021 | Permitted Site 1 | Tree(s) :: 17 | 3574 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/1990 12:00:00 AM | Permit Number 29056 | 6001209.73992765 | 2120899.08941713 | 37.803651752042896 | -122.440040791569 | (37.8036517520429, -122.440040791569) | |||
| 101491 | 101491 | 57849 | Permitted Site 1 | Tree(s) :: 17 | 264 Mallorca Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/1990 12:00:00 AM | Permit Number 29054 | 6001448.85521526 | 2120882.35482124 | 37.80361941271121 | -122.439212122633 | (37.8036194127112, -122.439212122633) | |||
| 2830 | 2830 | 86908 | Permitted Site 1 | Tree(s) :: 17 | 65 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780355 | 6001653.18429 | 2120872.6628099997 | 37.80360442595129 | -122.43850433841601 | (37.8036044259513, -122.438504338416) | |
| 76172 | 76172 | 93725 | Permitted Site 1 | Tree(s) :: 17 | 2050 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2010 12:00:00 AM | 3x3 | Permit Number 53314 | 6009477.0 | 2120679.0 | 37.8035146090917 | -122.411415847958 | (37.8035146090917, -122.411415847958) | ||
| 106632 | 106632 | 93726 | Permitted Site 1 | Tree(s) :: 17 | 2050 Powell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2010 12:00:00 AM | 3x3 | Permit Number 53314 | 6009477.0 | 2120679.0 | 37.8035146090917 | -122.411415847958 | (37.8035146090917, -122.411415847958) | ||
| 95033 | 95033 | 106942 | Significant Tree 6 | Tree(s) :: 17 | 1300@ Embarcadero Battery St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/02/2014 12:00:00 AM | Permit Number 772680 | 6012231.9986 | 2120618.97397 | 37.8035039293343 | -122.40187777389099 | (37.8035039293343, -122.401877773891) | |||
| 80974 | 80974 | 52855 | Permitted Site 1 | Tree(s) :: 17 | 3560CAPRA WAY Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | Permit Number 48864 | 6001218.21588434 | 2120838.32312827 | 37.8034853865059 | -122.440007100367 | (37.8034853865059, -122.440007100367) | |||
| 93048 | 93048 | 64274 | Permitted Site 1 | Tree(s) :: 17 | 1916 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1988 12:00:00 AM | Permit Number 25078 | 6009971.60434107 | 2120647.29275281 | 37.8034552778135 | -122.40970200099 | (37.8034552778135, -122.40970200099) | |||
| 86520 | 86520 | 58317 | Permitted Site 1 | Tree(s) :: 17 | 1914 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1982 12:00:00 AM | Permit Number 19536 | 6009972.82091536 | 2120638.49315762 | 37.8034311844802 | -122.40969716948601 | (37.8034311844802, -122.409697169486) | |||
| 121535 | 121535 | 68835 | Permitted Site 1 | Tree(s) :: 17 | 2270 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/2011 12:00:00 AM | Permit Number 767177 | 5999361.06837518 | 2120851.91110281 | 37.8034167987103 | -122.446434792903 | (37.8034167987103, -122.446434792903) | |||
| 101838 | 101838 | 66025 | Permitted Site 1 | Tree(s) :: 17 | 3554 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/1990 12:00:00 AM | Permit Number 29061 | 6001221.84844011 | 2120812.28041218 | 37.8034140869284 | -122.439992661315 | (37.8034140869284, -122.439992661315) | |||
| 3702 | 3702 | 143025 | Permitted Site 1 | Tree(s) :: 17 | 2147 MASON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/2008 12:00:00 AM | 4 | Width 0ft | Permit Number 51763 | 6008956.6469 | 2120652.8991 | 37.803413743220794 | -122.413214712493 | (37.8034137432208, -122.413214712493) | |
| 61257 | 61257 | 134809 | Undocumented 2 | Tree(s) :: 17 | 2430 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | Permit Number 778843 | 6007053.11654 | 2120656.70313 | 37.8033171384475 | -122.41980223860399 | (37.8033171384475, -122.419802238604) | ||
| 96251 | 96251 | 107399 | Significant Tree 6 | Tree(s) :: 17 | 1300X Sansome St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/02/2014 12:00:00 AM | 3 | Permit Number 772689 | 6012222.0 | 2120529.0 | 37.8032563246841 | -122.40190604611401 | (37.8032563246841, -122.401906046114) | ||
| 87244 | 87244 | 36193 | Permitted Site 1 | Tree(s) :: 17 | 150 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 39259 | 6012022.89460249 | 2120526.4557937 | 37.8032382250246 | -122.402594881782 | (37.8032382250246, -122.402594881782) | ||||
| 95180 | 95180 | 36192 | Permitted Site 1 | Tree(s) :: 17 | 150 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 39259 | 6012022.89460249 | 2120526.4557937 | 37.8032382250246 | -122.402594881782 | (37.8032382250246, -122.402594881782) | ||||
| 92728 | 92728 | 59920 | Permitted Site 1 | Tree(s) :: 17 | 1757 Grant Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/1981 12:00:00 AM | Permit Number 19390 | 6010408.855593 | 2120529.5255822 | 37.803156411107295 | -122.40818055703899 | (37.8031564111073, -122.408180557039) | |||
| 84714 | 84714 | 92484 | Permitted Site 1 | Tree(s) :: 17 | 155 Greenwich St | 15 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015.0 | 2120477.0 | 37.803101990704896 | -122.402618721555 | (37.8031019907049, -122.402618721555) | ||
| 85249 | 85249 | 92475 | Permitted Site 1 | Tree(s) :: 17 | 155 Greenwich St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015.0 | 2120477.0 | 37.803101990704896 | -122.402618721555 | (37.8031019907049, -122.402618721555) | ||
| 85668 | 85668 | 92476 | Permitted Site 1 | Tree(s) :: 17 | 155 Greenwich St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015.0 | 2120477.0 | 37.803101990704896 | -122.402618721555 | (37.8031019907049, -122.402618721555) | ||
| 88491 | 88491 | 92474 | Permitted Site 1 | Tree(s) :: 17 | 155 Greenwich St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015.0 | 2120477.0 | 37.803101990704896 | -122.402618721555 | (37.8031019907049, -122.402618721555) | ||
| 91344 | 91344 | 87564 | Permitted Site 1 | Tree(s) :: 17 | 155 Greenwich St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015.0 | 2120477.0 | 37.803101990704896 | -122.402618721555 | (37.8031019907049, -122.402618721555) | ||
| 104140 | 104140 | 92480 | Permitted Site 1 | Tree(s) :: 17 | 155 Greenwich St | 10 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015.0 | 2120477.0 | 37.803101990704896 | -122.402618721555 | (37.8031019907049, -122.402618721555) | ||
| 113154 | 113154 | 87562 | Permitted Site 1 | Tree(s) :: 17 | 155 Greenwich St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015.0 | 2120477.0 | 37.803101990704896 | -122.402618721555 | (37.8031019907049, -122.402618721555) | ||
| 128270 | 128270 | 92481 | Permitted Site 1 | Tree(s) :: 17 | 155 Greenwich St | 12 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015.0 | 2120477.0 | 37.803101990704896 | -122.402618721555 | (37.8031019907049, -122.402618721555) | ||
| 140175 | 140175 | 87563 | Permitted Site 1 | Tree(s) :: 17 | 155 Greenwich St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015.0 | 2120477.0 | 37.803101990704896 | -122.402618721555 | (37.8031019907049, -122.402618721555) |
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");