recreation_resource

-1 rows


Description

Resource information relating to a recreational file. A recreation file can have only one resource. A recreation resource must be of type Site, Reserve, Trail, or Interpretive Forest.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
rec_resource_id varchar 20 null
act_advisories_flat.rec_resource_id act_advisories_flat_rec_resource_id_fkey R
act_advisories_flat_history.rec_resource_id Implied Constraint R
recreation_access.rec_resource_id recreation_access_rec_resource_id_fkey R
recreation_access_history.rec_resource_id Implied Constraint R
recreation_activity.rec_resource_id recreation_activity_rec_resource_id_fkey R
recreation_activity_code_trails.rec_resource_id recreation_activity_code_trails_rec_resource_id_fkey R
recreation_activity_code_trails_history.rec_resource_id Implied Constraint R
recreation_agreement_holder.rec_resource_id recreation_agreement_holder_rec_resource_id_fkey R
recreation_defined_campsite.rec_resource_id recreation_defined_campsite_rec_resource_id_fkey R
recreation_driving_direction.rec_resource_id recreation_driving_direction_rec_resource_id_fkey R
recreation_establishment_order_docs.rec_resource_id recreation_establishment_order_docs_rec_resource_id_fkey R
recreation_feature.rec_resource_id recreation_feature_rec_resource_id_fkey R
recreation_feature_history.rec_resource_id Implied Constraint R
recreation_fee.rec_resource_id recreation_fee_rec_resource_id_fkey R
recreation_map_feature.rec_resource_id recreation_map_feature_rec_resource_id_fkey R
recreation_resource_document.rec_resource_id recreation_resource_document_rec_resource_id_fkey R
recreation_resource_history.rec_resource_id Implied Constraint R
recreation_resource_image.rec_resource_id recreation_resource_image_rec_resource_id_fkey R
recreation_resource_reservation_info.rec_resource_id recreation_resource_reservation_info_rec_resource_id_fkey R
recreation_resource_search_view.rec_resource_id Implied Constraint R
recreation_resource_type_view_admin.rec_resource_id Implied Constraint R
recreation_resource_type_view_public.rec_resource_id Implied Constraint R
recreation_site_description.rec_resource_id recreation_site_description_rec_resource_id_fkey R
recreation_status.rec_resource_id recreation_status_rec_resource_id_fkey R
recreation_structure.rec_resource_id recreation_structure_rec_resource_id_fkey R
recreation_structure_history.rec_resource_id Implied Constraint R

Identification manually assigned to a Recreation Resource.
name varchar 200 √ null

Name of the Recreation Project.
description text 2147483647 √ null

Field notes related to a recreation site. e.g. A managed, 11 unit site with 2WD access, gravel beach launch and a small float. Watch for hazards on the lake. This column is for internal use and is not a description for public use.
closest_community varchar 200 √ null

A text description generally describing the closest community or, for more isolated sites and trails, it could be a geographic feature to a recreation site or trail. e.g. VERNON, KELOWNA, PRINCE GEORGE.
display_on_public_site bool 1 √ false
district_code varchar 4 √ null
recreation_district_code.district_code recreation_resource_district_code_fkey R

A code indicating a recreation district boundary. EG Cascades, Chilliwack, Discovery Coast. Note: There are 17 Recreation District Boundaries, most of which have different geographical boundaries than Forest District Boundaries. Because of this, Rec District Boundary Codes are different from Forest District Boundary Codes.
maintenance_standard_code varchar 1 √ null
recreation_maintenance_standard_code.maintenance_standard_code recreation_resource_maintenance_standard_code_fkey R
updated_at timestamp 29,6 √ now()
updated_by text 2147483647 √ null
created_at timestamp 29,6 √ now()
created_by text 2147483647 √ null
sys_period tstzrange 2147483647 tstzrange(CURRENT_TIMESTAMP, NULL::timestamp with time zone)
project_established_date date 13 √ null

The date when the recreation project was officially established or created.
control_access_code varchar 1 √ null
recreation_control_access_code.recreation_control_access_code recreation_resource_control_access_code_fkey R

Describes the Controlled Access Code for a rec resource. E.g. “Gated”, “Restricted Use”.
risk_rating_code varchar 2 √ null
recreation_risk_rating_code.risk_rating_code recreation_resource_risk_rating_code_fkey R
right_of_way numeric 7,1 √ null

Identifies the Right of Way width for a linear feature. Sourced from fta.recreation_project.right_of_way.
rec_status_code varchar 50 √ null

Site status value for a recreation resource. Sourced from fta.recreation_file_status_code.file_status_st.
arch_impact_assess_ind varchar 1 √ null

Indicates if an archaeological impact assessment has been performed. Y or N. Sourced from fta.recreation_project.arch_impact_assess_ind.
resource_feature_ind varchar 1 √ 'N'::character varying

Indicates whether this is a resource feature established under the Government Action Regulation.

Indexes

Constraint Name Type Sort Column(s)
recreation_resource_pkey Primary key Asc rec_resource_id

Relationships

Close relationships within degrees of separation