units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where COUNTY = 22, DES_TP = 61 and MNG_AG_LEV = 1
This data as json, copyable, CSV (advanced)
| Link | rowid ▼ | id | map | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 641 | 641 | 640 | {"type": "Polygon", "coordinates": [[[-116.7198, 34.11981], [-116.70246, 34.11977], [-116.70251, 34.10579], [-116.71018, 34.10612], [-116.71976, 34.10633], [-116.71977, 34.11761], [-116.7198, 34.11981]]]} | Open Access 1 | 2745 | San Gorgonio Wilderness | 24903 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | San Bernardino 22 | 598.093 | San Gorgonio Wilderness | 0 | Wilderness Area 61 | 1 | |
| 1739 | 1739 | 1738 | {"type": "Polygon", "coordinates": [[[-116.58089, 34.11817], [-116.58086, 34.13271], [-116.56346, 34.1327], [-116.56345, 34.1182], [-116.56997, 34.11821], [-116.58089, 34.11817]]]} | Open Access 1 | 12948 | San Gorgonio Wilderness | 24903 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | San Bernardino 22 | 639.291 | San Gorgonio Wilderness | 0 | Wilderness Area 61 | 1 | |
| 5280 | 5280 | 5279 | {"type": "Polygon", "coordinates": [[[-116.65041, 34.07675], [-116.63292, 34.07673], [-116.63292, 34.06229], [-116.65036, 34.06223], [-116.65041, 34.07675]]]} | Open Access 1 | 2739 | San Gorgonio Wilderness | 24903 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | San Bernardino 22 | 639.84 | San Gorgonio Wilderness | 0 | Wilderness Area 61 | 1 | |
| 6520 | 6520 | 6519 | {"type": "Polygon", "coordinates": [[[-116.72005, 34.06233], [-116.71996, 34.06301], [-116.71996, 34.07689], [-116.70265, 34.07679], [-116.70266, 34.06231], [-116.72005, 34.06233]]]} | Open Access 1 | 2765 | San Gorgonio Wilderness | 24903 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | San Bernardino 22 | 635.831 | San Gorgonio Wilderness | 0 | Wilderness Area 61 | 1 | |
| 6547 | 6547 | 6546 | {"type": "Polygon", "coordinates": [[[-116.64768, 34.26478], [-116.64761, 34.27934], [-116.6302, 34.27921], [-116.63013, 34.28917], [-116.63014, 34.29368], [-116.62398, 34.29372], [-116.61282, 34.29369], [-116.61286, 34.28368], [-116.61285, 34.27918], [-116.63019, 34.2792], [-116.63023, 34.27349], [-116.63023, 34.26472], [-116.64768, 34.26478]]]} | Open Access 1 | 3228 | Bighorn Mountains Wilderness | 16099 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | San Bernardino 22 | 1272.489 | Bighorn Mtns. Wilderness | 0 | Wilderness Area 61 | 1 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps(
id INT,
map,
ACCESS_TYP INT,
UNIT_ID INT,
UNIT_NAME TEXT,
SUID_NMA INT,
AGNCY_ID INT,
AGNCY_NAME INT,
AGNCY_LEV INT,
AGNCY_TYP INT,
AGNCY_WEB TEXT,
LAYER INT,
MNG_AG_ID INT,
MNG_AGENCY INT,
MNG_AG_LEV INT,
MNG_AG_TYP INT,
PARK_URL TEXT,
COUNTY INT,
ACRES REAL,
LABEL_NAME TEXT,
YR_EST INT,
DES_TP INT,
GAP_STS TEXT,
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_units_with_maps_DES_TP]
ON [units_with_maps] ([DES_TP]);
CREATE INDEX [idx_units_with_maps_COUNTY]
ON [units_with_maps] ([COUNTY]);
CREATE INDEX [idx_units_with_maps_MNG_AG_TYP]
ON [units_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_units_with_maps_MNG_AG_LEV]
ON [units_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_units_with_maps_MNG_AGENCY]
ON [units_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_units_with_maps_LAYER]
ON [units_with_maps] ([LAYER]);
CREATE INDEX [idx_units_with_maps_AGNCY_TYP]
ON [units_with_maps] ([AGNCY_TYP]);
CREATE INDEX [idx_units_with_maps_AGNCY_LEV]
ON [units_with_maps] ([AGNCY_LEV]);
CREATE INDEX [idx_units_with_maps_AGNCY_NAME]
ON [units_with_maps] ([AGNCY_NAME]);
CREATE INDEX [idx_units_with_maps_ACCESS_TYP]
ON [units_with_maps] ([ACCESS_TYP]);