{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"OPUC 811 Complaint","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}
HasZ: false
HasM: false
Time Info:
Start Time Field: complaint_start
End Time Field: complaint_submitted_end
Track ID Field: null
Time Extent
complaint_note (type: esriFieldTypeString, alias: Following the requirements of Oregon's Utility Notification, Locating, Marking and Excavation Rules are vital to safety of underground facilities, workers and the public. Investigations of alleged violations can be initiated through a complaint process administered by Oregon Public Utility Commission (OPUC). Once you complete this Complaint Survey, Staff will contact you or your company's designated contact for follow-up information. If you have any questions or would rather submit your Complaint/Request for Administrative Action to the OPUC Consumer Services Division, please contact us at 503-378-6600, 800-522-2404 or email puc.consumer@puc.oregon.gov You may have more information related to your complaint that could not be added to this Survey. If you have additional information that supports an alleged violation, please contact us., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
contact_note1 (type: esriFieldTypeString, alias: Please provide contact information for the parties involved in the complaint., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
alternative_contact_yes_no (type: esriFieldTypeString, alias: Does your organization have a designated contact person or group for OPUC information requests?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
alt_contact_muni (type: esriFieldTypeString, alias: Does your organization have a designated contact person or group for OPUC information requests?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
contact_note2 (type: esriFieldTypeString, alias: Who is your complaint against?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Stakeholder_Defendant_Offender (type: esriFieldTypeString, alias: Select the Stakeholder group for the person or entity your complaint is against., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [contractor1: Contractor], [county1: County], [developer1: Developer], ... 6 more ...)
mulitple_utility_stakehholder_utility (type: esriFieldTypeString, alias: Is your complaint concerning more than one utility?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
mulitple_utility_stakehholder_muni1 (type: esriFieldTypeString, alias: Is your complaint concerning more than one municipality?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
mult_utility1 (type: esriFieldTypeString, alias: Please list Utilities involved in your complaint., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
mult_muni (type: esriFieldTypeString, alias: Please list Municipalities involved in your complaint., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
stakeholder_lic_number (type: esriFieldTypeString, alias: Does the company or individual have a CCB, LCB or other professional license number?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
stakeholder_lic_digit (type: esriFieldTypeString, alias: If other license number is available, please enter it here., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
general_sub (type: esriFieldTypeString, alias: Was a general contractor onsite?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
sub_verification (type: esriFieldTypeString, alias: Is your complaint against a subcontractor?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
notification_locatingmarking_excavation_issue (type: esriFieldTypeString, alias: Complaints generally fall into one of the following root categories:One-Call (811) Notification PracticesLocating and Marking ServicesInsufficient Excavation PracticesIt is important to identify the root category so the issue can be addressed with the Stakeholder., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
complaint_category (type: esriFieldTypeString, alias: Please select a root category that best fits your complaint., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
too_many_catergory (type: esriFieldTypeString, alias: Selecting more than one category could be difficult to identify the root of the issue. Submitting separate complaint for another category is encouraged., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
many_catergory_discription (type: esriFieldTypeString, alias: Please describe your complaint and concerns for events that have multiple root categories., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
notification_practices (type: esriFieldTypeString, alias: Select subcategory for 811 Notification Practices that fits your complaint, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [no notification to One-Call Center 811: No Notification to One-Call Center (811)], [One-Call Center was notified but not sufficient: One-Call Center (811) was notified but not sufficient; timely; or, wrong information provided to One-Call Center.])
Insuf_one_call_notice_number (type: esriFieldTypeString, alias: Please provide the Oregon 811 Notification Ticket#:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
LocatingMarkingServices (type: esriFieldTypeString, alias: Select subcategory for Locating Marking Issues that fits your complaint., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [FacilityCouldNotBeFoundLocated: Facility Could Not Be Found or Located], [MarkingLocationNotSufficient: Facility Marking or Location Not Sufficient], [FacilityNotLocatedMarked: Facility Was Not Located or Marked], ... 1 more ...)
OR_locating_Marking_Issue (type: esriFieldTypeString, alias: Please provide the Oregon 811 Notification Ticket#:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
insuf_excav_practices (type: esriFieldTypeString, alias: Select subcategory for Insufficient Excavation Practices that fits your complaint., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [MaintainingMarks: Maintain Markings During Excavation], [SupportingExposedFacility: Supporting Exposed Facility], [UseHandtool: Improper Use of Hand tools Where Required], ... 3 more ...)
OR_one_call_refer_number (type: esriFieldTypeString, alias: Please provide the Oregon 811 Notification Ticket#:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
complaint_discription (type: esriFieldTypeString, alias: Please provide a general description of your complaint., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
unable_to_locate (type: esriFieldTypeString, alias: Please describe your project and the events related to when you discovered facilities could not be found or located., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Q1_locate_image (type: esriFieldTypeString, alias: Do you have a photo of the project, prior to excavating where facilities could not be found or located? Please upload your photo below., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
Q2_locate_image (type: esriFieldTypeString, alias: Do you have a photo of the project, during or after excavation where facilities could not be found or located? Please upload your photo below., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
unable_to_locate_sum (type: esriFieldTypeString, alias: Please share anything else about events or additional information that supports the alleged violation regarding facilities that could not be found or located., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
mark_not_suff_description (type: esriFieldTypeString, alias: Please describe your project and how you discovered underground facilities were not located and marked sufficiently., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Q1_locating_marking_image (type: esriFieldTypeString, alias: Do you have photos of the project where locating and marking were not sufficient? Please upload your photos below., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
mark_not_suff_description_sum (type: esriFieldTypeString, alias: Please share anything else about events or additional information that supports the alleged violation regarding facilities not sufficient located and marked., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
no_loc_mark (type: esriFieldTypeString, alias: Please describe your project and how you discovered underground facilities were not located and marked., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Q1_no_locating_marking (type: esriFieldTypeString, alias: Do you have photos of the project, prior to excavating where there was no locating and marking of facilities? Please upload your photo(s) below., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
Q2_no_locating_marking (type: esriFieldTypeString, alias: Do you have photos of the project, during or after excavation where no locating and marking of facilities occurred? Please upload your photo(s) below., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
no_loc_marking_sum (type: esriFieldTypeString, alias: Please share anything else about events or additional information that supports the alleged violation regarding facilities not located and marked., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ill_map_records (type: esriFieldTypeString, alias: Please describe your project and how you discovered incorrect facility, maps and records., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ill_map_records_sum (type: esriFieldTypeString, alias: Please share anything else about events or additional information that supports the alleged violation regarding insufficient maps and/or records., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
excavation_verification_yes_no (type: esriFieldTypeString, alias: Can you confirm whether excavation took place?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
Excavation_dateTime (type: esriFieldTypeDate, alias: When did you discover or have knowledge of excavation activity taking place?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Excavation_begin_when (type: esriFieldTypeString, alias: Do you know approximately when excavation activity began?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes, I know the date and time.: Yes, I know the date and time.], [no: No.], [Yes, I know the date but not the time.: Yes, I know the date but not the time.])
ExcavationYes_dateTime (type: esriFieldTypeDate, alias: Please provide date and time., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ExcavationYes_date (type: esriFieldTypeDate, alias: Please provide the date., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Project_Type_of_Work (type: esriFieldTypeString, alias: What type of work was being done when excavation took place?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [agriculture: Agriculture], [building construction: Building Construction], [building demolition: Building Demolition], ... 28 more ...)
Emergency_Excavation (type: esriFieldTypeString, alias: Was the excavation activity in response to an emergency?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
Emergency_Classification (type: esriFieldTypeString, alias: Which of the following best describes the emergency?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [prevent loss of life: Prevent Loss of Life], [mitigate damage to property: Mitigate Damage to Property], [prevent interruption of essential public services: Prevent Interruption of Essential Public Service], ... 1 more ...)
Q_ex_overall_image (type: esriFieldTypeString, alias: Do you have a photo of the general area where excavation occurred?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
markings_aboveground_facility (type: esriFieldTypeString, alias: In the immediate area of excavation, are there any visible markings or aboveground facilities that would indicate the presence of an underground facility?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
markings_aboveground_facilities (type: esriFieldTypeString, alias: Select visible marking or aboveground facility type(s) and provide photo(s) below., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ex_equipment_tools (type: esriFieldTypeString, alias: What type of equipment was used onsite by the excavating party?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [auger: Auger], [backhoe/track_excavator: Backhoe/Track Excavator], [boring: Boring], ... 12 more ...)
ex_equipment_tools_image (type: esriFieldTypeString, alias: Do you have photos of the excavation equipment or tool used onsite?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
ex_equip_tool_Model (type: esriFieldTypeString, alias: Provide the model number for machine excavation equipment., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ex_damage_yes_no (type: esriFieldTypeString, alias: Did the excavation cause damage to an underground facility?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
ex_damage_image (type: esriFieldTypeString, alias: Do you have a photo of the damaged underground facility?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
ex_damage_product_release (type: esriFieldTypeString, alias: Did the damage cause a utility outage or interrupt utility service?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
ex_damage_expose_unknown (type: esriFieldTypeString, alias: Was the facility exposed at the time of the damage?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
ex_handtool_damage (type: esriFieldTypeString, alias: Did the damage occur with hand tools?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
excavation_activities_sum (type: esriFieldTypeString, alias: Please share anything else about events or additional information that supports your complaint of an alleged violation., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
facility_type (type: esriFieldTypeString, alias: What is the type of underground facility?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
branch_type (type: esriFieldTypeString, alias: Which line type is the underground facility?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
facility_size (type: esriFieldTypeString, alias: Is the width of the underground facility greater than 2 inches?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)