| 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. |
|
|
|
| STMINLETID |
Stminlet 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 |
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. |
|
|
|
| ROADSEGMENTID |
Roadsegment ID |
NUMBER |
GIS maintained field. ROADSEGMENTID of the GIS_DATA.ROADSEGMENT layer feature that the storm water inlet is along. A value of -1 indicates that the feature does not follow a road. Roadsegments must have a CATEGORY value of '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 |
GIS maintained field. GENERAL_GRID_ID value of the GIS_DATA.GRID_STANDARD_QUARTERED layer feature which the storm water inlet falls within. A value of -1 indicates that the feature does not fall inside a quarter grid. |
|
|
|
| ROADCONSTLIMITID |
Road Costruction Limit 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 |
Type of Inlet |
VARCHAR2 |
Provided through as-built plan or digital submission. Indicates the type of the inlet. A pick list is used for this field - contact GIS for pick list values. |
StmInletOutletCategory |
|
ENGINEERED; MANHOLE; MODIFIED DOUBLE DITCH INLET CATCH BASIN; MODIFIED DOUBLE SIDE INLET CATCH BASIN; MODIFIED SIDE INLET CATCH BASIN; MODIFIED SIDE INLET CATCH BASIN MANHOLE; MODIFIED SIDE INLET DOUBLE CATCH BASIN MANHOLE; MODIFIED SINGLE INLET CATCH BASIN; MODIFIED STORM MANHOLE; NON ENGINEERED ...See GIS for a complete list... |
| SUBCATEGORY |
Subcategory |
VARCHAR2 |
Provided through as-built plan or digital submission. Indicates the sub type of the inlet. A pick list is used for this field - contact GIS for pick list values. |
StmInletSubCategory |
|
FLOW-RESTRICTED; NORMAL |
| COVER_SHAPE |
Cover Shape of the inlet |
VARCHAR2 |
Provided through as-built plan or digital submission. Indicates the cover shape of the inlet. A pick list is used for this field - contact GIS for pick list values. |
StmShape |
SQUARE |
ARCHED; HORIZONTAL ELLIPTICAL; IRREGULAR; NOT APPLICABLE; OVAL; RECTANGULAR; ROUND; SQUARE; VERTICAL ELLIPTICAL |
| GRATE |
Is a Grate present |
VARCHAR2 |
Provided through as-built plan or digital submission. Indicates if a grate is present for the inlet. A pick list is used for this field - contact GIS for pick list values. |
YesNoLongOnly |
NO |
NO; YES |
| LOCK_TYPE |
Lock Type |
VARCHAR2 |
Provided through as-built plan or digital submission. Indicates the lock type of the inlet. A pick list is used for this field - contact GIS for pick list values. |
StmLockType |
NONE |
BOLTED; NONE; PADLOCK |
| INLET_SHAPE |
Shape of the Inlet |
VARCHAR2 |
Provided through as-built plan or digital submission. Indicates the shape of the inlet. A pick list is used for this field - contact GIS for pick list values. |
StmShape |
ROUND |
ARCHED; HORIZONTAL ELLIPTICAL; IRREGULAR; NOT APPLICABLE; OVAL; RECTANGULAR; ROUND; SQUARE; VERTICAL ELLIPTICAL |
| WIDTH |
Width (mm) Inside cross-sectional width of the inlet |
NUMBER |
Provided through as-built plan or digital submission. Inside cross-sectional width of the inlet in millimetres. A value of -2 indicates that the width was not given or is unknown. A pick list is used for this field - contact GIS for pick list values. |
|
0 |
|
| HEIGHT |
Height (mm) Inside cross-sectional height of the inlet |
NUMBER |
Provided through as-built plan or digital submission. Inside cross-sectional height of the inlet in millimetres. A value of -2 indicates that the height was not given or is unknown. A pick list is used for this field - contact GIS for pick list values. |
|
0 |
|
| EROSION_PROTECTION |
Type of erosion protection |
VARCHAR2 |
Provided through as-built plan or digital submission. Indicates the type of erosion protection for the inlet. A pick list is used for this field - contact GIS for pick list values. |
StmOutletErosion |
|
ENGINEERED WALL; GABION MAT/BASKET; NONE; RIP RAP LINING; VEGETATION / GEOTEXTILE MATTING |
| FLOW_CONTROL_DEVICE |
Is a flow control device is present |
VARCHAR2 |
Provided through as-built plan or digital submission. Indicates if a flow control device is present for the inlet. A pick list is used for this field - contact GIS for pick list values. |
YesNoLongOnly |
NO |
NO; YES |
| FACILITY_TYPE |
Type of feature water leaves from inlet |
VARCHAR2 |
Provided through as-built plan or digital submission. Indicates the type of feature the water leaves when entering the inlet. A pick list is used for this field - contact GIS for pick list values. |
StmInletOutletType |
|
NONE; OGS; POND |
| HEADWALL_MATERIAL |
Headwall Material |
VARCHAR2 |
Provided through as-built plan or digital submission. Headwall material. |
|
|
|
| WINGWALL_MATERIAL |
Wingwall Material |
VARCHAR2 |
Provided through as-built plan or digital submission. Wingwall material. |
|
|
|
| GROUNDWATER_SYSTEM |
Is inlet part of a Groundwater System |
VARCHAR2 |
Provided through as-built plan or digital submission. Indicates if the inlet is a part of the groundwater system. A pick list is used for this field - contact GIS for pick list values. |
YesNoLongOnly |
NO |
NO; YES |
| 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 receive or acquire the inlet. |
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; PURCHASED |
| ISSUE_NOTES |
Issue Notes |
VARCHAR2 |
CoK maintained field. Open text field that is used to identify or list data issues. |
|
|
|
| ENGINEERING_NOTES |
Engineering Notes |
VARCHAR2 |
Engineering maintained field. Open text field for notes. |
|
|
|
| CONSULTANT |
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. |
|
|
|
| REL_STMFACILITYID |
Related Stm Facility ID |
NUMBER |
|
|
|
|
| REL_STMSTREAMREACHID |
Related Stm Stream Reach ID |
NUMBER |
|
|
|
|
| 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 |
|
CAMBRIDGE; DUAL CITY AND REGION; DUAL CITY AND WRDSB; PRIVATE; REGION; SCHOOL BOARD; UNKNOWN; WATERLOO; WELLESLEY; WILMOT ...See GIS for a complete list... |
| COVER_TYPE |
Cover Type |
VARCHAR2 |
|
StmInletOutletCoverType |
|
BIRDCAGE STYLE; DOUBLE CATCH BASIN; GRATE; LID; NONE; OPEN COVER; PERFORATED; SIDE INLET; SLOPED GRATE (HONEYCOMB); SOLID ...See GIS for a complete list... |
| COVER_WIDTH |
Cover Width (mm) |
NUMBER |
|
|
|
|
| DEPTH |
Depth (mm) |
NUMBER |
|
|
|
|
| ELEVATION_TOP |
Elevation Top |
NUMBER |
|
|
|
|
| PIPE_SIZE |
Pipe Size (mm) |
NUMBER |
|
StmPipeWidthHeight |
0 |
0; 3330; 3500; 3700; 4000; 5000; 5050; 5180; 5500; 6200 ...See GIS for a complete list... |
| PIPE_SHAPE |
Pipe Shape |
VARCHAR2 |
|
StmShape |
ROUND |
ARCHED; HORIZONTAL ELLIPTICAL; IRREGULAR; NOT APPLICABLE; OVAL; RECTANGULAR; ROUND; SQUARE; VERTICAL ELLIPTICAL |
| PIPE_INVERT |
Pipe Invert |
NUMBER |
|
|
|
|
| HEADWALL_HEIGHT |
Headwall height (mm) |
NUMBER |
|
StmInletWidthHeight |
0 |
0; 1200; 1350; 1500; 1600; 2000; 2100; 825; 900; 975 ...See GIS for a complete list... |
| HEADWALL_WIDTH |
Headwall width (mm) |
NUMBER |
|
StmInletWidthHeight |
0 |
0; 1200; 1350; 1500; 1600; 2000; 2100; 825; 900; 975 ...See GIS for a complete list... |
| WINGWALL_HEIGHT |
Wingwall height (mm) |
NUMBER |
|
StmInletWidthHeight |
0 |
0; 1200; 1350; 1500; 1600; 2000; 2100; 825; 900; 975 ...See GIS for a complete list... |
| WINGWALL_WIDTH |
Wingwall width (mm) |
NUMBER |
|
StmInletWidthHeight |
0 |
0; 1200; 1350; 1500; 1600; 2000; 2100; 825; 900; 975 ...See GIS for a complete list... |
