View In:   ArcGIS Online Map Viewer

Name: Sign Maintenance

Display Field: streetname

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 3200

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: 1321333.8056457988
YMin: 356503.21909533883
XMax: 1342345.6678102538
YMax: 379117.11401333695
Spatial Reference: PROJCS["NAD83 / Washington North (ftUS)",GEOGCS["NAD83",DATUM["North_American_Datum_1983",SPHEROID["GRS 1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic_2SP"],PARAMETER["false_easting",1640416.667],PARAMETER["false_northing",0.0],PARAMETER["central_meridian",-120.833333333333],PARAMETER["standard_parallel_1",47.5],PARAMETER["standard_parallel_2",48.7333333333333],PARAMETER["latitude_of_origin",47.0],UNIT["US survey foot",0.3048006096012192]]

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
  Label: Defer
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [116, 173, 66, 255]
  Size: 5.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [240, 240, 240, 0] Width: 1
• Value: Replace
  Label: Replace
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [131, 41, 166, 255]
  Size: 5.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [240, 240, 240, 0] Width: 1
• Value: Retire
  Label: Retire
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 197, 255, 255]
  Size: 5.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [240, 240, 240, 0] 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

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 )
• sign_type ( type: esriFieldTypeString, alias: sign_type, editable: true, nullable: true, length: 22, defaultValue: null, modelName: sign_type )
• sign_other ( type: esriFieldTypeString, alias: sign_other, editable: true, nullable: true, length: 40, defaultValue: null, modelName: sign_other )
• sign_code ( type: esriFieldTypeString, alias: sign_code, editable: true, nullable: true, length: 15, defaultValue: null, modelName: sign_code )
• post_cond ( type: esriFieldTypeString, alias: post_cond, editable: true, nullable: true, length: 22, defaultValue: null, modelName: post_cond )
• post_matl ( type: esriFieldTypeString, alias: post_matl, editable: true, nullable: true, length: 22, defaultValue: null, modelName: post_matl )
• comments ( type: esriFieldTypeString, alias: comments, editable: true, nullable: true, length: 40, defaultValue: null, modelName: comments )
• offset_cl ( type: esriFieldTypeInteger, alias: offset_cl, editable: true, nullable: true, defaultValue: null, modelName: offset_cl )
• sgn_height ( type: esriFieldTypeInteger, alias: sgn_height, editable: true, nullable: true, defaultValue: null, modelName: sgn_height )
• sign_size ( type: esriFieldTypeString, alias: sign_size, editable: true, nullable: true, length: 50, defaultValue: null, modelName: sign_size )
• n_s_road ( type: esriFieldTypeString, alias: n_s_road, editable: true, nullable: true, length: 50, defaultValue: null, modelName: n_s_road )
• e_w_road ( type: esriFieldTypeString, alias: e_w_road, editable: true, nullable: true, length: 50, defaultValue: null, modelName: e_w_road )
• install_yr ( type: esriFieldTypeDate, alias: install_yr, editable: true, nullable: true, length: 8, defaultValue: null, modelName: install_yr )
• condition ( type: esriFieldTypeInteger, alias: condition, editable: true, nullable: true, defaultValue: null, modelName: condition )
• uniq_id ( type: esriFieldTypeString, alias: uniq_id, editable: true, nullable: true, length: 10, defaultValue: null, modelName: uniq_id )
• leg_refl ( type: esriFieldTypeInteger, alias: leg_refl, editable: true, nullable: true, defaultValue: null, modelName: leg_refl )
• back_refl ( type: esriFieldTypeInteger, alias: back_refl, editable: true, nullable: true, defaultValue: null, modelName: back_refl )
• descr ( type: esriFieldTypeString, alias: descr, editable: true, nullable: true, length: 50, defaultValue: null, modelName: descr )
• position_ ( type: esriFieldTypeInteger, alias: position_, editable: true, nullable: true, defaultValue: null, modelName: position_ )
• inspected ( type: esriFieldTypeDate, alias: inspected, editable: true, nullable: true, length: 8, defaultValue: null, modelName: inspected )
• source ( type: esriFieldTypeString, alias: source, editable: true, nullable: true, length: 20, defaultValue: null, modelName: source )
• creator_1 ( type: esriFieldTypeString, alias: creator_1, editable: true, nullable: true, length: 20, defaultValue: null, modelName: creator_1 )
• xcoord ( type: esriFieldTypeDouble, alias: xcoord, editable: true, nullable: true, defaultValue: null, modelName: xcoord )
• ycoord ( type: esriFieldTypeDouble, alias: ycoord, editable: true, nullable: true, defaultValue: null, modelName: ycoord )
• ss_id ( type: esriFieldTypeInteger, alias: SS ID, editable: true, nullable: true, defaultValue: null, modelName: ss_id )
• 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 )
• 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 )
• signcategory ( type: esriFieldTypeString, alias: Sign Category, editable: true, nullable: true, length: 50, defaultValue: null, modelName: signcategory )
• signtype ( type: esriFieldTypeString, alias: Sign Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: signtype )
• signcondition ( type: esriFieldTypeString, alias: Sign Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: signcondition )
• retroreflectivity ( type: esriFieldTypeDouble, alias: Retroreflectivity, editable: true, nullable: true, defaultValue: null, modelName: retroreflectivity )
• installation_date ( type: esriFieldTypeDate, alias: Installation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: installation_date )
• remaining_warranty_yrs ( type: esriFieldTypeSmallInteger, alias: Remaining Warranty (yrs), editable: true, nullable: true, defaultValue: null, modelName: remaining_warranty_yrs )
• survey_date ( type: esriFieldTypeDate, alias: Survey Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: survey_date )
• image_path ( type: esriFieldTypeString, alias: Image Path, editable: true, nullable: true, length: 255, defaultValue: null, modelName: image_path )
• notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 150, defaultValue: null, modelName: notes )
• 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 )
• maintenance_suggestion ( type: esriFieldTypeString, alias: Maintenance Suggestion, editable: true, nullable: true, length: 50, defaultValue: null, modelName: maintenance_suggestion )
• 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 )
• last_edit ( type: esriFieldTypeDate, alias: Last Edit, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_edit )
• future_event ( type: esriFieldTypeString, alias: Future Event, editable: true, nullable: true, length: 100, 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_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 )
• editor_notes ( type: esriFieldTypeString, alias: Editor Notes, editable: true, nullable: true, length: 150, defaultValue: null, modelName: editor_notes )
• symbology ( type: esriFieldTypeString, alias: Symbology, editable: true, nullable: true, length: 50, defaultValue: null, modelName: symbology )
• 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 )
• condition_index ( type: esriFieldTypeInteger, alias: condition_index, editable: true, nullable: true, defaultValue: null, modelName: condition_index )
• sign_id ( type: esriFieldTypeInteger, alias: sign_id, editable: true, nullable: true, defaultValue: null, modelName: sign_id )
• clx_uid ( type: esriFieldTypeInteger, alias: clx_uid, editable: true, nullable: true, defaultValue: null, modelName: clx_uid )

