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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 209 | 209 | 134568 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Grove St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 12/17/2009 12:00:00 AM | 5 | Width 4ft | 6007669.37768 | 2111613.23365 | 37.778520694605795 | -122.41702848568501 | (37.7785206946058, -122.417028485685) | ||
| 45278 | 45278 | 50677 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 320 Clementina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2009 12:00:00 AM | 6 | 3x3 | Permit Number 53102 | 6011972.4253 | 2112821.65689 | 37.782079864123205 | -122.40222750461001 | (37.7820798641232, -122.40222750461) | |
| 55303 | 55303 | 50676 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 320 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2009 12:00:00 AM | 2 | 3x3 | Permit Number 53102 | 6011983.41914 | 2112836.30852 | 37.7821207077455 | -122.402190501114 | (37.7821207077455, -122.402190501114) | |
| 88429 | 88429 | 49697 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 363@ 15th ST Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2009 12:00:00 AM | 3x3 | 6006144.22117649 | 2107501.72994467 | 37.767145579966 | -122.422012436947 | (37.767145579966, -122.422012436947) | |||
| 110793 | 110793 | 32069 | Permitted Site 1 | Tree(s) :: 17 | 3680 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2009 12:00:00 AM | 3x3 | Permit Number 53101 | 6004358.393579 | 2106024.19392568 | 37.7629877393508 | -122.42808404338001 | (37.7629877393508, -122.42808404338) | ||
| 113688 | 113688 | 9953 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 95X Grove St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 12/17/2009 12:00:00 AM | 12 | 3X3 | 6007383.306516 | 2111592.002729 | 37.778446303098505 | -122.418016611499 | (37.7784463030985, -122.418016611499) | ||
| 129080 | 129080 | 50762 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 1247 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2009 12:00:00 AM | Permit Number 53107 | 6009900.23371634 | 2109608.97618966 | 37.7731427119765 | -122.409169607112 | (37.7731427119765, -122.409169607112) | |||
| 139319 | 139319 | 64097 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 1275 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2009 12:00:00 AM | 4x4 | Permit Number 53106 | 5992357.42606092 | 2106782.26411484 | 37.764382907691704 | -122.46964608804501 | (37.7643829076917, -122.469646088045) | ||
| 150953 | 150953 | 50678 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 320 Clementina St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2009 12:00:00 AM | 3 | 3x3 | Permit Number 53102 | 6011917.0823 | 2112771.09085 | 37.7819379322194 | -122.402415410739 | (37.7819379322194, -122.402415410739) | |
| 170698 | 170698 | 50331 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 Howard St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2009 12:00:00 AM | 6 | Permit Number 53108 | 6011486.904569999 | 2112973.18308 | 37.7824688065362 | -122.40391786131399 | (37.7824688065362, -122.403917861314) |
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");