Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, qCaretaker
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29906 | 29906 | 250138 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 2550x Lyon St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 101 | 5999227.62567 | 2117605.22496 | 37.7944946461503 | -122.446662836939 | (37.7944946461503, -122.446662836939) | ||||
41136 | 41136 | 250136 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 2550x Lyon St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 100 | 5999230.194080001 | 2117561.109 | 37.794373662156296 | -122.446650774326 | (37.7943736621563, -122.446650774326) | ||||
76485 | 76485 | 197585 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 900x Carolina St | 75 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6012517.30691 | 2102783.51804 | 37.7545477896502 | -122.399637433715 | (37.7545477896502, -122.399637433715) | ||||
114763 | 114763 | 112145 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 401X ROOSEVELT WAY | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6000065.0 | 2106738.0 | 37.764703828929896 | -122.44298463673401 | (37.7647038289299, -122.442984636734) | ||||
140384 | 140384 | 104978 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 66X San Lorenzo Way | 1 | Median : Yard 3 | Tree 1 | Private 1 | Permit Number 770332 | 5993690.5 | 2097533.7 | 37.7390656757525 | -122.46436386193301 | (37.7390656757525, -122.464363861933) |
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");