Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, DBH, PlotSize, PermitNotes
qCaretaker ✖
Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
177834 | 177834 | 100976 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 450X Chestnut St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 5 | Permit Number 37341 | 6009558.1383 | 2120880.7372 | 37.8040730797801 | -122.411149322876 | (37.8040730797801, -122.411149322876) | ||
176592 | 176592 | 34689 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 5 | 3x3 | Permit Number 38352 | 6002816.77257 | 2119329.88091 | 37.79943447017929 | -122.434367321195 | (37.7994344701793, -122.434367321195) |
171968 | 171968 | 93015 | Permitted Site 1 | Tristania conferta :: 79 | 2395 Lombard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 01/08/2010 12:00:00 AM | 3 | 4x4 | Permit Number 53139; 3-year maintenance agreement through 12/29/12 | 6001036.8533 | 2119267.6007 | 37.7991622735558 | -122.440521987709 | (37.7991622735558, -122.440521987709) |
166994 | 166994 | 34691 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 10 | 3x3 | Permit Number 38352 | 6002820.98316 | 2119293.45008 | 37.7993346796145 | -122.43435014504699 | (37.7993346796145, -122.434350145047) |
161870 | 161870 | 98647 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 12 | 5x5 | 6002751.94545 | 2119240.19821 | 37.7991845449763 | -122.434585229619 | (37.7991845449763, -122.434585229619) | ||
153048 | 153048 | 98645 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 9 | 5x5 | 6002788.88101 | 2119245.38589 | 37.799200885676605 | -122.434457791187 | (37.7992008856766, -122.434457791187) | ||
147766 | 147766 | 100979 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 450X Chestnut St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 6 | Permit Number 37341 | 6009507.0071 | 2120874.2443 | 37.8040523843138 | -122.411325807727 | (37.8040523843138, -122.411325807727) | ||
145991 | 145991 | 97568 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 500 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 6001703.0 | 2110108.0 | 37.7740502679918 | -122.437560592174 | (37.7740502679918, -122.437560592174) | |||
145388 | 145388 | 100987 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 2190 Powell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257168998 | (37.8045319114054, -122.41088257169) | |||
145311 | 145311 | 100972 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 450X Chestnut St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 03/24/2016 07:43:00 AM | 3 | Permit Number 37341 | 6009614.0 | 2121059.9 | 37.8045681487804 | -122.410968670823 | (37.8045681487804, -122.410968670823) | |
144888 | 144888 | 96468 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2001 Market St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | |||
144879 | 144879 | 24627 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 444 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 12/06/2006 12:00:00 AM | 3 | 3X4 | 6001753.1685929 | 2109931.6605583 | 37.7735689361616 | -122.43737442109699 | (37.7735689361616, -122.437374421097) | |
144041 | 144041 | 97895 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 375X Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 3 | 3x3 | 6008901.5 | 2100225.6 | 37.7473220995732 | -122.411961145064 | (37.7473220995732, -122.411961145064) | ||
142889 | 142889 | 109994 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 501X Shotwell St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | |||
142683 | 142683 | 116623 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 4 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
142420 | 142420 | 95236 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1220 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 12 | 3x3 | 6002897.4 | 2101092.2 | 37.7493628934568 | -122.432784769514 | (37.7493628934568, -122.432784769514) | ||
141475 | 141475 | 104153 | Permitted Site 1 | :: 54 | 525X Church St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x17 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
141399 | 141399 | 97582 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 744 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3x3 | 6001602.0 | 2110950.0 | 37.7763564458951 | -122.43797029127701 | (37.7763564458951, -122.437970291277) | ||
140818 | 140818 | 100980 | DPW Maintained 3 | Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 | 2190 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 05/03/2013 12:00:00 AM | 3 | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257168998 | (37.8045319114054, -122.41088257169) | |
140589 | 140589 | 14248 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2001 Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/20/2011 12:00:00 AM | 0 | 3x3 | Permit Number 767173 | 6004759.8459002 | 2108188.2274393 | 37.7689523618819 | -122.426849682313 | (37.7689523618819, -122.426849682313) |
140126 | 140126 | 97899 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 375X Precita Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 6 | 3x3 | 6008901.5 | 2100225.6 | 37.7473220995732 | -122.411961145064 | (37.7473220995732, -122.411961145064) | ||
133902 | 133902 | 34692 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 9 | 3x3 | Permit Number 38352 | 6002825.2019 | 2119271.55666 | 37.7992748054477 | -122.434333980647 | (37.7992748054477, -122.434333980647) |
131687 | 131687 | 98655 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 6 | 5x5 | 6002650.75991 | 2119226.56813 | 37.799141375727295 | -122.434934390513 | (37.7991413757273, -122.434934390513) | ||
128369 | 128369 | 109998 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 501X Shotwell St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | ||||
127181 | 127181 | 103126 | Permitted Site 1 | Tree(s) :: 17 | 1020 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 03/22/2013 12:00:00 AM | 3x3 | Permit Number 769235 | 6005624.5 | 2103007.3 | 37.7547756072831 | -122.423490517587 | (37.7547756072831, -122.423490517587) | |
126456 | 126456 | 116577 | Significant Tree 6 | Shrub :: Shrub 98 | 3000x 19TH AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | MTA 6 | DPW 4 | 30 | 3x3 | 5990602.0 | 2095184.0 | 37.7324354869182 | -122.47487091251001 | (37.7324354869182, -122.47487091251) | ||
125790 | 125790 | 116627 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 8 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
125523 | 125523 | 106883 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 180X SAN MARCOS AVE | 4 | Median : Cutout 11 | Tree 1 | Private 1 | DPW 4 | 4 | 5993452.8 | 2100406.9 | 37.746941053663505 | -122.46539437233801 | (37.7469410536635, -122.465394372338) | |||
124890 | 124890 | 96470 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2001 Market St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | |||
124339 | 124339 | 116630 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 11 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
124316 | 124316 | 109993 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 501X Shotwell St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | |||
124070 | 124070 | 98909 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 501X Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | |||
123257 | 123257 | 116622 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 3 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
122481 | 122481 | 102195 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3999X Folsom St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 3 | 3x3 | 6008408.0 | 2096514.0 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | ||
121851 | 121851 | 97594 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 601X Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3x3 | 6001572.2 | 2110512.7 | 37.7751540352305 | -122.43804204596901 | (37.7751540352305, -122.438042045969) | ||
121486 | 121486 | 95235 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1220 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 3 | 3x3 | 6002897.4 | 2101092.2 | 37.7493628934568 | -122.432784769514 | (37.7493628934568, -122.432784769514) | ||
121382 | 121382 | 5205 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 781 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 10/28/2015 07:08:00 AM | 3 | 4X4 | 6001514.7755792 | 2111067.8471612 | 37.776675063930504 | -122.438280468838 | (37.7766750639305, -122.438280468838) | |
121169 | 121169 | 109989 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 501X Shotwell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | |||
120836 | 120836 | 24637 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 425 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 10/25/2011 12:00:00 AM | 3 | 3X3 | 6001690.3813095 | 2109822.1283023 | 37.773264618286 | -122.437583765683 | (37.773264618286, -122.437583765683) | |
120777 | 120777 | 95241 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1220 Noe St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 3 | 3x3 | 6002897.4 | 2101092.2 | 37.7493628934568 | -122.432784769514 | (37.7493628934568, -122.432784769514) | ||
120725 | 120725 | 96465 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2001 Market St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | |||
120634 | 120634 | 116580 | Significant Tree 6 | Shrub :: Shrub 98 | 3000x 19TH AVE | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | MTA 6 | DPW 4 | 3x3 | 5990602.0 | 2095184.0 | 37.7324354869182 | -122.47487091251001 | (37.7324354869182, -122.47487091251) | |||
120473 | 120473 | 112511 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 699x WILLOW ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW 4 | 08/08/2015 03:37:00 PM | 3 | 2x2 | 6004423.0 | 2113018.0 | 37.7821946822097 | -122.42835909048999 | (37.7821946822097, -122.42835909049) | |
120383 | 120383 | 95412 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2815 Diamond St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 1 | 3x3 | Planted by Glen Park Public Library; will become DPW maintained after it is established. | 6002467.0 | 2095594.0 | 37.734241695714005 | -122.43388015504499 | (37.734241695714, -122.433880155045) | |
119959 | 119959 | 100985 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2190 Powell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 03/23/2016 02:34:00 PM | 3 | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257168998 | (37.8045319114054, -122.41088257169) | |
119913 | 119913 | 97600 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 857 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3x3 | 6001483.0 | 2111323.0 | 37.7773738419974 | -122.43840867438801 | (37.7773738419974, -122.438408674388) | ||
119702 | 119702 | 111096 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 67 SAINT CHARLES AVE | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 15 | 5992079.0 | 2088073.0 | 37.712995910736204 | -122.46924723728901 | (37.7129959107362, -122.469247237289) | |||
119651 | 119651 | 97570 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 546 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 6001754.3 | 2110345.0 | 37.7747039272721 | -122.437400111383 | (37.7747039272721, -122.437400111383) | |||
119523 | 119523 | 97603 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 823 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3x3 | 6001500.0 | 2111204.0 | 37.777048064939706 | -122.438341338421 | (37.7770480649397, -122.438341338421) | ||
119101 | 119101 | 116621 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 2 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
118803 | 118803 | 97587 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 319 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 6001745.0 | 2109492.0 | 37.772361273527004 | -122.437371188758 | (37.772361273527, -122.437371188758) | |||
118370 | 118370 | 97563 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 250 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 09/21/2015 12:00:00 AM | 3 | 5x5 | 6001845.0 | 2109086.0 | 37.771252182937296 | -122.436996208247 | (37.7712521829373, -122.436996208247) | |
117440 | 117440 | 95240 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1220 Noe St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 12 | 3x3 | 6002897.4 | 2101092.2 | 37.7493628934568 | -122.432784769514 | (37.7493628934568, -122.432784769514) | ||
117253 | 117253 | 97580 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 700X Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3x3 | 6001615.5 | 2110795.9 | 37.7759340937147 | -122.437912550894 | (37.7759340937147, -122.437912550894) | ||
116328 | 116328 | 5157 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 270 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 0 | 6001849.8958745 | 2109240.8779841997 | 37.7716777176824 | -122.43699036314301 | (37.7716777176824, -122.436990363143) | |||
115707 | 115707 | 96469 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2001 Market St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | |||
114895 | 114895 | 116578 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 2699x OCEAN AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | MTA 6 | DPW 4 | 11 | 3x3 | 5990602.0 | 2095184.0 | 37.7324354869182 | -122.47487091251001 | (37.7324354869182, -122.47487091251) | ||
114335 | 114335 | 5184 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 460X Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 04/21/2016 12:00:00 AM | 3 | 3x3 | 6001745.349517 | 2109984.4298688998 | 37.7737133829934 | -122.437405247826 | (37.7737133829934, -122.437405247826) | |
114247 | 114247 | 106879 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 180X SAN MARCOS AVE | 2 | Median : Cutout 11 | Tree 1 | Private 1 | DPW 4 | 6 | 5993452.8 | 2100406.9 | 37.746941053663505 | -122.46539437233801 | (37.7469410536635, -122.465394372338) | |||
113857 | 113857 | 97066 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1599X Newcomb Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 10 | 3x3 | 6015231.1 | 2095663.5 | 37.7351486000155 | -122.38975506041099 | (37.7351486000155, -122.389755060411) | ||
113603 | 113603 | 104154 | Permitted Site 1 | :: 54 | 525X Church St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x17 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
113485 | 113485 | 97567 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 342 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 6001791.0 | 2109583.0 | 37.772613751849605 | -122.43721858759199 | (37.7726137518496, -122.437218587592) | |||
113343 | 113343 | 116624 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 5 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
111283 | 111283 | 98658 | DPW Maintained 3 | Tree(s) :: 17 | 2110 Greenwich St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 06/20/2014 12:00:00 AM | 6x6 | Permit Number 772915 | 6002683.8 | 2119245.6 | 37.799195508176105 | -122.434821422435 | (37.7991955081761, -122.434821422435) | |
111008 | 111008 | 116626 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 5732X GEARY BLVD | 7 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
110539 | 110539 | 14250 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2001 Market St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/20/2011 12:00:00 AM | 0 | 3x3 | Permit Number 767173 | 6004759.8459002 | 2108188.2274393 | 37.7689523618819 | -122.426849682313 | (37.7689523618819, -122.426849682313) |
109915 | 109915 | 109999 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 501X Shotwell St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | ||||
109678 | 109678 | 97597 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 701X Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 4x3 | 6001578.0 | 2110798.0 | 37.7759377272515 | -122.438042423333 | (37.7759377272515, -122.438042423333) | ||
109229 | 109229 | 93013 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2395 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 01/08/2010 12:00:00 AM | 3 | 4x4 | Permit Number 53139; 3-year maintenance agreement through 12/29/12 | 6000915.0 | 2119261.0 | 37.7991372104515 | -122.440943166878 | (37.7991372104515, -122.440943166878) |
109180 | 109180 | 102635 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2176 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 02/08/2013 12:00:00 AM | 3 | 5x5 | Permit Number 769974 | 6006850.0 | 2105688.0 | 37.7622052831774 | -122.41944256138001 | (37.7622052831774, -122.41944256138) |
109167 | 109167 | 97897 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 375X Precita Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 3 | 3x3 | 6008901.5 | 2100225.6 | 37.7473220995732 | -122.411961145064 | (37.7473220995732, -122.411961145064) | ||
108228 | 108228 | 106878 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 180X SAN MARCOS AVE | 1 | Median : Cutout 11 | Tree 1 | Private 1 | DPW 4 | 26 | 5993452.8 | 2100406.9 | 37.746941053663505 | -122.46539437233801 | (37.7469410536635, -122.465394372338) | |||
108200 | 108200 | 97586 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 285 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 6001769.0 | 2109329.0 | 37.771915080469 | -122.437276497302 | (37.771915080469, -122.437276497302) | |||
108016 | 108016 | 28093 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 508 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3X3 | 6001722.1241568 | 2110151.9438084 | 37.7741720139963 | -122.43749758605 | (37.7741720139963, -122.43749758605) | ||
107934 | 107934 | 95238 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1220 Noe St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 3x3 | 6002897.4 | 2101092.2 | 37.7493628934568 | -122.432784769514 | (37.7493628934568, -122.432784769514) | |||
107842 | 107842 | 100984 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 2190 Powell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257168998 | (37.8045319114054, -122.41088257169) | |||
106828 | 106828 | 24629 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 616 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 12/06/2006 12:00:00 AM | 3 | 3x3 | 6001670.9205271 | 2110518.3359108996 | 37.7751751237236 | -122.437700953995 | (37.7751751237236, -122.437700953995) | |
106746 | 106746 | 97598 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 701X Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 4x3 | 6001578.0 | 2110798.0 | 37.7759377272515 | -122.438042423333 | (37.7759377272515, -122.438042423333) | ||
106272 | 106272 | 115004 | Private 5 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1050 MCALLISTER ST | 1 | Front Yard : Cutout 8 | Tree 1 | Office of Mayor 21 | DPW 4 | 01/19/2016 09:19:00 AM | 3 | 3x3 | 6004148.0 | 2111858.0 | 37.778994045300706 | -122.42922772691401 | (37.7789940453007, -122.429227726914) | |
106116 | 106116 | 109995 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 501X Shotwell St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | |||
105955 | 105955 | 24643 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 801X Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/04/2010 12:00:00 AM | 3 | 4x4 | 6001519.6000152 | 2111126.7877173 | 37.776837174254 | -122.438268003206 | (37.776837174254, -122.438268003206) | |
105652 | 105652 | 98659 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2110 Greenwich St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 20 | 7x7 | 6002683.8 | 2119245.6 | 37.799195508176105 | -122.434821422435 | (37.7991955081761, -122.434821422435) | ||
104559 | 104559 | 114737 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 455x LILY ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW for City Agency 10 | DPW 4 | 6004484.0 | 2109981.0 | 37.77385927942 | -122.427931581119 | (37.77385927942, -122.427931581119) | ||||
104363 | 104363 | 24644 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 845 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 12/17/2001 12:00:00 AM | 3 | 3X3 | 6001484.9123945 | 2111282.0018462 | 37.7772613801811 | -122.43839912079099 | (37.7772613801811, -122.438399120791) | |
103701 | 103701 | 96466 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2001 Market St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | |||
101889 | 101889 | 95411 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2815 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 1 | 3x3 | Planted by Glen Park Library; will become DPW maintained. | 6002467.0 | 2095594.0 | 37.734241695714005 | -122.43388015504499 | (37.734241695714, -122.433880155045) | |
100514 | 100514 | 97565 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 258 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 6001879.6 | 2109184.5 | 37.7715246060424 | -122.43688357823 | (37.7715246060424, -122.43688357823) | |||
100355 | 100355 | 116620 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 1 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 12 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | ||
99549 | 99549 | 97896 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 375X Precita Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 3 | 3x3 | 6008901.5 | 2100225.6 | 37.7473220995732 | -122.411961145064 | (37.7473220995732, -122.411961145064) | ||
98906 | 98906 | 116629 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 10 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
98455 | 98455 | 97903 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 375X Precita Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 3 | 3x3 | 6008901.5 | 2100225.6 | 37.7473220995732 | -122.411961145064 | (37.7473220995732, -122.411961145064) | ||
97910 | 97910 | 100983 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 2190 Powell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257168998 | (37.8045319114054, -122.41088257169) | |||
97325 | 97325 | 97901 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 375X Precita Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 6 | 3x3 | 6008901.5 | 2100225.6 | 37.7473220995732 | -122.411961145064 | (37.7473220995732, -122.411961145064) | ||
96961 | 96961 | 97902 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 375X Precita Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 6 | 3x3 | 6008901.5 | 2100225.6 | 37.7473220995732 | -122.411961145064 | (37.7473220995732, -122.411961145064) | ||
96632 | 96632 | 116628 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 9 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
96184 | 96184 | 102636 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2176 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 02/08/2013 12:00:00 AM | 3 | 5x5 | Permit Number 769974 | 6006850.0 | 2105688.0 | 37.7622052831774 | -122.41944256138001 | (37.7622052831774, -122.41944256138) |
96077 | 96077 | 104157 | Permitted Site 1 | :: 54 | 525X Church St | 5 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x20 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
95556 | 95556 | 104158 | Permitted Site 1 | :: 54 | 525X Church St | 6 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x20 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
95495 | 95495 | 104151 | Permitted Site 1 | :: 54 | 525X Church St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | SFUSD 4 | DPW 4 | 2x58 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
95046 | 95046 | 109987 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 501X Shotwell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) |
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");