TEIS Metadata Report


TEI_Usr_Dfn_Fields


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 Fields (TEI_Usr_Dfn_Fields)

TEI_Usr_Dfn_Fields contains project specific field names, definitions, descriptions, domains and ranges for user defined fields (i.e., fields that are not RISC standard).

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

There are 591 FGDB bytes, and 4 SDE Bytes per row.

Table of Contents

Business Area Project ID (BAPID)

Item MetaData ID 18 (Report Item 1)

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

Applies To (APPLIES)

Item MetaData ID 437 (Report Item 2)

None Examples are not available.

This item was added on 3/15/2011. This item should not be indexed, and is MANDATORY.

Naming Details

PlatformNameAlias
FGDB (Operational)APPLIESApplies To
ArcSDE (BCGW)NoneNone
Oracle (BCGW)NoneNone
E00 (Coverage)NoneNone
RISC StandardNoneNone

SHORT NAME WARNING: The FGDB_Name and RISC_Short_Name do not match. LONG NAME WARNING: The FGDB_Alias and RISC_Long_Name do not match.

Item Type Details

PlatformTypeWidthPrecisionScale
FGDB (Operational)String1000
ArcSDE (BCGW)None000
Oracle (BCGW)None0
E00 (Coverage)None00

Attribute Descriptions

Item Definition (Operational Metadata)
None

FGDB (Operational)
The section of the TEM database that the user defined information pertains to. Ex. Project, Ecosystem, Terrain, etc.

Oracle (BCGW) Metadata Description
None

RISC Standard Description
The section of the TEM or other database that the user-defined information pertains to. Ex. Project, Ecosystem, Terrain, etc.

RISC Standard Instructions
None

Column Name (COLM_NAME)

Item MetaData ID 438 (Report Item 3)

None Examples are not available.

This item was added on 3/15/2011. This item should not be indexed, and is MANDATORY.

Naming Details

PlatformNameAlias
FGDB (Operational)COLM_NAMEColumn Name
ArcSDE (BCGW)NoneNone
Oracle (BCGW)NoneNone
E00 (Coverage)NoneNone
RISC StandardNoneNone

SHORT NAME WARNING: The FGDB_Name and RISC_Short_Name do not match. LONG NAME WARNING: The FGDB_Alias and RISC_Long_Name do not match.

Item Type Details

PlatformTypeWidthPrecisionScale
FGDB (Operational)String1000
ArcSDE (BCGW)None000
Oracle (BCGW)None0
E00 (Coverage)None00

Attribute Descriptions

Item Definition (Operational Metadata)
None

FGDB (Operational)
The column name of the attribute being referred to. It can be an existing column name or a new 'user defined' column name. Ex. Existing - Mapcode

Oracle (BCGW) Metadata Description
None

RISC Standard Description
The column name of the attribute being referred to. It can be an existing column name or a new 'user defined' column name. Ex. Existing - Mapcode

RISC Standard Instructions
None

Value Type (VALUE_TYP)

Item MetaData ID 439 (Report Item 4)

None Examples are not available.

This item was added on 3/15/2011. This item should not be indexed, and is MANDATORY.

Naming Details

PlatformNameAlias
FGDB (Operational)VALUE_TYPValue Type
ArcSDE (BCGW)NoneNone
Oracle (BCGW)NoneNone
E00 (Coverage)NoneNone
RISC StandardNoneNone

SHORT NAME WARNING: The FGDB_Name and RISC_Short_Name do not match. LONG NAME WARNING: The FGDB_Alias and RISC_Long_Name do not match.

Item Type Details

PlatformTypeWidthPrecisionScale
FGDB (Operational)String1200
ArcSDE (BCGW)None000
Oracle (BCGW)None0
E00 (Coverage)None00

Attribute Descriptions

Item Definition (Operational Metadata)
None

