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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
180983 | 180983 | 200531 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6016156.3167 | 2095682.0459 | 37.7352507861079 | -122.386557515095 | (37.7352507861079, -122.386557515095) | |||
180976 | 180976 | 217454 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 0ft | 5996047.542640001 | 2089003.42322 | 37.7157791619486 | -122.45559792969601 | (37.7157791619486, -122.455597929696) | |||
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) | |||
180833 | 180833 | 175622 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 700x Mansell St | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6009430.205130001 | 2090028.38757 | 37.7193523869705 | -122.40941337645 | (37.7193523869705, -122.40941337645) | |||
180648 | 180648 | 204549 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 66 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 5ft | 5999718.509930001 | 2097359.75923 | 37.7389337000243 | -122.44350932999 | (37.7389337000243, -122.44350932999) | |||
180608 | 180608 | 225049 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 500x 27th St | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 4ft | 6002919.63953 | 2100068.3028700002 | 37.7465527734974 | -122.432634735922 | (37.7465527734974, -122.432634735922) | |||
180603 | 180603 | 206418 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 99x Castenada Ave | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 5ft | 5993828.80673 | 2100251.01259 | 37.7465347043225 | -122.464082870453 | (37.7465347043225, -122.464082870453) | |||
180560 | 180560 | 211626 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 299x Magellan Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 6ft | 5994442.33797 | 2100102.5844900003 | 37.7461624991943 | -122.46195060033399 | (37.7461624991943, -122.461950600334) | |||
180482 | 180482 | 217529 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 1x Minerva St | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | Width 0ft | 5996247.03619 | 2089001.7982400001 | 37.7157861460877 | -122.45490827471599 | (37.7157861460877, -122.454908274716) | |||
180359 | 180359 | 208262 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 900x Portola Dr | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 5996288.991880001 | 2098815.5269 | 37.7427346981622 | -122.455472135224 | (37.7427346981622, -122.455472135224) | |||
180267 | 180267 | 221556 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005741.57845 | 2102677.06839 | 37.753875475376 | -122.42306215689501 | (37.753875475376, -122.423062156895) | |||
180234 | 180234 | 247518 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 300x Divisadero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001762.8451 | 2109678.405 | 37.7728741096846 | -122.437322810858 | (37.7728741096846, -122.437322810858) | |||
180180 | 180180 | 180294 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500x Alemany Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6001976.82417 | 2093214.99008 | 37.7276816496801 | -122.435404724267 | (37.7276816496801, -122.435404724267) | |||
180140 | 180140 | 199523 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 1150x Tennessee St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 4ft | 6015556.62319 | 2103663.95863 | 37.7571342443646 | -122.389188058008 | (37.7571342443646, -122.389188058008) | |||
180119 | 180119 | 177682 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 500x Mansell St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 6010419.57085 | 2090347.6649900002 | 37.7202844416499 | -122.406015971566 | (37.7202844416499, -122.406015971566) | |||
179995 | 179995 | 137750 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1000x DIVISADERO ST | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001422.0638 | 2112046.2398 | 37.779356209408995 | -122.43867130831 | (37.779356209409, -122.43867130831) | |||
179926 | 179926 | 176358 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 300x Mansell St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | Width 0ft | 6010959.21222 | 2090503.85024 | 37.720743461908995 | -122.40416158569599 | (37.720743461909, -122.404161585696) | |||
179832 | 179832 | 180287 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1416x Alemany Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6002337.82047 | 2093711.5292900002 | 37.7290655291296 | -122.434192238485 | (37.7290655291296, -122.434192238485) | |||
179825 | 179825 | 208220 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1600x Portola Dr | 28 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 5992380.47609 | 2096824.50033 | 37.737042792691895 | -122.46884169241001 | (37.7370427926919, -122.46884169241) | |||
179815 | 179815 | 217437 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 601x Monterey Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 4ft | 5997794.81955 | 2094706.79322 | 37.7315393941054 | -122.449969377904 | (37.7315393941054, -122.449969377904) | |||
179776 | 179776 | 205767 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 5ft | 5999244.31767 | 2097578.6483400003 | 37.7395076626552 | -122.445164594286 | (37.7395076626552, -122.445164594286) | |||
179590 | 179590 | 204529 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 400x Marietta Dr | 29 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 3ft | 5999184.7705 | 2097021.0106799998 | 37.7379731233579 | -122.44533039778999 | (37.7379731233579, -122.44533039779) | |||
179520 | 179520 | 140602 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 700x WEBSTER ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6003984.6897 | 2111298.7883 | 37.7774493417916 | -122.429752786414 | (37.7774493417916, -122.429752786414) | |||
179339 | 179339 | 139329 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1350x GEARY BLVD | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6005196.3246 | 2114113.3931 | 37.785246088934706 | -122.425761723999 | (37.7852460889347, -122.425761723999) | |||
179323 | 179323 | 221491 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6005578.642000001 | 2105634.14294 | 37.7619857144891 | -122.423835881448 | (37.7619857144891, -122.423835881448) | |||
179257 | 179257 | 208275 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 5995884.520690001 | 2098326.53098 | 37.741368818629 | -122.456835313194 | (37.741368818629, -122.456835313194) | |||
179210 | 179210 | 180051 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000819.2999599995 | 2090695.20934 | 37.7206970991836 | -122.43922576376801 | (37.7206970991836, -122.439225763768) | |||
179057 | 179057 | 217462 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 48 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 0ft | 5996487.36469 | 2088998.4739599999 | 37.7157908018916 | -122.454077353311 | (37.7157908018916, -122.454077353311) | |||
178961 | 178961 | 221541 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 900x Guerrero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005710.1718 | 2103251.3867 | 37.7554506478492 | -122.423211590049 | (37.7554506478492, -122.423211590049) | |||
178932 | 178932 | 176320 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 0ft | 6009693.65645 | 2090109.67926 | 37.7195903547889 | -122.408508450717 | (37.7195903547889, -122.408508450717) | |||
178863 | 178863 | 178252 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100x Mansell St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 28 | Width 0ft | 6011405.602080001 | 2090646.90467 | 37.7211611925117 | -122.402628599549 | (37.7211611925117, -122.402628599549) | |||
178847 | 178847 | 208279 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 5995785.55074 | 2098260.3465 | 37.7411814088878 | -122.457172728052 | (37.7411814088878, -122.457172728052) | |||
178808 | 178808 | 205676 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 501x Ortega St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 2ft | 5992530.35141 | 2103103.67505 | 37.754292459543 | -122.468780293 | (37.754292459543, -122.468780293) | |||
178708 | 178708 | 208382 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 200x Dorantes Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 3ft | 5993521.04534 | 2099745.47865 | 37.7451288940009 | -122.465110355772 | (37.7451288940009, -122.465110355772) | |||
178685 | 178685 | 211622 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 299x Magellan Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 6ft | 5994374.65588 | 2100035.76883 | 37.745975143439104 | -122.46217978988899 | (37.7459751434391, -122.462179789889) | |||
178645 | 178645 | 247510 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 400x Divisadero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001703.2636 | 2110010.3317 | 37.7737821102395 | -122.43755268459299 | (37.7737821102395, -122.437552684593) | |||
178643 | 178643 | 180268 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1204x Alemany Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6003087.38761 | 2094197.7854099998 | 37.730443193382605 | -122.43163562957399 | (37.7304431933826, -122.431635629574) | |||
178530 | 178530 | 180283 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1370x Alemany Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6002508.03305 | 2093910.51217 | 37.7296215502929 | -122.433618015959 | (37.7296215502929, -122.433618015959) | |||
178382 | 178382 | 247517 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 250x Divisadero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001820.5087 | 2109214.383 | 37.771603298669 | -122.437090117747 | (37.771603298669, -122.437090117747) | |||
178271 | 178271 | 176340 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 200x Mansell St | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6011135.84107 | 2090535.2556900003 | 37.720839562571996 | -122.403553239308 | (37.720839562572, -122.403553239308) | |||
178254 | 178254 | 221510 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1300x Guerrero St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005838.80296 | 2100921.0233299998 | 37.7490592658716 | -122.422601154533 | (37.7490592658716, -122.422601154533) | |||
178250 | 178250 | 246357 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2100x Market St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 32 | Width 0ft | 6003963.462 | 2107490.3857 | 37.7669911968193 | -122.429554546796 | (37.7669911968193, -122.429554546796) | |||
178223 | 178223 | 205766 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 5ft | 5999230.5906 | 2097582.30956 | 37.7395169319577 | -122.4452123195 | (37.7395169319577, -122.4452123195) | |||
178216 | 178216 | 211338 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 501x Ortega St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 2ft | 5992538.26817 | 2103091.89381 | 37.7542605686777 | -122.46875205786999 | (37.7542605686777, -122.46875205787) | |||
178207 | 178207 | 198003 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 920x Jamestown Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 5ft | 6014527.01214 | 2089285.60779 | 37.7175971171782 | -122.391743566112 | (37.7175971171782, -122.391743566112) | |||
178018 | 178018 | 209211 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 99x San Marcos Ave | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 5993782.2667 | 2100229.04683 | 37.7464717095186 | -122.46424220511601 | (37.7464717095186, -122.464242205116) | |||
178016 | 178016 | 180311 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1604x Alemany Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 6001617.96298 | 2092474.2998799998 | 37.7256274955847 | -122.436592315896 | (37.7256274955847, -122.436592315896) | |||
177984 | 177984 | 205677 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 501x Ortega St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 5992540.21682 | 2103087.49694 | 37.7542486085892 | -122.468744999088 | (37.7542486085892, -122.468744999088) | |||
177897 | 177897 | 130224 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1400x Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 4ft | 6006293.97441 | 2115456.1680900003 | 37.7889949833896 | -122.422059611555 | (37.7889949833896, -122.422059611555) | |||
177873 | 177873 | 221550 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6005729.97057 | 2102894.68155 | 37.7544723356343 | -122.423117766494 | (37.7544723356343, -122.423117766494) | |||
177808 | 177808 | 112591 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1200X Divisadero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | 3x3 | 6001352.6873 | 2112575.8699 | 37.7808064923129 | -122.438949276348 | (37.7808064923129, -122.438949276348) | |||
177749 | 177749 | 200602 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 45 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6016396.2402 | 2095212.996 | 37.7339761481789 | -122.385695323117 | (37.7339761481789, -122.385695323117) | |||
177704 | 177704 | 180068 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 38 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000492.17507 | 2090236.21555 | 37.71941818588179 | -122.440323630039 | (37.7194181858818, -122.440323630039) | |||
177617 | 177617 | 176070 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 700x Mansell St | 34 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 0ft | 6009191.21918 | 2089961.56598 | 37.7191555154919 | -122.410234749751 | (37.7191555154919, -122.410234749751) | |||
177490 | 177490 | 176319 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | Width 0ft | 6009753.29629 | 2090123.38013 | 37.7196313144016 | -122.40830326229602 | (37.7196313144016, -122.408303262296) | |||
177475 | 177475 | 126129 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 2800x Van Ness Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 6ft | 6005644.09156 | 2120125.76706 | 37.8017798472085 | -122.424640432904 | (37.8017798472085, -122.424640432904) | |||
177471 | 177471 | 180084 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2100x Alemany Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000104.08716 | 2089866.26451 | 37.7183802800914 | -122.441638567472 | (37.7183802800914, -122.441638567472) | |||
177449 | 177449 | 247507 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 400x Divisadero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001724.6395 | 2109878.2699 | 37.7734207168265 | -122.437469283257 | (37.7734207168265, -122.437469283257) | |||
177434 | 177434 | 211173 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 800x Junipero Serra Blvd | 54 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | Width 0ft | 5991356.551080001 | 2092861.75062 | 37.7261028691334 | -122.472093069844 | (37.7261028691334, -122.472093069844) | |||
177416 | 177416 | 180100 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2200x Alemany Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 5999678.44391 | 2089461.99311 | 37.7172459822806 | -122.44308081565 | (37.7172459822806, -122.44308081565) | |||
177316 | 177316 | 97367 | DPW Maintained 3 | Acer saccharinum :: Silver Maple 273 | 1263X Robert C Levy Tunl | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | 6007448.14227 | 2118102.63987 | 37.79632656786411 | -122.418254043985 | (37.7963265678641, -122.418254043985) | ||||
177231 | 177231 | 200533 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1400x La Salle Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6016162.6096 | 2095677.4311 | 37.7352384631645 | -122.38653543635799 | (37.7352384631645, -122.386535436358) | |||
177190 | 177190 | 200529 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1400x La Salle Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 0ft | 6016150.0239 | 2095691.2754 | 37.7352757800904 | -122.386579915171 | (37.7352757800904, -122.386579915171) | |||
177174 | 177174 | 180070 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 41 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000442.5181599995 | 2090189.01132 | 37.7192857463155 | -122.440491891393 | (37.7192857463155, -122.440491891393) | |||
177057 | 177057 | 221539 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1100x Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 3ft | 6005756.51513 | 2102435.1394700003 | 37.753212037416 | -122.422993308391 | (37.753212037416, -122.422993308391) | |||
177037 | 177037 | 246965 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 250x Noe St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 5ft | 6002901.60437 | 2106802.37956 | 37.7650419192671 | -122.433178178236 | (37.7650419192671, -122.433178178236) | |||
176843 | 176843 | 106329 | DPW Maintained 3 | Prunus x yedoensis :: Yoshino Cherry 237 | 600X Webster St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 12x30 | 6004014.02744 | 2111067.07552 | 37.7768147769105 | -122.429634767527 | (37.7768147769105, -122.429634767527) | |||
176821 | 176821 | 244373 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005612.0227 | 2109867.6455 | 37.7736117862994 | -122.424021499783 | (37.7736117862994, -122.424021499783) | |||
176764 | 176764 | 221549 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6005728.89674 | 2102911.59468 | 37.7545187145683 | -122.423122682192 | (37.7545187145683, -122.423122682192) | |||
176679 | 176679 | 180039 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 32 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6001024.8340300005 | 2091089.76883 | 37.7217921640611 | -122.43854355335199 | (37.7217921640611, -122.438543553352) | |||
176650 | 176650 | 180059 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000706.97869 | 2090484.68802 | 37.7201126630403 | -122.439598938365 | (37.7201126630403, -122.439598938365) | |||
176544 | 176544 | 221552 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005734.10722 | 2102815.94179 | 37.754256367947704 | -122.423097864468 | (37.7542563679477, -122.423097864468) | |||
176520 | 176520 | 211355 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 300x Marietta Dr | 30 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 5ft | 5999309.78108 | 2097559.20163 | 37.7394580029801 | -122.444936853564 | (37.7394580029801, -122.444936853564) | |||
176308 | 176308 | 244427 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 102x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 6005661.3527 | 2109672.0384 | 37.7730774813758 | -122.423836948028 | (37.7730774813758, -122.423836948028) | |||
176294 | 176294 | 139358 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1350x GEARY BLVD | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 19 | Width 0ft | 6004934.0187 | 2114075.446 | 37.7851270694756 | -122.426666519258 | (37.7851270694756, -122.426666519258) | |||
176178 | 176178 | 141591 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 700x DIVISADERO ST | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6001556.326 | 2111042.9577 | 37.776609086888 | -122.438134950627 | (37.776609086888, -122.438134950627) | |||
176168 | 176168 | 204428 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 501x Ortega St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 5992543.86372 | 2103078.2348599997 | 37.754223388005 | -122.46873171339199 | (37.754223388005, -122.468731713392) | |||
176150 | 176150 | 138268 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2800x GEARY BLVD | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 42 | Width 0ft | 5998223.1317 | 2113127.3282 | 37.782142096338795 | -122.449815635357 | (37.7821420963388, -122.449815635357) | |||
176077 | 176077 | 176104 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700x Mansell St | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 26 | Width 0ft | 6009423.2681599995 | 2090026.7428 | 37.7193474820922 | -122.409437239052 | (37.7193474820922, -122.409437239052) | |||
176025 | 176025 | 244355 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6005591.5984 | 2110402.9339 | 37.7750804055544 | -122.42413022622601 | (37.7750804055544, -122.424130226226) | |||
175826 | 175826 | 205330 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1x Minerva St | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 5996263.21296 | 2089001.7429400003 | 37.715786922213 | -122.45485235667 | (37.715786922213, -122.45485235667) | |||
175756 | 175756 | 181248 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011168.55226 | 2087238.084 | 37.7117880246642 | -122.403208349279 | (37.7117880246642, -122.403208349279) | |||
175662 | 175662 | 215033 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 300x Marietta Dr | 28 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 5ft | 5999299.88675 | 2097560.85432 | 37.739461976177395 | -122.44497118247699 | (37.7394619761774, -122.444971182477) | |||
175620 | 175620 | 117840 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 600x 39th Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 6ft | 5983808.599090001 | 2111637.58628 | 37.777216427782896 | -122.499572493795 | (37.7772164277829, -122.499572493795) | |||
175519 | 175519 | 211235 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50x Santa Rita Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 22 | Width 5ft | 5993688.66706 | 2100390.50163 | 37.7469096280744 | -122.46457758119301 | (37.7469096280744, -122.464577581193) | |||
175385 | 175385 | 204558 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 56 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 5ft | 5999610.45434 | 2097460.9174599997 | 37.739205293478896 | -122.44389020099399 | (37.7392052934789, -122.443890200994) | |||
175298 | 175298 | 179168 | DPW Maintained 3 | Prunus blireiana :: Flowering Plum 102 | 200x Mansell St | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 6011032.14311 | 2090534.0564299999 | 37.7208304767293 | -122.40391160924 | (37.7208304767293, -122.40391160924) | |||
175278 | 175278 | 199890 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 1200x Quesada Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6017354.2822 | 2093058.6837 | 37.7281137963921 | -122.382233221943 | (37.7281137963921, -122.382233221943) | |||
175240 | 175240 | 205765 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 5ft | 5999225.79466 | 2097584.57981 | 37.739522891768395 | -122.44522906489401 | (37.7395228917684, -122.445229064894) | |||
175115 | 175115 | 219878 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2x Montezuma St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 6007278.55035 | 2099761.42955 | 37.7459564033742 | -122.41754030963699 | (37.7459564033742, -122.417540309637) | |||
175089 | 175089 | 107489 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1306x Montgomery St | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | 6011451.881469999 | 2119930.90855 | 37.801571101985004 | -122.40452895426901 | (37.801571101985, -122.404528954269) | ||||
175009 | 175009 | 231185 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2850x Bryant St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 5ft | 6009841.33523 | 2100729.29077 | 37.74875780773171 | -122.408746777365 | (37.7487578077317, -122.408746777365) | |||
174998 | 174998 | 184611 | DPW Maintained 3 | :: 54 | 3800x Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 0ft | 5982199.0286 | 2102854.3652 | 37.753005653234204 | -122.504489538097 | (37.7530056532342, -122.504489538097) | |||
174961 | 174961 | 222627 | DPW Maintained 3 | Ceanothus Sps :: California lilac 270 | 322x Elsie St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 3ft | 6006329.86925 | 2096925.87693 | 37.7381171866669 | -122.42061947320299 | (37.7381171866669, -122.420619473203) | |||
174904 | 174904 | 217433 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 501x Monterey Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 4ft | 5998496.43118 | 2094696.04115 | 37.731549992634605 | -122.447543007012 | (37.7315499926346, -122.447543007012) | |||
174777 | 174777 | 205080 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 31 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 5991211.60542 | 2090562.33735 | 37.7197808608892 | -122.47242657625 | (37.7197808608892, -122.47242657625) | |||
174741 | 174741 | 211335 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 501x Ortega St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 5992526.64779 | 2103107.81832 | 37.7543036219218 | -122.468793402415 | (37.7543036219218, -122.468793402415) | |||
174730 | 174730 | 97362 | DPW Maintained 3 | Acer saccharinum :: Silver Maple 273 | 1263X Robert C Levy Tunl | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | 6007524.81802 | 2118113.4619299998 | 37.796360598225796 | -122.41798949673901 | (37.7963605982258, -122.417989496739) | ||||
174719 | 174719 | 204533 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 400x Marietta Dr | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 3ft | 5999422.62995 | 2097044.63622 | 37.7380515685181 | -122.444509700769 | (37.7380515685181, -122.444509700769) | |||
174630 | 174630 | 249485 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1400x Van Ness Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6006288.55578 | 2115489.9349599998 | 37.7890873932245 | -122.42208075914 | (37.7890873932245, -122.42208075914) |
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");