Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, qSiteInfo, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 30852 | 30852 | 240192 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 15 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004287.41019 | 2098213.31975 | 37.7415368893219 | -122.42777298295401 | (37.7415368893219, -122.427772982954) | |||
| 35804 | 35804 | 239300 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 927 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6009964.45155 | 2103786.9298 | 37.757160299531996 | -122.408536698407 | (37.757160299532, -122.408536698407) | |||
| 53135 | 53135 | 197099 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 361 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6014371.32039 | 2105439.78975 | 37.7619445120636 | -122.39341159536801 | (37.7619445120636, -122.393411595368) | |||
| 69560 | 69560 | 239354 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 187 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6004748.91753 | 2098687.71701 | 37.742865571999104 | -122.42621101343201 | (37.7428655719991, -122.426211013432) | |||
| 69666 | 69666 | 240194 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 48 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004261.63308 | 2097975.00788 | 37.7408810812017 | -122.42784513465901 | (37.7408810812017, -122.427845134659) | |||
| 70530 | 70530 | 73459 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 330 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 15 | 6010582.5171300005 | 2106716.25151 | 37.765238152235206 | -122.40660560128299 | (37.7652381522352, -122.406605601283) | ||
| 130140 | 130140 | 239310 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 460 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6005491.5697099995 | 2101034.9456700003 | 37.7493524745442 | -122.42380999086001 | (37.7493524745442, -122.42380999086) | |||
| 148823 | 148823 | 99598 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3001 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Permit Number 17057 | 6002874.08515 | 2118929.42484 | 37.7983381750246 | -122.434140356598 | (37.7983381750246, -122.434140356598) | |||
| 151351 | 151351 | 213953 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5994770.431919999 | 2090973.1015700002 | 37.7211140599462 | -122.460154799032 | (37.7211140599462, -122.460154799032) | |||
| 159725 | 159725 | 213957 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5994771.7805 | 2091087.8520099998 | 37.7214292147603 | -122.460158446674 | (37.7214292147603, -122.460158446674) | |||
| 163677 | 163677 | 239332 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3284 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6009010.21186 | 2099567.25485 | 37.7455205280624 | -122.411538719955 | (37.7455205280624, -122.411538719955) | |||
| 165260 | 165260 | 54444 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 626 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/1972 12:00:00 AM | 15 | Permit Number 10222 | 6014089.82372 | 2104201.41345 | 37.7585285559536 | -122.394298481614 | (37.7585285559536, -122.394298481614) | ||
| 166384 | 166384 | 239241 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1301 Potrero Ave | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6010653.63145 | 2101615.38344 | 37.7512362871225 | -122.406000261299 | (37.7512362871225, -122.406000261299) | |||
| 177196 | 177196 | 213954 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5994772.0848 | 2091005.96515 | 37.721204390545104 | -122.460151465241 | (37.7212043905451, -122.460151465241) | |||
| 177889 | 177889 | 239322 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1682 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6009287.32125 | 2099523.77754 | 37.7454166887246 | -122.410577445415 | (37.7454166887246, -122.410577445415) | |||
| 186231 | 186231 | 239333 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3258 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6009001.08587 | 2099726.03471 | 37.7459559905813 | -122.411581492612 | (37.7459559905813, -122.411581492612) | |||
| 188403 | 188403 | 239243 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1301 Potrero Ave | 4 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6010651.8200900005 | 2101663.18223 | 37.751367430767395 | -122.40600989216101 | (37.7513674307674, -122.406009892161) |
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");