Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, qCareAssistant, PermitNotes
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1529 | 1529 | 251578 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000X Columbus Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | ||||||||||
1982 | 1982 | 118349 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:43:00 AM | 3 | ||||||||
2168 | 2168 | 118346 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 05:47:00 AM | 3 | ||||||||
2766 | 2766 | 118353 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 05:58:00 AM | 3 | ||||||||
3111 | 3111 | 118355 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:48:00 AM | 3 | ||||||||
3394 | 3394 | 118348 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:19:00 AM | 3 | ||||||||
4215 | 4215 | 118354 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:05:00 AM | 3 | ||||||||
4374 | 4374 | 118351 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:32:00 AM | 3 | ||||||||
5429 | 5429 | 118350 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 05:53:00 AM | 3 | ||||||||
5643 | 5643 | 118347 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 05:39:00 AM | 3 | ||||||||
5661 | 5661 | 118352 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:56:00 AM | 3 | ||||||||
9748 | 9748 | 173655 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 100 Lawton St | 1 | Median : Cutout 11 | Tree 1 | DPW for City Agency 10 | ||||||||||
10102 | 10102 | 121489 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2 Judah St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | |||||||||
14379 | 14379 | 48480 | Permitted Site 1 | Tree(s) :: 17 | 1 | Median : Cutout 11 | Tree 1 | Private 1 | Permit Number 45832 | ||||||||||
147452 | 147452 | 178266 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 12x Canyon Dr | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6002746.13562 | 2086151.65676 | 37.7083309587667 | -122.43224097763901 | (37.7083309587667, -122.432240977639) | |||
161444 | 161444 | 176333 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 12x Canyon Dr | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 6002752.1139 | 2086168.71447 | 37.708378134509296 | -122.43222153339899 | (37.7083781345093, -122.432221533399) | |||
180884 | 180884 | 178265 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 12x Canyon Dr | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | Width 0ft | 6002756.140790001 | 2086182.07734 | 37.7084150543766 | -122.43220856967501 | (37.7084150543766, -122.432208569675) | |||
151982 | 151982 | 178264 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 12x Canyon Dr | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 34 | Width 0ft | 6002759.723230001 | 2086192.08797 | 37.708442744517896 | -122.432196902771 | (37.7084427445179, -122.432196902771) | |||
10449 | 10449 | 98333 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 12X Canyon Dr | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 99 | 6003235.70781 | 2086338.01389 | 37.708870401808205 | -122.43056224915199 | (37.7088704018082, -122.430562249152) | ||||
169994 | 169994 | 179174 | DPW Maintained 3 | Pseudotsuga menziesii :: Douglas Fir 231 | 12x Canyon Dr | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6003147.35342 | 2086364.11434 | 37.7089370622714 | -122.43086947554899 | (37.7089370622714, -122.430869475549) | |||
13019 | 13019 | 24270 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300X Winding Way | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6001396.0736 | 2086458.9864 | 37.709098177596005 | -122.436928924942 | (37.709098177596, -122.436928924942) | |||
11289 | 11289 | 24269 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300X Winding Way | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6001399.20674 | 2086458.92155 | 37.7090981776115 | -122.43691809171999 | (37.7090981776115, -122.43691809172) | |||
10927 | 10927 | 24271 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300X Winding Way | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6001388.30533 | 2086462.2685599998 | 37.70910674815379 | -122.436956008017 | (37.7091067481538, -122.436956008017) | |||
11032 | 11032 | 24272 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300X Winding Way | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6001382.61488 | 2086464.9875900003 | 37.7091138905754 | -122.43697586956301 | (37.7091138905754, -122.436975869563) | |||
186679 | 186679 | 179670 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 300x Winding Way | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6001487.80324 | 2086473.7350700002 | 37.7091438874604 | -122.436612949055 | (37.7091438874604, -122.436612949055) | |||
52138 | 52138 | 177088 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 300x Winding Way | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 6001504.621119999 | 2086478.58914 | 37.7091581713864 | -122.436555171203 | (37.7091581713864, -122.436555171203) | |||
115627 | 115627 | 178410 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 300x Winding Way | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 6001531.44731 | 2086487.39833 | 37.7091838838906 | -122.43646308602 | (37.7091838838906, -122.43646308602) | |||
13159 | 13159 | 24265 | DPW Maintained 3 | Ilex aquifolium :: European Holly 277 | 300X Winding Way | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6001546.70936 | 2086492.80474 | 37.7091995959417 | -122.43641072479299 | (37.7091995959417, -122.436410724793) | |||
39688 | 39688 | 178859 | DPW Maintained 3 | Prunus laurocerasus :: English laurel 227 | 300x Winding Way | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | Width 0ft | 6001566.6929 | 2086499.15435 | 37.7092181660671 | -122.436342112826 | (37.7092181660671, -122.436342112826) | |||
10890 | 10890 | 24263 | DPW Maintained 3 | Prunus laurocerasus :: English laurel 227 | 300X Winding Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 8 | 6001575.13411 | 2086503.1415799998 | 37.7092295937538 | -122.43631322390199 | (37.7092295937538, -122.436313223902) | |||
103037 | 103037 | 24281 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 300X Winding Way | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8 | 6001646.2933309 | 2086550.8578367 | 37.7093646550959 | -122.436070699117 | (37.7093646550959, -122.436070699117) | |||
110884 | 110884 | 24285 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 300X Winding Way | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 6001646.2933309 | 2086550.8578367 | 37.7093646550959 | -122.436070699117 | (37.7093646550959, -122.436070699117) | |||
123249 | 123249 | 24282 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 300X Winding Way | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8 | 6001646.2933309 | 2086550.8578367 | 37.7093646550959 | -122.436070699117 | (37.7093646550959, -122.436070699117) | |||
128561 | 128561 | 24283 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 300X Winding Way | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6001646.2933309 | 2086550.8578367 | 37.7093646550959 | -122.436070699117 | (37.7093646550959, -122.436070699117) | |||
144777 | 144777 | 24280 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 300X Winding Way | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8 | 6001646.2933309 | 2086550.8578367 | 37.7093646550959 | -122.436070699117 | (37.7093646550959, -122.436070699117) | |||
146155 | 146155 | 24284 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 300X Winding Way | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6001646.2933309 | 2086550.8578367 | 37.7093646550959 | -122.436070699117 | (37.7093646550959, -122.436070699117) | |||
11264 | 11264 | 117179 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 350x Winding Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 3x3 | 6001167.67306 | 2086580.24641 | 37.7094181465037 | -122.43772698870701 | (37.7094181465037, -122.437726988707) | |||
167020 | 167020 | 179495 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 350x Winding Way | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6001141.4285699995 | 2086583.09342 | 37.7094244714452 | -122.43781789759 | (37.7094244714452, -122.43781789759) | |||
11192 | 11192 | 24264 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 350X Winding Way | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 8 | 6001155.71614 | 2086583.0952599999 | 37.709425288929296 | -122.437768517615 | (37.7094252889293, -122.437768517615) | |||
11178 | 11178 | 24266 | DPW Maintained 3 | Eucalyptus pulverulenta :: Silver Mountain Gum Tree 107 | 350X Winding Way | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 8 | 6001132.77174 | 2086585.13109 | 37.7094295741756 | -122.437847962815 | (37.7094295741756, -122.437847962815) | |||
12367 | 12367 | 24267 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 350X Winding Way | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 6001124.44895 | 2086586.86413 | 37.7094338594468 | -122.43787685174401 | (37.7094338594468, -122.437876851744) | |||
12342 | 12342 | 24268 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 350X Winding Way | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 6001111.916180001 | 2086587.12369 | 37.7094338594537 | -122.437920185566 | (37.7094338594537, -122.437920185566) | |||
35157 | 35157 | 178267 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 350x Winding Way | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | Width 0ft | 6001101.515319999 | 2086589.4198900003 | 37.7094395728456 | -122.437956296952 | (37.7094395728456, -122.437956296952) | |||
22854 | 22854 | 176359 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 350x Winding Way | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 19 | Width 0ft | 6001093.21408 | 2086592.19305 | 37.7094467152559 | -122.437985185864 | (37.7094467152559, -122.437985185864) | |||
142086 | 142086 | 110077 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4099x ALEMANY BLVD | Median : Cutout 11 | Tree 1 | Private 1 | 48 | 5991599.0 | 2086829.0 | 37.7095524384103 | -122.470815701049 | (37.7095524384103, -122.470815701049) | |||||
46886 | 46886 | 175915 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 350x Winding Way | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6000968.48443 | 2086648.8804900001 | 37.7095952724697 | -122.43842033004299 | (37.7095952724697, -122.438420330043) | |||
10981 | 10981 | 1860 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2500 Bay Shore Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6 | 6010703.231369999 | 2086455.7019 | 37.709613762523205 | -122.404761589082 | (37.7096137625232, -122.404761589082) | |||
10337 | 10337 | 1859 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2500 Bay Shore Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6 | 6010721.136519999 | 2086497.1887700001 | 37.7097286779125 | -122.404702624138 | (37.7097286779125, -122.404702624138) | |||
11400 | 11400 | 1858 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2500 Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6010736.7682300005 | 2086529.19155 | 37.709817424799 | -122.404650849269 | (37.709817424799, -122.404650849269) | |||
13013 | 13013 | 1304 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 4000X Alemany Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 10 | 5991645.96929 | 2086939.8139900002 | 37.7098594231521 | -122.470661434599 | (37.7098594231521, -122.470661434599) | |||
11567 | 11567 | 1857 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2500 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6010751.52595 | 2086559.13987 | 37.7099004816803 | -122.404601950438 | (37.7099004816803, -122.404601950438) | |||
13003 | 13003 | 24273 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 350X Winding Way | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 6000864.27338 | 2086762.8945799998 | 37.7099024017335 | -122.43878866537399 | (37.7099024017335, -122.438788665374) | |||
11332 | 11332 | 1303 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 4000X Alemany Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 45 | 10 | 5991684.008830001 | 2086976.4673900001 | 37.709962264210404 | -122.47053263188299 | (37.7099622642104, -122.470532631883) | |||
10951 | 10951 | 24278 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 350X Winding Way | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6000808.42529 | 2086790.5767400002 | 37.709975233345 | -122.438983668972 | (37.709975233345, -122.438983668972) | |||
12225 | 12225 | 24277 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 350X Winding Way | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6000814.16949 | 2086790.4577099998 | 37.709975233345496 | -122.43896380743999 | (37.7099752333455, -122.43896380744) | |||
23244 | 23244 | 24275 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 350X Winding Way | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 38 | 8 | 6000843.90644 | 2086792.8315400002 | 37.709983443260995 | -122.438861201091 | (37.709983443261, -122.438861201091) | |||
13219 | 13219 | 24279 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 350X Winding Way | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6000809.6312 | 2086798.35513 | 37.709996659695 | -122.43898005820299 | (37.709996659695, -122.438980058203) | |||
12496 | 12496 | 24276 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 350X Winding Way | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6000825.35085 | 2086800.6303 | 37.710003801206796 | -122.438925891137 | (37.7100038012068, -122.438925891137) | |||
11821 | 11821 | 24274 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 350X Winding Way | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6000860.34882 | 2086800.42556 | 37.710005230221 | -122.438804917029 | (37.710005230221, -122.438804917029) | |||
90771 | 90771 | 98853 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 4043X Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 5991835.94326 | 2086997.82238 | 37.710029684074 | -122.470009076276 | (37.710029684074, -122.470009076276) | |||||
143078 | 143078 | 121420 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1155x Prague St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 6000780.0 | 2086820.0 | 37.7100544057225 | -122.439084019343 | (37.7100544057225, -122.439084019343) | ||||
11290 | 11290 | 1302 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4000X Alemany Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 10 | 5991739.11571 | 2087020.66511 | 37.7100868068254 | -122.470345390352 | (37.7100868068254, -122.470345390352) | |||
188789 | 188789 | 1301 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 4000X Alemany Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 32 | 10 | 5991772.09471 | 2087046.42932 | 37.7101594558675 | -122.470233284447 | (37.7101594558675, -122.470233284447) | |||
12049 | 12049 | 1300 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 4000X Alemany Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 10 | 5991824.5048400005 | 2087077.28239 | 37.7102472009077 | -122.470054391311 | (37.7102472009077, -122.470054391311) | |||
86585 | 86585 | 1862 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2510 Bay Shore Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6010780.8257042 | 2086709.3373148 | 37.710314531205896 | -122.404511250175 | (37.7103145312059, -122.404511250175) | |||
87252 | 87252 | 1861 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2510 Bay Shore Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6 | 6010780.8257042 | 2086709.3373148 | 37.710314531205896 | -122.404511250175 | (37.7103145312059, -122.404511250175) | |||
10821 | 10821 | 1299 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 4000X Alemany Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 10 | 5991881.88808 | 2087114.90346 | 37.7103538164401 | -122.46985880224301 | (37.7103538164401, -122.469858802243) | |||
10727 | 10727 | 1298 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 4000X Alemany Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 10 | 5991889.9079 | 2087118.85792 | 37.7103651380077 | -122.46983137204599 | (37.7103651380077, -122.469831372046) | |||
11437 | 11437 | 1297 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 4000X Alemany Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 10 | 5991899.37983 | 2087126.21827 | 37.7103858952584 | -122.46979917089199 | (37.7103858952584, -122.469799170892) | |||
10785 | 10785 | 1296 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 4000X Alemany Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 10 | 5991907.39965 | 2087130.17274 | 37.710397216839496 | -122.46977174067499 | (37.7103972168395, -122.469771740675) | |||
10299 | 10299 | 1295 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 4000X Alemany Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 10 | 5991914.74417 | 2087134.82891 | 37.710410426081 | -122.46974669545901 | (37.710410426081, -122.469746695459) | |||
106367 | 106367 | 1854 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 2500 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6010837.5147418 | 2086759.4488696998 | 37.7104552954566 | -122.404318844881 | (37.7104552954566, -122.404318844881) | |||
138313 | 138313 | 1855 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 2500 Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6 | 6010837.5147418 | 2086759.4488696998 | 37.7104552954566 | -122.404318844881 | (37.7104552954566, -122.404318844881) | |||
139020 | 139020 | 1856 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2500 Bay Shore Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6010837.5147418 | 2086759.4488696998 | 37.7104552954566 | -122.404318844881 | (37.7104552954566, -122.404318844881) | |||
12006 | 12006 | 1294 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 4000X Alemany Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 10 | 5991953.08243 | 2087152.92109 | 37.7104623187479 | -122.469615507754 | (37.7104623187479, -122.469615507754) | |||
10605 | 10605 | 1293 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 4000X Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 10 | 5991961.87152 | 2087160.6390900002 | 37.7104840184951 | -122.46958569253701 | (37.7104840184951, -122.469585692537) | |||
12362 | 12362 | 15901 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 5600 Mission St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/10/1995 12:00:00 AM | 6 | 20 | 5998236.34112 | 2087033.73083 | 37.710496198018 | -122.447890739788 | (37.710496198018, -122.447890739788) | ||
10954 | 10954 | 15902 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5600 Mission St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/23/1995 12:00:00 AM | 6 | TR20 | 5998238.99709 | 2087038.7453700001 | 37.7105101186185 | -122.447881921009 | (37.7105101186185, -122.447881921009) | ||
42138 | 42138 | 181261 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400x Bay Shore Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6010896.06222 | 2086791.14453 | 37.710545596879705 | -122.40411872042299 | (37.7105455968797, -122.404118720423) | |||
13018 | 13018 | 15903 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 5600 Mission St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/01/1992 12:00:00 AM | 6 | TR20 | 5998269.83738 | 2087060.55751 | 37.7105717725495 | -122.44777690001101 | (37.7105717725495, -122.447776900011) | ||
11532 | 11532 | 15904 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5600 Mission St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/10/1995 12:00:00 AM | 6 | TR20 | 5998273.75241 | 2087065.5939900002 | 37.7105858253457 | -122.44776373121 | (37.7105858253457, -122.44776373121) | ||
11509 | 11509 | 15905 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5600 Mission St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/13/1994 12:00:00 AM | 12 | TR20 | 5998282.5187800005 | 2087066.12192 | 37.71058777596279 | -122.44773347081998 | (37.7105877759628, -122.44773347082) | ||
10548 | 10548 | 15906 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5600 Mission St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/23/1995 12:00:00 AM | 3 | TR20 | 5998281.91295 | 2087072.66875 | 37.7106057174457 | -122.447736035688 | (37.7106057174457, -122.447736035688) | ||
12577 | 12577 | 15907 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5600 Mission St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/23/1995 12:00:00 AM | 3 | TR20 | 5998292.86326 | 2087073.3238400002 | 37.7106081420281 | -122.447698236291 | (37.7106081420281, -122.447698236291) | ||
10887 | 10887 | 15908 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5600 Mission St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/01/1992 12:00:00 AM | 3 | TR20 | 5998294.210469999 | 2087081.2429799999 | 37.7106299631863 | -122.447694149767 | (37.7106299631863, -122.447694149767) | ||
57972 | 57972 | 181260 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400x Bay Shore Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6010918.05044 | 2086828.8185599998 | 37.7106502707697 | -122.40404537351601 | (37.7106502707697, -122.404045373516) | |||
44652 | 44652 | 181259 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400x Bay Shore Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6010937.034659999 | 2086861.99587 | 37.710742429686206 | -122.40398209272499 | (37.7107424296862, -122.403982092725) | |||
27734 | 27734 | 181258 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400x Bay Shore Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6010956.04386 | 2086896.41565 | 37.7108380015362 | -122.403918812817 | (37.7108380015362, -122.403918812817) | |||
29208 | 29208 | 181257 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400x Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6010977.11587 | 2086929.96483 | 37.7109312981009 | -122.40384834192801 | (37.7109312981009, -122.403848341928) | |||
150822 | 150822 | 181256 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400x Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6010998.20467 | 2086964.34233 | 37.7110268699605 | -122.40377787107799 | (37.7110268699605, -122.403777871078) | |||
9112 | 9112 | 122861 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000X Alemany Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/08/2016 01:43:00 PM | 3 | 3x3 | 5996648.0 | 2087344.0 | 37.7112572095529 | -122.453402744961 | (37.7112572095529, -122.453402744961) | ||
9209 | 9209 | 122858 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000X Alemany Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/08/2016 01:48:00 PM | 3 | 3x3 | 5996648.0 | 2087344.0 | 37.7112572095529 | -122.453402744961 | (37.7112572095529, -122.453402744961) | ||
9268 | 9268 | 122855 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000X Alemany Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/08/2016 01:30:00 PM | 3 | 3x3 | 5996648.0 | 2087344.0 | 37.7112572095529 | -122.453402744961 | (37.7112572095529, -122.453402744961) | ||
9272 | 9272 | 122860 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000X Alemany Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/08/2016 01:54:00 PM | 3 | 3x3 | 5996648.0 | 2087344.0 | 37.7112572095529 | -122.453402744961 | (37.7112572095529, -122.453402744961) | ||
9280 | 9280 | 122859 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000X Alemany Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/08/2016 01:46:00 PM | 3 | 3x3 | 5996648.0 | 2087344.0 | 37.7112572095529 | -122.453402744961 | (37.7112572095529, -122.453402744961) | ||
9291 | 9291 | 122856 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000X Alemany Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/08/2016 01:13:00 PM | 3 | 3x3 | 5996648.0 | 2087344.0 | 37.7112572095529 | -122.453402744961 | (37.7112572095529, -122.453402744961) | ||
9327 | 9327 | 122854 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000X Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/08/2016 01:40:00 PM | 3 | 3x3 | 5996648.0 | 2087344.0 | 37.7112572095529 | -122.453402744961 | (37.7112572095529, -122.453402744961) | ||
9354 | 9354 | 122862 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000X Alemany Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/08/2016 01:57:00 PM | 3 | 3x3 | 5996648.0 | 2087344.0 | 37.7112572095529 | -122.453402744961 | (37.7112572095529, -122.453402744961) | ||
9406 | 9406 | 122857 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000X Alemany Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/08/2016 01:17:00 PM | 3 | 3x3 | 5996648.0 | 2087344.0 | 37.7112572095529 | -122.453402744961 | (37.7112572095529, -122.453402744961) | ||
77993 | 77993 | 12500 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X Lake Merced Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 5987438.4549992 | 2087542.2692131 | 37.7112694082243 | -122.485247377649 | (37.7112694082243, -122.485247377649) |
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");