View In:   ArcGIS Online Map Viewer

Name: Pavement Maintenance

Display Field: streetname

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: ROADSEG contains all the features from HIGHWAY_OFFICIAL, RURAL_ROAD_OFFICIAL and OTHER_ROAD_OFFICIAL. ROADSEG is the Saskatchewan road network data that is being used by NRCAN as National Road Network (NRN). ROADSED data layer has been generated by merging HIGHWAY_OFFICIAL, RURAL_ROAD_OFFICIAL and OTHER_ROAD_OFFICIAL. Unique Identifiers (NID) is associated with each line segment. "NID" National Identifier is used to manage the updates between data producer and data users. ROADSEG data layer is one of the important data table for SURN, NRN, SASK911, CAR, SGI-iHaul and other applications.

Copyright Text: Saskatchewan Ministry of Highways & Infrastructure, Government of Saskatchewan, Canada

Default Visibility: true

MaxRecordCount: 42750

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: -106.83684597099995
YMin: 52.056445832000065
XMax: -106.50511889099994
YMax: 52.23042995000003
Spatial Reference: 4326  (4326)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: maintenance_suggestion
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Defer Maintenance
  Label: Defer Maintenance
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [56, 168, 0, 255]
  Width: 2
• Value: Preventive Maintenance
  Label: Preventive Maintenance
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 255, 0, 255]
  Width: 2
• Value: Rehabilitation
  Label: Rehabilitation
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 112, 255, 255]
  Width: 2
• Value: Reclamation
  Label: Reclamation
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 170, 0, 255]
  Width: 2
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: maintenance_suggestion

Fields:

