Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1102 | 1102 | 241326 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 395 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 8 | Width 3ft | 6007429.44982 | 2107410.61084 | 37.7669677904545 | -122.417560553376 | (37.7669677904545, -122.417560553376) | ||
| 1798 | 1798 | 241305 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 697 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 5 | Width 3ft | 6007530.224909999 | 2105637.84626 | 37.7621058621135 | -122.41708636154301 | (37.7621058621135, -122.417086361543) | ||
| 2740 | 2740 | 72022 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 550 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/1989 12:00:00 AM | 12 | 4x4 | 6010599.26481 | 2116134.30998 | 37.791098878065796 | -122.40721162653401 | (37.7910988780658, -122.407211626534) | ||
| 3708 | 3708 | 241324 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 490 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 7 | Width 3ft | 6007395.8118199995 | 2106861.7423400003 | 37.765458833278 | -122.417637995807 | (37.765458833278, -122.417637995807) | ||
| 3714 | 3714 | 241323 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 490 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 8 | Width 3ft | 6007394.41265 | 2106888.07859 | 37.765531067728894 | -122.417644702035 | (37.7655310677289, -122.417644702035) | ||
| 5677 | 5677 | 19923 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 100 STAIRWAY37 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 20ST | ||||||||
| 11160 | 11160 | 19922 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 100 STAIRWAY37 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 20ST | ||||||||
| 11940 | 11940 | 19758 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 100 STAIRWAY15 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 20ST | ||||||||
| 12107 | 12107 | 26278 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1828 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/08/1998 12:00:00 AM | 3 | 6000476.90225 | 2093497.19967 | 37.728371233643706 | -122.44061019542801 | (37.7283712336437, -122.440610195428) | |||
| 14361 | 14361 | 100315 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1683 Galvez Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6015443.91077 | 2097940.33755 | 37.7414121299803 | -122.38917822030399 | (37.7414121299803, -122.389178220304) | |||
| 14398 | 14398 | 104044 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1601X Kansas St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 70 | 9x9 | 6011818.89895 | 2100809.64818 | 37.749089017243904 | -122.401913980245 | (37.7490890172439, -122.401913980245) | |||
| 14780 | 14780 | 104045 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1601X Kansas St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 4 | 3x6 | 6011820.27046 | 2100794.2900099996 | 37.7490469235803 | -122.40190815805 | (37.7490469235803, -122.40190815805) | |||
| 15101 | 15101 | 100314 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1683 Galvez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6015409.74359 | 2097962.08476 | 37.7414699491892 | -122.389297877816 | (37.7414699491892, -122.389297877816) | |||
| 15236 | 15236 | 61555 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1175- 1175 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2007 12:00:00 AM | 7 | 3x3 | Permit Number 49777 | 6012252.19835 | 2102963.4918400003 | 37.7550271768774 | -122.40056689654101 | (37.7550271768774, -122.400566896541) | |
| 15361 | 15361 | 104046 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1601X Kansas St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 4 | 3x6 | 6011820.47885 | 2100780.87152 | 37.7490100909441 | -122.401906494295 | (37.7490100909441, -122.401906494295) | |||
| 15563 | 15563 | 104460 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1601X Kansas St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 4 | 3x6 | 6011835.24913 | 2100548.938 | 37.7483740760146 | -122.401839117097 | (37.7483740760146, -122.401839117097) | |||
| 18677 | 18677 | 88330 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 544 London St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51318 | 6001416.8 | 2090660.3 | 37.720635228492206 | -122.437157897339 | (37.7206352284922, -122.437157897339) | |||
| 19270 | 19270 | 91581 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 200x South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007370.010962999 | 2108444.137303 | 37.769802266170295 | -122.41783941244101 | (37.7698022661703, -122.417839412441) | ||
| 19735 | 19735 | 96580 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 401x Otsego Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 05/14/2011 12:00:00 AM | 3x3 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | |||
| 20263 | 20263 | 91677 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 599 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007489.042117 | 2106191.6259580003 | 37.763624095672895 | -122.417268041752 | (37.7636240956729, -122.417268041752) | |||
| 23657 | 23657 | 196979 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1551 20th St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6013315.21298 | 2104723.80911 | 37.7599198521353 | -122.39701407983802 | (37.7599198521353, -122.397014079838) | |||
| 24899 | 24899 | 241325 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 425 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007441.87524 | 2107194.22963 | 37.766374357512 | -122.417502238664 | (37.766374357512, -122.417502238664) | |||
| 25708 | 25708 | 41912 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 642 12th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 8 | Permit Number 42274 | 5992258.1025 | 2111064.36491 | 37.7761346671426 | -122.470301476833 | (37.7761346671426, -122.470301476833) | |
| 26363 | 26363 | 241362 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 610 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009794.309330001 | 2105409.48411 | 37.7616059370772 | -122.409239613928 | (37.7616059370772, -122.409239613928) | |||
| 27023 | 27023 | 59880 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2139 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1981 12:00:00 AM | 10 | Permit Number 19345 | 6002701.87127 | 2118840.7450599996 | 37.7980849079605 | -122.434729923369 | (37.7980849079605, -122.434729923369) | |
| 28103 | 28103 | 247599 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 900 Tompkins Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 10ft | 6009183.00439 | 2096409.33052 | 37.7368592482464 | -122.410718251366 | (37.7368592482464, -122.410718251366) | |||
| 28335 | 28335 | 241388 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1769 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6003420.97531 | 2097978.6003400004 | 37.7408433528415 | -122.430752071748 | (37.7408433528415, -122.430752071748) | |||
| 29042 | 29042 | 241390 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 381 30th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004068.125469999 | 2098354.29911 | 37.7419115792635 | -122.428541241382 | (37.7419115792635, -122.428541241382) | |||
| 29151 | 29151 | 196965 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 500 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6015917.99613 | 2105847.4159999997 | 37.763149578419 | -122.38809064946999 | (37.763149578419, -122.38809064947) | |||
| 29450 | 29450 | 241312 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 700 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007473.647469999 | 2105479.75896 | 37.761668608133604 | -122.41727083858 | (37.7616686081336, -122.41727083858) | |||
| 30604 | 30604 | 38903 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 800 Powell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1998 12:00:00 AM | 3 | Permit Number 40882 | 6010050.2194300005 | 2116612.32864 | 37.7923806592989 | -122.40914505830798 | (37.7923806592989, -122.409145058308) | |
| 30801 | 30801 | 241283 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1201 Vermont St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6011469.095480001 | 2101944.7688700003 | 37.7521862823701 | -122.403203448894 | (37.7521862823701, -122.403203448894) | |||
| 31204 | 31204 | 34256 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 156 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 4 | Permit Number 39596 | 5993995.61311 | 2114522.3944099997 | 37.78572978571 | -122.46454215478 | (37.78572978571, -122.46454215478) | |
| 31761 | 31761 | 179275 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 716 Peru Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6005245.16074 | 2092477.2139400002 | 37.725840954193295 | -122.424053582122 | (37.7258409541933, -122.424053582122) | |||
| 32204 | 32204 | 241310 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 565 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007485.43036 | 2106430.0255 | 37.764278482093204 | -122.417297428844 | (37.7642784820932, -122.417297428844) | |||
| 32453 | 32453 | 241290 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1227 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6011160.10458 | 2102427.21865 | 37.753493722159 | -122.40430594666701 | (37.753493722159, -122.404305946667) | |||
| 32983 | 32983 | 196995 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2 Napoleon St | 8 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6013853.97089 | 2100136.72086 | 37.7473546683845 | -122.394829506973 | (37.7473546683845, -122.394829506973) | |||
| 33708 | 33708 | 80092 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1800-1804 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52336 | 6004273.51915 | 2119103.69822 | 37.798896010091205 | -122.429310324527 | (37.7988960100912, -122.429310324527) | |
| 33736 | 33736 | 65937 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2826 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1990 12:00:00 AM | 7 | Permit Number 28956 | 5999433.3119 | 2118083.73409 | 37.7958202522453 | -122.44598557278401 | (37.7958202522453, -122.445985572784) | ||
| 34027 | 34027 | 196983 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1601 Kansas St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 6011835.24913 | 2100548.938 | 37.7483740760146 | -122.401839117097 | (37.7483740760146, -122.401839117097) | |||
| 34152 | 34152 | 41913 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 642 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 8 | Permit Number 42274 | 5992259.32657 | 2111046.49076 | 37.7760856603427 | -122.470295940533 | (37.7760856603427, -122.470295940533) | |
| 34793 | 34793 | 241297 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1534 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6007142.6566 | 2107359.7842099997 | 37.7668120908263 | -122.41854892359899 | (37.7668120908263, -122.418548923599) | |||
| 35274 | 35274 | 196970 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 500 18th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6015850.66313 | 2105843.80284 | 37.763135926706795 | -122.38832328159599 | (37.7631359267068, -122.388323281596) | |||
| 35888 | 35888 | 241328 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 373 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007423.72887 | 2107548.5847099996 | 37.7673463124187 | -122.417590121285 | (37.7673463124187, -122.417590121285) | |||
| 36504 | 36504 | 197003 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 503 Beale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6015964.6605 | 2113962.87673 | 37.7854354289412 | -122.38849574371001 | (37.7854354289412, -122.38849574371) | |||
| 37202 | 37202 | 241295 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1350 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007154.425919999 | 2107655.79566 | 37.7676255312226 | -122.418529207767 | (37.7676255312226, -122.418529207767) | |||
| 37397 | 37397 | 91640 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1427 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007757.588641 | 2101343.9238919998 | 37.7503285203588 | -122.415995902486 | (37.7503285203588, -122.415995902486) | |||
| 37502 | 37502 | 34257 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 160 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 9 | Permit Number 39597 | 5993997.84726 | 2114498.92628 | 37.78566547740571 | -122.464532720679 | (37.7856654774057, -122.464532720679) | |
| 37617 | 37617 | 241293 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1300 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6011113.70254 | 2102244.2434799997 | 37.7529887195714 | -122.404453537112 | (37.7529887195714, -122.404453537112) | |||
| 37753 | 37753 | 71351 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 118 Danvers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/2008 12:00:00 AM | 3x3 | Permit Number 50915 | 5999898.11886666 | 2105092.21291824 | 37.7601753897516 | -122.44344360556002 | (37.7601753897516, -122.44344360556) | ||
| 37755 | 37755 | 241365 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1475 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 6010134.568630001 | 2100721.5441 | 37.748752956797794 | -122.407732226982 | (37.7487529567978, -122.407732226982) | |||
| 38113 | 38113 | 196990 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2 Napoleon St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6014143.12746 | 2100151.41021 | 37.7474110756645 | -122.39383064437901 | (37.7474110756645, -122.393830644379) | |||
| 38294 | 38294 | 241369 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2877 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 7ft | 6009515.68514 | 2102750.48038 | 37.7542892993236 | -122.410015545387 | (37.7542892993236, -122.410015545387) | |||
| 38456 | 38456 | 241317 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 270 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007335.93397 | 2108086.9588 | 37.7688196204438 | -122.41793196081801 | (37.7688196204438, -122.417931960818) | |||
| 39431 | 39431 | 241273 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 55 Haight St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6005874.88911 | 2109629.37494 | 37.7729723901943 | -122.423095264536 | (37.7729723901943, -122.423095264536) | |||
| 39737 | 39737 | 241337 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2711 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009686.38177 | 2105455.07073 | 37.761725060389 | -122.409616110618 | (37.761725060389, -122.409616110618) | |||
| 40217 | 40217 | 196963 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 500 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6015947.26389 | 2105849.11258 | 37.7631558583726 | -122.38798953960101 | (37.7631558583726, -122.387989539601) | |||
| 40314 | 40314 | 241327 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 377 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007424.50403 | 2107516.88319 | 37.7672593111026 | -122.41758519300501 | (37.7672593111026, -122.417585193005) | |||
| 40491 | 40491 | 241321 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 356 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007355.9869099995 | 2107612.7207 | 37.7675186027402 | -122.417828978541 | (37.7675186027402, -122.417828978541) | |||
| 40712 | 40712 | 65755 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 3036 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/1990 12:00:00 AM | 14 | Permit Number 28718 | 6004280.733630001 | 2119630.96227 | 37.80034414971529 | -122.429322978897 | (37.8003441497153, -122.429322978897) | |
| 40771 | 40771 | 241272 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 67 Webster St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6004275.92505 | 2108860.93687 | 37.770772085482605 | -122.428571490982 | (37.7707720854826, -122.428571490982) | |||
| 41551 | 41551 | 34964 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 900 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1997 12:00:00 AM | 8 | Permit Number 38553 | 6014444.742740001 | 2102850.7303299997 | 37.7548395926778 | -122.39297650156901 | (37.7548395926778, -122.392976501569) | ||
| 41621 | 41621 | 120834 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2033 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5989271.19606 | 2110543.25177 | 37.7745306911578 | -122.48059571456498 | (37.7745306911578, -122.480595714565) | |||
| 42090 | 42090 | 241379 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 3702 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008438.87775 | 2097614.97452 | 37.7401279331501 | -122.41337627141701 | (37.7401279331501, -122.413376271417) | |||
| 42244 | 42244 | 241274 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2616 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6010311.63301 | 2104008.02665 | 37.75778681942779 | -122.40735159161501 | (37.7577868194278, -122.407351591615) | |||
| 42273 | 42273 | 31514 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2537 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 13 | Permit Number 35072 | 6010934.2499 | 2102257.13766 | 37.7530140939364 | -122.405075029795 | (37.7530140939364, -122.405075029795) | |
| 42415 | 42415 | 122016 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1633 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5990486.56458 | 2110588.66917 | 37.774725954752796 | -122.47639488146099 | (37.7747259547528, -122.476394881461) | |||
| 42801 | 42801 | 241354 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2601 Mariposa St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 6ft | 6009719.71418 | 2105928.26145 | 37.7630262022081 | -122.409534224627 | (37.7630262022081, -122.409534224627) | |||
| 43037 | 43037 | 241350 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2601 Mariposa St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 6009654.92584 | 2105925.07195 | 37.76301381405529 | -122.409758081181 | (37.7630138140553, -122.409758081181) | |||
| 44456 | 44456 | 241338 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2709 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009715.56008 | 2105456.2423 | 37.7617299122363 | -122.409515276828 | (37.7617299122363, -122.409515276828) | |||
| 44724 | 44724 | 241370 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2877 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 7ft | 6009531.75591 | 2102750.92335 | 37.7542914163323 | -122.409959999651 | (37.7542914163323, -122.409959999651) | |||
| 45678 | 45678 | 70389 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1942 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1999 12:00:00 AM | 2 | 5989540.17856 | 2110611.69098 | 37.7747342353889 | -122.47967027105899 | (37.7747342353889, -122.479670271059) | ||
| 46221 | 46221 | 241389 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 47 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6002625.8998300005 | 2096003.5312299998 | 37.7353751906151 | -122.43336004273 | (37.7353751906151, -122.43336004273) | |||
| 46541 | 46541 | 196984 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1601 Kansas St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 6011820.47885 | 2100780.87152 | 37.7490100909441 | -122.401906494295 | (37.7490100909441, -122.401906494295) | |||
| 46602 | 46602 | 91707 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 99 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007261.828778 | 2109331.862933 | 37.7722336617279 | -122.41827656224599 | (37.7722336617279, -122.418276562246) | ||
| 46628 | 46628 | 90888 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1643 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 2 | 3x3 | 5990427.389219999 | 2110587.7825599997 | 37.7747200883254 | -122.47659951411 | (37.7747200883254, -122.47659951411) | ||
| 47101 | 47101 | 67973 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2133 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 3 | Permit Number 31694 | 5988948.22001 | 2110531.76438 | 37.7744803739464 | -122.48171209676799 | (37.7744803739464, -122.481712096768) | |
| 47277 | 47277 | 90869 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2045 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5989208.80531 | 2110541.2902599997 | 37.774521679169396 | -122.48081139016199 | (37.7745216791694, -122.480811390162) | ||
| 47790 | 47790 | 32353 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2180 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1996 12:00:00 AM | 8 | Permit Number 36907 | 6009556.94604 | 2104659.06953 | 37.759532167893 | -122.410007582777 | (37.759532167893, -122.410007582777) | |
| 47818 | 47818 | 47653 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 245 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/2002 12:00:00 AM | 5 | Permit Number 45457 | 6013208.50894 | 2105918.56319 | 37.7631944437823 | -122.39746691096701 | (37.7631944437823, -122.397466910967) | |
| 47952 | 47952 | 241313 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 720 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007476.612269999 | 2105442.18225 | 37.7615655979969 | -122.417257921613 | (37.7615655979969, -122.417257921613) | |||
| 47985 | 47985 | 83223 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1446-48 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2016 12:00:00 AM | 3 | 3x3 | Permit Number 50888 | 5993687.91761966 | 2105648.90031529 | 37.7613477954461 | -122.464962006978 | (37.7613477954461, -122.464962006978) | |
| 48206 | 48206 | 241329 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 349 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007417.325069999 | 2107664.8176700003 | 37.767665100494206 | -122.417620510295 | (37.7676651004942, -122.417620510295) | |||
| 48775 | 48775 | 37999 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 725 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 6 | Permit Number 40211 | 6012746.31439 | 2104130.05474 | 37.758257848348705 | -122.39893996271401 | (37.7582578483487, -122.398939962714) | |
| 49190 | 49190 | 241285 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1201 Vermont St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 6011473.17853 | 2101977.48291 | 37.752276335990004 | -122.40319162999901 | (37.75227633599, -122.403191629999) | |||
| 49905 | 49905 | 43686 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 162 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 4 | Permit Number 43330 | 5993378.798359999 | 2114426.59889 | 37.785431180637005 | -122.46666917491999 | (37.785431180637, -122.46666917492) | |
| 51103 | 51103 | 196994 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2 Napoleon St | 7 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6013884.28274 | 2100137.93009 | 37.7473596740254 | -122.39472477462401 | (37.7473596740254, -122.394724774624) | |||
| 51144 | 51144 | 241330 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 335 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007413.91501 | 2107730.15032 | 37.7678442967163 | -122.417636936423 | (37.7678442967163, -122.417636936423) | |||
| 52082 | 52082 | 123105 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 498 11th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992529.16869 | 2112181.64232 | 37.7792180760249 | -122.46944514164801 | (37.7792180760249, -122.469445141648) | |||
| 52341 | 52341 | 241334 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 245 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007405.72375 | 2108268.9659 | 37.7693232965496 | -122.417703464652 | (37.7693232965496, -122.417703464652) | |||
| 52365 | 52365 | 34963 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 900 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1997 12:00:00 AM | 13 | Permit Number 38553 | 6014444.86373 | 2102867.97159 | 37.754886940207705 | -122.392977289379 | (37.7548869402077, -122.392977289379) | ||
| 52439 | 52439 | 241387 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 43 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004298.9077699995 | 2098020.68858 | 37.7410086185538 | -122.42771950655 | (37.7410086185538, -122.42771950655) | |||
| 54246 | 54246 | 241340 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2701 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009746.5481 | 2105459.14432 | 37.7617396168174 | -122.409408306065 | (37.7617396168174, -122.409408306065) | |||
| 54443 | 54443 | 136182 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 3140 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5999403.041730001 | 2119664.02877 | 37.800157590747105 | -122.446204044176 | (37.8001575907471, -122.446204044176) | |||
| 54629 | 54629 | 82125 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 317 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50070 | 6006739.55759841 | 2104266.9934198 | 37.758297308509995 | -122.41972370977 | (37.75829730851, -122.41972370977) |
| 56244 | 56244 | 65529 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1855 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/1990 12:00:00 AM | 3 | Permit Number 28417 | 5989796.43775 | 2110560.03757 | 37.7746072923506 | -122.47878004958 | (37.7746072923506, -122.47878004958) | ||
| 56981 | 56981 | 196988 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1601 Kansas St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6011818.89895 | 2100809.64818 | 37.749089017243904 | -122.401913980245 | (37.7490890172439, -122.401913980245) | |||
| 57849 | 57849 | 241284 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1201 Vermont St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 6011470.02474 | 2101959.91095 | 37.752227911103894 | -122.403201300403 | (37.7522279111039, -122.403201300403) | |||
| 57866 | 57866 | 241276 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1400 Potrero Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6010713.5875 | 2101085.7119400003 | 37.749785278666394 | -122.40575562052601 | (37.7497852786664, -122.405755620526) | |||
| 58092 | 58092 | 196987 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1601 Kansas St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6011820.27046 | 2100794.2900099996 | 37.7490469235803 | -122.40190815805 | (37.7490469235803, -122.40190815805) |
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");