Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSpecies, qAddress, SiteOrder, PlantType, PlantDate, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 740 | 740 | 26411 | DPW Maintained 3 | Pittosporum eugenioides :: Tarata 110 | 34 Maple St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3 | 10 | 5996554.84409 | 2116119.62648 | 37.7902625562289 | -122.45580349675699 | (37.7902625562289, -122.455803496757) | |||
| 821 | 821 | 251392 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Bosworth St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | Width 3ft | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | ||||
| 843 | 843 | 216491 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Bosworth St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 01/29/1998 12:00:00 AM | 0 | Width 3ft | 6001764.68694 | 2095507.97765 | 37.733965618424 | -122.43630211726601 | (37.733965618424, -122.436302117266) | ||
| 1664 | 1664 | 26404 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 34 Maple St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3 | 10 | 5996581.1026099995 | 2115987.02812 | 37.7898999837554 | -122.455703055979 | (37.7898999837554, -122.455703055979) | |||
| 4439 | 4439 | 26408 | DPW Maintained 3 | Cedrus deodara :: Deodar Cedar 129 | 34 Maple St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3 | 10 | 5996561.99823 | 2116111.6508299997 | 37.7902410678174 | -122.45577816732599 | (37.7902410678174, -122.455778167326) | |||
| 4446 | 4446 | 253627 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 44 Stonecrest Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3x3 | 5991061.0 | 2093828.0 | 37.7287388406121 | -122.4731851996 | (37.7287388406121, -122.4731851996) | ||||
| 4530 | 4530 | 26410 | DPW Maintained 3 | Pittosporum eugenioides :: Tarata 110 | 34 Maple St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3 | 10 | 5996557.377619999 | 2116117.2149400003 | 37.790256080189295 | -122.455794556583 | (37.7902560801893, -122.455794556583) | |||
| 4532 | 4532 | 253201 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 800 Oak St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | Private 3 | 6x6 | 6003064.0 | 2109976.0 | 37.77376511482 | -122.43284323125299 | (37.77376511482, -122.432843231253) | |||
| 4536 | 4536 | 253202 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 800 Oak St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | Private 3 | 6x6 | 6003064.0 | 2109976.0 | 37.77376511482 | -122.43284323125299 | (37.77376511482, -122.432843231253) | |||
| 4538 | 4538 | 253635 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 830 Oak St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 02/22/2008 12:00:00 AM | 6003018.63904 | 2109969.70237 | 37.7737452502421 | -122.43299969185101 | (37.7737452502421, -122.432999691851) | ||||
| 4541 | 4541 | 253199 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 800 Oak St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | Private 3 | 6x6 | 6003064.0 | 2109976.0 | 37.77376511482 | -122.43284323125299 | (37.77376511482, -122.432843231253) | |||
| 4545 | 4545 | 253200 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 800 Oak St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | Private 3 | 6x6 | 6003064.0 | 2109976.0 | 37.77376511482 | -122.43284323125299 | (37.77376511482, -122.432843231253) | |||
| 4548 | 4548 | 253634 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 830 Oak St | 1 | Sidewalk: Property side : Cutout 5 | tree 3 | DPW 2 | 6003018.63904 | 2109969.70237 | 37.7737452502421 | -122.43299969185101 | (37.7737452502421, -122.432999691851) | |||||
| 5088 | 5088 | 206891 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1675x 15th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 24 | Width 3ft | 5991393.559640001 | 2103864.47578 | 37.756315678748706 | -122.472767037095 | (37.7563156787487, -122.472767037095) | |||
| 5678 | 5678 | 26407 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 34 Maple St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3 | 10 | 5996568.426030001 | 2116078.0273700003 | 37.7901491157315 | -122.455753496227 | (37.7901491157315, -122.455753496227) | |||
| 7571 | 7571 | 26412 | DPW Maintained 3 | Pittosporum eugenioides :: Tarata 110 | 34 Maple St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3 | 10 | 5996536.01908 | 2116115.1957 | 37.7902493101054 | -122.455868309095 | (37.7902493101054, -122.455868309095) | |||
| 8270 | 8270 | 26409 | DPW Maintained 3 | Pittosporum eugenioides :: Tarata 110 | 34 Maple St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3 | 10 | 5996561.54746 | 2116120.98746 | 37.790266677821 | -122.45578040214599 | (37.790266677821, -122.455780402146) | |||
| 8439 | 8439 | 19025 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 3170 Sacramento St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 8 | 2X2 | 5999621.132119999 | 2115414.4338700003 | 37.7885017807754 | -122.445143681435 | (37.7885017807754, -122.445143681435) | |||
| 8634 | 8634 | 26406 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 34 Maple St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3 | 10 | 5996571.148159999 | 2116042.19518 | 37.79005088639771 | -122.45574148670099 | (37.7900508863977, -122.455741486701) | |||
| 8973 | 8973 | 26405 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 34 Maple St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3 | 10 | 5996577.84585 | 2116013.8842599997 | 37.7899735365954 | -122.455716266094 | (37.7899735365954, -122.455716266094) | |||
| 10214 | 10214 | 173907 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2200 Jerrold Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 6012443.0 | 2099218.0 | 37.7447535037256 | -122.399644080592 | (37.7447535037256, -122.399644080592) | |||||
| 10957 | 10957 | 17580 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 3x3 | 6003780.63082 | 2090335.5596900003 | 37.719877649504205 | -122.428963734788 | (37.7198776495042, -122.428963734788) | |||
| 11152 | 11152 | 17582 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 3x3 | 6003762.13068 | 2090345.22062 | 37.7199031291015 | -122.42902837176202 | (37.7199031291015, -122.429028371762) | |||
| 11319 | 11319 | 17589 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 3x3 | 6003683.23846 | 2090394.91559 | 37.720035114503006 | -122.42930461652 | (37.720035114503, -122.42930461652) | |||
| 11996 | 11996 | 17591 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 30 | 3x3 | 6003659.63671 | 2090407.2266799998 | 37.7200675818369 | -122.42938707716299 | (37.7200675818369, -122.429387077163) | |||
| 12305 | 12305 | 17584 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 3x3 | 6003740.32149 | 2090358.06458 | 37.7199371612464 | -122.42910467385201 | (37.7199371612464, -122.429104673852) | |||
| 12769 | 12769 | 17578 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 3x3 | 6003799.63122 | 2090323.6743700001 | 37.7198460905006 | -122.428897210135 | (37.7198460905006, -122.428897210135) | |||
| 12852 | 12852 | 17587 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 35 | 3X3 | 6003703.481380001 | 2090378.19842 | 37.7199903588363 | -122.42923345225901 | (37.7199903588363, -122.429233452259) | |||
| 13246 | 13246 | 187614 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 100 Castro St | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3x3 | 6002192.0 | 2107639.0 | 37.767298794762 | -122.43569238083799 | (37.767298794762, -122.435692380838) | ||||
| 13247 | 13247 | 187613 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 100 Castro St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3x3 | 6002192.0 | 2107639.0 | 37.767298794762 | -122.43569238083799 | (37.767298794762, -122.435692380838) | ||||
| 13248 | 13248 | 187615 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 100 Castro St | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3x3 | 6002192.0 | 2107639.0 | 37.767298794762 | -122.43569238083799 | (37.767298794762, -122.435692380838) | ||||
| 13249 | 13249 | 187612 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 100 Castro St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3x3 | 6002192.0 | 2107639.0 | 37.767298794762 | -122.43569238083799 | (37.767298794762, -122.435692380838) | ||||
| 14134 | 14134 | 104461 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1601X Kansas St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 4 | 3x6 | 6011834.442419999 | 2100473.73914 | 37.748167551187 | -122.401836621487 | (37.748167551187, -122.401836621487) | |||
| 14398 | 14398 | 104044 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1601X Kansas St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 70 | 9x9 | 6011818.89895 | 2100809.64818 | 37.749089017243904 | -122.401913980245 | (37.7490890172439, -122.401913980245) | |||
| 14780 | 14780 | 104045 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1601X Kansas St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 4 | 3x6 | 6011820.27046 | 2100794.2900099996 | 37.7490469235803 | -122.40190815805 | (37.7490469235803, -122.40190815805) | |||
| 15106 | 15106 | 104458 | DPW Maintained 3 | Betula pendula :: European White Birch 146 | 1601X Kansas St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 4 | 3x6 | 6011832.95066 | 2100589.70632 | 37.748485888729206 | -122.40184993054501 | (37.7484858887292, -122.401849930545) | |||
| 15361 | 15361 | 104046 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1601X Kansas St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 4 | 3x6 | 6011820.47885 | 2100780.87152 | 37.7490100909441 | -122.401906494295 | (37.7490100909441, -122.401906494295) | |||
| 15563 | 15563 | 104460 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1601X Kansas St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 4 | 3x6 | 6011835.24913 | 2100548.938 | 37.7483740760146 | -122.401839117097 | (37.7483740760146, -122.401839117097) | |||
| 21052 | 21052 | 16925 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 512 Oak St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 25 | 6004419.62206 | 2110173.45228 | 37.7743840640969 | -122.42816799305099 | (37.7743840640969, -122.428167993051) | ||||
| 22233 | 22233 | 16926 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 514 Oak St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 3X3 | 6004391.58115 | 2110176.00513 | 37.774389487009 | -122.42826517381201 | (37.774389487009, -122.428265173812) | |||
| 23146 | 23146 | 18396 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 8 | 3X3 | 6010579.89975 | 2102879.8481400004 | 37.7547041035309 | -122.406344319459 | (37.7547041035309, -122.406344319459) | |||
| 23258 | 23258 | 18405 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 15 | 3X3 | 6010556.98057 | 2103355.2247200003 | 37.756008099814295 | -122.406457075558 | (37.7560080998143, -122.406457075558) | |||
| 23324 | 23324 | 18403 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 01/14/1991 12:00:00 AM | 10 | 3X3 | 6010561.22501 | 2103261.37452 | 37.7557506454989 | -122.406435784089 | (37.7557506454989, -122.406435784089) | ||
| 46604 | 46604 | 2135 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 24 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 24 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 60904 | 60904 | 16944 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 599X Oak St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 20 | 3x3 | 6004143.777734599 | 2110082.9014722 | 37.774119822677996 | -122.429115732545 | (37.774119822678, -122.429115732545) | |||
| 78294 | 78294 | 24522 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 45 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 79080 | 79080 | 2058 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Bosworth St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 06/08/1992 12:00:00 AM | 22 | 3X3 | 6001908.8431877 | 2095495.9697001998 | 37.7339408370986 | -122.43580286684099 | (37.7339408370986, -122.435802866841) | ||
| 79829 | 79829 | 26416 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 34 Maple St | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3 | 10 | 5996568.2197254 | 2116061.2858977 | 37.790103136313206 | -122.455752999345 | (37.7901031363132, -122.455752999345) | |||
| 80242 | 80242 | 24613 | DPW Maintained 3 | Corymbia citriodora :: Lemon Scented Gum 301 | 1735 Mission St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 24 | 6x7 | 6006758.7391800005 | 2108085.91697 | 37.768784258651706 | -122.419928366315 | (37.7687842586517, -122.419928366315) | |||
| 81940 | 81940 | 27502 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 198X LAKE ST | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 15 | 3X3 | 5995045.0 | 2114905.0 | 37.786840755254204 | -122.46093934021002 | (37.7868407552542, -122.46093934021) | |||
| 82530 | 82530 | 14583 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1159 Masonic Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 60 | 4X4 | 5999386.3171 | 2108834.4593 | 37.7704214603588 | -122.445482773554 | (37.7704214603588, -122.445482773554) | |||
| 82755 | 82755 | 2119 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 82883 | 82883 | 92052 | DPW Maintained 3 | Betula nigra :: River Birch 266 | 2323 Cesar Chavez St | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 05/16/2009 12:00:00 AM | 6012395.8634440005 | 2100936.77011 | 37.749470250033795 | -122.399927744224 | (37.7494702500338, -122.399927744224) | |||||
| 84691 | 84691 | 21808 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2600X Taylor St | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 03/01/2016 12:00:00 AM | 3 | 4x4 | 6008553.39113 | 2121935.04647 | 37.806911549800795 | -122.414700989571 | (37.8069115498008, -122.414700989571) | ||
| 88044 | 88044 | 10731 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100 Hudson Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 3X4 | 6018138.790397401 | 2094650.7890521 | 37.7325287066123 | -122.379631682873 | (37.7325287066123, -122.379631682873) | |||
| 92247 | 92247 | 10776 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1120X Hudson Ave | 50 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 10/26/2011 12:00:00 AM | 3 | 3x4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | ||
| 93747 | 93747 | 26415 | DPW Maintained 3 | Cupressus sempervirens :: Italian Cypress 136 | 34 Maple St | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3 | 10 | 5996568.2197254 | 2116061.2858977 | 37.790103136313206 | -122.455752999345 | (37.7901031363132, -122.455752999345) | |||
| 94842 | 94842 | 21807 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2600X Taylor St | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 03/01/2016 12:00:00 AM | 3 | 3X3 | 6008553.39113 | 2121935.04647 | 37.806911549800795 | -122.414700989571 | (37.8069115498008, -122.414700989571) | ||
| 95381 | 95381 | 10763 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 21 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 22 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 95857 | 95857 | 2117 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 96353 | 96353 | 104459 | DPW Maintained 3 | Tree(s) :: 17 | 1601X Kansas St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 4 | 3x6 | 6011789.30586 | 2100707.09327 | 37.748805772054 | -122.402009105448 | (37.748805772054, -122.402009105448) | |||
| 99878 | 99878 | 6102 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500X 08th St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 6 | 18 | 6010526.812454099 | 2109340.6023904 | 37.772440902057795 | -122.406983260044 | (37.7724409020578, -122.406983260044) | |||
| 100446 | 100446 | 2113 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 100546 | 100546 | 2062 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Bosworth St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 14 | 3X3 | 6001908.8431877 | 2095495.9697001998 | 37.7339408370986 | -122.43580286684099 | (37.7339408370986, -122.435802866841) | |||
| 101382 | 101382 | 108685 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 301X CHESTER AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 5991720.0 | 2087146.0 | 37.7104298409998 | -122.47042057923099 | (37.7104298409998, -122.470420579231) | ||||
| 101916 | 101916 | 26413 | DPW Maintained 3 | Cupressus sempervirens :: Italian Cypress 136 | 34 Maple St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3 | 10 | 5996568.2197254 | 2116061.2858977 | 37.790103136313206 | -122.455752999345 | (37.7901031363132, -122.455752999345) | |||
| 103041 | 103041 | 16943 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 599X Oak St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 3x3 | 6004143.777734599 | 2110082.9014722 | 37.774119822677996 | -122.429115732545 | (37.774119822678, -122.429115732545) | |||
| 103627 | 103627 | 2130 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 19 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 103686 | 103686 | 10735 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100 Hudson Ave | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 3x4 | 6018138.790397401 | 2094650.7890521 | 37.7325287066123 | -122.379631682873 | (37.7325287066123, -122.379631682873) | |||
| 103746 | 103746 | 10775 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1120X Hudson Ave | 48 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 3 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | ||
| 105424 | 105424 | 26414 | DPW Maintained 3 | Cupressus sempervirens :: Italian Cypress 136 | 34 Maple St | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3 | 10 | 5996568.2197254 | 2116061.2858977 | 37.790103136313206 | -122.455752999345 | (37.7901031363132, -122.455752999345) | |||
| 106968 | 106968 | 2121 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 06/01/2000 12:00:00 AM | 3 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | |||
| 110122 | 110122 | 14584 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1159 Masonic Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 100 | 4x4 | 5999323.48045 | 2108827.83023 | 37.7703996711999 | -122.445699648114 | (37.7703996711999, -122.445699648114) | |||
| 111836 | 111836 | 2071 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 900X Bosworth St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 20 | 3X3 | 6001652.8683327995 | 2095576.0345146998 | 37.734146132831796 | -122.436693577752 | (37.7341461328318, -122.436693577752) | |||
| 114504 | 114504 | 10774 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 39 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 6 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 119405 | 119405 | 6105 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500X 08th St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3 | 18 | 6010526.812454099 | 2109340.6023904 | 37.772440902057795 | -122.406983260044 | (37.7724409020578, -122.406983260044) | |||
| 120534 | 120534 | 2064 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Bosworth St | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 14 | 3X3 | 6001908.8431877 | 2095495.9697001998 | 37.7339408370986 | -122.43580286684099 | (37.7339408370986, -122.435802866841) | |||
| 122783 | 122783 | 10768 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 23 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 14 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 123207 | 123207 | 10738 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 8 | 3x4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 123607 | 123607 | 16942 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 599X Oak St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 6 | 3x3 | 6004143.777734599 | 2110082.9014722 | 37.774119822677996 | -122.429115732545 | (37.774119822678, -122.429115732545) | |||
| 125132 | 125132 | 2061 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Bosworth St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 8 | 3X3 | 6001908.8431877 | 2095495.9697001998 | 37.7339408370986 | -122.43580286684099 | (37.7339408370986, -122.435802866841) | |||
| 125275 | 125275 | 2132 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 21 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 0 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 125479 | 125479 | 2077 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 900X Bosworth St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 3X3 | 6001652.8683327995 | 2095576.0345146998 | 37.734146132831796 | -122.436693577752 | (37.7341461328318, -122.436693577752) | |||
| 125496 | 125496 | 27503 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 198X LAKE ST | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 25 | 3x3 | 5995045.0 | 2114905.0 | 37.786840755254204 | -122.46093934021002 | (37.7868407552542, -122.46093934021) | |||
| 125511 | 125511 | 2128 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 17 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 125618 | 125618 | 2079 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 900X Bosworth St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 3X3 | 6001652.8683327995 | 2095576.0345146998 | 37.734146132831796 | -122.436693577752 | (37.7341461328318, -122.436693577752) | |||
| 126542 | 126542 | 2074 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 900X Bosworth St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 21 | 3X3 | 6001652.8683327995 | 2095576.0345146998 | 37.734146132831796 | -122.436693577752 | (37.7341461328318, -122.436693577752) | |||
| 126559 | 126559 | 98132 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 47 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 22 | 3x4 | 6017903.8 | 2094987.0 | 37.733438911814 | -122.38046746904399 | (37.733438911814, -122.380467469044) | |||
| 127931 | 127931 | 2101 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000X Bosworth St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 04/09/1990 12:00:00 AM | 14 | 6001184.3961352995 | 2095706.3375319 | 37.7344772801388 | -122.438322562248 | (37.7344772801388, -122.438322562248) | |||
| 128760 | 128760 | 2115 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 138901 | 138901 | 2095 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000X Bosworth St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 15 | 3X3 | 6001184.3961352995 | 2095706.3375319 | 37.7344772801388 | -122.438322562248 | (37.7344772801388, -122.438322562248) | |||
| 139002 | 139002 | 16934 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 534 Oak St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 24 | 3X3 | 6004202.212169999 | 2110156.57626 | 37.774325423266895 | -122.428918851232 | (37.7743254232669, -122.428918851232) | |||
| 140071 | 140071 | 2139 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 28 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 140884 | 140884 | 104457 | DPW Maintained 3 | Tree(s) :: 17 | 1601X Kansas St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 4 | 3x6 | 6011789.30586 | 2100707.09327 | 37.748805772054 | -122.402009105448 | (37.748805772054, -122.402009105448) | |||
| 141733 | 141733 | 10733 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1100 Hudson Ave | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 01/28/2016 08:19:00 AM | 3 | 3x4 | 6018138.790397401 | 2094650.7890521 | 37.7325287066123 | -122.379631682873 | (37.7325287066123, -122.379631682873) | ||
| 141855 | 141855 | 10769 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1120X Hudson Ave | 41 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 8 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 141869 | 141869 | 21804 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2600X Taylor St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 01/22/2016 12:00:00 AM | 12 | 3X3 | 6008553.39113 | 2121935.04647 | 37.806911549800795 | -122.414700989571 | (37.8069115498008, -122.414700989571) | ||
| 143311 | 143311 | 10754 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 17 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 8 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 144479 | 144479 | 10750 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1120X Hudson Ave | 19 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 6 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 144510 | 144510 | 10758 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 43 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) |
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");