• objectid ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: objectid )
• streetname ( type: esriFieldTypeString, alias: Street Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: streetname )
• fromstreetname ( type: esriFieldTypeString, alias: From Street Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: fromstreetname )
• tostreetname ( type: esriFieldTypeString, alias: To Street Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: tostreetname )
• pci ( type: esriFieldTypeInteger, alias: PCI, editable: true, nullable: true, defaultValue: null, modelName: pci )
• maintenance_suggestion ( type: esriFieldTypeString, alias: Maintenance Suggestion, editable: true, nullable: true, length: 150, defaultValue: null, modelName: maintenance_suggestion )
• estimated_cost ( type: esriFieldTypeInteger, alias: Estimate Cost ($), editable: true, nullable: true, defaultValue: null, modelName: estimated_cost )
• repair_priority ( type: esriFieldTypeDouble, alias: Repair Priority, editable: true, nullable: true, defaultValue: null, modelName: repair_priority )
• functional_class ( type: esriFieldTypeString, alias: Functional Class, editable: true, nullable: true, length: 50, defaultValue: null, modelName: functional_class )
• functional_class_id ( type: esriFieldTypeSmallInteger, alias: Functional Class ID, editable: true, nullable: true, defaultValue: null, modelName: functional_class_id )
• surface_type ( type: esriFieldTypeString, alias: Surface Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: surface_type )
• survey_date ( type: esriFieldTypeDate, alias: Survey Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: survey_date )
• width_m ( type: esriFieldTypeSingle, alias: Width (m), editable: true, nullable: true, defaultValue: null, modelName: width_m )
• length_m ( type: esriFieldTypeInteger, alias: Length (m), editable: true, nullable: true, defaultValue: null, modelName: length_m )
• area_sm ( type: esriFieldTypeSingle, alias: Area (sm), editable: true, nullable: true, defaultValue: null, modelName: area_sm )
• last_repair_method ( type: esriFieldTypeString, alias: Last Repair Method, editable: true, nullable: true, length: 50, defaultValue: null, modelName: last_repair_method )
• last_repair_cost ( type: esriFieldTypeInteger, alias: Last Repair Cost, editable: true, nullable: true, defaultValue: null, modelName: last_repair_cost )
• last_repair_date ( type: esriFieldTypeDate, alias: Last Repair Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_repair_date )
• future_event ( type: esriFieldTypeString, alias: Future Event, editable: true, nullable: true, length: 50, defaultValue: null, modelName: future_event )
• future_event_date ( type: esriFieldTypeDate, alias: Future Event Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: future_event_date )
• editor_note ( type: esriFieldTypeString, alias: Editor Notes, editable: true, nullable: true, length: 100, defaultValue: null, modelName: editor_note )
• editor_name ( type: esriFieldTypeString, alias: Editor Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: editor_name )
• editor_id ( type: esriFieldTypeInteger, alias: Editor ID, editable: true, nullable: true, defaultValue: null, modelName: editor_id )
• last_edit ( type: esriFieldTypeDate, alias: Last Edit, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_edit )
• construction_year ( type: esriFieldTypeString, alias: Construction Year, editable: true, nullable: true, length: 25, defaultValue: null, modelName: construction_year )
• ss_id ( type: esriFieldTypeInteger, alias: SS ID, editable: true, nullable: true, defaultValue: null, modelName: ss_id )
• pci_2024 ( type: esriFieldTypeSmallInteger, alias: PCI 2024, editable: true, nullable: true, defaultValue: null, modelName: pci_2024 )
• notes_2024 ( type: esriFieldTypeString, alias: Notes 2024, editable: true, nullable: true, length: 150, defaultValue: null, modelName: notes_2024 )
• start_date_ss ( type: esriFieldTypeDate, alias: Start Date SS, editable: true, nullable: true, length: 8, defaultValue: null, modelName: start_date_ss )
• end_date_ss ( type: esriFieldTypeDate, alias: End Date SS, editable: true, nullable: true, length: 8, defaultValue: null, modelName: end_date_ss )
• speedlimit ( type: esriFieldTypeDouble, alias: SPEEDLIMIT, editable: true, nullable: true, defaultValue: null, modelName: speedlimit )
• postedname ( type: esriFieldTypeString, alias: POSTEDNAME, editable: true, nullable: true, length: 100, defaultValue: null, modelName: postedname )
• rtename1en ( type: esriFieldTypeString, alias: RTENAME1EN, editable: true, nullable: true, length: 100, defaultValue: null, modelName: rtename1en )
• exitnbr ( type: esriFieldTypeString, alias: EXITNBR, editable: true, nullable: true, length: 10, defaultValue: null, modelName: exitnbr )
• nbrlanes ( type: esriFieldTypeInteger, alias: NBRLANES, editable: true, nullable: true, defaultValue: null, modelName: nbrlanes )
• pavstatus ( type: esriFieldTypeInteger, alias: Pavement Status ID, editable: true, nullable: true, defaultValue: null, modelName: pavstatus )
• pavsurf ( type: esriFieldTypeInteger, alias: Pavement Surface ID, editable: true, nullable: true, defaultValue: null, modelName: pavsurf )
• unpavsurf ( type: esriFieldTypeInteger, alias: Unpaved Surface ID, editable: true, nullable: true, defaultValue: null, modelName: unpavsurf )
• fcid ( type: esriFieldTypeString, alias: Functional Class ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: fcid )
• fcl ( type: esriFieldTypeString, alias: Functional Class, editable: true, nullable: true, length: 255, defaultValue: null, modelName: fcl )
• pavstatus_ ( type: esriFieldTypeString, alias: Pavement Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: pavstatus_ )
• pavsurf_ ( type: esriFieldTypeString, alias: Pavement Surface, editable: true, nullable: true, length: 255, defaultValue: null, modelName: pavsurf_ )
• unpav_ ( type: esriFieldTypeString, alias: Unpaved Surface, editable: true, nullable: true, length: 255, defaultValue: null, modelName: unpav_ )
• Shape__Length ( type: esriFieldTypeDouble, alias: st_length(shape), editable: false, nullable: false, defaultValue: null, modelName: st_length(shape) )
• objectid_slx ( type: esriFieldTypeInteger, alias: objectid_slx, editable: true, nullable: true, defaultValue: null, modelName: objectid_slx )
• clx_uid ( type: esriFieldTypeInteger, alias: clx_uid, editable: true, nullable: true, defaultValue: null, modelName: clx_uid )

Types:

