CPAD_2020a_SuperUnits

Table actions

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

55 rows where LAYER = 8 sorted by LAYER

This data as json, geojson, copyable, CSV (advanced)

Suggested facets: ACCESS_TYP, PARK_URL, YR_EST

MNG_AG_LEV 1 ✖

LAYER 1 ✖

  • US Fish and Wildlife Service · 55 ✖
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
820 Open Access 1 Tijuana River Valley Regional Park http://www.sdparks.org/content/sdparks/en/park-pages/TJRVRP.html 26362 106 United States Fish and Wildlife Service 44 Federal 1 Federal Agency 1 http://www.fws.gov/ US Fish and Wildlife Service 8 451.213 Tijuana River Valley RP   <Binary: 743 bytes>
930 Open Access 1 Don Edwards National Wildlife Refuge http://www.fws.gov/refuge/don_edwards_san_francisco_bay/ 13902 106 United States Fish and Wildlife Service 44 Federal 1 Federal Agency 1 http://www.fws.gov/ US Fish and Wildlife Service 8 12672.945 Don Edwards NWR 1974 <Binary: 26,034 bytes>
931 Open Access 1 Humboldt Bay National Wildlife Refuge http://www.fws.gov/refuge/humboldt_bay/ 13915 106 United States Fish and Wildlife Service 44 Federal 1 Federal Agency 1 http://www.fws.gov/ US Fish and Wildlife Service 8 1903.334 Humboldt Bay NWR 1971 <Binary: 14,783 bytes>
932 Open Access 1 Sacramento River National Wildlife Refuge http://www.fws.gov/refuge/sacramento_river/ 13934 106 United States Fish and Wildlife Service 44 Federal 1 Federal Agency 1 http://www.fws.gov/ US Fish and Wildlife Service 8 442.681 Sacramento River NWR 1989 <Binary: 2,935 bytes>
933 Open Access 1 Salinas River National Wildlife Refuge http://www.fws.gov/refuge/salinas_river/ 13939 106 United States Fish and Wildlife Service 44 Federal 1 Federal Agency 1 http://www.fws.gov/ US Fish and Wildlife Service 8 384.054 Salinas River NWR 1974 <Binary: 420 bytes>
938 Open Access 1 San Diego National Wildlife Refuge http://www.fws.gov/refuge/San_Diego/visit/plan_your_visit.html 13972 106 United States Fish and Wildlife Service 44 Federal 1 Federal Agency 1 http://www.fws.gov/ US Fish and Wildlife Service 8 10401.84 San Diego NWR 1996 <Binary: 17,794 bytes>
939 Open Access 1 Sonny Bono Salton Sea National Wildlife Refuge http://www.fws.gov/refuge/sonny_bono_salton_sea/ 13989 106 United States Fish and Wildlife Service 44 Federal 1 Federal Agency 1 http://www.fws.gov/ US Fish and Wildlife Service 8 31835.905 Sonny Bono Salton Sea NWR 1930 <Binary: 2,660 bytes>
2043 No Public Access 3 Bitter Creek National Wildlife Refuge   16129 106 United States Fish and Wildlife Service 44 Federal 1 Federal Agency 1 http://www.fws.gov/ US Fish and Wildlife Service 8 14691.197 Bitter Creek NWR 1985 <Binary: 14,157 bytes>
2085 No Public Access 3 Blue Ridge National Wildlife Refuge https://www.fws.gov/refuge/blue_ridge/ 16187 106 United States Fish and Wildlife Service 44 Federal 1 Federal Agency 1 http://www.fws.gov/ US Fish and Wildlife Service 8 891.572 Blue Ridge NWR 1982 <Binary: 330 bytes>
2429 No Public Access 3 Butte Sink National Wildlife Refuge   16604 106 United States Fish and Wildlife Service 44 Federal 1 Federal Agency 1 http://www.fws.gov/ US Fish and Wildlife Service 8 712.433 Butte Sink NWR   <Binary: 1,108 bytes>
3961 Restricted Access 2 Ellicott Slough National Wildlife Area   18587 106 United States Fish and Wildlife Service 44 Federal 1 Federal Agency 1 http://www.fws.gov/ US Fish and Wildlife Service 8 31.062 Ellicott Slough Nat. Wildlife Area   <Binary: 644 bytes>
4181 No Public Access 3 Farallon National Wildlife Refuge   18842 106 United States Fish and Wildlife Service 44 Federal 1 Federal Agency 1 http://www.fws.gov/ US Fish and Wildlife Service 8 109.157 Farallon NWR 1969 <Binary: 11,823 bytes>
6645 Open Access 1 Marin Island National Wildlife Refuge   21817 106 United States Fish and Wildlife Service 44 Federal 1 Federal Agency 1 http://www.fws.gov/ US Fish and Wildlife Service 8 117.423 Marin Island NWR   <Binary: 330 bytes>
7429 Restricted Access 2 North Central Valley Wildlife Refuge   22811 106 United States Fish and Wildlife Service 44 Federal 1 Federal Agency 1 http://www.fws.gov/ US Fish and Wildlife Service 8 445.781 North Central Valley Wildlife Refuge   <Binary: 394 bytes>
7430 Restricted Access 2 North Central Valley Wildlife Management Area   22810 106 United States Fish and Wildlife Service 44 Federal 1 Federal Agency 1 http://www.fws.gov/ US Fish and Wildlife Service 8 1915.189 North Central Valley WMA   <Binary: 522 bytes>
7671 Restricted Access 2 Sacramento River National Wildlife Refuge   24771 106 United States Fish and Wildlife Service 44 Federal 1 Federal Agency 1 http://www.fws.gov/ US Fish and Wildlife Service 8 5925.271 Sacramento River NWR 1989 <Binary: 17,928 bytes>
7779 Restricted Access 2 San Joaquin National Wildlife Refuge   24912 106 United States Fish and Wildlife Service 44 Federal 1 Federal Agency 1 http://www.fws.gov/ US Fish and Wildlife Service 8 7191.57 San Joaquin NWR   <Binary: 16,459 bytes>
7793 Restricted Access 2 San Luis National Wildlife Refuge   24933 106 United States Fish and Wildlife Service 44 Federal 1 Federal Agency 1 http://www.fws.gov/ US Fish and Wildlife Service 8 18418.093 San Luis NWR 1966 <Binary: 12,379 bytes>
7815 Restricted Access 2 San Pablo Bay National Wildlife Refuge   24964 106 United States Fish and Wildlife Service 44 Federal 1 Federal Agency 1 http://www.fws.gov/ US Fish and Wildlife Service 8 16510.261 San Pablo Bay NWR 1970 <Binary: 12,315 bytes>
9178 Restricted Access 2 San Diego National Wildlife Refuge   24857 106 United States Fish and Wildlife Service 44 Federal 1 Federal Agency 1 http://www.fws.gov/ US Fish and Wildlife Service 8 867.676 San Diego NWR 1996 <Binary: 1,079 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]);