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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29378 | 29378 | 95906 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1323 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767607 | 5987385.7768 | 2106255.5896 | 37.7626482044987 | -122.486802739667 | (37.7626482044987, -122.486802739667) |
| 72290 | 72290 | 82688 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1875 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51093 | 5984404.185 | 2102433.03 | 37.7519782422196 | -122.496832705614 | (37.7519782422196, -122.496832705614) | |
| 151022 | 151022 | 95110 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 649 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 2 | 3x3 | Permit Number 54039 | 6001693.52474 | 2093271.82828 | 37.7278216210543 | -122.436388158988 | (37.7278216210543, -122.436388158988) |
| 163888 | 163888 | 38590 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1614 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 2 | Permit Number 40545 | 6015168.4288 | 2094722.1342 | 37.732560324707705 | -122.38990600380698 | (37.7325603247077, -122.389906003807) | |
| 173694 | 173694 | 95910 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1863 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767611 | 5986268.2408 | 2102571.6706 | 37.75246795898221 | -122.49039681822201 | (37.7524679589822, -122.490396818222) |
| 176558 | 176558 | 38592 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1618 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 2 | Permit Number 40547 | 6015152.7308 | 2094735.8699 | 37.7325971695789 | -122.389961235194 | (37.7325971695789, -122.389961235194) | |
| 180708 | 180708 | 65972 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2090 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/1991 12:00:00 AM | 2 | Permit Number 28996 | 5989155.2561 | 2101119.0911 | 37.74864775647529 | -122.480306841406 | (37.7486477564753, -122.480306841406) | |
| 186544 | 186544 | 63000 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1251 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1986 12:00:00 AM | 2 | Permit Number 23408 | 5983028.2339 | 2106580.2336 | 37.763284575331795 | -122.50189769196899 | (37.7632845753318, -122.501897691969) |
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");