| 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. |
|
|
|
| SANMANHOLEID |
SAN Manhole ID |
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. |
|
|
|
| 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 |
| 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. |
|
|
|
| UPDATE_BY |
Last 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 |
Last 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. |
|
|
|
| CREATE_BY |
Created 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. |
|
|
|
| PARCELID |
Parcel ID |
NUMBER |
Reference Parcel ID that the feature is located in. The value is either manually entered or generated from a spatial join process. |
|
|
|
| ROADSEGMENTID |
Road Segment ID |
NUMBER |
Input by GIS staff. ROADSEGMENTID of the GIS_DATA.ROADSEGMENT layer feature that the sanitary manhole is associated with . A value of -1 indicates that the feature is not near a road. Roadsegments must have a CATEGORY value of 'HIGHWAY' , 'RAMP' , 'ROAD' , or 'ROUNDABOUT' and a STATUS value of 'ACTIVE' , 'PLANNED', or 'REGISTERED'. |
|
|
|
| QUARTER_GRID_ID |
Quarter Grid ID |
VARCHAR2 |
Input by GIS staff. GENERAL_GRID_ID value of the GIS_DATA.GRID_STANDARD_QUARTERED layer feature which the sanitary manhole falls within. A value of -1 indicates that the feature does not fall inside a quarter grid. |
GridQuarteredID |
|
277-A; 407-C; 586-D; 587-A; 607-A; 607-B; 607-C; 607-D; 608-A; 608-B ...See GIS for a complete list... |
| ROADCONSTLIMITID |
Road Construction ID |
NUMBER |
This field is not being used at this time. |
|
|
|
| TAG1 |
Tag1 |
VARCHAR2 |
Temporary location to store short term data for mapping purposes only. |
|
|
|
| TAG2 |
Tag2 |
VARCHAR2 |
Temporary location to store short term data for mapping purposes only. |
|
|
|
| TAG3 |
Tag3 |
VARCHAR2 |
Temporary location to store short term data for mapping purposes only. |
|
|
|
| GIS_NOTES |
GIS Notes |
VARCHAR2 |
Open text field for outlining any problems or to highlight special characteristics of the feature specific to GIS. |
|
|
|
| SHAPE |
SHAPE |
ST_GEOMETRY |
ESRI system maintained field. Stores the geometry type and geometry of the feature. |
|
|
|
| CATEGORY |
Category |
VARCHAR2 |
Primary mapping field of the layer. Valid category values are:GRAVITY MANHOLE,UNKNOWN,VALVE CHAMBER |
SanManholeCategory |
GRAVITY MANHOLE |
GRAVITY MANHOLE; UNKNOWN; VALVE CHAMBER |
| OWNERSHIP |
Ownership |
VARCHAR2 |
Asset Owner: Who owns the feature, Generally Government agencies such as CITY, REGION and MTO and private citizens and businesses shown as PUBLIC. This usually relates to the property the asset sits on. |
OwnershipClass |
KITCHENER |
CAMBRIDGE; DUAL CITY AND REGION; DUAL CITY AND WRDSB; PRIVATE; REGION; SCHOOL BOARD; UNKNOWN; WATERLOO; WELLESLEY; WILMOT ...See GIS for a complete list... |
| DEPTH |
Depth (m) |
NUMBER |
Provided through as-built plan or digital submission. The depth below surface grade of the sanitary manhole. This value is the COVER_ELEVATION minus the sanitary manhole's lowest pipe invert. The default value is <null>. The value -2 indicates that the sanitary manhole depth was not given or is unknown. |
|
|
|
| COVER_SHAPE |
Cover Shape |
VARCHAR2 |
Provided through as-built plan or digital submission. The shape of the sanitary manhole cover. The default value is 'TO INPUT'. Valid values are 'ROUND', 'SQUARE'. The value 'UNKNOWN' indicates that the sanitary manhole cover shape was not given or is unknown. |
SanManholeCoverShape |
ROUND |
ROUND; SQUARE |
| COVER_LENGTH |
Cover Length (cm) |
NUMBER |
Provided through as-built plan or digital submission. The length of the sanitary manhole cover. The default value is <null>. The value -2 indicates that the sanitary manhole cover length was not given or is unknown. |
|
|
|
| LOCK_TYPE |
Is a cover lock is present |
VARCHAR2 |
Provided through as-built plan or digital submission. Indicates if a cover lock is present for the sanitary manhole. The default value is 'TO INPUT'. Valid values are 'NONE'. The value 'UNKNOWN' indicates that the presence of of a cover lock was not given or is unknown. |
SanManholeLockType |
NONE |
NONE |
| DROP_UP_INVERT |
Drop Pipe Upstream Invert (cm) |
NUMBER |
Provided through as-built plan or digital submission. Drop pipe up invert in meters above sea level. The default value is <null>. Valid values should range between 260 and 450. The value -2 indicates that the drop pipe up invert was not given or is unknown. |
|
|
|
| TRUNK_SEWER |
Is manhole considered part of a trunk sewer |
VARCHAR2 |
Provided through as-built plan or digital submission. Indicates if the sanitary manhole is considered part of a trunk sewer. Values are codes. The following uses the key 'CODE' ('DESCRIPTION'). The default value is 'X' ('X - TO INPUT'). Valid values are 'N' ('N - NO'), 'Y' ('Y - YES'). The value 'U' ('U - UNKNOWN') indicates that the trunk sewer indication was not given or is unknown. |
YesNoLongOnly |
NO |
NO; YES |
| TRUNK_SEWER_NAME |
Trunk Sewer Name (if applicable) |
VARCHAR2 |
Provided through as-built plan or digital submission. The name of the trunk sewer that the sanitary manhole is a part of. The default value is <null>. If the TRUNK_SEWER field value is 'Y' then a name is needed in this field. If the TRUNK_SEWER field value is 'N' then this field should be blank. |
|
|
|
| COVER_ELEVATION |
Cover Elevation (m) |
NUMBER |
Provided through as-built plan or digital submission. The elevation, in meters above sea level, of the sanitary manhole cover. The default value is <null>. Valid values should range between 260 and 450. The value -2 indicates that the sanitary manhole cover elevation was not given or is unknown. |
|
|
|
| RISER_TYPE |
Type of Riser |
VARCHAR2 |
Provided through as-built plan or digital submission. Riser type of the sanitary manhole. The default value is 'TO INPUT'. Valid values are 'MODULOCK'. The value 'UNKNOWN' indicates that the riser type was not given or is unknown. |
SanManholeRiserType |
MODULOCK |
MODULOCK |
| GROUND_WATER |
Is ground water present at an elevation equal to or higher than the bottom of the sanitary manhole |
VARCHAR2 |
Provided through as-built plan or digital submission. Indicates if groundwater is present at an elevation equal to or higher than the bottom of the sanitary manhole. The default value is 'TO INPUT'. Valid values are 'NO', 'YES'. The value 'UNKNOWN' indicates that the presence of groundwater was not given or is unknown. |
YesNoLong |
|
NO; UNKNOWN; YES |
| INSTALLATION_DATE |
Installation Date |
DATE |
Date the feature was installed |
|
|
|
| INSTALLATION_YEAR |
Year Installed |
NUMBER |
Year the asset was installed. Usually a database maintained field. |
|
|
|
| ACQUISITION |
How was the asset acquired |
VARCHAR2 |
Input by GIS staff. Identification of how the city received or acquired the feature. If the feature came through the subdivision process it is considered 'DONATED' and if not it is 'PURCHASED' |
PSABAcquisition |
DONATED |
DONATED; PURCHASED |
| ISSUE_NOTE |
Issues Notes |
VARCHAR2 |
Input by GIS staff. Open text field that is used to identify or list data issues of records. |
|
|
|
| ENGINEERING_NOTES |
Engineering Notes |
VARCHAR2 |
Input by Engineering staff. Open text field for notes. |
|
|
|
| CONSULTANT |
Name of consultant that submitted drawings |
VARCHAR2 |
Provided through as-built plan or digital submission. Open text field used to indicate the consultant that submitted drawings using the digital submission process set up in 2011. |
|
|
|
| SAN_SUB_DRAINAGE_AREA |
Sanitary Sub-drainage Area |
VARCHAR2 |
|
SanSubDrainageArea |
|
BIEHN; BRIDGEPORT; LOWER SCHNEIDER - UPPER DOON; NONE; UNKNOWN; UPPER SCHNEIDER - SHOEMAKER DIRECT; UPPER SCHNEIDER - UPPER SCHNEIDER DIRECT; UPPER SCHNEIDER - VICTORIA; UPPER SCHNEIDER - VOISON; UPPER SCHNEIDER - WESTMOUNT DIRECT ...See GIS for a complete list... |
| FLOW_MONITOR_DEVICE |
Is there a flow monitoring device |
VARCHAR2 |
|
SanManholeFlowDevice |
NONE |
ACTIVE; NONE; REMOVED |
| FLOW_DEVICE_INSTALL_DATE |
Flow device installation Date (if Applicable) |
TIMESTAMP(6) |
|
|
|
|
| FLOW_DEVICE_REMOVE_DATE |
Flow Device Removal Date (if Applicable) |
TIMESTAMP(6) |
|
|
|
|
| PHYSICAL_ACCESS |
Is there Physical Access |
VARCHAR2 |
|
YesNo |
Y |
N - NO; U - UNKNOWN; Y - YES |
| LEGAL_ACCESS |
Is there Lagal Access |
VARCHAR2 |
|
YesNo |
U |
N - NO; U - UNKNOWN; Y - YES |
| LOCATION |
Location of Manhole |
VARCHAR2 |
Open text field that describes the location of the feature in more detail. |
|
|
|
| DROP_PIPE_TYPE |
What is the drop pipe type? |
VARCHAR2 |
Entered through CW inspection |
SanManholeDropPipeType |
NONE |
EXTERNAL; INTERNAL; NONE; YES - UNKNOWN |
