Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 596 | 596 | 240413 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 3420 Market St | 2 | : 4 | Tree 1 | DPW 2 | 04/19/1996 12:00:00 AM | 8 | Width 3ft | 6000107.95046 | 2103900.11575 | 37.756914147893795 | -122.442632304847 | (37.7569141478938, -122.442632304847) | ||
| 31206 | 31206 | 246759 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 70 Waltham St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6009196.74806 | 2098886.80636 | 37.7436626276403 | -122.410845655606 | (37.7436626276403, -122.410845655606) | ||||
| 40291 | 40291 | 240392 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1803 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008038.16649 | 2107910.1392200002 | 37.768373611578205 | -122.415490461517 | (37.7683736115782, -122.415490461517) | |||
| 45898 | 45898 | 78303 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 4200 Anza St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 8 | 5985601.84615 | 2111830.0583200003 | 37.7778499560934 | -122.493383352985 | (37.7778499560934, -122.493383352985) | ||
| 54599 | 54599 | 240401 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 499 Hoffman Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000694.66286 | 2101176.32982 | 37.749468718214004 | -122.440407898332 | (37.749468718214, -122.440407898332) | |||
| 57928 | 57928 | 54837 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 131 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1995 12:00:00 AM | 8 | Permit Number 10691 | 5998715.81827648 | 2110282.46474316 | 37.77435901320929 | -122.447906287477 | (37.7743590132093, -122.447906287477) | |
| 59699 | 59699 | 197345 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1277 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008901.33871 | 2110395.02653 | 37.7752450102959 | -122.41268050642599 | (37.7752450102959, -122.412680506426) | |||
| 60527 | 60527 | 32523 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 861 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | 8 | Permit Number 37025 | 6007568.6691 | 2095324.89508 | 37.7337909808565 | -122.416222953925 | (37.7337909808565, -122.416222953925) | |
| 75966 | 75966 | 197346 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1245 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008998.58265 | 2110487.32292 | 37.7755038918289 | -122.412350641372 | (37.7755038918289, -122.412350641372) | |||
| 101774 | 101774 | 8103 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 775 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/1998 12:00:00 AM | 8 | 3X3 | 6004110.63243 | 2111457.69852 | 37.7778928009026 | -122.42932844351601 | (37.7778928009026, -122.429328443516) | ||
| 135936 | 135936 | 214037 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 510 Ramsell St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5993017.248790001 | 2090566.81293 | 37.719897493047704 | -122.466185481793 | (37.7198974930477, -122.466185481793) | |||
| 151712 | 151712 | 248239 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 298 Esmeralda Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6006759.33465 | 2099019.31967 | 37.7438895076886 | -122.419283056374 | (37.7438895076886, -122.419283056374) | ||||
| 156395 | 156395 | 136314 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 107 Bernard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6008318.73536 | 2118064.92593 | 37.796271980829 | -122.415238929252 | (37.796271980829, -122.415238929252) | |||
| 159513 | 159513 | 214043 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 212 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5998768.52981 | 2093586.90837 | 37.7285201208974 | -122.446522546303 | (37.7285201208974, -122.446522546303) | |||
| 162768 | 162768 | 42678 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1097 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 8 | Permit Number 42702 | 6007821.24509 | 2118860.5405 | 37.7984285685682 | -122.417016754032 | (37.7984285685682, -122.417016754032) | |
| 167372 | 167372 | 40008 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 950 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 8 | Permit Number 41261 | 6018990.20826 | 2094681.6711099998 | 37.7326604269313 | -122.376690235261 | (37.7326604269313, -122.376690235261) | |
| 173397 | 173397 | 179371 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 479 Goettingen St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010448.30169 | 2092366.9553099999 | 37.7258306011814 | -122.40605884135401 | (37.7258306011814, -122.406058841354) | |||
| 175872 | 175872 | 78389 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 4200 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 8 | 5985613.90998 | 2111830.68363 | 37.77785237866 | -122.49334166667101 | (37.77785237866, -122.493341666671) | ||
| 178929 | 178929 | 247983 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 497 Peralta Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6009757.51939 | 2099637.18115 | 37.74575442014729 | -122.408959568646 | (37.7457544201473, -122.408959568646) | ||||
| 179090 | 179090 | 240400 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 499 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000695.68287 | 2101155.78818 | 37.74941237387971 | -122.440402898093 | (37.7494123738797, -122.440402898093) |
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");