About this Dataset

GAOA Project Detail LN (Feature Layer)

This dataset contains the detailed information about the individual asset linear features such as roads and trails that make up Great American Outdoors Act (GAOA) projects. This data can be used together with the project summary data to display general project locations. The data is refreshed on a nightly basis from the US Forest Service database of infrastructure projects which is stewarded by the individual National Forests and Grasslands.\nFor more information about Forest Service GAOA projects visit our website: https://www.fs.usda.gov/managing-land/gaoa

Metadata and Downloads
Organization: Department of Agriculture
Last updated: 2024-03-30T10:45:49.452083
Tags: edw, gaoa, infra, namp, open-data, usfs

Tables

Table 1

@usgov.usda_gov_gaoa_project_detail_ln_feature_layer_42124.table_1

26.91 kB
13 rows
39 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "sec_id" BIGINT,
  "forest_name" VARCHAR,
  "mng_org" BIGINT,
  "region" BIGINT,
  "region_name" VARCHAR,
  "proj_id" VARCHAR,
  "proj_name" VARCHAR,
  "proj_type" VARCHAR,
  "proj_status" VARCHAR,
  "approval_status" VARCHAR,
  "approved_fy" VARCHAR,
  "planned_start" TIMESTAMP,
  "planned_finish" TIMESTAMP,
  "actual_start" TIMESTAMP,
  "actual_finish" TIMESTAMP,
  "asset_type" VARCHAR,
  "asset_id" VARCHAR,
  "asset_name" VARCHAR,
  "feature_type" VARCHAR,
  "feature_id" VARCHAR,
  "feature_name" VARCHAR,
  "task_type" VARCHAR,
  "state" VARCHAR,
  "county" VARCHAR,
  "st_cnty_code" VARCHAR,
  "congressional_district" VARCHAR,
  "st_district_code" VARCHAR,
  "lu_latitude" VARCHAR,
  "lu_longitude" VARCHAR,
  "feature_latitude" DOUBLE,
  "feature_longitude" DOUBLE,
  "proj_cn" BIGINT,
  "lu_cn" VARCHAR,
  "feature_cn" DOUBLE,
  "rte_cn" DOUBLE,
  "task_cn" BIGINT,
  "distinct_asset_flag" VARCHAR,
  "shapelen" VARCHAR
);