Sanitary_Pumping_Stations Sanitary_Pumping_Stations
Logo

Corporate Production GIS Metadata

Layer Name: Sanitary_Pumping_Stations

General Information

Layer Name: Sanitary_Pumping_Stations
# of Features: 28
Status: ACTIVE
Layer Source: GIS_DATA.SAN_PUMPING_STATION
Layer Quality: Good
Feature Accuracy: +/- 1m
Type: POINT
Description: Point location of sanitary pumping stations operated by Kitchener and the Region which can be either a building, can or wet well panel facility.
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: Sanitary Pumping Stations: Insfrastructure Services - Operation (Current to date of printing)
History: Bryan Dubrick at Operations has provided the location of the pumping stations and the data associated with each of them. Currently 2 pumping stations are owned and maintained by the Region. One pumping station is located outside of Kitchener in Mannhiem and is operated by the City on behalf of Wilmot Township.
Original Source: INS - Engineering - Operations
Original Source Process:
Maintenance: No formal process
Current Info Source: Ortho Imagery and Operations staff.
Outstanding Issues:
Update Frequency: CONTINUOUS

Data Fields & Domain Information

Sanitary_Pumping_Stations

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.
SANPUMPINGSTATIONID Sanpumpingstationid 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.
ROADSEGMENTID Roadsegmentid NUMBER
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.
PROPERTYUNITID Propertyunitid NUMBER Reference Address ID (Property_unit) that the feature is addresses to. The value is either manually entered or generated from a spatial join process
CIVIC_NO Civic No NUMBER Integer value. Civic address of the feature.
STREET Street VARCHAR2 Street name of the feature based on the STREET MASTER Table.
PUMPING_STATION Pumping Station VARCHAR2 SanPumpSta BRIDGEPORT REGIONAL PUMPING STATION; PS 02; PS 19; PS 20; PS 21; PS 22; PS 23; PS 24; RIVERBEND REGIONAL PUMPING STATION; UNKNOWN ...See GIS for a complete list...
ALTERNATE_NAME Alternate Name VARCHAR2 SanPumpStaAltName APPLE TREE PUMPING STATION; NATHALIE PUMPING STATION; PLANNED PUMPING STATION 2; RIVER BIRCH PUMPING STATION; RIVERBEND REGIONAL PUMPING STATION; SPRINGMOUNT PUMPING STATION; STOKE PUMPING STATION; UNKNOWN; VICTORIA PUMPING STATION; ZELLER PUMPING STATION ...See GIS for a complete list...
NUMBER_OF_PUMPS Number Of Pumps NUMBER
BACKUP_GENERATOR Backup Generator VARCHAR2 YesNoLong NO; UNKNOWN; YES
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.
ENGINEERING_NOTES Engineering Notes VARCHAR2
CONSULTANT Name of consultant that submitted drawings VARCHAR2
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.
CATEGORY Category VARCHAR2
SUBCATEGORY Subcategory VARCHAR2
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.
MUNICIPAL_FACILITY Municipal Facility VARCHAR2 If the feature is maintained by the City of Kitchener it is determined to be a Municipal facility. YesNo N N - NO; U - UNKNOWN; Y - YES
LOCATION_DESCRIPTION Location Description VARCHAR2 Open text field that describes the location of the feature.
ON_CALL On Call VARCHAR2 If the feature is part of the On-Call system at the City of Kitchener YesNo N N - NO; U - UNKNOWN; Y - YES
DIVISION_RESPONSIBLE Division Responsible VARCHAR2 Asset Lead: The division at the City of Kitchener responsible for the asset financially. GISDivisionResponsible STORM AND SANITARY UTILITY AGREEMENT - INS - PARKING; OPERATIONS (CEMETERIES); OPERATIONS (ROADS); OPERATIONS (TURF); PARKING; PLANNING; SPORT; STORM AND SANITARY UTILITY; TRANSPORTATION PLANNING; UNKNOWN ...See GIS for a complete list...
ASSOCIATED_LAND_AREA Associated Land Area NUMBER Area (generally in m2) of the land associated with the feature.
CONSTRUCTION_YEAR Construction Year VARCHAR2 Estimate of the feature''s construction year
TAG1 Tag1 VARCHAR2 Temporary location to store short term data for mapping purposes only.
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 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.
SHAPE SHAPE ST_GEOMETRY ESRI system maintained field. Stores the geometry type and geometry of the feature.
PUMPING_STATION_NAME Pumping Station Name VARCHAR2 SanPumpStaName APPLE TREE PUMPING STATION; NATHALIE PUMPING STATION; RIVER BIRCH PUMPING STATION; RIVERBEND REGIONAL PUMPING STATION; SHIRLEY BRESLAU PUMPING STATION; SHIRLEY PUMPING STATION; SPRINGMOUNT PUMPING STATION; STOKE PUMPING STATION; UNKNOWN; WOOLNER TRAIL PUMPING STATION ...See GIS for a complete list...