Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

399 rows where LAYER = 6

View and edit SQL

Suggested facets: ACCESS_TYP, MNG_AG_ID, MNG_AGENCY, MNG_AG_LEV, MNG_AG_TYP, DES_TP, GAP_STS

id ▼ ACCESS_TYP UNIT_ID UNIT_NAME SUID_NMA AGNCY_ID AGNCY_NAME AGNCY_LEV AGNCY_TYP AGNCY_WEB LAYER MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP PARK_URL COUNTY ACRES LABEL_NAME YR_EST DES_TP GAP_STS geometry
44 Open Access 1 104 Rhode Island Wildlife Area 30492 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/Lands/Places-to-Visit/Rhode-Island-WA Contra Costa 12 85.271 Rhode Island Wildlife Area 2002 State Conservation Area 8 2 <Binary: 612 bytes>
66 Open Access 1 188 Dales Lake Ecological Reserve 32143 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/Lands/Places-to-Visit/Dales-Lake-ER Tehama 18 381.434 Dales Lake ER 1994 State Conservation Area 8 2 <Binary: 228 bytes>
212 Open Access 1 663 Fall River Mills Ecological Reserve 32163 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/Lands/Places-to-Visit/Fall-River-Mills-ER Shasta 27 1.448 Fall River Mills ER 1998 State Conservation Area 8 2 <Binary: 212 bytes>
227 No Public Access 3 621 Elsa Rupp Natural Area 32160 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 201 California Department of Fish and Wildlife 25 State 5 State Agency 5   Siskiyou 28 9.475 Elsa Rupp Natural Area   None 26   <Binary: 180 bytes>
390 Open Access 1 1165 Steelhead Beach Fishing Access 32317 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 201 California Department of Fish and Wildlife 25 State 5 State Agency 5   Sonoma 16 54.507 Steelhead Beach FA 0 State Recreation Area 39 4 <Binary: 504 bytes>
401 Restricted Access 2 1556 Springville Ecological Reserve 25751 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 201 California Department of Fish and Wildlife 25 State 5 State Agency 5   Tulare 29 4.947 Springville ER 0 State Conservation Area 8 2 <Binary: 180 bytes>
466 Restricted Access 2 921 Grass Lake Wildlife Area 19448 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 201 California Department of Fish and Wildlife 25 State 5 State Agency 5   Siskiyou 28 44.169 Grass Lake Wildlife Area 0 State Conservation Area 8 2 <Binary: 404 bytes>
522 Open Access 1 2260 Mouth of Cottonwood Creek Wildlife Area 30477 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/Lands/Places-to-Visit/Mouth-of-Cottonwood-Creek-WA Shasta 27 1016.666 Mouth of Cottonwood Creek Wildlife Area 1982 State Conservation Area 8 2 <Binary: 2823 bytes>
544 No Public Access 3 1814 Lower Box Canyon 32208 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 201 California Department of Fish and Wildlife 25 State 5 State Agency 5   Siskiyou 28 1.061 Lower Box Canyon 0 State Resource Management Area 55 3 <Binary: 132 bytes>
630 Restricted Access 2 4792 Thomes Creek Ecological Reserve 26310 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 201 California Department of Fish and Wildlife 25 State 5 State Agency 5   Tehama 18 442.371 Thomes Creek ER 0 State Conservation Area 8 2 <Binary: 292 bytes>
635 Open Access 1 4868 Carrizo Plains Ecological Reserve 32106 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/Lands/Places-to-Visit/Carrizo-Plains-ER San Luis Obispo 1 38876.762 Carrizo Plains ER 1993 State Conservation Area 8 2 <Binary: 15571 bytes>
688 Open Access 1 3506 Sacramento River -- Prospect Ave. Fishing Access 32282 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 201 California Department of Fish and Wildlife 25 State 5 State Agency 5   Siskiyou 28 1.339 Sacramento River -- Prospect Ave. FA 0 State Recreation Area 39 4 <Binary: 132 bytes>
1129 No Public Access 3 6619 Deep Springs Lake 32146 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 201 California Department of Fish and Wildlife 25 State 5 State Agency 5   Inyo 43 725.874 Deep Springs Lake 0 State Resource Management Area 55 3 <Binary: 228 bytes>
1160 Open Access 1 7361 Sycuan Peak Ecological Reserve 32323 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/Lands/Places-to-Visit/Sycuan-Peak-ER San Diego 4 2347.431 Sycuan Peak ER 2000 State Conservation Area 8 2 <Binary: 1938 bytes>
1223 Open Access 1 8807 Healdsburg Fishing Access 32183 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 201 California Department of Fish and Wildlife 25 State 5 State Agency 5   Sonoma 16 4.182 Healdsburg FA 0 State Recreation Area 39 4 <Binary: 228 bytes>
1361 No Public Access 3 8074 Pilobos 32263 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 201 California Department of Fish and Wildlife 25 State 5 State Agency 5   Fresno 9 134.36 Pilobos 0 State Resource Management Area 55 3 <Binary: 282 bytes>
1521 Restricted Access 2 12834 San Luis Rey River Ecological Reserve 24942 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 201 California Department of Fish and Wildlife 25 State 5 State Agency 5   San Diego 4 14.153 San Luis Rey River ER 0 State Conservation Area 8 2 <Binary: 148 bytes>
1550 No Public Access 3 11546 Santa Margarita Ecological Reserve 33343 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 221 San Diego State University 378 State 5 State Agency 5 https://fsp.sdsu.edu/about-us/ Riverside 10 243.178 Santa Margarita ER 1962 State Conservation Area 8 2 <Binary: 532 bytes>
1580 No Public Access 3 12128 Chuckwalla Bench 32115 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 201 California Department of Fish and Wildlife 25 State 5 State Agency 5   Riverside 10 66.962 Chuckwalla Bench 0 State Resource Management Area 55 3 <Binary: 196 bytes>
1641 Open Access 1 1917 Keys Creek Fishing Access 32194 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 201 California Department of Fish and Wildlife 25 State 5 State Agency 5   Marin 23 15.8 Keys Creek FA 0 State Recreation Area 39 4 <Binary: 970 bytes>

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [CPAD_2020a_Units] (
   [id] INTEGER PRIMARY KEY,
   [ACCESS_TYP] INTEGER,
   [UNIT_ID] INTEGER,
   [UNIT_NAME] TEXT,
   [SUID_NMA] INTEGER,
   [AGNCY_ID] INTEGER,
   [AGNCY_NAME] INTEGER,
   [AGNCY_LEV] INTEGER,
   [AGNCY_TYP] INTEGER,
   [AGNCY_WEB] TEXT,
   [LAYER] INTEGER,
   [MNG_AG_ID] INTEGER,
   [MNG_AGENCY] INTEGER,
   [MNG_AG_LEV] INTEGER,
   [MNG_AG_TYP] INTEGER,
   [PARK_URL] TEXT,
   [COUNTY] INTEGER,
   [ACRES] FLOAT,
   [LABEL_NAME] TEXT,
   [YR_EST] INTEGER,
   [DES_TP] INTEGER,
   [GAP_STS] TEXT
, "geometry" GEOMETRY,
   FOREIGN KEY(ACCESS_TYP) REFERENCES ACCESS_TYP(id),
   FOREIGN KEY(AGNCY_NAME) REFERENCES AGNCY_NAME(id),
   FOREIGN KEY(AGNCY_LEV) REFERENCES AGNCY_LEV(id),
   FOREIGN KEY(AGNCY_TYP) REFERENCES AGNCY_TYP(id),
   FOREIGN KEY(LAYER) REFERENCES LAYER(id),
   FOREIGN KEY(MNG_AGENCY) REFERENCES MNG_AGENCY(id),
   FOREIGN KEY(MNG_AG_LEV) REFERENCES MNG_AG_LEV(id),
   FOREIGN KEY(MNG_AG_TYP) REFERENCES MNG_AG_TYP(id),
   FOREIGN KEY(COUNTY) REFERENCES COUNTY(id),
   FOREIGN KEY(DES_TP) REFERENCES DES_TP(id)
);
CREATE INDEX [idx_CPAD_2020a_Units_DES_TP]
    ON [CPAD_2020a_Units] ([DES_TP]);
