Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3525 | 3525 | 253489 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
| 26649 | 26649 | 49071 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1970 Ocean Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/2003 12:00:00 AM | Permit Number 46231 | 5993706.31601319 | 2092791.54243423 | 37.7260457932168 | -122.46396504093 | (37.7260457932168, -122.46396504093) | ||
| 34372 | 34372 | 241223 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2800 17th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009004.56515 | 2106399.07167 | 37.7642788409211 | -122.41204096432699 | (37.7642788409211, -122.412040964327) | |||
| 48849 | 48849 | 198000 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 828x Jamestown Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 5ft | 6014844.30096 | 2089001.4675099999 | 37.7168345316683 | -122.390626989449 | (37.7168345316683, -122.390626989449) | |||
| 59765 | 59765 | 241209 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2801 17th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6009128.3617 | 2106356.68814 | 37.76416941052621 | -122.411609790669 | (37.7641694105262, -122.411609790669) | |||
| 76250 | 76250 | 215428 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 20 Lakewood Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5993651.19736 | 2093024.90181 | 37.7266833644367 | -122.464172514845 | (37.7266833644367, -122.464172514845) | |||
| 106980 | 106980 | 108282 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1 HENRY ADAMS ST | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | |||
| 107827 | 107827 | 115617 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1400 16th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6012270.55026102 | 2107054.03832976 | 37.7662599354936 | -122.400790794031 | (37.7662599354936, -122.400790794031) | ||||
| 110283 | 110283 | 34049 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 375 Alabama St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37958 | 6008950.19472335 | 2106493.86234805 | 37.7645360636147 | -122.41223571697999 | (37.7645360636147, -122.41223571698) | ||
| 117817 | 117817 | 42739 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 2155 Bay Shore Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42735 | 6011836.19977805 | 2087516.89388515 | 37.712590845234296 | -122.400920338197 | (37.7125908452343, -122.400920338197) | ||
| 126801 | 126801 | 34084 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | 6 | 3x3 | Permit Number 37968 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551068999 | (37.7627561815899, -122.41623551069) |
| 164340 | 164340 | 117703 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 4001 Clement St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 7ft | 5983084.790030001 | 2113081.26685 | 37.7811378565893 | -122.502183200126 | (37.7811378565893, -122.502183200126) |
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");