Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCareAssistant, DBH
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 186618 | 186618 | 115552 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 925x Minnesota St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 15x7 | 6015276.56251 | 2104229.2059299997 | 37.7586707630633 | -122.390196112573 | (37.7586707630633, -122.390196112573) | ||
| 184785 | 184785 | 113031 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 251 06th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 14 | 3x3 | 5993971.49407 | 2113867.66105 | 37.7839306754778 | -122.464578040665 | (37.7839306754778, -122.464578040665) | |||
| 183769 | 183769 | 95151 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 13 | 5988720.99449 | 2113605.53219 | 37.7829068638151 | -122.482723403965 | (37.7829068638151, -122.482723403965) | |||
| 183247 | 183247 | 98791 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 950 Clay St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 1 | 3x6 | Permit Number 768771 | 6010164.1906 | 2117196.54488 | 37.7939911598214 | -122.408791948484 | (37.7939911598214, -122.408791948484) | |
| 180919 | 180919 | 115549 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 925x Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 18 | 20x7 | 6015281.58054 | 2104112.34112 | 37.7583501556473 | -122.390170593412 | (37.7583501556473, -122.390170593412) | ||
| 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) | ||
| 177652 | 177652 | 115972 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1599x 30th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 8 | 3x3 | 5986817.4474 | 2104547.1317 | 37.757924098588795 | -122.488642781125 | (37.7579240985888, -122.488642781125) | |||
| 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) |
| 175061 | 175061 | 115966 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1599x 30th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | 3x3 | 5986811.649 | 2104717.0256 | 37.7583902423484 | -122.488675321582 | (37.7583902423484, -122.488675321582) | |||
| 174085 | 174085 | 43304 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 693 Vermont St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/12/2000 12:00:00 AM | 19 | Permit Number 43072 | 6011287.96925 | 2105166.37556 | 37.7610219838923 | -122.404056515205 | (37.7610219838923, -122.404056515205) | |
| 172027 | 172027 | 116857 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 950x Clay St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 2 | 3x3 | 6010080.350930001 | 2117187.65635 | 37.793962057763 | -122.409081415981 | (37.793962057763, -122.409081415981) | ||
| 172003 | 172003 | 98805 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 950x Clay St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/16/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768771 | 6010143.10639 | 2117195.10642 | 37.793986029186 | -122.408864800763 | (37.793986029186, -122.408864800763) |
| 170121 | 170121 | 116065 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 693 Vermont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 20 | 8x7 | 6011274.01561 | 2105377.63125 | 37.761601265113896 | -122.404119643106 | (37.7616012651139, -122.404119643106) | ||
| 168957 | 168957 | 116048 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 650x Kansas St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 4x4 | 6011498.51602 | 2105372.79225 | 37.7616005195649 | -122.403342842915 | (37.7616005195649, -122.403342842915) | ||
| 168456 | 168456 | 115973 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1599x 30TH AVE | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 0 | 3x3 | 5986686.0 | 2104596.0 | 37.7580506061519 | -122.489100968136 | (37.7580506061519, -122.489100968136) | |||
| 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) |
| 166938 | 166938 | 116059 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2100x 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 2 | 3x3 | 6011431.5308 | 2105131.75607 | 37.760934946603605 | -122.40355755965099 | (37.7609349466036, -122.403557559651) | ||
| 166820 | 166820 | 110958 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 940 Filbert St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11 | 5x5 | 6008447.06762 | 2119689.6105 | 37.8007401724743 | -122.414909918573 | (37.8007401724743, -122.414909918573) | ||
| 166151 | 166151 | 115971 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1599x 30th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 4 | 3x3 | 5986813.9683 | 2104572.6448 | 37.757993947556 | -122.48865668838499 | (37.757993947556, -122.488656688385) | |||
| 164886 | 164886 | 115968 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1599x 30th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | 3x3 | 5986813.3885 | 2104648.6042 | 37.7582024774349 | -122.48866427663799 | (37.7582024774349, -122.488664276638) | |||
| 163336 | 163336 | 95153 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 18 | 5988721.4522400005 | 2113658.22406 | 37.783051567455004 | -122.482725682991 | (37.783051567455, -122.482725682991) | |||
| 163065 | 163065 | 116050 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 650x Kansas St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 4x4 | 6011499.79329 | 2105331.08163 | 37.76148606285779 | -122.403335490949 | (37.7614860628578, -122.403335490949) | ||
| 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) | ||
| 160302 | 160302 | 115965 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1599x 30th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 7 | 3x3 | 5986811.649 | 2104744.2782 | 37.758465070521105 | -122.488677324697 | (37.7584650705211, -122.488677324697) | |||
| 159681 | 159681 | 73495 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/11/1995 12:00:00 AM | 10 | 5988730.14838 | 2113498.62278 | 37.7826138532986 | -122.482683898749 | (37.7826138532986, -122.482683898749) | ||
| 158398 | 158398 | 116058 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2100x 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 2 | 3x3 | 6011458.59484 | 2105134.56728 | 37.760944177262004 | -122.403464154268 | (37.760944177262, -122.403464154268) | ||
| 158318 | 158318 | 116046 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 650x Kansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4 | 5x15 | 6011495.20108 | 2105434.8979700003 | 37.761770862847705 | -122.40335867726002 | (37.7617708628477, -122.40335867726) | ||
| 156514 | 156514 | 122751 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 693 Vermont St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 18 | 6011280.99043 | 2105260.13165 | 37.7612790272197 | -122.40408725043301 | (37.7612790272197, -122.404087250433) | |||
| 155253 | 155253 | 115550 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 925x Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 18 | 20x7 | 6015279.22506 | 2104155.94994 | 37.7584697654838 | -122.39018178636199 | (37.7584697654838, -122.390181786362) | ||
| 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) | ||
| 152078 | 152078 | 110955 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 940 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 5x5 | 6008486.881990001 | 2119694.39066 | 37.8007555347125 | -122.41477248237699 | (37.8007555347125, -122.414772482377) | ||
| 151441 | 151441 | 70932 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/11/1995 12:00:00 AM | 14 | 5988727.46903 | 2113517.2675099997 | 37.7826648905872 | -122.48269453478301 | (37.7826648905872, -122.482694534783) | ||
| 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) | ||
| 146991 | 146991 | 95155 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 250 23rd Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 16 | 5988718.098730001 | 2113738.3311400004 | 37.7832713237769 | -122.482743157022 | (37.7832713237769, -122.482743157022) | |||
| 146100 | 146100 | 43905 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1050 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 04/26/2002 12:00:00 AM | 6 | 3x3 | Permit Number 43505 | 6009958.09497236 | 2103085.10649041 | 37.755232893914794 | -122.408509176777 | (37.7552328939148, -122.408509176777) |
| 145918 | 145918 | 47257 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1035 Gilman Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/08/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52469 | 6015368.10493708 | 2089617.80548286 | 37.71855592189279 | -122.388859444456 | (37.7185559218928, -122.388859444456) |
| 145909 | 145909 | 42986 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 2X Yale St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/16/2000 12:00:00 AM | 3 | 4x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.41922408324301 | (37.7290063985797, -122.419224083243) |
| 145659 | 145659 | 99685 | DPW Maintained 3 | Tree(s) :: 17 | 165 Grattan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 8 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.45052048585899 | (37.7638673579207, -122.450520485859) | ||
| 145524 | 145524 | 96494 | DPW Maintained 3 | Washingtonia filifera :: California Fan Palm 189 | 2500X Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5x5 | 6008744.0 | 2103690.4 | 37.7568268248396 | -122.412750681409 | (37.7568268248396, -122.412750681409) | |||
| 145453 | 145453 | 95270 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2245 Jones St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/23/2016 02:41:00 PM | 3 | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | ||
| 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) | |
| 145283 | 145283 | 76112 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 380 Webster St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/12/1994 12:00:00 AM | 4 | 3x3 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.42905135835501 | (37.7740034947051, -122.429051358355) | |
| 145208 | 145208 | 95259 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2290X 14th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5992014.7 | 2099861.3 | 37.745359932747 | -122.47032742053699 | (37.745359932747, -122.470327420537) | ||||
| 145137 | 145137 | 77213 | DPW Maintained 3 | Melaleuca ericifolia :: Heath Melaleuca 184 | 499X Hearst Ave | 20 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 8 | 6x50 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
| 145041 | 145041 | 92956 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 300 Seneca Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 12/23/2009 12:00:00 AM | 20 | 3x3 | Permit Number 53118 | 5999177.1 | 2091098.3 | 37.721710307674606 | -122.444931280306 | (37.7217103076746, -122.444931280306) | |
| 145003 | 145003 | 99547 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Henry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 24 | 3x3 | 6002211.6 | 2107376.8 | 37.7665799711801 | -122.435605827147 | (37.7665799711801, -122.435605827147) | ||
| 144911 | 144911 | 76325 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3899X Kirkham St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/14/1994 12:00:00 AM | 5 | 3x20 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) | |
| 144736 | 144736 | 96510 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 2360X Harrison St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954.0 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | ||
| 144522 | 144522 | 95498 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X 32nd Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 18 | 3x3 | 5985976.055430001 | 2112422.37376 | 37.779498166536605 | -122.492132474117 | (37.7794981665366, -122.492132474117) | |||
| 144514 | 144514 | 96603 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 144409 | 144409 | 42358 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 380X Flood Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 5 | 4x4 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
| 144344 | 144344 | 99682 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 165 Grattan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.45052048585899 | (37.7638673579207, -122.450520485859) | ||
| 144331 | 144331 | 99257 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 151X Palm Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 5995884.6314900005 | 2113369.4177200003 | 37.782672735096504 | -122.457923263549 | (37.7826727350965, -122.457923263549) | ||
| 144168 | 144168 | 113470 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 450 CHURCH ST | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6x6 | 6004088.0 | 2106523.0 | 37.764342039298896 | -122.429054808288 | (37.7643420392989, -122.429054808288) | ||||
| 144074 | 144074 | 92957 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 300 Seneca Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 12/23/2009 12:00:00 AM | 20 | 3x3 | Permit Number 53118 | 5999177.1 | 2091098.3 | 37.721710307674606 | -122.444931280306 | (37.7217103076746, -122.444931280306) | |
| 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) | ||
| 143933 | 143933 | 113572 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 901 LOMBARD ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6007968.0 | 2120121.0 | 37.8018977290678 | -122.41659827224701 | (37.8018977290678, -122.416598272247) | |||
| 143508 | 143508 | 95265 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2245 Jones St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | ||||
| 143471 | 143471 | 99669 | DPW Maintained 3 | Tree(s) :: 17 | 150X Alma St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x6 | 5997882.0 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | ||
| 143233 | 143233 | 76675 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 163X London St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 8 | 3x3 | 6002837.0 | 2092721.0 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | |
| 143214 | 143214 | 96582 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 401x Otsego Ave | 7 | 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) | |||
| 143144 | 143144 | 105784 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1570 31ST AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 04/18/2014 12:00:00 AM | Permit Number 772914 | 5986686.8 | 2104596.0 | 37.7580506528461 | -122.489098201432 | (37.7580506528461, -122.489098201432) | |||
| 143137 | 143137 | 76749 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 200X Farallones St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/20/1989 12:00:00 AM | 8 | 3x3 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.45912868181601 | (37.7143256328225, -122.459128681816) | |
| 143015 | 143015 | 75386 | DPW Maintained 3 | Melaleuca ericifolia :: Heath Melaleuca 184 | 163X London St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 10 | 3x3 | 6002837.0 | 2092721.0 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | |
| 142924 | 142924 | 108788 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100-1198X Schwerin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.136580001 | 2087632.54285 | 37.7127552255458 | -122.41039559568199 | (37.7127552255458, -122.410395595682) | |
| 142922 | 142922 | 95471 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4 | 3x3 | 5986558.17112 | 2112222.9767400003 | 37.778984690357 | -122.49010404497 | (37.778984690357, -122.49010404497) | ||
| 142799 | 142799 | 99688 | DPW Maintained 3 | Tree(s) :: 17 | 165 Grattan St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.45052048585899 | (37.7638673579207, -122.450520485859) | ||
| 142763 | 142763 | 98802 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 950x CLAY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/16/2012 12:00:00 AM | 3x3 | Permit Number 768771 | 6010160.0 | 2117472.0 | 37.7947472579955 | -122.408825891367 | (37.7947472579955, -122.408825891367) | |
| 142748 | 142748 | 37835 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 450X Moscow St | 21 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003752.0 | 2090699.0 | 37.720873955994 | -122.42908860130501 | (37.720873955994, -122.429088601305) |
| 142732 | 142732 | 76271 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3899X Kirkham St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/14/1994 12:00:00 AM | 8 | 3x20 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) | |
| 142731 | 142731 | 102192 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3999X Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6008408.0 | 2096514.0 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | ||
| 142697 | 142697 | 99369 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 451X 29th Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12 | 3x3 | 5986847.81361 | 2112672.3215799998 | 37.7802353734381 | -122.489135113122 | (37.7802353734381, -122.489135113122) | ||
| 142663 | 142663 | 42642 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600X GREEN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/26/2000 12:00:00 AM | 5 | 3x3 | 6005364.0 | 2118556.0 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | |
| 142592 | 142592 | 96085 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2290X 14th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5992014.7 | 2099861.3 | 37.745359932747 | -122.47032742053699 | (37.745359932747, -122.470327420537) | ||||
| 142587 | 142587 | 102023 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 165X Chattanooga St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6004753.0 | 2102714.0 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | ||
| 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) | ||
| 142357 | 142357 | 42987 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 2X Yale St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/16/2000 12:00:00 AM | 8 | 4x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.41922408324301 | (37.7290063985797, -122.419224083243) |
| 142333 | 142333 | 99366 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 451X 29th Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 5986848.25067 | 2112734.65735 | 37.7804065552175 | -122.48913818535101 | (37.7804065552175, -122.489138185351) | ||
| 142332 | 142332 | 95517 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 10 | 3x3 | 5985993.99278 | 2111923.13747 | 37.778128454962 | -122.49203365493601 | (37.778128454962, -122.492033654936) | |||
| 142324 | 142324 | 117253 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 2500x 34TH AVE | 3 | Side Yard : Yard 17 | Tree 1 | SFUSD 4 | 3x3 | 5985829.0 | 2097874.0 | 37.73954376030179 | -122.491570003273 | (37.7395437603018, -122.491570003273) | ||||
| 142264 | 142264 | 96605 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 141932 | 141932 | 107886 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 941 Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/03/2014 12:00:00 AM | 3 | 3x3 | Permit Number 771772 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946771999 | (37.7944046419585, -122.40879946772) |
| 141821 | 141821 | 99680 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 165 Grattan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.45052048585899 | (37.7638673579207, -122.450520485859) | ||
| 141815 | 141815 | 98973 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 825 Shotwell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 8 | 3x3 | 6008234.2 | 2102998.9 | 37.754899496003105 | -122.414464835105 | (37.7548994960031, -122.414464835105) | ||
| 141798 | 141798 | 95490 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3 | 3x3 | 5986007.65609 | 2111463.21002 | 37.7768664240251 | -122.49195251911199 | (37.7768664240251, -122.491952519112) | |||
| 141772 | 141772 | 98748 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 540X Eureka St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | ||||
| 141689 | 141689 | 75040 | DPW Maintained 3 | Tree(s) :: 17 | 499X Hearst Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 18 | 6x20 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
| 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) | |||
| 141465 | 141465 | 97247 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 301X Excelsior Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 4x4 | Permit Number 767495 | 6003399.0 | 2092092.0 | 37.7246788362927 | -122.43040815339701 | (37.7246788362927, -122.430408153397) |
| 141315 | 141315 | 98560 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2035X Stockton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257168998 | (37.8045319114054, -122.41088257169) | ||||
| 141236 | 141236 | 112028 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2101x 22nd Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 07/23/2015 12:00:00 AM | 3 | 9x9 | 6011761.0 | 2103726.0 | 37.757093449930004 | -122.402319220858 | (37.75709344993, -122.402319220858) | ||
| 141095 | 141095 | 112061 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1199 VISITACION AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4x4 | 6009231.0 | 2087548.0 | 37.7125305915537 | -122.40992695457899 | (37.7125305915537, -122.409926954579) | |||
| 141032 | 141032 | 96584 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 401x Otsego Ave | 9 | 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) | |||
| 140987 | 140987 | 95489 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | 3x3 | 5986007.8525 | 2111486.5622099997 | 37.7769305539658 | -122.49195355936199 | (37.7769305539658, -122.491953559362) | |||
| 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) | |
| 140800 | 140800 | 47197 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2899X Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/2002 12:00:00 AM | 3 | 3x3 | 5986581.22601267 | 2112881.07204474 | 37.7807929786872 | -122.490072708464 | (37.7807929786872, -122.490072708464) | |
| 140600 | 140600 | 113574 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 901 LOMBARD ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6007968.0 | 2120121.0 | 37.8018977290678 | -122.41659827224701 | (37.8018977290678, -122.416598272247) | |||
| 140524 | 140524 | 107868 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 830X Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6012494.965419999 | 2112152.38808 | 37.7802713603069 | -122.400372718325 | (37.7802713603069, -122.400372718325) | |||||
| 140357 | 140357 | 73285 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600X GREEN ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/20/1999 12:00:00 AM | 13 | 3x3 | 6005364.0 | 2118556.0 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) |
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");