Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, DBH
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13503 | 13503 | 16543 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 400X Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3x3 | 6016084.8488 | 2098009.98397 | 37.74163887514379 | -122.38696691508999 | (37.7416388751438, -122.38696691509) | ||
| 32206 | 32206 | 115845 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1500 Bay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6003527.72894 | 2120738.7231400004 | 37.8033431135653 | -122.432007819421 | (37.8033431135653, -122.432007819421) | |||
| 37750 | 37750 | 106035 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 195X Main St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014366.747719999 | 2116104.57878 | 37.7912273690908 | -122.394174082061 | (37.7912273690908, -122.394174082061) | ||||
| 83230 | 83230 | 95955 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 190X Spear St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2011 12:00:00 AM | 3x3 | Permit Number 767637 | 6014675.0 | 2116143.7 | 37.791351915434 | -122.39311026796601 | (37.791351915434, -122.393110267966) | ||
| 83439 | 83439 | 119744 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 15X Fremont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013411.0 | 2116073.0 | 37.7910874921548 | -122.39747874956998 | (37.7910874921548, -122.39747874957) | ||||
| 88469 | 88469 | 96756 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1820X Palou Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6013661.38712 | 2096183.48051 | 37.736489188553 | -122.395218577377 | (37.736489188553, -122.395218577377) | |||
| 94061 | 94061 | 94895 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 43 Flora St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53954 | 6014036.5 | 2094589.2 | 37.732132475471104 | -122.39381008289601 | (37.7321324754711, -122.393810082896) |
| 99856 | 99856 | 16553 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 500X Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6016006.287148001 | 2097894.9109735 | 37.74131855784729 | -122.387230532448 | (37.7413185578473, -122.387230532448) | |||
| 102694 | 102694 | 103342 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 590X 09th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6010323.0 | 2108639.0 | 37.7705030566796 | -122.407638793146 | (37.7705030566796, -122.407638793146) | |||
| 106363 | 106363 | 82092 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 30 Molimo Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49838 | 5998889.06181671 | 2096571.98929044 | 37.736723332936 | -122.446320512355 | (37.736723332936, -122.446320512355) | ||
| 107120 | 107120 | 97182 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 10X Fremont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6013222.5 | 2116242.1 | 37.7915413037038 | -122.398142826086 | (37.7915413037038, -122.398142826086) | |||
| 110305 | 110305 | 6648 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 495X Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | |||
| 112741 | 112741 | 16513 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 330 Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016404.80629 | 2098376.61978 | 37.742663293572505 | -122.38588614932699 | (37.7426632935725, -122.385886149327) | |||
| 154271 | 154271 | 93112 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300 Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53024 | 6016561.73954 | 2098375.23066 | 37.7426681627043 | -122.38534341756599 | (37.7426681627043, -122.385343417566) | |
| 177272 | 177272 | 115849 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3501 Laguna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6003588.62501 | 2120788.7376599996 | 37.803483892518294 | -122.43180065966801 | (37.8034838925183, -122.431800659668) |
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");