View In:   ArcGIS Online Map Viewer

Name: Sidewalk Maintenance

Display Field: streetname

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 5000

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: -102.50419182799999
YMin: 51.19564305200004
XMax: -102.42847453899998
YMax: 51.22830178500004
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 )
• clx_uid ( type: esriFieldTypeInteger, alias: CLX UID, editable: true, nullable: true, defaultValue: null, modelName: clx_uid )
• streetname ( type: esriFieldTypeString, alias: Street Name, editable: true, nullable: true, length: 75, defaultValue: null, modelName: streetname )
• fromstreetname ( type: esriFieldTypeString, alias: From Street Name, editable: true, nullable: true, length: 75, defaultValue: null, modelName: fromstreetname )
• tostreetname ( type: esriFieldTypeString, alias: To Street Name, editable: true, nullable: true, length: 75, defaultValue: null, modelName: tostreetname )
• sci ( type: esriFieldTypeSmallInteger, alias: SCI, editable: true, nullable: true, defaultValue: null, modelName: sci )
• num_of_uplifts ( type: esriFieldTypeSmallInteger, alias: Number of Uplifts, editable: true, nullable: true, defaultValue: null, modelName: num_of_uplifts )
• num_of_distresses ( type: esriFieldTypeSmallInteger, alias: Number of Distresses, editable: true, nullable: true, defaultValue: null, modelName: num_of_distresses )
• maintenance_suggestion ( type: esriFieldTypeString, alias: Maintenance Suggestion, editable: true, nullable: true, length: 255, defaultValue: null, modelName: maintenance_suggestion )
• estimated_cost ( type: esriFieldTypeInteger, alias: Estimated 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: 75, 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: 75, defaultValue: null, modelName: surface_type )
• width_m ( type: esriFieldTypeDouble, 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: esriFieldTypeDouble, alias: Area (sm), editable: true, nullable: true, defaultValue: null, modelName: area_sm )
• survey_date ( type: esriFieldTypeDate, alias: Survey Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: survey_date )
• last_repair_method ( type: esriFieldTypeString, alias: Last Repair Method, editable: true, nullable: true, length: 255, 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: 255, 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 Note, editable: true, nullable: true, length: 255, defaultValue: null, modelName: editor_note )
• editor_name ( type: esriFieldTypeString, alias: Editor Name, editable: true, nullable: true, length: 75, 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 )
• sw_id ( type: esriFieldTypeInteger, alias: SW ID, editable: true, nullable: true, defaultValue: null, modelName: sw_id )
• notes_2024 ( type: esriFieldTypeString, alias: Notes 2024, editable: true, nullable: true, length: 255, defaultValue: null, modelName: notes_2024 )
• video ( type: esriFieldTypeString, alias: Video, editable: true, nullable: true, length: 255, defaultValue: null, modelName: video )
• begin_width ( type: esriFieldTypeDouble, alias: Begin Width, editable: true, nullable: true, defaultValue: null, modelName: begin_width )
• end_width ( type: esriFieldTypeDouble, alias: End Width, editable: true, nullable: true, defaultValue: null, modelName: end_width )
• avg_width ( type: esriFieldTypeDouble, alias: Average Width, editable: true, nullable: true, defaultValue: null, modelName: avg_width )
• sci_2024 ( type: esriFieldTypeSmallInteger, alias: SCI 2024, editable: true, nullable: true, defaultValue: null, modelName: sci_2024 )
• ss_id ( type: esriFieldTypeInteger, alias: SS ID, editable: true, nullable: true, defaultValue: null, modelName: ss_id )
• asset_id ( type: esriFieldTypeString, alias: Sidewalk_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: asset_id )
• communityname ( type: esriFieldTypeString, alias: Community Name, editable: true, nullable: true, length: 20, defaultValue: City of Yorkton, modelName: communityname , Coded Values: [City of Melville: City of Melville] , [City of Yorkton: City of Yorkton] , [Ebenezer: Ebenezer] , ...6 more... )
• roadtype ( type: esriFieldTypeString, alias: Road Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: roadtype , Coded Values: [Highway: Highway] , [Major Collector: Major Collector] , [Minor Collector: Minor Collector] , ...3 more... )
• material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 20, defaultValue: null, modelName: material , Coded Values: [AS: Asphalt] , [BR: Brick] , [CC: Concrete] , ...2 more... )
• material_st ( type: esriFieldTypeString, alias: Material Sub-Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: material_st )
• width ( type: esriFieldTypeDouble, alias: Width, editable: true, nullable: true, defaultValue: null, modelName: width )
• surfacearea ( type: esriFieldTypeDouble, alias: Surface Area, editable: true, nullable: true, defaultValue: null, modelName: surfacearea , Range: [0, 1000000000] )
• installdate ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: installdate )
• usefullife ( type: esriFieldTypeDouble, alias: Useful Life, editable: true, nullable: true, defaultValue: null, modelName: usefullife )
• ownership ( type: esriFieldTypeString, alias: Ownership, editable: true, nullable: true, length: 50, defaultValue: City of Yorkton, modelName: ownership , Coded Values: [Access Communications: Access Communications] , [BT Telecom: BT Telecom] , [Canadian National Railway: Canadian National Railway] , ...12 more... )
• historiccost ( type: esriFieldTypeDouble, alias: Historic Cost, editable: true, nullable: true, defaultValue: null, modelName: historiccost , Range: [0, 100000000] )
• status_ ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 20, defaultValue: null, modelName: status_ , Coded Values: [Abandoned: Abandoned] , [Decommissioned: Decommissioned] , [Existing: Existing] , ...3 more... )
• yearretired ( type: esriFieldTypeSmallInteger, alias: Year Retired, editable: true, nullable: true, defaultValue: null, modelName: yearretired )
• editedby ( type: esriFieldTypeString, alias: Edited By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: editedby )
• comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 254, defaultValue: null, modelName: comments )
• source ( type: esriFieldTypeString, alias: Source, editable: true, nullable: true, length: 254, defaultValue: null, modelName: source )
• id_2012 ( type: esriFieldTypeString, alias: ID_2012, editable: true, nullable: true, length: 254, defaultValue: null, modelName: id_2012 )
• id_2014 ( type: esriFieldTypeString, alias: ID_2014, editable: true, nullable: true, length: 254, defaultValue: null, modelName: id_2014 )
• disabcomply ( type: esriFieldTypeString, alias: Disability Compliant, editable: true, nullable: true, length: 5, defaultValue: null, modelName: disabcomply , Coded Values: [Yes: Yes] , [No: No] )
• surftype ( type: esriFieldTypeString, alias: Surface Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: surftype )
• id_2023_03 ( type: esriFieldTypeString, alias: ID_2023_03, editable: true, nullable: true, length: 254, defaultValue: null, modelName: id_2023_03 )
• createdby ( type: esriFieldTypeString, alias: Created By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: createdby )
• date_created ( type: esriFieldTypeDate, alias: Date Created, editable: true, nullable: true, length: 8, defaultValue: null, modelName: date_created )
• date_edited ( type: esriFieldTypeDate, alias: Date Edited, editable: true, nullable: true, length: 8, defaultValue: null, modelName: date_edited )
• status_code ( type: esriFieldTypeString, alias: Status Code, editable: true, nullable: true, length: 2, defaultValue: null, modelName: status_code , Coded Values: [AB: Abandoned] , [A: Active] , [P2: Alternate] , ...22 more... )
• historicid ( type: esriFieldTypeString, alias: HistoricID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: historicid )
• 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 )
• Shape__Length ( type: esriFieldTypeDouble, alias: st_length(shape), editable: false, nullable: false, defaultValue: null, modelName: st_length(shape) )
• notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: notes )

