Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 32139 | 32139 | 215423 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 15 Fairfield Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5993769.4086 | 2092813.96021 | 37.72611098282629 | -122.46374856183998 | (37.7261109828263, -122.46374856184) | |||
| 35031 | 35031 | 241196 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 285 Mullen Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010370.46966 | 2100029.8165599997 | 37.7468668275408 | -122.406867732983 | (37.7468668275408, -122.406867732983) | |||
| 42264 | 42264 | 246217 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 725 Buena Vista Ave West | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5999828.0384 | 2107849.3991 | 37.7677419398126 | -122.443884078726 | (37.7677419398126, -122.443884078726) | |||
| 49851 | 49851 | 197983 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1809 19th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6012297.3164 | 2105130.82765 | 37.760980720296295 | -122.400563103211 | (37.7609807202963, -122.400563103211) | |||
| 51602 | 51602 | 197989 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 28 15th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6012209.71616 | 2107476.11774 | 37.7674154774686 | -122.401030868501 | (37.7674154774686, -122.401030868501) | |||
| 56645 | 56645 | 247209 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 800 Duboce Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6001860.515269999 | 2108286.6653 | 37.7690582897368 | -122.436885307832 | (37.7690582897368, -122.436885307832) | |||
| 153956 | 153956 | 241211 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2801 17th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009079.81613 | 2106354.44033 | 37.7641605153159 | -122.411777537601 | (37.7641605153159, -122.411777537601) | |||
| 157728 | 157728 | 215438 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 217 Staples Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5998696.43814 | 2093778.97623 | 37.7290433761531 | -122.44678558449101 | (37.7290433761531, -122.446785584491) | |||
| 174334 | 174334 | 241198 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 106 Chattanooga St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6004702.81282 | 2102995.20065 | 37.754690319613296 | -122.426677105059 | (37.7546903196133, -122.426677105059) | |||
| 180078 | 180078 | 241183 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1720 Dolores St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6005264.11037 | 2098316.58265 | 37.7418756279601 | -122.424403226839 | (37.7418756279601, -122.424403226839) | |||
| 188005 | 188005 | 215430 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 20 Lakewood Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5993628.724219999 | 2092981.5344200002 | 37.72656299287289 | -122.464247056069 | (37.7265629928729, -122.464247056069) |
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");