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

276 rows where LAYER = 9

View and edit SQL

Suggested facets: ACCESS_TYP

id ▼ ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST geometry
25 Open Access 1 Carpinteria State Beach http://www.parks.ca.gov/?page_id=599 1466 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 58.152 Carpinteria SB 1932 <Binary: 951 bytes>
42 Open Access 1 Antelope Valley California Poppy Reserve http://www.parks.ca.gov/?page_id=627 1396 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 1771.64 Antelope Valley California Poppy Reserve 1976 <Binary: 868 bytes>
47 Open Access 1 Anza-Borrego Desert State Park http://www.parks.ca.gov/?page_id=638 1413 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 589083.255 Anza-Borrego Desert SP 1933 <Binary: 128571 bytes>
49 Open Access 1 Border Field State Park http://www.parks.ca.gov/?page_id=664 1444 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 787.577 Border Field SP 1972 <Binary: 906 bytes>
58 Open Access 1 Benicia Capitol State Historic Park http://www.parks.ca.gov/?page_id=475 1431 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 0.863 Benicia Capitol SHP 1951 <Binary: 132 bytes>
62 Open Access 1 Bidwell Mansion State Historic Park http://www.parks.ca.gov/?page_id=460 1435 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 5.235 Bidwell Mansion SHP 1964 <Binary: 356 bytes>
66 Open Access 1 California Indian Heritage Center http://www.parks.ca.gov/?page_id=22628 1456 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 51.979 California Indian Heritage Ctr. 2011 <Binary: 964 bytes>
67 Open Access 1 Antelope Valley Indian Museum http://www.avim.parks.ca.gov 1397 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 161.637 Antelope Valley Indian Museum 1979 <Binary: 228 bytes>
69 Open Access 1 Arthur B. Ripley Desert Woodland State Park http://www.parks.ca.gov/?page_id=634 1419 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 568.252 Arthur B. Ripley Desert Woodland SP 1993 <Binary: 634 bytes>
70 Open Access 1 Burleigh H. Murray Ranch http://www.parks.ca.gov/?page_id=535 1448 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 1353.186 Burleigh H. Murray Ranch 1979 <Binary: 532 bytes>
80 Open Access 1 Azalea State Natural Reserve http://www.parks.ca.gov/?page_id=420 1424 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 35.286 Azalea SNR 1943 <Binary: 436 bytes>
81 Open Access 1 California Mining & Mineral Museum http://www.parks.ca.gov/?page_id=588 1457 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 0.327 California Mining & Mineral Museum 1999 <Binary: 196 bytes>
82 Open Access 1 California Citrus State Historic Park http://www.parks.ca.gov/?page_id=649 1455 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 252.448 California Citrus SHP 1984 <Binary: 2695 bytes>
84 Open Access 1 Bale Grist Mill State Historic Park http://www.parks.ca.gov/?page_id=482 1428 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 0.893 Bale Grist Mill SHP 1974 <Binary: 212 bytes>
88 Open Access 1 Benicia State Recreation Area http://www.parks.ca.gov/?page_id=476 1433 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 456.124 Benicia SRA 1957 <Binary: 2532 bytes>
90 Open Access 1 Del Norte Coast Redwoods State Park http://www.parks.ca.gov/?page_id=414 1491 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 31317.297 Del Norte Coast Redwoods SP 1925 <Binary: 9960 bytes>
91 Open Access 1 Drum Barracks http://ohp.parks.ca.gov/ListedResources/Detail/169 1504 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 0.539 Drum Barracks   <Binary: 164 bytes>
93 Open Access 1 Caspar Headlands State Natural Reserve http://www.parks.ca.gov/?page_id=444 1468 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 3.222 Caspar Headlands SNR 1972 <Binary: 1364 bytes>
94 Open Access 1 Donner Memorial State Park http://www.parks.ca.gov/?page_id=503 1503 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 3607.661 Donner Memorial SP 1928 <Binary: 11257 bytes>
95 Open Access 1 Big Basin Redwoods State Park http://www.parks.ca.gov/bigbasin 1441 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 18222.355 Big Basin Redwoods SP 1902 <Binary: 18643 bytes>

Next page

Advanced export

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

CSV options:

CREATE TABLE [CPAD_2020a_SuperUnits] (
   [id] INTEGER PRIMARY KEY,
   [ACCESS_TYP] INTEGER,
   [PARK_NAME] TEXT,
   [PARK_URL] TEXT,
   [SUID_NMA] INTEGER,
   [MNG_AG_ID] INTEGER,
   [MNG_AGENCY] INTEGER,
   [MNG_AG_LEV] INTEGER,
   [MNG_AG_TYP] INTEGER,
   [AGNCY_WEB] TEXT,
   [LAYER] INTEGER,
   [ACRES] FLOAT,
   [LABEL_NAME] TEXT,
   [YR_EST] INTEGER
, "geometry" GEOMETRY,
   FOREIGN KEY(ACCESS_TYP) REFERENCES ACCESS_TYP(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(LAYER) REFERENCES LAYER(id)
);
CREATE INDEX [idx_CPAD_2020a_SuperUnits_LAYER]
    ON [CPAD_2020a_SuperUnits] ([LAYER]);
CREATE INDEX [idx_CPAD_2020a_SuperUnits_MNG_AG_TYP]
    ON [CPAD_2020a_SuperUnits] ([MNG_AG_TYP]);
CREATE INDEX [idx_CPAD_2020a_SuperUnits_MNG_AG_LEV]
    ON [CPAD_2020a_SuperUnits] ([MNG_AG_LEV]);
CREATE INDEX [idx_CPAD_2020a_SuperUnits_MNG_AGENCY]
    ON [CPAD_2020a_SuperUnits] ([MNG_AGENCY]);
CREATE INDEX [idx_CPAD_2020a_SuperUnits_ACCESS_TYP]
    ON [CPAD_2020a_SuperUnits] ([ACCESS_TYP]);