| 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. |
|
|
|
| STMCATCHBASINID |
Stmcatchbasinid |
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 |
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'. |
|
|
|
| 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 |
Input by GIS staff. Standard 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 Limit ID |
NUMBER |
This field is not being used at this time. |
|
|
|
| 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 |
Provided through as-built plan or digital submission. Primary mapping field of the layer. Valid category values are:CATCH BASIN,CATCH BASIN MANHOLE,DITCH INLET CATCH BASIN,DOUBLE CATCH BASIN,DOUBLE SIDE INLET CATCH BASIN,FRENCH DRAIN,SIDE INLET CATCH BASIN,TO INPUT,UNKNOWN |
StmCatchbasinCategory |
|
CATCH BASIN; DITCH INLET CATCH BASIN; DOUBLE CATCH BASIN; DOUBLE DITCH INLET CATCH BASIN; DOUBLE SIDE INLET CATCH BASIN; FRENCH DRAIN; SIDE INLET CATCH BASIN |
| 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 |
KITCHENER |
CAMBRIDGE; DUAL CITY AND REGION; DUAL CITY AND WRDSB; PRIVATE; REGION; SCHOOL BOARD; UNKNOWN; WATERLOO; WELLESLEY; WILMOT ...See GIS for a complete list... |
| WATERGRID |
Water Grid ID |
VARCHAR2 |
Input by GIS staff. Water grid. |
|
|
|
| DEPTH |
Depth (mm) |
NUMBER |
Provided through as-built plan or digital submission. Working depth. |
|
|
|
| SUMP |
Is a Sump Present |
VARCHAR2 |
Provided through as-built plan or digital submission. Sump present indication. |
YesNoLongOnly |
YES |
NO; YES |
| COVER_SHAPE |
Cover Shape |
VARCHAR2 |
Provided through as-built plan or digital submission. Cover shape. |
StmCatchbasinCoverShape |
SQUARE |
RECTANGULAR; ROUND; SQUARE |
| COVER_TYPE |
Cover Type |
VARCHAR2 |
Provided through as-built plan or digital submission. Cover type. |
StmCatchbasinCoverType |
GRATE |
GRATE; NONE; OPEN COVER; SIDE INLET |
| SUBDRAIN |
Is a Sub-drain present |
VARCHAR2 |
Provided through as-built plan or digital submission. Subdrain present indication. |
YesNoLongOnly |
NO |
NO; YES |
| LEAD_INVERT |
Lead Invert: Invert of outgoing pipe |
NUMBER |
Provided through as-built plan or digital submission. Invert of outgoing pipe. |
|
|
|
| ELEVATION_TOP |
Elevation (m) at Top of Cathcbasin |
NUMBER |
Provided through as-built plan or digital submission. Elevation at top. |
|
|
|
| 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 did the city received or acquired the feature |
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 |
| ENGINEERING_NOTES |
Engineering Notes |
VARCHAR2 |
Input by Engineering staff. Open text field for notes. |
|
|
|
| ISSUE_NOTES |
Issue Notes |
VARCHAR2 |
Input by GIS staff. Open text field that is used to identify or list data issues of records. |
|
|
|
| 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 |
San Sub Drainage Area |
VARCHAR2 |
Input by GIS staff. Sanitary sub drainage area. |
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... |
| PRIORITY_SNOW_CLEARING |
Priority Snow Clearing Needed |
VARCHAR2 |
|
YesNoOnly |
N |
No; Yes |
| CLEANOUT_CATEGORY |
Type of Cleanout |
VARCHAR2 |
|
StmCleanoutCategory |
NA |
COMMERCIAL OR INDUSTRIAL; DRAINAGE AREA; MATURE SUBDIVISION; NA; NEW SUBDIVISION; OLD SUBDIVISION |
| FISH_PLATE |
Fish Plate Stamp on Catchbasin |
VARCHAR2 |
|
YesNoOnly |
N |
No; Yes |
| LOCATION |
Location |
VARCHAR2 |
Open text field that describes the location of the feature in more detail. |
|
|
|
| GENERAL_GRID |
General Grid ID |
VARCHAR2 |
Input by GIS staff. Standard grid. |
GridStandardID |
|
277; 563; 582; 583; 584; 585; 586; 587; 607; 608 ...See GIS for a complete list... |
| CB_INSERT |
Are there any Catchbasin Inserts |
VARCHAR2 |
Provided through as-built plan or digital submission. Identify the presence of any catchbasin inserts such as CB Shields etc. |
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 |
