Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5008 | 5008 | 253723 | DPW Maintained 3 | Calocedrus decurrens :: Incense Cedar 177 | 1X Glenview Dr | Median : Yard 3 | Tree 1 | DPW 2 | 3x3 | 5998487.0 | 2100314.0 | 37.746975021233204 | -122.447979947083 | (37.7469750212332, -122.447979947083) | |||||
| 108934 | 108934 | 113438 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 180x LOWER TER | Median : Yard 3 | Tree 1 | Private 1 | 22 | 3x3 | 6000120.0 | 2106246.0 | 37.7633560547765 | -122.44275907578 | (37.7633560547765, -122.44275907578) | ||||
| 180863 | 180863 | 218285 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50x Junipero Serra Frontage West | 0 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 5991436.68421 | 2095414.89925 | 37.7331178131424 | -122.47200206387 | (37.7331178131424, -122.47200206387) | ||||
| 182431 | 182431 | 218284 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 50x Junipero Serra Frontage West | 0 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 5991438.8932 | 2095398.7783700002 | 37.7330736770928 | -122.4719932523 | (37.7330736770928, -122.4719932523) | ||||
| 3 | 3 | 119263 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 495X Lakeshore Dr | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 10x30 | |||||||||
| 763 | 763 | 251373 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
| 1098 | 1098 | 251438 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2501X Santiago St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
| 3018 | 3018 | 128709 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 4x Columbus Ave | 1 | Median : Yard 3 | Tree 1 | Private 1 | 19 | Width 9ft | 6011726.08303 | 2117794.9108 | 37.795721488711294 | -122.403429729102 | (37.7957214887113, -122.403429729102) | |||
| 3208 | 3208 | 253368 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 236 Moncada Way | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 10x10 | 5992398.0 | 2093455.0 | 37.7277919980392 | -122.468536018982 | (37.7277919980392, -122.468536018982) | ||||
| 9926 | 9926 | 173734 | Undocumented 2 | Tree(s) :: 17 | 2500X Lyon St | 1 | Median : Yard 3 | Tree 1 | Private 1 | 01/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779102 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | |
| 11046 | 11046 | 116538 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1002x Naples St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 3x3 | 6001578.1015800005 | 2088233.43486 | 37.7139807660769 | -122.436426724612 | (37.7139807660769, -122.436426724612) | |||
| 11659 | 11659 | 106061 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 12X Canyon Dr | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 40 | 6003256.93175 | 2086330.4794599998 | 37.7088509162175 | -122.430488359046 | (37.7088509162175, -122.430488359046) | ||||
| 13314 | 13314 | 187669 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 554 Valley St | 1 | Median : Yard 3 | Tree 1 | Private 1 | 6002324.0 | 2099197.0 | 37.7441265828549 | -122.434632098307 | (37.7441265828549, -122.434632098307) | |||||
| 18076 | 18076 | 107933 | DPW Maintained 3 | Tree(s) :: 17 | 3098X Market St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 5999920.0 | 2105144.0 | 37.7603188321069 | -122.44337164916 | (37.7603188321069, -122.44337164916) | |||||
| 19618 | 19618 | 102860 | DPW Maintained 3 | Calocedrus decurrens :: Incense Cedar 177 | 10X CRANLEIGH DR | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 03/06/2013 12:00:00 AM | 6 | 5991339.0 | 2095700.0 | 37.7338949747581 | -122.472360557436 | (37.7338949747581, -122.472360557436) | |||
| 22840 | 22840 | 251107 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1700X Quesada Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
| 24045 | 24045 | 211638 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 605x Saint Francis Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 5993404.24438 | 2096035.5287900001 | 37.7349355669295 | -122.465244802603 | (37.7349355669295, -122.465244802603) | ||||
| 24947 | 24947 | 206807 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 11x Saint Francis Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 5991689.221530001 | 2095992.9314700002 | 37.734719554257296 | -122.471171081279 | (37.7347195542573, -122.471171081279) | ||||
| 25048 | 25048 | 132103 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1400x The Embarcadero | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | Width 10ft | 6012095.78368 | 2120981.89347 | 37.8044928149639 | -122.402374687645 | (37.8044928149639, -122.402374687645) | |||
| 27355 | 27355 | 234354 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 650x Dolores St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 6004979.813630001 | 2104508.3497200003 | 37.7588607286626 | -122.425826859935 | (37.7588607286626, -122.425826859935) | ||||
| 31521 | 31521 | 175079 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1104x Alemany Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 6003837.73065 | 2094453.4628599999 | 37.7311877286109 | -122.42905980937599 | (37.7311877286109, -122.429059809376) | |||
| 32868 | 32868 | 251069 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5200x Geary Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 10ft | 5990794.5513 | 2112690.3427 | 37.7805144291466 | -122.47548298954099 | (37.7805144291466, -122.475482989541) | |||
| 32926 | 32926 | 195231 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300x Evans Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | Width 7ft | 6017124.15925 | 2097442.52392 | 37.7401382376012 | -122.38333380241001 | (37.7401382376012, -122.38333380241) | |||
| 33003 | 33003 | 194020 | DPW Maintained 3 | Morus alba :: White Mulberry 112 | 1100x Bay Shore Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6011361.40113 | 2093925.29225 | 37.7301604996095 | -122.403011863611 | (37.7301604996095, -122.403011863611) | ||||
| 33836 | 33836 | 246868 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3090x Market St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 32 | 5999955.5697 | 2105338.29244 | 37.760854339489 | -122.443262585704 | (37.760854339489, -122.443262585704) | ||||
| 34159 | 34159 | 124136 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3600x Geary Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 5995735.89711 | 2112868.88763 | 37.7812898666102 | -122.458401576021 | (37.7812898666102, -122.458401576021) | ||||
| 34680 | 34680 | 210208 | DPW Maintained 3 | Melaleuca styphelliodes :: Paperbark Tree 239 | 198x San Anselmo Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | 5993586.63469 | 2096365.42652 | 37.7358519005501 | -122.464638167637 | (37.7358519005501, -122.464638167637) | ||||
| 35368 | 35368 | 194364 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 310x The Embarcadero | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | Width 8ft | 6016200.86003 | 2114659.13107 | 37.78736027221179 | -122.387727152497 | (37.7873602722118, -122.387727152497) | |||
| 35652 | 35652 | 249474 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1200x Van Ness Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6006395.0323 | 2114736.35179 | 37.7870242450239 | -122.421658817911 | (37.7870242450239, -122.421658817911) | ||||
| 36942 | 36942 | 197374 | DPW Maintained 3 | Robinia pseudoacacia :: Black Locust 169 | 950x Kansas St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6011591.5235 | 2103896.27295 | 37.7575515198905 | -122.402917314288 | (37.7575515198905, -122.402917314288) | ||||
| 37159 | 37159 | 249463 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Van Ness Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6006539.42856 | 2113694.50869 | 37.7841717411666 | -122.421085234814 | (37.7841717411666, -122.421085234814) | ||||
| 38094 | 38094 | 231477 | DPW Maintained 3 | Malus :: Crab Apple 235 | 600x San Jose Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 8ft | 6005974.01132 | 2099648.68915 | 37.7455733533412 | -122.422043227715 | (37.7455733533412, -122.422043227715) | |||
| 39483 | 39483 | 211654 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 200x Terrace Dr | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 5993772.928590001 | 2096520.6347700001 | 37.7362888019871 | -122.464005344374 | (37.7362888019871, -122.464005344374) | ||||
| 40944 | 40944 | 189323 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 301x Cashmere St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6016365.09613 | 2096197.7024299998 | 37.736678230916795 | -122.38587161279499 | (37.7366782309168, -122.385871612795) | ||||
| 41518 | 41518 | 203592 | DPW Maintained 3 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1485x Northwood Dr | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5995892.33391 | 2093907.44512 | 37.729235533389705 | -122.45648881700899 | (37.7292355333897, -122.456488817009) | ||||
| 41755 | 41755 | 126624 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 801x Greenwich St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6009066.28691 | 2120109.01558 | 37.801926529358504 | -122.41279682292401 | (37.8019265293585, -122.412796822924) | |||
| 43116 | 43116 | 212147 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700x Miramar Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5995390.97132 | 2094022.6530799998 | 37.729523070026104 | -122.458230394627 | (37.7295230700261, -122.458230394627) | ||||
| 43461 | 43461 | 194341 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 418x The Embarcadero | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | Width 8ft | 6016036.61123 | 2112738.53497 | 37.7820776491035 | -122.388161338867 | (37.7820776491035, -122.388161338867) | |||
| 46600 | 46600 | 116804 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 131 LAKESHORE DR | 1 | Median : Yard 3 | Landscaping 2 | DPW 2 | 10x100 | 5984782.0 | 2094243.0 | 37.7295127607338 | -122.494922366174 | (37.7295127607338, -122.494922366174) | ||||
| 47939 | 47939 | 211068 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 500x Miramar Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 35 | 5995376.89131 | 2092998.0023 | 37.7267088170477 | -122.4582049393 | (37.7267088170477, -122.4582049393) | ||||
| 49072 | 49072 | 119929 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6400x Geary Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | 5987119.54861 | 2112558.01872 | 37.779937387281706 | -122.48818666733801 | (37.7799373872817, -122.488186667338) | ||||
| 49560 | 49560 | 220715 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3050x Cesar Chavez St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 10ft | 6009276.8217 | 2100578.88918 | 37.748313203588 | -122.410688249989 | (37.748313203588, -122.410688249989) | |||
| 49952 | 49952 | 135593 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 160x Drumm St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 7ft | 6013643.30781 | 2117724.86941 | 37.795636069300606 | -122.396790824061 | (37.7956360693006, -122.396790824061) | |||
| 51701 | 51701 | 208264 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 8ft | 5996224.40551 | 2098673.0355 | 37.742339745598706 | -122.45568515764299 | (37.7423397455987, -122.455685157643) | |||
| 52470 | 52470 | 189048 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2160x Palou Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6011828.04798 | 2097532.87353 | 37.7400922075757 | -122.40165206078699 | (37.7400922075757, -122.401652060787) | ||||
| 55886 | 55886 | 220703 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3250x Cesar Chavez St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 10ft | 6007996.96806 | 2100573.00592 | 37.7482252085331 | -122.415113547572 | (37.7482252085331, -122.415113547572) | |||
| 56164 | 56164 | 211065 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 400x Miramar Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 5995367.472159999 | 2092431.62053 | 37.7251531275117 | -122.458196526171 | (37.7251531275117, -122.458196526171) | ||||
| 57260 | 57260 | 242793 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2x Coso Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | Width 9ft | 6007083.58829 | 2099965.0449 | 37.746504513177 | -122.418228897148 | (37.746504513177, -122.418228897148) | |||
| 57455 | 57455 | 240287 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 4300x 21st St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 10ft | 6000783.43844 | 2103265.5060900003 | 37.755210146643 | -122.440250712118 | (37.755210146643, -122.440250712118) | |||
| 57778 | 57778 | 124704 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2x Cherry St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 5996074.417169999 | 2115943.0366 | 37.789750104458 | -122.457452946984 | (37.789750104458, -122.457452946984) | ||||
| 58200 | 58200 | 246535 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1x Octavia St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | Width 8ft | 6005703.308569999 | 2109325.61851 | 37.7721286642513 | -122.423667182089 | (37.7721286642513, -122.423667182089) | |||
| 59175 | 59175 | 217814 | DPW Maintained 3 | Eucalyptus camaldulensis :: River Red Gum 340 | 1x Junipero Serra Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 39 | 5991642.1645 | 2095884.13354 | 37.734418100595995 | -122.47132584741001 | (37.734418100596, -122.47132584741) | ||||
| 59302 | 59302 | 250133 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 2550x Lyon St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 5999242.46646 | 2117532.2796099996 | 37.7942952053215 | -122.446606235406 | (37.7942952053215, -122.446606235406) | ||||
| 60619 | 60619 | 197886 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 1498x Tennessee St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 7ft | 6015689.86816 | 2101943.47037 | 37.7524175331559 | -122.388607147206 | (37.7524175331559, -122.388607147206) | |||
| 61518 | 61518 | 220721 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3100x Cesar Chavez St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 10ft | 6008980.2117099995 | 2100577.3064900003 | 37.748292223309704 | -122.41171381166401 | (37.7482922233097, -122.411713811664) | |||
| 65398 | 65398 | 132082 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1200x The Embarcadero | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6012375.04896 | 2120549.1986599998 | 37.803320325622295 | -122.40137783233999 | (37.8033203256223, -122.40137783234) | |||
| 67634 | 67634 | 206814 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2187x 09th Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 5993540.83818 | 2100833.0540400003 | 37.748116241270104 | -122.465120894018 | (37.7481162412701, -122.465120894018) | ||||
| 68230 | 68230 | 212110 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1802x Monterey Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | Width 10ft | 5992575.24541 | 2095393.14196 | 37.733123891637504 | -122.468064206012 | (37.7331238916375, -122.468064206012) | |||
| 68645 | 68645 | 249487 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1500x Van Ness Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 6006262.64335 | 2115713.0194599996 | 37.789698466352704 | -122.42218626847901 | (37.7896984663527, -122.422186268479) | ||||
| 69754 | 69754 | 212137 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 602x Miramar Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 36 | 5995383.74966 | 2093392.9126 | 37.7277935397334 | -122.458209800147 | (37.7277935397334, -122.458209800147) | ||||
| 69767 | 69767 | 251022 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5000x Geary Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 10ft | 5991511.6828 | 2112712.2313 | 37.7806160737768 | -122.473003713445 | (37.7806160737768, -122.473003713445) | |||
| 70498 | 70498 | 212107 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1701x Monterey Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | Width 10ft | 5992822.82885 | 2095375.69454 | 37.7330902803915 | -122.46720698303601 | (37.7330902803915, -122.467206983036) | |||
| 71118 | 71118 | 212103 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1602x Monterey Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 32 | Width 10ft | 5993196.79522 | 2095380.0761799999 | 37.7331238916354 | -122.46591441082899 | (37.7331238916354, -122.465914410829) | |||
| 71756 | 71756 | 233939 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 270x Dolores St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 32 | 6004850.2917 | 2106826.33652 | 37.765218049699605 | -122.426439853137 | (37.7652180496996, -122.426439853137) | ||||
| 73883 | 73883 | 208307 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 700x Bosworth St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 6002108.77199 | 2095420.81947 | 37.7337458465985 | -122.435106279748 | (37.7337458465985, -122.435106279748) | |||
| 77799 | 77799 | 105836 | DPW Maintained 3 | Araucaria heterophylla :: Norfolk Island Pine 24 | 2100X SLOAT BLVD | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5984309.0 | 2095832.0 | 37.733848030924 | -122.49667476772 | (37.733848030924, -122.49667476772) | ||||
| 79875 | 79875 | 112144 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 401X ROOSEVELT WAY | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6000065.0 | 2106738.0 | 37.764703828929896 | -122.44298463673401 | (37.7647038289299, -122.442984636734) | ||||
| 79938 | 79938 | 96141 | DPW Maintained 3 | Tree(s) :: 17 | 1468X Innes Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016228.8 | 2096740.9 | 37.738162198215 | -122.386380713289 | (37.738162198215, -122.386380713289) | ||||
| 82638 | 82638 | 96136 | DPW Maintained 3 | Tree(s) :: 17 | 1454X Innes Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016287.8 | 2096690.3 | 37.7380265265677 | -122.386173192236 | (37.7380265265677, -122.386173192236) | ||||
| 84668 | 84668 | 116500 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 71X PARKRIDGE DR | 1 | Median : Yard 3 | Tree 1 | Private 1 | 45 | 3x3 | 5999012.0 | 2102131.0 | 37.751994056327 | -122.446295237287 | (37.751994056327, -122.446295237287) | |||
| 84882 | 84882 | 108688 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1x MONTEZUMA ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | 6007361.0 | 2099793.0 | 37.7460477277002 | -122.417257445993 | (37.7460477277002, -122.417257445993) | ||||
| 85176 | 85176 | 104920 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 750 Gonzalez Dr | 1 | Median : Yard 3 | Tree 1 | Private 1 | 5990385.0 | 2090588.0 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | |||||
| 86719 | 86719 | 109347 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 59x BURNSIDE AVE | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6001229.7 | 2095779.3 | 37.7346801948558 | -122.438171157158 | (37.7346801948558, -122.438171157158) | ||||
| 91583 | 91583 | 96139 | DPW Maintained 3 | Tree(s) :: 17 | 1460X Innes Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016261.2 | 2096710.2 | 37.738079695647706 | -122.386266549459 | (37.7380796956477, -122.386266549459) | ||||
| 92261 | 92261 | 117511 | DPW Maintained 3 | Shrub :: Shrub 98 | 2634 37TH AVE | 1 | Median : Yard 3 | Landscaping 2 | DPW 2 | 20 | 3x3 | 5984921.0 | 2097163.0 | 37.737538439530795 | -122.49465702329901 | (37.7375384395308, -122.494657023299) | |||
| 92518 | 92518 | 102573 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 20X Park St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6004982.6 | 2096420.1 | 37.7366524147431 | -122.425241679782 | (37.7366524147431, -122.425241679782) | ||||
| 93441 | 93441 | 115152 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 245x ARLINGTON ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | 3x3 | 6004671.0 | 2096632.0 | 37.737216635749604 | -122.426334098447 | (37.7372166357496, -122.426334098447) | |||
| 93919 | 93919 | 96976 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 390X Filbert St | 1 | Median : Yard 3 | Tree 1 | Rec/Park 3 | 28 | 6010951.1 | 2119992.4 | 37.8017119430502 | -122.406266229116 | (37.8017119430502, -122.406266229116) | ||||
| 94441 | 94441 | 96130 | DPW Maintained 3 | Tree(s) :: 17 | 1428X Innes Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016403.1 | 2096603.7 | 37.737795121412795 | -122.385768505015 | (37.7377951214128, -122.385768505015) | ||||
| 94540 | 94540 | 106114 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1752X DOLORES ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 6005197.0 | 2098194.1 | 37.741535528464496 | -122.424626562024 | (37.7415355284645, -122.424626562024) | |||||
| 95383 | 95383 | 104500 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 22 SATURN ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 45 | 6000539.0 | 2106092.0 | 37.762957086281396 | -122.441298844913 | (37.7629570862814, -122.441298844913) | ||||
| 95953 | 95953 | 111416 | Undocumented 2 | Ulmus spp :: Elm Spp 215 | 200x SAN MARCOS AVE | 1 | Median : Yard 3 | Tree 1 | Private 1 | 24 | 5993395.0 | 2100395.0 | 37.746905045660796 | -122.465593373526 | (37.7469050456608, -122.465593373526) | ||||
| 96850 | 96850 | 113535 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100X CASHMERE ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12/05/2015 12:49:00 PM | 3 | 6017054.0 | 2095889.0 | 37.7358686950692 | -122.38346826685301 | (37.7358686950692, -122.383468266853) | |||
| 99590 | 99590 | 111406 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 150x SAN MARCOS AVE | 1 | Median : Yard 3 | Tree 1 | Private 1 | 40 | 5993566.0 | 2100407.0 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | ||||
| 100517 | 100517 | 104502 | Private 5 | Pinus radiata :: Monterey Pine 3 | 30X SATURN ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6000456.0 | 2106003.0 | 37.7627079858093 | -122.44157952536999 | (37.7627079858093, -122.44157952537) | ||||
| 102484 | 102484 | 113196 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 4090X 20th St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 6003325.9669699995 | 2104184.75857 | 37.7578786248615 | -122.43152352597099 | (37.7578786248615, -122.431523525971) | |||||
| 102603 | 102603 | 96129 | DPW Maintained 3 | Tree(s) :: 17 | 1424X Innes Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016423.9 | 2096594.4 | 37.7377707364606 | -122.385695940665 | (37.7377707364606, -122.385695940665) | ||||
| 104032 | 104032 | 98994 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 745X SANCHEZ ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 40 | 6003713.0 | 2103768.0 | 37.7567562336472 | -122.430155272915 | (37.7567562336472, -122.430155272915) | ||||
| 104474 | 104474 | 97692 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 70x Benton Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 11/05/2011 12:00:00 AM | 6004768.61645 | 2094959.0484200001 | 37.732628603868704 | -122.425877544976 | (37.7326286038687, -122.425877544976) | ||||
| 105675 | 105675 | 109208 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401x CASTRO ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 6002698.0 | 2098487.0 | 37.7421983129634 | -122.43328816691401 | (37.7421983129634, -122.433288166914) | |||||
| 107740 | 107740 | 107644 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1400x KIRKWOOD AVE | 1 | Median : Yard 3 | Tree 1 | Private 1 | 6015822.8 | 2096363.1 | 37.7371023539668 | -122.38775811873998 | (37.7371023539668, -122.38775811874) | |||||
| 108451 | 108451 | 104499 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 44X SATURN ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6000456.0 | 2106003.0 | 37.7627079858093 | -122.44157952536999 | (37.7627079858093, -122.44157952537) | ||||
| 108704 | 108704 | 106057 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 140X CANYON DR | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6002713.0 | 2086188.2 | 37.708429419739794 | -122.432358106226 | (37.7084294197398, -122.432358106226) | ||||
| 109029 | 109029 | 108973 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 3485X SAN BRUNO AVE | 1 | Median : Yard 3 | Tree 1 | DPW for City Agency 10 | 6011510.0 | 2091910.0 | 37.724635221414 | -122.402356490066 | (37.724635221414, -122.402356490066) | |||||
| 109166 | 109166 | 103947 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2363X 36th Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 5985162.60331 | 2099213.25819 | 37.74318203563929 | -122.49397275511299 | (37.7431820356393, -122.493972755113) | ||||
| 109545 | 109545 | 111090 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 28x HIGUERA AVE | 1 | Median : Yard 3 | Tree 1 | Private 1 | 06/04/2015 12:00:00 AM | 3 | Permit Number 777485 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | ||
| 109648 | 109648 | 111396 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 50x SANTA RITA AVE | 1 | Median : Yard 3 | Tree 1 | Private 1 | 53 | Permit Number 779360 | 5993713.0 | 2100532.0 | 37.74729954942379 | -122.464503713167 | (37.7472995494238, -122.464503713167) | |||
| 109811 | 109811 | 96135 | DPW Maintained 3 | Tree(s) :: 17 | 1444X Innes Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016335.2 | 2096661.0 | 37.7379486980737 | -122.386007263552 | (37.7379486980737, -122.386007263552) | ||||
| 110134 | 110134 | 117310 | Permitted Site 1 | Tree(s) :: 17 | 126X Juan Bautista Cir | 1 | Median : Yard 3 | Tree 1 | Private 1 | 06/06/2016 12:00:00 AM | 3 | 10x10 | Permit Number 777998 | 5989282.4 | 2089642.3 | 37.7171428191075 | -122.479027821944 | (37.7171428191075, -122.479027821944) | |
| 110858 | 110858 | 104466 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 200X VIDAL DR | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 50 | 5987624.0 | 2090693.0 | 37.719931328083206 | -122.48483708629801 | (37.7199313280832, -122.484837086298) |
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");