Storm_Leads Storm_Leads
Logo

Corporate Production GIS Metadata

Layer Name: Storm_Leads

General Information

Layer Name: Storm_Leads
# of Features: 15166
Status: ACTIVE
Layer Source: GIS_DATA.STM_LEAD
Layer Quality: Good
Feature Accuracy: +/- 1m
Type: POLYLINE
Description: Inventory of storm water leads. A storm lead is a pipe that transport storm water from an inlet or from a private property to the storm water main. Typically, the lead is connected into a storm manhole, however, it may also be connected directly to a storm pipe.
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: Storm Water Leads: Development & Technical Services - Engineering Design Construction (Sept 2002)
History: August 2004 - Conversion of DGN files maintained by Engineering into SDE May 2005 QC of convered attributes June 2005 Input of new Infrastructure August 2005 started updating layer based on Service Agreement: DTS - Engineering : Sanitary, Storm Drainage, Road Infrastructure, Sidewalk, Survey Monumentation. Please see Sevice Agreement for details
Original Source: INS - Engineering
Original Source Process:
Maintenance: Service Agreement: DTS - Engineering : Sanitary, Storm Drainage, Road Infrastructure, Sidewalk, Survey Monumentation. Please see Sevice Agreement for details
Current Info Source: Kitchener As-Builts
Outstanding Issues: Backlog of New Infrastructure from 2002. 1999 Infrastructure with no Attributes, Prior to 1999 Infrastructure Attributes needed QC started.
Update Frequency: CONTINUOUS

Data Fields & Domain Information

Storm_Leads

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.
STMLEADID Stm Lead 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 Road Segment ID NUMBER
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
ROADCONSTLIMITID Road Construction Limit ID NUMBER
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.
LENGTH Length (m) from as built plan NUMBER
MATERIAL Material VARCHAR2 StmLeadMaterial XXX CP - CONCRETE; HDPE - HIGH DENSITY POLYETHYLENE; PVC - POLYVINYL CHLORIDE; XXX - UNKNOWN
DIAMETER Diameter (mm) NUMBER StmLeadDiameter 250 12; 200; 250; 300; 350; 375; 400; 450; 525; 600 ...See GIS for a complete list...
UP_INVERT Upstream Invert Elevation (m) upstream (defined by flow) low end of the inside bottom of the storm lead. NUMBER
DN_INVERT Downstream Invert Elevation (m) downstream (defined by flow) low end of the inside bottom of the storm lead. NUMBER
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 aquired the asset 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
ISSUE_NOTES Issue Notes VARCHAR2
CONSULTANT Name of Consultant that suppied the drawings VARCHAR2
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...