FGDB (Operational)
The field data type. Valid types are String, Integer and SmallInteger. SmallInteger fields can only store values between -32,768 and 32,767; Integer stores values between -2,147,483,648 and 2,147,483,647.

Oracle (BCGW) Metadata Description
None

RISC Standard Description
The field data type. Valid types are String, Integer and SmallInteger. SmallInteger fields can only store values between -32,768 and 32,767; Integer stores values between -2,147,483,648 and 2,147,483,647.

RISC Standard Instructions
None

Length (LENGTH)

Item MetaData ID 440 (Report Item 5)

None Examples are not available.

This item was added on 3/15/2011. This item should not be indexed, and is MANDATORY.

Naming Details

PlatformNameAlias
FGDB (Operational)LENGTHLength
ArcSDE (BCGW)NoneNone
Oracle (BCGW)NoneNone
E00 (Coverage)NoneNone
RISC StandardNoneNone

SHORT NAME WARNING: The FGDB_Name and RISC_Short_Name do not match. LONG NAME WARNING: The FGDB_Alias and RISC_Long_Name do not match.

Item Type Details

PlatformTypeWidthPrecisionScale
FGDB (Operational)Integer200
ArcSDE (BCGW)None000
Oracle (BCGW)None0
E00 (Coverage)None00

Attribute Descriptions

Item Definition (Operational Metadata)
None

FGDB (Operational)
For String fields, the maximum length of a valid string value. For Integer and SmallInteger fields, this value is always 4 and 2 respectively.

Oracle (BCGW) Metadata Description
None

RISC Standard Description
For String fields, the maximum length of a valid string value. For Integer and SmallInteger fields, this value is always 4 and 2 respectively.

RISC Standard Instructions
None

Decimals (DECIMAL)

Item MetaData ID 441 (Report Item 6)

None Examples are not available.

This item was added on 3/15/2011. This item should not be indexed, and is not mandatory.

Naming Details

PlatformNameAlias
FGDB (Operational)DECIMALDecimals
ArcSDE (BCGW)NoneNone
Oracle (BCGW)NoneNone
E00 (Coverage)NoneNone
RISC StandardNoneNone

SHORT NAME WARNING: The FGDB_Name and RISC_Short_Name do not match. LONG NAME WARNING: The FGDB_Alias and RISC_Long_Name do not match.

Item Type Details

PlatformTypeWidthPrecisionScale
FGDB (Operational)Integer200
ArcSDE (BCGW)None000
Oracle (BCGW)None0
E00 (Coverage)None00

Attribute Descriptions

Item Definition (Operational Metadata)
None

FGDB (Operational)
For Float and Double field types, the number of decimal places to be stored in the field. All digits are counted, no matter what side of the decimal they are on.

Oracle (BCGW) Metadata Description
None

RISC Standard Description
For Float and Double field types, the number of decimal places to be stored in the field. All digits are counted, no matter what side of the decimal they are on.

RISC Standard Instructions
None

Required (REQUIRED)

Item MetaData ID 442 (Report Item 7)

None Examples are not available.

This item was added on 3/15/2011. This item should not be indexed, and is MANDATORY.

Naming Details

PlatformNameAlias
FGDB (Operational)REQUIREDRequired
ArcSDE (BCGW)NoneNone
Oracle (BCGW)NoneNone
E00 (Coverage)NoneNone
RISC StandardNoneNone

SHORT NAME WARNING: The FGDB_Name and RISC_Short_Name do not match. LONG NAME WARNING: The FGDB_Alias and RISC_Long_Name do not match.

Item Type Details

PlatformTypeWidthPrecisionScale
FGDB (Operational)String100
ArcSDE (BCGW)None000
Oracle (BCGW)None0
E00 (Coverage)None00

Attribute Descriptions

Item Definition (Operational Metadata)
None

FGDB (Operational)
Designates whether the field is mandatory (Y or N).

Oracle (BCGW) Metadata Description
None

RISC Standard Description
Designates whether the field is mandatory (Y or N).

