Storm_Service

Storm_Service_Pipes Storm_Service_Pipes

Corporate Production GIS Metadata

Layer Name: Storm_Service_Pipes

General Information

Layer Name:	Storm_Service_Pipes
# of Features:	23700
Status:	ACTIVE
Layer Source:	GIS_DATA.STM_SERVICE_PIPE
Layer Quality:	Good
Feature Accuracy:	+/- 1m
Type:	POLYLINE
Description:	Inventory of storm water service pipes
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:	Stm Service Pipe: Corporate Services - Technology Innovation and Services - GDA (Current)
History:
Original Source:	INS - Engineering
Original Source Process:
Maintenance:
Current Info Source:
Outstanding Issues:
Update Frequency:	CONTINUOUS

Data Fields & Domain Information

Storm_Service_Pipes

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.
STMSERVICEPIPEID	Stm Service Pipe 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.
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.
STATUS	Status	VARCHAR2	Indicates the status of feature. A pick list is used for this field - contact GIS for pick list values.	SanStmServicePipeStatus	ACTIVE	ACTIVE; ESTIMATED LOCATION; UNKNOWN
STATUS_DATE	Status Date	DATE	Database maintained field. Updates to the current date/time when the STATUS field value is changed.
CREATE_DATE	Create Date	DATE	Database maintained field. Updates to the current data/time. Update takes place when the feature is created.
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.
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.
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.
SHAPE	SHAPE	ST_GEOMETRY	ESRI system maintained field. Stores the geometry type and geometry of the feature.
MATERIAL	Material	VARCHAR2		StmServiceMaterial	POLYVINYL CHLORIDE	CLAY; CONCRETE; POLYVINYL CHLORIDE
DIAMETER	Diameter (mm)	NUMBER		StmPipeWidthHeight	0	0; 3330; 3500; 3700; 4000; 5000; 5050; 5180; 5500; 6200 ...See GIS for a complete list...
GROUNDWATER_SYSTEM	Is Pipe part of a Groundwater System	VARCHAR2		YesNoLongOnly	NO	NO; YES
INSTALLATION_DATE	Installation Date	DATE	Date the feature was installed
ENGINEERING_NOTES	Engineering Notes	VARCHAR2
CONSULTANT	Name of consultant that submitted drawings	VARCHAR2
INSTALLATION_YEAR	Installation Year	NUMBER	Year the asset was installed. Usually a database maintained field.
LINER_YEAR	Year Liner Installed	NUMBER
CAPPED	Is the service capped?	VARCHAR2		YesNoLongOnly	NO	NO; YES