Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▲ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 183566 | 183566 | 51934 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 329 Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2005 12:00:00 AM | 3 | Permit Number 48161 | 6009143.0719 | 2121468.7430000002 | 37.8056643107542 | -122.41262728712401 | (37.8056643107542, -122.412627287124) | ||
| 55411 | 55411 | 51933 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 329 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2005 12:00:00 AM | 3 | Permit Number 48161 | 6009122.9755 | 2121466.1666 | 37.805656108704206 | -122.41269665162201 | (37.8056561087042, -122.412696651622) | ||
| 146738 | 146738 | 142680 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2351 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008850.2243 | 2121359.3231 | 37.8053474312043 | -122.413632988017 | (37.8053474312043, -122.413632988017) | |||
| 132006 | 132006 | 142637 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 18 VANDEWATER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6009182.7493 | 2121339.4049 | 37.805311407498706 | -122.412480829032 | (37.8053114074987, -122.412480829032) | |||
| 176455 | 176455 | 142739 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 18 VANDEWATER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6009159.5612 | 2121336.3132 | 37.8053016171389 | -122.41256085603001 | (37.8053016171389, -122.41256085603) | |||
| 67716 | 67716 | 92641 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 7 Vandewater St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/02/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52933 | 6009274.4711 | 2121331.1603 | 37.8052939168226 | -122.412162829753 | (37.8052939168226, -122.412162829753) | |
| 169314 | 169314 | 142740 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 20 VANDEWATER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6009137.9189 | 2121333.2215 | 37.8052919134811 | -122.41263553354901 | (37.8052919134811, -122.412635533549) | |||
| 132684 | 132684 | 142737 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 7 VANDEWATER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6009252.3136 | 2121328.0685 | 37.8052841842332 | -122.412239290232 | (37.8052841842332, -122.412239290232) | |||
| 183113 | 183113 | 92639 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 7 Vandewater St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/02/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52933 | 6009235.308999999 | 2121324.4615 | 37.8052733261346 | -122.41229788192499 | (37.8052733261346, -122.412297881925) | |
| 136060 | 136060 | 71433 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 270 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 11 | 6010029.1823 | 2121294.154 | 37.805234624598704 | -122.40954843082199 | (37.8052346245987, -122.409548430822) | ||
| 184085 | 184085 | 142681 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2345 MASON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008860.4852 | 2121282.3664 | 37.8051367036076 | -122.413592032358 | (37.8051367036076, -122.413592032358) | |||
| 135216 | 135216 | 142682 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2345 MASON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008863.3354 | 2121265.835 | 37.805091472577 | -122.41358099891899 | (37.805091472577, -122.413580998919) | |||
| 173779 | 173779 | 142683 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2345 MASON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008865.6156 | 2121248.1634 | 37.8050430788359 | -122.413571857358 | (37.8050430788359, -122.413571857358) | |||
| 178478 | 178478 | 142647 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 372 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6009533.6626 | 2121225.5256 | 37.805018410116894 | -122.411258394201 | (37.8050184101169, -122.411258394201) | |||
| 62910 | 62910 | 142648 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 372 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6009518.7191 | 2121223.4644 | 37.805011912482705 | -122.41130996239599 | (37.8050119124827, -122.411309962396) | |||
| 56232 | 56232 | 142684 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2335 MASON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008867.3258 | 2121225.3614 | 37.8049805662968 | -122.413564325286 | (37.8049805662968, -122.413564325286) | |||
| 62975 | 62975 | 142685 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2335 MASON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6008872.4562 | 2121205.4097 | 37.8049260720114 | -122.413545158922 | (37.8049260720114, -122.413545158922) | |||
| 32777 | 32777 | 142686 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2335 MASON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008875.3065 | 2121182.0377 | 37.8048620584091 | -122.41353364109301 | (37.8048620584091, -122.413533641093) | |||
| 84427 | 84427 | 92640 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 7 Vandewater St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/02/2009 12:00:00 AM | 3x3 | Permit Number 52933 | 6009355.0 | 2121160.0 | 37.8048284715711 | -122.41187204576201 | (37.8048284715711, -122.411872045762) | ||
| 33631 | 33631 | 142971 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 501 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6008854.3582 | 2121089.2284 | 37.804606051082104 | -122.41359956692 | (37.8046060510821, -122.41359956692) | |||
| 164183 | 164183 | 33100 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2257 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 6 | Permit Number 37340 | 6008897.7476 | 2121071.8248 | 37.8045607014693 | -122.41344818166901 | (37.8045607014693, -122.413448181669) | |
| 177501 | 177501 | 33099 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2257 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 7 | Permit Number 37340 | 6008900.8507 | 2121053.982 | 37.8045118838444 | -122.413436180416 | (37.8045118838444, -122.413436180416) | |
| 180395 | 180395 | 64429 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2552 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/1988 12:00:00 AM | 6 | Permit Number 25281 | 6006994.6099 | 2121088.36171 | 37.8044990670436 | -122.420035354544 | (37.8044990670436, -122.420035354544) | ||
| 5389 | 5389 | 27381 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2540 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 6006997.70161 | 2121072.6946 | 37.8044562233376 | -122.42002354287901 | (37.8044562233376, -122.420023542879) | |||
| 6089 | 6089 | 11017 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2540 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6007000.76456 | 2121055.6377 | 37.8044095620003 | -122.420011732067 | (37.8044095620003, -122.420011732067) | |||
| 144153 | 144153 | 33098 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2255 Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37340 | 6008896.26792228 | 2121013.91069891 | 37.8044016007834 | -122.41344920391701 | (37.8044016007834, -122.413449203917) | ||
| 126322 | 126322 | 47781 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2230 Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2002 12:00:00 AM | 3 | 3x3 | Permit Number 45556 | 6008946.6214 | 2120995.0232 | 37.8043525675445 | -122.41327361431802 | (37.8043525675445, -122.413273614318) | |
| 6239 | 6239 | 11016 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2540 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 2X3 | 6007002.01732 | 2121033.5199 | 37.804348902732 | -122.42000582623301 | (37.804348902732, -122.420005826233) | |||
| 63278 | 63278 | 47780 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2230 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2002 12:00:00 AM | 5 | 3x3 | Permit Number 45556 | 6008949.7245 | 2120970.9742 | 37.8042867092291 | -122.41326117407101 | (37.8042867092291, -122.413261174071) | |
| 152420 | 152420 | 47782 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2230 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2002 12:00:00 AM | 4 | 3x3 | Permit Number 45556 | 6008954.3791 | 2120943.8221 | 37.80421241767979 | -122.413243145173 | (37.8042124176798, -122.413243145173) | |
| 179468 | 179468 | 136153 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 774 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 6007588.93066 | 2120962.1003799997 | 37.804185852054296 | -122.417969692741 | (37.8041858520543, -122.417969692741) | |||
| 31882 | 31882 | 136154 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 774 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6007574.81731 | 2120960.13461 | 37.8041796602339 | -122.41801839373699 | (37.8041796602339, -122.418018393737) | |||
| 24327 | 24327 | 136155 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 774 Francisco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6007553.7315 | 2120957.34522 | 37.8041708145069 | -122.418091165079 | (37.8041708145069, -122.418091165079) | |||
| 63533 | 63533 | 136156 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 774 Francisco St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6007537.99806 | 2120955.25152 | 37.8041641801856 | -122.41814546343599 | (37.8041641801856, -122.418145463436) | |||
| 58114 | 58114 | 136157 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 774 Francisco St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6007521.76946 | 2120952.68455 | 37.8041562184887 | -122.41820144174999 | (37.8041562184887, -122.41820144175) | |||
| 68808 | 68808 | 142572 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2251 MASON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6008918.4067 | 2120916.3917 | 37.8041350810562 | -122.413365689825 | (37.8041350810562, -122.413365689825) | |||
| 51506 | 51506 | 142573 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2251 MASON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6008919.584 | 2120909.0921 | 37.804115104282296 | -122.413361099144 | (37.8041151042823, -122.413361099144) | |||
| 74064 | 74064 | 142576 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2251 MASON ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6008931.8286 | 2120832.3281 | 37.8039050170211 | -122.41331329383002 | (37.8039050170211, -122.41331329383) | |||
| 66971 | 66971 | 66269 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 600 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | 11 | Permit Number 32655 | 6008906.6331 | 2120793.0043 | 37.80379562910829 | -122.41339770206001 | (37.8037956291083, -122.41339770206) | ||
| 69317 | 69317 | 101339 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 600 Chestnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | 10 | Permit Number 32655 | 6008874.1379 | 2120789.2367 | 37.8037834596872 | -122.41350988733299 | (37.8037834596872, -122.413509887333) | ||
| 152296 | 152296 | 101340 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 600 Chestnut St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | 9 | Permit Number 32655 | 6008863.3062 | 2120787.3529 | 37.803777679043996 | -122.41354723786199 | (37.803777679044, -122.413547237862) | ||
| 168145 | 168145 | 101341 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 600 Chestnut St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | 10 | Permit Number 32655 | 6008852.9454 | 2120786.8819999998 | 37.8037758043003 | -122.413583058795 | (37.8037758043003, -122.413583058795) | ||
| 76339 | 76339 | 101357 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2201X Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | 5x5 | Permit Number 32655 | 6008936.1 | 2120783.7 | 37.803771736238 | -122.41329507143601 | (37.803771736238, -122.413295071436) | ||
| 78700 | 78700 | 101360 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2201X Mason St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | 5x5 | Permit Number 32655 | 6008936.1 | 2120783.7 | 37.803771736238 | -122.41329507143601 | (37.803771736238, -122.413295071436) | ||
| 95769 | 95769 | 101356 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2201X Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | 5x5 | Permit Number 32655 | 6008936.1 | 2120783.7 | 37.803771736238 | -122.41329507143601 | (37.803771736238, -122.413295071436) | ||
| 73489 | 73489 | 101342 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 600 Chestnut St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | 12 | Permit Number 32655 | 6008822.334 | 2120781.2306 | 37.803758568044294 | -122.413688591667 | (37.8037585680443, -122.413688591667) | ||
| 151126 | 151126 | 101343 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 600 Chestnut St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | 9 | Permit Number 32655 | 6008800.1996 | 2120778.8759 | 37.8037508596523 | -122.41376502259399 | (37.8037508596523, -122.413765022594) | ||
| 138193 | 138193 | 101344 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 600 Chestnut St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | 9 | Permit Number 32655 | 6008790.3098 | 2120778.405 | 37.803749011292894 | -122.413799213582 | (37.8037490112929, -122.413799213582) | ||
| 31960 | 31960 | 68737 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 650 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | 12 | Permit Number 32656 | 6008735.2093 | 2120769.9280000003 | 37.8037226410898 | -122.413989292504 | (37.8037226410898, -122.413989292504) | ||
| 185889 | 185889 | 142577 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 650 CHESTNUT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6008711.1911 | 2120767.1023 | 37.8037135334497 | -122.414072209035 | (37.8037135334497, -122.414072209035) | |||
| 37451 | 37451 | 142578 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 650 CHESTNUT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6008694.2371 | 2120763.8057 | 37.8037035295601 | -122.41413064608999 | (37.8037035295601, -122.41413064609) | |||
| 130400 | 130400 | 142579 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 650 CHESTNUT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6008676.3412 | 2120761.9219 | 37.803697351930204 | -122.41419244264999 | (37.8036973519302, -122.41419244265) | |||
| 56940 | 56940 | 33960 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 690 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1997 12:00:00 AM | 12 | Permit Number 37913 | 6008630.6596 | 2120754.8577 | 37.803675389390605 | -122.414350026627 | (37.8036753893906, -122.414350026627) | ||
| 59425 | 59425 | 33959 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 690 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1997 12:00:00 AM | 10 | Permit Number 37913 | 6008606.6414 | 2120752.0321 | 37.8036662817713 | -122.41443294306801 | (37.8036662817713, -122.414432943068) | ||
| 162098 | 162098 | 33961 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 690 Chestnut St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1997 12:00:00 AM | 11 | Permit Number 37913 | 6008567.552999999 | 2120746.3807 | 37.803648568516 | -122.414567810769 | (37.803648568516, -122.414567810769) | ||
| 70693 | 70693 | 33957 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 690 Chestnut St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1997 12:00:00 AM | 12 | Permit Number 37913 | 6008543.0639 | 2120742.6132 | 37.8036368480661 | -122.414652290037 | (37.8036368480661, -122.414652290037) | ||
| 137349 | 137349 | 81166 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2154 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52244 | 6008997.2075 | 2120680.2495 | 37.8034911176056 | -122.41307628549299 | (37.8034911176056, -122.413076285493) | |
| 173747 | 173747 | 136169 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 198 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6012034.81845 | 2120168.1216599997 | 37.802254992345794 | -122.402528406073 | (37.8022549923458, -122.402528406073) | |||
| 38889 | 38889 | 136170 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 198 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6012018.24202 | 2120166.5429599998 | 37.8022497321882 | -122.40258565782699 | (37.8022497321882, -122.402585657827) | |||
| 44917 | 44917 | 136171 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 198 Filbert St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6012005.31491 | 2120164.69847 | 37.8022439459513 | -122.40263026237801 | (37.8022439459513, -122.402630262378) | |||
| 64044 | 64044 | 136172 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 198 Filbert St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6011990.4613 | 2120162.70156 | 37.802237633629495 | -122.402681522861 | (37.8022376336295, -122.402681522861) | |||
| 185798 | 185798 | 136152 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 941 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007813.62095 | 2120247.54124 | 37.8022364959693 | -122.41714146932699 | (37.8022364959693, -122.417141469327) | |||
| 146481 | 146481 | 136173 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 198 Filbert St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6011973.46095 | 2120159.2157799997 | 37.802227113350604 | -122.40274010737 | (37.8022271133506, -122.40274010737) | |||
| 137502 | 137502 | 136168 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 199 Filbert St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6012040.44274 | 2120141.95348 | 37.8021834548683 | -122.40250710202 | (37.8021834548683, -122.40250710202) | |||
| 136593 | 136593 | 136167 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 199 Filbert St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6012021.9546 | 2120140.98814 | 37.80217977213079 | -122.40257101235301 | (37.8021797721308, -122.402571012353) | |||
| 179742 | 179742 | 136166 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 199 Filbert St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6012002.67028 | 2120138.6984200003 | 37.802172408481795 | -122.402637584674 | (37.8021724084818, -122.402637584674) | |||
| 167793 | 167793 | 136165 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 199 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6011988.41006 | 2120136.64195 | 37.8021659657496 | -122.40268678748801 | (37.8021659657496, -122.402686787488) | |||
| 149591 | 149591 | 136164 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 199 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6011976.278530001 | 2120136.0167400003 | 37.80216357174071 | -122.40272872467301 | (37.8021635717407, -122.402728724673) | |||
| 176580 | 176580 | 136163 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 201 Filbert St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6011866.89805 | 2120109.75638 | 37.80208535951461 | -122.403105387728 | (37.8020853595146, -122.403105387728) | |||
| 169947 | 169947 | 136162 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 201 Filbert St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011855.12339 | 2120107.7286900003 | 37.8020791344174 | -122.403145991197 | (37.8020791344174, -122.403145991197) | |||
| 24824 | 24824 | 136161 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 201 Filbert St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6011844.59181 | 2120106.54793 | 37.8020753041917 | -122.40318235259399 | (37.8020753041917, -122.403182352594) | |||
| 42555 | 42555 | 136160 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 201 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6011831.76306 | 2120104.36711 | 37.8020685997417 | -122.40322659294701 | (37.8020685997417, -122.403226592947) | |||
| 37735 | 37735 | 136159 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 201 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6011819.31995 | 2120103.92256 | 37.8020666841878 | -122.40326962099701 | (37.8020666841878, -122.403269620997) | |||
| 173234 | 173234 | 136158 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1261 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6011459.7379 | 2119677.17366 | 37.800874846854704 | -122.40448389641399 | (37.8008748468547, -122.404483896414) | |||
| 91221 | 91221 | 38504 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2448 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1998 12:00:00 AM | Permit Number 40495 | 6006719.11813993 | 2119590.22485423 | 37.8003700386069 | -122.420882291974 | (37.8003700386069, -122.420882291974) | ||
| 145097 | 145097 | 112678 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 490x GREEN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010628.0 | 2119373.0 | 37.79999314396429 | -122.40734061853 | (37.7999931439643, -122.40734061853) | ||||
| 64221 | 64221 | 42846 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2507 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 1 | Permit Number 45197 | 6006200.908969999 | 2119434.24266 | 37.7999125282101 | -122.42266441374399 | (37.7999125282101, -122.422664413744) | |
| 176822 | 176822 | 42847 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2507 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 7 | Permit Number 45197 | 6006203.58131 | 2119416.6683400003 | 37.7998644243564 | -122.422653916865 | (37.7998644243564, -122.422653916865) | |
| 83504 | 83504 | 33073 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1400 Grant Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37333 | 6010634.39060918 | 2119281.77515247 | 37.7997430205195 | -122.407312069993 | (37.7997430205195, -122.407312069993) | ||
| 95624 | 95624 | 33074 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1400 Grant Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37333 | 6010634.39060918 | 2119281.77515247 | 37.7997430205195 | -122.407312069993 | (37.7997430205195, -122.407312069993) | ||
| 63377 | 63377 | 71449 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 372 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 15 | 6011710.51408 | 2119095.9218900003 | 37.7992928818086 | -122.403575181848 | (37.7992928818086, -122.403575181848) | ||
| 95954 | 95954 | 80132 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2907-2909 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52336 | 6004303.44564273 | 2119114.6178643 | 37.7989276868106 | -122.429207548051 | (37.7989276868106, -122.429207548051) | ||
| 96385 | 96385 | 80093 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1800-1804 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52336 | 6004315.45310997 | 2119112.20443091 | 37.7989217398797 | -122.429165826066 | (37.7989217398797, -122.429165826066) | ||
| 125878 | 125878 | 80131 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1800-1804 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52336 | 6004315.45310997 | 2119112.20443091 | 37.7989217398797 | -122.429165826066 | (37.7989217398797, -122.429165826066) | ||
| 83667 | 83667 | 33135 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 3103 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37364 | 6001398.64749893 | 2119042.88886918 | 37.7985658687067 | -122.439253943829 | (37.7985658687067, -122.439253943829) | ||
| 109361 | 109361 | 33136 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 3103 Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37364 | 6001398.64749893 | 2119042.88886918 | 37.7985658687067 | -122.439253943829 | (37.7985658687067, -122.439253943829) | ||
| 125831 | 125831 | 33137 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 3103 Pierce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37364 | 6001398.64749893 | 2119042.88886918 | 37.7985658687067 | -122.439253943829 | (37.7985658687067, -122.439253943829) | ||
| 95559 | 95559 | 100087 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2028 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6003216.8 | 2118972.8 | 37.798476716718895 | -122.432957560795 | (37.7984767167189, -122.432957560795) | |||||
| 188697 | 188697 | 71536 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1159 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1995 12:00:00 AM | 8 | 3x3 | 6007487.54298 | 2118815.04438 | 37.798284870413205 | -122.41816824147499 | (37.7982848704132, -122.418168241475) | ||
| 7371 | 7371 | 44106 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1242 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778937 | 6007599.34177 | 2118533.61268 | 37.797518421388205 | -122.41776142416401 | (37.7975184213882, -122.417761424164) | |
| 75982 | 75982 | 38486 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 46 Bernard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1998 12:00:00 AM | 12 | Permit Number 40483 | 6008598.7758599995 | 2118126.03004 | 37.79645549199179 | -122.414274253461 | (37.7964554919918, -122.414274253461) | |
| 33931 | 33931 | 38487 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 663 Bernard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1998 12:00:00 AM | 11 | Permit Number 40484 | 6008553.25241 | 2118118.58868 | 37.7964325026095 | -122.414431248111 | (37.7964325026095, -122.414431248111) | |
| 159864 | 159864 | 136107 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2844 Fillmore St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6002576.03515 | 2117998.39641 | 37.7957648926996 | -122.43510507374701 | (37.7957648926996, -122.435105073747) | |||
| 140029 | 140029 | 57111 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1378 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/2016 12:00:00 AM | 3 | Permit Number 14381 | 6007532.82476836 | 2117829.05895603 | 37.795580149108204 | -122.417941620632 | (37.7955801491082, -122.417941620632) | |
| 24019 | 24019 | 88218 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2833 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 7 | 3x3 | Permit Number 51182 | 6002531.3189900005 | 2117911.01652 | 37.7955224309554 | -122.435253546437 | (37.7955224309554, -122.435253546437) | |
| 169409 | 169409 | 136104 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2749 Pierce St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6001552.22851 | 2117904.90821 | 37.795450010374296 | -122.43864092293501 | (37.7954500103743, -122.438640922935) | |||
| 31289 | 31289 | 136105 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2831 Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6002541.1319699995 | 2117853.26725 | 37.795364423677896 | -122.435215459237 | (37.7953644236779, -122.435215459237) | |||
| 99 | 99 | 7992 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2247 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/2007 12:00:00 AM | 3 | 3X3 | 6005467.69382 | 2117725.44397 | 37.7951792074025 | -122.42507996488001 | (37.7951792074025, -122.42507996488) | ||
| 184604 | 184604 | 136106 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2362 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6002236.434090001 | 2117779.37436 | 37.7951442255914 | -122.436264471651 | (37.7951442255914, -122.436264471651) | |||
| 5854 | 5854 | 30037 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2231 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/14/2008 12:00:00 AM | 3 | 3x3 | 6005477.24721 | 2117649.17337 | 37.794970327277 | -122.425041479277 | (37.794970327277, -122.425041479277) |
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");