Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | ||||
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) | |||
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) | |||
92656 | 92656 | 10376 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1255X Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 21x6 | 6000170.7774495995 | 2108835.6049214 | 37.7704693578958 | -122.44276941339199 | (37.7704693578958, -122.442769413392) | |||
95505 | 95505 | 1429 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 75X Arguello Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 5 | 5995465.54596 | 2115556.4736099998 | 37.788653715516205 | -122.45953155962 | (37.7886537155162, -122.45953155962) | |||
96237 | 96237 | 11349 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1300X Ingalls St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6017347.6886145 | 2093992.5867035 | 37.730677746775605 | -122.382320962891 | (37.7306777467756, -122.382320962891) | |||
98223 | 98223 | 10420 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1219X Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5999405.64403 | 2108687.20317 | 37.7700182355876 | -122.445405332062 | (37.7700182355876, -122.445405332062) | |||
99379 | 99379 | 1642 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 860 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5995719.79795 | 2110383.37965 | 37.7744643941763 | -122.45827731837299 | (37.7744643941763, -122.458277318373) | |||
100856 | 100856 | 14543 | DPW Maintained 3 | Quillaja saponaria :: Chilean Soapbark 343 | 736 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5999282.2180699995 | 2110225.9006 | 37.7742360610429 | -122.44594294328002 | (37.7742360610429, -122.44594294328) | |||
101124 | 101124 | 4763 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 22 Commer Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6016508.324428201 | 2094752.2608580003 | 37.732717262878396 | -122.385275716107 | (37.7327172628784, -122.385275716107) | |||
101724 | 101724 | 8162 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1104 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3x3 | 6002393.15082 | 2111291.80956 | 37.7773399284264 | -122.435257938115 | (37.7773399284264, -122.435257938115) | |||
101797 | 101797 | 1506 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 345 Arguello Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5995528.42515 | 2113903.2607299997 | 37.7841180535654 | -122.45919424672701 | (37.7841180535654, -122.459194246727) | |||
103017 | 103017 | 10275 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 222 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3x3 | 6004852.2764800005 | 2109616.19972 | 37.772878454111705 | -122.42663166961701 | (37.7728784541117, -122.426631669617) | |||
104204 | 104204 | 14512 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500X Masonic Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4X4 | 5999167.52145 | 2111070.84281 | 37.776549506017105 | -122.446400495731 | (37.7765495060171, -122.446400495731) | |||
105690 | 105690 | 8166 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1124 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6002264.1606 | 2111273.81911 | 37.7772832052401 | -122.435702869129 | (37.7772832052401, -122.435702869129) | |||
106251 | 106251 | 13123 | DPW Maintained 3 | Persea borbonia :: False Avocado 244 | 1671 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6004412.3101699995 | 2119715.97512 | 37.8005850211999 | -122.428873735983 | (37.8005850211999, -122.428873735983) | |||
106368 | 106368 | 10362 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1126 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X4 | 6000713.44362 | 2108968.6618 | 37.7708656202791 | -122.440901879767 | (37.7708656202791, -122.440901879767) | |||
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) | |||
110986 | 110986 | 12738 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1630 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/12/2013 12:00:00 AM | 100 | 4x4 | 5990343.3046 | 2114764.5197400004 | 37.7861833727245 | -122.47719566934299 | (37.7861833727245, -122.477195669343) | ||
115010 | 115010 | 9648 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 420X Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5999128.38767 | 2111347.91542 | 37.77730804103229 | -122.446555809153 | (37.7773080410323, -122.446555809153) | |||
116697 | 116697 | 12594 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 545 Lake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5993765.6939900005 | 2114834.3012 | 37.786572939805204 | -122.465360268476 | (37.7865729398052, -122.465360268476) | |||
117123 | 117123 | 12636 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 901 Lake St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5992666.273990001 | 2114790.8903900003 | 37.7863902797856 | -122.46916079788099 | (37.7863902797856, -122.469160797881) | |||
117853 | 117853 | 3012 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2440 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6002689.255201099 | 2115491.3069188 | 37.7888874982911 | -122.434533962619 | (37.7888874982911, -122.434533962619) | |||
118001 | 118001 | 13409 | DPW Maintained 3 | Corymbia citriodora :: Lemon Scented Gum 301 | 364 Marietta Dr | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 100 | 5 | 5999660.108164 | 2097381.7238333 | 37.738990678772396 | -122.443712833155 | (37.7389906787724, -122.443712833155) | |||
118523 | 118523 | 12662 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1044 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5992177.16633 | 2114831.4087900002 | 37.7864732581467 | -122.470855923323 | (37.7864732581467, -122.470855923323) | |||
119858 | 119858 | 12540 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 227 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5994726.9405 | 2114869.90451 | 37.786726085899794 | -122.462037198106 | (37.7867260858998, -122.462037198106) | |||
121745 | 121745 | 17198 | DPW Maintained 3 | Persea borbonia :: False Avocado 244 | 1675X Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3x3 | 6004367.95797 | 2119722.65234 | 37.8006008446769 | -122.42902768903099 | (37.8006008446769, -122.429027689031) |
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");