Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 95002 | 95002 | 95237 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1220 Noe St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 9 | 3x3 | 6002897.4 | 2101092.2 | 37.7493628934568 | -122.432784769514 | (37.7493628934568, -122.432784769514) | ||
| 94993 | 94993 | 112510 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 699x WILLOW ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW 4 | 2x2 | 6004423.0 | 2113018.0 | 37.7821946822097 | -122.42835909048999 | (37.7821946822097, -122.42835909049) | |||
| 94772 | 94772 | 98675 | Permitted Site 1 | Tree(s) :: 17 | 199X Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 6006189.1 | 2096374.1 | 37.736594195559505 | -122.421067016387 | (37.7365941955595, -122.421067016387) | ||||
| 94262 | 94262 | 106880 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 180X SAN MARCOS AVE | 3 | Median : Cutout 11 | Tree 1 | Private 1 | DPW 4 | 5 | 5993452.8 | 2100406.9 | 37.746941053663505 | -122.46539437233801 | (37.7469410536635, -122.465394372338) | |||
| 93703 | 93703 | 97898 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 375X Precita Ave | 4 | 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) | ||
| 93134 | 93134 | 98908 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 501X Shotwell St | 2 | 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) | |||
| 92935 | 92935 | 104156 | Permitted Site 1 | :: 54 | 525X Church St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x20 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
| 92640 | 92640 | 109986 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 501X Shotwell St | 3 | 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) | |||
| 92075 | 92075 | 111588 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 730X Lake Merced Blvd | 4 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 48 | 5987577.495069999 | 2091187.90071 | 37.7212874908284 | -122.485034126397 | (37.7212874908284, -122.485034126397) | |||
| 90552 | 90552 | 47255 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1035 Gilman Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 05/09/2002 12:00:00 AM | 6 | 3x3 | Permit Number 45198 | 6015368.10493708 | 2089617.80548286 | 37.71855592189279 | -122.388859444456 | (37.7185559218928, -122.388859444456) |
| 90177 | 90177 | 109991 | Undocumented 2 | Quercus spp :: Oak 297 | 501X Shotwell St | 8 | 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) | |||
| 89691 | 89691 | 109988 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 501X Shotwell St | 5 | 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) | |||
| 89354 | 89354 | 111589 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 730X Lake Merced Blvd | 5 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | Permit Number 774260 | 5987577.495069999 | 2091187.90071 | 37.7212874908284 | -122.485034126397 | (37.7212874908284, -122.485034126397) | |||
| 89333 | 89333 | 104727 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1079 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | Permit Number 770313 | 6004450.0 | 2102615.0 | 37.7536320814231 | -122.427524315639 | (37.7536320814231, -122.427524315639) | ||
| 89325 | 89325 | 96464 | 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) | |||
| 89035 | 89035 | 100982 | DPW Maintained 3 | Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 | 2190 Powell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 05/03/2013 12:00:00 AM | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257168998 | (37.8045319114054, -122.41088257169) | ||
| 88343 | 88343 | 97566 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 338 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 6001793.0 | 2109569.0 | 37.7725754250276 | -122.437210666805 | (37.7725754250276, -122.437210666805) | |||
| 87567 | 87567 | 100981 | DPW Maintained 3 | Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 | 2190 Powell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 05/03/2013 12:00:00 AM | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257168998 | (37.8045319114054, -122.41088257169) | ||
| 87276 | 87276 | 112509 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 699x WILLOW ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW 4 | 2x2 | 6004423.0 | 2113018.0 | 37.7821946822097 | -122.42835909048999 | (37.7821946822097, -122.42835909049) | |||
| 87235 | 87235 | 117162 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1383X VERMONT ST | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | DPW 4 | 6011571.0 | 2102081.0 | 37.752566033842896 | -122.40286062573799 | (37.7525660338429, -122.402860625738) | ||||
| 85949 | 85949 | 109996 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 501X Shotwell St | 13 | 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) | |||
| 85658 | 85658 | 96467 | 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) | |||
| 85143 | 85143 | 115005 | Private 5 | Prunus cerasifera :: Cherry Plum 16 | 1050 MCALLISTER ST | 2 | Front Yard : Cutout 8 | Tree 1 | Office of Mayor 21 | DPW 4 | 3x3 | 6004148.0 | 2111858.0 | 37.778994045300706 | -122.42922772691401 | (37.7789940453007, -122.429227726914) | |||
| 84743 | 84743 | 116631 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 12 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 84168 | 84168 | 28096 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 850 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3X3 | 6001561.6093482 | 2111313.2017111 | 37.77735140937129 | -122.43813603744499 | (37.7773514093713, -122.438136037445) | ||
| 83876 | 83876 | 109990 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 501X Shotwell St | 7 | 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) | |||
| 83032 | 83032 | 28101 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 305 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3X3 | 6001749.0605888 | 2109439.6370142 | 37.7722177286516 | -122.437353392664 | (37.7722177286516, -122.437353392664) | ||
| 82894 | 82894 | 24632 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 605 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 10/08/2014 11:30:00 AM | 3 | 3X3 | 6001606.913089 | 2110457.4002288003 | 37.7750041699802 | -122.437918004082 | (37.7750041699802, -122.437918004082) | |
| 81722 | 81722 | 104155 | Permitted Site 1 | :: 54 | 525X Church St | 3 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x17 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
| 81591 | 81591 | 95239 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1220 Noe St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 12 | 6002897.4 | 2101092.2 | 37.7493628934568 | -122.432784769514 | (37.7493628934568, -122.432784769514) | |||
| 81163 | 81163 | 104152 | Permitted Site 1 | :: 54 | 525X Church St | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | SFUSD 4 | DPW 4 | 2x68 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
| 80719 | 80719 | 116576 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 2500x OCEAN AVE | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | DPW 4 | 30 | 10X10 | 5991377.0 | 2094742.0 | 37.7312667472315 | -122.472159374256 | (37.7312667472315, -122.472159374256) | ||
| 80527 | 80527 | 97588 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 327 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 6001736.6 | 2109522.6 | 37.7724448159613 | -122.437402436672 | (37.7724448159613, -122.437402436672) | |||
| 77875 | 77875 | 106884 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 180X SAN MARCOS AVE | 6 | Median : Cutout 11 | Tree 1 | Private 1 | DPW 4 | 4 | 5993452.8 | 2100406.9 | 37.746941053663505 | -122.46539437233801 | (37.7469410536635, -122.465394372338) | |||
| 77610 | 77610 | 109992 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 501X Shotwell St | 9 | 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) | |||
| 74427 | 74427 | 67860 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 01/20/1993 12:00:00 AM | 5 | 5x5 | Permit Number 31536 | 6002806.21719 | 2119247.92289 | 37.7992088356751 | -122.43439798360501 | (37.7992088356751, -122.434397983605) |
| 73429 | 73429 | 34690 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 8 | 3x3 | Permit Number 38352 | 6002819.05677 | 2119313.26082 | 37.7993889653989 | -122.434358228162 | (37.7993889653989, -122.434358228162) |
| 71504 | 71504 | 98651 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2110 Greenwich St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 23 | 5x5 | 6002674.17203 | 2119228.66956 | 37.799148474973705 | -122.434853527066 | (37.7991484749737, -122.434853527066) | ||
| 69366 | 69366 | 93014 | Permitted Site 1 | Tristania conferta :: 79 | 2395 Lombard St | 4 | 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 | 6001021.4146 | 2119265.9756 | 37.7991569323377 | -122.440575294128 | (37.7991569323377, -122.440575294128) |
| 69128 | 69128 | 98649 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 16 | 5x5 | 6002707.76445 | 2119233.0203 | 37.799162328147794 | -122.434737597267 | (37.7991623281478, -122.434737597267) | ||
| 64540 | 64540 | 100974 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 450X Chestnut St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 15 | Permit Number 37341 | 6009596.2838 | 2120888.8532 | 37.8040975034287 | -122.41101789076099 | (37.8040975034287, -122.411017890761) | ||
| 63146 | 63146 | 75990 | Undocumented 2 | Acer saccharinum :: Silver Maple 273 | 350 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 10/07/1995 12:00:00 AM | 3 | 3x3 | 6011912.57037 | 2118781.03793 | 37.7984395708796 | -122.40285383475599 | (37.7984395708796, -122.402853834756) | |
| 62828 | 62828 | 5490 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 714 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 12/28/2015 12:00:00 AM | 1 | 4X4 | Permit Number 774286 | 6004953.58017 | 2104162.27117 | 37.757908995925206 | -122.425892952911 | (37.7579089959252, -122.425892952911) |
| 61687 | 61687 | 97564 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 252 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) | |||
| 61243 | 61243 | 34693 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 9 | 3x3 | Permit Number 38352 | 6002813.73545 | 2119366.57801 | 37.799535058456 | -122.43438045581301 | (37.799535058456, -122.434380455813) |
| 59125 | 59125 | 100975 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 450X Chestnut St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 11 | Permit Number 37341 | 6009580.8633 | 2120886.4184 | 37.8040899533369 | -122.411071082632 | (37.8040899533369, -122.411071082632) | ||
| 58682 | 58682 | 116625 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 6 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 57285 | 57285 | 100977 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 450X Chestnut St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 3 | Permit Number 37341 | 6009542.7178 | 2120879.1139 | 37.8040677578058 | -122.411202572075 | (37.8040677578058, -122.411202572075) | ||
| 55605 | 55605 | 100978 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 450X Chestnut St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 5 | Permit Number 37341 | 6009524.0508 | 2120877.4907 | 37.8040622540071 | -122.41126705605801 | (37.8040622540071, -122.411267056058) | ||
| 53064 | 53064 | 98650 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 11 | 5x5 | 6002693.158 | 2119231.9709099997 | 37.799158617543604 | -122.43478806542801 | (37.7991586175436, -122.434788065428) | ||
| 52422 | 52422 | 34688 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 7 | 3x3 | Permit Number 38352 | 6002815.38185 | 2119347.35443 | 37.7994823689702 | -122.434373383533 | (37.7994823689702, -122.434373383533) |
| 47263 | 47263 | 100971 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 450X Chestnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 4 | Permit Number 37341 | 6009642.5454 | 2120895.3461 | 37.8041179253888 | -122.410858257388 | (37.8041179253888, -122.410858257388) | ||
| 44207 | 44207 | 98648 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 9 | 5x5 | 6002730.0885 | 2119237.75472 | 37.7991765949935 | -122.434660687245 | (37.7991765949935, -122.434660687245) | ||
| 44053 | 44053 | 97599 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 857 Divisadero St | 1 | 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) | ||
| 40243 | 40243 | 100970 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 450X Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 9 | Permit Number 37341 | 6009657.9659 | 2120896.9693 | 37.804123246932896 | -122.41080500812201 | (37.8041232469329, -122.410805008122) | ||
| 33915 | 33915 | 98646 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 8 | 5x5 | 6002771.23879 | 2119243.65965 | 37.799195144410795 | -122.43451871576099 | (37.7991951444108, -122.434518715761) | ||
| 31571 | 31571 | 98656 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 8 | 5x5 | 6002629.88193 | 2119221.45898 | 37.799126161900396 | -122.435006269744 | (37.7991261619004, -122.435006269744) | ||
| 28447 | 28447 | 116579 | Significant Tree 6 | Shrub :: Shrub 98 | 3000x 19TH AVE | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5990602.0 | 2095184.0 | 37.7324354869182 | -122.47487091251001 | (37.7324354869182, -122.47487091251) | |||
| 28296 | 28296 | 33101 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 450X Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 11/01/1997 12:00:00 AM | 14 | Permit Number 37341 | 6009682.3141 | 2120901.0273 | 37.804135754366996 | -122.410721035819 | (37.804135754367, -122.410721035819) | |
| 26614 | 26614 | 98657 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 11 | 5x5 | 6002607.56666 | 2119218.5959900003 | 37.7991170337862 | -122.43508328318701 | (37.7991170337862, -122.435083283187) | ||
| 22149 | 22149 | 16024 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 130 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 12/29/2015 12:00:00 AM | 3 | 3X3 | Permit Number 776129 | 6001188.36813 | 2094689.80455 | 37.731686341545206 | -122.43823603107799 | (37.7316863415452, -122.438236031078) |
| 22018 | 22018 | 24636 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 443 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 06/17/2014 12:00:00 AM | 3 | 3X4 | 6001673.68932 | 2109984.60324 | 37.773709784823296 | -122.437653143592 | (37.7737097848233, -122.437653143592) | |
| 20046 | 20046 | 5155 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 265 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 12/17/2001 12:00:00 AM | 3 | 3X3 | 6001777.3063 | 2109242.3472 | 37.7716776256193 | -122.43724155970399 | (37.7716776256193, -122.437241559704) | |
| 18577 | 18577 | 5154 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 259 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3X3 | 6001780.9624 | 2109220.4101 | 37.771617599631604 | -122.43722734206499 | (37.7716175996316, -122.437227342065) | ||
| 18219 | 18219 | 5158 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 275 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 03/27/1990 12:00:00 AM | 3 | 3X3 | 6001773.6501 | 2109268.6052 | 37.771749515715605 | -122.437256087151 | (37.7717495157156, -122.437256087151) | |
| 17669 | 17669 | 5170 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 318 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 02/15/2005 12:00:00 AM | 3 | 3X3 | 6001801.5136 | 2109559.6859 | 37.7725503347821 | -122.43718055043101 | (37.7725503347821, -122.437180550431) | |
| 17572 | 17572 | 5174 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 350 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 11/28/2006 12:00:00 AM | 3 | 3x4 | 6001785.2321 | 2109677.0482 | 37.7728716568906 | -122.437245274575 | (37.7728716568906, -122.437245274575) | |
| 15949 | 15949 | 103659 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 3 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 12885 | 12885 | 103661 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 5 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 12113 | 12113 | 103660 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 4 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 12092 | 12092 | 77648 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 01/01/2011 12:00:00 AM | 3 | 3x3 | 6006817.147419999 | 2093142.9824700002 | 37.727757638780204 | -122.418666516263 | (37.7277576387802, -122.418666516263) | |
| 11415 | 11415 | 103667 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 6 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 11212 | 11212 | 103658 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 2 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 10665 | 10665 | 103665 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 4 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 10038 | 10038 | 96503 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 2360X Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 3x3 | 6008639.8 | 2104954.0 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | |||
| 9684 | 9684 | 173630 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 2699x OCEAN AVE | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5990602.0 | 2095184.0 | 37.7324354869182 | -122.47487091251001 | (37.7324354869182, -122.47487091251) | |||
| 8431 | 8431 | 97593 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 661 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 6001569.9782 | 2110730.4395 | 37.7757517668907 | -122.438065332169 | (37.7757517668907, -122.438065332169) | |||
| 8408 | 8408 | 103664 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 3 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 8394 | 8394 | 97584 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 818 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3x3 | 6001564.5243 | 2111243.3358 | 37.777159740959895 | -122.43812094768101 | (37.7771597409599, -122.438120947681) | ||
| 8311 | 8311 | 5206 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 793 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/10/1993 12:00:00 AM | 3 | 4X4 | 6001519.3329 | 2111090.328 | 37.7767370498578 | -122.438266314655 | (37.7767370498578, -122.438266314655) | |
| 8303 | 8303 | 97591 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 501 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 4x3 | 6001649.1323 | 2110166.4258 | 37.7742076278049 | -122.43775111477899 | (37.7742076278049, -122.437751114779) | ||
| 8197 | 8197 | 103668 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 6 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 8085 | 8085 | 5202 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 740 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 02/15/2005 12:00:00 AM | 3 | 3X4 | 6001595.2588 | 2111007.3853 | 37.7765136281427 | -122.437997722367 | (37.7765136281427, -122.437997722367) | |
| 7872 | 7872 | 97569 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 542 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 6001690.505 | 2110331.7687 | 37.7746639704386 | -122.437619843013 | (37.7746639704386, -122.437619843013) | |||
| 7792 | 7792 | 97581 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 736 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3x3 | 6001597.3606 | 2110988.4698 | 37.776461810461704 | -122.43798909643101 | (37.7764618104617, -122.437989096431) | ||
| 7764 | 7764 | 103662 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 1 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 7681 | 7681 | 103657 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 1 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 7506 | 7506 | 14836 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1300 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 10/22/2008 12:00:00 AM | 9 | 3X3 | 6002892.8097 | 2111692.1261 | 37.7784674596438 | -122.43355807318501 | (37.7784674596438, -122.433558073185) | |
| 7406 | 7406 | 97595 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 793 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 4x4 | 6001524.4178 | 2111055.242 | 37.7766410017417 | -122.438246210395 | (37.7766410017417, -122.438246210395) | ||
| 6760 | 6760 | 24628 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 536 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 03/27/1990 12:00:00 AM | 3 | 3X3 | 6001694.2572 | 2110311.9357 | 37.774609727324204 | -122.437605442785 | (37.7746097273242, -122.437605442785) | |
| 6072 | 6072 | 24616 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 830 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 03/27/1990 12:00:00 AM | 3 | 3X3 | 6001554.3804 | 2111297.3519 | 37.777307478654706 | -122.438159908991 | (37.7773074786547, -122.438159908991) | |
| 6000 | 6000 | 28097 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 661 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3X3 | 6001567.17 | 2110752.9686 | 37.7758134664372 | -122.438076660597 | (37.7758134664372, -122.438076660597) | ||
| 5886 | 5886 | 5187 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 505 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3X3 | 6001641.6836 | 2110218.0701 | 37.7743490065847 | -122.43778058071699 | (37.7743490065847, -122.437780580717) | ||
| 5874 | 5874 | 97590 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 559 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3x3 | 6001615.3648 | 2110410.2466 | 37.774875178544995 | -122.437885389718 | (37.774875178545, -122.437885389718) | ||
| 5871 | 5871 | 97602 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 833 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3xe | 6001492.376 | 2111306.2278 | 37.777328323069796 | -122.438375037891 | (37.7773283230698, -122.438375037891) | ||
| 5735 | 5735 | 28095 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 650 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 12/06/2006 12:00:00 AM | 3 | 3x3 | 6001636.0563 | 2110732.7869 | 37.775761969914896 | -122.437836920035 | (37.7757619699149, -122.437836920035) | |
| 5728 | 5728 | 97579 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 628 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3x3 | 6001646.5608 | 2110651.222 | 37.7755386104847 | -122.437794739235 | (37.7755386104847, -122.437794739235) | ||
| 5598 | 5598 | 103666 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 5 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 5239 | 5239 | 253830 | Permitted Site 1 | :: 54 | 651X Polk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | ||||||||
| 5238 | 5238 | 169219 | Permitted Site 1 | Potential Site :: Potential Site 29 | 840 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 0 | 3x3 | 6006827.36035 | 2113629.7400599997 | 37.7840101293977 | -122.42008449353001 | (37.7840101293977, -122.42008449353) |
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");