| 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. |
|
|
|
| LAYER |
Layer |
VARCHAR2 |
Provided by Engineering. Original Microstation level name. |
|
|
|
| LEVEL_NUM |
Level Num |
VARCHAR2 |
Provided by Engineering. Indicates the level of the associated sanitary drainage area. |
|
|
|
| LEVEL_NAME |
Level Name |
VARCHAR2 |
Provided by Engineering. Name of the sanitary drainage area. |
|
|
|
| LEVEL1 |
Level1 |
VARCHAR2 |
Provided by Engineering. Level 1 sanitary drainage area for the associated record. |
|
|
|
| LEVEL2 |
Level2 |
VARCHAR2 |
Provided by Engineering. Level 2 sanitary drainage area for the associated record. |
|
|
|
| LEVEL3 |
Level3 |
VARCHAR2 |
Provided by Engineering. Level 3 sanitary drainage area for the associated record. |
|
|
|
| LEVEL4 |
Level4 |
VARCHAR2 |
Provided by Engineering. Level 4 sanitary drainage area for the associated record. |
|
|
|
| DRAIN_FLOW |
Drain Flow |
VARCHAR2 |
Provided by Engineering. Complete hierarchy of sanitary drainage areas for the associated record. |
|
|
|
| PAGE |
Page |
VARCHAR2 |
Provided by Engineering. Indicates the atlas page number in the sanitary drainage area atlas. |
|
|
|
| CATEGORY |
Category |
VARCHAR2 |
Primary mapping field of the layer. Valid category values are:INTERMEDIATE AREA,MAIN AND SUB AREA,MAIN AREA,SUB AREA,SUPER AREA |
SanDrainageAreaCategory |
|
INTERMEDIATE AREA; MAIN AND SUB AREA; MAIN AREA; SUB AREA; SUPER AREA; UNKNOWN |
| SUBCATEGORY |
Subcategory |
VARCHAR2 |
Secondary mapping field of the layer.Valid subcategory values are:Balzer,Biehn,Biehn Direct,Biehn Future,Borden,Bridgeport,Dietwieler,Doon,Downtown East,Freeport,Gateway Park,Grand River South,Henry Sturm Direct,Idlewood-Lackner,Kolb,Lawrence,Lower Schneider,Lower Schneider Direct,Manchester,Manchester Direct,Melitzer,Middle Strasburg,Montgomery,Montgomery Direct,North Strasburg,Ottawa,Ottawa Direct,Pioneer Tower West,Sandrock,Schneider,Shoemaker,Shoemaker Direct,South Strasburg A,South Strasburg B,South Strasburg Direct,South Strasburg Future 1,South Strasburg Future 2,Southwest Future 1,Southwest Future 2,Southwest Future 3,Spring Valley,Spring Valley North,Spring Valley South,Strasburg,Strasburg Direct,Trillium,Upper Doon,Upper Doon Direct,Upper Doon Future,Upper Schneider,Upper Schneider Direct,Victoria,Victoria North,Voison,Westmount,Westmount Direct |
|
|
|
| CREATE_DATE |
Create Date |
DATE |
Database maintained field. Updates to the current data/time. Update takes place when the feature is created. |
|
|
|
| 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. |
|
|
|
| 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. |
|
|
|
| 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. |
|
|
|
| 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 |
VARCHAR2 |
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. |
|
|
|
| SANDRAINAGEAREAID |
Sandrainageareaid |
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. |
|
|
|
| SHAPE |
Shape |
ST_GEOMETRY |
ESRI system maintained field. Stores the geometry type and geometry of the feature. |
|
|
|