TEIS Metadata Report


TEI_Usr_Dfn_Data


Report Creator Version Beta

For details visit the Terrain web site or email the developer.

Run Parameters

2015-02-03 16:52:00 on BOOLEAN

Script: D:\MoE\TEIS_environment_v7_20150109\Scripts\CreateAllTemplatesAndMetadataReports.py

Input Location: D:\MoE\TEIS_environment_v7_20150109\Tools_and_Templates.gdb

Terrestrial Ecosystem Information User Defined Data (TEI_Usr_Dfn_Data)

TEI_Usr_Dfn_Data contains user defined (project specific) fields containing codes or ranges relating to user defined values (i.e., fields and attributes that are not RISC standard).

Table created 3/21/2011.This feature class is of type TABLE, and is projected to Unknown.

There are 58 FGDB bytes, and 58 SDE Bytes per row.

Table of Contents

TEIS Primary Key (TEIS_ID)

Item MetaData ID 312 (Report Item 1)

contains the unique identifier (PK) for the TEIS Polygon Attributes detailed geometry. This key may change between snapshots of the database. Examples include: 1, 1234567, 99392.

This item was added on 10/22/2009. This item should be INDEXED, and is MANDATORY. Unique numeric ID for detailed polygons. (Non-soils.)

Naming Details

PlatformNameAlias
FGDB (Operational)TEIS_IDTEIS Primary Key
ArcSDE (BCGW)TEIS_IDTEIS_ID
Oracle (BCGW)TEIS_IDTEIS_ID
E00 (Coverage)TEIS_IDNone
RISC StandardTEIS_IDTEIS Primary Key

Item Type Details

PlatformTypeWidthPrecisionScale
FGDB (Operational)Integer400
ArcSDE (BCGW)Integer400
Oracle (BCGW)NUMBER10
E00 (Coverage)B410

Attribute Descriptions

Item Definition (Operational Metadata)
contains the unique identifier (PK) for the TEIS Polygon Attributes detailed geometry. This key may change between snapshots of the database.

FGDB (Operational)
The unique identifier (PK) for the TEIS detailed geometry. This key may change between snapshots of the database.

Oracle (BCGW) Metadata Description
TEIS_ID (aka TEIS_ID) contains the unique identifier (PK) for the TEIS Polygon Attributes detailed geometry. This key may change between snapshots of the database. For example: TBT_4741_082M066_124975.

RISC Standard Description
The unique identifier (PK) for the TEIS detailed geometry. This key may change between snapshots of the database.

RISC Standard Instructions
N/A

Project Polygon Identifier (PROJPOLYID)

Item MetaData ID 427 (Report Item 2)

contains a polygon identifier for linking attribute data to spatial data for TER, TEM, PEM and SEI data. It is not provincially unique. This field can be used for linking foreign key data (user defined fields, report references, etc.). It contains the attribute previously known as TER_TAG and ECP_TAG. Examples include: 12345, X17YK4.

This item was added on 11/25/2009. This item should be INDEXED, and is MANDATORY. COMMENTS: This will replace project specific IDs (ECP_TAG, TER_TAG, etc.). The same data can be used to populate it.

Naming Details

PlatformNameAlias
FGDB (Operational)PROJPOLYIDProject Polygon Identifier
ArcSDE (BCGW)PROJECT_POLYGON_IDENTIFIERPROJECT_POLYGON_IDENTIFIER
Oracle (BCGW)PROJPOLYIDPROJECT_POLYGON_IDENTIFIER
E00 (Coverage)PROJPOLYIDNone
RISC StandardPROJPOLYIDProject Polygon Identifier

Item Type Details

PlatformTypeWidthPrecisionScale
FGDB (Operational)String5000
ArcSDE (BCGW)String5000
Oracle (BCGW)VARCHAR250
E00 (Coverage)C5050

Attribute Descriptions

Item Definition (Operational Metadata)
contains a polygon identifier for linking attribute data to spatial data for TER, TEM, PEM and SEI data. It is not provincially unique. This field can be used for linking foreign key data (user defined fields, report references, etc.). It contains the attribute previously known as TER_TAG and ECP_TAG.

FGDB (Operational)
This field contains a unique polygon identifier for linking attribute data to spatial data for TER, TEM, PEM and SEI data. A unique identifier within a project, that when combined with the BAPID creates a unique identifier within the province. This field can be used for linking foreign key data (user defined fields, report references, etc.).

Oracle (BCGW) Metadata Description
PROJECT_POLYGON_IDENTIFIER (aka PROJPOLYID) contains a polygon identifier for linking attribute data to spatial data for TER, TEM, PEM and SEI data. It is not provincially unique. This field can be used for linking foreign key data (user defined fields, report references, etc.). It contains the attribute previously known as TER_TAG and ECP_TAG. For example: 12345, X17YK4.

RISC Standard Description
This field contains a unique polygon identifier for linking attribute data to spatial data for TER, TEM, PEM and SEI data. A unique identifier within a project, that when combined with the BAPID creates a unique identifier within the province. This field can be used for linking foreign key data (user defined fields, report references, etc.).

RISC Standard Instructions
N/A

Business Area Project ID (BAPID)

Item MetaData ID 18 (Report Item 3)

contains a numeric project identifier assigned by the Ministry of Environment, Ecosystem Information Section. The project BAPID is used to identify all information relating to a project and is the unique identifier (PK) for the project and is the linking key used to join or relate other TEIS data sets such as the TEIS Polygon Attribute. Examples include: 1234.

It is unknown when this item was added. This item should be INDEXED, and is MANDATORY. COMMENTS: must correspond with Project boundary feature class

Naming Details

PlatformNameAlias
FGDB (Operational)BAPIDBusiness Area Project ID
ArcSDE (BCGW)BUSINESS_AREA_PROJECT_IDBUSINESS_AREA_PROJECT_ID
Oracle (BCGW)BAPIDBUSINESS_AREA_PROJECT_ID
E00 (Coverage)BAPIDNone
RISC StandardBAPIDBusiness Area Project ID

Item Type Details

PlatformTypeWidthPrecisionScale
FGDB (Operational)Integer400
ArcSDE (BCGW)Integer400
Oracle (BCGW)NUMBER5
E00 (Coverage)I55

Attribute Descriptions

Item Definition (Operational Metadata)
contains a numeric project identifier assigned by the Ministry of Environment, Ecosystem Information Section. The project BAPID is used to identify all information relating to a project and is the unique identifier (PK) for the project and is the linking key used to join or relate other TEIS data sets such as the TEIS Polygon Attribute.

FGDB (Operational)
This field contains a unique project identifier. The project BAPID is used in all .e00 files.

Oracle (BCGW) Metadata Description
BUSINESS_AREA_PROJECT_ID (aka BAPID) contains a numeric project identifier assigned by the Ministry of Environment, Ecosystem Information Section. The project BAPID is used to identify all information relating to a project and is the unique identifier (PK) for the project and is the linking key used to join or relate other TEIS data sets such as the TEIS Polygon Attribute. For example: 1234.

RISC Standard Description
This field contains a unique project identifier. The project BAPID is used in all spatial files.

RISC Standard Instructions
If not already done, request a project BAPID from Soilterrain@victoria1.gov.bc.ca

End of Report