View In:   ArcGIS Online Map Viewer

Name: Sidewalk Maintenance

Display Field: streetname

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: This layer is used by Streets MOC to track work orders and work requests within the City of Redmond's assest management program. SidewalkAsset features are continuous lines from one intersection to the next, unlike the SidewalkEdge which is split based on changes in sidewalk category. The layer represents approximate location of the existing sidewalk.

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: -122.16488049899999
YMin: 47.62737537500004
XMax: -122.08013526199994
YMax: 47.711372303000076
Spatial Reference: 4326  (4326)  VCSWkid(5702)  LatestVCSWkid(5702)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: maintenance_suggestion
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSLSSolid
Color: [250, 52, 17, 255]
Width: 1
Default Label: Others
UniqueValueInfos:
• Value: Defer Maintenance
  Label: Defer Maintenance
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [1, 97, 0, 255]
  Width: 1
• Value: Grinding
  Label: Grinding
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [115, 223, 255, 255]
  Width: 1
• Value: Reconstruction
  Label: Reconstruction
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 112, 255, 255]
  Width: 1
• Value: Rehabilitation
  Label: Rehabilitation
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [197, 0, 255, 255]
  Width: 1
• Value: null
  Label: Null
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [115, 76, 0, 255]
  Width: 1
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: 255, defaultValue: null, modelName: streetname )
• fromstreetname ( type: esriFieldTypeString, alias: From Street Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: fromstreetname )
• tostreetname ( type: esriFieldTypeString, alias: To Street Name, editable: true, nullable: true, length: 255, 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 )
• 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: 255, 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: 255, defaultValue: null, modelName: surface_type )
• survey_date ( type: esriFieldTypeString, alias: Survey Date, editable: true, nullable: true, length: 255, defaultValue: null, modelName: survey_date )
• width_ft ( type: esriFieldTypeDouble, alias: Width (ft), editable: true, nullable: true, defaultValue: null, modelName: width_ft )
• length_ft ( type: esriFieldTypeInteger, alias: Length (ft), editable: true, nullable: true, defaultValue: null, modelName: length_ft )
• area_sy ( type: esriFieldTypeDouble, alias: Area (sy), editable: true, nullable: true, defaultValue: null, modelName: area_sy )
• 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: 255, 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 )
• video ( type: esriFieldTypeString, alias: Video, editable: true, nullable: true, length: 255, defaultValue: null, modelName: video )
• notes_2022 ( type: esriFieldTypeString, alias: Notes 2022, editable: true, nullable: true, length: 255, defaultValue: null, modelName: notes_2022 )
• assetid ( type: esriFieldTypeString, alias: Asset ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: assetid )
• Shape__Length ( type: esriFieldTypeDouble, alias: st_length(shape), editable: false, nullable: false, defaultValue: null, modelName: st_length(shape) )
• num_of_distresses ( type: esriFieldTypeInteger, alias: Number of Distresses, editable: true, nullable: true, defaultValue: null, modelName: num_of_distresses )
• projectname ( type: esriFieldTypeString, alias: ProjectName, editable: true, nullable: true, length: 50, defaultValue: null, modelName: projectname )
• recorddrawing ( type: esriFieldTypeString, alias: RecordDrawing, editable: true, nullable: true, length: 20, defaultValue: null, modelName: recorddrawing )
• d_ownership ( type: esriFieldTypeString, alias: d_Ownership, editable: true, nullable: true, length: 6, defaultValue: UNK, modelName: d_ownership )
• d_datasource ( type: esriFieldTypeString, alias: d_DataSource, editable: true, nullable: true, length: 6, defaultValue: RECD, modelName: d_datasource )
• d_status ( type: esriFieldTypeString, alias: d_Status, editable: true, nullable: true, length: 6, defaultValue: ACT, modelName: d_status )
• installyear ( type: esriFieldTypeString, alias: InstallYear, editable: true, nullable: true, length: 4, defaultValue: null, modelName: installyear )
• notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: notes )
• createdby ( type: esriFieldTypeString, alias: CreatedBy, editable: true, nullable: true, length: 50, defaultValue: null, modelName: createdby )
• datecreated ( type: esriFieldTypeDate, alias: DateCreated, editable: true, nullable: true, length: 8, defaultValue: null, modelName: datecreated )
• modifiedby ( type: esriFieldTypeString, alias: ModifiedBy, editable: true, nullable: true, length: 50, defaultValue: null, modelName: modifiedby )
• datemodified ( type: esriFieldTypeDate, alias: DateModified, editable: true, nullable: true, length: 8, defaultValue: null, modelName: datemodified )
• lucityautonumber ( type: esriFieldTypeInteger, alias: LucityAutoNumber, editable: true, nullable: true, defaultValue: null, modelName: lucityautonumber )
• d_assettype ( type: esriFieldTypeString, alias: d_AssetType, editable: true, nullable: true, length: 30, defaultValue: null, modelName: d_assettype )
• globalid ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: globalid )
• 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 )
• 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:
  num_of_uplifts: null
  objectid_slx: null
  streetname: null
  fromstreetname: null
  tostreetname: null
  sci: 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_ft: null
  length_ft: null
  area_sy: 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
  video: null
  notes_2022: null
  assetid: null
  end_date_ss: null
  num_of_distresses: null
  projectname: null
  recorddrawing: null
  d_ownership: UNK
  d_datasource: RECD
  d_status: ACT
  installyear: null
  notes: null
  createdby: null
  datecreated: null
  modifiedby: null
  datemodified: null
  lucityautonumber: null
  d_assettype: null
  clx_uid: null
  start_date_ss: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Grinding
