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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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 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: 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: 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: UtilitiesAssetsLayersEIS
Scripts: None
Notes: The inventory of fire hydrants with their location information is maintained by Enwin in the their database. The point features for the location of the hydrants are provided as shape files to the Geomatics team on a monthy basis from Enwin.
Primary key: FACILITYID
Foreign key: nan
Description: Services: UtilitiesAssetsLayersEIS
Scripts: None
Notes: The inventory of poles with their location information is maintained by Enwin in the their database. The point features for the location of the poles are provided as shape files to the Geomatics team on a quarterly basis from Enwin.
Primary key: FACILITYID
Foreign key: nan
Description: Services: UtlilityLayersEIS
Scripts: None
Notes: The inventory of cable and the locations it runs along are maintained in a spreadsheet by Traffic. When changes are made to the cable network the CAD staff in Geomatics is notified to update the Auto CAD drawing of record. The GIS staff from Geomatics then takes this CAD drawing and converts it to a feature layer so it may be published as a web service to be used in web applications.
Primary key: nan
Foreign key: nan
Description: Services: GridLayersEIS and MappMyCity
Scripts: None
Notes: The tiles and the area covered by each in this layer correspond to the AutoCAD mapbooks and their contents maintained by the CAD staff in the Geomatics department. This layer serves as a means to provide links to the corresponding mapbook files on the geomatics server which can be found in the LINK field in the feature layer. This layer only needs updates when the letter code to a tile or the link location of the mapbook file changes.
Primary key: nan
Foreign key: nan