Combined Sewer

Services: SewerInfrastructure and MappMyCity Scripts: sewer_update.py Notes: The inventory of sewer pipelines with their location information is maintained by IMS in the Hansen database. The polyline features for the locations of pipelines are maintained by the CAD staff in the Geomatics department in an AutoCAD drawing. The GIS team then converts this AutoCAD drawing to a feature layer in their SDE so it can be used in a published web service. This layer is updated upon request by Geomatics using a python script that combines the CAD geometry with attributes from Hansen. Queries can be conducted on the SEWER_TYPE to select the relevant sewer access type such as SANITARY (SEWER_TYPE)Primary key: COMPKEYForeign key: COMPKEY