Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21690 | 21690 | 4077 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3200X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6008348.6867 | 2100615.53254 | 37.7483617364081 | -122.413900318962 | (37.7483617364081, -122.413900318962) | |||
| 24733 | 24733 | 50832 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 886 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2004 12:00:00 AM | 6 | Permit Number 47351 | 6012122.31213 | 2104263.6699599996 | 37.7585899355868 | -122.401107436752 | (37.7585899355868, -122.401107436752) | ||
| 46119 | 46119 | 231159 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 35 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005878.30776 | 2097748.88767 | 37.7403515297919 | -122.422239205296 | (37.7403515297919, -122.422239205296) | |||
| 56449 | 56449 | 52564 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1275 40th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2006 12:00:00 AM | 6 | Permit Number 48660 | 5983650.9916 | 2106470.941 | 37.763021051858104 | -122.499735733929 | (37.7630210518581, -122.499735733929) | |
| 57809 | 57809 | 45092 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1895X 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 6 | Permit Number 43969 | 5988136.1945 | 2102427.0445 | 37.7521797768379 | -122.48392659715401 | (37.7521797768379, -122.483926597154) | |
| 58115 | 58115 | 208524 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1645 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5990570.23623 | 2106516.77895 | 37.76355050069 | -122.47580802711201 | (37.76355050069, -122.475808027112) | |||
| 65083 | 65083 | 45627 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2525 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/01/2001 12:00:00 AM | 6 | Permit Number 44337 | 5986426.1598 | 2103650.8116 | 37.7554402080729 | -122.48993007778601 | (37.7554402080729, -122.489930077786) | |
| 70942 | 70942 | 101160 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 375 Connecticut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6x5 | 6013245.35442 | 2105273.6114 | 37.7614255996257 | -122.39729424385901 | (37.7614255996257, -122.397294243859) | |||
| 77018 | 77018 | 47438 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 754 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 6 | Permit Number 45349 | 5982933.06329 | 2110647.13754 | 37.7744455330351 | -122.502527876502 | (37.7744455330351, -122.502527876502) | |
| 88090 | 88090 | 4078 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3200X Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6008412.1891644 | 2100602.6212259 | 37.7483298510109 | -122.413679815119 | (37.7483298510109, -122.413679815119) | |||
| 163563 | 163563 | 182459 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1599 30th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5986820.9264 | 2104460.1554 | 37.7576854884853 | -122.488624356735 | (37.7576854884853, -122.488624356735) | |||
| 164886 | 164886 | 115968 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1599x 30th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | 3x3 | 5986813.3885 | 2104648.6042 | 37.7582024774349 | -122.48866427663799 | (37.7582024774349, -122.488664276638) | |||
| 168918 | 168918 | 208527 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1780 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5993763.18798 | 2103365.50006 | 37.7550825094637 | -122.46453587693001 | (37.7550825094637, -122.46453587693) | |||
| 171817 | 171817 | 231167 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 355 Masonic Ave | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 3ft | 6000251.62356 | 2106898.61611 | 37.765155479357205 | -122.44235068844601 | (37.7651554793572, -122.442350688446) | |||
| 172761 | 172761 | 208536 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2471 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5991693.08423 | 2098625.72908 | 37.741948771623605 | -122.471349495085 | (37.7419487716236, -122.471349495085) | |||
| 175040 | 175040 | 231142 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1632 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009692.5788199995 | 2100157.74499 | 37.7471801360609 | -122.40922085227601 | (37.7471801360609, -122.409220852276) | |||
| 175061 | 175061 | 115966 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1599x 30th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | 3x3 | 5986811.649 | 2104717.0256 | 37.7583902423484 | -122.488675321582 | (37.7583902423484, -122.488675321582) | |||
| 179735 | 179735 | 250198 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 201 Union St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 0ft | 6011825.11075 | 2119776.45008 | 37.8011678477679 | -122.40322653269199 | (37.8011678477679, -122.403226532692) |
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");