BLM Natl MLRS Mineral Materials
Department of the Interior
@usgov.doi_gov_blm_natl_mlrs_mineral_materials_b062b
Department of the Interior
@usgov.doi_gov_blm_natl_mlrs_mineral_materials_b062b
This dataset contains mineral materials cases derived from Legal Land Descriptions (LLD) contained in the US Bureau of Land Management's, BLM, Mineral and Land Record System(MLRS) and geocoded (mapped) using the Public Land Survey System (PLSS) derived from the most accurate survey data available through BLM Cadastral Survey workforce. Geospatial representations might be missing for some cases that can not be geocoded using the MLRS algorithm. Mineral materials include common varieties of sand, stone,gravel, pumice, pumicite, clay, rock, and semi-precious and non-precious gemstone. This data set contains cases within the case type groupings for mineral materials of exploration permit, nonexclusive sale, exclusive sale, and free use with the case disposition of 'Authorized', 'Pending','Closed', or 'Interim'.
Each case is given a data quality score based on how well it mapped. These can be lumped into seven groups to provide a simplified way to understand the scores.
CREATE TABLE table_1 (
"objectid" BIGINT,
"id" BIGINT,
"admin_state" VARCHAR,
"geo_state" VARCHAR,
"blm_prod" VARCHAR,
"cse_disp" VARCHAR,
"cse_type_nr" BIGINT,
"cse_nr" VARCHAR,
"leg_cse_nr" VARCHAR,
"cse_name" VARCHAR,
"cmmdty" VARCHAR,
"eff_dt" TIMESTAMP,
"exp_dt" VARCHAR,
"prdcng" VARCHAR,
"sale_dt" TIMESTAMP,
"cust_nm_sec" VARCHAR,
"pct_int_sec" DOUBLE,
"int_rel_sec" VARCHAR,
"cse_disp_dt" VARCHAR,
"src" VARCHAR,
"qlty" VARCHAR,
"cse_meta" VARCHAR,
"rcrd_acrs" DOUBLE,
"sf_id" VARCHAR,
"created" TIMESTAMP,
"modified" TIMESTAMP,
"shape_length" DOUBLE,
"shape_area" DOUBLE
);Anyone who has the link will be able to view this.