Types:

ID: Defer
Name: Defer
Domains:
Templates:
• Name: Defer
  Description:
  Prototype:
  repair_priority: null
  clx_uid: null
  sign_type: null
  sign_other: null
  sign_code: null
  post_cond: null
  post_matl: null
  comments: null
  offset_cl: null
  sgn_height: null
  sign_size: null
  n_s_road: null
  e_w_road: null
  install_yr: null
  condition: null
  uniq_id: null
  leg_refl: null
  back_refl: null
  descr: null
  position_: null
  inspected: null
  source: null
  creator_1: null
  xcoord: null
  ycoord: null
  ss_id: null
  streetname: null
  fromstreetname: null
  tostreetname: null
  functional_class: null
  functional_class_id: null
  signcategory: null
  signtype: null
  signcondition: null
  retroreflectivity: null
  installation_date: null
  remaining_warranty_yrs: null
  survey_date: null
  image_path: null
  notes: null
  estimated_cost: null
  maintenance_suggestion: Defer
  last_repair_method: null
  last_repair_cost: null
  last_repair_date: null
  last_edit: null
  future_event: null
  future_event_date: null
  editor_name: null
  editor_id: null
  editor_notes: null
  symbology: null
  start_date_ss: null
  end_date_ss: null
  objectid_slx: null
  condition_index: null
  sign_id: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Replace
Name: Replace
Domains:
Templates:
• Name: Replace
  Description:
  Prototype:
  repair_priority: null
  clx_uid: null
  sign_type: null
  sign_other: null
  sign_code: null
  post_cond: null
  post_matl: null
  comments: null
  offset_cl: null
  sgn_height: null
  sign_size: null
  n_s_road: null
  e_w_road: null
  install_yr: null
  condition: null
  uniq_id: null
  leg_refl: null
  back_refl: null
  descr: null
  position_: null
  inspected: null
  source: null
  creator_1: null
  xcoord: null
  ycoord: null
  ss_id: null
  streetname: null
  fromstreetname: null
  tostreetname: null
  functional_class: null
  functional_class_id: null
  signcategory: null
  signtype: null
  signcondition: null
  retroreflectivity: null
  installation_date: null
  remaining_warranty_yrs: null
  survey_date: null
  image_path: null
  notes: null
  estimated_cost: null
  maintenance_suggestion: Replace
  last_repair_method: null
  last_repair_cost: null
  last_repair_date: null
  last_edit: null
  future_event: null
  future_event_date: null
  editor_name: null
  editor_id: null
  editor_notes: null
  symbology: null
  start_date_ss: null
  end_date_ss: null
  objectid_slx: null
  condition_index: null
  sign_id: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Retire
Name: Retire
Domains:
Templates:
• Name: Retire
  Description:
  Prototype:
  repair_priority: null
  clx_uid: null
  sign_type: null
  sign_other: null
  sign_code: null
  post_cond: null
  post_matl: null
  comments: null
  offset_cl: null
  sgn_height: null
  sign_size: null
  n_s_road: null
  e_w_road: null
  install_yr: null
  condition: null
  uniq_id: null
  leg_refl: null
  back_refl: null
  descr: null
  position_: null
  inspected: null
  source: null
  creator_1: null
  xcoord: null
  ycoord: null
  ss_id: null
  streetname: null
  fromstreetname: null
  tostreetname: null
  functional_class: null
  functional_class_id: null
  signcategory: null
  signtype: null
  signcondition: null
  retroreflectivity: null
  installation_date: null
  remaining_warranty_yrs: null
  survey_date: null
  image_path: null
  notes: null
  estimated_cost: null
  maintenance_suggestion: Retire
  last_repair_method: null
  last_repair_cost: null
  last_repair_date: null
  last_edit: null
  future_event: null
  future_event_date: null
  editor_name: null
  editor_id: null
  editor_notes: null
  symbology: null
  start_date_ss: null
  end_date_ss: null
  objectid_slx: null
  condition_index: null
  sign_id: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

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