units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 3, AGNCY_TYP = 1 and UNIT_NAME = "BLM"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11190 | 11190 | 11189 | {"type": "MultiPolygon", "coordinates": [[[[-121.40216, 38.2541], [-121.40126, 38.25502], [-121.40116, 38.25575], [-121.40069, 38.25609], [-121.3998, 38.25771], [-121.39915, 38.25819], [-121.39865, 38.25957], [-121.39866, 38.26069], [-121.39827, 38.26167], [-121.39776, 38.2621], [-121.38884, 38.26208], [-121.38883, 38.26162], [-121.38448, 38.26161], [-121.38449, 38.25917], [-121.38527, 38.25893], [-121.38612, 38.25886], [-121.38745, 38.25829], [-121.38815, 38.25765], [-121.38989, 38.25736], [-121.39053, 38.25736], [-121.3912, 38.25765], [-121.39282, 38.25793], [-121.39308, 38.25788], [-121.39308, 38.25765], [-121.39282, 38.25733], [-121.3905, 38.25651], [-121.38971, 38.25633], [-121.3894, 38.25639], [-121.3889, 38.25681], [-121.38841, 38.25699], [-121.38765, 38.25708], [-121.38738, 38.25722], [-121.38739, 38.25646], [-121.38958, 38.25602], [-121.38959, 38.25578], [-121.38863, 38.2534], [-121.38868, 38.2534], [-121.38887, 38.25353], [-121.38971, 38.25353], [-121.39006, 38.2536], [-121.3905, 38.25363], [-121.39077, 38.25374], [-121.39143, 38.25395], [-121.39239, 38.25411], [-121.39325, 38.25386], [-121.39395, 38.25371], [-121.39523, 38.25349], [-121.39524, 38.25348], [-121.39464, 38.2514], [-121.39716, 38.25142], [-121.40076, 38.25368], [-121.40216, 38.2541]]], [[[-121.43885, 38.2758], [-121.42582, 38.27583], [-121.42579, 38.26864], [-121.42183, 38.26861], [-121.4211, 38.26875], [-121.42111, 38.26869], [-121.4208, 38.26844], [-121.42068, 38.26794], [-121.42065, 38.26748], [-121.42074, 38.26732], [-121.42117, 38.26716], [-121.42123, 38.267], [-121.41981, 38.2667], [-121.4197, 38.26661], [-121.41978, 38.26629], [-121.4199, 38.26618], [-121.42053, 38.26606], [-121.42059, 38.26595], [-121.42039, 38.26572], [-121.41993, 38.2656], [-121.41975, 38.26549], [-121.41973, 38.26515], [-121.41984, 38.26491], [-121.41981, 38.26391], [-121.42016, 38.2632], [-121.42022, 38.26286], [-121.42002, 38.2626], [-121.42004, 38.26219], [-121.42199, 38.26167], [-121.4221, 38.26176], [-121.42217, 38.26217], [-121.42237, 38.26226], [-121.42263, 38.2622], [-121.42286, 38.26178], [-121.42286, 38.26155], [-121.42228, 38.26121], [-121.42245, 38.26103], [-121.42356, 38.2608], [-121.4242, 38.26048], [-121.4244, 38.26068], [-121.42446, 38.26133], [-121.42491, 38.26134], [-121.42481, 38.26014], [-121.42471, 38.26004], [-121.42541, 38.26004], [-121.42533, 38.26134], [-121.42415, 38.26368], [-121.42502, 38.26479], [-121.42578, 38.2663], [-121.42579, 38.26863], [-121.42926, 38.26865], [-121.42942, 38.27299], [-121.43357, 38.27302], [-121.43363, 38.26943], [-121.43453, 38.26943], [-121.43437, 38.26969], [-121.43427, 38.27002], [-121.43427, 38.27018], [-121.43428, 38.27024], [-121.43435, 38.27034], [-121.4344, 38.27039], [-121.43453, 38.27047], [-121.43466, 38.27052], [-121.4349, 38.27054], [-121.43511, 38.27053], [-121.43528, 38.27049], [-121.43552, 38.27038], [-121.43581, 38.27022], [-121.43605, 38.27006], [-121.43619, 38.26994], [-121.43667, 38.26944], [-121.43707, 38.26944], [-121.4382, 38.27258], [-121.4384, 38.27321], [-121.43856, 38.27385], [-121.43865, 38.27427], [-121.43874, 38.27489], [-121.43885, 38.2758]]], [[[-121.43942, 38.28138], [-121.43684, 38.28205], [-121.43527, 38.28275], [-121.43333, 38.28271], [-121.43176, 38.28299], [-121.42897, 38.2828], [-121.41985, 38.28275], [-121.4198, 38.27601], [-121.43887, 38.27596], [-121.43905, 38.27755], [-121.43898, 38.27757], [-121.43917, 38.27919], [-121.43925, 38.27919], [-121.4394, 38.28055], [-121.43933, 38.28057], [-121.43942, 38.28138]]], [[[-121.45645, 38.2843], [-121.44742, 38.28424], [-121.4474, 38.28046], [-121.4453, 38.27972], [-121.44396, 38.28036], [-121.44049, 38.28156], [-121.44005, 38.28144], [-121.43987, 38.27976], [-121.43927, 38.27464], [-121.43916, 38.27399], [-121.43906, 38.27355], [-121.43894, 38.27309], [-121.43867, 38.27217], [-121.43862, 38.2719], [-121.43861, 38.27152], [-121.43867, 38.27108], [-121.43873, 38.27087], [-121.43883, 38.2706], [-121.44011, 38.26786], [-121.44049, 38.26766], [-121.44058, 38.26759], [-121.44081, 38.26731], [-121.44106, 38.26695], [-121.44118, 38.26672], [-121.4413, 38.26638], [-121.4416, 38.2654], [-121.44165, 38.2651], [-121.44166, 38.26494], [-121.44163, 38.26463], [-121.44155, 38.26425], [-121.44145, 38.26394], [-121.44129, 38.26355], [-121.44349, 38.26372], [-121.44468, 38.26306], [-121.44976, 38.2654], [-121.45098, 38.26503], [-121.45122, 38.26501], [-121.45539, 38.27586], [-121.45569, 38.27669], [-121.45589, 38.27735], [-121.45613, 38.27834], [-121.457, 38.28251], [-121.457, 38.2827], [-121.45699, 38.28298], [-121.45694, 38.28325], [-121.45688, 38.28347], [-121.45671, 38.28389], [-121.45659, 38.28409], [-121.45645, 38.2843]], [[-121.45258, 38.27746], [-121.45242, 38.27745], [-121.45201, 38.27789], [-121.45167, 38.27799], [-121.45129, 38.27815], [-121.45102, 38.27824], [-121.45068, 38.27824], [-121.45022, 38.2782], [-121.45007, 38.27822], [-121.45009, 38.27839], [-121.45002, 38.27852], [-121.44972, 38.27859], [-121.44958, 38.27858], [-121.44936, 38.27865], [-121.44874, 38.27878], [-121.44845, 38.27896], [-121.4483, 38.27916], [-121.44812, 38.27937], [-121.44786, 38.27945], [-121.44776, 38.27968], [-121.44763, 38.27985], [-121.44746, 38.27994], [-121.4474, 38.27996], [-121.44741, 38.28045], [-121.44747, 38.28046], [-121.44785, 38.28038], [-121.44812, 38.28022], [-121.44822, 38.28005], [-121.44839, 38.27991], [-121.44898, 38.27929], [-121.44935, 38.27898], [-121.44969, 38.27885], [-121.45014, 38.27879], [-121.4508, 38.27876], [-121.45162, 38.27865], [-121.45234, 38.27846], [-121.45327, 38.27806], [-121.45351, 38.27786], [-121.45371, 38.27763], [-121.45381, 38.27725], [-121.4539, 38.27703], [-121.45316, 38.27701], [-121.45307, 38.27714], [-121.45273, 38.27734], [-121.45258, 38.27746]]]]} | No Public Access 3 | 21461 | BLM | 16161 | 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 | Sacramento 41 | 1450.517 | BLM | 0 | National Public Lands 1 | 3 | |
| 13966 | 13966 | 13965 | {"type": "Polygon", "coordinates": [[[-121.48188, 38.33873], [-121.47585, 38.33896], [-121.47579, 38.33592], [-121.48187, 38.33587], [-121.48188, 38.33873]]]} | No Public Access 3 | 37013 | BLM | 16161 | 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 | Sacramento 41 | 42.907 | BLM | 0 | 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]);