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_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.
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.)
Platform | Name | Alias |
---|---|---|
FGDB (Operational) | TEIS_ID | TEIS Primary Key |
ArcSDE (BCGW) | TEIS_ID | TEIS_ID |
Oracle (BCGW) | TEIS_ID | TEIS_ID |
E00 (Coverage) | TEIS_ID | None |
RISC Standard | TEIS_ID | TEIS Primary Key |
Platform | Type | Width | Precision | Scale |
---|---|---|---|---|
FGDB (Operational) | Integer | 4 | 0 | 0 |
ArcSDE (BCGW) | Integer | 4 | 0 | 0 |
Oracle (BCGW) | NUMBER | 10 | ||
E00 (Coverage) | B | 4 | 10 |
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 |
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.
Platform | Name | Alias |
---|---|---|
FGDB (Operational) | PROJPOLYID | Project Polygon Identifier |
ArcSDE (BCGW) | PROJECT_POLYGON_IDENTIFIER | PROJECT_POLYGON_IDENTIFIER |
Oracle (BCGW) | PROJPOLYID | PROJECT_POLYGON_IDENTIFIER |
E00 (Coverage) | PROJPOLYID | None |
RISC Standard | PROJPOLYID | Project Polygon Identifier |
Platform | Type | Width | Precision | Scale |
---|---|---|---|---|
FGDB (Operational) | String | 50 | 0 | 0 |
ArcSDE (BCGW) | String | 50 | 0 | 0 |
Oracle (BCGW) | VARCHAR2 | 50 | ||
E00 (Coverage) | C | 50 | 50 |
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 |
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
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 |