units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where COUNTY = 37, DES_TP = 1 and MNG_AGENCY = 1
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- United States Bureau of Land Management · 1 ✖
DES_TP 1
- National Public Lands · 1 ✖
ACCESS_TYP 1
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11251 | 11251 | 11250 | {"type": "MultiPolygon", "coordinates": [[[[-120.81619, 36.87248], [-120.81613, 36.87486], [-120.81608, 36.87965], [-120.81172, 36.87958], [-120.81232, 36.8833], [-120.80781, 36.88321], [-120.8072, 36.8795], [-120.80734, 36.87503], [-120.80738, 36.87225], [-120.8074, 36.86882], [-120.81191, 36.8689], [-120.81188, 36.8724], [-120.81619, 36.87248]]], [[[-120.86716, 36.80008], [-120.86715, 36.80731], [-120.85823, 36.8071], [-120.85819, 36.79988], [-120.86716, 36.80008]]], [[[-120.93752, 36.78778], [-120.93744, 36.79504], [-120.93387, 36.79478], [-120.93395, 36.78752], [-120.9307, 36.78692], [-120.93067, 36.78731], [-120.9306, 36.79419], [-120.92187, 36.79259], [-120.92184, 36.79484], [-120.92181, 36.79618], [-120.91575, 36.79507], [-120.91296, 36.79458], [-120.913, 36.79099], [-120.91302, 36.78376], [-120.91302, 36.77637], [-120.90375, 36.77718], [-120.90393, 36.75895], [-120.90846, 36.75854], [-120.90846, 36.76226], [-120.91298, 36.76186], [-120.92201, 36.76256], [-120.92202, 36.76642], [-120.93109, 36.76715], [-120.93109, 36.76328], [-120.93246, 36.76339], [-120.93406, 36.78016], [-120.93405, 36.78252], [-120.93397, 36.78735], [-120.93395, 36.7875], [-120.93752, 36.78778]]], [[[-120.92713, 36.75924], [-120.92173, 36.75881], [-120.91301, 36.75816], [-120.913, 36.75436], [-120.90847, 36.75477], [-120.90846, 36.75107], [-120.90561, 36.75133], [-120.90726, 36.74998], [-120.91299, 36.74539], [-120.91299, 36.74679], [-120.92647, 36.74619], [-120.92712, 36.7467], [-120.92713, 36.75924]]], [[[-120.96079, 36.78862], [-120.96008, 36.78864], [-120.95118, 36.78871], [-120.95116, 36.78918], [-120.95115, 36.79235], [-120.94664, 36.79204], [-120.94667, 36.78841], [-120.94216, 36.7881], [-120.94217, 36.78446], [-120.93758, 36.78413], [-120.93762, 36.78039], [-120.93762, 36.77461], [-120.93838, 36.7746], [-120.93838, 36.77223], [-120.95118, 36.77242], [-120.95977, 36.77252], [-120.95976, 36.77452], [-120.96078, 36.77452], [-120.96077, 36.78128], [-120.96079, 36.78862]]], [[[-120.94247, 36.81582], [-120.94247, 36.81582], [-120.93889, 36.81321], [-120.94243, 36.81328], [-120.94247, 36.81582]]], [[[-121.14563, 36.92035], [-121.14558, 36.92398], [-121.14415, 36.92394], [-121.1442, 36.92032], [-121.14563, 36.92035]]], [[[-121.14584, 36.90514], [-121.14576, 36.91255], [-121.14432, 36.91252], [-121.14438, 36.90874], [-121.1444, 36.90511], [-121.14584, 36.90514]]], [[[-121.14781, 36.85234], [-121.1461, 36.85231], [-121.14611, 36.84976], [-121.14626, 36.84999], [-121.14652, 36.85017], [-121.14672, 36.85036], [-121.14685, 36.85059], [-121.14715, 36.85148], [-121.14729, 36.85168], [-121.14746, 36.85199], [-121.14766, 36.85221], [-121.14781, 36.85234]]], [[[-121.17305, 36.90515], [-121.17296, 36.91251], [-121.16391, 36.91258], [-121.16384, 36.92004], [-121.15933, 36.92011], [-121.15939, 36.91257], [-121.15939, 36.90878], [-121.16391, 36.90878], [-121.16848, 36.90875], [-121.16849, 36.90518], [-121.17305, 36.90515]]]]} | Open Access 1 | 21632 | BLM | 16162 | 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 | Merced 37 | 3993.055 | BLM | 1899 | National Public Lands 1 | 3 |
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]);