Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, PlantDate, PermitNotes, XCoord, YCoord, Latitude, Longitude, Location
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2370 | 2370 | 112542 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 438 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/24/2016 12:00:00 AM | 3 | 3x3 | 6011405.06525 | 2118709.9257400003 | 37.7982159634572 | -122.40460495956002 | (37.7982159634572, -122.40460495956) | ||
| 6247 | 6247 | 112539 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 426 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/12/2016 11:10:00 AM | 3 | 3x3 | 6011460.82325 | 2118719.23159 | 37.7982446311281 | -122.404412674615 | (37.7982446311281, -122.404412674615) | ||
| 6998 | 6998 | 112530 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 435 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/24/2016 07:26:00 AM | 3 | 3x3 | 6011409.86951 | 2118646.99301 | 37.7980434339179 | -122.40458390283199 | (37.7980434339179, -122.404583902832) | ||
| 7100 | 7100 | 106210 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 585X Bush St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774310 | 6010773.37918 | 2115862.1930299997 | 37.7903614528559 | -122.406590009715 | (37.7903614528559, -122.406590009715) | |
| 10245 | 10245 | 43062 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 490 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 51464 | 5985348.18764 | 2112571.6735099996 | 37.779871377757296 | -122.49431551232401 | (37.7798713777573, -122.494315512324) | |
| 15769 | 15769 | 30659 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 54 Lafayette St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 34592 | 6007591.74325 | 2109572.72569 | 37.7729135790239 | -122.41715242667 | (37.7729135790239, -122.41715242667) |
| 41315 | 41315 | 95661 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 231 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767423 | 6010393.1108800005 | 2093567.05478 | 37.7291227359169 | -122.406334153496 | (37.7291227359169, -122.406334153496) |
| 47422 | 47422 | 37962 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 150 Mississippi St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52636 | 6013967.394309999 | 2106347.66255 | 37.7644148813545 | -122.39487221400299 | (37.7644148813545, -122.394872214003) | |
| 48473 | 48473 | 92109 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 654 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52365 | 5981669.51861 | 2111284.19832 | 37.7761203861627 | -122.506945906937 | (37.7761203861627, -122.506945906937) | |
| 83275 | 83275 | 94656 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 118 Baden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53795 | 6000765.0 | 2094410.0 | 37.7308939745429 | -122.439679643784 | (37.7308939745429, -122.439679643784) |
| 86432 | 86432 | 117228 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 66 POTOMAC ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6003144.0 | 2108708.0 | 37.7702880357607 | -122.43247591327801 | (37.7702880357607, -122.432475913278) | |||
| 87056 | 87056 | 102078 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 35 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769728 | 6005184.6 | 2096720.6 | 37.737488929995706 | -122.42456464703699 | (37.7374889299957, -122.424564647037) |
| 91393 | 91393 | 100238 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 701X 39th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5983814.58777 | 2110777.43528 | 37.774855053302495 | -122.499488194975 | (37.7748550533025, -122.499488194975) | |||
| 97280 | 97280 | 94657 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 118 Baden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53795 | 6000765.0 | 2094410.0 | 37.7308939745429 | -122.439679643784 | (37.7308939745429, -122.439679643784) |
| 105918 | 105918 | 94658 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 130 Baden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53796 | 6000765.0 | 2094447.0 | 37.73099556799129 | -122.43968229537701 | (37.7309955679913, -122.439682295377) |
| 106194 | 106194 | 102595 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 133 Baden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769795 | 6000714.8 | 2094523.9 | 37.7312038601891 | -122.439861356334 | (37.7312038601891, -122.439861356334) |
| 126995 | 126995 | 9330 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 159 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/2015 03:37:00 AM | 3 | 3x3 | 6000991.502255901 | 2098643.2192577 | 37.7425302962209 | -122.439199887043 | (37.7425302962209, -122.439199887043) | ||
| 129190 | 129190 | 94659 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 130 Baden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53796 | 6000765.0 | 2094447.0 | 37.73099556799129 | -122.43968229537701 | (37.7309955679913, -122.439682295377) |
| 160691 | 160691 | 81886 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 44 Toledo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50856 | 6001667.32434 | 2120063.59572 | 37.801383746212295 | -122.43839740632299 | (37.8013837462123, -122.438397406323) | |
| 173900 | 173900 | 112532 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 435 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6011441.2715 | 2118651.0791599997 | 37.7980564084299 | -122.404475530047 | (37.7980564084299, -122.404475530047) |
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");