Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, PlantDate, DBH, PlotSize, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7078 | 7078 | 95163 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 998 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 04/21/2016 12:00:00 AM | 3 | 3x3 | 6001491.8688 | 2111772.0851 | 37.7786074207661 | -122.438410176931 | (37.7786074207661, -122.438410176931) | |
82777 | 82777 | 85446 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y12 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
88231 | 88231 | 85433 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y1 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
95845 | 95845 | 85448 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y14 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
96265 | 96265 | 85437 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y4 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
97533 | 97533 | 85444 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y10 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
98712 | 98712 | 85439 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y5 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
98784 | 98784 | 95178 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1215 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3 | 3x3 | 6001286.14287 | 2112595.80793 | 37.7808574507306 | -122.439180914838 | (37.7808574507306, -122.439180914838) | ||
99579 | 99579 | 85445 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y11 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
102642 | 102642 | 85435 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y3 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/07/2006 12:00:00 AM | 3 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
103232 | 103232 | 95167 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1300 DIVISADERO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3 | 3x3 | 6001355.0 | 2112906.0 | 37.781713077167396 | -122.43896494142 | (37.7817130771674, -122.43896494142) | ||
103498 | 103498 | 85440 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y6 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
105788 | 105788 | 85443 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y9 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | ||||
122914 | 122914 | 85441 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y7 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
123072 | 123072 | 85434 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y2 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/23/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
126348 | 126348 | 85447 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y13 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
143542 | 143542 | 85442 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y8 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) |
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");