Storm_Stream_Reach Storm_Stream_Reach
Logo

Corporate Production GIS Metadata

Layer Name: Storm_Stream_Reach

General Information

Layer Name: Storm_Stream_Reach
# of Features: 1463
Status: ACTIVE
Layer Source: GIS_DATA.STM_STREAM_REACH
Layer Quality: Good
Feature Accuracy: +/- 2m
Type: POLYLINE
Description: Location of storm water stream reaches.
Projection: NAD 83 UTM Zone 17N (EPSG 26917)
Disclaimer: The City of Kitchener assumes no responsibility for the accuracy of the provided data. Any use of this information is done so at the users risk. Good survey practices must be applied when utilizing this information. The City of Kitchener and its partners have created this data for information purposes on an as-is and as available basis and is under no circumstances a substitute for a Legal Survey. The City does not make any representations or warranty, express or implied, concerning the accuracy, quality, likely results, or reliability of the use of the data. The City of Kitchener assumes no responsibility for any errors and is not liable for any damages of any kind resulting from the use of, or reliance on, the information and material contained in this layer. All information should be verified independently before being used or relied on. Users are encouraged to contact the City of Kitchener to ensure the accuracy of the information provided by Kitchener.

Source and Contraints

Source Map Label: Stream Reach: Infrastructure Services - Engineering (July 2013)
History: July 2013 - Conversion from Engineering personal geodatabase into SDE. Minor editing of structure and features.
Original Source: INS - Engineering
Original Source Process:
Maintenance:
Current Info Source:
Outstanding Issues:
Update Frequency: CONTINUOUS

Data Fields & Domain Information

Storm_Stream_Reach

Column Name Alias Data Type Comments Domain Name Default value Domain Values
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.
STMSTREAMREACHID Stmstreamreachid 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.
SHAPE SHAPE ST_GEOMETRY ESRI system maintained field. Stores the geometry type and geometry of the feature.
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.
SOURCE Source VARCHAR2 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.
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
STATUS_DATE Status Date DATE Database maintained field. Updates to the current date/time when the STATUS field value is changed.
CATEGORY Category VARCHAR2 Primary mapping field of the layer. Valid category values are:INTERMITTENT,MAJOR,MINOR StmStreamReachCategory INTERMITTENT; LINK - FACILITY; LINK - GRAND RIVER; LINK - STREAM; MAJOR; MINOR
WATERCOURSE_NAME Watercourse Name VARCHAR2 Name of the larger watercourse. The default value is 'TO INPUT'. Valid values are all the watercourse names. The value 'UNKNOWN' indicates that the watercourse name was not given or is unknown. StmStreamReachWatercourseName NONE ALDER CREEK; NONE; OTHER; SANDROCK CREEK; SCHNEIDER CREEK; SCHOOL CREEK; SHOEMAKER CREEK; STRASBURG CREEK; VOISIN CREEK; WESTMOUNT CREEK ...See GIS for a complete list...
REACH_NAME Reach Name VARCHAR2 Name of the smaller reach. The default value is 'TO INPUT'. Valid values are all the reach names. The value 'UNKNOWN' indicates that the reach name was not given or is unknown. 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...
REACH_ID Reach Id VARCHAR2 Value identying the reach for each section.
SECTION_ID Section Id VARCHAR2 Value identying each section.
CHANNEL Channel VARCHAR2 Identifies the material/condition of the bottom of the stream reach. The default value is 'TO INPUT'. Valid values are 'CHANNELIZED', 'CONCRETE', 'NATURAL/MIXED', and 'REHABILITATED'. The value 'UNKNOWN' indicates that the channel material/condition was not given or is unknown. StmStreamReachChannel NONE CHANNELIZED; CONCRETE; NATURAL/MIXED; NONE; REHABILITATED
LOCATION_DESCRIPTION Location Description VARCHAR2 Open text field that describes the location of the feature.
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. StmStreamReachOwnership KITCHENER GRCA; HYDRO; KITCHENER; PRIVATE; PROVINCE; RAILWAY; REGION; SCHOOL BOARD; WATERLOO
MAINTENANCE_RESPONSIBILITY Maintenance Responsibility VARCHAR2 StmStreamReachMaintenance STORM UTILITY PRIVATE; STORM UTILITY
WARRANTY_DATE Warranty Date TIMESTAMP(6)