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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5168 | 5168 | 152422 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 700x Guerrero St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005644.9376300005 | 2104427.7274700003 | 37.7586769234173 | -122.423520817442 | (37.7586769234173, -122.423520817442) | |||
5263 | 5263 | 8574 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6 | 6001134.4053 | 2113480.9790000003 | 37.783279269060294 | -122.43976932905301 | (37.7832792690603, -122.439769329053) | |||
5271 | 5271 | 8390 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1500 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 8 | 6004488.7034 | 2114010.5767 | 37.784923768316396 | -122.428202546761 | (37.7849237683164, -122.428202546761) | |||
5273 | 5273 | 8391 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1500 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 8 | 6004438.3798 | 2114005.2394 | 37.784906265949004 | -122.428376269712 | (37.784906265949, -122.428376269712) | |||
5279 | 5279 | 23791 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100X Webster St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 20 | 6003783.4554 | 2112735.7654 | 37.7813835268154 | -122.430551482109 | (37.7813835268154, -122.430551482109) | |||
5280 | 5280 | 8392 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1500 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 8 | 6004378.143999999 | 2113996.8521 | 37.784879827842296 | -122.428584068109 | (37.7848798278423, -122.428584068109) | |||
5299 | 5299 | 4716 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000X Columbus Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 3 | 6008306.8566 | 2120868.0824 | 37.803968081269204 | -122.415478587922 | (37.8039680812692, -122.415478587922) | |||
5311 | 5311 | 8577 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 6 | 6000958.4259 | 2113453.9053 | 37.783194913277796 | -122.440376203878 | (37.7831949132778, -122.440376203878) | |||
5350 | 5350 | 28646 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1600X Webster St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 6 | 6003557.7645 | 2114374.9896 | 37.7858716371659 | -122.431449317827 | (37.7858716371659, -122.431449317827) | |||
5356 | 5356 | 17193 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2235X Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20 | 6004642.48731 | 2116869.91995 | 37.792783506093706 | -122.427874318555 | (37.7927835060937, -122.427874318555) | |||
5380 | 5380 | 23543 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2800X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 9 | 6005659.04127 | 2120027.6333 | 37.8015112413055 | -122.424581715282 | (37.8015112413055, -122.424581715282) | |||
5433 | 5433 | 8620 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600 Geary Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5999320.4644 | 2113220.5634 | 37.7824608186771 | -122.446026081758 | (37.7824608186771, -122.446026081758) | |||
5443 | 5443 | 23446 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2100X Van Ness Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6005973.04919 | 2117793.46515 | 37.7953945104887 | -122.423336192033 | (37.7953945104887, -122.423336192033) | |||
5451 | 5451 | 23407 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1748X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006159.63822 | 2116414.10982 | 37.791617675355795 | -122.422592496742 | (37.7916176753558, -122.422592496742) | |||
5461 | 5461 | 23583 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 3100X Van Ness Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 9 | 6005493.5455 | 2121226.7269099997 | 37.8047942964921 | -122.425239779807 | (37.8047942964921, -122.425239779807) | |||
5467 | 5467 | 27939 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X The Embarcadero | 8 | Median : Cutout 11 | Tree 1 | Port 9 | 36 | 4X4 | 6013788.66429 | 2118525.16075 | 37.7978415693921 | -122.396343981507 | (37.7978415693921, -122.396343981507) | |||
5624 | 5624 | 23856 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400X Webster St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 3X3 | 6003669.3238 | 2113580.0643 | 37.7836952941839 | -122.4310065985 | (37.7836952941839, -122.4310065985) | |||
5633 | 5633 | 8583 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2200 Geary Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 6 | 6000590.222999999 | 2113406.0186 | 37.7830424571155 | -122.441646596602 | (37.7830424571155, -122.441646596602) | |||
5634 | 5634 | 23786 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1100X Webster St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 8X8 | 6003813.7072 | 2112544.6294 | 37.780860428691895 | -122.43043318397301 | (37.7808604286919, -122.430433183973) | |||
5719 | 5719 | 16360 | DPW Maintained 3 | Populus tremuloides :: Quaking aspen 166 | 1306X Montgomery St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 42 | 8 | 6011456.11099 | 2119859.6934 | 37.801375798912794 | -122.404509302284 | (37.8013757989128, -122.404509302284) | |||
5798 | 5798 | 8630 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600 Geary Blvd | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5999216.9073 | 2113207.365 | 37.7824186652585 | -122.44638339297501 | (37.7824186652585, -122.446383392975) | |||
5866 | 5866 | 14435 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 90X Masonic Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 3X3 | 5998902.8519 | 2113071.3194 | 37.7820271773983 | -122.447460087026 | (37.7820271773983, -122.447460087026) | |||
5913 | 5913 | 23706 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 700X Webster St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 8X8 | 6003994.1877 | 2111257.6303 | 37.7773368699173 | -122.42971699343799 | (37.7773368699173, -122.429716993438) | |||
5918 | 5918 | 23710 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 700X Webster St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003962.5277 | 2111419.0963 | 37.77777842285779 | -122.429838035535 | (37.7777784228578, -122.429838035535) | |||
5919 | 5919 | 28639 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300 Webster St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 20 | 6003713.3264 | 2113228.0439 | 37.7827312275464 | -122.43082923608401 | (37.7827312275464, -122.430829236084) | |||
5929 | 5929 | 8470 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1900 Geary Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 8 | 6002187.2355 | 2113695.2 | 37.7839273365059 | -122.43614229642701 | (37.7839273365059, -122.436142296427) | |||
5947 | 5947 | 8624 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2600 Geary Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5999301.8512 | 2113214.4718 | 37.782443029823206 | -122.446090036766 | (37.7824430298232, -122.446090036766) | |||
5957 | 5957 | 28643 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1300 Webster St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | 20 | 6003700.2631 | 2113325.6745 | 37.7829985565916 | -122.43088139933201 | (37.7829985565916, -122.430881399332) | |||
5993 | 5993 | 23902 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1600X Webster St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 20 | 6003560.0188 | 2114334.411 | 37.7857603463241 | -122.431438620741 | (37.7857603463241, -122.431438620741) | |||
6012 | 6012 | 27414 | DPW Maintained 3 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 2300 Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 9 | 6005892.4011 | 2118361.12861 | 37.7969486190501 | -122.42365562852801 | (37.7969486190501, -122.423655628528) | |||
6044 | 6044 | 107491 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 6011446.048280001 | 2119975.7461599996 | 37.8016938891322 | -122.40455229795 | (37.8016938891322, -122.40455229795) | ||||
6071 | 6071 | 29679 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1900X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006078.2689 | 2117059.9303200003 | 37.7933863459523 | -122.422919954291 | (37.7933863459523, -122.422919954291) | ||||
6075 | 6075 | 23828 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1200X Webster St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003742.203 | 2113074.035 | 37.78230999365589 | -122.430718341656 | (37.7823099936559, -122.430718341656) | |||
6096 | 6096 | 8399 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Geary Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6003960.687000001 | 2113944.6223 | 37.7847127843654 | -122.430024606782 | (37.7847127843654, -122.430024606782) | |||
6099 | 6099 | 4714 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000X Columbus Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 3 | 6008373.9156 | 2120808.2881 | 37.8038076701269 | -122.415242289828 | (37.8038076701269, -122.415242289828) | |||
6122 | 6122 | 23406 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1748X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 9 | 6006168.03383 | 2116381.79756 | 37.7915294275986 | -122.42256115088499 | (37.7915294275986, -122.422561150885) | |||
6165 | 6165 | 14421 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X Masonic Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 3X3 | 5998843.9665 | 2113055.4136 | 37.7819801389805 | -122.44766265742399 | (37.7819801389805, -122.447662657424) | |||
6171 | 6171 | 8616 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2600 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 5999337.0471 | 2113224.2861 | 37.78247198716561 | -122.44596898090299 | (37.7824719871656, -122.445968980903) | |||
6197 | 6197 | 23919 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1700X Webster St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6x6 | 6003523.3584 | 2114587.3577 | 37.7864527963196 | -122.431583520291 | (37.7864527963196, -122.431583520291) | |||
6248 | 6248 | 23822 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Webster St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 20 | 6003768.3296 | 2112880.8363 | 37.7817809984294 | -122.430614164895 | (37.7817809984294, -122.430614164895) | |||
6262 | 6262 | 23731 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 800X Webster St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 6003929.9014 | 2111682.7982 | 37.7785006353915 | -122.429969716521 | (37.7785006353915, -122.429969716521) | |||
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) | |||
6297 | 6297 | 4668 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 600X Columbus Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 3 | 6009590.6555 | 2119701.3035 | 37.8008364710267 | -122.41095344028601 | (37.8008364710267, -122.410953440286) | |||
6368 | 6368 | 8674 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2900 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | M6 | 5998029.5545 | 2113103.6387 | 37.7820659737765 | -122.45048361361201 | (37.7820659737765, -122.450483613612) | |||
6382 | 6382 | 8738 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3300X Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6x10 | 5996893.3032 | 2112947.7955 | 37.7815729712314 | -122.45440324333 | (37.7815729712314, -122.45440324333) | |||
6394 | 6394 | 8581 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 6 | 6000715.1007 | 2113420.9091 | 37.7830904567466 | -122.441215640748 | (37.7830904567466, -122.441215640748) | |||
6395 | 6395 | 8394 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1500 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 8 | 6004234.0356 | 2113977.7901 | 37.784819331933 | -122.429081276927 | (37.784819331933, -122.429081276927) | |||
6402 | 6402 | 23443 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2100X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 9 | 6005986.240069999 | 2117685.53144 | 37.7950988961632 | -122.423282873032 | (37.7950988961632, -122.423282873032) | |||
6405 | 6405 | 8469 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1900 Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 8 | 6002244.0904 | 2113695.2 | 37.7839305664786 | -122.435945599699 | (37.7839305664786, -122.435945599699) | |||
6409 | 6409 | 17195 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2235X Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20 | 6004631.93349 | 2116900.78038 | 37.7928676439669 | -122.427913035268 | (37.7928676439669, -122.427913035268) | |||
6463 | 6463 | 8468 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1900 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 8 | 6002285.3778 | 2113701.9684 | 37.7839514961521 | -122.435803245129 | (37.7839514961521, -122.435803245129) | |||
6495 | 6495 | 26421 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2235X Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 6004624.1328 | 2116974.76242 | 37.793070338586205 | -122.427945300259 | (37.7930703385862, -122.427945300259) | |||
6496 | 6496 | 23490 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2500X Van Ness Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6005777.87956 | 2119177.1307599996 | 37.799182688783496 | -122.424109961515 | (37.7991826887835, -122.424109961515) | |||
6510 | 6510 | 8398 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Geary Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6003997.2859 | 2113948.4347 | 37.784725324941604 | -122.429898258777 | (37.7847253249416, -122.429898258777) | |||
6534 | 6534 | 23551 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2900X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 6005612.78895 | 2120375.11437 | 37.802462723129395 | -122.424766503478 | (37.8024627231294, -122.424766503478) | ||||
6651 | 6651 | 16365 | DPW Maintained 3 | Ligustrum japonicum :: Japanese Privet 4 | 1306X Montgomery St | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6011450.07983 | 2119965.49195 | 37.8016659588815 | -122.40453762461901 | (37.8016659588815, -122.404537624619) | |||
6701 | 6701 | 8474 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1900 Geary Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6001879.2717 | 2113651.8819999998 | 37.7837908949329 | -122.437204633286 | (37.7837908949329, -122.437204633286) | |||
6721 | 6721 | 8476 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1900 Geary Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 8 | 6001756.762999999 | 2113633.6072 | 37.783733752237 | -122.437627157513 | (37.783733752237, -122.437627157513) | |||
6783 | 6783 | 14432 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 90X Masonic Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 3X3 | 5998887.9614 | 2113022.2482 | 37.781891589698894 | -122.44750806785801 | (37.7818915896989, -122.447508067858) | |||
6800 | 6800 | 23823 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1200X Webster St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003765.5794 | 2112902.15 | 37.781839364726 | -122.430625200646 | (37.781839364726, -122.430625200646) | |||
6839 | 6839 | 8584 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2200 Geary Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 6 | 6000533.0297 | 2113398.5733 | 37.7830187554699 | -122.441843926918 | (37.7830187554699, -122.441843926918) | |||
6873 | 6873 | 23463 | DPW Maintained 3 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 2300 Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 9 | 6005896.8378 | 2118341.60488 | 37.7968952622641 | -122.423638887645 | (37.7968952622641, -122.423638887645) | |||
6919 | 6919 | 8636 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2600 Geary Blvd | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5999097.4445 | 2113192.4744 | 37.782370955794605 | -122.446795608488 | (37.7823709557946, -122.446795608488) | |||
6949 | 6949 | 23761 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 900X Webster St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 20 | 6003883.1487 | 2112042.3815 | 37.7794853141392 | -122.430157111124 | (37.7794853141392, -122.430157111124) | |||
6953 | 6953 | 23580 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 3100X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 9 | 6005507.77084 | 2121129.71298 | 37.8045287248816 | -122.42518364411501 | (37.8045287248816, -122.425183644115) | |||
7003 | 7003 | 14431 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X Masonic Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 3X3 | 5998857.8418 | 2113111.93 | 37.7821361113043 | -122.44761872504499 | (37.7821361113043, -122.447618725045) | |||
7009 | 7009 | 27938 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X The Embarcadero | 7 | Median : Cutout 11 | Tree 1 | Port 9 | 36 | 4X4 | 6013758.52527 | 2118508.2804400004 | 37.7977935429048 | -122.396447087875 | (37.7977935429048, -122.396447087875) | |||
7023 | 7023 | 23544 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2800X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 9 | 6005656.2038 | 2120054.10262 | 37.80158375904121 | -122.424593418169 | (37.8015837590412, -122.424593418169) | |||
7036 | 7036 | 16366 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 1306X Montgomery St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 8 | 6011454.042780001 | 2119896.37482 | 37.8014764015683 | -122.40451904281299 | (37.8014764015683, -122.404519042813) | |||
7054 | 7054 | 4734 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100X Columbus Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 3x3 | 6007950.0877 | 2121194.0464 | 37.80484303663339 | -122.416736319981 | (37.8048430366334, -122.416736319981) | |||
7067 | 7067 | 28641 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1300 Webster St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 20 | 6003709.2011 | 2113267.9212 | 37.7828404869024 | -122.43084635463 | (37.7828404869024, -122.43084635463) | |||
7070 | 7070 | 8575 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 6 | 6001093.7947 | 2113474.2106 | 37.7832583731226 | -122.439909339764 | (37.7832583731226, -122.439909339764) | |||
7107 | 7107 | 4638 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 500X Columbus Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 3 | 6009905.4204 | 2119408.7236 | 37.8000507639755 | -122.40984355245001 | (37.8000507639755, -122.40984355245) | |||
7140 | 7140 | 8579 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2200 Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6 | 6000836.5941 | 2113437.661 | 37.7831433729932 | -122.440796526182 | (37.7831433729932, -122.440796526182) | |||
7149 | 7149 | 23486 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6005800.3407 | 2119014.80575 | 37.7987382537111 | -122.424020688524 | (37.7987382537111, -122.424020688524) | |||
7162 | 7162 | 23924 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1700X Webster St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 12x1 | 6003487.1069 | 2114786.6255 | 37.7869978805436 | -122.43172317383998 | (37.7869978805436, -122.43172317384) | |||
7214 | 7214 | 14423 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 90X Masonic Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 12 | 5998895.4066 | 2113040.8614 | 37.7819431221776 | -122.44748365121 | (37.7819431221776, -122.44748365121) | |||
7230 | 7230 | 8401 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Geary Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6003886.7265 | 2113933.9476 | 37.7846792853457 | -122.43027972368401 | (37.7846792853457, -122.430279723684) | |||
7236 | 7236 | 8621 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600 Geary Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5999320.4644 | 2113213.4566 | 37.782441305247104 | -122.446025570431 | (37.7824413052471, -122.446025570431) | |||
7257 | 7257 | 8535 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2100 Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6 | 6001300.5704 | 2113502.1304 | 37.7833468021346 | -122.439195981768 | (37.7833468021346, -122.439195981768) | |||
7259 | 7259 | 23270 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 843X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 3X3 | 6006591.05831 | 2113351.86982 | 37.783233848997 | -122.42088227939101 | (37.783233848997, -122.420882279391) | |||
7299 | 7299 | 23726 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X Webster St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 6 | 6003954.9966 | 2111561.7912 | 37.778169801288904 | -122.42987426911101 | (37.7781698012889, -122.429874269111) | |||
7311 | 7311 | 23920 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1700X Webster St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 12x12 | 6003521.972999999 | 2114612.7568 | 37.786522457310205 | -122.43159012740699 | (37.7865224573102, -122.431590127407) | |||
7325 | 7325 | 23732 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 800X Webster St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 6003928.5263 | 2111708.2372 | 37.7785704067109 | -122.429976288631 | (37.7785704067109, -122.429976288631) | |||
7376 | 7376 | 8465 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 1900 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 8 | 6002373.3675 | 2113709.4137 | 37.783976936809104 | -122.435499366282 | (37.7839769368091, -122.435499366282) | |||
7386 | 7386 | 23826 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1200X Webster St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003751.8286 | 2113008.0312 | 37.78212930904171 | -122.43068032991002 | (37.7821293090417, -122.43068032991) | |||
7438 | 7438 | 23859 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1400X Webster St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 3X3 | 6003649.3852 | 2113669.4444 | 37.783939579713504 | -122.431081960003 | (37.7839395797135, -122.431081960003) | |||
7490 | 7490 | 23861 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400X Webster St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 3X3 | 6003632.8842 | 2113765.0125 | 37.784201050677794 | -122.43114587096201 | (37.7842010506778, -122.431145870962) | |||
7547 | 7547 | 8637 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2600 Geary Blvd | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 5999081.877 | 2113180.2912 | 37.7823366145664 | -122.44684858803001 | (37.7823366145664, -122.44684858803) | |||
7550 | 7550 | 8618 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2600 Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 5999321.4797 | 2113227.3319 | 37.7824794612004 | -122.44602305626199 | (37.7824794612004, -122.446023056262) | |||
7577 | 7577 | 4636 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 500X Columbus Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 45 | 3 | 6009974.2224 | 2119345.7236 | 37.7998816370329 | -122.409601021151 | (37.7998816370329, -122.409601021151) | |||
7591 | 7591 | 14429 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X Masonic Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 3X3 | 5998837.1981 | 2113128.5127 | 37.7821804632664 | -122.44769133675501 | (37.7821804632664, -122.447691336755) | |||
7603 | 7603 | 23579 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 3100X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 42 | 3x3 | 6005511.92719 | 2121098.1181099997 | 37.804442208310206 | -122.425167011149 | (37.8044422083102, -122.425167011149) | |||
7642 | 7642 | 23788 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100X Webster St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003799.2688 | 2112646.3852 | 37.7811390068769 | -122.43049039607 | (37.7811390068769, -122.43049039607) | |||
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) | |||
7700 | 7700 | 8586 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 6 | 6000400.7068 | 2113377.2527 | 37.782952673809795 | -122.442300177437 | (37.7829526738098, -122.442300177437) | |||
7761 | 7761 | 23444 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2100X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 9 | 6005977.75981 | 2117720.35574 | 37.795194036322705 | -122.423314692816 | (37.7951940363227, -122.423314692816) | |||
7773 | 7773 | 8602 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 6 | 6000066.0077 | 2113328.1816 | 37.7827988555755 | -122.44345456827601 | (37.7827988555755, -122.443454568276) | |||
7781 | 7781 | 16359 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1306x Montgomery St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6011459.70542 | 2119848.6083 | 37.8013455628052 | -122.404496083149 | (37.8013455628052, -122.404496083149) | |||
7796 | 7796 | 16361 | DPW Maintained 3 | Cercis occidentalis :: Western Redbud 246 | 1306X Montgomery St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6011454.0998 | 2119899.17668 | 37.8014840979794 | -122.404519042839 | (37.8014840979794, -122.404519042839) |
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");