Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6792 | 6792 | 23871 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1499X Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003600.3539 | 2113692.9201 | 37.784001259600295 | -122.43125326646499 | (37.7840012596003, -122.431253266465) | |||
| 6874 | 6874 | 13090 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 724 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/2004 12:00:00 AM | 12 | 3X3 | 6008885.9219 | 2120447.4555 | 37.8028456756355 | -122.413444921903 | (37.8028456756355, -122.413444921903) | ||
| 8518 | 8518 | 18226 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1675 Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004172.0667 | 2114245.454 | 37.785550761919 | -122.42931476245899 | (37.785550761919, -122.429314762459) | |||
| 18986 | 18986 | 10211 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1311 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/15/1991 12:00:00 AM | 12 | 2X2 | 6005852.922730001 | 2101311.29856 | 37.7501316687427 | -122.422580057332 | (37.7501316687427, -122.422580057332) | ||
| 73827 | 73827 | 142480 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1656 POWELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6009655.9931 | 2119387.8477 | 37.799979462358706 | -122.410705194848 | (37.7999794623587, -122.410705194848) | |||
| 76233 | 76233 | 108192 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 603 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6007188.43841 | 2091737.3666 | 37.7239190175192 | -122.417283387741 | (37.7239190175192, -122.417283387741) | |||
| 89705 | 89705 | 109182 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 634 HURON AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5998040.0 | 2087925.4 | 37.7129332935716 | -122.448633512376 | (37.7129332935716, -122.448633512376) | |||
| 121025 | 121025 | 111845 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1550 York St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 3x3 | 6010144.81466304 | 2100398.61683821 | 37.7478668430794 | -122.407674029985 | (37.7478668430794, -122.407674029985) | ||
| 137794 | 137794 | 142584 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2232 Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6008967.5673 | 2120856.1596 | 37.803972458794796 | -122.41319130359699 | (37.8039724587948, -122.413191303597) | |||
| 141416 | 141416 | 11200 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 186 Idora Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 5995344.6608195 | 2099448.7962231003 | 37.74441926622529 | -122.45878317784799 | (37.7444192662253, -122.458783177848) | |||
| 150022 | 150022 | 238032 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 3851 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6002743.63234 | 2103545.30285 | 37.7560898095039 | -122.43349178442499 | (37.7560898095039, -122.433491784425) | |||
| 151841 | 151841 | 237989 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 114 Park St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6005562.12851 | 2096385.4572 | 37.7365900164084 | -122.423235535394 | (37.7365900164084, -122.423235535394) | |||
| 182223 | 182223 | 214385 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1955 10th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 5993134.95065 | 2102190.16883 | 37.7518191170825 | -122.46662305770501 | (37.7518191170825, -122.466623057705) | |||
| 182343 | 182343 | 178937 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 250 Athens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6004445.3973900005 | 2091822.37508 | 37.723997724407795 | -122.426771694853 | (37.7239977244078, -122.426771694853) | ||||
| 114472 | 114472 | 65384 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 49 Wilder St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1989 12:00:00 AM | 12 | Permit Number 28223 | 6002684.49028093 | 2095505.99557199 | 37.734012395369 | -122.433121936639 | (37.734012395369, -122.433121936639) | |
| 99821 | 99821 | 34369 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 71 Harper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | 12 | 12x4. 5 | Permit Number 38124 | 6003708.03789498 | 2097975.15575924 | 37.740850154442896 | -122.42975927113899 | (37.7408501544429, -122.429759271139) |
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");