recreation_site_point

-1 rows


Description

Stores the location of a Recreation Site as a point geometry. The data is used to provide the public a map location of the Recreation Site.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
rec_resource_id varchar 10 null
recreation_map_feature_history.rec_resource_id Implied Constraint R
recreation_resource_docs_history.rec_resource_id Implied Constraint R
recreation_resource_images_history.rec_resource_id Implied Constraint R
recreation_site_point_history.rec_resource_id Implied Constraint R

Identification manually assigned to a Recreation Resource.
geometry geometry 2147483647 √ null

A point geometry location represented by a single X,Y pair
revision_count int4 10 √ null

A count of the number of times an entry in the entity has been modified. Used to validate if the current information displayed on a user"s web browser is the most current.
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)

Indexes

Constraint Name Type Sort Column(s)
recreation_site_point_pkey Primary key Asc rec_resource_id
recreation_site_point_rec_resource_id_geometry_key Must be unique Asc/Asc rec_resource_id + geometry

Relationships

Close relationships within degrees of separation