Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qLegalStatus
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10259 | 10259 | 141190 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1771 ELLIS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9999 | Width 0ft | 6002407.0405 | 2112959.471 | 37.781919696317296 | -122.43532920805599 | (37.7819196963173, -122.435329208056) | |||
| 140943 | 140943 | 120977 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 794x Gates St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3030 | 3x3 | 6008103.0 | 2095407.0 | 37.7340464539486 | -122.414381414226 | (37.7340464539486, -122.414381414226) | |||
| 134826 | 134826 | 133419 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3535 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1920 | Width 3ft | 5997881.22616 | 2115448.76842 | 37.788496590783794 | -122.451165933971 | (37.7884965907838, -122.451165933971) | |||
| 10796 | 10796 | 56697 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1835 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1530 | 3x4 | 5983784.1963 | 2102652.3274 | 37.752544024505895 | -122.498992883391 | (37.7525440245059, -122.498992883391) | |||
| 99896 | 99896 | 20988 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 2002X Sunset Blvd | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 200 | 40 | 5984887.616570599 | 2101567.3225095 | 37.7496295616808 | -122.49509712324499 | (37.7496295616808, -122.495097123245) | |||
| 152523 | 152523 | 223698 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 151 | 6004903.42732 | 2096771.39372 | 37.7376125150086 | -122.42554040785801 | (37.7376125150086, -122.425540407858) | ||||
| 143986 | 143986 | 12622 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 814 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 140 | 3X3 | 5992940.7068300005 | 2114858.78084 | 37.786592541866796 | -122.468216278652 | (37.7865925418668, -122.468216278652) | |||
| 77325 | 77325 | 5120 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2725 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 135 | 5X5 | 6002393.1757827 | 2096184.1201448997 | 37.735857840487206 | -122.434177561301 | (37.7358578404872, -122.434177561301) | |||
| 85913 | 85913 | 12591 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 540 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 135 | 3X3 | 5993752.44537 | 2114880.64385 | 37.7866994199903 | -122.465409472784 | (37.7866994199903, -122.465409472784) | |||
| 89969 | 89969 | 1617 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 764 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 135 | 3X3 | 5995701.56639 | 2110898.08045 | 37.775876579407296 | -122.458377647589 | (37.7758765794073, -122.458377647589) | |||
| 97213 | 97213 | 12530 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 114 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 130 | 3X3 | 5995104.55115 | 2114935.75764 | 37.786928633878205 | -122.460735538354 | (37.7869286338782, -122.460735538354) | |||
| 119052 | 119052 | 12535 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 140 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 130 | 3X3 | 5994996.21554 | 2114933.31934 | 37.7869157052582 | -122.461110175363 | (37.7869157052582, -122.461110175363) | |||
| 181 | 181 | 9914 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1900 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 126 | 3X3 | 6005235.69262 | 2116267.9294 | 37.7911641319684 | -122.42577893234899 | (37.7911641319684, -122.425778932349) | |||
| 2214 | 2214 | 4695 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 850X Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 4x8 | 6008940.69941 | 2120350.9777900004 | 37.802583847399 | -122.41324853649999 | (37.802583847399, -122.4132485365) | |||
| 2891 | 2891 | 10596 | DPW Maintained 3 | Platanus x hispanica 'Bloodgood' :: Bloodgood London Plane 152 | 1098 Harrison St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 3X3 | Permit Number 780455 | 6010813.59233 | 2110557.81798 | 37.775799138353705 | -122.406077023861 | (37.7757991383537, -122.406077023861) | ||
| 6334 | 6334 | 6269 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1355 Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 3X3 | 6004413.7404 | 2113247.5728 | 37.7828245080819 | -122.42840749249201 | (37.7828245080819, -122.428407492492) | |||
| 7939 | 7939 | 4660 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 125 | 5X5 | 6009761.7282 | 2119587.7167 | 37.8005341810425 | -122.410353429867 | (37.8005341810425, -122.410353429867) | |||
| 78599 | 78599 | 12607 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 653 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 125 | 9x7 | 5993406.40366 | 2114819.71467 | 37.7865121620391 | -122.46660225402901 | (37.7865121620391, -122.466602254029) | |||
| 83955 | 83955 | 12598 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 604 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 3X3 | 5993561.79248 | 2114876.17941 | 37.786676164615294 | -122.46606875626001 | (37.7866761646153, -122.46606875626) | |||
| 85463 | 85463 | 1534 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 470X Arguello Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 3X3 | 5995618.147655 | 2113146.451022 | 37.7820452142616 | -122.458829030077 | (37.7820452142616, -122.458829030077) | |||
| 91709 | 91709 | 1533 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 470X Arguello Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 3X3 | 5995618.147655 | 2113146.451022 | 37.7820452142616 | -122.458829030077 | (37.7820452142616, -122.458829030077) | |||
| 94716 | 94716 | 19364 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 3X3 | 5993918.28317 | 2114892.65914 | 37.7867419735566 | -122.464836591079 | (37.7867419735566, -122.464836591079) | |||
| 96797 | 96797 | 1620 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 777 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 3X3 | 5995637.36215 | 2110958.16718 | 37.776037871937206 | -122.45860409582599 | (37.7760378719372, -122.458604095826) | |||
| 102596 | 102596 | 13012 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 400 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 3X3 | 6010380.849090001 | 2120676.56867 | 37.8035585868989 | -122.408287852113 | (37.8035585868989, -122.408287852113) | |||
| 113211 | 113211 | 19366 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500X Lake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 3X3 | 5993786.07945 | 2114905.6520700003 | 37.7867700254284 | -122.465294925074 | (37.7867700254284, -122.465294925074) | |||
| 117946 | 117946 | 1434 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 100X Arguello Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 3X5 | 5995535.03638 | 2115411.50396 | 37.7882596635004 | -122.459280632339 | (37.7882596635004, -122.459280632339) | |||
| 118300 | 118300 | 1581 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 629 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 3X3 | 5995601.12395 | 2111917.66113 | 37.7786703056802 | -122.458798934123 | (37.7786703056802, -122.458798934123) | |||
| 120708 | 120708 | 1551 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 530 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 3X3 | 5995634.85993 | 2112642.48366 | 37.7806624148094 | -122.458734717129 | (37.7806624148094, -122.458734717129) | |||
| 125820 | 125820 | 12592 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 545 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 3X3 | 5993704.83087 | 2114833.84106 | 37.7865681661673 | -122.465570804819 | (37.7865681661673, -122.465570804819) | |||
| 126700 | 126700 | 12581 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 431 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 125 | 3x3 | 5994092.89819 | 2114844.89484 | 37.7866208917825 | -122.46422900028 | (37.7866208917825, -122.46422900028) | |||
| 127418 | 127418 | 12606 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 651 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 125 | 3X3 | 5993439.12695 | 2114820.30449 | 37.786515669843205 | -122.466489083379 | (37.7865156698432, -122.466489083379) | |||
| 128940 | 128940 | 1540 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 470X Arguello Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 3X3 | 5995618.147655 | 2113146.451022 | 37.7820452142616 | -122.458829030077 | (37.7820452142616, -122.458829030077) | |||
| 140148 | 140148 | 110856 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 199x HAWTHORNE ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 123 | 3x3 | 6013721.0 | 2113357.0 | 37.7836472413673 | -122.39621571824699 | (37.7836472413673, -122.396215718247) | |||
| 113541 | 113541 | 585 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3035 24TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 122 | 3x3 | 6008718.0 | 2102146.0 | 37.752584791835105 | -122.412731419953 | (37.7525847918351, -122.412731419953) | |||
| 156890 | 156890 | 249999 | Undocumented 2 | Ficus carica :: Edible Fig 201 | 39 Darrell Pl | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 121 | Width 0ft | 6011509.9435 | 2120224.2158 | 37.8023796968334 | -122.404348688764 | (37.8023796968334, -122.404348688764) | |||
| 114429 | 114429 | 12626 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 830 Lake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 120 | 3X3 | 5992851.54693 | 2114852.9076 | 37.786571265759 | -122.468524319967 | (37.786571265759, -122.468524319967) | |||
| 118283 | 118283 | 12625 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 830 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 120 | 3X3 | 5992875.842730001 | 2114855.09948 | 37.786578687444795 | -122.46844042271401 | (37.7865786874448, -122.468440422714) | |||
| 9980 | 9980 | 5639 | DPW Maintained 3 | Aesculus x carnea :: Red Horse Chestnut 194 | 1273 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 106 | 6X6 | 6005219.14783 | 2100952.73682 | 37.7491113654052 | -122.424746185103 | (37.7491113654052, -122.424746185103) | |||
| 50438 | 50438 | 205639 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 212 Hearst Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 105 | 5999981.368430001 | 2094392.7205 | 37.7308018951744 | -122.442387538165 | (37.7308018951744, -122.442387538165) | ||||
| 148568 | 148568 | 176105 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700x Mansell St | 29 | Median : Cutout 11 | Tree 1 | DPW 2 | 105 | Width 0ft | 6009225.48687 | 2089982.90412 | 37.7192160263732 | -122.41011780460899 | (37.7192160263732, -122.410117804609) | |||
| 186127 | 186127 | 131690 | Undocumented 2 | Musa spp :: Banana 371 | 407 Vallejo St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 105 | 6011485.14109 | 2119034.37122 | 37.7991112871264 | -122.40435072033199 | (37.7991112871264, -122.404350720332) | ||||
| 29906 | 29906 | 250138 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 2550x Lyon St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 101 | 5999227.62567 | 2117605.22496 | 37.7944946461503 | -122.446662836939 | (37.7944946461503, -122.446662836939) | ||||
| 1033 | 1033 | 14582 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1157 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4X4 | 5999380.4238 | 2108868.5189 | 37.7705146429615 | -122.445505607921 | (37.7705146429615, -122.445505607921) | |||
| 1121 | 1121 | 13143 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1800 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6003680.9036 | 2119717.0807 | 37.8005466318744 | -122.431404778789 | (37.8005466318744, -122.431404778789) | |||
| 1214 | 1214 | 14441 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 57 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4X4 | 5998815.3699 | 2112874.8656 | 37.781482766726896 | -122.447748586483 | (37.7814827667269, -122.447748586483) | |||
| 2681 | 2681 | 10334 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 850 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4X4 | 6002067.0 | 2109164.0 | 37.7714789673294 | -122.436233885162 | (37.7714789673294, -122.436233885162) | |||
| 3202 | 3202 | 14513 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 501 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4X4 | 5999073.0679 | 2111076.7771 | 37.776560404910796 | -122.4467276636 | (37.7765604049108, -122.4467276636) | |||
| 3503 | 3503 | 14499 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 350 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4x4 | 5999064.4701 | 2111602.7455 | 37.7780040877061 | -122.44679526057199 | (37.7780040877061, -122.446795260572) | |||
| 3904 | 3904 | 4665 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 100 | 5X5 | 6009675.3838 | 2119664.5956 | 37.8007404309352 | -122.410657649881 | (37.8007404309352, -122.410657649881) | |||
| 5220 | 5220 | 3005 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2370 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6003025.35785 | 2115546.48182 | 37.7890580681313 | -122.43337503892599 | (37.7890580681313, -122.433375038926) | |||
| 5666 | 5666 | 8170 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1190 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6002123.0971 | 2111240.3416 | 37.7771832708527 | -122.436188456168 | (37.7771832708527, -122.436188456168) | |||
| 5742 | 5742 | 14498 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 350 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5999068.9707 | 2111582.6972 | 37.7779492973394 | -122.44677824853001 | (37.7779492973394, -122.44677824853) | |||
| 5814 | 5814 | 6256 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1315 Ellis St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6004614.9344 | 2113276.215 | 37.7829145353129 | -122.427713486832 | (37.7829145353129, -122.427713486832) | |||
| 6149 | 6149 | 14526 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 637 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5999136.9105 | 2110609.5392 | 37.775281136182606 | -122.446473192139 | (37.7752811361826, -122.446473192139) | |||
| 6290 | 6290 | 14424 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X Masonic Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 100 | 12 | 5998854.1192 | 2113097.3779 | 37.7820959422738 | -122.44763055563999 | (37.7820959422738, -122.44763055564) | |||
| 6597 | 6597 | 2938 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3x3 | 6005165.9769 | 2115843.65422 | 37.7899952390391 | -122.425989931308 | (37.7899952390391, -122.425989931308) | |||
| 7035 | 7035 | 2945 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1976 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4x4 | 6004916.90852 | 2115812.13334 | 37.78989461118729 | -122.426849441272 | (37.7898946111873, -122.426849441272) | |||
| 7137 | 7137 | 6252 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1315 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6004508.0501 | 2113262.2432 | 37.78287012558321 | -122.42808226621099 | (37.7828701255832, -122.428082266211) | |||
| 7531 | 7531 | 8183 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1216 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6001748.9425 | 2111188.325 | 37.777019181607706 | -122.437479047598 | (37.7770191816077, -122.437479047598) | |||
| 7655 | 7655 | 4730 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1175X Columbus Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 100 | 3x3 | 6007911.57425 | 2121225.41132 | 37.8049269905411 | -122.41687182377 | (37.8049269905411, -122.41687182377) | |||
| 7737 | 7737 | 8094 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 762 Fulton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 100 | 3X3 | 6004211.6397 | 2111535.7715 | 37.7781128879326 | -122.428984591665 | (37.7781128879326, -122.428984591665) | |||
| 8329 | 8329 | 8190 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1280 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6001658.902000001 | 2111173.1154 | 37.7769723003903 | -122.437789435412 | (37.7769723003903, -122.437789435412) | |||
| 8809 | 8809 | 3076 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2901 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3X3 | 6000369.0268 | 2115111.6254 | 37.7877130071917 | -122.442534340035 | (37.7877130071917, -122.442534340035) | |||
| 8969 | 8969 | 8181 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1212 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6001826.5111 | 2111197.1465 | 37.7770478129311 | -122.43721134601002 | (37.7770478129311, -122.43721134601) | |||
| 9140 | 9140 | 12661 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1045 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 4X4 | 5992178.70595 | 2114775.57253 | 37.786320036254004 | -122.47084652786002 | (37.786320036254, -122.47084652786) | |||
| 9275 | 9275 | 9356 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 241 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3X3 | 6000999.4900667 | 2098404.1035626 | 37.74187419547079 | -122.43915513344 | (37.7418741954708, -122.43915513344) | |||
| 14810 | 14810 | 4764 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 20 Commer Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6016747.24729 | 2094694.7761400002 | 37.7325726360097 | -122.384445690014 | (37.7325726360097, -122.384445690014) | |||
| 16630 | 16630 | 4771 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 20 Commer Ct | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6016532.61927 | 2094742.5477 | 37.7326919364855 | -122.385191045451 | (37.7326919364855, -122.385191045451) | |||
| 16950 | 16950 | 25174 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3062 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6000130.8652 | 2105433.23803 | 37.761125030928895 | -122.44266313540199 | (37.7611250309289, -122.442663135402) | |||
| 17143 | 17143 | 10434 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1457 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5999128.9575 | 2108690.2041 | 37.7700106766776 | -122.44636259863998 | (37.7700106766776, -122.44636259864) | |||
| 17349 | 17349 | 10372 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1216 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6000283.8166 | 2108900.9156 | 37.7706551281266 | -122.442383101019 | (37.7706551281266, -122.442383101019) | |||
| 17398 | 17398 | 5707 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1600 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6005241.864159999 | 2098983.9941 | 37.74370693182271 | -122.424527610259 | (37.7437069318227, -122.424527610259) | |||
| 17478 | 17478 | 5658 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1349-1349 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6005239.88286 | 2100530.07402 | 37.74795200168529 | -122.42464442051 | (37.7479520016853, -122.42464442051) | |||
| 17547 | 17547 | 5745 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1764 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4X6 | 6005291.38109 | 2098122.5242 | 37.7413443273726 | -122.424295134606 | (37.7413443273726, -122.424295134606) | |||
| 18605 | 18605 | 10373 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1234 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 9x5 | 6000208.6256 | 2108891.1906 | 37.770624139779 | -122.44264248857 | (37.770624139779, -122.44264248857) | |||
| 18731 | 18731 | 5529 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 895 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4X4 | 6005093.86648 | 2103161.8218799997 | 37.7551699235695 | -122.425336590916 | (37.7551699235695, -122.425336590916) | |||
| 18991 | 18991 | 5440 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 500X Dolores St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 100 | 6 | 6004903.17124 | 2105121.8240799997 | 37.7605408528978 | -122.426135598976 | (37.7605408528978, -122.426135598976) | |||
| 19090 | 19090 | 17231 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5 Ora Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6001200.02819 | 2098556.64623 | 37.7423044507995 | -122.438472666097 | (37.7423044507995, -122.438472666097) | |||
| 19432 | 19432 | 5731 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1703 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6005358.59777 | 2098401.9936900004 | 37.7421154825341 | -122.424082592458 | (37.7421154825341, -122.424082592458) | |||
| 19488 | 19488 | 10031 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 310 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 2x3 | 6005459.49344 | 2107143.4221799998 | 37.7661231103266 | -122.42435532265301 | (37.7661231103266, -122.424355322653) | |||
| 19611 | 19611 | 5725 | DPW Maintained 3 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 1676 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4X4 | 6005265.5295 | 2098569.21573 | 37.7425693811872 | -122.424416284994 | (37.7425693811872, -122.424416284994) | |||
| 20706 | 20706 | 10325 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 807 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6002259.2753800005 | 2109123.5178 | 37.7713787357685 | -122.435565898974 | (37.7713787357685, -122.435565898974) | |||
| 21076 | 21076 | 5748 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1770 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 5X5 | 6005291.423690001 | 2098088.82872 | 37.7412518096224 | -122.424292591354 | (37.7412518096224, -122.424292591354) | |||
| 21340 | 21340 | 5342 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 173 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 6X8 | 6004862.74294 | 2107362.11728 | 37.7666898792732 | -122.426434939225 | (37.7666898792732, -122.426434939225) | |||
| 21691 | 21691 | 5719 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1652 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6005259.7539800005 | 2098674.6778700002 | 37.7428586301118 | -122.424443754787 | (37.7428586301118, -122.424443754787) | |||
| 21952 | 21952 | 5447 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 500X Dolores St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 100 | 6 | 6004926.667780001 | 2104747.1594700003 | 37.7595134404185 | -122.42602766326401 | (37.7595134404185, -122.426027663264) | |||
| 22001 | 22001 | 10329 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 826 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4X4 | 6002169.5428 | 2109164.5209999997 | 37.7714862234563 | -122.435879222083 | (37.7714862234563, -122.435879222083) | |||
| 22188 | 22188 | 10293 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 509 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6003637.74102 | 2109321.06429 | 37.7719993462366 | -122.430811822711 | (37.7719993462366, -122.430811822711) | |||
| 41136 | 41136 | 250136 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 2550x Lyon St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 100 | 5999230.194080001 | 2117561.109 | 37.794373662156296 | -122.446650774326 | (37.7943736621563, -122.446650774326) | ||||
| 77970 | 77970 | 12741 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1638 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 4X4 | 5990321.4540800005 | 2114762.4147099997 | 37.786176325151295 | -122.47727111168899 | (37.7861763251513, -122.477271111689) | |||
| 78188 | 78188 | 7673 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 290X LAKE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3X3 | 5994618.0 | 2114909.0 | 37.7868271588239 | -122.46241694027701 | (37.7868271588239, -122.462416940277) | |||
| 81413 | 81413 | 12903 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6007848.98747 | 2111478.5775200003 | 37.7781610630449 | -122.41639760505 | (37.7781610630449, -122.41639760505) | |||
| 82446 | 82446 | 4768 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 26 Commer Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/1993 12:00:00 AM | 100 | 3X3 | 6016521.3746591 | 2094751.2728264 | 37.7327152718937 | -122.385230528967 | (37.7327152718937, -122.385230528967) | ||
| 84814 | 84814 | 4766 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 25 Commer Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6016516.0463685 | 2094701.5331358002 | 37.7325784018492 | -122.38524548572799 | (37.7325784018492, -122.385245485728) | |||
| 86346 | 86346 | 12587 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 452 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 6X6 | 5994011.04137 | 2114897.5595 | 37.7867607761959 | -122.46451602816299 | (37.7867607761959, -122.464516028163) | |||
| 86737 | 86737 | 1428 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 75X Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 5 | 5995465.63795 | 2115574.8643900002 | 37.78870421691 | -122.459532573841 | (37.78870421691, -122.459532573841) | |||
| 87397 | 87397 | 14536 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701X Masonic Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | |||
| 88522 | 88522 | 13394 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 300 Marietta Dr | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 100 | 5 | 5999367.9101935 | 2097504.6578797 | 37.7393115562077 | -122.444731949771 | (37.7393115562077, -122.444731949771) | |||
| 89919 | 89919 | 1440 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 126 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 5X5 | 5995572.08179 | 2115303.34583 | 37.7879648202564 | -122.459144627311 | (37.7879648202564, -122.459144627311) | |||
| 92301 | 92301 | 12659 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1040 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5992205.79142 | 2114830.06485 | 37.7864712234678 | -122.47075679064301 | (37.7864712234678, -122.470756790643) |
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");