Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantDate, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3267 | 3267 | 2831 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1200 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 3X3 | 6008484.02773 | 2116302.9533599997 | 37.791443325609606 | -122.414542237062 | (37.7914433256096, -122.414542237062) | |||
| 5097 | 5097 | 253793 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1698X 08th Ave | 3 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 5993765.0 | 2103990.0 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | ||||
| 11201 | 11201 | 19747 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 100 STAIRWAY15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 10ST | ||||||||
| 15820 | 15820 | 19764 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 100 STAIRWAY16 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 30ST | ||||||||
| 17849 | 17849 | 26939 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1000 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3 | 6005048.52765 | 2102486.42553 | 37.7533128811044 | -122.42544532345501 | (37.7533128811044, -122.425445323455) | |||
| 20254 | 20254 | 23999 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 300 West Portal Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 5992235.8832 | 2097133.9008 | 37.7378839736291 | -122.469364124733 | (37.7378839736291, -122.469364124733) | |||
| 20399 | 20399 | 8212 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2189X Funston Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8X25 | 5992284.57704 | 2100523.9125099997 | 37.7471948966366 | -122.46944246202 | (37.7471948966366, -122.46944246202) | |||
| 22671 | 22671 | 18156 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1355 Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005730.74632 | 2114465.38856 | 37.786242766547105 | -122.42393782586399 | (37.7862427665471, -122.423937825864) | |||
| 23165 | 23165 | 25259 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1630 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 5994884.3509 | 2092299.7091 | 37.724763157858796 | -122.45985706395399 | (37.7247631578588, -122.459857063954) | |||
| 92309 | 92309 | 5042 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 5399X Diamond Heights Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002053.1297196 | 2098277.9970185 | 37.741587834770705 | -122.435502976689 | (37.7415878347707, -122.435502976689) | |||
| 93132 | 93132 | 13300 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 168 LUNADO CT | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/26/2016 12:00:00 AM | 3 | 15 | 5991818.0 | 2092671.0 | 37.7256058079955 | -122.47048399681299 | (37.7256058079955, -122.470483996813) | ||
| 93600 | 93600 | 11449 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2X Arguello Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3 | 5995514.85453 | 2115936.98374 | 37.789701328403794 | -122.459388527967 | (37.7897013284038, -122.459388527967) | |||
| 94921 | 94921 | 90651 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3350 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5985244.351217 | 2110444.86641 | 37.77402569788379 | -122.494517894729 | (37.7740256978838, -122.494517894729) | |
| 111630 | 111630 | 90646 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3300X Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5985392.933158999 | 2110450.258895 | 37.774049198972605 | -122.49400432939699 | (37.7740491989726, -122.494004329397) | |
| 120273 | 120273 | 113891 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x STORRIE ST | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 12 | 6000722.0 | 2105303.0 | 37.76080110933629 | -122.440609317727 | (37.7608011093363, -122.440609317727) | ||||
| 127676 | 127676 | 4967 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 5200X Diamond Heights Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6000724.3855206 | 2099633.2111664 | 37.7452333754909 | -122.440194472866 | (37.7452333754909, -122.440194472866) | |||
| 141454 | 141454 | 90654 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3400 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5985083.076571 | 2110439.01327 | 37.7740001866718 | -122.495075331328 | (37.7740001866718, -122.495075331328) | |
| 151195 | 151195 | 247574 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 350x Alemany Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6008213.28818 | 2095041.8138700002 | 37.7330499269008 | -122.413974287302 | (37.7330499269008, -122.413974287302) |
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");