| OBJECTID |
OBJECTID |
NUMBER |
ESRI system maintained integer field used to uniquely identify rows in tables in a geodatabase. Note that OBJECTIID values change upon export or import of the data and should not be used as a primary field for searching or identifying records. |
|
|
|
| STMMAINPONDID |
Stmmainpondid |
NUMBER |
Database maintained field that permanently assigns a unique value for each record. This ID value should be the one referred to when identifying a record. |
|
|
|
| CREATE_BY |
Create By |
VARCHAR2 |
Database maintained field. Updates to the user name that created the feature. Update takes place when the feature is created. |
|
|
|
| CREATE_DATE |
Create Date |
DATE |
Database maintained field. Updates to the current data/time. Update takes place when the feature is created. |
|
|
|
| UPDATE_BY |
Update By |
VARCHAR2 |
Database maintained field. Updates to the user name that most recently updated either an attribute or the geometry of the feature. Update takes place when the feature is created and/or changed. |
|
|
|
| UPDATE_DATE |
Update Date |
DATE |
Database maintained field. Updates to the current data/time when an attribute or the geometry of the feature is changed. Update takes place when the feature is created and/or changed. |
|
|
|
| STATUS |
Status |
VARCHAR2 |
Indicates the status of feature. A pick list is used for this field - contact GIS for pick list values. |
GISStatus |
ACTIVE |
ACTIVE; HISTORIC; PLANNED; UNKNOWN |
| STATUS_DATE |
Status Date |
DATE |
Database maintained field. Updates to the current date/time when the STATUS field value is changed. |
|
|
|
| SOURCE |
Source |
NUMBER |
GIS maintained field. Source EDRA (Electronic Document Registration Application) document number, or name of department or specific staff member that the information came from. |
|
|
|
| SOURCE_DATE |
Source Date |
DATE |
GIS maintained field. Date of the source document or information. |
|
|
|
| CATEGORY |
Category |
VARCHAR2 |
GIS maintained field. Not used at this time. |
|
|
|
| STM_POND_REF_NO |
Stm Pond Ref No |
VARCHAR2 |
GIS maintained field. Common ID value referring to the associated storm facility and the pond number. |
|
|
|
| REL_STMFACILITYID |
Rel Stmfacilityid |
NUMBER |
GIS maintained field. Refers to the ID of the associated storm facility. |
|
|
|
| LINER_TYPE |
Liner Type |
VARCHAR2 |
Engineering maintained field. Liner of the pond. |
StmForebayPondLinerType |
NONE |
CABLE CONCRETE; CLAY; CONCRETE BLOCK; GABION; GEOSYNTHETIC; NONE; OTHER; RUBBER; STONE |
| SHAPE |
SHAPE |
ST_GEOMETRY |
ESRI system maintained field. Stores the geometry type and geometry of the feature. |
|
|
|
| PERMANENT_POOL_ELEVATION_M |
Permanent Pool Elevation (m) |
NUMBER |
Engineering maintained field. Elevation in metres of the surface of the main pond. |
|
|
|
| SEDIMENT_REMOVAL_ELEVATION_M |
Sediment Removal Elevation (m) |
NUMBER |
Engineering maintained field. Elevation in metres when sediment is to be removed. |
|
|
|
| SEDIMENT_REMOVAL_VOLUME_M3 |
Sediment Removal Volume (m3) |
NUMBER |
Engineering maintained field. Amount of cubic metres of sediment for removal. |
|
|
|
| ENG_NOTES |
Eng Notes |
VARCHAR2 |
Engineering maintained field. Open text field for notes. |
|
|
|
| PLUNGE_POOL |
Plunge Pool |
VARCHAR2 |
|
YesNoLongOnly |
NO |
NO; YES |
| SEDIMENT_REMOVAL_FREQUENCY_YRS |
Sediment Removal Frequency Yrs |
NUMBER |
|
|
|
|
| LAST_CLEANOUT_YEAR |
Last Cleanout Year |
NUMBER |
|
|
|
|
| MAIN_POND_BOTTOM_ELEVATION_M |
Main Pond Bottom Elevation (m) |
NUMBER |
|
|
|
|
| PERMANENT_POOL_VOLUME_M3 |
Permanent Pool Volume (m3) |
NUMBER |
|
|
|
|
| BENCHMARKID |
Closest BenchmarkID |
NUMBER |
|
|
|
|
