Dataset: Recreation Opportunities (Feature Layer)

About this Dataset

Recreation Opportunities (Feature Layer)

This dataset contains the recreation opportunity information that the Forest Service collects through the Recreation Portal and shares with the public on https://www.recreation.gov, the Forest Service World Wide Web pages (https://www.fs.usda.gov/) and the Interactive Visitor Map. This recreation data contains detailed descriptions of recreational sites, areas, activities & facilities. This published dataset consists of one point feature class for recreational areas, one spatial view and three related tables such as activities, facilities & rec area advisories. The purpose of each related table is described below RECAREAACTIVITIES: This related table contains information about the activities that are associated with the rec area.RECAREAFACILITIES: This related table contains information about the amenities that are associated with the rec area. RECAREAADVISORIES: This table contains events, news, alerts and warnings that are associated with the rec area.RECAREAACTIVITIES_V: This spatial view/feature class is generated by joining the RECAREAACTIVITIES table to the RECREATION OPPORTUNITIES Feature Class. Please note that the RECAREAID is the unique identifier present in point feature class and in the related tables as well. The RECAREAID is used as foreign key to access relate records.This published data is updated nightly from an XML feed maintained by the CIO Rec Portal team. This data is intended for public use and distribution. Metadata
Organization: Department of Agriculture
Last updated: 2024-03-30T08:59:54.696852
Tags: areas, open-data, opportunities, rec, rec-sites, recreation, ridb, usfs

Tables

Table 1

@usgov.usda_gov_recreation_opportunities_feature_layer_69fe2.table_1

6.05 MB
14344 rows
27 columns


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "recareaname" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "recareaurl" VARCHAR,
  "open_season_start" VARCHAR,
  "open_season_end" VARCHAR,
  "forestname" VARCHAR,
  "recareaid" BIGINT,
  "shape" VARCHAR,
  "markertype" VARCHAR,
  "markeractivity" VARCHAR,
  "markeractivitygroup" VARCHAR,
  "recareadescription" VARCHAR,
  "recportal_unit_key" BIGINT,
  "forestorgcode" BIGINT,
  "objectid" BIGINT,
  "feedescription" VARCHAR,
  "operational_hours" VARCHAR,
  "reservation_info" VARCHAR,
  "restrictions" VARCHAR,
  "infra_cn" VARCHAR,
  "spotlightdisplay" VARCHAR,
  "attractiondisplay" VARCHAR,
  "accessibility" VARCHAR,
  "openstatus" VARCHAR
);