Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, PlantDate, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26926 | 26926 | 190879 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 200 Berry St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6013947.21695 | 2109982.7867400004 | 37.7743950025592 | -122.395196653408 | (37.7743950025592, -122.395196653408) | |||
| 28830 | 28830 | 191188 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 401 Berry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6012921.49842 | 2108941.08068 | 37.771477617131 | -122.398671712036 | (37.771477617131, -122.398671712036) | |||
| 29519 | 29519 | 191195 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 401 Berry St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6013075.662380001 | 2109083.51263 | 37.7718772911475 | -122.39814844152001 | (37.7718772911475, -122.39814844152) | |||
| 37435 | 37435 | 190880 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 200 Berry St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6013928.84356 | 2109965.19356 | 37.7743456738347 | -122.395258978227 | (37.7743456738347, -122.395258978227) | |||
| 41881 | 41881 | 51123 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | 10 | Permit Number 47557 | 6012907.31344 | 2108994.69031 | 37.7716240267703 | -122.39872454180401 | (37.7716240267703, -122.398724541804) | ||
| 53437 | 53437 | 191186 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 455 Berry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6012843.925419999 | 2108867.55559 | 37.7712714115714 | -122.39893488155899 | (37.7712714115714, -122.398934881559) | |||
| 118386 | 118386 | 191172 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 330 Berry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6013502.580709999 | 2109556.6030200003 | 37.7732000607555 | -122.396704861437 | (37.7732000607555, -122.396704861437) | |||
| 129871 | 129871 | 191180 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 362 Berry St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6013011.10848 | 2109086.96064 | 37.7718831628012 | -122.39837198149598 | (37.7718831628012, -122.398371981496) | |||
| 133682 | 133682 | 51482 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 235 Berry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Permit Number 47794 | 6014137.24495 | 2110108.95335 | 37.77475199384529 | -122.39454814238199 | (37.7747519938453, -122.394548142382) | |||
| 154201 | 154201 | 191191 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 401 Berry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6012989.140869999 | 2109006.19311 | 37.7716601696237 | -122.39844230127 | (37.7716601696237, -122.39844230127) | |||
| 160449 | 160449 | 85227 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 355 Berry St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 10 | Permit Number 49539 | 6013279.22191 | 2109288.33477 | 37.7724510226373 | -122.39745867679702 | (37.7724510226373, -122.397458676797) | ||
| 168732 | 168732 | 51127 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | 10 | Permit Number 47557 | 6012791.79876 | 2108883.8380400003 | 37.77131321475821 | -122.39911633417 | (37.7713132147582, -122.39911633417) | ||
| 169523 | 169523 | 227027 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1301 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6011166.45785 | 2102232.02401 | 37.752958115644105 | -122.404270238186 | (37.7529581156441, -122.404270238186) | |||
| 177049 | 177049 | 191169 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 330 Berry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6013574.9944 | 2109626.21147 | 37.773395219943 | -122.39645925121599 | (37.773395219943, -122.396459251216) | |||
| 177344 | 177344 | 191164 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 300 Berry St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6013682.57668 | 2109729.99621 | 37.7736861758168 | -122.396094380961 | (37.7736861758168, -122.396094380961) | |||
| 187963 | 187963 | 190882 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 200 Berry St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6013891.89628 | 2109930.79083 | 37.774249156806 | -122.395384376097 | (37.774249156806, -122.395384376097) |
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");