About this Dataset

Recreation Sites (Feature Layer)

This dataset shows information about the USDA Forest Service constructed recreation sites used to populate the public facing webpages. This information is the descriptive and qualitative information used to set appropriate expectations for visitor use and may not contain all the exact engineering, constructed features. View Metadata.
Organization: Department of Agriculture
Last updated: 2024-03-30T10:48:23.477952
Tags: environment, open-data, recreation, usda-forest-service

Tables

Table 1

@usgov.usda_gov_recreation_sites_feature_layer.table_1

9.9 MB
31,684 rows
138 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "site_cn" DOUBLE,
  "root_cn" DOUBLE,
  "parent_cn" DOUBLE,
  "region" BIGINT,
  "security_id" BIGINT,
  "managing_org" BIGINT,
  "site_id" VARCHAR,
  "site_name" VARCHAR,
  "site_subtype" VARCHAR,
  "development_status" VARCHAR,
  "development_scale" DOUBLE,
  "poss_id" DOUBLE,
  "nrrs_id" DOUBLE,
  "total_capacity" DOUBLE,
  "fee_charged" VARCHAR,
  "fee_type" VARCHAR,
  "recarea_name" VARCHAR,
  "recarea_enable" VARCHAR,
  "recarea_description" VARCHAR,
  "recarea_status" VARCHAR,
  "parent_recarea" VARCHAR,
  "information_center" VARCHAR,
  "current_conditions" VARCHAR,
  "official_designation" VARCHAR,
  "fee_description" VARCHAR,
  "operational_hours" VARCHAR,
  "open_season" VARCHAR,
  "best_season" VARCHAR,
  "busiest_season" VARCHAR,
  "usage_level" VARCHAR,
  "pack_in_out" VARCHAR,
  "public_site_name" VARCHAR,
  "alias_name" VARCHAR,
  "alternative_name" VARCHAR,
  "site_address" VARCHAR,
  "mailing_address" VARCHAR,
  "physical_address" VARCHAR,
  "address_line1" VARCHAR,
  "address_line2" VARCHAR,
  "address_city" VARCHAR,
  "address_state" VARCHAR,
  "address_zip_code" DOUBLE,
  "address_zip_code4" VARCHAR,
  "site_directions" VARCHAR,
  "site_phone_nbr" DOUBLE,
  "site_email_address" VARCHAR,
  "rec1stop_url" VARCHAR,
  "usda_portal_url" VARCHAR,
  "site_time_zone" VARCHAR,
  "important_info" VARCHAR,
  "site_contact_notes" VARCHAR,
  "rentals_and_guides" VARCHAR,
  "passes" VARCHAR,
  "permit_information" VARCHAR,
  "restrictions" VARCHAR,
  "closest_towns" VARCHAR,
  "states_spanned" VARCHAR,
  "water_availability" VARCHAR,
  "restroom_availability" VARCHAR,
  "operated_by" VARCHAR,
  "season_description" VARCHAR,
  "directions" VARCHAR,
  "maximum_elevation" VARCHAR,
  "minimum_elevation" VARCHAR,
  "activity_type" VARCHAR,
  "activity_type_count" BIGINT,
  "activity_types" VARCHAR,
  "activities_distance_from_site" VARCHAR,
  "service_type" VARCHAR,
  "services_distance_from_site" VARCHAR,
  "alerts_description" VARCHAR,
  "alerts_start_date" TIMESTAMP,
  "alerts_end_date" TIMESTAMP,
  "closure_reason" VARCHAR,
  "unit_closure_description" VARCHAR,
  "unit_closure_start_date" VARCHAR,
  "unit_closure_end_date" VARCHAR,
  "site_opening_start_date" TIMESTAMP,
  "site_opening_end_date" TIMESTAMP,
  "season_name" VARCHAR,
  "site_season_start_date" TIMESTAMP,
  "site_season_end_date" TIMESTAMP,
  "unit_type" VARCHAR,
  "aba_accessible" VARCHAR,
  "capacity_size_rating" VARCHAR,
  "min_nbr_people" VARCHAR,
  "max_nbr_people" VARCHAR,
  "driveway_doublewide" VARCHAR,
  "driveway_entry" VARCHAR,
  "driveway_grade" VARCHAR,
  "driveway_length" VARCHAR,
  "driveway_surface" VARCHAR,
  "max_nbr_vehicles" VARCHAR,
  "max_vehicle_length" VARCHAR,
  "unit_length" VARCHAR,
  "unit_width" VARCHAR,
  "picnic_table" VARCHAR
);