| 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. |
|
|
|
| STMFACILITYID |
Stmfacilityid |
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. |
|
|
|
| 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. |
|
|
|
| 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. |
|
|
|
| STATUS |
Status |
VARCHAR2 |
Indicates the status of feature. A pick list is used for this field - contact GIS for pick list values. |
GISStatusPlanned |
PLANNED |
ACTIVE; PLANNED; UNKNOWN |
| STATUS_DATE |
Status Date |
DATE |
Database maintained field. Updates to the current date/time when the STATUS field value is changed. |
|
|
|
| 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. |
|
|
|
| CATEGORY |
Category |
VARCHAR2 |
|
StmFacilityCategory |
ENGINEERED |
ENGINEERED; NATURAL |
| STMFACILITY_REF_NO |
Stm Facility Ref No |
NUMBER |
|
|
|
|
| FACILITY_NAME |
Facility Name |
VARCHAR2 |
|
|
|
|
| LOCATION_DESCRIPTION |
Location Description |
VARCHAR2 |
Open text field that describes the location of the feature. |
|
|
|
| MAINTENANCE_RESPONSIBILITY |
Maintenance Responsibility |
VARCHAR2 |
|
StmFacilityMaintResponse |
DEVELOPER |
DEVELOPER; KITCHENER; NONE; OTHER |
| PARCELID |
Parcelid |
NUMBER |
Reference Parcel ID that the feature is located in. The value is either manually entered or generated from a spatial join process. |
|
|
|
| PARK |
Park |
VARCHAR2 |
|
|
|
|
| REGISTERED_PLAN |
Registered Plan |
VARCHAR2 |
|
|
|
|
| INSTALLATION_YEAR |
Installation Year |
NUMBER |
Year the asset was installed. Usually a database maintained field. |
|
|
|
| ACQUISITION |
Acquisition |
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 |
| CATCHMENT_AREA_HA |
Catchment Area (ha) |
NUMBER |
|
|
|
|
| DISCHARGES_INTO |
Discharges Into |
VARCHAR2 |
|
|
|
|
| CREEK_NAME |
Creek Name |
VARCHAR2 |
|
StmStreamReachName |
NONE |
ALDER CREEK; NONE; OTHER; STRASBURG CREEK; STRASBURG CREEK MAIN BRANCH; STRASBURG CREEK MIDDLE BRANCH; STRASBURG CREEK NORTH BRANCH; STRASBURG CREEK SOUTH BRANCH; VOISIN CREEK; WESTMOUNT CREEK ...See GIS for a complete list... |
| DRAWDOWN_2YR_HRS |
Drawdown 2Yr Hrs |
NUMBER |
|
|
|
|
| DRAWDOWN_5YR_HRS |
Drawdown 5Yr Hrs |
NUMBER |
|
|
|
|
| DRAWDOWN_25YR_HRS |
Drawdown 25Yr Hrs |
NUMBER |
|
|
|
|
| DRAWDOWN_100YR_HRS |
Drawdown 100Yr Hrs |
NUMBER |
|
|
|
|
| DRAWDOWN_REGYR_HRS |
Drawdown Regyr Hrs |
NUMBER |
|
|
|
|
| SHAPE |
Shape |
ST_GEOMETRY |
ESRI system maintained field. Stores the geometry type and geometry of the feature. |
|
|
|
| HABITAT_PROTECTION_LEVEL |
Habitat Protection Level |
VARCHAR2 |
|
StmFacilityHabitatProLvl |
NONE |
BASIC; ENHANCED; NONE; NORMAL |
| FENCED |
Fenced |
VARCHAR2 |
|
YesNoLongOnly |
NO |
NO; YES |
| SIGNAGE |
Signage |
VARCHAR2 |
|
YesNoLongOnly |
NO |
NO; YES |
| STORM_EVENT_DESIGN_REQUIREMENT |
Storm Event Design Requirement |
VARCHAR2 |
|
|
|
|
| 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. |
|
|
|
| QUANTITY_FACILITY |
Quantity Facility |
VARCHAR2 |
|
YesNoLongOnly |
NO |
NO; YES |
| QUALITY_FACILITY |
Quality Facility |
VARCHAR2 |
|
YesNoLongOnly |
NO |
NO; YES |
| 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. |
StmFacilityOwnership |
DEVELOPER |
DEVELOPER; KITCHENER; OTHER; REGION |
| DESIGN_REPORT_NAME |
Design Report Name |
VARCHAR2 |
|
|
|
|
| DESIGN_REPORT_AUTHOR |
Design Report Author |
VARCHAR2 |
|
|
|
|
| REPORT_PUBLISHED_DATE |
Report Published Date |
DATE |
|
|
|
|
| FACILITY_TYPE |
Facility Type |
VARCHAR2 |
|
StmFacilityFacType |
NATURAL POND |
DRY POND; NATURAL POND; WET POND; WETLAND |
| SUBWATERSHED |
Subwatershed |
VARCHAR2 |
|
StmSubwatershed |
NONE |
ALDER CREEK; NONE; NORTH STRASBURG CREEK; UNNAMED CATCHMENT 1; UNNAMED CATCHMENT 2; UNNAMED CATCHMENT 3; UNNAMED CATCHMENT 4; UPPER SCHNEIDER CREEK; VOISIN CREEK; WESTMOUNT CREEK ...See GIS for a complete list... |
| PERMANENT_POOL_TOTAL_VOLUME_M3 |
Permanent Pool Total Volume M3 |
NUMBER |
|
|
|
|
| EXTENDED_DETENTION_ELEVATION_M |
Extended Detention Elevation M |
NUMBER |
|
|
|
|
| EXTENDED_DETENTION_VOLUME_M3 |
Extended Detention Volume M3 |
NUMBER |
|
|
|
|
| ADJACENT_LAND_USE |
Adjacent Land Use |
VARCHAR2 |
|
StmFacilityAdjLandUse |
OTHER |
COMMERCIAL; INDUSTRIAL; OTHER; RESIDENTIAL |
| ENG_NOTES |
Engineering Notes |
VARCHAR2 |
Input by Engineering staff. Open text field for notes. |
|
|
|
| ECA_REFERENCE_NUMBER |
ECA Reference Number |
VARCHAR2 |
|
|
|
|
| INFILTRATION_FACILITY |
Infiltration Facility |
VARCHAR2 |
|
YesNoLongOnly |
NO |
NO; YES |
| WHPA_VULNERABILITY |
Whpa Vulnerability |
VARCHAR2 |
|
StmFacilityWhpaVul |
NONE |
HIGH; LOW; NONE |
| LAST_SEDIMENT_TESTING_DATE |
Last Sediment Testing Date |
DATE |
|
|
|
|
| LAST_INSPECTION_DATE |
Last Inspection Date |
DATE |
|
|
|
|
| ADDRESS |
Address |
VARCHAR2 |
Street address the feature is located at. Includes both a civic number and a street. |
|
|
|
| WARD |
WARD |
VARCHAR2 |
Reference Ward that the feature is located in. The value is either manually entered or generated from a spatial join process. |
WardCodedValues |
|
Ward 1; Ward 10; Ward 3; Ward 4; Ward 5; Ward 6; Ward 7; Ward 8; Ward 9; unknown |
