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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29901 | 29901 | 191709 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 3535 Jennings St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6013020.366769999 | 2089365.2626599998 | 37.717732082047895 | -122.39695697201 | (37.7177320820479, -122.39695697201) | ||||
29993 | 29993 | 200316 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 300 Spear St | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6015592.61729 | 2115325.41388 | 37.789156021370204 | -122.38987812219601 | (37.7891560213702, -122.389878122196) | ||||
30245 | 30245 | 200301 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 300 Spear St | 17 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015414.78725 | 2115487.52698 | 37.7895912833718 | -122.39050472932101 | (37.7895912833718, -122.390504729321) | ||||
30342 | 30342 | 199587 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 875 Vermont St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6011307.0012300005 | 2104284.0502 | 37.7586003785102 | -122.40392860014099 | (37.7586003785102, -122.403928600141) | ||||
30356 | 30356 | 131206 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 12 Greenwich St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6012268.92363 | 2120560.78169 | 37.8033462081302 | -122.401745899659 | (37.8033462081302, -122.401745899659) | ||||
30369 | 30369 | 209572 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 100 Malta Dr | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 5999439.81114 | 2096263.84796 | 37.7359086891413 | -122.444394200825 | (37.7359086891413, -122.444394200825) | ||||
30654 | 30654 | 237210 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 483 Valley St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6002788.0313800005 | 2099167.4963 | 37.744071904607395 | -122.43302547424 | (37.7440719046074, -122.43302547424) | ||||
30838 | 30838 | 187949 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 302 Main St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6015269.3196 | 2115112.5908 | 37.7885537238177 | -122.390981820563 | (37.7885537238177, -122.390981820563) | ||||
31084 | 31084 | 134794 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1040 Lombard St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 6007385.13093 | 2120235.26271 | 37.8021786677605 | -122.418623384776 | (37.8021786677605, -122.418623384776) | ||||
31261 | 31261 | 215028 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 100 Terrace Dr | 23 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5993755.12546 | 2096561.9752 | 37.7364012864951 | -122.464069896803 | (37.7364012864951, -122.464069896803) | ||||
31497 | 31497 | 178323 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | 5990245.32384 | 2089538.4798299999 | 37.7169136270349 | -122.475691910275 | (37.7169136270349, -122.475691910275) | ||||
31605 | 31605 | 250344 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 101 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 5987477.27987 | 2115739.4405400003 | 37.788693527018104 | -122.487182863703 | (37.7886935270181, -122.487182863703) | ||||
31630 | 31630 | 199351 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 875 Vermont St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | 6011310.4458099995 | 2104289.7069599996 | 37.7586161031593 | -122.403917085224 | (37.7586161031593, -122.403917085224) | ||||
31755 | 31755 | 177719 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 0 Higuera Ave | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 5987711.1405 | 2090208.21579 | 37.7186053084801 | -122.484500336223 | (37.7186053084801, -122.484500336223) | ||||
31783 | 31783 | 245510 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 483 Valley St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6002844.07949 | 2099175.98984 | 37.744098404927 | -122.43283227920901 | (37.744098404927, -122.432832279209) | ||||
31795 | 31795 | 202089 | Undocumented 2 | Prunus armeniaca :: Apricot 259 | 1 Gould St | 17 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6012847.10312 | 2091145.2908299998 | 37.722610035407904 | -122.39768065196199 | (37.7226100354079, -122.397680651962) | ||||
31850 | 31850 | 213746 | Undocumented 2 | Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 362 | 1500 15th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 5991556.54065 | 2105092.12844 | 37.759695922737706 | -122.47229288660601 | (37.7596959227377, -122.472292886606) | ||||
31917 | 31917 | 194488 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1401 Rhode Island St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | 6012030.157269999 | 2101805.35505 | 37.751834800344 | -122.40125340303601 | (37.751834800344, -122.401253403036) | ||||
31982 | 31982 | 175855 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 667 London St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6001081.321380001 | 2089927.90496 | 37.718605160981795 | -122.438265098081 | (37.7186051609818, -122.438265098081) | ||||
31987 | 31987 | 250506 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 55 27th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 5987256.92022 | 2115565.6906 | 37.7882036078544 | -122.48793249451 | (37.7882036078544, -122.48793249451) | ||||
32037 | 32037 | 187942 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 300 Main St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6015080.74918 | 2115307.92538 | 37.789079602378294 | -122.391647913344 | (37.7890796023783, -122.391647913344) | ||||
32094 | 32094 | 177949 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Fuente Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 5989559.04866 | 2090448.7873900002 | 37.7193732944219 | -122.47813052091101 | (37.7193732944219, -122.478130520911) | ||||
32132 | 32132 | 199530 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1091 19th St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 6014489.75504 | 2105264.07428 | 37.7614686151109 | -122.39298967844499 | (37.7614686151109, -122.392989678445) | ||||
32246 | 32246 | 187491 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 750 Velasco Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6006526.88476 | 2086669.8859599999 | 37.7099675513223 | -122.419210983794 | (37.7099675513223, -122.419210983794) | ||||
32368 | 32368 | 190972 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | 6011274.67248 | 2104298.88872 | 37.758639315564 | -122.404041452454 | (37.758639315564, -122.404041452454) | ||||
32935 | 32935 | 196267 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1121 Jamestown Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6013259.78096 | 2090144.7382099999 | 37.719885690359604 | -122.396184017281 | (37.7198856903596, -122.396184017281) | ||||
32991 | 32991 | 237208 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 483 Valley St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6002753.541619999 | 2099167.64088 | 37.74407034517979 | -122.433144742342 | (37.7440703451798, -122.433144742342) | ||||
33239 | 33239 | 250504 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 35 27th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 5987226.17362 | 2115615.6145599997 | 37.7883388910724 | -122.488042540952 | (37.7883388910724, -122.488042540952) | ||||
33343 | 33343 | 227094 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Alemany Blvd | 35 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6009153.630890001 | 2095762.56962 | 37.7350817355269 | -122.410774146024 | (37.7350817355269, -122.410774146024) | ||||
33535 | 33535 | 226834 | Undocumented 2 | Juglans regia :: Walnut: English 348 | 246 Bemis St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6003051.73266 | 2096339.9722099998 | 37.7363231300074 | -122.431911797003 | (37.7363231300074, -122.431911797003) | ||||
33675 | 33675 | 134800 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1070 Lombard St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6007227.6114300005 | 2120220.91562 | 37.802130404749896 | -122.419167461114 | (37.8021304047499, -122.419167461114) | ||||
33763 | 33763 | 194216 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1121 Jamestown Ave | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6013384.67345 | 2090050.6938099999 | 37.719634411689206 | -122.39574571828399 | (37.7196344116892, -122.395745718284) | ||||
34120 | 34120 | 194400 | Undocumented 2 | Phoenix dactylifera :: Date Palm 65 | 1121 Jamestown Ave | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6013373.9192 | 2090059.88362 | 37.7196590468175 | -122.395783535707 | (37.7196590468175, -122.395783535707) | ||||
34154 | 34154 | 250700 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 80 McLaren Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 5986776.39864 | 2114896.79403 | 37.786338968822704 | -122.489545789219 | (37.7863389688227, -122.489545789219) | ||||
34192 | 34192 | 177311 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 631 London St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 6001193.123869999 | 2090116.89755 | 37.7191304504876 | -122.43789217260401 | (37.7191304504876, -122.437892172604) | ||||
34202 | 34202 | 246791 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 175 Brewster St | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6010143.06435 | 2098755.47908 | 37.743355047810205 | -122.40756425069901 | (37.7433550478102, -122.407564250699) | ||||
34280 | 34280 | 188251 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1039 Jamestown Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 6013763.34518 | 2089782.1261 | 37.718918036018295 | -122.394417981716 | (37.7189180360183, -122.394417981716) | ||||
34346 | 34346 | 202086 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1 Gould St | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6012832.48602 | 2091118.85258 | 37.722536627341796 | -122.39772932687299 | (37.7225366273418, -122.397729326873) | ||||
34442 | 34442 | 250358 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 33 Scenic Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 5987605.71758 | 2115644.4352599997 | 37.788440158338396 | -122.48673151464199 | (37.7884401583384, -122.486731514642) | ||||
34477 | 34477 | 200323 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 300 Spear St | 21 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015655.422040001 | 2115235.75043 | 37.7889133087555 | -122.389654558808 | (37.7889133087555, -122.389654558808) | ||||
34497 | 34497 | 191363 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 955 Key Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6013550.52728 | 2089583.75311 | 37.7183615103672 | -122.395139727222 | (37.7183615103672, -122.395139727222) | ||||
34559 | 34559 | 175753 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 755 London St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6000826.82092 | 2089512.30625 | 37.7174495420436 | -122.439115030257 | (37.7174495420436, -122.439115030257) | ||||
34747 | 34747 | 123483 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 600 Arguello Blvd | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 34 | 5995662.44998 | 2111958.25695 | 37.7787852957742 | -122.458589724568 | (37.7787852957742, -122.458589724568) | ||||
34784 | 34784 | 207435 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1550 15th Ave | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 5991562.287830001 | 2104945.46167 | 37.759293547166 | -122.472262318665 | (37.759293547166, -122.472262318665) | ||||
34855 | 34855 | 134971 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2100 The Embarcadero | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6009844.1621199995 | 2122376.03453 | 37.8081948291999 | -122.41026515223 | (37.8081948291999, -122.41026515223) | ||||
34928 | 34928 | 178912 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5993780.74611 | 2086770.03775 | 37.709516474781104 | -122.463270994886 | (37.7095164747811, -122.463270994886) | ||||
35071 | 35071 | 176378 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 0 Crespi Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | 5989827.05129 | 2090325.18948 | 37.7190494782331 | -122.477195118066 | (37.7190494782331, -122.477195118066) | ||||
35184 | 35184 | 190969 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 6011271.58164 | 2104330.23228 | 37.758725205314704 | -122.404054347838 | (37.7587252053147, -122.404054347838) | ||||
35307 | 35307 | 135015 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1077 Front St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 6012578.55568 | 2120142.36821 | 37.802214619965206 | -122.40064498919399 | (37.8022146199652, -122.400644989194) | ||||
35367 | 35367 | 197333 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1501 25th St | 22 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6014202.148440001 | 2101967.42619 | 37.7524007500093 | -122.39375364352301 | (37.7524007500093, -122.393753643523) | ||||
35526 | 35526 | 131605 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 982 Green St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6008358.64628 | 2118966.19584 | 37.7987488873077 | -122.41516465784599 | (37.7987488873077, -122.415164657846) | ||||
35638 | 35638 | 223005 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 246 Bemis St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 6003031.63093 | 2096309.9705299998 | 37.7362396126721 | -122.431979155322 | (37.7362396126721, -122.431979155322) | ||||
35697 | 35697 | 179258 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 0 Juan Bautista Cir | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5989486.24295 | 2090206.2141599997 | 37.7187030225094 | -122.478364452564 | (37.7187030225094, -122.478364452564) | ||||
35895 | 35895 | 188437 | Undocumented 2 | Ceiba speciosa :: Silk floss 335 | 1465 Rhode Island St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6012048.22997 | 2101554.20026 | 37.7511461921502 | -122.40117325816001 | (37.7511461921502, -122.40117325816) | ||||
36099 | 36099 | 188431 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 889 Vermont St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6011294.06359 | 2104194.03596 | 37.7583524966 | -122.403967010163 | (37.7583524966, -122.403967010163) | ||||
36339 | 36339 | 194446 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1501 25th St | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 6014162.91853 | 2101954.38506 | 37.7523627617528 | -122.393888395238 | (37.7523627617528, -122.393888395238) | ||||
36362 | 36362 | 209568 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 100 Malta Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 5999462.29955 | 2096158.98515 | 37.735622043705 | -122.444308916343 | (37.735622043705, -122.444308916343) | ||||
36409 | 36409 | 198632 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 419 Mission Bay Blvd North | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015782.37645 | 2108741.7224 | 37.77108919993629 | -122.38876177932501 | (37.7710891999363, -122.388761779325) | ||||
36414 | 36414 | 136262 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 11 Filbert St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6012539.8548099995 | 2120210.2855 | 37.8023989459081 | -122.400783688018 | (37.8023989459081, -122.400783688018) | ||||
36420 | 36420 | 250353 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 90 Scenic Way | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 5987585.69001 | 2115723.97833 | 37.7886573931578 | -122.486806649401 | (37.7886573931578, -122.486806649401) | ||||
36449 | 36449 | 176377 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 0 Crespi Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 5989839.20092 | 2090334.4554299999 | 37.7190756251255 | -122.47715379871201 | (37.7190756251255, -122.477153798712) | ||||
36572 | 36572 | 125283 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1022 Vallejo St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | 6008553.3357 | 2118652.52979 | 37.797898577410706 | -122.414468760628 | (37.7978985774107, -122.414468760628) | ||||
36632 | 36632 | 188878 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 800 Vermont St | 17 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6011299.1950199995 | 2104323.40019 | 37.7587079887048 | -122.403958366804 | (37.7587079887048, -122.403958366804) | ||||
36738 | 36738 | 181277 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 0 Gonzalez Dr | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 5988402.74919 | 2089827.8491900002 | 37.7176011677477 | -122.482081905481 | (37.7176011677477, -122.482081905481) | ||||
36842 | 36842 | 205287 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Terrace Dr | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | 5993689.14699 | 2096660.1046799999 | 37.736666922846105 | -122.46430513247499 | (37.7366669228461, -122.464305132475) | ||||
36921 | 36921 | 175655 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 5989994.06268 | 2089291.6225400001 | 37.7162212479866 | -122.476542364932 | (37.7162212479866, -122.476542364932) | ||||
37153 | 37153 | 250359 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 33 Scenic Way | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 5987617.21703 | 2115632.85047 | 37.788409020220705 | -122.486690877876 | (37.7884090202207, -122.486690877876) | ||||
37172 | 37172 | 229433 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 78 Norwich St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6008994.16182 | 2099484.29017 | 37.7452918250714 | -122.41158835801399 | (37.7452918250714, -122.411588358014) | ||||
37330 | 37330 | 246723 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 51 Stoneman St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6007993.984209999 | 2099385.4725900004 | 37.7449643396286 | -122.415039822929 | (37.7449643396286, -122.415039822929) | ||||
37421 | 37421 | 220545 | Undocumented 2 | Aesculus californica :: California Buckeye 338 | 527 Powhattan Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6008718.64128 | 2098106.70395 | 37.7414938180831 | -122.41244370862199 | (37.7414938180831, -122.412443708622) | ||||
37501 | 37501 | 240270 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 527 Banks St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6008672.46387 | 2098105.62692 | 37.7414882692663 | -122.412603298703 | (37.7414882692663, -122.412603298703) | ||||
37671 | 37671 | 176274 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 775 London St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6000713.865119999 | 2089358.3764799999 | 37.7170204575094 | -122.439494437135 | (37.7170204575094, -122.439494437135) | ||||
37676 | 37676 | 217768 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 470 West Portal Ave | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | 5991501.61813 | 2096126.7253400001 | 37.7350760653014 | -122.47182943178301 | (37.7350760653014, -122.471829431783) | ||||
37712 | 37712 | 189773 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2150 26th St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 6012060.25758 | 2101403.52141 | 37.750733131726605 | -122.401121078568 | (37.7507331317266, -122.401121078568) | ||||
37763 | 37763 | 189762 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2200 26th St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | 6011977.64986 | 2101382.7583 | 37.7506715119927 | -122.401405285922 | (37.7506715119927, -122.401405285922) | ||||
37847 | 37847 | 187948 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 302 Main St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6015252.9594 | 2115128.97629 | 37.788597806797796 | -122.391039570534 | (37.7885978067978, -122.391039570534) | ||||
37917 | 37917 | 199398 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1027 Jamestown Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6013845.577380001 | 2089711.9694400001 | 37.718729970701396 | -122.394128826289 | (37.7187299707014, -122.394128826289) | ||||
37919 | 37919 | 133114 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1201 Greenwich St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6007094.56661 | 2119804.0690599997 | 37.8009783561189 | -122.41959826875099 | (37.8009783561189, -122.419598268751) | ||||
38055 | 38055 | 134980 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2350 Stockton St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6009736.585940001 | 2122356.6353700003 | 37.8081355332869 | -122.410636078516 | (37.8081355332869, -122.410636078516) | ||||
38129 | 38129 | 191390 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 845 Vermont St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | 6011298.55233 | 2104376.91383 | 37.7588548893488 | -122.403964355369 | (37.7588548893488, -122.403964355369) | ||||
38217 | 38217 | 176045 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Font Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 5990157.58815 | 2089581.85402 | 37.7170276349961 | -122.475998332672 | (37.7170276349961, -122.475998332672) | ||||
38367 | 38367 | 133141 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 407 Vallejo St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | 6011477.96138 | 2119029.17792 | 37.7990966263734 | -122.40437519896099 | (37.7990966263734, -122.404375198961) | ||||
38586 | 38586 | 246713 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1 Bonview St | 19 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 6007763.89494 | 2099225.75212 | 37.7445128502976 | -122.415824124379 | (37.7445128502976, -122.415824124379) | ||||
38799 | 38799 | 133113 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1201 Greenwich St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6007028.127 | 2119798.62305 | 37.800959660109 | -122.41982779193701 | (37.800959660109, -122.419827791937) | ||||
39130 | 39130 | 134791 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 Lombard St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6007500.8396 | 2120253.7585299998 | 37.802235966276 | -122.418224288116 | (37.802235966276, -122.418224288116) | ||||
39449 | 39449 | 194139 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 770 Illinois St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 6015990.605380001 | 2105494.8516 | 37.7621855348578 | -122.387814914632 | (37.7621855348578, -122.387814914632) | ||||
39528 | 39528 | 194389 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1031 Key Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 36 | 6013123.75243 | 2089902.89375 | 37.7192140640518 | -122.396637279208 | (37.7192140640518, -122.396637279208) | ||||
39540 | 39540 | 131592 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 999 Green St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 6008355.8018 | 2118946.79635 | 37.7986954612792 | -122.41517312674601 | (37.7986954612792, -122.415173126746) | ||||
39557 | 39557 | 189319 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1121 Jamestown Ave | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6013379.939590001 | 2090055.2755099998 | 37.71964672878121 | -122.39576240251499 | (37.7196467287812, -122.395762402515) | ||||
39647 | 39647 | 190975 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 23 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | 6011275.59974 | 2104245.89235 | 37.758493851126296 | -122.40403451598 | (37.7584938511263, -122.40403451598) | ||||
39657 | 39657 | 187951 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 302 Main St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6015307.966030001 | 2115072.7119299998 | 37.7884463699393 | -122.390845320574 | (37.7884463699393, -122.390845320574) | ||||
39739 | 39739 | 129479 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 12 Filbert St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6012506.1322099995 | 2120230.97584 | 37.8024538756 | -122.400901840066 | (37.8024538756, -122.400901840066) | ||||
39748 | 39748 | 240597 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 523 Powhattan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 29 | 6008567.55649 | 2098119.2319799997 | 37.741519737445294 | -122.412966995358 | (37.7415197374453, -122.412966995358) | ||||
39767 | 39767 | 137066 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 12 Filbert St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6012425.54206 | 2120223.78485 | 37.8024296352708 | -122.401180217987 | (37.8024296352708, -122.401180217987) | ||||
39776 | 39776 | 200298 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 300 Spear St | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6015397.853619999 | 2115526.63522 | 37.7896977262219 | -122.390566052287 | (37.7896977262219, -122.390566052287) | ||||
39889 | 39889 | 175866 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 771 London St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6000758.69857 | 2089409.69112 | 37.7171639074676 | -122.439343145965 | (37.7171639074676, -122.439343145965) | ||||
40050 | 40050 | 176160 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5990378.89561 | 2089837.21304 | 37.7177416175535 | -122.47525201947701 | (37.7177416175535, -122.475252019477) | ||||
40111 | 40111 | 178175 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 5989026.35056 | 2089515.5020599999 | 37.7167797908382 | -122.47990357931002 | (37.7167797908382, -122.47990357931) | ||||
40186 | 40186 | 218289 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1 Woodacre Dr | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | 5991265.0261699995 | 2095485.2551900002 | 37.7333010580894 | -122.472600653515 | (37.7333010580894, -122.472600653515) | ||||
40401 | 40401 | 246785 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 175 Brewster St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6010076.64553 | 2098710.46758 | 37.7432277379635 | -122.40779073774999 | (37.7432277379635, -122.40779073775) |
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");