RISC Standard Instructions
None

Case (CASE)

Item MetaData ID 443 (Report Item 8)

None Examples are not available.

This item was added on 3/15/2011. This item should not be indexed, and is not mandatory.

Naming Details

PlatformNameAlias
FGDB (Operational)CASECase
ArcSDE (BCGW)NoneNone
Oracle (BCGW)NoneNone
E00 (Coverage)NoneNone
RISC StandardNoneNone

SHORT NAME WARNING: The FGDB_Name and RISC_Short_Name do not match. LONG NAME WARNING: The FGDB_Alias and RISC_Long_Name do not match.

Item Type Details

PlatformTypeWidthPrecisionScale
FGDB (Operational)String200
ArcSDE (BCGW)None000
Oracle (BCGW)None0
E00 (Coverage)None00

Attribute Descriptions

Item Definition (Operational Metadata)
None

FGDB (Operational)
For String fields, the allowed case of the string value. L - Lower; U - Upper; M - Mixed.

Oracle (BCGW) Metadata Description
None

RISC Standard Description
For String fields, the allowed case of the string value. L - Lower; U - Upper; M - Mixed.

RISC Standard Instructions
None

Minimum Value (MIN_VALUE)

Item MetaData ID 444 (Report Item 9)

None Examples are not available.

This item was added on 3/15/2011. This item should not be indexed, and is not mandatory.

Naming Details

PlatformNameAlias
FGDB (Operational)MIN_VALUEMinimum Value
ArcSDE (BCGW)NoneNone
Oracle (BCGW)NoneNone
E00 (Coverage)NoneNone
RISC StandardNoneNone

SHORT NAME WARNING: The FGDB_Name and RISC_Short_Name do not match. LONG NAME WARNING: The FGDB_Alias and RISC_Long_Name do not match.

Item Type Details

PlatformTypeWidthPrecisionScale
FGDB (Operational)Integer400
ArcSDE (BCGW)None000
Oracle (BCGW)None0
E00 (Coverage)None00

Attribute Descriptions

Item Definition (Operational Metadata)
None

FGDB (Operational)
For numeric fields, the minimum value allowed in the field.

Oracle (BCGW) Metadata Description
None

RISC Standard Description
For numeric fields, the minimum value allowed in the field.

RISC Standard Instructions
None

Maximum Value (MAX_VALUE)

Item MetaData ID 445 (Report Item 10)

None Examples are not available.

This item was added on 3/15/2011. This item should not be indexed, and is not mandatory.

Naming Details

PlatformNameAlias
FGDB (Operational)MAX_VALUEMaximum Value
ArcSDE (BCGW)NoneNone
Oracle (BCGW)NoneNone
E00 (Coverage)NoneNone
RISC StandardNoneNone

SHORT NAME WARNING: The FGDB_Name and RISC_Short_Name do not match. LONG NAME WARNING: The FGDB_Alias and RISC_Long_Name do not match.

Item Type Details

PlatformTypeWidthPrecisionScale
FGDB (Operational)Integer400
ArcSDE (BCGW)None000
Oracle (BCGW)None0
E00 (Coverage)None00

Attribute Descriptions

Item Definition (Operational Metadata)
None

FGDB (Operational)
For numeric fields, the maximum value allowed in the field.

Oracle (BCGW) Metadata Description
None

RISC Standard Description
For numeric fields, the maximum value allowed in the field.

RISC Standard Instructions
None

Unit of Measure (UOFM)

Item MetaData ID 446 (Report Item 11)

None Examples are not available.

This item was added on 3/15/2011. This item should not be indexed, and is not mandatory.

Naming Details

PlatformNameAlias
FGDB (Operational)UOFMUnit of Measure
ArcSDE (BCGW)NoneNone
Oracle (BCGW)NoneNone
E00 (Coverage)NoneNone
RISC StandardNoneNone

