| 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. |
|
|
|
| STMMANHOLEID |
Stmmanhole 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. |
|
|
|
| ROADSEGMENTID |
Roadsegment ID |
NUMBER |
|
|
|
|
| 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. |
|
|
|
| QUARTER_GRID_ID |
Quarter Grid ID |
VARCHAR2 |
|
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 Limit ID |
NUMBER |
|
|
|
|
| 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. |
|
|
|
| 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. |
|
|
|
| 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:CATCH BASIN,CATCH BASIN MANHOLE,DOUBLE CATCH BASIN MANHOLE,SIDE INLET CATCH BASIN MANHOLE,SINGLE INLET CATCH BASIN MANHOLE,STORM MANHOLE,TO INPUT,UNKNOWN |
StmManholeCategory |
|
CATCH BASIN MANHOLE; DITCH INLET CATCH BASIN MANHOLE; DOUBLE CATCH BASIN MANHOLE; DOUBLE SIDE INLET CATCH BASIN MANHOLE; SIDE INLET CATCH BASIN MANHOLE; SIDE INLET DOUBLE CATCH BASIN MANHOLE; SINGLE INLET CATCH BASIN MANHOLE; STORM MANHOLE |
| DEPTH |
Depth (mm) |
NUMBER |
|
|
|
|
| COVER_SHAPE |
Cover Shape |
VARCHAR2 |
|
StmManholeCoverShape |
|
RECTANGULAR; ROUND; SQUARE; UNKNOWN |
| COVER_TYPE |
Cover Type |
VARCHAR2 |
|
StmManholeCoverType |
CB FRAME & GRATE |
BIRDCAGE STYLE; DICB; DITCH INLET GRATE; DOUBLE CATCH BASIN; LID; OPEN COVER; PERFORATED; SIDE INLET; SLOPED GRATE (HONEYCOMB); SOLID ...See GIS for a complete list... |
| COVER_ELEVATION |
Cover Elevation (m) |
NUMBER |
|
|
|
|
| SUBDRAIN |
Is there a Sub-drain |
VARCHAR2 |
|
YesNoLongOnly |
NO |
NO; YES |
| RISER_TYPE |
Riser Type |
VARCHAR2 |
|
StmManholeRiserType |
MODULOCK |
MODULOCK |
| INSTALLATION_DATE |
Installation Date |
DATE |
Date the feature was installed |
|
|
|
| INSTALLATION_YEAR |
Installation Year |
NUMBER |
Year the asset was installed. Usually a database maintained field. |
|
|
|
| ACQUISITION |
How the manhole was aquired by the city |
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_NOTES |
Issue Notes |
VARCHAR2 |
|
|
|
|
| ENGINEERING_NOTES |
Engineering Notes |
VARCHAR2 |
|
|
|
|
| CONSULTANT |
Name of consultant that submitted drawings |
VARCHAR2 |
|
|
|
|
| GROUNDWATER_SYSTEM |
Is manhole part of Groundwater System |
VARCHAR2 |
|
YesNoLongOnly |
NO |
NO; YES |
| SAN_SUB_DRAINAGE_AREA |
San 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... |
| OWNERSHIP |
Asset Owner |
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 |
|
CAMBRIDGE; DUAL CITY AND REGION; DUAL CITY AND WRDSB; PRIVATE; REGION; SCHOOL BOARD; UNKNOWN; WATERLOO; WELLESLEY; WILMOT ...See GIS for a complete list... |
| PRIORITY_SNOW_CLEARING |
Is Priority Snow Clearing Needed |
VARCHAR2 |
|
YesNoOnly |
N |
No; Yes |
| SPLITTER |
Is there a Splitter |
VARCHAR2 |
|
YesNoOnly |
N |
No; Yes |
| CLEANOUT_CATEGORY |
Cleanout Category |
VARCHAR2 |
|
StmCleanoutCategory |
NA |
COMMERCIAL OR INDUSTRIAL; DRAINAGE AREA; MATURE SUBDIVISION; NA; NEW SUBDIVISION; OLD SUBDIVISION |
| SUMP |
Is there a Sump present |
VARCHAR2 |
|
YesNoLongOnly |
NO |
NO; YES |
| FISH_PLATE |
Is there a Fish Plate stamp |
VARCHAR2 |
|
YesNo |
N |
N - NO; U - UNKNOWN; Y - YES |
| LOCATION |
Location |
VARCHAR2 |
Open text field that describes the location of the feature in more detail. |
|
|
|
| GENERAL_GRID |
General Grid ID |
VARCHAR2 |
|
GridStandardID |
|
277; 563; 582; 583; 584; 585; 586; 587; 607; 608 ...See GIS for a complete list... |
| CB_INSERT |
Is there a Catchbasin Insert |
VARCHAR2 |
|
YesNoOnly |
N |
No; Yes |
| LEGAL_ACCESS |
Is there Legal Access |
VARCHAR2 |
|
YesNoOnly |
Y |
No; Yes |
| PHYSICAL_ACCESS |
Is there Physical Access |
VARCHAR2 |
|
YesNoOnly |
Y |
No; Yes |
| MAX_MH_WIDTH |
Max Manhole Width (mm) |
NUMBER |
|
|
|
|
| FLOW_MONITOR_DEVICE |
FLOW_MONITOR_DEVICE |
VARCHAR2 |
|
SanManholeFlowDevice |
NONE |
ACTIVE; NONE; REMOVED |
| FLOW_DEVICE_INSTALL_DATE |
FLOW_DEVICE_INSTALL_DATE |
TIMESTAMP(6) |
|
|
|
|
| FLOW_DEVICE_REMOVE_DATE |
FLOW_DEVICE_REMOVE_DATE |
TIMESTAMP(6) |
|
|
|
|
| STM_SUB_WATERSHED |
STM_SUB_WATERSHED |
VARCHAR2 |
|
|
|
|
