Description: Services: SewerInfrastructureScripts: NoneNotes: The inventory of manholes that are part of Low Impact Developments are maintained by Engineering in the Hansen database. The point features for the location of the manholes are noted in an AutoCAD drawing and must be recognized by the CAD Staff in Geomatics who then must notify GIS staff to update the layer in their SDE so it can be used in a published web service. Primary key: nanForeign key: nan
Description: Services: SewerInfrastructure and MappMyCity Scripts: sewer_update.py Notes: The inventory of sanitary manholes with their location information is maintained by IMS in the Hansen database. The point features for the locations of access points 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 and ACCESS_TYPE fields in order to select the relevant sewer access type such as SANITARY (SEWER_TYPE) MANHOLE (ACCESS_TYPE)Primary key: AP_NUM Foreign key: Varies by ACCESS_TYPE and Hansen Table
Description: Services: SewerInfrastructureScripts: NoneNotes: The inventory of pipelines that are part of Low Impact Developments are maintained by Engineering in the Hansen database. The polyline features for the location of the pipelines are noted in an AutoCAD drawing and must be recognized by the CAD Staff in Geomatics who then must notify GIS staff to update the layer in their SDE so it can be used in a published web service. Primary key: nanForeign key: nan
Description: 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
Description: Services: SewerInfrastructureScripts: NoneNotes: The inventory of areas that are part of Low Impact Developments are maintained by Engineering in the Hansen database. The polygon features for the location of the areas are noted in an AutoCAD drawing and must be recognized by the CAD Staff in Geomatics who then must notify GIS staff to update the layer in their SDE so it can be used in a published web service. Primary key: nanForeign key: nan
Description: Services: SewerInfrasctructure Scripts: NoneNotes: The inventory of the different storm sewer service areas and their location information is maintained by IMS in the Hansen database. The polygon features for the extents are maintained by the IMS staff and 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.Primary key: A_NumForeign key: nan
Description: Services: SewerInfrasctructure Scripts: NoneNotes: The inventory of the different sanitary sewer service areas and their location information is maintained by IMS in the Hansen database. The polygon features for the extents are maintained by the IMS staff and 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.Primary key: A_NumForeign key: nan