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");