Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19843 | 19843 | 99594 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1855X Evans Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6014349.8 | 2099426.2 | 37.7454312840379 | -122.393065244865 | (37.7454312840379, -122.393065244865) | |||
| 20843 | 20843 | 111792 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 55X SHERMAN ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6010857.0 | 2110997.0 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | ||||
| 65719 | 65719 | 99967 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2270 Folsom St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007986.9 | 2105322.2 | 37.761264849910205 | -122.415484545241 | (37.7612648499102, -122.415484545241) | |||||
| 78377 | 78377 | 48697 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 405 Howard St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | |||
| 84958 | 84958 | 50566 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2295 Folsom St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/2003 12:00:00 AM | Permit Number 47188 | 6008194.0 | 2105070.0 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | |||
| 85081 | 85081 | 101766 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 45X 11th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6007389.6 | 2110351.2 | 37.7750397101602 | -122.41790686002899 | (37.7750397101602, -122.417906860029) | |||
| 87271 | 87271 | 26950 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2040 Sutter St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | 3X3 | 6002695.468169999 | 2114444.00008 | 37.78601221318821 | -122.43443755618799 | (37.7860122131882, -122.434437556188) | |||
| 90905 | 90905 | 120135 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 10X Grove St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007842.0 | 2111812.0 | 37.779076168386105 | -122.41644540073798 | (37.7790761683861, -122.416445400738) | ||||
| 94306 | 94306 | 41194 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 500 16th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.38916212984199 | (37.7669713213554, -122.389162129842) | ||
| 94908 | 94908 | 95038 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3224 Pierce St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 3x3 | 6001388.0 | 2119447.0 | 37.79967484547421 | -122.43931976889999 | (37.7996748454742, -122.4393197689) | ||||
| 102700 | 102700 | 111598 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 398X BRYANT ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014483.0 | 2113360.0 | 37.7836978486164 | -122.393579678281 | (37.7836978486164, -122.393579678281) | ||||
| 103361 | 103361 | 111226 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3150x 19TH ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6008324.0 | 2105048.0 | 37.7605309015758 | -122.41429925401 | (37.7605309015758, -122.41429925401) | |||
| 107518 | 107518 | 120152 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1X Hyde St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008026.0 | 2111839.0 | 37.77916064960021 | -122.41581078056299 | (37.7791606496002, -122.415810780563) | ||||
| 107657 | 107657 | 16856 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 150 Oak St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6006257.87931 | 2110498.54999 | 37.7753805408795 | -122.421832203671 | (37.7753805408795, -122.421832203671) | |||
| 108134 | 108134 | 6817 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1400X Fairfax Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3X3 | 6016560.821272099 | 2097522.8211505003 | 37.740327568702895 | -122.385287208511 | (37.7403275687029, -122.385287208511) | |||
| 110957 | 110957 | 45390 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1501-1555 Mariposa St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2001 12:00:00 AM | Permit Number 44202 | 6012875.34483574 | 2106095.24513094 | 37.763661017326605 | -122.39863162145599 | (37.7636610173266, -122.398631621456) | |||
| 113607 | 113607 | 49297 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2X Spear St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371.0 | 2116872.0 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | |||
| 121138 | 121138 | 103636 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1450X Stevenson St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 777592 | 6006328.29748 | 2108087.53462 | 37.768764440650294 | -122.42141735000799 | (37.7687644406503, -122.421417350008) | ||
| 125338 | 125338 | 15155 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 895X Mission St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 18 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | |||
| 125433 | 125433 | 112411 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 300x 15TH ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011264.0 | 2107649.0 | 37.7678373720049 | -122.404314158491 | (37.7678373720049, -122.404314158491) | ||||
| 140079 | 140079 | 113008 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 700x STANYAN ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997124.0 | 2108268.0 | 37.768736698354004 | -122.453267191941 | (37.768736698354, -122.453267191941) | ||||
| 140262 | 140262 | 17045 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1200X Oak St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6001235.1914802 | 2109729.1714048 | 37.772983491104604 | -122.439151661694 | (37.7729834911046, -122.439151661694) | |||
| 143522 | 143522 | 7892 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1187 Franklin St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6006000.38049 | 2113895.86172 | 37.7846942050769 | -122.422964467171 | (37.7846942050769, -122.422964467171) | |||
| 143989 | 143989 | 110990 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/2015 12:00:00 AM | 3 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||
| 144303 | 144303 | 89021 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1500 Mission St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51766 | 6007445.1 | 2110006.7 | 37.7740969185595 | -122.417690449841 | (37.7740969185595, -122.417690449841) | |||
| 144621 | 144621 | 40355 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 379 TEHAMA ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/1999 12:00:00 AM | 8 | Permit Number 41479 | 6011447.0 | 2112547.0 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) |
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");