Report Creator Version Beta
For details visit the Terrain web site or email the developer.
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
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.
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
Platform | Name | Alias |
---|---|---|
FGDB (Operational) | BAPID | Business Area Project ID |
ArcSDE (BCGW) | BUSINESS_AREA_PROJECT_ID | BUSINESS_AREA_PROJECT_ID |
Oracle (BCGW) | BAPID | BUSINESS_AREA_PROJECT_ID |
E00 (Coverage) | BAPID | None |
RISC Standard | BAPID | Business Area Project ID |
Platform | Type | Width | Precision | Scale |
---|---|---|---|---|
FGDB (Operational) | Integer | 4 | 0 | 0 |
ArcSDE (BCGW) | Integer | 4 | 0 | 0 |
Oracle (BCGW) | NUMBER | 5 | ||
E00 (Coverage) | I | 5 | 5 |
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 |
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.
Platform | Name | Alias |
---|---|---|
FGDB (Operational) | APPLIES | Applies To |
ArcSDE (BCGW) | None | None |
Oracle (BCGW) | None | None |
E00 (Coverage) | None | None |
RISC Standard | None | None |
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.
Platform | Type | Width | Precision | Scale |
---|---|---|---|---|
FGDB (Operational) | String | 10 | 0 | 0 |
ArcSDE (BCGW) | None | 0 | 0 | 0 |
Oracle (BCGW) | None | 0 | ||
E00 (Coverage) | None | 0 | 0 |
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 |
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.
Platform | Name | Alias |
---|---|---|
FGDB (Operational) | COLM_NAME | Column Name |
ArcSDE (BCGW) | None | None |
Oracle (BCGW) | None | None |
E00 (Coverage) | None | None |
RISC Standard | None | None |
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.
Platform | Type | Width | Precision | Scale |
---|---|---|---|---|
FGDB (Operational) | String | 10 | 0 | 0 |
ArcSDE (BCGW) | None | 0 | 0 | 0 |
Oracle (BCGW) | None | 0 | ||
E00 (Coverage) | None | 0 | 0 |
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 |
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.
Platform | Name | Alias |
---|---|---|
FGDB (Operational) | VALUE_TYP | Value Type |
ArcSDE (BCGW) | None | None |
Oracle (BCGW) | None | None |
E00 (Coverage) | None | None |
RISC Standard | None | None |
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.
Platform | Type | Width | Precision | Scale |
---|---|---|---|---|
FGDB (Operational) | String | 12 | 0 | 0 |
ArcSDE (BCGW) | None | 0 | 0 | 0 |
Oracle (BCGW) | None | 0 | ||
E00 (Coverage) | None | 0 | 0 |
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 |
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.
Platform | Name | Alias |
---|---|---|
FGDB (Operational) | LENGTH | Length |
ArcSDE (BCGW) | None | None |
Oracle (BCGW) | None | None |
E00 (Coverage) | None | None |
RISC Standard | None | None |
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.
Platform | Type | Width | Precision | Scale |
---|---|---|---|---|
FGDB (Operational) | Integer | 2 | 0 | 0 |
ArcSDE (BCGW) | None | 0 | 0 | 0 |
Oracle (BCGW) | None | 0 | ||
E00 (Coverage) | None | 0 | 0 |
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 |
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.
Platform | Name | Alias |
---|---|---|
FGDB (Operational) | DECIMAL | Decimals |
ArcSDE (BCGW) | None | None |
Oracle (BCGW) | None | None |
E00 (Coverage) | None | None |
RISC Standard | None | None |
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.
Platform | Type | Width | Precision | Scale |
---|---|---|---|---|
FGDB (Operational) | Integer | 2 | 0 | 0 |
ArcSDE (BCGW) | None | 0 | 0 | 0 |
Oracle (BCGW) | None | 0 | ||
E00 (Coverage) | None | 0 | 0 |
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 |
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.
Platform | Name | Alias |
---|---|---|
FGDB (Operational) | REQUIRED | Required |
ArcSDE (BCGW) | None | None |
Oracle (BCGW) | None | None |
E00 (Coverage) | None | None |
RISC Standard | None | None |
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.
Platform | Type | Width | Precision | Scale |
---|---|---|---|---|
FGDB (Operational) | String | 1 | 0 | 0 |
ArcSDE (BCGW) | None | 0 | 0 | 0 |
Oracle (BCGW) | None | 0 | ||
E00 (Coverage) | None | 0 | 0 |
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 |
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.
Platform | Name | Alias |
---|---|---|
FGDB (Operational) | CASE | Case |
ArcSDE (BCGW) | None | None |
Oracle (BCGW) | None | None |
E00 (Coverage) | None | None |
RISC Standard | None | None |
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.
Platform | Type | Width | Precision | Scale |
---|---|---|---|---|
FGDB (Operational) | String | 2 | 0 | 0 |
ArcSDE (BCGW) | None | 0 | 0 | 0 |
Oracle (BCGW) | None | 0 | ||
E00 (Coverage) | None | 0 | 0 |
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 |
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.
Platform | Name | Alias |
---|---|---|
FGDB (Operational) | MIN_VALUE | Minimum Value |
ArcSDE (BCGW) | None | None |
Oracle (BCGW) | None | None |
E00 (Coverage) | None | None |
RISC Standard | None | None |
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.
Platform | Type | Width | Precision | Scale |
---|---|---|---|---|
FGDB (Operational) | Integer | 4 | 0 | 0 |
ArcSDE (BCGW) | None | 0 | 0 | 0 |
Oracle (BCGW) | None | 0 | ||
E00 (Coverage) | None | 0 | 0 |
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 |
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.
Platform | Name | Alias |
---|---|---|
FGDB (Operational) | MAX_VALUE | Maximum Value |
ArcSDE (BCGW) | None | None |
Oracle (BCGW) | None | None |
E00 (Coverage) | None | None |
RISC Standard | None | None |
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.
Platform | Type | Width | Precision | Scale |
---|---|---|---|---|
FGDB (Operational) | Integer | 4 | 0 | 0 |
ArcSDE (BCGW) | None | 0 | 0 | 0 |
Oracle (BCGW) | None | 0 | ||
E00 (Coverage) | None | 0 | 0 |
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 |
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.
Platform | Name | Alias |
---|---|---|
FGDB (Operational) | UOFM | Unit of Measure |
ArcSDE (BCGW) | None | None |
Oracle (BCGW) | None | None |
E00 (Coverage) | None | None |
RISC Standard | None | None |
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.
Platform | Type | Width | Precision | Scale |
---|---|---|---|---|
FGDB (Operational) | String | 20 | 0 | 0 |
ArcSDE (BCGW) | None | 0 | 0 | 0 |
Oracle (BCGW) | None | 0 | ||
E00 (Coverage) | None | 0 | 0 |
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 |
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.
Platform | Name | Alias |
---|---|---|
FGDB (Operational) | DESCRIP | Description |
ArcSDE (BCGW) | None | None |
Oracle (BCGW) | None | None |
E00 (Coverage) | None | None |
RISC Standard | None | None |
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.
Platform | Type | Width | Precision | Scale |
---|---|---|---|---|
FGDB (Operational) | String | 255 | 0 | 0 |
ArcSDE (BCGW) | None | 0 | 0 | 0 |
Oracle (BCGW) | None | 0 | ||
E00 (Coverage) | None | 0 | 0 |
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 |
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.
Platform | Name | Alias |
---|---|---|
FGDB (Operational) | VALUE | Value |
ArcSDE (BCGW) | None | None |
Oracle (BCGW) | None | None |
E00 (Coverage) | None | None |
RISC Standard | None | None |
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.
Platform | Type | Width | Precision | Scale |
---|---|---|---|---|
FGDB (Operational) | String | 10 | 0 | 0 |
ArcSDE (BCGW) | None | 0 | 0 | 0 |
Oracle (BCGW) | None | 0 | ||
E00 (Coverage) | None | 0 | 0 |
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 |
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.
Platform | Name | Alias |
---|---|---|
FGDB (Operational) | VALUE_DESC | Value Description |
ArcSDE (BCGW) | None | None |
Oracle (BCGW) | None | None |
E00 (Coverage) | None | None |
RISC Standard | None | None |
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.
Platform | Type | Width | Precision | Scale |
---|---|---|---|---|
FGDB (Operational) | String | 255 | 0 | 0 |
ArcSDE (BCGW) | None | 0 | 0 | 0 |
Oracle (BCGW) | None | 0 | ||
E00 (Coverage) | None | 0 | 0 |
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 |