Name: Grinding
Domains:
Templates:
• Name: Grinding (Concrete)
  Description:
  Prototype:
  num_of_uplifts: null
  objectid_slx: null
  streetname: null
  fromstreetname: null
  tostreetname: null
  sci: null
  maintenance_suggestion: Grinding
  estimated_cost: null
  repair_priority: null
  functional_class: null
  functional_class_id: null
  surface_type: null
  survey_date: null
  width_ft: null
  length_ft: null
  area_sy: 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
  video: null
  notes_2022: null
  assetid: null
  end_date_ss: null
  num_of_distresses: null
  projectname: null
  recorddrawing: null
  d_ownership: UNK
  d_datasource: RECD
  d_status: ACT
  installyear: null
  notes: null
  createdby: null
  datecreated: null
  modifiedby: null
  datemodified: null
  lucityautonumber: null
  d_assettype: null
  clx_uid: null
  start_date_ss: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Reconstruction
Name: Reconstruction
Domains:
Templates:
• Name: Reconstruction
  Description:
  Prototype:
  num_of_uplifts: null
  objectid_slx: null
  streetname: null
  fromstreetname: null
  tostreetname: null
  sci: null
  maintenance_suggestion: Reconstruction
  estimated_cost: null
  repair_priority: null
  functional_class: null
  functional_class_id: null
  surface_type: null
  survey_date: null
  width_ft: null
  length_ft: null
  area_sy: 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
  video: null
  notes_2022: null
  assetid: null
  end_date_ss: null
  num_of_distresses: null
  projectname: null
  recorddrawing: null
  d_ownership: UNK
  d_datasource: RECD
  d_status: ACT
  installyear: null
  notes: null
  createdby: null
  datecreated: null
  modifiedby: null
  datemodified: null
  lucityautonumber: null
  d_assettype: null
  clx_uid: null
  start_date_ss: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Rehabilitation
Name: Rehabilitation
Domains:
Templates:
• Name: Rehabilitation
  Description:
  Prototype:
  objectid_slx: null
  end_date_ss: null
  streetname: null
  fromstreetname: null
  tostreetname: null
  sci: null
  num_of_uplifts: null
  maintenance_suggestion: Rehabilitation
  estimated_cost: null
  repair_priority: null
  functional_class: null
  functional_class_id: null
  surface_type: null
  survey_date: null
  width_ft: null
  length_ft: null
  area_sy: 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
  video: null
  notes_2022: null
  assetid: null
  start_date_ss: null
  num_of_distresses: null
  projectname: null
  recorddrawing: null
  d_ownership: UNK
  d_datasource: RECD
  d_status: ACT
  installyear: null
  notes: null
  createdby: null
  datecreated: null
  modifiedby: null
  datemodified: null
  lucityautonumber: null
  d_assettype: null
  clx_uid: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: null
Name: Null
Domains:
Templates:
• Name: null
  Description:
  Prototype:
  objectid_slx: null
  end_date_ss: null
  streetname: null
  fromstreetname: null
  tostreetname: null
  sci: null
  num_of_uplifts: null
  maintenance_suggestion: null
  estimated_cost: null
  repair_priority: null
  functional_class: null
  functional_class_id: null
  surface_type: null
  survey_date: null
  width_ft: null
  length_ft: null
  area_sy: 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
  video: null
  notes_2022: null
  assetid: null
  start_date_ss: null
  num_of_distresses: null
  projectname: null
  recorddrawing: null
  d_ownership: UNK
  d_datasource: RECD
  d_status: ACT
  installyear: null
  notes: null
  createdby: null
  datecreated: null
  modifiedby: null
  datemodified: null
  lucityautonumber: null
  d_assettype: null
  clx_uid: 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: true

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