Description: Services:Scripts: NoneNotes: This layer was generated by the Geomatics team using archived feature classes that were then compressed and can be queried by type.Primary key: nanForeign key: nan
Description: Services: BasemapLayersEIS
Scripts: None
Notes: Generated by Geomatics based on the location of the airport runways from an aerial photo. Unknow how up to date it is.
Primary key: nan
Foreign key: nan
Description: Services: TrailsBikeLaneLayers and MappMyCity
Scripts: None
Notes: The inventory of trails assets is maintained by the Parks department in their CityWide database. They provide data exports to Geomatics on a bi-weekly basis such that the corresponding features can be updated in the Geomatics database. The assets must be updated in the Geomatics database as Geomatics supplies a web service on their MappMyCity server that CityWide consumes so that Parks can see their assets in CityWides GIS Viewer addon. The Geomatics team maintains the geometry or linework for the trails.
Primary key: GISID
Foreign key: nan
Copyright Text: Owned by: CityWide
Managed by: Parks
Description: Services: TrailsBikeLaneLayersEIS and MappMyCity
Scripts: None
Notes: Notes: This layer was generated by the Geomatices team using the known locations of bike lanes in Windsor as inventoried by Transportation Planning in the Hansen database. The layer is updated with locations and classifications of bike lanes through an inventory extract from Hansen and joining the COMPKEY field in the bike lanes to the road segment with the corresponding COMPKEY. The geometry of where bike lanes are located is thus derived from the geometry of the street layer.
Primary key: JOIN_KEY
Foreign key: nan
Description: Services: Scripts: None
Notes: The locations of bike parking and installation or removal of bike racks is managed by Transportation Planning. Geomatics updates the layer with the current inventory of bike racks on request.
Primary key: nan
Foreign key: nan
Description: Services:Scripts: NoneNotes: This layer was generated by the Geomatics team using archived feature classes that were then compressed and can be queried by type.Primary key: nanForeign key: nan
Description: Services: TransitLayersEIS Scripts: None
Notes: The defined bus stop locations are determined and created by Transit Windsor in their gdb. The Geomatics team updates the corresponding layer in the SDE when requested.
Primary key: nan
Foreign key: nan
Description: Services:Scripts: NoneNotes: This layer was generated by the Geomatics team using archived feature classes that were then compressed and can be queried by route name. Transit will send individual bus routes and the process is to append the data over to the new schema.Primary key: nanForeign key: nan
Description: Services: MappMyCity
Scripts: None
Notes: The intersections assigned crossing guards are determined and tracked by Parking Services in a spreadsheet. The point features for the locations of the crossing guards are maintained by the Geomatics GIS team and updated upon requesting a new record of crossing guard locations from Parking Services each September. The layer is published to MappMyCity server as a web service to use in the MySchoolNeighbourhood web map.
Primary key: nan
Foreign key: nan
Description: Services: TransportationLayersEIS and MappMyCity
Scripts: None
Notes: The lines for the edge of pavement are maintained by the Geomatics CAD team. The CAD staff update the linework when As Built contracts are worked on in the edge of pavement AutoCAD drawing of record. 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 by Geomatics when notified by the CAD staff or IMS.
Primary key: nan
Foreign key: nan
Description: Services: BasemapTileLayer
Scripts: None
Notes: This layer was obtained from Essex county's open data website and was then modified to Windsor's boarder according to Official Plans by Geomatics. It is updated occassionally by downloading a new set of the data from Essex-County's open data website.
Primary key: nan
Foreign key: nan
Description: Services: TransportationLayersEIS and MappMyCity
Scripts: None
Notes: The inventory of streets is maintained by IMS in the Hansen database. The line features for the location of the streets are maintained by the IMS staff 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 an extract if segments qualified as a major road from the street centerline layer.
Primary key: nan
Foreign key: nan
Description: Services: BasemapTileLayer
Scripts: None
Notes: This layer was obtained from State of Michigan GIS's open data website by and clipped in extent Geomatics. It is updated occassionally by downloading a new set of the data from State of Michigan GIS's open data website.
Primary key: nan
Foreign key: nan
Description: Services: MappMyCity
Scripts: None
Notes: The locations of designated on street kiss and ride are determined and tracked by Parking Services in a spreadsheet. The point features for the locations are maintained by the Geomatics GIS team and updated upon requesting a new record of locations from Parking Services each September. The layer is published to MappMyCity server as a web service to use in the MySchoolNeighbourhood web map.
Primary key: nan
Foreign key: nan
Description: Services: TrailBikeLanesLayersEIS and MappMyCity
Scripts: None
Notes: These polylines are part of the trail network and are to be merged into the new Trails feature class
Primary key: nan
Foreign key: nan
Description: Services: TransportationLayersEIS
Scripts: None
Notes: The inventory of railway crossings and their locations are maintained by IMS in the Hansen database. The point features for the location of the railway crossings are maintained by GIS team as a feature layer in their SDE so it can be used in a published web service. This layer is updated upon notification from IMS.
Primary key: nan
Foreign key: nan
Description: Services: TransportationLayersEIS
Scripts: None
Notes: Need to determine origin of this feature and if it is up to date
Primary key: nan
Foreign key: nan
Description: Services: ROWLayersEIS
Scripts: None
Notes: The closure of alleys in the City is managed by Right of Waythrough by laws permits and purchase agreements. This layer managed by Geomatics and updated when notification is received from Right of Way baout an alley closure.
Primary key: nan
Foreign key: nan
Description: Services: MappMyCity
Scripts: None
Notes: The locations of restricted on street parking are determined and tracked by Parking Services in a spreadsheet. The line features and attributes for the on street parking restrictions are maintained by the Geomatics GIS team and updated upon requesting a new record of locations from Parking Services each September. The layer is published to MappMyCity server as a web service to use in the MySchoolNeighbourhood web map.
Primary key: nan
Foreign key: nan
Description: Services: TransportationLayersEIS and MappMyCity
Scripts: sidewalkUpdate.py
Notes: The inventory of sidewalks with their location information is maintained by IMS in the Hansen database. The line features for the location of the sidewalks are maintained by the IMS staff 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.
Primary key: COMPKEY
Foreign key: nan
Description: Services: TransportationLayersEIS and MappMyCity
Scripts: street_centreline_update.py
Notes: The inventory of streets with their location information is maintained by IMS in the Hansen database. The line features for the location of the streets are maintained by the IMS staff 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. The layer is used in the custom intersection geo-locator tool by the Geomatics team and published to the Enterprise server as a locator service to use in internal web applications.
Primary key: COMPKEY
Foreign key: nan
Description: Services: MappMyCity
Scripts: None
Notes: The planned route that qualifies as the Windsor Loop signed route by Transportation Planning in the Active Transportation Master Plan. Geomatics created this polyline from road segments defined by Transportation Planning planned to have bike lanes to form the route. The route includes existing and planned bike lanes.
Primary key: nan
Foreign key: nan