Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: DBH
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17299 | 17299 | 8210 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2189X Funston Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8X25 | 5992281.31882 | 2100517.50117 | 37.7471771044468 | -122.469453261968 | (37.7471771044468, -122.469453261968) | |||
| 18335 | 18335 | 8215 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2189X Funston Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8X25 | 5992282.36795 | 2100542.6208599997 | 37.7472461372953 | -122.469451462412 | (37.7472461372953, -122.469451462412) | |||
| 18536 | 18536 | 8217 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2189X Funston Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8X25 | 5992282.7442 | 2100560.49724 | 37.7472952429876 | -122.469451462429 | (37.7472952429876, -122.469451462429) | |||
| 18961 | 18961 | 8216 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2189X Funston Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8X25 | 5992283.56126 | 2100549.85323 | 37.7472660644888 | -122.469447862447 | (37.7472660644888, -122.469447862447) | |||
| 19720 | 19720 | 8219 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2189X Funston Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8X25 | 5992283.90112 | 2100578.3571900004 | 37.747344348682795 | -122.469448761774 | (37.7473443486828, -122.469448761774) | |||
| 20399 | 20399 | 8212 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2189X Funston Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8X25 | 5992284.57704 | 2100523.9125099997 | 37.7471948966366 | -122.46944246202 | (37.7471948966366, -122.46944246202) | |||
| 21139 | 21139 | 8218 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2189X Funston Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8X25 | 5992283.97023 | 2100569.2840400003 | 37.7473194401374 | -122.46944786245199 | (37.7473194401374, -122.469447862452) | |||
| 21615 | 21615 | 8213 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2189X Funston Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8X25 | 5992288.54504 | 2100526.93925 | 37.7472034366016 | -122.469428961394 | (37.7472034366016, -122.469428961394) |
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");