SHORT NAME WARNING: The FGDB_Name and RISC_Short_Name do not match. LONG NAME WARNING: The FGDB_Alias and RISC_Long_Name do not match.

Item Type Details

PlatformTypeWidthPrecisionScale
FGDB (Operational)String2000
ArcSDE (BCGW)None000
Oracle (BCGW)None0
E00 (Coverage)None00

Attribute Descriptions

Item Definition (Operational Metadata)
None

FGDB (Operational)
The unit of measure implied by the entry. Ex. Centimeters, Hectares, etc.

Oracle (BCGW) Metadata Description
None

RISC Standard Description
The unit of measure implied by the entry. Ex. Centimeters, Hectares, etc.

RISC Standard Instructions
None

Description (DESCRIP)

Item MetaData ID 447 (Report Item 12)

None Examples are not available.

This item was added on 3/15/2011. This item should not be indexed, and is not mandatory.

Naming Details

PlatformNameAlias
FGDB (Operational)DESCRIPDescription
ArcSDE (BCGW)NoneNone
Oracle (BCGW)NoneNone
E00 (Coverage)NoneNone
RISC StandardNoneNone

SHORT NAME WARNING: The FGDB_Name and RISC_Short_Name do not match. LONG NAME WARNING: The FGDB_Alias and RISC_Long_Name do not match.

Item Type Details

PlatformTypeWidthPrecisionScale
FGDB (Operational)String25500
ArcSDE (BCGW)None000
Oracle (BCGW)None0
E00 (Coverage)None00

Attribute Descriptions

Item Definition (Operational Metadata)
None

FGDB (Operational)
A textual description or definition of the field.

Oracle (BCGW) Metadata Description
None

RISC Standard Description
A textual description or definition of the field.

RISC Standard Instructions
None

Value (VALUE)

Item MetaData ID 448 (Report Item 13)

None Examples are not available.

This item was added on 3/15/2011. This item should not be indexed, and is not mandatory.

Naming Details

PlatformNameAlias
FGDB (Operational)VALUEValue
ArcSDE (BCGW)NoneNone
Oracle (BCGW)NoneNone
E00 (Coverage)NoneNone
RISC StandardNoneNone

SHORT NAME WARNING: The FGDB_Name and RISC_Short_Name do not match. LONG NAME WARNING: The FGDB_Alias and RISC_Long_Name do not match.

Item Type Details

PlatformTypeWidthPrecisionScale
FGDB (Operational)String1000
ArcSDE (BCGW)None000
Oracle (BCGW)None0
E00 (Coverage)None00

Attribute Descriptions

Item Definition (Operational Metadata)
None

FGDB (Operational)
For String fields, one of the valid values. (For each valid value, make a new record in this table.)

Oracle (BCGW) Metadata Description
None

RISC Standard Description
For String fields, one of the valid values. (For each valid value, make a new record in this table.)

RISC Standard Instructions
None

Value Description (VALUE_DESC)

Item MetaData ID 449 (Report Item 14)

None Examples are not available.

This item was added on 3/15/2011. This item should not be indexed, and is not mandatory.

Naming Details

PlatformNameAlias
FGDB (Operational)VALUE_DESCValue Description
ArcSDE (BCGW)NoneNone
Oracle (BCGW)NoneNone
E00 (Coverage)NoneNone
RISC StandardNoneNone

SHORT NAME WARNING: The FGDB_Name and RISC_Short_Name do not match. LONG NAME WARNING: The FGDB_Alias and RISC_Long_Name do not match.

Item Type Details

PlatformTypeWidthPrecisionScale
FGDB (Operational)String25500
ArcSDE (BCGW)None000
Oracle (BCGW)None0
E00 (Coverage)None00

Attribute Descriptions

Item Definition (Operational Metadata)
None

FGDB (Operational)
A textual description or definition of the value.

Oracle (BCGW) Metadata Description
None

RISC Standard Description
A textual description or definition of the value.

RISC Standard Instructions
None

End of Report