Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 763 | 763 | 251373 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
| 1098 | 1098 | 251438 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2501X Santiago St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
| 3208 | 3208 | 253368 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 236 Moncada Way | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 10x10 | 5992398.0 | 2093455.0 | 37.7277919980392 | -122.468536018982 | (37.7277919980392, -122.468536018982) | ||||
| 13314 | 13314 | 187669 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 554 Valley St | 1 | Median : Yard 3 | Tree 1 | Private 1 | 6002324.0 | 2099197.0 | 37.7441265828549 | -122.434632098307 | (37.7441265828549, -122.434632098307) | |||||
| 24947 | 24947 | 206807 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 11x Saint Francis Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 5991689.221530001 | 2095992.9314700002 | 37.734719554257296 | -122.471171081279 | (37.7347195542573, -122.471171081279) | ||||
| 67634 | 67634 | 206814 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2187x 09th Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 5993540.83818 | 2100833.0540400003 | 37.748116241270104 | -122.465120894018 | (37.7481162412701, -122.465120894018) | ||||
| 92518 | 92518 | 102573 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 20X Park St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6004982.6 | 2096420.1 | 37.7366524147431 | -122.425241679782 | (37.7366524147431, -122.425241679782) | ||||
| 95383 | 95383 | 104500 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 22 SATURN ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 45 | 6000539.0 | 2106092.0 | 37.762957086281396 | -122.441298844913 | (37.7629570862814, -122.441298844913) | ||||
| 110858 | 110858 | 104466 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 200X VIDAL DR | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 50 | 5987624.0 | 2090693.0 | 37.719931328083206 | -122.48483708629801 | (37.7199313280832, -122.484837086298) | ||||
| 141156 | 141156 | 104399 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2440X 37th Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 5984875.46821 | 2098521.80546 | 37.7412666886784 | -122.49491460561501 | (37.7412666886784, -122.494914605615) | |||||
| 141372 | 141372 | 104398 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 3525X Ulloa St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 48 | 5985120.1668300005 | 2098189.34613 | 37.7403681660846 | -122.494044040088 | (37.7403681660846, -122.494044040088) | ||||
| 159868 | 159868 | 190994 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 50x Dedman Ct | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 37 | 6016552.89235 | 2096279.67285 | 37.736913695911 | -122.385228023775 | (37.736913695911, -122.385228023775) | ||||
| 168306 | 168306 | 206810 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 66x Santa Monica Way | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 5993662.74276 | 2097416.4076799997 | 37.7387420203269 | -122.464451319071 | (37.7387420203269, -122.464451319071) | ||||
| 182720 | 182720 | 247577 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 300x Alemany Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 44 | 6008700.9232 | 2095336.3735 | 37.7338860994661 | -122.41230921050501 | (37.7338860994661, -122.412309210505) |
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");