Types:

ID: Defer Maintenance
Name: Defer Maintenance
Domains:
• communityname:
  Inherited
• roadtype:
  Inherited
• material:
  Inherited
• surfacearea:
  Inherited
• ownership:
  Inherited
• historiccost:
  Inherited
• status_:
  Inherited
• disabcomply:
  Inherited
• status_code:
  Inherited
Templates:
• Name: Defer Maintenance
  Description:
  Prototype:
  end_date_ss: null
  notes: null
  clx_uid: null
  streetname: null
  fromstreetname: null
  tostreetname: null
  sci: null
  num_of_uplifts: null
  num_of_distresses: null
  maintenance_suggestion: Defer Maintenance
  estimated_cost: null
  repair_priority: null
  functional_class: null
  functional_class_id: null
  surface_type: null
  width_m: null
  length_m: null
  area_sm: null
  survey_date: 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
  sw_id: null
  notes_2024: null
  video: null
  begin_width: null
  end_width: null
  avg_width: null
  sci_2024: null
  ss_id: null
  asset_id: null
  communityname: City of Yorkton
  roadtype: null
  material: null
  material_st: null
  width: null
  surfacearea: null
  installdate: null
  usefullife: null
  ownership: City of Yorkton
  historiccost: null
  status_: null
  yearretired: null
  editedby: null
  comments: null
  source: null
  id_2012: null
  id_2014: null
  disabcomply: null
  surftype: null
  id_2023_03: null
  createdby: null
  date_created: null
  date_edited: null
  status_code: null
  historicid: null
  start_date_ss: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Preventive Maintenance