CREATE INDEX [idx_CPAD_2020a_Units_COUNTY]
    ON [CPAD_2020a_Units] ([COUNTY]);
CREATE INDEX [idx_CPAD_2020a_Units_MNG_AG_TYP]
    ON [CPAD_2020a_Units] ([MNG_AG_TYP]);
CREATE INDEX [idx_CPAD_2020a_Units_MNG_AG_LEV]
    ON [CPAD_2020a_Units] ([MNG_AG_LEV]);
CREATE INDEX [idx_CPAD_2020a_Units_MNG_AGENCY]
    ON [CPAD_2020a_Units] ([MNG_AGENCY]);
CREATE INDEX [idx_CPAD_2020a_Units_LAYER]
    ON [CPAD_2020a_Units] ([LAYER]);
CREATE INDEX [idx_CPAD_2020a_Units_AGNCY_TYP]
    ON [CPAD_2020a_Units] ([AGNCY_TYP]);
CREATE INDEX [idx_CPAD_2020a_Units_AGNCY_LEV]
    ON [CPAD_2020a_Units] ([AGNCY_LEV]);
CREATE INDEX [idx_CPAD_2020a_Units_AGNCY_NAME]
    ON [CPAD_2020a_Units] ([AGNCY_NAME]);
CREATE INDEX [idx_CPAD_2020a_Units_ACCESS_TYP]
    ON [CPAD_2020a_Units] ([ACCESS_TYP]);