| 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. |
|
|
|
| STMOUTLETID |
Stmoutlet 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 |
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 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. |
|
|
|
| FACILITY_TYPE |
Type of feature water enters when exiting the outlet |
VARCHAR2 |
Provided through as-built plan or digital submission. Indicates the type of feature the water enters when exiting the outlet. A pick list is used for this field - contact GIS for pick list values. |
StmInletOutletType |
|
NONE; OGS; POND |
| 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... |
| OUTLET_SHAPE |
Outlet Shape |
VARCHAR2 |
Provided through as-built plan or digital submission. Indicates the shape of the outlet. 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) how the city received or acquired the feature |
NUMBER |
Provided through as-built plan or digital submission. Inside cross-sectional width of the outlet 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. |
StmInletWidthHeight |
0 |
0; 1200; 1350; 1500; 1600; 2000; 2100; 825; 900; 975 ...See GIS for a complete list... |
| HEIGHT |
Height (mm) Inside cross-sectional height of the outlet |
NUMBER |
Provided through as-built plan or digital submission. Inside cross-sectional height of the outlet 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. |
StmInletWidthHeight |
0 |
0; 1200; 1350; 1500; 1600; 2000; 2100; 825; 900; 975 ...See GIS for a complete list... |
| ENERGY_DISSIPATION |
Type of Energy Dissipation Present |
VARCHAR2 |
Provided through as-built plan or digital submission. Indicates the type of energy dissipation for the outlet. |
StmOutletEnergyDisp |
|
ENGINEERED WALL/CONCRETE BAFFLES; GROUTED RIP RAP; NONE; PLUNGE POOL |
| GRATE |
Is a Grate Present |
VARCHAR2 |
Provided through as-built plan or digital submission. Indicates if a grate is present for the outlet. A pick list is used for this field - contact GIS for pick list values. |
YesNoLongOnly |
NO |
NO; YES |
| GRATE_LOCK_TYPE |
Grate Lock Type Present |
VARCHAR2 |
Provided through as-built plan or digital submission. Indicates the lock type of the outlet. A pick list is used for this field - contact GIS for pick list values. |
StmLockType |
NONE |
BOLTED; NONE; PADLOCK |
| EROSION_PROTECTION |
Type of Erosion Protection |
VARCHAR2 |
Provided through as-built plan or digital submission. Indicates the type of erosion protection for the outlet. 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 |
| ENDWALL_HEIGHT |
Endwall Height (mm) |
NUMBER |
Provided through as-built plan or digital submission. Endwall height in millimetres. A value of -2 indicates that the height was not given or is unknown. |
|
|
|
| ENDWALL_WIDTH |
Endwall Width (mm) |
NUMBER |
Provided through as-built plan or digital submission. Endwall width in millimetres. A value of -2 indicates that the width was not given or is unknown. |
|
|
|
| ENDWALL_MATERIAL |
Endwall Material |
VARCHAR2 |
Provided through as-built plan or digital submission. Endwall material. |
|
|
|
| WINGWALL_HEIGHT |
Wingwall Height (mm) |
NUMBER |
Provided through as-built plan or digital submission. Wingwall height in millimetres. A value of -2 indicates that the height was not given or is unknown. |
|
|
|
| WINGWALL_WIDTH |
Wingwall Width (mm) |
NUMBER |
Provided through as-built plan or digital submission. Wingwall width in millimetres. A value of -2 indicates that the width was not given or is unknown. |
|
|
|
| WINGWALL_MATERIAL |
Wingwall Material |
VARCHAR2 |
Provided through as-built plan or digital submission. Wingwall material. |
|
|
|
| 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 city received or acquired the outlet |
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. |
|
|
|
| GROUNDWATER_SYSTEM |
Is Outlet part of a Groundwater System |
VARCHAR2 |
Provided through as-built plan or digital submission. Indicates if the outlet 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 |
| REL_STMFACILITYID |
Related Stm Facility ID |
NUMBER |
|
|
|
|
| REL_STMSTREAMREACHID |
Related Stm Stream Reach ID |
NUMBER |
|
|
|
|
| CATEGORY |
Category |
VARCHAR2 |
|
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... |
| LOCK_TYPE |
Lock Type |
VARCHAR2 |
|
StmLockType |
NONE |
BOLTED; NONE; PADLOCK |
| COVER_SHAPE |
Cover Shape |
VARCHAR2 |
|
StmShape |
|
ARCHED; HORIZONTAL ELLIPTICAL; IRREGULAR; NOT APPLICABLE; OVAL; RECTANGULAR; ROUND; SQUARE; VERTICAL ELLIPTICAL |
| COVER_WIDTH |
Cover Width (mm) |
NUMBER |
|
|
|
|
| DEPTH |
Depth (m) |
NUMBER |
|
|
|
|
| ELEVATION_TOP |
Elevation Top (mm) |
NUMBER |
|
|
|
|
| INLET_SHAPE |
Inlet Shape |
VARCHAR2 |
|
StmShape |
ROUND |
ARCHED; HORIZONTAL ELLIPTICAL; IRREGULAR; NOT APPLICABLE; OVAL; RECTANGULAR; ROUND; SQUARE; VERTICAL ELLIPTICAL |
| PIPE_SHAPE |
Pipe Shape |
VARCHAR2 |
|
StmShape |
ROUND |
ARCHED; HORIZONTAL ELLIPTICAL; IRREGULAR; NOT APPLICABLE; OVAL; RECTANGULAR; ROUND; SQUARE; VERTICAL ELLIPTICAL |
| PIPE_SIZE |
Pipe Size (mm) |
NUMBER |
|
StmPipeWidthHeight |
0 |
0; 3330; 3500; 3700; 4000; 5000; 5050; 5180; 5500; 6200 ...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... |
| PIPE_INVERT |
Pipe Invert (mm) |
NUMBER |
|
|
|
|
