Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, PlantDate, PermitNotes, XCoord, YCoord, Latitude, Longitude, Location
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28860 | 28860 | 51570 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 227 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/04/2005 12:00:00 AM | 17 | Permit Number 47867 | 5988337.51894 | 2114460.53389 | 37.7852321378524 | -122.48411277430401 | (37.7852321378524, -122.484112774304) | |
| 40659 | 40659 | 62578 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 739 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/1986 12:00:00 AM | 9 | Permit Number 22783 | 6011302.7424099995 | 2104925.74778 | 37.7603620991639 | -122.403988486898 | (37.7603620991639, -122.403988486898) | |
| 57547 | 57547 | 38224 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1099 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2002 12:00:00 AM | 14 | Permit Number 40351 | 6014264.59569 | 2102044.43409 | 37.7526156672934 | -122.39354307806101 | (37.7526156672934, -122.393543078061) | |
| 62464 | 62464 | 62579 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 741 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/1986 12:00:00 AM | 10 | Permit Number 22784 | 6011303.77085 | 2104898.93824 | 37.7602885436105 | -122.40398304329399 | (37.7602885436105, -122.403983043294) | |
| 78284 | 78284 | 36808 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1290 Egbert Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39532 | 6014916.278192299 | 2090716.3266444001 | 37.721547191141205 | -122.39049795372 | (37.7215471911412, -122.39049795372) | ||
| 83231 | 83231 | 36833 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2715 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39537 | 6015005.69395491 | 2090908.83002417 | 37.7220807273762 | -122.390202307194 | (37.7220807273762, -122.390202307194) | ||
| 89868 | 89868 | 36789 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1314 Donner Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39526 | 6015468.42166203 | 2090653.62366449 | 37.7214056358126 | -122.388584951991 | (37.7214056358126, -122.388584951991) | ||
| 95666 | 95666 | 36809 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1290 Egbert Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39532 | 6014916.278192299 | 2090716.3266444001 | 37.721547191141205 | -122.39049795372 | (37.7215471911412, -122.39049795372) | ||
| 116970 | 116970 | 34459 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1960 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/2015 12:00:00 AM | Permit Number 42077 | 6008233.26269903 | 2119182.7725058 | 37.7993365057546 | -122.415613869084 | (37.7993365057546, -122.415613869084) | ||
| 117616 | 117616 | 36790 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1314 Donner Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39526 | 6015468.42166203 | 2090653.62366449 | 37.7214056358126 | -122.388584951991 | (37.7214056358126, -122.388584951991) | ||
| 120244 | 120244 | 34458 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1960 Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/2015 12:00:00 AM | 3x3 | Permit Number 42077 | 6008233.26269903 | 2119182.7725058 | 37.7993365057546 | -122.415613869084 | (37.7993365057546, -122.415613869084) | |
| 125997 | 125997 | 34460 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1960 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/2015 12:00:00 AM | 3x3 | Permit Number 38200 | 6008233.26269903 | 2119182.7725058 | 37.7993365057546 | -122.415613869084 | (37.7993365057546, -122.415613869084) | |
| 146328 | 146328 | 36834 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2715 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39537 | 6015005.69395491 | 2090908.83002417 | 37.7220807273762 | -122.390202307194 | (37.7220807273762, -122.390202307194) | ||
| 148918 | 148918 | 62209 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 227 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/12/1985 12:00:00 AM | 16 | Permit Number 22331 | 5988338.57879 | 2114482.10714 | 37.7852914335725 | -122.48411069019699 | (37.7852914335725, -122.484110690197) | |
| 183147 | 183147 | 66382 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 661 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1991 12:00:00 AM | 12 | Permit Number 29508 | 6003420.5252 | 2110677.1492 | 37.7757105120941 | -122.431660023451 | (37.7757105120941, -122.431660023451) |
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");