ID: Defer Maintenance
Name: Defer Maintenance
Domains:
Templates:
• Name: Defer Maintenance
  Description:
  Prototype:
  objectid_slx: null
  clx_uid: null
  streetname: null
  fromstreetname: null
  tostreetname: null
  pci: null
  maintenance_suggestion: Defer Maintenance
  estimated_cost: null
  repair_priority: null
  functional_class: null
  functional_class_id: null
  surface_type: null
  survey_date: null
  width_m: null
  length_m: null
  area_sm: null
  last_repair_method: null
  last_repair_cost: null
  last_repair_date: null
  future_event: null
  future_event_date: null
  editor_note: null
  editor_name: null
  editor_id: null
  last_edit: null
  construction_year: null
  ss_id: null
  pci_2024: null
  notes_2024: null
  start_date_ss: null
  end_date_ss: null
  speedlimit: null
  postedname: null
  rtename1en: null
  exitnbr: null
  nbrlanes: null
  pavstatus: null
  pavsurf: null
  unpavsurf: null
  fcid: null
  fcl: null
  pavstatus_: null
  pavsurf_: null
  unpav_: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Preventive Maintenance
Name: Preventive Maintenance
Domains:
Templates:
• Name: Preventive Maintenance
  Description:
  Prototype:
  objectid_slx: null
  clx_uid: null
  streetname: null
  fromstreetname: null
  tostreetname: null
  pci: null
  maintenance_suggestion: Preventive Maintenance
  estimated_cost: null
  repair_priority: null
  functional_class: null
  functional_class_id: null
  surface_type: null
  survey_date: null
  width_m: null
  length_m: null
  area_sm: null
  last_repair_method: null
  last_repair_cost: null
  last_repair_date: null
  future_event: null
  future_event_date: null
  editor_note: null
  editor_name: null
  editor_id: null
  last_edit: null
  construction_year: null
  ss_id: null
  pci_2024: null
  notes_2024: null
  start_date_ss: null
  end_date_ss: null
  speedlimit: null
  postedname: null
  rtename1en: null
  exitnbr: null
  nbrlanes: null
  pavstatus: null
  pavsurf: null
  unpavsurf: null
  fcid: null
  fcl: null
  pavstatus_: null
  pavsurf_: null
  unpav_: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Rehabilitation
Name: Rehabilitation
Domains:
Templates:
• Name: Rehabilitation
  Description:
  Prototype:
  objectid_slx: null
  clx_uid: null
  streetname: null
  fromstreetname: null
  tostreetname: null
  pci: null
  maintenance_suggestion: Rehabilitation
  estimated_cost: null
  repair_priority: null
  functional_class: null
  functional_class_id: null
  surface_type: null
  survey_date: null
  width_m: null
  length_m: null
  area_sm: null
  last_repair_method: null
  last_repair_cost: null
  last_repair_date: null
  future_event: null
  future_event_date: null
  editor_note: null
  editor_name: null
  editor_id: null
  last_edit: null
  construction_year: null
  ss_id: null
  pci_2024: null
  notes_2024: null
  start_date_ss: null
  end_date_ss: null
  speedlimit: null
  postedname: null
  rtename1en: null
  exitnbr: null
  nbrlanes: null
  pavstatus: null
  pavsurf: null
  unpavsurf: null
  fcid: null
  fcl: null
  pavstatus_: null
  pavsurf_: null
  unpav_: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Reclamation
Name: Reclamation
Domains:
Templates:
• Name: Reclamation
  Description:
  Prototype:
  objectid_slx: null
  clx_uid: null
  streetname: null
  fromstreetname: null
  tostreetname: null
  pci: null
  maintenance_suggestion: Reclamation
  estimated_cost: null
  repair_priority: null
  functional_class: null
  functional_class_id: null
  surface_type: null
  survey_date: null
  width_m: null
  length_m: null
  area_sm: null
  last_repair_method: null
  last_repair_cost: null
  last_repair_date: null
  future_event: null
  future_event_date: null
  editor_note: null
  editor_name: null
  editor_id: null
  last_edit: null
  construction_year: null
  ss_id: null
  pci_2024: null
  notes_2024: null
  start_date_ss: null
  end_date_ss: null
  speedlimit: null
  postedname: null
  rtename1en: null
  exitnbr: null
  nbrlanes: null
  pavstatus: null
  pavsurf: null
  unpavsurf: null
  fcid: null
  fcl: null
  pavstatus_: null
  pavsurf_: null
  unpav_: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata