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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 122 | 122 | 183689 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1341 42nd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5983043.6112 | 2105976.497 | 37.761627789464704 | -122.501799836383 | (37.7616277894647, -122.501799836383) | |||
| 13065 | 13065 | 52792 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1277TEHAMA Houston St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2006 12:00:00 AM | Permit Number 48833 | ||||||||
| 27615 | 27615 | 47743 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 4201 Clement St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/2002 12:00:00 AM | 6 | Permit Number 45527 | 5982418.5702 | 2113061.40286 | 37.78104415210971 | -122.50448647782 | (37.7810441521097, -122.50448647782) | |
| 34675 | 34675 | 31971 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 100 02nd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 9 | Permit Number 35372 | 5995225.90281 | 2114852.20624 | 37.786706205556 | -122.46030963631 | (37.786706205556, -122.46030963631) | |
| 54142 | 54142 | 38882 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 101 Commonwealth Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40703 | 5996508.72142362 | 2113802.71293841 | 37.7838982845648 | -122.455795523067 | (37.7838982845648, -122.455795523067) | ||
| 73555 | 73555 | 37647 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1001 Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1998 12:00:00 AM | 2 | Permit Number 40060 | 5992426.792 | 2111328.0458 | 37.7768684149352 | -122.469737140808 | (37.7768684149352, -122.469737140808) | ||
| 84971 | 84971 | 41662 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1376 Clayton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42129 | 5999046.52257313 | 2104716.21389633 | 37.7590943881005 | -122.44636181286998 | (37.7590943881005, -122.44636181287) | ||
| 88831 | 88831 | 41690 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 150 Conrad St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42144 | 6001748.90360557 | 2096547.6107593998 | 37.7368193138397 | -122.436431068172 | (37.7368193138397, -122.436431068172) | ||
| 89337 | 89337 | 40785 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 410 Monticello St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/1999 12:00:00 AM | Permit Number 41739 | 5991762.23808711 | 2091284.45671221 | 37.7217954779898 | -122.470575817994 | (37.7217954779898, -122.470575817994) | ||
| 93271 | 93271 | 8100 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 765 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/1998 12:00:00 AM | 6 | 3X3 | 6004193.95704 | 2111472.64562 | 37.7779385589247 | -122.429041260431 | (37.7779385589247, -122.429041260431) | ||
| 95116 | 95116 | 82767 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 398 11th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52426 | 6008893.02169344 | 2108709.50255899 | 37.770616489827106 | -122.412590100264 | (37.7706164898271, -122.412590100264) | ||
| 95600 | 95600 | 48903 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2200X Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2002 12:00:00 AM | Permit Number 46105 | 6004224.6625681 | 2116191.17070072 | 37.790896187279394 | -122.42927158905898 | (37.7908961872794, -122.429271589059) | |||
| 96296 | 96296 | 38062 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1802 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40254 | 6001102.14351194 | 2114546.50782632 | 37.786203101297396 | -122.439957367186 | (37.7862031012974, -122.439957367186) | ||
| 98152 | 98152 | 87936 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3600 Quintara St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50956 | 5982309.0 | 2100840.0 | 37.7474812377595 | -122.503960055968 | (37.7474812377595, -122.503960055968) | ||
| 102043 | 102043 | 41729 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 99X 14th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42172 | 6008031.27943269 | 2107943.20653569 | 37.7684640195804 | -122.415516624702 | (37.7684640195804, -122.415516624702) | ||
| 102562 | 102562 | 38030 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1400 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1998 12:00:00 AM | Permit Number 40236 | 5991713.73808693 | 2098444.67646581 | 37.7414528421268 | -122.471264893104 | (37.7414528421268, -122.471264893104) | |||
| 103735 | 103735 | 41749 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1100 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42181 | 6009068.76416013 | 2116381.28511649 | 37.7916912386009 | -122.41252459171899 | (37.7916912386009, -122.412524591719) | ||
| 111749 | 111749 | 113423 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1583 Shafter Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6015002.21794725 | 2094078.95124561 | 37.730785055109294 | -122.39043571521799 | (37.7307850551093, -122.390435715218) | |||
| 119499 | 119499 | 40199 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 4845 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1999 12:00:00 AM | 5 | Permit Number 41381 | 5983584.60152 | 2111699.05511 | 37.7773720577908 | -122.500351906273 | (37.7773720577908, -122.500351906273) | |
| 126641 | 126641 | 32859 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 499 Hoffman Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/1996 12:00:00 AM | Permit Number 37207 | 6000703.6978076 | 2101134.48618072 | 37.7493543400616 | -122.440373654783 | (37.7493543400616, -122.440373654783) | |||
| 127644 | 127644 | 87804 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1953 Jackson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50568 | 6004841.0 | 2117073.0 | 37.7933523405685 | -122.427201927622 | (37.7933523405685, -122.427201927622) | ||
| 128479 | 128479 | 41874 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 66 Belcher St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42253 | 6003778.26782897 | 2107952.91484982 | 37.768250702181504 | -122.430228105724 | (37.7682507021815, -122.430228105724) | ||
| 128904 | 128904 | 33058 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 328 San Jose Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2016 12:00:00 AM | 3 | Permit Number 779143 | 6006171.76331287 | 2101198.94449976 | 37.7498411527935 | -122.421469507825 | (37.7498411527935, -122.421469507825) | ||
| 140049 | 140049 | 38215 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 350 Wayland St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40338 | 6010576.45287423 | 2092372.10995681 | 37.7258519216371 | -122.405616192564 | (37.7258519216371, -122.405616192564) | ||
| 143019 | 143019 | 52145 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 101 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/2004 12:00:00 AM | 6002340.0 | 2108819.0 | 37.7705471897255 | -122.43526488371799 | (37.7705471897255, -122.435264883718) | |||
| 148570 | 148570 | 48459 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 520 06th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2002 12:00:00 AM | 2 | Permit Number 45824 | 6011943.63031 | 2110470.08202 | 37.775621375652705 | -122.40216174348998 | (37.7756213756527, -122.40216174349) | ||
| 185123 | 185123 | 42676 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1097 Green St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | 5 | Permit Number 42702 | 6007858.06857 | 2118865.16486 | 37.7984433372469 | -122.41688966093399 | (37.7984433372469, -122.416889660934) |
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");