Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, PlantDate, DBH, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2166 | 2166 | 43082 | Permitted Site 1 | Grevillea 'Red Hooks' :: Silk Oak Tree 'Red Hooks' 171 | 205 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2003 12:00:00 AM | 21 | Permit Number 46999 | 6009001.971030001 | 2113315.3872700003 | 37.783269275104104 | -122.412538876675 | (37.7832692751041, -122.412538876675) | |
| 2171 | 2171 | 43085 | Permitted Site 1 | Grevillea 'Red Hooks' :: Silk Oak Tree 'Red Hooks' 171 | 240 Jones St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2000 12:00:00 AM | 15 | Permit Number 42924 | 6009019.84513 | 2113517.34513 | 37.7838248061099 | -122.412491319636 | (37.7838248061099, -122.412491319636) | |
| 2172 | 2172 | 43089 | Permitted Site 1 | Grevillea 'Red Hooks' :: Silk Oak Tree 'Red Hooks' 171 | 240 Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2000 12:00:00 AM | 15 | Permit Number 42924 | 6009028.16004 | 2113458.59755 | 37.783663965959995 | -122.41245839903999 | (37.78366396596, -122.41245839904) | |
| 2177 | 2177 | 43088 | Permitted Site 1 | Grevillea 'Red Hooks' :: Silk Oak Tree 'Red Hooks' 171 | 240 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2000 12:00:00 AM | 14 | Permit Number 42924 | 6009031.2139800005 | 2113438.72212 | 37.7836095641737 | -122.412446428164 | (37.7836095641737, -122.412446428164) | |
| 2185 | 2185 | 43087 | Permitted Site 1 | Grevillea 'Red Hooks' :: Silk Oak Tree 'Red Hooks' 171 | 240 Jones St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2000 12:00:00 AM | 16 | Permit Number 42924 | 6009022.06951 | 2113499.20947 | 37.7837751347655 | -122.41248234170601 | (37.7837751347655, -122.412482341706) | |
| 91299 | 91299 | 67362 | Permitted Site 1 | Grevillea 'Red Hooks' :: Silk Oak Tree 'Red Hooks' 171 | 2671 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1992 12:00:00 AM | Permit Number 30853 | 6010086.54525916 | 2103948.57589748 | 37.757610980443 | -122.408125849252 | (37.757610980443, -122.408125849252) | ||
| 92287 | 92287 | 59885 | Permitted Site 1 | Grevillea 'Red Hooks' :: Silk Oak Tree 'Red Hooks' 171 | 1850 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/07/1981 12:00:00 AM | Permit Number 19351 | 5998908.71324025 | 2110792.89105347 | 37.7757715367559 | -122.447275774754 | (37.7757715367559, -122.447275774754) | ||
| 106428 | 106428 | 66692 | Permitted Site 1 | Grevillea 'Red Hooks' :: Silk Oak Tree 'Red Hooks' 171 | 201 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1991 12:00:00 AM | Permit Number 29921 | 6008604.66149229 | 2112784.65195825 | 37.7817896977572 | -122.413875858365 | (37.7817896977572, -122.413875858365) | ||
| 126290 | 126290 | 62694 | Permitted Site 1 | Grevillea 'Red Hooks' :: Silk Oak Tree 'Red Hooks' 171 | 223 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1987 12:00:00 AM | Permit Number 24327 | 6005062.32368294 | 2100161.23117158 | 37.7469292144699 | -122.425232170901 | (37.7469292144699, -122.425232170901) | ||
| 139304 | 139304 | 63629 | Permitted Site 1 | Grevillea 'Red Hooks' :: Silk Oak Tree 'Red Hooks' 171 | 226 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/2011 12:00:00 AM | Permit Number 24272 | 6005034.16074873 | 2100211.76184956 | 37.7470663690256 | -122.425333151112 | (37.7470663690256, -122.425333151112) |
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");