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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1585 | 1585 | 23896 | DPW Maintained 3 | Shrub :: Shrub 98 | 1581 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/24/2017 12:00:00 AM | 3 | 3x3 | 6003535.353102201 | 2114132.0136397 | 37.7852032161945 | -122.43150950273301 | (37.7852032161945, -122.431509502733) | ||
| 1666 | 1666 | 251642 | Undocumented 2 | Shrub :: Shrub 98 | 2253 Broderick St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 3x3 | 6000298.51737 | 2116393.24113 | 37.7912279703404 | -122.442870356286 | (37.7912279703404, -122.442870356286) | ||||
| 18786 | 18786 | 97930 | Undocumented 2 | Shrub :: Shrub 98 | 1615 Grant Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010461.1 | 2120070.1 | 37.801897866839 | -122.40796734514 | (37.801897866839, -122.40796734514) | ||||
| 19473 | 19473 | 61098 | Permitted Site 1 | Shrub :: Shrub 98 | 806 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/24/1988 12:00:00 AM | 3x3 | Permit Number 25594 | 6007925.06671696 | 2103219.75918175 | 37.7554885536992 | -122.41554954379299 | (37.7554885536992, -122.415549543793) | |
| 79258 | 79258 | 114185 | Undocumented 2 | Shrub :: Shrub 98 | 2200 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997096.0 | 2109871.0 | 37.7731365175856 | -122.45347979574801 | (37.7731365175856, -122.453479795748) | ||||
| 82971 | 82971 | 102755 | Undocumented 2 | Shrub :: Shrub 98 | 61 Jordan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | 3x3 | 5996159.1 | 2114114.4 | 37.7847340229516 | -122.457027629275 | (37.7847340229516, -122.457027629275) | |||
| 87585 | 87585 | 121391 | Undocumented 2 | Shrub :: Shrub 98 | 1301x 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993851.0 | 2106604.0 | 37.763979651815205 | -122.464467327674 | (37.7639796518152, -122.464467327674) | ||||
| 88223 | 88223 | 94197 | Permitted Site 1 | Shrub :: Shrub 98 | 355 Ocean Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2010 12:00:00 AM | 3x3 | Permit Number 53723 | 5999419.6 | 2091436.9 | 37.7226538624451 | -122.444117342662 | (37.7226538624451, -122.444117342662) | ||
| 92104 | 92104 | 121390 | Undocumented 2 | Shrub :: Shrub 98 | 1301x 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993851.0 | 2106604.0 | 37.763979651815205 | -122.464467327674 | (37.7639796518152, -122.464467327674) | ||||
| 101049 | 101049 | 94198 | Permitted Site 1 | Shrub :: Shrub 98 | 355 Ocean Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2010 12:00:00 AM | 3x3 | Permit Number 53723 | 5999419.6 | 2091436.9 | 37.7226538624451 | -122.444117342662 | (37.7226538624451, -122.444117342662) | ||
| 111245 | 111245 | 99672 | DPW Maintained 3 | Shrub :: Shrub 98 | 1250X Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 5997882.0 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | ||
| 114697 | 114697 | 104783 | Undocumented 2 | Shrub :: Shrub 98 | 50 Walnut St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998501.2 | 2116298.0 | 37.790863832623 | -122.449082132455 | (37.790863832623, -122.449082132455) | ||||
| 118772 | 118772 | 104034 | Undocumented 2 | Shrub :: Shrub 98 | 722 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012694.0 | 2104139.0 | 37.7582794948464 | -122.39912151779 | (37.7582794948464, -122.39912151779) | ||||
| 125354 | 125354 | 113803 | Permitted Site 1 | Shrub :: Shrub 98 | 806 SHOTWELL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6007931.0 | 2103220.0 | 37.755489548438 | -122.41552904166201 | (37.755489548438, -122.415529041662) | |||
| 128708 | 128708 | 114186 | Undocumented 2 | Shrub :: Shrub 98 | 2200 HAYES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997096.0 | 2109871.0 | 37.7731365175856 | -122.45347979574801 | (37.7731365175856, -122.453479795748) |
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");