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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
5480 | 5480 | 87732 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3200X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005468.85489 | 2121438.02655 | 37.8053730758726 | -122.425340270033 | (37.8053730758726, -122.425340270033) | ||
5494 | 5494 | 87738 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3200X Van Ness Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005444.64461 | 2121623.98788 | 37.8058823097966 | -122.425437295217 | (37.8058823097966, -122.425437295217) | ||
5524 | 5524 | 4635 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 500X Columbus Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/05/1990 12:00:00 AM | 35 | 3 | 6010009.8735 | 2119314.4873 | 37.7997978674726 | -122.409475448708 | (37.7997978674726, -122.409475448708) | ||
5618 | 5618 | 87403 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1300 Webster St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 10 | 3x3 | 6003687.1999 | 2113392.3659 | 37.7831809343135 | -122.430931353807 | (37.7831809343135, -122.430931353807) | ||
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) | |||
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 | ||||||||
5646 | 5646 | 4679 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 700X Columbus Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/19/2006 12:00:00 AM | 6 | 3x3 | 6009212.7257 | 2120043.2180000003 | 37.801754083871295 | -122.412285420728 | (37.8017540838713, -122.412285420728) | ||
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 | ||||||||
5715 | 5715 | 23219 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 602X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/09/2005 12:00:00 AM | 6 | 3X3 | 6006682.87351 | 2112699.3573 | 37.7814473835175 | -122.420518302185 | (37.7814473835175, -122.420518302185) | ||
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) | |||
5747 | 5747 | 23218 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 602X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/09/2005 12:00:00 AM | 6 | 3X3 | 6006687.798690001 | 2112675.92876 | 37.781383332005795 | -122.420499599884 | (37.7813833320058, -122.420499599884) | ||
5785 | 5785 | 25798 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012871.9305 | 2119823.23547 | 37.801354716114 | -122.39960734420201 | (37.801354716114, -122.399607344202) | ||
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) | |||
5830 | 5830 | 4674 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 700X Columbus Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/05/1991 12:00:00 AM | 15 | 3x4 | 6009400.8826 | 2119872.8379 | 37.8012968187356 | -122.411622263241 | (37.8012968187356, -122.411622263241) | ||
5837 | 5837 | 8395 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1500 Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/09/1994 12:00:00 AM | 6 | 8 | 6004192.8617 | 2113973.9777 | 37.7848065332396 | -122.429223453232 | (37.7848065332396, -122.429223453232) | ||
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) | |||
5927 | 5927 | 25672 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 450X The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 36 | 15 | 6014076.201780001 | 2118013.23421 | 37.796451936061295 | -122.39531313361799 | (37.7964519360613, -122.395313133618) | ||
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) | |||
6093 | 6093 | 26031 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 450X The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 36 | 10 | 6014122.12078 | 2117941.0950599997 | 37.7962564126589 | -122.39514918719999 | (37.7962564126589, -122.3951491872) | ||
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) | |||
6383 | 6383 | 4717 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000X Columbus Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/19/2006 12:00:00 AM | 6 | 3 | 6008242.0329 | 2120925.0825 | 37.804120945419 | -122.415706953629 | (37.804120945419, -122.415706953629) | ||
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) | |||
6398 | 6398 | 23727 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 800X Webster St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 6 | 6003949.8401 | 2111575.542 | 37.7782072655707 | -122.429893088415 | (37.7782072655707, -122.429893088415) | ||
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) | |||
6504 | 6504 | 87726 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2238X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/25/2008 12:00:00 AM | 3 | 3x3 | 6005930.7522 | 2118113.00552 | 37.796269500484 | -122.42350527534599 | (37.796269500484, -122.423505275346) | ||
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) | ||||
6589 | 6589 | 4667 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 600X Columbus Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/03/2012 12:00:00 AM | 12 | 3 | Permit Number 769286 | 6009690.8519 | 2119608.7257 | 37.80058789320879 | -122.410600176031 | (37.8005878932088, -122.410600176031) | |
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) | |||
6688 | 6688 | 87724 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2238X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/18/2008 12:00:00 AM | 3 | 3x3 | 6005939.31579 | 2118054.71962 | 37.796109945467 | -122.423471497734 | (37.796109945467, -122.423471497734) | ||
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) | |||
6748 | 6748 | 26030 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 450X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 36 | 10 | 6014150.34723 | 2117905.1373099997 | 37.796159250800294 | -122.395048997307 | (37.7961592508003, -122.395048997307) | ||
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) | |||
6794 | 6794 | 8396 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Geary Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/09/1994 12:00:00 AM | 6 | 8 | 6004125.3824 | 2113965.9717 | 37.7847807304874 | -122.429456338379 | (37.7847807304874, -122.429456338379) | ||
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) | |||
6941 | 6941 | 87735 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3200X Van Ness Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005457.063999999 | 2121526.81323 | 37.8056161950061 | -122.42538739630501 | (37.8056161950061, -122.425387396305) | ||
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) | |||
6954 | 6954 | 8532 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2100 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/10/1994 12:00:00 AM | 6 | 6 | 6001535.4351 | 2113580.6442 | 37.783575742772705 | -122.438389071264 | (37.7835757427727, -122.438389071264) | ||
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) | |||
7108 | 7108 | 25783 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 08/30/1996 12:00:00 AM | 36 | 10 | 6013938.98446 | 2118296.9177 | 37.7972232315271 | -122.39580782638599 | (37.7972232315271, -122.395807826386) | ||
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) | |||
7152 | 7152 | 29781 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2000X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2006 12:00:00 AM | 3 | 6006021.95745 | 2117391.75426 | 37.7942942736085 | -122.42313839334601 | (37.7942942736085, -122.423138393346) | |||
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) | |||
7244 | 7244 | 8475 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1900 Geary Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/03/1994 12:00:00 AM | 6 | 8 | 6001831.8926 | 2113645.1136 | 37.7837696172579 | -122.43736806210899 | (37.7837696172579, -122.437368062109) | ||
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) | |||
7340 | 7340 | 25782 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 08/15/1996 12:00:00 AM | 36 | 10 | 6013997.3565 | 2118221.08563 | 37.7970182616509 | -122.395600527244 | (37.7970182616509, -122.395600527244) | ||
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) |
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");