Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, PlantDate, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 759 | 759 | 221434 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:56:00 AM | 1 | Width 3ft | 6005437.11129 | 2108190.56795 | 37.7689970584876 | -122.42450722982001 | (37.7689970584876, -122.42450722982) | ||
| 4338 | 4338 | 221462 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300x Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:33:00 AM | 1 | Width 3ft | 6005503.98521 | 2106938.10792 | 37.7655618784892 | -122.424186831055 | (37.7655618784892, -122.424186831055) | ||
| 4416 | 4416 | 221474 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400x Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 10:16:00 AM | 1 | Width 3ft | 6005537.16302 | 2106367.52425 | 37.7639970644374 | -122.42403149656401 | (37.7639970644374, -122.424031496564) | ||
| 4478 | 4478 | 221500 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/28/2015 11:10:00 PM | 2 | Width 3ft | 6005602.08318 | 2105171.2083400004 | 37.7607159284129 | -122.423721890569 | (37.7607159284129, -122.423721890569) | ||
| 5131 | 5131 | 152418 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 700x Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005636.4507 | 2104585.0792400003 | 37.759108495478394 | -122.42356135618999 | (37.7591084954784, -122.42356135619) | |||
| 5661 | 5661 | 118352 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:56:00 AM | 3 | ||||||||
| 25703 | 25703 | 221449 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6005469.95975 | 2107527.1833200003 | 37.767177417921 | -122.42434641935499 | (37.767177417921, -122.424346419355) | |||
| 52085 | 52085 | 221487 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005570.243559999 | 2105766.57088 | 37.762348856238205 | -122.42387434542101 | (37.7623488562382, -122.423874345421) | |||
| 52769 | 52769 | 221515 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1300x Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005828.19442 | 2101110.33186 | 37.7495784651962 | -122.42265128992399 | (37.7495784651962, -122.422651289924) | |||
| 54972 | 54972 | 221524 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1200x Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 3ft | 6005795.8556 | 2101693.96335 | 37.7511791585977 | -122.42280459107401 | (37.7511791585977, -122.422804591074) | |||
| 80233 | 80233 | 110778 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000X GUERRERO ST | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/26/2015 02:43:00 PM | 3 | 3x3 | 6005663.0 | 2103080.0 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | ||
| 91609 | 91609 | 110624 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400X GUERRERO ST | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 10:16:00 AM | 3 | 3x3 | 6005439.0 | 2106552.0 | 37.7644980484366 | -122.42438413571101 | (37.7644980484366, -122.424384135711) | ||
| 94847 | 94847 | 91287 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1212x Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 6005738.0 | 2101906.0 | 37.7517580978369 | -122.42301973133999 | (37.7517580978369, -122.42301973134) | |||
| 98416 | 98416 | 115516 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6005415.2 | 2107753.5 | 37.767795737129205 | -122.424551925681 | (37.7677957371292, -122.424551925681) | |||||
| 101837 | 101837 | 110765 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300X GUERRERO ST | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:33:00 AM | 3 | 3x3 | 6005492.0 | 2106949.0 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | ||
| 142527 | 142527 | 109699 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x GUERRERO ST | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/28/2015 11:10:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.42431273662201 | (37.7613144297161, -122.424312736622) | ||
| 149575 | 149575 | 221542 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 900x Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 3ft | 6005709.18006 | 2103278.9471400003 | 37.7555262664424 | -122.423216978787 | (37.7555262664424, -122.423216978787) | |||
| 177873 | 177873 | 221550 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6005729.97057 | 2102894.68155 | 37.7544723356343 | -122.423117766494 | (37.7544723356343, -122.423117766494) |
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");