Name: ResSnowSign
Display Field: Street_Name
Type: Feature Layer
Geometry Type: esriGeometryPoint
Has Views: true
Source Schema Changes Allowed: false
Views
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)
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:
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:
Relationships:
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
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Query Related Records
Query Attachments
Add Features
Update Features
Apply Edits
Calculate
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat