Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23101 | 23101 | 4130 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3550 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/27/1995 12:00:00 AM | 4 | 3x3 | 6006437.45796 | 2100604.55432 | 37.748224069995295 | -122.42050853554501 | (37.7482240699953, -122.420508535545) | ||
| 37799 | 37799 | 183676 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3710 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5984252.2399 | 2106352.1361 | 37.7627301098016 | -122.497647481121 | (37.7627301098016, -122.497647481121) | |||
| 39608 | 39608 | 119979 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 286 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5987467.13814 | 2114050.95667 | 37.7840568428401 | -122.487093893766 | (37.7840568428401, -122.487093893766) | |||
| 41700 | 41700 | 87109 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1358 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50058 | 5985264.3746 | 2105978.0640000002 | 37.761762290042704 | -122.49411934585301 | (37.7617622900427, -122.494119345853) | |
| 43517 | 43517 | 208531 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 136 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5993591.87174 | 2090510.0333599998 | 37.7197747266151 | -122.464195105813 | (37.7197747266151, -122.464195105813) | |||
| 61771 | 61771 | 201441 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 50 Middle Point Rd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 5ft | 6018208.2556 | 2096140.7000900002 | 37.7366235404482 | -122.37949498601601 | (37.7366235404482, -122.379494986016) | |||
| 64712 | 64712 | 69313 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1599 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1994 12:00:00 AM | 4 | Permit Number 33392 | 5986810.4893 | 2104771.5308 | 37.758539831018 | -122.488683338527 | (37.758539831018, -122.488683338527) | |
| 66245 | 66245 | 30695 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 15 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/2001 12:00:00 AM | 4 | Permit Number 34611 | 6005182.95707 | 2108838.8706099996 | 37.7707627855907 | -122.425432476641 | (37.7707627855907, -122.425432476641) | |
| 147495 | 147495 | 231151 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3101 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009109.901219999 | 2100538.836 | 37.7481938662608 | -122.411262629885 | (37.7481938662608, -122.411262629885) | |||
| 148373 | 148373 | 52563 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1275 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2006 12:00:00 AM | 4 | Permit Number 48660 | 5983651.2644 | 2106493.3098 | 37.7630824862581 | -122.49973644381399 | (37.7630824862581, -122.499736443814) | |
| 149559 | 149559 | 229189 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3281 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007838.5569 | 2100529.3417599997 | 37.748096413035796 | -122.415658239036 | (37.7480964130358, -122.415658239036) | |||
| 151833 | 151833 | 229188 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3287 Cesar Chavez St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 5ft | 6007796.6026099995 | 2100528.4399 | 37.748091578262795 | -122.415803252021 | (37.7480915782628, -122.415803252021) | |||
| 154617 | 154617 | 231171 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2950 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009778.821959999 | 2100624.5586900003 | 37.7484667349686 | -122.408955560378 | (37.7484667349686, -122.408955560378) | |||
| 166950 | 166950 | 229198 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3351 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006464.802019999 | 2102585.11894 | 37.7536637884725 | -122.420554550246 | (37.7536637884725, -122.420554550246) | |||
| 180205 | 180205 | 42599 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2222 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 4 | Permit Number 42669 | 6003877.92614 | 2116329.40578 | 37.7912561101206 | -122.43048114921301 | (37.7912561101206, -122.430481149213) | |
| 181395 | 181395 | 246447 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 449 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6003605.22415 | 2099791.4643200003 | 37.74583149562061 | -122.43024431183399 | (37.7458314956206, -122.430244311834) |
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");