Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 83307 | 83307 | 24349 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 85 Duboce Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/24/2003 12:00:00 AM | 3 | 2x2 | 6006210.36104 | 2108383.4741700003 | 37.769570370002604 | -122.421846308181 | (37.7695703700026, -122.421846308181) | ||
| 120532 | 120532 | 103325 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 200 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6001895.0 | 2108750.0 | 37.7703324520775 | -122.436799199856 | (37.7703324520775, -122.436799199856) | ||||
| 100542 | 100542 | 103326 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 224 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6001907.0 | 2108933.4 | 37.7708367050105 | -122.43677082248301 | (37.7708367050105, -122.436770822483) | ||||
| 18809 | 18809 | 5147 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 228 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2016 12:00:00 AM | 3 | 3x3 | 6001883.9625 | 2108955.9605 | 37.7708973412472 | -122.436852124872 | (37.7708973412472, -122.436852124872) | ||
| 139919 | 139919 | 103333 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 243 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6001783.9 | 2108958.2 | 37.7708978028329 | -122.43719840332399 | (37.7708978028329, -122.437198403324) | ||||
| 23233 | 23233 | 5150 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 243 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2016 12:00:00 AM | 2 | 3x3 | 6001815.3824 | 2108971.2006 | 37.7709352888143 | -122.437090436044 | (37.7709352888143, -122.437090436044) | ||
| 143218 | 143218 | 103327 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 234 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6001874.0 | 2108997.0 | 37.771009459311706 | -122.43688952378 | (37.7710094593117, -122.43688952378) | ||||
| 102585 | 102585 | 103332 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 245 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6001802.8 | 2109052.7 | 37.7711583507176 | -122.43713979494301 | (37.7711583507176, -122.437139794943) | ||||
| 81486 | 81486 | 103328 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 242 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3x3 | 6001866.0 | 2109053.0 | 37.7711627667236 | -122.436921205648 | (37.7711627667236, -122.436921205648) | |||
| 82169 | 82169 | 103330 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 1600X McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6001400.4 | 2111522.1 | 37.7779158216762 | -122.438708684362 | (37.7779158216762, -122.438708684362) | ||||
| 141020 | 141020 | 103331 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 1600X McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6001400.4 | 2111522.1 | 37.7779158216762 | -122.438708684362 | (37.7779158216762, -122.438708684362) |
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");