Name: Preventive Maintenance
Domains:
• communityname:
  Inherited
• roadtype:
  Inherited
• material:
  Inherited
• surfacearea:
  Inherited
• ownership:
  Inherited
• historiccost:
  Inherited
• status_:
  Inherited
• disabcomply:
  Inherited
• status_code:
  Inherited
Templates:
• Name: Preventive Maintenance
  Description:
  Prototype:
  end_date_ss: null
  notes: null
  clx_uid: null
  streetname: null
  fromstreetname: null
  tostreetname: null
  sci: null
  num_of_uplifts: null
  num_of_distresses: null
  maintenance_suggestion: Preventive Maintenance
  estimated_cost: null
  repair_priority: null
  functional_class: null
  functional_class_id: null
  surface_type: null
  width_m: null
  length_m: null
  area_sm: null
  survey_date: 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
  sw_id: null
  notes_2024: null
  video: null
  begin_width: null
  end_width: null
  avg_width: null
  sci_2024: null
  ss_id: null
  asset_id: null
  communityname: City of Yorkton
  roadtype: null
  material: null
  material_st: null
  width: null
  surfacearea: null
  installdate: null
  usefullife: null
  ownership: City of Yorkton
  historiccost: null
  status_: null
  yearretired: null
  editedby: null
  comments: null
  source: null
  id_2012: null
  id_2014: null
  disabcomply: null
  surftype: null
  id_2023_03: null
  createdby: null
  date_created: null
  date_edited: null
  status_code: null
  historicid: null
  start_date_ss: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Rehabilitation
Name: Rehabilitation
Domains:
• communityname:
  Inherited
• roadtype:
  Inherited
• material:
  Inherited
• surfacearea:
  Inherited
• ownership:
  Inherited
• historiccost:
  Inherited
• status_:
  Inherited
• disabcomply:
  Inherited
• status_code:
  Inherited
Templates:
• Name: Rehabilitation
  Description:
  Prototype:
  end_date_ss: null
  notes: null
  clx_uid: null
  streetname: null
  fromstreetname: null
  tostreetname: null
  sci: null
  num_of_uplifts: null
  num_of_distresses: null
  maintenance_suggestion: Rehabilitation
  estimated_cost: null
  repair_priority: null
  functional_class: null
  functional_class_id: null
  surface_type: null
  width_m: null
  length_m: null
  area_sm: null
  survey_date: 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
  sw_id: null
  notes_2024: null
  video: null
  begin_width: null
  end_width: null
  avg_width: null
  sci_2024: null
  ss_id: null
  asset_id: null
  communityname: City of Yorkton
  roadtype: null
  material: null
  material_st: null
  width: null
  surfacearea: null
  installdate: null
  usefullife: null
  ownership: City of Yorkton
  historiccost: null
  status_: null
  yearretired: null
  editedby: null
  comments: null
  source: null
  id_2012: null
  id_2014: null
  disabcomply: null
  surftype: null
  id_2023_03: null
  createdby: null
  date_created: null
  date_edited: null
  status_code: null
  historicid: null
  start_date_ss: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Reclamation
Name: Reclamation
Domains:
• communityname:
  Inherited
• roadtype:
  Inherited
• material:
  Inherited
• surfacearea:
  Inherited
• ownership:
  Inherited
• historiccost:
  Inherited
• status_:
  Inherited
• disabcomply:
  Inherited
• status_code:
  Inherited
Templates:
• Name: Reclamation
  Description:
  Prototype:
  end_date_ss: null
  notes: null
  clx_uid: null
  streetname: null
  fromstreetname: null
  tostreetname: null
  sci: null
  num_of_uplifts: null
  num_of_distresses: null
  maintenance_suggestion: Reclamation
  estimated_cost: null
  repair_priority: null
  functional_class: null
  functional_class_id: null
  surface_type: null
  width_m: null
  length_m: null
  area_sm: null
  survey_date: 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
  sw_id: null
  notes_2024: null
  video: null
  begin_width: null
  end_width: null
  avg_width: null
  sci_2024: null
  ss_id: null
  asset_id: null
  communityname: City of Yorkton
  roadtype: null
  material: null
  material_st: null
  width: null
  surfacearea: null
  installdate: null
  usefullife: null
  ownership: City of Yorkton
  historiccost: null
  status_: null
  yearretired: null
  editedby: null
  comments: null
  source: null
  id_2012: null
  id_2014: null
  disabcomply: null
  surftype: null
  id_2023_03: null
  createdby: null
  date_created: null
  date_edited: null
  status_code: null
  historicid: null
  start_date_ss: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Capabilities: Query,Create,Update,Delete,Uploads,Editing

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   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata