CPAD_2020a_Units
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
517 rows where MNG_AG_LEV = 1 sorted by YR_EST
This data as json, geojson, copyable, CSV (advanced)
Suggested facets: ACCESS_TYP, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, LAYER, MNG_AG_ID, GAP_STS
AGNCY_WEB 12 ✖
- http://www.blm.gov/wo/st/en.html 119
- http://www.fs.fed.us/ 111
- http://www.nps.gov/ 88
- http://www.fws.gov/ 77
- http://www.usace.army.mil/ 52
- http://www.usbr.gov/ 30
- http://www.uscg.mil/ 8
- http://www.defense.gov/ 7
- http://www.slc.ca.gov/ 3
- http://www.parks.ca.gov/ 1
- http://www.sandiegocounty.gov/parks/ 1
- http://www.sequoiariverlands.org 1
MNG_AGENCY 9 ✖
- United States Bureau of Land Management 121
- United States Forest Service 111
- United States National Park Service 89
- United States Fish and Wildlife Service 82
- United States Army Corps of Engineers 52
- United States Bureau of Reclamation 29
- Other Federal 19
- United States Coast Guard 8
- United States Department of Defense 6
Advanced export
JSON shape: default, array, newline-delimited, object
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]);