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

394 rows where LAYER = 6

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
68 Open Access 1 Morro Dunes Ecological Reserve   32232 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 282.915 Morro Dunes ER 1983 <Binary: 522 bytes>
89 Restricted Access 2 Bair Island Ecological Reserve https://www.wildlife.ca.gov/Lands/Places-to-Visit/Bair-Island-ER 15765 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 787.542 Bair Island ER 1986 <Binary: 772 bytes>
397 No Public Access 3 Acker Island   32009 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 20.964 Acker Island   <Binary: 212 bytes>
401 Open Access 1 Agua Hedionda Lagoon Ecological Reserve https://www.wildlife.ca.gov/Lands/Places-to-Visit/Agua-Hedionda-Lagoon-ER 32012 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 195.204 Agua Hedionda Lagoon ER 2002 <Binary: 1956 bytes>
408 Open Access 1 Alkali Sink Ecological Reserve https://www.wildlife.ca.gov/Lands/Places-to-Visit/Alkali-Sink-ER 32014 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 936.052 Alkali Sink ER 1979 <Binary: 683 bytes>
409 Open Access 1 Allensworth Ecological Reserve https://www.wildlife.ca.gov/Lands/Places-to-Visit/Allensworth-ER 32015 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 6406.291 Allensworth ER 1983 <Binary: 10960 bytes>
418 No Public Access 3 California Aqueduct, Region 4   32081 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 118.422 California Aqueduct, Region 4   <Binary: 410 bytes>
423 Open Access 1 American River Access   32019 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 59.699 American River Access   <Binary: 324 bytes>
425 No Public Access 3 Bodega Bay Monarch Butterfly   32057 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 4.082 Bodega Bay Monarch Butterfly   <Binary: 244 bytes>
429 No Public Access 3 Apricum Hill Ecological Reserve   32028 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 37.028 Apricum Hill ER   <Binary: 196 bytes>
430 Open Access 1 Anderson Fishing Access   32022 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 37.55 Anderson FA   <Binary: 436 bytes>
445 No Public Access 3 Basso Bridge   32041 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 31.443 Basso Bridge   <Binary: 759 bytes>
446 No Public Access 3 Bend Ferry Road   32047 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 45.386 Bend Ferry Road   <Binary: 148 bytes>
448 Open Access 1 Belden's Landing Fishing Access   32045 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 9.739 Belden's Landing FA   <Binary: 452 bytes>
449 Open Access 1 Battle Creek Public Access   32043 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 4.331 Battle Creek PA   <Binary: 292 bytes>
450 Open Access 1 Bend Bridge Public Access   32046 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 3.867 Bend Bridge PA   <Binary: 164 bytes>
478 No Public Access 3 Byron Conservation Bank   32076 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 139.977 Byron Conservation Bank   <Binary: 244 bytes>
485 Open Access 1 Bracut Tidelands   32065 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 222.435 Bracut Tidelands   <Binary: 552 bytes>
487 Open Access 1 Bonnyview Road Fishing Access   32064 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 6.223 Bonnyview Road FA   <Binary: 164 bytes>
488 Open Access 1 Brannan Island Fishing Access   32066 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 6.247 Brannan Island FA   <Binary: 666 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]);