About this Dataset

GAOA Project Detail PT (Feature Layer)

This dataset contains the detailed information about the individual asset point features such as recreation sites, that make up Great American Outdoors Act (GAOA) projects. This data can be used together with the project summary data to display general project and asset 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:50:39.440141
Tags: edw, gaoa, infra, namp, open-data, usfs

Tables

Table 1

@usgov.usda_gov_gaoa_project_detail_pt_feature_layer_f5205.table_1

843.33 kB
14,317 rows
41 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "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" DOUBLE,
  "congressional_district" DOUBLE,
  "st_district_code" DOUBLE,
  "lu_latitude" DOUBLE,
  "lu_longitude" DOUBLE,
  "feature_latitude" DOUBLE,
  "feature_longitude" DOUBLE,
  "proj_cn" BIGINT,
  "lu_cn" DOUBLE,
  "feature_cn" DOUBLE,
  "rte_cn" VARCHAR,
  "task_cn" BIGINT,
  "distinct_asset_flag" VARCHAR,
  "shape" VARCHAR
);