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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
682 | 682 | 251365 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | ||||||||||
712 | 712 | 251366 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | ||||||||||
713 | 713 | 251364 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | ||||||||||
95325 | 95325 | 111308 | Private 5 | Pinus radiata :: Monterey Pine 3 | 780x JAMESTOWN AVE | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6x90 | 6015099.0 | 2088640.0 | 37.7158561393861 | -122.389721379672 | (37.7158561393861, -122.389721379672) | ||||
99533 | 99533 | 100242 | Private 5 | Tree(s) :: 17 | 76 Linda St | Sidewalk: Curb side : Pot 10 | Landscaping 2 | Private 1 | 6005815.0 | 2105046.0 | 37.76038415245 | -122.422976606568 | (37.76038415245, -122.422976606568) | ||||||
2502 | 2502 | 253119 | Private 5 | Pinus radiata :: Monterey Pine 3 | 185 Belgrave Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | Permit Number 780239 | 5997636.85301 | 2104869.74588 | 37.759435335978296 | -122.45124816933 | (37.7594353359783, -122.45124816933) | ||||
3835 | 3835 | 253567 | Private 5 | Salix spp :: Willow 218 | 25 Raycliff Ter | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6000333.0 | 2116919.0 | 37.792673532262505 | -122.44278881704399 | (37.7926735322625, -122.442788817044) | |||||
5091 | 5091 | 253769 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 Raccoon Dr | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5998692.0 | 2104165.0 | 37.7575606372552 | -122.44754823773899 | (37.7575606372552, -122.447548237739) | |||||
8592 | 8592 | 121500 | Private 5 | Pinus radiata :: Monterey Pine 3 | 251X Pennsylvania Ave | 1 | Back Yard : Yard 13 | Tree 1 | DPW 2 | ||||||||||
13268 | 13268 | 187627 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 88 States St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6001213.0 | 2106258.0 | 37.7634512529938 | -122.438979613423 | (37.7634512529938, -122.438979613423) | |||||
79705 | 79705 | 108816 | Private 5 | Pinus radiata :: Monterey Pine 3 | 348 Gold Mine Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 30 | 6001084.0 | 2097744.0 | 37.740066514789 | -122.43881563429301 | (37.740066514789, -122.438815634293) | ||||
85994 | 85994 | 104510 | Private 5 | Sequoia sempervirens :: Coast Redwood 116 | 254 ALLISON ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 40 | 6000052.0 | 2087408.0 | 37.7116274717654 | -122.441642291463 | (37.7116274717654, -122.441642291463) | ||||
97106 | 97106 | 102276 | Private 5 | Tree(s) :: 17 | 279 Topaz Way | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 6001205.6 | 2097796.6 | 37.7402178594385 | -122.43839895973301 | (37.7402178594385, -122.438398959733) | ||||||
101345 | 101345 | 104689 | Private 5 | Pinus radiata :: Monterey Pine 3 | 657 PALMETTO AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 30 | 5991786.0 | 2087190.1 | 37.7105547448876 | -122.470195680575 | (37.7105547448876, -122.470195680575) | ||||
103907 | 103907 | 106639 | Private 5 | Private shrub :: Private Shrub 64 | 1321X CLAYTON ST | 1 | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5998910.0 | 2105100.0 | 37.7601403710114 | -122.44686158716699 | (37.7601403710114, -122.446861587167) | |||||
110838 | 110838 | 107348 | Private 5 | Private shrub :: Private Shrub 64 | 260 LANSDALE AVE | 1 | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5995019.0 | 2096651.7 | 37.7367204092857 | -122.459706678853 | (37.7367204092857, -122.459706678853) | |||||
111683 | 111683 | 114761 | Private 5 | Pinus radiata :: Monterey Pine 3 | 2155 10TH AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10x10 | 5993160.0 | 2101036.0 | 37.7486515109126 | -122.466452556212 | (37.7486515109126, -122.466452556212) | ||||
122672 | 122672 | 102060 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 115 Kensington Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5994908.3 | 2098325.8 | 37.741310707397396 | -122.460210667073 | (37.7413107073974, -122.460210667073) | |||||
123904 | 123904 | 106641 | Private 5 | Private shrub :: Private Shrub 64 | 1323X CLAYTON ST | 1 | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5999055.0 | 2105304.0 | 37.7607087868046 | -122.446374778866 | (37.7607087868046, -122.446374778866) | |||||
145175 | 145175 | 108885 | Private 5 | Cupaniopsis anacardioides :: Carrotwood 118 | 707 NOE ST | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6003152.4 | 2104071.5 | 37.757557804850705 | -122.43211570496099 | (37.7575578048507, -122.432115704961) | ||||
127330 | 127330 | 109501 | Private 5 | Ulmus americana :: American Elm 119 | 1400X on Filbert Montgomery St | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | see 279 Filbert St. Same tree; shared responsibility | 6011485.9 | 2120124.8 | 37.802105381717894 | -122.404424889694 | (37.8021053817179, -122.404424889694) | ||||
110956 | 110956 | 118356 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 RACCOON DR | 2 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 48 | 5998776.0 | 2103987.0 | 37.7570766935068 | -122.44724492231701 | (37.7570766935068, -122.447244922317) | ||||
94096 | 94096 | 100243 | Private 5 | Tree(s) :: 17 | 1326-1332 Shotwell St | unknown : Yard 19 | Tree 1 | Private 1 | 6008043.0 | 2100485.0 | 37.7479861507453 | -122.41494814206699 | (37.7479861507453, -122.414948142067) | ||||||
106936 | 106936 | 105441 | Private 5 | Eucalyptus globulus :: Blue Gum 103 | 425 WAWONA ST | unknown : Yard 19 | Tree 1 | Private 1 | 5991587.6 | 2097036.5 | 37.737579050883106 | -122.471598439568 | (37.7375790508831, -122.471598439568) |
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");