Archaeology Resource Management

442 views (4 recent)

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

OBSOLETE: This dataset has been replaced by WHSE_ARCHAEOLOGY.RAAD_SITES_SUBSET_BUFFERED_SP

Polygon layer containing 50 metre buffer of known archaeological site boundaries protected by the Heritage Conservation Act in the province of British Columbia.

Data and Resources

Dataset Extent

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

Additional Information

Purpose

50 metre buffer of known archaeological sites in the Province in order to facilitate their protection and use in land management planning.

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 2019-02-12
Resource Status obsolete
Replacement Recordhttps://catalogue.data.gov.bc.ca/dataset/566fc734-04e4-41ed-8224-bab4bcbb8c09

Object Description

Object Name: WHSE_ARCHAEOLOGY.RAAD_RESOURCE_MGMT_POLY

Short Name: RDRSRCMGMT
Comments: Contains basic site information but features are buffered according to Resource Management crieria

Column Name Short Name Data Type Data Precision Comments
MODIFIEDBY MODIFIEDBY VARCHAR2 10 Last user to modify data
MODIFIEDON MODIFIEDON DATE 7 Last modification date of data
MODIFIEDUSING MDFDSNG VARCHAR2 20 Last process to modify data
BORDENNUMBER BRDNNMBR VARCHAR2 13 Borden Number
BORDENUPPER BRDNPPR VARCHAR2 2 Borden Upper
BORDENLOWER BRDNLWR VARCHAR2 2 Borden Lower
BORDENSEQUENCE BRDNSQNC NUMBER 10 Borden Sequence
CREATIONDATE CRTNDT DATE 7 Creation Date
SITEFORMUSERID STFRMSRD VARCHAR2 30 Arch Branch Staff who Inserted the Record
FORMRECEIVED FRMRCVD DATE 7 Date on which the original hard copy or digital site form was received by the Archaeology Branch.
REGISTRATIONSTATUS RGSTRTNSTT VARCHAR2 20 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.
DOCUMENTKEY DCMNTK NUMBER 10 List of scanned images and attached documents relating to an individual site.
SITEPARENTOID STPRNTD NUMBER 10 Contains a reference to the parent site, if applicable. The parent site retains a link with child records to track past relationships between sites.
XX_ARSI_ID XX_ARSI_ID NUMBER 10 Old Oracle Key from PHRD (for Data Conversion Checking)
APPROVALFLAG PPRVLFLG VARCHAR2 20 There are 3 options that can be chosen from a drop-down list to populate this column: Approved (Project Officer Approved), INV Reviewed (Inventory Reviewed), and NEW (Site has been added or updated but not approved by the Branch). The NEW option is entered automatically by the system when new or updated site information is added; Branch staff must switch the flag to Approved or INV Reviewed after the information has been verified.
PACCUPDATEDDATE PCCPDTDDT DATE 7 Date that a consultant updated a record related to the site.
PACCPROJOFFICER PCCPRJFFCR VARCHAR2 40 Indicates the reviewing Project Officer who approved consultant entry.
PACCFLAGFLIPPEDDATE PCCFLGFLPP DATE 7 Date on which Archaeology Branch staff approved the changes.
CREATEDON CREATEDON DATE 7 First creation date of data
CREATEDBY CREATEDBY VARCHAR2 30 First user to create data
CREATEDUSING CRTDSNG VARCHAR2 30 First process to create data
ISHERITAGESITE SHRTGST VARCHAR2 1 Indicates whether site is a historic place.
REGISTRATIONDATE RGSTRTNDT DATE 7 Registrationdate
IMPORTPK IMPORTPK VARCHAR2 100 Internal identifier for HRIA. Used by XML import wizard as primary key.
IMPORTFK IMPORTFK VARCHAR2 100 Internal identifier for HRIA. Used by XML import wizard as foreign key.
SITEOID SITEOID NUMBER 38 Contains a reference to the original site object id
FEATURE_CODE FTRCD VARCHAR2 10 The Feature Code is most importantly a means of linking a feature to its name and definition
GEOMETRY GEOMETRY SDO_GEOMETRY 1 GEOMETRY is the column used to reference the spatial coordinates defining the feature.
OBJECTID OBJECTID NUMBER 38 OBJECTID is a required attribute of feature classes and object classes in a geodatabase.
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.
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