About this Dataset

Other Sub Surface Right (Feature Layer)

An area depicting ownership parcels of the subsurface estate, excluding mineral rights; it is collected only if the subsurface estate is different than the overlying surface estate. Metadata
Organization: Department of Agriculture
Last updated: 2024-03-30T10:47:59.187247
Tags: alp-land-dataset, estate, land-status, lands-and-realty, nfs-lands, open-data, other-sub-surface-right, parcels, planning-cadastre, usda-forest-service

Tables

Table 1

@usgov.usda_gov_other_sub_surface_right_feature_layer_b4c58.table_1

18.27 KB
11 rows
21 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "subsurfacerightid" VARCHAR,
  "casename" VARCHAR,
  "localcaseid" VARCHAR,
  "caseclass" VARCHAR,
  "region" BIGINT,
  "righttype" VARCHAR,
  "rightname" VARCHAR,
  "statusmethod" VARCHAR,
  "actiondate" TIMESTAMP,
  "actionfiscalyear" DOUBLE,
  "actioncalyear" DOUBLE,
  "expirationdate" VARCHAR,
  "claimanttype" VARCHAR,
  "officialacres" DOUBLE,
  "gis_acres" DOUBLE,
  "minerals" VARCHAR,
  "comments" VARCHAR,
  "nfs_landunit_fk" VARCHAR,
  "shapearea" DOUBLE,
  "shapelen" DOUBLE
);