units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where COUNTY = 57 and DES_TP = 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11188 | 11188 | 11187 | {"type": "MultiPolygon", "coordinates": [[[[-120.12268, 39.79105], [-120.12197, 39.79441], [-120.11723, 39.7944], [-120.11259, 39.79444], [-120.11261, 39.79814], [-120.10801, 39.79817], [-120.10796, 39.79458], [-120.10799, 39.79448], [-120.11258, 39.79444], [-120.11326, 39.79106], [-120.12268, 39.79105]]], [[[-120.1127, 39.80904], [-120.10814, 39.80905], [-120.10809, 39.80544], [-120.10819, 39.80543], [-120.11267, 39.80542], [-120.1127, 39.80904]]], [[[-120.19783, 39.76966], [-120.19776, 39.77326], [-120.19775, 39.7769], [-120.193, 39.77684], [-120.1931, 39.77324], [-120.18379, 39.77318], [-120.1791, 39.77304], [-120.17891, 39.77669], [-120.17421, 39.77661], [-120.17403, 39.78029], [-120.17397, 39.7839], [-120.16446, 39.78381], [-120.15482, 39.78366], [-120.15536, 39.7656], [-120.16037, 39.76565], [-120.16027, 39.76204], [-120.14542, 39.76185], [-120.14562, 39.75095], [-120.14113, 39.75094], [-120.14133, 39.74729], [-120.14132, 39.74728], [-120.13257, 39.74718], [-120.13246, 39.75092], [-120.13663, 39.75093], [-120.13657, 39.75464], [-120.13209, 39.75456], [-120.13195, 39.76181], [-120.13196, 39.76182], [-120.13643, 39.76183], [-120.13628, 39.76903], [-120.12741, 39.76885], [-120.12535, 39.76907], [-120.12525, 39.77276], [-120.12315, 39.77277], [-120.12056, 39.77286], [-120.12045, 39.7765], [-120.111, 39.77689], [-120.11062, 39.76595], [-120.11996, 39.76559], [-120.11922, 39.75109], [-120.12604, 39.75088], [-120.12605, 39.75092], [-120.12756, 39.75092], [-120.12769, 39.74991], [-120.12806, 39.7361], [-120.14648, 39.73655], [-120.14663, 39.7366], [-120.15117, 39.73663], [-120.15108, 39.73994], [-120.1509, 39.74367], [-120.15066, 39.74736], [-120.1554, 39.74745], [-120.1552, 39.7511], [-120.1504, 39.75103], [-120.15038, 39.75828], [-120.16509, 39.75849], [-120.18402, 39.75864], [-120.18413, 39.76597], [-120.19331, 39.76603], [-120.19321, 39.76963], [-120.19783, 39.76966]], [[-120.12752, 39.75819], [-120.12751, 39.75817], [-120.12557, 39.75815], [-120.12549, 39.76178], [-120.12744, 39.7618], [-120.12752, 39.75819]], [[-120.16518, 39.76932], [-120.16519, 39.76933], [-120.16987, 39.7694], [-120.17007, 39.76579], [-120.16538, 39.76571], [-120.16518, 39.76932]]], [[[-120.14051, 39.8197], [-120.1405, 39.8235], [-120.13596, 39.8235], [-120.13577, 39.8307], [-120.13094, 39.83062], [-120.13084, 39.83782], [-120.12618, 39.83802], [-120.1264, 39.8235], [-120.12636, 39.81611], [-120.13578, 39.81616], [-120.13577, 39.8197], [-120.14051, 39.8197]]], [[[-120.17921, 39.75495], [-120.16503, 39.75491], [-120.16022, 39.75487], [-120.16061, 39.75139], [-120.16071, 39.74393], [-120.15577, 39.74375], [-120.15598, 39.73999], [-120.15608, 39.73666], [-120.1654, 39.73672], [-120.16562, 39.72926], [-120.17519, 39.72948], [-120.17522, 39.73669], [-120.17502, 39.74366], [-120.1745, 39.7513], [-120.17913, 39.7513], [-120.17921, 39.75495]]], [[[-120.18442, 39.72236], [-120.17498, 39.72228], [-120.17488, 39.71505], [-120.18434, 39.71516], [-120.18442, 39.72236]]], [[[-120.21093, 39.84939], [-120.21088, 39.85301], [-120.20152, 39.85289], [-120.20159, 39.84567], [-120.20172, 39.83845], [-120.19697, 39.83841], [-120.19223, 39.83841], [-120.19229, 39.83105], [-120.1827, 39.83092], [-120.18278, 39.82378], [-120.18756, 39.82381], [-120.18751, 39.82738], [-120.2065, 39.82753], [-120.20638, 39.83847], [-120.20623, 39.84933], [-120.21093, 39.84939]]], [[[-120.21313, 39.999], [-120.21311, 40.00267], [-120.21194, 40.00265], [-120.21073, 40.00266], [-120.21073, 40.00079], [-120.20836, 40.00078], [-120.20836, 40.00265], [-120.206, 40.00262], [-120.20127, 40.00263], [-120.20125, 39.99893], [-120.20537, 40.00075], [-120.20554, 40.00012], [-120.20601, 39.99958], [-120.20602, 40.0], [-120.21073, 40.00001], [-120.21075, 39.99898], [-120.21313, 39.999]]], [[[-120.22844, 40.0855], [-120.21422, 40.08592], [-120.21419, 40.07861], [-120.20955, 40.07867], [-120.20948, 40.07127], [-120.22822, 40.07121], [-120.22844, 40.0855]]], [[[-120.22025, 40.00271], [-120.21429, 40.00268], [-120.21431, 39.99901], [-120.21555, 39.99902], [-120.21554, 39.99913], [-120.21578, 39.99919], [-120.21717, 39.99977], [-120.21791, 39.99993], [-120.21905, 40.00071], [-120.21936, 40.00071], [-120.2196, 40.0008], [-120.21989, 40.00062], [-120.22014, 40.00007], [-120.21981, 39.99946], [-120.22025, 39.99946], [-120.22025, 40.00271]]], [[[-120.23949, 39.83894], [-120.2393, 39.84611], [-120.23934, 39.85333], [-120.22513, 39.85318], [-120.22516, 39.83866], [-120.22054, 39.83856], [-120.21572, 39.83853], [-120.21581, 39.83489], [-120.22056, 39.83491], [-120.2206, 39.8313], [-120.23477, 39.8315], [-120.23462, 39.83884], [-120.23949, 39.83894]]], [[[-120.2721, 39.83518], [-120.27204, 39.83878], [-120.25797, 39.83893], [-120.24859, 39.83894], [-120.24871, 39.83156], [-120.26274, 39.83153], [-120.26271, 39.8352], [-120.26741, 39.83524], [-120.2721, 39.83518]]], [[[-120.30978, 39.83532], [-120.30978, 39.8389], [-120.30497, 39.83888], [-120.30497, 39.83541], [-120.30978, 39.83532]]], [[[-120.34306, 39.84995], [-120.34304, 39.85356], [-120.33358, 39.85345], [-120.32403, 39.85339], [-120.32412, 39.84608], [-120.32414, 39.83891], [-120.32417, 39.83515], [-120.33346, 39.83521], [-120.3383, 39.83531], [-120.33829, 39.839], [-120.33831, 39.84987], [-120.34306, 39.84995]]], [[[-120.40733, 39.85028], [-120.40721, 39.85427], [-120.3982, 39.85382], [-120.3892, 39.85344], [-120.38929, 39.84991], [-120.38453, 39.8499], [-120.38451, 39.84628], [-120.37522, 39.84632], [-120.37535, 39.84261], [-120.38903, 39.84266], [-120.40283, 39.84291], [-120.40279, 39.85025], [-120.40733, 39.85028]]], [[[-120.39009, 39.72677], [-120.38997, 39.73416], [-120.38991, 39.75221], [-120.38537, 39.75222], [-120.38537, 39.74853], [-120.38542, 39.74492], [-120.3808, 39.74488], [-120.38079, 39.74125], [-120.37603, 39.74124], [-120.37605, 39.7404], [-120.37605, 39.73754], [-120.37772, 39.73761], [-120.38073, 39.73764], [-120.38075, 39.73543], [-120.38078, 39.73404], [-120.38537, 39.73409], [-120.3855, 39.72672], [-120.39009, 39.72677]]], [[[-120.39407, 39.8391], [-120.3889, 39.83901], [-120.38905, 39.83542], [-120.39404, 39.83547], [-120.39407, 39.8391]]], [[[-120.39891, 39.80307], [-120.39886, 39.8067], [-120.39422, 39.80663], [-120.39427, 39.80299], [-120.39891, 39.80307]]], [[[-120.40821, 39.80318], [-120.40806, 39.8105], [-120.40344, 39.81042], [-120.4036, 39.80314], [-120.40821, 39.80318]]], [[[-120.54739, 39.77393], [-120.54736, 39.78075], [-120.54192, 39.78063], [-120.53819, 39.78072], [-120.53777, 39.77374], [-120.54739, 39.77393]]], [[[-120.74597, 40.05213], [-120.74439, 40.05255], [-120.74467, 40.05442], [-120.74076, 40.05728], [-120.74076, 40.05619], [-120.74051, 40.05619], [-120.74042, 40.05548], [-120.73812, 40.05566], [-120.73803, 40.05355], [-120.73645, 40.05192], [-120.7376, 40.05036], [-120.73729, 40.04809], [-120.73941, 40.04774], [-120.73956, 40.04874], [-120.73957, 40.04875], [-120.7433, 40.04633], [-120.74369, 40.04846], [-120.74551, 40.04811], [-120.74597, 40.05213]], [[-120.73847, 40.05184], [-120.73847, 40.05185], [-120.74006, 40.0529], [-120.73974, 40.05019], [-120.73972, 40.05019], [-120.73847, 40.05184]]], [[[-120.77651, 40.02208], [-120.77524, 40.02339], [-120.77126, 40.02098], [-120.7725, 40.01966], [-120.77651, 40.02208]]], [[[-120.8016, 39.90925], [-120.79261, 39.90921], [-120.79261, 39.90921], [-120.79357, 39.90739], [-120.79682, 39.90784], [-120.79972, 39.90827], [-120.8016, 39.90925]]], [[[-120.86851, 40.14695], [-120.8685, 40.14878], [-120.86386, 40.14879], [-120.86388, 40.14696], [-120.86851, 40.14695]]], [[[-120.90125, 40.11633], [-120.9012, 40.12016], [-120.90121, 40.12351], [-120.89645, 40.1235], [-120.89659, 40.11627], [-120.90125, 40.11633]]], [[[-120.92911, 40.10299], [-120.92911, 40.10525], [-120.92433, 40.10523], [-120.92424, 40.102], [-120.91521, 40.10205], [-120.91517, 40.09959], [-120.91564, 40.09984], [-120.9167, 40.09852], [-120.91736, 40.09894], [-120.9176, 40.09903], [-120.9179, 40.09907], [-120.91839, 40.09909], [-120.91862, 40.09916], [-120.91864, 40.09938], [-120.91881, 40.10063], [-120.91917, 40.10086], [-120.91965, 40.10086], [-120.91969, 40.10115], [-120.92297, 40.10122], [-120.92304, 40.10053], [-120.92546, 40.10196], [-120.92607, 40.1014], [-120.92911, 40.10299]]], [[[-121.05166, 40.24188], [-121.05157, 40.2453], [-121.04158, 40.24533], [-121.04159, 40.24193], [-121.05166, 40.24188]]], [[[-121.06555, 40.37647], [-121.0655, 40.38035], [-121.06092, 40.38045], [-121.06102, 40.37652], [-121.06555, 40.37647]]], [[[-121.07978, 40.37311], [-121.0797, 40.38045], [-121.07018, 40.38047], [-121.07044, 40.373], [-121.07978, 40.37311]]], [[[-121.18523, 40.3322], [-121.1804, 40.33235], [-121.18037, 40.33429], [-121.17527, 40.33429], [-121.17515, 40.3307], [-121.17513, 40.33069], [-121.17516, 40.33429], [-121.17511, 40.33607], [-121.16102, 40.33627], [-121.15583, 40.33636], [-121.15592, 40.32905], [-121.16088, 40.32888], [-121.1751, 40.32878], [-121.17508, 40.32521], [-121.18, 40.32514], [-121.17996, 40.32865], [-121.18503, 40.32878], [-121.18523, 40.3322]]], [[[-121.22778, 40.3433], [-121.22266, 40.34335], [-121.22261, 40.34327], [-121.22262, 40.3431], [-121.22272, 40.3429], [-121.2228, 40.34268], [-121.2226, 40.34246], [-121.22225, 40.34252], [-121.22182, 40.34249], [-121.22131, 40.3424], [-121.22097, 40.34239], [-121.22034, 40.34243], [-121.21973, 40.34251], [-121.2195, 40.3425], [-121.21929, 40.3424], [-121.21919, 40.34228], [-121.21901, 40.34199], [-121.21891, 40.34172], [-121.21887, 40.34147], [-121.21877, 40.34128], [-121.21874, 40.34107], [-121.2188, 40.34068], [-121.21876, 40.34038], [-121.21861, 40.34019], [-121.21849, 40.34009], [-121.21847, 40.33975], [-121.22771, 40.33967], [-121.22778, 40.3433]]], [[[-121.22748, 40.3324], [-121.22737, 40.33607], [-121.21879, 40.33613], [-121.21875, 40.3324], [-121.22285, 40.33249], [-121.22748, 40.3324]]], [[[-121.22785, 40.35069], [-121.22329, 40.35074], [-121.22327, 40.3471], [-121.22773, 40.34702], [-121.22785, 40.35069]]]]} | Open Access 1 | 21453 | 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 | Plumas 57 | 10864.052 | 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]);