Water_Service_Pipes Water_Service_Pipes
Logo

Corporate Production GIS Metadata

Layer Name: Water_Service_Pipes

General Information

Layer Name: Water_Service_Pipes
# of Features: 71432
Status: ACTIVE
Layer Source: GIS_DATA.WAT_SERVICE_PIPE
Layer Quality: Good
Feature Accuracy: +/- 2m
Type: POLYLINE
Description: Inventory of all 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: Water Service Pipe: Corporate Services - Technology Innovation and Services - Geospatial Data and Analytics (Current to date of printing)
History:
Original Source: INS - Utilities
Original Source Process:
Maintenance:
Current Info Source:
Outstanding Issues:
Update Frequency: CONTINUOUS

Data Fields & Domain Information

Water_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.
WATSERVICEPIPEID Watservicepipeid 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. GISStatusAbandoned ACTIVE ABANDONED; ACTIVE; 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 Primary mapping field of the layer. Valid category values are:ADDRESS,HYDRANT WatServiceCategory ADDRESS; HYDRANT; UNKNOWN
REL_WATERMAINID Rel Watermainid NUMBER
PROPERTY_UNIT_ID Property Unit Id NUMBER
TAG1 Tag1 VARCHAR2 Temporary location to store short term data for mapping purposes only.
SHAPE SHAPE ST_GEOMETRY ESRI system maintained field. Stores the geometry type and geometry of the feature.
MAPPED_FROM Mapped From VARCHAR2 WatServPipeMappedFrom CORRECT LOC PENDING; ESTIMATED LOCATION; FROM CONSTRUCTION; FROM LOCATE; UNKNOWN
DIAMETER Diameter in mm NUMBER WatServiceDiameter 0 0; 100; 150; 200; 250; 300; 32; 38; 50; 75 ...See GIS for a complete list...
MATERIAL Material VARCHAR2 WatServPipeMaterial XXX AC - ASBESTOS CEMENT; PE - POLYETHYLENE; PE IN CI - POLYETHYLENE IN CAST IRON; PEX - CROSS LINKED POLYETHYLENE; PVC - POLYVINYL CHLORIDE; PVCB - POLYVINYL CHLORIDE BIONAX; PVCF - POLYVINYL CHLORIDE FUSIBLE; PVCO - POLYVINYL CHLORINE ORIENTATED; ST - STEEL; XXX - UNKNOWN ...See GIS for a complete list...
VALVE_TURNS Valve Turns NUMBER
VALVE_LEFT Valve Left VARCHAR2 GISOpenClosed U C - CLOSED; O - OPEN; U - UNKNOWN
INSTALLATION_DATE Installation Date DATE Date the feature was installed
KU_NOTES Ku Notes VARCHAR2 Input by Utilities staff. Open text field for notes.
ENGINEERING_NOTES Engineering Notes VARCHAR2 Input by Engineering staff. Open text field for notes.
CONSULTANT Consultant VARCHAR2
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.
LIVE_NOT_CONNECTED Live not connected VARCHAR2 YesNo N N - NO; U - UNKNOWN; Y - YES