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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
174476 | 174476 | 176315 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 600x Mansell St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | Width 0ft | 6010056.94301 | 2090202.23729 | 37.7198648386596 | -122.40725921596399 | (37.7198648386596, -122.407259215964) | |||
174465 | 174465 | 217456 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | Width 0ft | 5996127.26791 | 2089002.03978 | 37.715779938072295 | -122.455322264126 | (37.7157799380723, -122.455322264126) | |||
174460 | 174460 | 221422 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 800x Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005661.88318 | 2104154.96713 | 37.7579289437835 | -122.42344282103001 | (37.7579289437835, -122.42344282103) | |||
174456 | 174456 | 211627 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 299x Magellan Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 6ft | 5994448.55945 | 2100109.15012 | 37.7461808849383 | -122.461929563416 | (37.7461808849383, -122.461929563416) | |||
174364 | 174364 | 244465 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005629.1512 | 2109732.6732 | 37.773242151986 | -122.423952649806 | (37.773242151986, -122.423952649806) | |||
174282 | 174282 | 204559 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 55 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 5ft | 5999606.142519999 | 2097461.8157099998 | 37.739207513906706 | -122.443905173798 | (37.7392075139067, -122.443905173798) | |||
174240 | 174240 | 244360 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005525.0257 | 2110428.4298 | 37.7751466521023 | -122.424362329876 | (37.7751466521023, -122.424362329876) | |||
174036 | 174036 | 205595 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 600x Laguna Honda Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 5995550.17234 | 2099899.0902400003 | 37.74566747188229 | -122.458105148758 | (37.7456674718823, -122.458105148758) | |||
174027 | 174027 | 137752 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1100x DIVISADERO ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001393.9748 | 2112237.1097 | 37.7798786918075 | -122.43878216092399 | (37.7798786918075, -122.438782160924) | |||
173916 | 173916 | 200530 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 6016148.3458 | 2095686.6607 | 37.735263016153105 | -122.386585395355 | (37.7352630161531, -122.386585395355) | |||
173839 | 173839 | 205118 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500x Junipero Serra Blvd | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 5991423.914 | 2093942.9209 | 37.729075391100004 | -122.471938967411 | (37.7290753911, -122.471938967411) | |||
173819 | 173819 | 204495 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 255x San Marcos Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 5ft | 5993111.4957 | 2100245.72605 | 37.746478821347104 | -122.46656284899099 | (37.7464788213471, -122.466562848991) | |||
173817 | 173817 | 245664 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 738x San Jose Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005721.51625 | 2098863.78747 | 37.743403947541296 | -122.42286054508001 | (37.7434039475413, -122.42286054508) | |||
173743 | 173743 | 200597 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1300x Newcomb Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6016514.3807 | 2094844.0461 | 37.732969621897794 | -122.38526117126301 | (37.7329696218978, -122.385261171263) | |||
173550 | 173550 | 211257 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100x Casitas Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 3ft | 5995466.651769999 | 2096989.01448 | 37.737672324406 | -122.45818336818 | (37.737672324406, -122.45818336818) | |||
173541 | 173541 | 206030 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 501x Monterey Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 4ft | 5998284.310380001 | 2094699.8261099998 | 37.7315482605292 | -122.44827661909201 | (37.7315482605292, -122.448276619092) | |||
173527 | 173527 | 244256 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 200x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005639.4577 | 2110060.8783 | 37.7741439057581 | -122.423940341347 | (37.7741439057581, -122.423940341347) | |||
173416 | 173416 | 212300 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 5991186.31185 | 2090192.49351 | 37.7187638967107 | -122.472487057435 | (37.7187638967107, -122.472487057435) | |||
173366 | 173366 | 180316 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1604x Alemany Blvd | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6001554.31065 | 2092335.28136 | 37.7252421648675 | -122.43680240921499 | (37.7252421648675, -122.436802409215) | |||
173360 | 173360 | 137725 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 800x DIVISADERO ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001532.7277 | 2111225.9053 | 37.7771100728165 | -122.438229692976 | (37.7771100728165, -122.438229692976) | |||
173128 | 173128 | 185117 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200x Sloat Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 28 | Width 0ft | 5987506.2336 | 2095918.1597 | 37.7342714110431 | -122.485627430105 | (37.7342714110431, -122.485627430105) | |||
173119 | 173119 | 211243 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50x Santa Rita Ave | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 22 | Width 5ft | 5993495.594269999 | 2100380.49402 | 37.746871017502706 | -122.46524447706999 | (37.7468710175027, -122.46524447707) | |||
173103 | 173103 | 221298 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 2800x Cesar Chavez St | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6010150.44695 | 2100616.45833 | 37.748465303245396 | -122.40766991113999 | (37.7484653032454, -122.40766991114) | |||
172971 | 172971 | 208311 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 700x Bosworth St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 5ft | 6001972.38304 | 2095452.1793900002 | 37.7338242081041 | -122.43558005878599 | (37.7338242081041, -122.435580058786) | |||
172817 | 172817 | 245965 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1950x Market St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | Width 0ft | 6005023.4835 | 2108512.8969 | 37.7698587289196 | -122.425960891085 | (37.7698587289196, -122.425960891085) | |||
172564 | 172564 | 211366 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 1x Minerva St | 35 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 5996338.39327 | 2089000.1724099999 | 37.7157869222084 | -122.45459238694401 | (37.7157869222084, -122.454592386944) | |||
172562 | 172562 | 180055 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000767.87775 | 2090597.6493799998 | 37.720426295310205 | -122.439396524348 | (37.7204262953102, -122.439396524348) | |||
172385 | 172385 | 200555 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 31 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6016252.4072 | 2095574.3949 | 37.7349605171331 | -122.386217789361 | (37.7349605171331, -122.386217789361) | |||
172378 | 172378 | 244353 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005598.6806 | 2110351.942 | 37.7749407940225 | -122.424102100187 | (37.7749407940225, -122.424102100187) | |||
172276 | 172276 | 211159 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 800x Portola Dr | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | Width 4ft | 5996511.507119999 | 2099115.91924 | 37.7435722673589 | -122.454724443377 | (37.7435722673589, -122.454724443377) | |||
172221 | 172221 | 245963 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1950x Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | Width 0ft | 6005062.3371 | 2108554.2304 | 37.7699744164919 | -122.425829439833 | (37.7699744164919, -122.425829439833) | |||
172193 | 172193 | 208302 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 600x Bosworth St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 6ft | 6002298.45936 | 2095373.7498299999 | 37.7336273734974 | -122.434447110867 | (37.7336273734974, -122.434447110867) | |||
172170 | 172170 | 137762 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1000x DIVISADERO ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001439.6617 | 2111903.7642 | 37.7789660085719 | -122.438600218498 | (37.7789660085719, -122.438600218498) | |||
172148 | 172148 | 205110 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Junipero Serra Blvd | 48 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 5991343.90426 | 2092703.6667900002 | 37.725668078393504 | -122.472125270987 | (37.7256680783935, -122.472125270987) | |||
172005 | 172005 | 200036 | DPW Maintained 3 | Cercis occidentalis :: Western Redbud 246 | 1500x Quesada Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6015497.9987 | 2094442.9756 | 37.7318120829921 | -122.38874711026399 | (37.7318120829921, -122.388747110264) | |||
171859 | 171859 | 211005 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 800x Portola Dr | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 4ft | 5996562.64616 | 2099171.2604900002 | 37.7437271539842 | -122.454551615288 | (37.7437271539842, -122.454551615288) | |||
171842 | 171842 | 180290 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1460x Alemany Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6002190.3660699995 | 2093508.3863 | 37.728499374443395 | -122.434687478938 | (37.7284993744434, -122.434687478938) | |||
171663 | 171663 | 213770 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 200x Monterey Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 4ft | 6000315.2619 | 2094667.17668 | 37.731574513540004 | -122.441252903117 | (37.73157451354, -122.441252903117) | |||
171600 | 171600 | 248622 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 142x McCoppin St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 26 | Width 0ft | 6005746.1935 | 2109104.2775 | 37.7715233357229 | -122.423503100629 | (37.7715233357229, -122.423503100629) | |||
171533 | 171533 | 206417 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 255x San Marcos Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 5ft | 5993040.30292 | 2100253.1432 | 37.7464950784009 | -122.466809562712 | (37.7464950784009, -122.466809562712) | |||
171458 | 171458 | 97373 | DPW Maintained 3 | Acer saccharinum :: Silver Maple 273 | 1351X Broadway | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | 6007014.5714300005 | 2118044.79728 | 37.796143331891706 | -122.419750186728 | (37.7961433318917, -122.419750186728) | ||||
171275 | 171275 | 199981 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1200x Shafter Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6017028.9443 | 2092601.7798 | 37.7268412531355 | -122.38332614590799 | (37.7268412531355, -122.383326145908) | |||
171233 | 171233 | 221443 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6005451.42839 | 2107920.02985 | 37.7682550341586 | -122.42443846228599 | (37.7682550341586, -122.424438462286) | |||
170857 | 170857 | 217727 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 100x Lincoln Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 5ft | 5995261.127780001 | 2107394.75932 | 37.7662320577801 | -122.45964742578998 | (37.7662320577801, -122.45964742579) | |||
170774 | 170774 | 180032 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6001123.43555 | 2091278.0147099998 | 37.722314653084396 | -122.438216192941 | (37.7223146530844, -122.438216192941) | |||
170719 | 170719 | 194307 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 200x The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | Width 5ft | 6015377.01126 | 2116388.0666 | 37.792061862225204 | -122.39069838843399 | (37.7920618622252, -122.390698388434) | |||
170700 | 170700 | 247515 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 250x Divisadero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001817.1167 | 2109233.3781 | 37.7716552616846 | -122.437103211063 | (37.7716552616846, -122.437103211063) | |||
170614 | 170614 | 212293 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 5991165.05081 | 2089858.71083 | 37.717846180842294 | -122.472536226064 | (37.7178461808423, -122.472536226064) | |||
170608 | 170608 | 244363 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6005533.5243 | 2110362.3292 | 37.7749656357807 | -122.42432822890801 | (37.7749656357807, -122.424328228908) | |||
170480 | 170480 | 245964 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1950x Market St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | Width 0ft | 6005048.2837 | 2108538.5237 | 37.7699304954931 | -122.42587693213301 | (37.7699304954931, -122.425876932133) | |||
170196 | 170196 | 217458 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 22 | Width 0ft | 5996270.87292 | 2089001.5829099999 | 37.7157869222056 | -122.454825868913 | (37.7157869222056, -122.454825868913) | |||
170156 | 170156 | 117839 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 600x 39th Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 5983810.52385 | 2111649.02031 | 37.7772479352498 | -122.499566680778 | (37.7772479352498, -122.499566680778) | |||
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) | |||
169856 | 169856 | 200573 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1400x La Salle Ave | 43 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 0ft | 6016335.7649 | 2095440.4518 | 37.734597349697104 | -122.385920256211 | (37.7345973496971, -122.385920256211) | |||
169800 | 169800 | 221482 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6005559.28434 | 2105952.19302 | 37.762857912083795 | -122.423925449408 | (37.7628579120838, -122.423925449408) | |||
169767 | 169767 | 221481 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005557.328430001 | 2105982.39063 | 37.7629407171602 | -122.423934361684 | (37.7629407171602, -122.423934361684) | |||
169745 | 169745 | 176068 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 700x Mansell St | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6009458.20535 | 2090043.50806 | 37.7193954735114 | -122.409317656201 | (37.7193954735114, -122.409317656201) | |||
169743 | 169743 | 137744 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1100x DIVISADERO ST | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001369.6084 | 2112388.3842 | 37.7802926669324 | -122.43887729860701 | (37.7802926669324, -122.438877298607) | |||
169662 | 169662 | 208300 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 600x Bosworth St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 6ft | 6002335.89975 | 2095363.88492 | 37.7336024119263 | -122.434316963673 | (37.7336024119263, -122.434316963673) | |||
169623 | 169623 | 222793 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 2800x Cesar Chavez St | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 6ft | 6010266.15939 | 2100660.65315 | 37.748593129264 | -122.40727289285101 | (37.748593129264, -122.407272892851) | |||
169550 | 169550 | 221558 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005728.5881 | 2102926.2105099997 | 37.754558828830106 | -122.423124788381 | (37.7545588288301, -122.423124788381) | |||
169529 | 169529 | 208276 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 5995860.94135 | 2098310.0569599997 | 37.7413222310459 | -122.456915650551 | (37.7413222310459, -122.456915650551) | |||
169462 | 169462 | 215032 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 300x Marietta Dr | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 5ft | 5999291.25805 | 2097565.13306 | 37.739473232107 | -122.44500132414801 | (37.739473232107, -122.445001324148) | |||
169431 | 169431 | 200546 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6016197.8191 | 2095632.8949 | 37.735118124804394 | -122.386410598906 | (37.7351181248044, -122.386410598906) | |||
169354 | 169354 | 117837 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 660x 39th Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 6ft | 5983820.01458 | 2111273.2343900003 | 37.776216692790705 | -122.49950607144899 | (37.7762166927907, -122.499506071449) | |||
169348 | 169348 | 210767 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 750x Parnassus Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 4ft | 5994619.5923 | 2106010.48038 | 37.7623942765042 | -122.46176597673599 | (37.7623942765042, -122.461765976736) | |||
169311 | 169311 | 140331 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400x WEBSTER ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6003635.6344 | 2113717.5722 | 37.784070947370296 | -122.431132969012 | (37.7840709473703, -122.431132969012) | |||
169296 | 169296 | 211238 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50x Santa Rita Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 23 | Width 5ft | 5993641.0282 | 2100369.29908 | 37.7468486648357 | -122.464740771274 | (37.7468486648357, -122.464740771274) | |||
169291 | 169291 | 231186 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2850x Bryant St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 5ft | 6009842.69971 | 2100715.50345 | 37.748720027217296 | -122.408741086441 | (37.7487200272173, -122.408741086441) | |||
169201 | 169201 | 200549 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6016205.8206 | 2095623.8265 | 37.7350936677212 | -122.386382302519 | (37.7350936677212, -122.386382302519) | |||
169172 | 169172 | 200560 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 37 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6016311.7963 | 2095496.5134 | 37.7347499571366 | -122.38600703115401 | (37.7347499571366, -122.386007031154) | |||
169141 | 169141 | 205089 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 42 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 5991231.16702 | 2090890.57712 | 37.7206832586037 | -122.47238287549601 | (37.7206832586037, -122.472382875496) | |||
169128 | 169128 | 210094 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 1x Minerva St | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 5996151.37066 | 2089000.9708099999 | 37.715778385846896 | -122.45523887719801 | (37.7157783858469, -122.455238877198) | |||
169025 | 169025 | 244305 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005579.7947 | 2110490.7532 | 37.775320869598204 | -122.424177304818 | (37.7753208695982, -122.424177304818) | |||
168960 | 168960 | 180278 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1204x Alemany Blvd | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6002788.01064 | 2094092.6752799999 | 37.7301376109521 | -122.43266311221001 | (37.7301376109521, -122.43266311221) | |||
168874 | 168874 | 140496 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 900x WEBSTER ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6003908.5877 | 2111892.4979 | 37.779075211733996 | -122.430058411766 | (37.779075211734, -122.430058411766) | |||
168829 | 168829 | 221544 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 900x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005705.623380001 | 2103333.32509 | 37.755675374928295 | -122.423233144119 | (37.7556753749283, -122.423233144119) | |||
168651 | 168651 | 212159 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 300x Marietta Dr | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 27 | Width 5ft | 5999137.09239 | 2097616.08451 | 37.739604332567794 | -122.445538022478 | (37.7396043325678, -122.445538022478) | |||
168489 | 168489 | 208213 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1600x Portola Dr | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 5992245.66958 | 2096691.5159099998 | 37.7366698618088 | -122.46929809835599 | (37.7366698618088, -122.469298098356) | |||
168366 | 168366 | 217730 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1200x Arguello Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 5995796.25486 | 2107257.89675 | 37.765887025696394 | -122.45778663137101 | (37.7658870256964, -122.457786631371) | |||
168334 | 168334 | 244338 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 102x Octavia St | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6005626.4106 | 2109908.4113 | 37.773724531640894 | -122.42397462928001 | (37.7737245316409, -122.42397462928) | |||
168209 | 168209 | 244332 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 102x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6005642.1688 | 2109804.2702 | 37.773439474978794 | -122.42391271229602 | (37.7734394749788, -122.423912712296) | |||
168192 | 168192 | 137721 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 800x DIVISADERO ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001519.5293 | 2111318.2945 | 37.7773629996088 | -122.438281970677 | (37.7773629996088, -122.438281970677) | |||
167769 | 167769 | 206461 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 100x Casitas Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 5995522.71914 | 2096987.57001 | 37.7376715797638 | -122.457989413181 | (37.7376715797638, -122.457989413181) | |||
167731 | 167731 | 177684 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 700x Mansell St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6009640.77537 | 2090111.56917 | 37.7195925824204 | -122.408691375527 | (37.7195925824204, -122.408691375527) | |||
167691 | 167691 | 245666 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 681x San Jose Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005857.27695 | 2099307.6356900004 | 37.744630313449 | -122.422422649005 | (37.744630313449, -122.422422649005) | |||
167542 | 167542 | 181237 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2100x Bay Shore Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 6ft | 6011709.60443 | 2087494.2224299998 | 37.712521531527294 | -122.40135630166 | (37.7125215315273, -122.40135630166) | |||
167503 | 167503 | 117838 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 660x 39th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 6ft | 5983820.62988 | 2111252.49481 | 37.7761597840052 | -122.499502409931 | (37.7761597840052, -122.499502409931) | |||
167490 | 167490 | 175615 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 100x Mansell St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6011400.018519999 | 2090633.7825099998 | 37.7211248500058 | -122.40264697809098 | (37.7211248500058, -122.402646978091) | |||
167470 | 167470 | 205331 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1x Minerva St | 30 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 5996300.3893099995 | 2089001.53161 | 37.715788474438206 | -122.45472384354099 | (37.7157884744382, -122.454723843541) | |||
167354 | 167354 | 208277 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 5995843.660130001 | 2098298.46411 | 37.741289407571294 | -122.45697456424601 | (37.7412894075713, -122.456974564246) | |||
167092 | 167092 | 211226 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2270x 09th Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 29 | Width 3ft | 5993310.66774 | 2100616.5192 | 37.747508416495 | -122.46590107748001 | (37.747508416495, -122.46590107748) | |||
167073 | 167073 | 210556 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 15x San Marcos Ave | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 5ft | 5993267.77676 | 2100290.91816 | 37.7466119245936 | -122.466025734301 | (37.7466119245936, -122.466025734301) | |||
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) | |||
167015 | 167015 | 220038 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 500x 27th St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 4ft | 6002807.79997 | 2100063.2344299997 | 37.7465325135634 | -122.433021102638 | (37.7465325135634, -122.433021102638) | |||
167005 | 167005 | 233636 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 758x San Jose Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 6005636.68539 | 2098604.551 | 37.7426873560463 | -122.42313544624399 | (37.7426873560463, -122.423135446244) | |||
166993 | 166993 | 107483 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1306x Montgomery St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | 6011458.52251 | 2119859.64432 | 37.8013757989196 | -122.404500953851 | (37.8013757989196, -122.404500953851) | ||||
166853 | 166853 | 176331 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 36 | Median : Cutout 11 | Tree 1 | DPW 2 | 27 | Width 0ft | 6009160.31915 | 2089943.1989099998 | 37.7191033512163 | -122.410340263619 | (37.7191033512163, -122.410340263619) | |||
166845 | 166845 | 219229 | DPW Maintained 3 | Ilex spp :: Holly Species 163 | 300x Marietta Dr | 47 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 5ft | 5999539.4664199995 | 2097492.37053 | 37.7392876066259 | -122.44413790396601 | (37.7392876066259, -122.444137903966) | |||
166645 | 166645 | 215738 | DPW Maintained 3 | Ulmus spp :: Elm Spp 215 | 15x San Marcos Ave | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 5ft | 5993371.7553900005 | 2100358.3023099997 | 37.7468029424032 | -122.46567108486799 | (37.7468029424032, -122.465671084868) |
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");