Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▼ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28377 | 28377 | 48685 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 100 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2002 12:00:00 AM | 22 | Permit Number 45967 | 5995923.78548 | 2113769.63655 | 37.7837738786202 | -122.45781677815 | (37.7837738786202, -122.45781677815) | ||
| 38080 | 38080 | 217478 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 51 Keystone Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 5994094.09681 | 2093023.21308 | 37.7267042448879 | -122.462641314769 | (37.7267042448879, -122.462641314769) | |||
| 44242 | 44242 | 181222 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 578 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6002385.20268 | 2090560.3971799999 | 37.720415918045795 | -122.43380329969101 | (37.7204159180458, -122.433803299691) | |||
| 45244 | 45244 | 124344 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 105 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 4ft | 5995869.2461 | 2113758.79509 | 37.7837409774514 | -122.458004677882 | (37.7837409774514, -122.458004677882) | |||
| 75228 | 75228 | 84746 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 170 King St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 22 | Permit No. 49304 | 6015095.84023 | 2111532.74661 | 37.778714656793 | -122.391331689209 | (37.778714656793, -122.391331689209) | ||
| 168665 | 168665 | 217474 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2007 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 5993457.007669999 | 2101818.8487299997 | 37.750818147353705 | -122.46548237740299 | (37.7508181473537, -122.465482377403) | |||
| 173828 | 173828 | 199451 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1455 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 5ft | 6015633.06498 | 2108386.39567 | 37.77010527416 | -122.389253441416 | (37.77010527416, -122.389253441416) | |||
| 183952 | 183952 | 199492 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 281 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 5ft | 6010946.44549 | 2111612.84065 | 37.778703415264296 | -122.40569177677901 | (37.7787034152643, -122.405691776779) | |||
| 34652 | 34652 | 243942 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 701 Church St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | Width 3ft | 6004361.46086 | 2104388.80864 | 37.7584975338534 | -122.427956893407 | (37.7584975338534, -122.427956893407) | |||
| 39492 | 39492 | 181267 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 271 Leland Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 3ft | 6009562.93662 | 2087661.4051599998 | 37.7128605768164 | -122.40878766951799 | (37.7128605768164, -122.408787669518) | |||
| 183191 | 183191 | 181262 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 271 Leland Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 3ft | 6009462.97914 | 2087698.55594 | 37.7129569859491 | -122.409135776392 | (37.7129569859491, -122.409135776392) | |||
| 170196 | 170196 | 217458 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 22 | Width 0ft | 5996270.87292 | 2089001.5829099999 | 37.7157869222056 | -122.454825868913 | (37.7157869222056, -122.454825868913) | |||
| 181473 | 181473 | 218224 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 399 Claremont Blvd | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | 5993477.431469999 | 2097858.26435 | 37.7399445640996 | -122.465124117182 | (37.7399445640996, -122.465124117182) |
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");