Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 754 | 754 | 221432 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 05:53:00 AM | 1 | Width 3ft | 6005434.00046 | 2108253.10785 | 37.769168602384205 | -122.42452243915301 | (37.7691686023842, -122.424522439153) | ||
| 4332 | 4332 | 221460 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:41:00 AM | 2 | Width 3ft | 6005499.89777 | 2107004.0817 | 37.76574279600489 | -122.424205661071 | (37.7657427960049, -122.424205661071) | ||
| 4377 | 4377 | 221451 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/09/2016 11:36:00 AM | 1 | Width 3ft | 6005468.550009999 | 2107589.96825 | 37.76734973074429 | -122.424355761536 | (37.7673497307443, -122.424355761536) | ||
| 4408 | 4408 | 221472 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 10:24:00 AM | 1 | Width 3ft | 6005534.310819999 | 2106426.8401 | 37.7641597706703 | -122.424045579956 | (37.7641597706703, -122.424045579956) | ||
| 5111 | 5111 | 152416 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 700x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005631.99539 | 2104658.5890900004 | 37.7593100848133 | -122.423581991114 | (37.7593100848133, -122.423581991114) | |||
| 5429 | 5429 | 118350 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 05:53:00 AM | 3 | ||||||||
| 44105 | 44105 | 221562 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 100 San Jose Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006161.28805 | 2102498.9287799997 | 37.753410020459995 | -122.421598049829 | (37.75341002046, -122.421598049829) | |||
| 44886 | 44886 | 221418 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 800x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 3ft | 6005666.2176 | 2103986.40391 | 37.757466353200996 | -122.423415847665 | (37.757466353201, -122.423415847665) | |||
| 46284 | 46284 | 221426 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 900x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005693.61577 | 2103548.6076700003 | 37.7562658131324 | -122.423289973179 | (37.7562658131324, -122.423289973179) | |||
| 73681 | 73681 | 221526 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1200x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 3ft | 6005792.85635 | 2101748.62489 | 37.7513290773756 | -122.42281884712601 | (37.7513290773756, -122.422818847126) | |||
| 87539 | 87539 | 91285 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1212x Guerrero St | 5 | 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) | |||
| 95444 | 95444 | 109697 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x GUERRERO ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 10:59:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.42431273662201 | (37.7613144297161, -122.424312736622) | ||
| 97820 | 97820 | 110763 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300X GUERRERO ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:41:00 AM | 3 | 3x3 | 6005492.0 | 2106949.0 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | ||
| 97980 | 97980 | 110776 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000X GUERRERO ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/26/2015 02:53:00 PM | 3 | 3x3 | 6005663.0 | 2103080.0 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | ||
| 104357 | 104357 | 110622 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400X GUERRERO ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 10:24:00 AM | 3 | 3x3 | 6005439.0 | 2106552.0 | 37.7644980484366 | -122.42438413571101 | (37.7644980484366, -122.424384135711) | ||
| 146089 | 146089 | 115514 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/09/2016 11:36:00 AM | 3 | 6005415.2 | 2107753.5 | 37.767795737129205 | -122.424551925681 | (37.7677957371292, -122.424551925681) | |||
| 151865 | 151865 | 221485 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005566.92978 | 2105826.00789 | 37.762511869155105 | -122.42389003321101 | (37.7625118691551, -122.423890033211) | |||
| 168829 | 168829 | 221544 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 900x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005705.623380001 | 2103333.32509 | 37.755675374928295 | -122.423233144119 | (37.7556753749283, -122.423233144119) | |||
| 169550 | 169550 | 221558 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005728.5881 | 2102926.2105099997 | 37.754558828830106 | -122.423124788381 | (37.7545588288301, -122.423124788381) | |||
| 184414 | 184414 | 221498 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005599.77613 | 2105242.7413 | 37.7609122108583 | -122.423734955914 | (37.7609122108583, -122.423734955914) | |||
| 185218 | 185218 | 221536 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1100x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 3ft | 6005762.1987 | 2102333.32685 | 37.75293280420979 | -122.422966417762 | (37.7529328042098, -122.422966417762) |
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");