Archaeology Sites Government Users View

557 views (8 recent)

Published by the Ministry of Forests, Lands, Natural Resource Operations and Rural Development - Archaeology
Licensed under Access Only

Polygon layer containing boundaries of known archaeological sites; Provincial extent; 'BORDENNUMBER' is the primary business key to record data; Polygons are region based features and can legally overlap. Accuracy field contains relative site accuracy, from GPS to Unknown - accuracy is on a poly by poly basis, no overall layer accuracy. Security: High - can be excepted from FOI; governed by the Heritage Conservation Act.

Data and Resources

Dataset Extent

Latitude: 48.0° to 60.0°
Longitude: -139.5° to -113.5°

Additional Information

Purpose

Location and extent of known archaeological sites in the Province in order to facilitate their protection.

Data Quality
Lineage Statement

More Information

Contact Information

NameDiana Cooper (pointOfContact)
EmailDiana.Cooper@gov.bc.ca
OrganizationMinistry of Forests, Lands, Natural Resource Operations and Rural Development
Sub-OrganizationArchaeology
NameCynthia Lake (pointOfContact)
Emailcynthia.r.lake@gov.bc.ca
OrganizationMinistry of Forests, Lands, Natural Resource Operations and Rural Development
Sub-OrganizationArchaeology

Access & Security

Who can view this dataset? Named users
Who can download this dataset?Named users

Metadata Information

Record Published 2014-12-15
Record Last Modified 2018-02-15
Resource Status completed

Object Description

Object Name: WHSE_ARCHAEOLOGY.RAAD_TFM_SITES_SVW

Short Name: RDTFMSTSSV
Comments: Spatial view containing boundaries of known archaeological sites; Provincial extent; BORDENNUMBER is the primary business key to record data; Polygons are region based features and can legally overlap. Accuracy field contains relative site accuracy, from GPS to Unknown - accuracy is on a poly by poly basis, no overall layer accuracy. Security: High - can be excepted from FOI; governed by the Heritage Conservation Act.

Column Name Short Name Data Type Data Precision Comments
BORDENNUMBER BORDENNUM VARCHAR2 13 BORDENNUMBER is a user maintained unique identification number. This is a primary key. In Canada, all archaeological sites are coded by what is known as the "Borden System". It assigns each location a sequence of 4 letters [DcRu] and a number [4] relating to a fixed map code. This is known as the Borden Number.
REGTY_SITECLASS CLASS VARCHAR2 4000 REGTY SITECLASS Indicates the site class. There are 5 options that can be chosen from a drop-down list to populate this column: Natural, Palaeontological, Postcontact, Precontact, and Traditional Use.
REGTY_TYPE TYPE VARCHAR2 4000 REGTY TYPE Indicates the site type. Choices available from a drop-down box are dependent on the SITECLASS column.
REGTY_SUBTYPE SUBTYPE VARCHAR2 4000 REGTY SUBTYPE Indicates the site subtype. Choices available from a drop-down box are dependent on the TYPE column.
REGTY_SITETYPEDESCRIPTOR DESCRIPTOR VARCHAR2 4000 REGTY SITETYPEDESCRIPTOR Indicates the site descriptor. Choices available from a drop-down box are dependent on the SUBTYPE column.
REGISTRATIONSTATUS REGSTATUS VARCHAR2 20 REGISTRATIONSTATUS Indicates the registration status. There are 5 options that can be chosen from a drop-down list to populate this column: Decision Pending, Federal Jurisdiction, Legacy, Registered, and Registry Candidate.
ISHERITAGESITE HERTGSITE VARCHAR2 1 ISHERITAGESITE Indicates if a site is a heritage site or an archaeological site. Heritage sites are denoted as Y or N. Archaeological sites are denoted as NULL.
BORDENUPPER BORDENUP VARCHAR2 2 BORDENUPPER is retrofitted from column BORDENUPPER of table TFM_SITE.
BORDENLOWER BORDENLOW VARCHAR2 2 BORDENLOWER is retrofitted from column BORDENLOWER of table TFM_SITE.
BORDENSEQUENCE BORDENSEQ NUMBER 38 BORDENSEQUENCE is retrofitted from column BORDENSEQUENCE of table TFM_SITE.
FORMRECEIVED FORMREC DATE 7 FORMRECEIVED represents the date on which the original hard copy or digital site form was received by the Archaeology Branch.
FEATURE_AREA_SQM NUMBER 19 FEATURE AREA SQM is the system calculated area of a two-dimensional polygon in square meters.
FEATURE_LENGTH_M NUMBER 19 FEATURE LENGTH M is the system calculated length or perimeter of a geometry in meters.
SHAPE SHAPE SDO_GEOMETRY 64 SHAPE is the column used to reference the spatial coordinates defining the feature.
OBJECTID OBJECTID NUMBER 38 OBJECTID is a column required by spatial layers that interact with ESRI ArcSDE. It is populated with unique values automatically by SDE.
SE_ANNO_CAD_DATA BLOB 4000 SE ANNO CAD DATA is a binary column used by spatial tools to store annotation, curve features and CAD data when using the SDO_GEOMETRY storage data type.

Comments

No comments have been posted yet.