About this Dataset

GAOA Project Summary (Feature Layer)

This dataset displays the approximate location of US Forest Service, Great American Outdoors Act (GAOA) projects. 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. This dataset is a spatial data layer of points representing the approximate or general location where the project takes place. The point location is intended for use in small scale maps to indicate the general location of the projects across the country. The location data is maintained by staff on the individual National Forest or Grassland using the database of record. Because a project can be made up of many assets distributed across a land area, a single project location point will not always reflect the specific location and extent of the work in the project. The project detail data can be used to display the individual assets that make up the project. For 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:46.669949
Tags: edw, gaoa, infra, namp, open-data, usfs

Tables

Table 1

@usgov.usda_gov_gaoa_project_summary_feature_layer_173da.table_1

346.02 kB
1,039 rows
40 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "region" BIGINT,
  "region_name" VARCHAR,
  "security_id" BIGINT,
  "forest_name" VARCHAR,
  "managing_org" BIGINT,
  "org_name" VARCHAR,
  "admin_org" BIGINT,
  "proj_id" VARCHAR,
  "proj_name" VARCHAR,
  "proj_type" VARCHAR,
  "proj_status" VARCHAR,
  "approval_status" VARCHAR,
  "approved_fy" VARCHAR,
  "approved_date" TIMESTAMP,
  "planned_start_date" TIMESTAMP,
  "planned_finish_date" TIMESTAMP,
  "actual_start_date" TIMESTAMP,
  "actual_finish_date" TIMESTAMP,
  "delivery_method" VARCHAR,
  "proj_summary" VARCHAR,
  "asset_type" VARCHAR,
  "state_county" VARCHAR,
  "cong_dist" VARCHAR,
  "est_total_dm_retired" DOUBLE,
  "transp_dollars" DOUBLE,
  "non_transp_dollars" DOUBLE,
  "total_approved_dollars" DOUBLE,
  "total_dollars_expended" DOUBLE,
  "contract_dollars_obligated" DOUBLE,
  "agreement_dollars_obligated" DOUBLE,
  "budget_id" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "project_cn" BIGINT,
  "last_update" TIMESTAMP,
  "shape" VARCHAR,
  "est_pct_complete" BIGINT
);