Layer: Form_10 (ID:0)

View In: Map Viewer

Name: Form_10

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Has Views: true

Source Schema Changes Allowed: true

Views

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"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

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: objectid

Unique ID Field:

Global ID Field: globalid

Type ID Field:

Fields:

objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
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 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@state.or.us 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)
complianant_information (type: esriFieldTypeString, alias: Complaint submitted by:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
stakeholder_id (type: esriFieldTypeString, alias: Please select your Stakeholder group., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [contractor1: Contractor], [county1: County], [developer1: Developer], ... 6 more ...)
complianant_first_name (type: esriFieldTypeString, alias: First Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
complainant_last_name (type: esriFieldTypeString, alias: Last Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
complainant_org (type: esriFieldTypeString, alias: Organization/Company, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
complainant_address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
complainant_city (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
complainant_zip (type: esriFieldTypeInteger, alias: Zip, SQL Type: sqlTypeOther, nullable: true, editable: true)
complainant_phone (type: esriFieldTypeString, alias: Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
complainant_email (type: esriFieldTypeString, alias: Email, 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])
alternative_contact (type: esriFieldTypeString, alias: Designated Contact(s), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
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])
alternative_contact1 (type: esriFieldTypeString, alias: Designated Contact(s), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
contact_note2 (type: esriFieldTypeString, alias: Who your compliant is 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 compliant 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)
defendant_last_name (type: esriFieldTypeString, alias: First Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
defendant_first_name (type: esriFieldTypeString, alias: Last Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
defendant_organization_company (type: esriFieldTypeString, alias: Organization/Company, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
defendant_address_address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
defendant_city_city (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
defendant_zip_zip (type: esriFieldTypeInteger, alias: Zip, SQL Type: sqlTypeOther, nullable: true, editable: true)
defendant_phone (type: esriFieldTypeString, alias: Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
defendant_email_email (type: esriFieldTypeString, alias: Email, 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)
lic_type (type: esriFieldTypeString, alias: Select license type., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
stakeholder_lic_text (type: esriFieldTypeString, alias: Please provide license number., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
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 It 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: esriFieldTypeInteger, alias: Please provide the Oregon 811 Notification Ticket#:, SQL Type: sqlTypeOther, 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: esriFieldTypeInteger, alias: Please provide the Oregon 811 Notification Ticket#:, SQL Type: sqlTypeOther, 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: esriFieldTypeInteger, alias: Please provide the Oregon 811 Notification Ticket#:, SQL Type: sqlTypeOther, 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 photos of the project, prior to excavating where facilities could not be found or located? Please upload your photo(s) 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 photos of the project, during or after excavation where facilities could not be found or located? Please upload your photo(s) 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 photo(s) 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 facilities not sufficient located and marked., 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 photos 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])
ex_hand_tools (type: esriFieldTypeString, alias: Select hand tool type., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [drill: Drill], [hammer: Hammer], [pick: Pick], ... 3 more ...)
emergency_officials (type: esriFieldTypeString, alias: Were emergency public officials notified or present onsite?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
emergency_public_officials (type: esriFieldTypeString, alias: Please provide responding agencies., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
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, Coded Values: [cable: Cable], [electric: Electric], [natural gas: Natural Gas], ... 6 more ...)
branch_type (type: esriFieldTypeString, alias: Which line type is the underground facility?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [main: Main], [service: Service])
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, Coded Values: [yes: Yes], [no: No])
CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
complaint_start (type: esriFieldTypeDate, alias: complaint_start, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
complaint_submitted_end (type: esriFieldTypeDate, alias: complaint_submitted_end, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/11/2021 3:42:43 PM

Schema Last Edit Date: 6/11/2021 3:42:43 PM

Data Last Edit Date: 6/11/2021 3:42:43 PM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Query Attachments Add Features Update Features Apply Edits Calculate Generate Renderer Validate SQL Get Estimates ConvertFormat