Layers:

Layer: ResSnowSign (0)


Name: ResSnowSign

Display Field: Street_Name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Has Views: true

Source Schema Changes Allowed: false

Description:

Residential snow removal signs can be temporarily installed, permanently installed, or on a large VMB (variable message board) that gets placed along a roadway. This dataset also has a related table which stores maintenance history on the signs, and there is a spatial view that ties the point sign location to the most recent record in the maintenance table (vw_ResSnowSign_MostRecentMaintenance)



Copyright Text: Transportation and Agriculture Service, Strathcona County

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 44145.1350999984
YMin: 5929252.54039999
XMax: 57250.2836000006
YMax: 5940202.78100405
Spatial Reference: PROJCS["NAD83_UTM_114_Longitude_Meter_Province_of_Alberta_Canada",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["Geodetic_Reference_System_of_1980",6378137.0,298.2572221008916]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["false_easting",0.0],PARAMETER["false_northing",0.0],PARAMETER["central_meridian",-114.0],PARAMETER["scale_factor",0.9999],PARAMETER["latitude_of_origin",0.0],UNIT["Meter",1.0]]


Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[69,118,142,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True


Global ID Field: GlobalID

Type ID Field:

Fields:
• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• GroupID (type: esriFieldTypeInteger, alias: GroupID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UniqueID (type: esriFieldTypeInteger, alias: UniqueID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Street_Name (type: esriFieldTypeString, alias: Street_Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• Street_Intersection (type: esriFieldTypeString, alias: Street_Intersection, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• Sign_Direction (type: esriFieldTypeString, alias: Sign_Direction, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Northbound: Northbound], [Southbound: Southbound], [Westbound: Westbound], ... 1 more ...)
• Sign_Priority (type: esriFieldTypeString, alias: Sign_Priority, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [N/A: N/A])
• Post_Type (type: esriFieldTypeString, alias: Post_Type, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Street Light: Street Light], [Tree: Tree], [Utility Pole: Utility Pole], ... 5 more ...)
• Neighbourhood (type: esriFieldTypeString, alias: Neighbourhood, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Version (type: esriFieldTypeSmallInteger, alias: Version, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Sign_Category (type: esriFieldTypeString, alias: Sign_Category, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [P3: P3], [P4: P4], [VMB: VMB])
• CreatedOn (type: esriFieldTypeDate, alias: CreatedOn, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• CreatedBy (type: esriFieldTypeString, alias: CreatedBy, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• ModifiedOn (type: esriFieldTypeDate, alias: ModifiedOn, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• ModifiedBy (type: esriFieldTypeString, alias: ModifiedBy, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• Sign_Type (type: esriFieldTypeString, alias: Sign_Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Temporary Sign: Temporary Sign], [Permanent Sign: Permanent Sign], [VMB: VMB])

Templates:

Name: Residential Snow Removal Signage
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:


Relationships:
• Res_Snow_Sign_Maintenance (1) -- Related To: sde.GIS.Res_Snow_Sign_Maintenance (3)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/13/2025 4:08:11 PM

Schema Last Edit Date: 2/13/2025 4:08:11 PM

Data Last Edit Date: 2/13/2025 4:08:11 PM

Layer: ResSnowStreets (1)


Name: ResSnowStreets

Display Field: SectionID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Has Views: true

Source Schema Changes Allowed: false

Description:

Residential snow removal streets are derived from streets in the Winter Priorities dataset, and follow specific criteria:

• Have a priority value of 3, 4, or Lane

• Are Urban streets, within the urban service area (rural roads are excluded)

This dataset also has a related table which stores maintenance history on the streets, and there is a spatial view that ties the street segment to the most recent record in the maintenance table (vw_ResSnowStreet_MostRecentMaintenance)



Copyright Text: Transportation and Agriculture Service, Strathcona County

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 44306.2054000002
YMin: 5929202.80629999
XMax: 57525.2034999998
YMax: 5941003.0053
Spatial Reference: PROJCS["NAD83_UTM_114_Longitude_Meter_Province_of_Alberta_Canada",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["Geodetic_Reference_System_of_1980",6378137.0,298.2572221008916]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["false_easting",0.0],PARAMETER["false_northing",0.0],PARAMETER["central_meridian",-114.0],PARAMETER["scale_factor",0.9999],PARAMETER["latitude_of_origin",0.0],UNIT["Meter",1.0]]


Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[230,140,101,255],"width":3.8}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True


Global ID Field: GlobalID

Type ID Field:

Fields:
• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• SectionID (type: esriFieldTypeString, alias: SectionID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• loc_street (type: esriFieldTypeString, alias: loc_street, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• loc_from (type: esriFieldTypeString, alias: loc_from, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• loc_to (type: esriFieldTypeString, alias: loc_to, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• loc_hood (type: esriFieldTypeString, alias: loc_hood, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• loc_district (type: esriFieldTypeString, alias: loc_district, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• trf_funcls (type: esriFieldTypeString, alias: trf_funcls, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• trf_lane (type: esriFieldTypeSmallInteger, alias: trf_lane, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Drop_Off_Zone (type: esriFieldTypeString, alias: Drop_Off_Zone, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• Winter_Priority (type: esriFieldTypeString, alias: Winter_Priority, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• TAS_Urban (type: esriFieldTypeString, alias: TAS_Urban, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Length_KM (type: esriFieldTypeDouble, alias: Length_KM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SegmentID (type: esriFieldTypeInteger, alias: SegmentID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: sde.GIS.Res_Snow_Streets
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:


Relationships:
• Res_Snow_Street_Maintenance (2) -- Related To: sde.GIS.Res_Snow_Street_Maintenance (5)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/13/2025 4:08:11 PM

Schema Last Edit Date: 2/6/2025 4:18:53 PM

Data Last Edit Date: 2/13/2025 4:08:11 PM

Tables:

sde.GIS.Res_Snow_Sign_Maintenance (3)


Name: sde.GIS.Res_Snow_Sign_Maintenance

Display Field: Sign_GroupID

Type: Table

Has Views: true

Source Schema Changes Allowed: false

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True


Global ID Field: GlobalID

Type ID Field:

Fields:
• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Sign_GroupID (type: esriFieldTypeInteger, alias: GroupID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Sign_UniqueID (type: esriFieldTypeInteger, alias: UniqueID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Posted_On (type: esriFieldTypeDate, alias: Posted_On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Posted_Time (type: esriFieldTypeSmallInteger, alias: Posted_Time, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Posted_By (type: esriFieldTypeString, alias: Posted_By, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Installed: Installed], [Removed: Removed])
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CreatedOn (type: esriFieldTypeDate, alias: CreatedOn, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• CreatedBy (type: esriFieldTypeString, alias: CreatedBy, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• ModifiedOn (type: esriFieldTypeDate, alias: ModifiedOn, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• ModifiedBy (type: esriFieldTypeString, alias: ModifiedBy, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: sde.GIS.Res_Snow_Sign_Maintenance
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• Status: Installed

Relationships:
• Res_Snow_Signage (1) -- Related To: ResSnowSign (0)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/13/2025 4:08:11 PM

Schema Last Edit Date: 2/11/2025 6:47:55 PM

Data Last Edit Date: 2/13/2025 4:08:11 PM

sde.GIS.Res_Snow_Street_Maintenance (5)


Name: sde.GIS.Res_Snow_Street_Maintenance

Display Field: SegmentID

Type: Table

Has Views: true

Source Schema Changes Allowed: false

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True


Global ID Field: GlobalID

Type ID Field:

Fields:
• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• SegmentID (type: esriFieldTypeInteger, alias: SegmentID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Street_Priority (type: esriFieldTypeString, alias: Street_Priority, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [P3: P3], [P4: P4], [Lane: Lane])
• Activity (type: esriFieldTypeString, alias: Activity, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Cleared: Cleared], [Windrow: Windrow])
• Activity_On (type: esriFieldTypeDate, alias: Activity_On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Activity_Time (type: esriFieldTypeSmallInteger, alias: Activity_Time, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Activity_Notes (type: esriFieldTypeString, alias: Activity_Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Day (type: esriFieldTypeSmallInteger, alias: Day, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [1 - 14])
• Crew (type: esriFieldTypeSmallInteger, alias: Crew, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [1 - 14])
• CreatedOn (type: esriFieldTypeDate, alias: CreatedOn, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• CreatedBy (type: esriFieldTypeString, alias: CreatedBy, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• ModifiedOn (type: esriFieldTypeDate, alias: ModifiedOn, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• ModifiedBy (type: esriFieldTypeString, alias: ModifiedBy, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: sde.GIS.Res_Snow_Street_Maintenance
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:


Relationships:
• Res_Snow_Streets (2) -- Related To: ResSnowStreets (1)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/13/2025 4:08:11 PM

Schema Last Edit Date: 2/6/2025 4:41:28 PM

Data Last Edit Date: 2/13/2025 4:08:11 PM