Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, PlantDate, DBH, PlotSize, PermitNotes, XCoord, YCoord, Latitude, Longitude, Location
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
425 | 425 | 251299 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 2190X Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4X4 | 6003624.7851 | 2107240.8343 | 37.766286807234295 | -122.430708166736 | (37.7662868072343, -122.430708166736) | ||||
431 | 431 | 251298 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 2190X Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4X4 | 6003624.7851 | 2107240.8343 | 37.766286807234295 | -122.430708166736 | (37.7662868072343, -122.430708166736) | ||||
432 | 432 | 251297 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 2190X Market St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4X4 | 6003624.7851 | 2107240.8343 | 37.766286807234295 | -122.430708166736 | (37.7662868072343, -122.430708166736) | ||||
446 | 446 | 251296 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 2190X Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4X4 | 6003624.7851 | 2107240.8343 | 37.766286807234295 | -122.430708166736 | (37.7662868072343, -122.430708166736) | ||||
155460 | 155460 | 115559 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 2539 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6001373.79142 | 2117611.09107 | 37.7946331129763 | -122.439237274207 | (37.7946331129763, -122.439237274207) | |||
7556 | 7556 | 115529 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 101 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | 4x4 | Permit Number 770842 | 6007327.31765 | 2111347.52577 | 37.777771876795 | -122.418192961161 | (37.777771876795, -122.418192961161) | |
8658 | 8658 | 115528 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 101 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | 4x4 | Permit Number 770842 | 6007325.8351 | 2111377.63368 | 37.77785446243671 | -122.418200224953 | (37.7778544624367, -122.418200224953) | |
98533 | 98533 | 119286 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 400 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2016 12:00:00 AM | 3 | 4x4 | 6005873.0 | 2111410.0 | 37.777861449140204 | -122.423228396467 | (37.7778614491402, -122.423228396467) | ||
125829 | 125829 | 119287 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 400 Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2016 12:00:00 AM | 3 | 4x4 | 6005873.0 | 2111410.0 | 37.777861449140204 | -122.423228396467 | (37.7778614491402, -122.423228396467) | ||
127953 | 127953 | 119285 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 400 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2016 12:00:00 AM | 3 | 4x4 | 6005873.0 | 2111410.0 | 37.777861449140204 | -122.423228396467 | (37.7778614491402, -122.423228396467) | ||
69564 | 69564 | 113240 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 329 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2015 12:00:00 AM | 2 | 3x4 | Permit Number 770912 | 6014728.70394 | 2112464.7296599997 | 37.7812532891345 | -122.392666980121 | (37.7812532891345, -122.392666980121) | |
129716 | 129716 | 113329 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 329 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770912 | 6014656.6559 | 2112395.64308 | 37.781059591367296 | -122.39291139783701 | (37.7810595913673, -122.392911397837) | |
157784 | 157784 | 113241 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 329 Brannan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2015 12:00:00 AM | 3 | 3x4 | Permit Number 770912 | 6014742.36618 | 2112476.99378 | 37.7812877223957 | -122.39262057328999 | (37.7812877223957, -122.39262057329) |
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");