Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, qCareAssistant, PermitNotes
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189094 | 189094 | 221424 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 900x Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005689.534530001 | 2103630.03961 | 37.7564891759384 | -122.423309876046 | (37.7564891759384, -122.423309876046) | |||
| 188905 | 188905 | 200550 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6016212.9331 | 2095623.1152 | 37.7350921083386 | -122.386357662249 | (37.7350921083386, -122.386357662249) | |||
| 188835 | 188835 | 200601 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1300x Newcomb Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6016439.2859 | 2094833.5580000002 | 37.7329366690371 | -122.385520065311 | (37.7329366690371, -122.385520065311) | |||
| 188789 | 188789 | 1301 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 4000X Alemany Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 32 | 10 | 5991772.09471 | 2087046.42932 | 37.7101594558675 | -122.470233284447 | (37.7101594558675, -122.470233284447) | |||
| 188631 | 188631 | 204531 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 400x Marietta Dr | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 3ft | 5999192.435380001 | 2097025.16393 | 37.7379849647319 | -122.44530419514999 | (37.7379849647319, -122.44530419515) | |||
| 188554 | 188554 | 221300 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 2800x Cesar Chavez St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 6ft | 6010513.720919999 | 2100755.88609 | 37.748868470213104 | -122.406423533516 | (37.7488684702131, -122.406423533516) | |||
| 188458 | 188458 | 188191 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 860x Jamestown Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014720.49682 | 2089157.49571 | 37.7172560852665 | -122.39106582262501 | (37.7172560852665, -122.391065822625) | |||
| 188264 | 188264 | 206032 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 601x Monterey Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 4ft | 5997524.38886 | 2094711.3028099998 | 37.7315362986421 | -122.450904629644 | (37.7315362986421, -122.450904629644) | |||
| 188243 | 188243 | 180043 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000932.74205 | 2090913.3851700001 | 37.721302615409705 | -122.438849257207 | (37.7213026154097, -122.438849257207) | |||
| 188083 | 188083 | 221533 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1100x Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 3ft | 6005767.42939 | 2102227.70946 | 37.75264309841 | -122.422940823082 | (37.75264309841, -122.422940823082) | |||
| 188070 | 188070 | 184620 | DPW Maintained 3 | :: 54 | 3000x Noriega St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 0ft | 5984460.1938 | 2102931.6946 | 37.753350719104795 | -122.496675818993 | (37.7533507191048, -122.496675818993) | |||
| 187999 | 187999 | 140339 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1300x WEBSTER ST | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6003689.95 | 2113371.7397 | 37.7831244557567 | -122.430920367043 | (37.7831244557567, -122.430920367043) | |||
| 187959 | 187959 | 88452 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3200X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/07/2008 12:00:00 AM | 4 | 5x12 | 6005470.42698 | 2121378.16696 | 37.8052088057127 | -122.425330567252 | (37.8052088057127, -122.425330567252) | ||
| 187731 | 187731 | 231187 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2850x Bryant St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 5ft | 6009843.90305 | 2100697.4884 | 37.748670629262904 | -122.408735654529 | (37.7486706292629, -122.408735654529) | |||
| 187646 | 187646 | 200535 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 6016168.4829 | 2095664.0064 | 37.735201926775396 | -122.386514194261 | (37.7352019267754, -122.386514194261) | |||
| 187581 | 187581 | 180063 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 31 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000614.24594 | 2090358.9478799999 | 37.7197621306905 | -122.439910472497 | (37.7197621306905, -122.439910472497) | |||
| 187415 | 187415 | 244374 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005614.0781 | 2109847.0914 | 37.7735554657504 | -122.42401292788901 | (37.7735554657504, -122.424012927889) | |||
| 187201 | 187201 | 112596 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1200x Divisadero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3x3 | 6001324.7675 | 2112728.8365 | 37.7812249111251 | -122.439056830439 | (37.7812249111251, -122.439056830439) | |||
| 187159 | 187159 | 208135 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 15x San Marcos Ave | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 5ft | 5993326.71612 | 2100337.0457 | 37.7467419791719 | -122.465825280839 | (37.7467419791719, -122.465825280839) | |||
| 187000 | 187000 | 211365 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 1x Minerva St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 5996056.33729 | 2089003.23942 | 37.715779161955396 | -122.45556751823601 | (37.7157791619554, -122.455567518236) | |||
| 186972 | 186972 | 244255 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 200x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005643.2766 | 2110040.2561 | 37.7740874977816 | -122.423925664351 | (37.7740874977816, -122.423925664351) | |||
| 186887 | 186887 | 141089 | DPW Maintained 3 | Tristania conferta :: 79 | 100x JORDAN AVE | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 5996248.2713 | 2112978.5918 | 37.7816205163369 | -122.456636959709 | (37.7816205163369, -122.456636959709) | |||
| 186690 | 186690 | 212295 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 5991170.53267 | 2089939.6813400001 | 37.7180688232854 | -122.472523177809 | (37.7180688232854, -122.472523177809) | |||
| 186679 | 186679 | 179670 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 300x Winding Way | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6001487.80324 | 2086473.7350700002 | 37.7091438874604 | -122.436612949055 | (37.7091438874604, -122.436612949055) | |||
| 186623 | 186623 | 175620 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 700x Mansell St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 6009477.4678 | 2090042.2500200002 | 37.719393098398704 | -122.40925098404499 | (37.7193930983987, -122.409250984045) | |||
| 186596 | 186596 | 2255 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X Brotherhood Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | 5990660.02895 | 2088282.4204099998 | 37.713488829713796 | -122.474166893001 | (37.7134888297138, -122.474166893001) | ||||
| 186484 | 186484 | 244409 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 202x Octavia St | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 0ft | 6005580.6462 | 2110260.99 | 37.7746900436181 | -122.424158015373 | (37.7746900436181, -122.424158015373) | |||
| 186381 | 186381 | 206462 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 100x Casitas Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 5995528.33875 | 2096982.8424099998 | 37.7376589218079 | -122.457969641597 | (37.7376589218079, -122.457969641597) | |||
| 186357 | 186357 | 211055 | DPW Maintained 3 | Pinus muricata :: Bishop Pine 302 | 300x Marietta Dr | 72 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 5999722.47175 | 2097250.7906299997 | 37.7386347240172 | -122.443487806529 | (37.7386347240172, -122.443487806529) | |||
| 186302 | 186302 | 175614 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 100x Mansell St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 6011421.832780001 | 2090628.0448200002 | 37.7211103133815 | -122.402571168832 | (37.7211103133815, -122.402571168832) | |||
| 186128 | 186128 | 204546 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 69 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 5ft | 5999726.305480001 | 2097318.0909700003 | 37.738819733438504 | -122.443479384359 | (37.7388197334385, -122.443479384359) | |||
| 186073 | 186073 | 233637 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 758x San Jose Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 6005642.24056 | 2098618.09907 | 37.74272486946911 | -122.423117200821 | (37.7427248694691, -122.423117200821) | |||
| 185855 | 185855 | 180082 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2100x Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000152.851 | 2089912.6147900003 | 37.7185103256827 | -122.441473335931 | (37.7185103256827, -122.441473335931) | |||
| 185759 | 185759 | 211336 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 501x Ortega St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 5992533.484209999 | 2103100.12483 | 37.7542828925471 | -122.46876920076201 | (37.7542828925471, -122.468769200762) | |||
| 185709 | 185709 | 222799 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 2800x Cesar Chavez St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 6ft | 6010384.90884 | 2100709.18955 | 37.7487330449049 | -122.40686567713499 | (37.7487330449049, -122.406865677135) | |||
| 185585 | 185585 | 180028 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6001180.14199 | 2091386.50132 | 37.7226157577852 | -122.438027939654 | (37.7226157577852, -122.438027939654) | |||
| 185520 | 185520 | 206438 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 300x Marietta Dr | 50 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 5ft | 5999556.5851300005 | 2097486.39574 | 37.73927217785771 | -122.44407828610001 | (37.7392721778577, -122.4440782861) | |||
| 185443 | 185443 | 142131 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2200x GEARY BLVD | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | Width 0ft | 6000333.6993 | 2113366.7616 | 37.7829200486713 | -122.442531241518 | (37.7829200486713, -122.442531241518) | |||
| 185409 | 185409 | 180035 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6001087.26718 | 2091207.92549 | 37.722120146807896 | -122.43833619936399 | (37.7221201468079, -122.438336199364) | |||
| 185396 | 185396 | 180066 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 36 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000525.601009999 | 2090267.6783099999 | 37.7195064786158 | -122.440210344258 | (37.7195064786158, -122.440210344258) | |||
| 185379 | 185379 | 113500 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 200x Mansell St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | 3x3 | 6011183.30408 | 2090581.60768 | 37.7209694867258 | -122.403392432416 | (37.7209694867258, -122.403392432416) | |||
| 185266 | 185266 | 213775 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 401x Monterey Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 4ft | 5999015.12983 | 2094689.3935 | 37.731561369058795 | -122.44574929389799 | (37.7315613690588, -122.445749293898) | |||
| 185218 | 185218 | 221536 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1100x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 3ft | 6005762.1987 | 2102333.32685 | 37.75293280420979 | -122.422966417762 | (37.7529328042098, -122.422966417762) | |||
| 185211 | 185211 | 244333 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 102x Octavia St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 6005640.1134 | 2109813.1769999997 | 37.773463814863 | -122.42392045570699 | (37.773463814863, -122.423920455707) | |||
| 185178 | 185178 | 221511 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1300x Guerrero St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005835.54562 | 2100976.57743 | 37.749211620932606 | -122.422616365666 | (37.7492116209326, -122.422616365666) | |||
| 185126 | 185126 | 97377 | DPW Maintained 3 | Acer saccharinum :: Silver Maple 273 | 1401X Broadway | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006713.66086 | 2118020.1658099997 | 37.7960587443728 | -122.420789650134 | (37.7960587443728, -122.420789650134) | ||||
| 185034 | 185034 | 176332 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 40 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 6009122.37089 | 2089940.9339 | 37.7190950046208 | -122.410471276831 | (37.7190950046208, -122.410471276831) | |||
| 184827 | 184827 | 176107 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700x Mansell St | 46 | Median : Cutout 11 | Tree 1 | DPW 2 | 61 | Width 0ft | 6008982.60232 | 2089910.3513099998 | 37.7190031946297 | -122.41095224595699 | (37.7190031946297, -122.410952245957) | |||
| 184665 | 184665 | 211252 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 99x San Marcos Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 28 | Width 5ft | 5993772.95985 | 2100263.65639 | 37.7465662021668 | -122.464276899165 | (37.7465662021668, -122.464276899165) | |||
| 184636 | 184636 | 199678 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1400x Underwood Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6015628.2568 | 2092949.4044 | 37.72771825330071 | -122.388192580507 | (37.7277182533007, -122.388192580507) | |||
| 184493 | 184493 | 176301 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 10x Mansell St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 22 | Width 0ft | 6011617.09806 | 2090687.60598 | 37.7212847557703 | -122.40190037442899 | (37.7212847557703, -122.401900374429) | |||
| 184447 | 184447 | 180037 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 29 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6001052.1769900005 | 2091141.7538400001 | 37.7219364584926 | -122.438452758712 | (37.7219364584926, -122.438452758712) | |||
| 184414 | 184414 | 221498 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005599.77613 | 2105242.7413 | 37.7609122108583 | -122.423734955914 | (37.7609122108583, -122.423734955914) | |||
| 184309 | 184309 | 244362 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005532.1079 | 2110378.8544 | 37.7750109299929 | -122.42433430414499 | (37.7750109299929, -122.424334304145) | |||
| 184198 | 184198 | 212301 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 5991188.84719 | 2090215.0879099998 | 37.7188260821255 | -122.47247994019199 | (37.7188260821255, -122.472479940192) | |||
| 184192 | 184192 | 180315 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1604x Alemany Blvd | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6001566.53867 | 2092362.21846 | 37.725316822989605 | -122.436762065623 | (37.7253168229896, -122.436762065623) | |||
| 184099 | 184099 | 200557 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1400x La Salle Ave | 33 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 0ft | 6016298.6383 | 2095516.7839 | 37.734804887646796 | -122.386053935891 | (37.7348048876468, -122.386053935891) | |||
| 184001 | 184001 | 187218 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2401 Sunset Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 27 | Width 0ft | 5984945.4705 | 2098810.8461 | 37.7420644138344 | -122.494693870399 | (37.7420644138344, -122.494693870399) | |||
| 183995 | 183995 | 194395 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 920x Jamestown Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | Width 5ft | 6014427.53162 | 2089348.9061599998 | 37.7177653992236 | -122.392091851971 | (37.7177653992236, -122.392091851971) | |||
| 183918 | 183918 | 180060 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000687.072369999 | 2090454.3849400003 | 37.7200283246365 | -122.439665576299 | (37.7200283246365, -122.439665576299) | |||
| 183605 | 183605 | 180302 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1604x Alemany Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6001751.00394 | 2092763.61834 | 37.726429457948896 | -122.436153099585 | (37.7264294579489, -122.436153099585) | |||
| 183567 | 183567 | 178253 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 200x Mansell St | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | Width 0ft | 6011075.03755 | 2090535.49996 | 37.7208368367282 | -122.403763436926 | (37.7208368367282, -122.403763436926) | |||
| 183541 | 183541 | 178448 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 300x Mansell St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 0ft | 6010856.8057 | 2090466.80243 | 37.720636013633204 | -122.404512968803 | (37.7206360136332, -122.404512968803) | |||
| 183528 | 183528 | 219372 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 400x Marietta Dr | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 3ft | 5999397.86314 | 2097051.08053 | 37.7380678498474 | -122.444595794674 | (37.7380678498474, -122.444595794674) | |||
| 183363 | 183363 | 175616 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 200x Mansell St | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6011130.05143 | 2090542.76805 | 37.72085986657329 | -122.40357378072201 | (37.7208598665733, -122.403573780722) | |||
| 183212 | 183212 | 181247 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 6ft | 6011190.75371 | 2087265.8089 | 37.7118653915605 | -122.40313356348899 | (37.7118653915605, -122.403133563489) | |||
| 183209 | 183209 | 176298 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 10x Mansell St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 23 | Width 0ft | 6011748.91192 | 2090731.5823400002 | 37.7214128614948 | -122.40144781756399 | (37.7214128614948, -122.401447817564) | |||
| 183186 | 183186 | 112594 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1200M Divisadero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3x3 | 6001343.2115 | 2112635.4321 | 37.7809694958311 | -122.438986327521 | (37.7809694958311, -122.438986327521) | |||
| 183163 | 183163 | 188197 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 920x Jamestown Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014447.456130001 | 2089337.65595 | 37.717735614585294 | -122.39202219499501 | (37.7177356145853, -122.392022194995) | |||
| 183152 | 183152 | 176558 | DPW Maintained 3 | Heteromeles arbutifolia :: Toyon 322 | 300x Mansell St | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 6010777.60358 | 2090452.8911 | 37.7205933893479 | -122.404785768266 | (37.7205933893479, -122.404785768266) | |||
| 183126 | 183126 | 117846 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 620x 39th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 55 | Width 6ft | 5983813.41321 | 2111492.12904 | 37.7768173268114 | -122.49954508796999 | (37.7768173268114, -122.49954508797) | |||
| 182952 | 182952 | 205103 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Junipero Serra Blvd | 37 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 5991326.973119999 | 2092437.01185 | 37.724934930379206 | -122.47216437168899 | (37.7249349303792, -122.472164371689) | |||
| 182927 | 182927 | 205086 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 39 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 5991226.90116 | 2090814.4677099998 | 37.7204740340313 | -122.472392075543 | (37.7204740340313, -122.472392075543) | |||
| 182909 | 182909 | 208283 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 5995702.361819999 | 2098208.0995400003 | 37.74103317363429 | -122.45745658465401 | (37.7410331736343, -122.457456584654) | |||
| 182868 | 182868 | 221512 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1300x Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005835.43443 | 2101000.02463 | 37.749275995297296 | -122.422618416129 | (37.7492759952973, -122.422618416129) | |||
| 182852 | 182852 | 208214 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1600x Portola Dr | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 3ft | 5992270.30355 | 2096715.89094 | 37.7367382129937 | -122.46921470239599 | (37.7367382129937, -122.469214702396) | |||
| 182798 | 182798 | 221555 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005738.9106 | 2102712.57542 | 37.753972818908 | -122.423073906548 | (37.753972818908, -122.423073906548) | |||
| 182784 | 182784 | 245673 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1594x Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005908.33244 | 2099840.7906299997 | 37.7460971157901 | -122.422283981647 | (37.7460971157901, -122.422283981647) | |||
| 182627 | 182627 | 200520 | DPW Maintained 3 | Tristania conferta :: 79 | 1400x La Salle Ave | 63 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6016476.5475 | 2095041.1188 | 37.7335086511389 | -122.38540570010599 | (37.7335086511389, -122.385405700106) | |||
| 182598 | 182598 | 211247 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 255x San Marcos Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 27 | Width 5ft | 5993181.00206 | 2100246.48569 | 37.7464849178553 | -122.46632256094 | (37.7464849178553, -122.46632256094) | |||
| 182459 | 182459 | 246404 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2000x Market St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 29 | Width 0ft | 6004606.9445 | 2108108.5245 | 37.7687248704296 | -122.427372879895 | (37.7687248704296, -122.427372879895) | |||
| 182417 | 182417 | 218726 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 600x Laguna Honda Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 3ft | 5995446.39334 | 2099958.3042 | 37.7458240951236 | -122.45846828420099 | (37.7458240951236, -122.458468284201) | |||
| 182395 | 182395 | 140747 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1300x DIVISADERO ST | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001275.0195 | 2113083.841 | 37.7821968322814 | -122.43925438646299 | (37.7821968322814, -122.439254386463) | |||
| 182389 | 182389 | 239871 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 322x Elsie St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6006320.05712 | 2096908.09305 | 37.7380678030916 | -122.420652136603 | (37.7380678030916, -122.420652136603) | |||
| 182320 | 182320 | 221521 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1200x Guerrero St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005805.669319999 | 2101529.55059 | 37.7507282726947 | -122.422758971142 | (37.7507282726947, -122.422758971142) | |||
| 182264 | 182264 | 233638 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 750x San Jose Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 3ft | 6005667.10941 | 2098695.24621 | 37.7429381014114 | -122.42303669349899 | (37.7429381014114, -122.423036693499) | |||
| 182189 | 182189 | 244315 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005508.5005 | 2110550.2437 | 37.7754801903482 | -122.42442816055599 | (37.7754801903482, -122.424428160556) | |||
| 181978 | 181978 | 246356 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2100x Market St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 32 | Width 0ft | 6003986.7122 | 2107511.3108 | 37.7670499684983 | -122.429475620431 | (37.7670499684983, -122.429475620431) | |||
| 181946 | 181946 | 221297 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 2800x Cesar Chavez St | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 6ft | 6010135.01415 | 2100610.8980799997 | 37.7484491721017 | -122.407722885716 | (37.7484491721017, -122.407722885716) | |||
| 181938 | 181938 | 205102 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Junipero Serra Blvd | 36 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 5991324.44766 | 2092411.88768 | 37.7248657994962 | -122.472171271311 | (37.7248657994962, -122.472171271311) | |||
| 181902 | 181902 | 190815 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 390x Hampshire St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 5ft | 6010042.68497 | 2106527.82648 | 37.7646905631515 | -122.408459468238 | (37.7646905631515, -122.408459468238) | |||
| 181858 | 181858 | 205972 | DPW Maintained 3 | Cedrus deodara :: Deodar Cedar 129 | 400x Marietta Dr | 49 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 5998976.04571 | 2096922.6715 | 37.7376911903888 | -122.446044988292 | (37.7376911903888, -122.446044988292) | |||
| 181793 | 181793 | 206291 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 500x Junipero Serra Blvd | 38 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 5991445.95006 | 2094262.4550299998 | 37.7299540269465 | -122.471886066612 | (37.7299540269465, -122.471886066612) | |||
| 181713 | 181713 | 200526 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1400x La Salle Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | Width 0ft | 6016126.5305 | 2095710.5736 | 37.735327468440204 | -122.386662486514 | (37.7353274684402, -122.386662486514) | |||
| 181682 | 181682 | 206977 | DPW Maintained 3 | Lagerstroemia indica :: Crape Myrtle 199 | 1x Minerva St | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 5996177.78414 | 2089001.8318599998 | 37.7157822655174 | -122.455147642762 | (37.7157822655174, -122.455147642762) | |||
| 181657 | 181657 | 211357 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 300x Marietta Dr | 42 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 5ft | 5999475.8897 | 2097510.5498900004 | 37.7393338956504 | -122.444359029265 | (37.7393338956504, -122.444359029265) | |||
| 181268 | 181268 | 180072 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 44 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000400.98899 | 2090150.2778599998 | 37.719177028168296 | -122.440632664989 | (37.7191770281683, -122.440632664989) | |||
| 181252 | 181252 | 113496 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 200x Mansell St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 3x3 | 6011235.51183 | 2090583.52363 | 37.7209776633755 | -122.403212099473 | (37.7209776633755, -122.403212099473) | |||
| 181042 | 181042 | 186841 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200x Sunset Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 32 | Width 0ft | 5984746.1314 | 2106971.8455 | 37.764460596444295 | -122.495985031222 | (37.7644605964443, -122.495985031222) | |||
| 180985 | 180985 | 204548 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 67 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 5ft | 5999721.47669 | 2097346.22168 | 37.738896698316005 | -122.443498100161 | (37.738896698316, -122.443498100161) |
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");