units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, MNG_AG_TYP = 1 and UNIT_NAME = "McCain Valley National Cooperative Land and Wildlife Management Area"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17015 | 17015 | 17014 | {"type": "MultiPolygon", "coordinates": [[[[-116.48381, 32.96218], [-116.46708, 32.96157], [-116.45862, 32.96147], [-116.45983, 32.97277], [-116.4557, 32.97273], [-116.4561, 32.97629], [-116.44754, 32.97614], [-116.44738, 32.98004], [-116.4387, 32.97977], [-116.43911, 32.97615], [-116.42886, 32.97602], [-116.42886, 32.97595], [-116.41453, 32.97592], [-116.41186, 32.97465], [-116.41187, 32.97222], [-116.42271, 32.97232], [-116.42189, 32.96497], [-116.41691, 32.9649], [-116.41671, 32.96121], [-116.39822, 32.96131], [-116.38099, 32.96109], [-116.38143, 32.94679], [-116.36206, 32.94652], [-116.36205, 32.94653], [-116.36298, 32.95401], [-116.36393, 32.96156], [-116.35884, 32.96111], [-116.35886, 32.96935], [-116.34707, 32.9697], [-116.34728, 32.97328], [-116.34552, 32.97326], [-116.3431, 32.97327], [-116.3422, 32.97269], [-116.34153, 32.96955], [-116.33717, 32.96942], [-116.33502, 32.95939], [-116.32758, 32.96131], [-116.32757, 32.94544], [-116.32877, 32.9297], [-116.32681, 32.91591], [-116.30079, 32.9181], [-116.29276, 32.91723], [-116.27701, 32.91733], [-116.26046, 32.91766], [-116.24985, 32.91791], [-116.24846, 32.91396], [-116.2496, 32.91395], [-116.2503, 32.9159], [-116.25132, 32.91591], [-116.25133, 32.9159], [-116.25003, 32.91204], [-116.24896, 32.9088], [-116.24874, 32.90811], [-116.25098, 32.90812], [-116.25034, 32.90614], [-116.25142, 32.90613], [-116.25082, 32.90417], [-116.25192, 32.90417], [-116.25164, 32.90321], [-116.25392, 32.9032], [-116.25361, 32.90223], [-116.25386, 32.90135], [-116.25576, 32.90135], [-116.2564, 32.89865], [-116.25624, 32.89865], [-116.25241, 32.89876], [-116.25186, 32.90049], [-116.25072, 32.90048], [-116.2502, 32.90222], [-116.24565, 32.90219], [-116.24631, 32.90054], [-116.24631, 32.90053], [-116.24431, 32.90053], [-116.24332, 32.90055], [-116.24432, 32.89903], [-116.24326, 32.89904], [-116.24258, 32.89906], [-116.2432, 32.89834], [-116.24319, 32.89832], [-116.24145, 32.8984], [-116.24364, 32.89624], [-116.24307, 32.88895], [-116.25937, 32.88771], [-116.26766, 32.88771], [-116.26769, 32.88035], [-116.27647, 32.88034], [-116.27662, 32.87291], [-116.28467, 32.87296], [-116.2849, 32.86581], [-116.29333, 32.86583], [-116.29345, 32.85844], [-116.3098, 32.85835], [-116.30973, 32.87302], [-116.31816, 32.87309], [-116.31817, 32.867], [-116.31815, 32.8585], [-116.32221, 32.85857], [-116.32221, 32.85492], [-116.32649, 32.855], [-116.32647, 32.85145], [-116.32647, 32.85134], [-116.32648, 32.85133], [-116.33485, 32.85122], [-116.33475, 32.84395], [-116.33475, 32.83514], [-116.33478, 32.82959], [-116.32643, 32.82955], [-116.32638, 32.82191], [-116.32638, 32.82083], [-116.32624, 32.81499], [-116.32632, 32.81498], [-116.32632, 32.81133], [-116.33045, 32.81132], [-116.33045, 32.80785], [-116.33048, 32.80459], [-116.33048, 32.80011], [-116.33465, 32.80012], [-116.33477, 32.79654], [-116.3305, 32.79647], [-116.32634, 32.79643], [-116.31786, 32.79652], [-116.31781, 32.80012], [-116.30945, 32.80013], [-116.30906, 32.78484], [-116.309, 32.78189], [-116.29596, 32.78184], [-116.29604, 32.78534], [-116.29173, 32.7853], [-116.29173, 32.79643], [-116.29602, 32.79642], [-116.29602, 32.80007], [-116.30504, 32.80012], [-116.30509, 32.8068], [-116.30512, 32.80759], [-116.30959, 32.80762], [-116.30952, 32.80388], [-116.3142, 32.80388], [-116.31787, 32.80387], [-116.31792, 32.80767], [-116.31804, 32.81498], [-116.31805, 32.81501], [-116.31119, 32.81504], [-116.31117, 32.81503], [-116.30975, 32.81504], [-116.30984, 32.82205], [-116.30995, 32.82949], [-116.29178, 32.82945], [-116.27388, 32.82934], [-116.26512, 32.82922], [-116.25591, 32.8292], [-116.23785, 32.82939], [-116.21986, 32.82994], [-116.21963, 32.81437], [-116.21996, 32.80879], [-116.22002, 32.80739], [-116.22047, 32.79961], [-116.22098, 32.78493], [-116.22101, 32.78367], [-116.22143, 32.77193], [-116.22218, 32.75548], [-116.22271, 32.74096], [-116.2228, 32.72635], [-116.22279, 32.72634], [-116.20879, 32.72661], [-116.20818, 32.71903], [-116.20772, 32.71218], [-116.20914, 32.69754], [-116.20816, 32.68279], [-116.20837, 32.66849], [-116.22577, 32.66803], [-116.22572, 32.6643], [-116.23619, 32.66435], [-116.2427, 32.6644], [-116.24274, 32.66648], [-116.24269, 32.66816], [-116.23847, 32.66812], [-116.23842, 32.67171], [-116.2297, 32.67166], [-116.22961, 32.67522], [-116.23837, 32.6753], [-116.23834, 32.67891], [-116.24236, 32.67887], [-116.24223, 32.68251], [-116.2428, 32.68893], [-116.24759, 32.68892], [-116.24761, 32.68987], [-116.25117, 32.68988], [-116.25564, 32.68994], [-116.2557, 32.69353], [-116.2596, 32.69355], [-116.25959, 32.69716], [-116.25975, 32.69717], [-116.25973, 32.70118], [-116.25972, 32.7117], [-116.26004, 32.72231], [-116.26404, 32.72234], [-116.26372, 32.712], [-116.2638, 32.70148], [-116.26787, 32.7015], [-116.26779, 32.71231], [-116.27583, 32.7129], [-116.2845, 32.71346], [-116.28447, 32.70619], [-116.28892, 32.70644], [-116.28902, 32.72087], [-116.29304, 32.72127], [-116.29372, 32.72392], [-116.28948, 32.72369], [-116.29001, 32.72632], [-116.28772, 32.72628], [-116.28753, 32.74113], [-116.28323, 32.74111], [-116.28319, 32.74482], [-116.28746, 32.74486], [-116.28748, 32.74858], [-116.29181, 32.74862], [-116.29176, 32.7524], [-116.28735, 32.75239], [-116.28726, 32.75969], [-116.28294, 32.75966], [-116.28289, 32.76331], [-116.28719, 32.76337], [-116.28715, 32.76705], [-116.29146, 32.76707], [-116.29577, 32.76712], [-116.29602, 32.75234], [-116.30028, 32.75239], [-116.30037, 32.74871], [-116.30468, 32.74874], [-116.3046, 32.75237], [-116.309, 32.75241], [-116.30886, 32.75608], [-116.30888, 32.7598], [-116.30448, 32.7598], [-116.30445, 32.76346], [-116.30889, 32.76351], [-116.30888, 32.76388], [-116.30882, 32.77045], [-116.31762, 32.77043], [-116.31764, 32.77081], [-116.32646, 32.77077], [-116.34367, 32.77083], [-116.34519, 32.77085], [-116.36094, 32.77096], [-116.36111, 32.78557], [-116.37719, 32.78545], [-116.37713, 32.80027], [-116.37719, 32.80388], [-116.37731, 32.80389], [-116.37731, 32.80393], [-116.3774, 32.81499], [-116.35951, 32.81488], [-116.35965, 32.82361], [-116.35966, 32.82567], [-116.35973, 32.8296], [-116.35965, 32.84386], [-116.35996, 32.85259], [-116.36009, 32.85588], [-116.36018, 32.85848], [-116.3638, 32.85848], [-116.37737, 32.85851], [-116.37761, 32.86577], [-116.38628, 32.86576], [-116.40816, 32.86569], [-116.40837, 32.88016], [-116.40847, 32.88017], [-116.40849, 32.8804], [-116.41275, 32.88044], [-116.41288, 32.88743], [-116.41289, 32.89068], [-116.41305, 32.90203], [-116.41254, 32.91668], [-116.43015, 32.91675], [-116.43099, 32.90197], [-116.448, 32.90176], [-116.44737, 32.91795], [-116.44708, 32.92354], [-116.44681, 32.93173], [-116.44683, 32.93183], [-116.46435, 32.93191], [-116.46564, 32.94673], [-116.48246, 32.94679], [-116.48381, 32.96218]], [[-116.26998, 32.75208], [-116.27009, 32.74863], [-116.27023, 32.74098], [-116.26592, 32.74092], [-116.26637, 32.72597], [-116.26013, 32.72587], [-116.24232, 32.72634], [-116.24226, 32.72267], [-116.23362, 32.7227], [-116.23364, 32.72636], [-116.23996, 32.7264], [-116.23994, 32.72997], [-116.24932, 32.72986], [-116.25764, 32.72966], [-116.26192, 32.7297], [-116.2615, 32.74087], [-116.26143, 32.74462], [-116.26577, 32.74471], [-116.26563, 32.75202], [-116.26998, 32.75208]], [[-116.25858, 32.78321], [-116.25857, 32.7832], [-116.25759, 32.78319], [-116.25636, 32.7832], [-116.25631, 32.78499], [-116.25842, 32.785], [-116.25849, 32.78499], [-116.25858, 32.78321]], [[-116.25862, 32.78138], [-116.25869, 32.77955], [-116.25647, 32.77955], [-116.25641, 32.78137], [-116.25862, 32.78138]], [[-116.27229, 32.89313], [-116.27759, 32.89311], [-116.27813, 32.88959], [-116.26988, 32.88961], [-116.26982, 32.88997], [-116.26938, 32.89313], [-116.25782, 32.89313], [-116.25679, 32.89314], [-116.25689, 32.8951], [-116.25699, 32.89623], [-116.25786, 32.89625], [-116.26532, 32.89625], [-116.27181, 32.89624], [-116.27229, 32.89313]], [[-116.27173, 32.77782], [-116.26871, 32.77778], [-116.2609, 32.77773], [-116.26084, 32.77892], [-116.26068, 32.78319], [-116.26152, 32.7832], [-116.26285, 32.78319], [-116.26297, 32.77954], [-116.27165, 32.77957], [-116.27173, 32.77782]], [[-116.26758, 32.77231], [-116.26763, 32.77053], [-116.26547, 32.77051], [-116.26539, 32.77232], [-116.26756, 32.77235], [-116.26758, 32.77231]], [[-116.2693, 32.78496], [-116.26931, 32.78498], [-116.27147, 32.78495], [-116.2715, 32.78442], [-116.27153, 32.78319], [-116.26936, 32.78319], [-116.2693, 32.78496]], [[-116.27407, 32.77243], [-116.27413, 32.7706], [-116.26981, 32.77055], [-116.26968, 32.77416], [-116.27184, 32.77419], [-116.27191, 32.7724], [-116.27407, 32.77243]], [[-116.27173, 32.7778], [-116.27174, 32.77781], [-116.27389, 32.77782], [-116.27396, 32.77636], [-116.27396, 32.77602], [-116.27179, 32.776], [-116.27173, 32.7778]], [[-116.30961, 32.80762], [-116.3096, 32.80763], [-116.30961, 32.80847], [-116.30968, 32.81136], [-116.31385, 32.81136], [-116.31377, 32.80764], [-116.30961, 32.80762]], [[-116.34805, 32.77823], [-116.35256, 32.77828], [-116.35249, 32.7746], [-116.34372, 32.77443], [-116.34386, 32.78559], [-116.34829, 32.78571], [-116.34805, 32.77823]], [[-116.44707, 32.93406], [-116.4468, 32.93174], [-116.43823, 32.93171], [-116.43839, 32.92768], [-116.43852, 32.92422], [-116.43429, 32.92421], [-116.43418, 32.928], [-116.42981, 32.92795], [-116.43004, 32.92049], [-116.42563, 32.92047], [-116.42549, 32.92796], [-116.42112, 32.92792], [-116.42108, 32.93167], [-116.4297, 32.93169], [-116.42999, 32.939], [-116.43878, 32.93907], [-116.43852, 32.93531], [-116.44721, 32.93536], [-116.44707, 32.93406]]], [[[-116.26229, 32.6829], [-116.25995, 32.68265], [-116.25998, 32.68037], [-116.2618, 32.68229], [-116.26204, 32.68256], [-116.26229, 32.6829]]], [[[-116.27244, 32.68032], [-116.27221, 32.68399], [-116.26253, 32.68292], [-116.26228, 32.68258], [-116.26199, 32.68222], [-116.25997, 32.6801], [-116.26, 32.67533], [-116.26843, 32.6761], [-116.26827, 32.67985], [-116.27244, 32.68032]]], [[[-116.28465, 32.69528], [-116.28446, 32.69894], [-116.28446, 32.70247], [-116.27996, 32.70243], [-116.28006, 32.69879], [-116.2803, 32.69523], [-116.28465, 32.69528]]], [[[-116.30488, 32.79272], [-116.29605, 32.7927], [-116.29605, 32.78908], [-116.30038, 32.78907], [-116.3004, 32.7854], [-116.30475, 32.78546], [-116.30488, 32.79272]]], [[[-116.32631, 32.80758], [-116.32208, 32.80759], [-116.32206, 32.80386], [-116.32631, 32.80387], [-116.32631, 32.80758]]]]} | Open Access 1 | 12485 | McCain Valley National Cooperative Land and Wildlife Management Area | 32363 | 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 Diego 4 | 75811.419 | McCain Valley Nat. Cooperative Land and WMA | 1961 | Conservation Area 13 | 2 |
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]);