Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
39579 | 39579 | 244952 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 290 Page St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 0ft | 6005205.1684 | 2109938.5353 | 37.7737834538473 | -122.425433917449 | (37.7737834538473, -122.425433917449) | |||
57029 | 57029 | 129009 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1137 Montgomery St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 3ft | 6011525.133769999 | 2119231.5602700002 | 37.7996549551749 | -122.404226217291 | (37.7996549551749, -122.404226217291) | |||
60014 | 60014 | 129023 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 400 Montgomery St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6011906.72239 | 2116826.4681700002 | 37.793072464585705 | -122.40273653976001 | (37.7930724645857, -122.40273653976) | |||
69471 | 69471 | 128994 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1414 Jones St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 6008423.060869999 | 2117463.28601 | 37.794625888727495 | -122.41483533869801 | (37.7946258887275, -122.414835338698) | |||
147927 | 147927 | 226015 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2440 24th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 2ft | 6011224.38926 | 2102319.5101099997 | 37.753201570213896 | -122.404076055683 | (37.7532015702139, -122.404076055683) | |||
153634 | 153634 | 129024 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 400 Montgomery St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6011905.28525 | 2116843.33674 | 37.7931187014156 | -122.40274269923 | (37.7931187014156, -122.40274269923) | |||
160831 | 160831 | 128995 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1414 Jones St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 6008424.44271 | 2117443.95005 | 37.794572874590294 | -122.41482918821 | (37.7945728745903, -122.41482918821) | |||
162869 | 162869 | 228337 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1768 Sanchez St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 2ft | 6003964.05943 | 2097961.58291 | 37.740827380874 | -122.428873076831 | (37.740827380874, -122.428873076831) | |||
164823 | 164823 | 226270 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 4491 24th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 26 | Width 8ft | 6000072.435819999 | 2101640.71207 | 37.7507083509117 | -122.442592908247 | (37.7507083509117, -122.442592908247) |
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");