Form_10
None
nan
[{'name': 'objectid', 'type': 'esriFieldTypeOID', 'alias': 'ObjectID', 'sqlType': 'sqlTypeOther', 'nullable': False, 'editable': False, 'domain': None, 'defaultValue': None}, {'name': 'globalid', 'type': 'esriFieldTypeGlobalID', 'alias': 'GlobalID', 'sqlType': 'sqlTypeGUID', 'length': 38, 'nullable': False, 'editable': False, 'domain': None, 'defaultValue': None}, {'name': '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.", 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'contact_note1', 'type': 'esriFieldTypeString', 'alias': 'Please provide contact information for the parties involved in the complaint.', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'complianant_information', 'type': 'esriFieldTypeString', 'alias': 'Complaint submitted by:', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'stakeholder_id', 'type': 'esriFieldTypeString', 'alias': 'Please select your Stakeholder group.', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'cvd_stakeholder_id', 'codedValues': [{'name': 'Contractor', 'code': 'contractor1'}, {'name': 'County', 'code': 'county1'}, {'name': 'Developer', 'code': 'developer1'}, {'name': 'Farmer', 'code': 'farmer1'}, {'name': 'Municipality', 'code': 'municipality1'}, {'name': 'Occupant/Consumer/Public', 'code': 'occupant1'}, {'name': 'Railroad Maintenance', 'code': 'railroadmaintenance1'}, {'name': 'State', 'code': 'state1'}, {'name': 'Utility', 'code': 'utility1'}]}, 'defaultValue': None}, {'name': 'complianant_first_name', 'type': 'esriFieldTypeString', 'alias': 'First Name', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'complainant_last_name', 'type': 'esriFieldTypeString', 'alias': 'Last Name', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'complainant_org', 'type': 'esriFieldTypeString', 'alias': 'Organization/Company', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'complainant_address', 'type': 'esriFieldTypeString', 'alias': 'Address', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'complainant_city', 'type': 'esriFieldTypeString', 'alias': 'City', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'complainant_zip', 'type': 'esriFieldTypeInteger', 'alias': 'Zip', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'complainant_phone', 'type': 'esriFieldTypeString', 'alias': 'Phone', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'complainant_email', 'type': 'esriFieldTypeString', 'alias': 'Email', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'alternative_contact_yes_no', 'type': 'esriFieldTypeString', 'alias': 'Does your organization have a designated contact person or group for OPUC information requests?', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'cvd_alternative_contact_yes_no', 'codedValues': [{'name': 'Yes', 'code': 'yes'}, {'name': 'No', 'code': 'no'}, {'name': 'Unknown', 'code': 'unknown'}]}, 'defaultValue': None}, {'name': 'alternative_contact', 'type': 'esriFieldTypeString', 'alias': 'Designated Contact(s)', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'alt_contact_muni', 'type': 'esriFieldTypeString', 'alias': 'Does your organization have a designated contact person or group for OPUC information requests?', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'cvd_alt_contact_muni', 'codedValues': [{'name': 'Yes', 'code': 'yes'}, {'name': 'No', 'code': 'no'}, {'name': 'Unknown', 'code': 'unknown'}]}, 'defaultValue': None}, {'name': 'alternative_contact1', 'type': 'esriFieldTypeString', 'alias': 'Designated Contact(s)', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'contact_note2', 'type': 'esriFieldTypeString', 'alias': 'Who your compliant is against?', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'Stakeholder_Defendant_Offender', 'type': 'esriFieldTypeString', 'alias': 'Select the Stakeholder group for the person or entity your compliant is against.', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'cvd_Stakeholder_Defendant_Offender', 'codedValues': [{'name': 'Contractor', 'code': 'contractor1'}, {'name': 'County', 'code': 'county1'}, {'name': 'Developer', 'code': 'developer1'}, {'name': 'Farmer', 'code': 'farmer1'}, {'name': 'Municipality', 'code': 'municipality1'}, {'name': 'Occupant/Consumer/Public', 'code': 'occupant1'}, {'name': 'Railroad Maintenance', 'code': 'railroadmaintenance1'}, {'name': 'State', 'code': 'state1'}, {'name': 'Utility', 'code': 'utility1'}]}, 'defaultValue': None}, {'name': 'mulitple_utility_stakehholder_utility', 'type': 'esriFieldTypeString', 'alias': 'Is your complaint concerning more than one utility?', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'cvd_mulitple_utility_stakehholder_utility', 'codedValues': [{'name': 'Yes', 'code': 'yes'}, {'name': 'No', 'code': 'no'}, {'name': 'Unknown', 'code': 'unknown'}]}, 'defaultValue': None}, {'name': 'mulitple_utility_stakehholder_muni1', 'type': 'esriFieldTypeString', 'alias': 'Is your complaint concerning more than one municipality?', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'cvd_mulitple_utility_stakehholder_muni1', 'codedValues': [{'name': 'Yes', 'code': 'yes'}, {'name': 'No', 'code': 'no'}, {'name': 'Unknown', 'code': 'unknown'}]}, 'defaultValue': None}, {'name': 'mult_utility1', 'type': 'esriFieldTypeString', 'alias': 'Please list Utilities involved in your complaint.', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'mult_muni', 'type': 'esriFieldTypeString', 'alias': 'Please list Municipalities involved in your complaint.', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'defendant_last_name', 'type': 'esriFieldTypeString', 'alias': 'First Name', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'defendant_first_name', 'type': 'esriFieldTypeString', 'alias': 'Last Name', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'defendant_organization_company', 'type': 'esriFieldTypeString', 'alias': 'Organization/Company', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'defendant_address_address', 'type': 'esriFieldTypeString', 'alias': 'Address', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'defendant_city_city', 'type': 'esriFieldTypeString', 'alias': 'City', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'defendant_zip_zip', 'type': 'esriFieldTypeInteger', 'alias': 'Zip', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'defendant_phone', 'type': 'esriFieldTypeString', 'alias': 'Phone', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'defendant_email_email', 'type': 'esriFieldTypeString', 'alias': 'Email', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'stakeholder_lic_number', 'type': 'esriFieldTypeString', 'alias': 'Does the company or individual have a CCB, LCB or other professional license number?', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'lic_type', 'type': 'esriFieldTypeString', 'alias': 'Select license type.', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'stakeholder_lic_text', 'type': 'esriFieldTypeString', 'alias': 'Please provide license number.', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'stakeholder_lic_digit', 'type': 'esriFieldTypeString', 'alias': 'If other license number is available, please enter it here.', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'general_sub', 'type': 'esriFieldTypeString', 'alias': 'Was a general contractor onsite?', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'cvd_general_sub', 'codedValues': [{'name': 'Yes', 'code': 'yes'}, {'name': 'No', 'code': 'no'}, {'name': 'Unknown', 'code': 'unknown'}]}, 'defaultValue': None}, {'name': 'sub_verification', 'type': 'esriFieldTypeString', 'alias': 'Is your complaint against a subcontractor?', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'cvd_sub_verification', 'codedValues': [{'name': 'Yes', 'code': 'yes'}, {'name': 'No', 'code': 'no'}, {'name': 'Unknown', 'code': 'unknown'}]}, 'defaultValue': None}, {'name': '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.', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'complaint_category', 'type': 'esriFieldTypeString', 'alias': 'Please select a root category that best fits your complaint.', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': '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.', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'many_catergory_discription', 'type': 'esriFieldTypeString', 'alias': 'Please describe your complaint and concerns for events that have multiple root categories.', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'notification_practices', 'type': 'esriFieldTypeString', 'alias': 'Select subcategory for 811 Notification Practices that fits your complaint', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'cvd_notification_practices', 'codedValues': [{'name': 'No Notification to One-Call Center (811)', 'code': 'no notification to One-Call Center 811'}, {'name': 'One-Call Center (811) was notified but not sufficient; timely; or, wrong information provided to One-Call Center.', 'code': 'One-Call Center was notified but not sufficient'}]}, 'defaultValue': None}, {'name': 'Insuf_one_call_notice_number', 'type': 'esriFieldTypeInteger', 'alias': 'Please provide the Oregon 811 Notification Ticket#:', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'LocatingMarkingServices', 'type': 'esriFieldTypeString', 'alias': 'Select subcategory for Locating Marking Issues that fits your complaint.', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'cvd_LocatingMarkingServices', 'codedValues': [{'name': 'Facility Could Not Be Found or Located', 'code': 'FacilityCouldNotBeFoundLocated'}, {'name': 'Facility Marking or Location Not Sufficient', 'code': 'MarkingLocationNotSufficient'}, {'name': 'Facility Was Not Located or Marked', 'code': 'FacilityNotLocatedMarked'}, {'name': 'Incorrect Facility Records or Maps', 'code': 'IncorrectFacilityRecordsMaps'}]}, 'defaultValue': None}, {'name': 'OR_locating_Marking_Issue', 'type': 'esriFieldTypeInteger', 'alias': 'Please provide the Oregon 811 Notification Ticket#:', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'insuf_excav_practices', 'type': 'esriFieldTypeString', 'alias': 'Select subcategory for Insufficient Excavation Practices that fits your complaint.', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'cvd_insuf_excav_practices', 'codedValues': [{'name': 'Maintain Markings During Excavation', 'code': 'MaintainingMarks'}, {'name': 'Supporting Exposed Facility', 'code': 'SupportingExposedFacility'}, {'name': 'Improper Use of Hand tools Where Required', 'code': 'UseHandtool'}, {'name': 'Improper Test-hole (pot-hole) or Backfilling Practices', 'code': 'TestHolePotholeOrBackfill'}, {'name': 'Did Not Maintain Clearance', 'code': 'MaintainClearence'}, {'name': 'Other: Insufficient Excavation Practices', 'code': 'OtherInsuffExPractices'}]}, 'defaultValue': None}, {'name': 'OR_one_call_refer_number', 'type': 'esriFieldTypeInteger', 'alias': 'Please provide the Oregon 811 Notification Ticket#:', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'complaint_discription', 'type': 'esriFieldTypeString', 'alias': 'Please provide a general description of your complaint.', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': '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.', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': '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.', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'cvd_Q1_locate_image', 'codedValues': [{'name': 'Yes', 'code': 'yes'}, {'name': 'No', 'code': 'no'}, {'name': 'Unknown', 'code': 'unknown'}]}, 'defaultValue': None}, {'name': '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.', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'cvd_Q2_locate_image', 'codedValues': [{'name': 'Yes', 'code': 'yes'}, {'name': 'No', 'code': 'no'}, {'name': 'Unknown', 'code': 'unknown'}]}, 'defaultValue': None}, {'name': '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.', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'mark_not_suff_description', 'type': 'esriFieldTypeString', 'alias': 'Please describe your project and how you discovered underground facilities were not located and marked sufficiently.', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': '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.', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'cvd_Q1_locating_marking_image', 'codedValues': [{'name': 'Yes', 'code': 'yes'}, {'name': 'No', 'code': 'no'}, {'name': 'Unknown', 'code': 'unknown'}]}, 'defaultValue': None}, {'name': '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.', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'no_loc_mark', 'type': 'esriFieldTypeString', 'alias': 'Please describe your project and how you discovered underground facilities were not located and marked.', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': '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.', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'cvd_Q1_no_locating_marking', 'codedValues': [{'name': 'Yes', 'code': 'yes'}, {'name': 'No', 'code': 'no'}, {'name': 'Unknown', 'code': 'unknown'}]}, 'defaultValue': None}, {'name': '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.', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'cvd_Q2_no_locating_marking', 'codedValues': [{'name': 'Yes', 'code': 'yes'}, {'name': 'No', 'code': 'no'}, {'name': 'Unknown', 'code': 'unknown'}]}, 'defaultValue': None}, {'name': '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.', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'ill_map_records', 'type': 'esriFieldTypeString', 'alias': 'Please describe your project and how you discovered incorrect facility, maps and records.', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': '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.', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'excavation_verification_yes_no', 'type': 'esriFieldTypeString', 'alias': 'Can you confirm whether excavation took place?', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'cvd_excavation_verification_yes_no', 'codedValues': [{'name': 'Yes', 'code': 'yes'}, {'name': 'No', 'code': 'no'}]}, 'defaultValue': None}, {'name': 'Excavation_dateTime', 'type': 'esriFieldTypeDate', 'alias': 'When did you discover or have knowledge of excavation activity taking place?', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'precision': 1}, {'name': 'Excavation_begin_when', 'type': 'esriFieldTypeString', 'alias': 'Do you know approximately when excavation activity began?', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'cvd_Excavation_begin_when', 'codedValues': [{'name': 'Yes, I know the date and time.', 'code': 'Yes, I know the date and time.'}, {'name': 'No.', 'code': 'no'}, {'name': 'Yes, I know the date but not the time.', 'code': 'Yes, I know the date but not the time.'}]}, 'defaultValue': None}, {'name': 'ExcavationYes_dateTime', 'type': 'esriFieldTypeDate', 'alias': 'Please provide date and time.', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'precision': 1}, {'name': 'ExcavationYes_date', 'type': 'esriFieldTypeDate', 'alias': 'Please provide the date.', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'precision': 1}, {'name': 'Project_Type_of_Work', 'type': 'esriFieldTypeString', 'alias': 'What type of work was being done when excavation took place?', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'cvd_Project_Type_of_Work', 'codedValues': [{'name': 'Agriculture', 'code': 'agriculture'}, {'name': 'Building Construction', 'code': 'building construction'}, {'name': 'Building Demolition', 'code': 'building demolition'}, {'name': 'Cable', 'code': 'cable'}, {'name': 'Curb / Sidewalk', 'code': 'curb/sidewalk'}, {'name': 'Data Not Collected', 'code': 'data not collected'}, {'name': 'Drainage', 'code': 'drainage'}, {'name': 'Driveway', 'code': 'driveway'}, {'name': 'Electric', 'code': 'electric'}, {'name': 'Engineering / Survey', 'code': 'engineering/survey'}, {'name': 'Fencing', 'code': 'fencing'}, {'name': 'Irrigation', 'code': 'irrigation'}, {'name': 'Landscaping', 'code': 'landscaping'}, {'name': 'Liquid Pipeline', 'code': 'liquid pipeline'}, {'name': 'Milling', 'code': 'milling'}, {'name': 'Natural Gas', 'code': 'natural gas'}, {'name': 'Pole / Post', 'code': 'pole'}, {'name': 'Public Transit Authority', 'code': 'public transit authority'}, {'name': 'Railroad Maintenance', 'code': 'railroad maintenance'}, {'name': 'Road Work', 'code': 'road work'}, {'name': 'Sewer', 'code': 'Sewer'}, {'name': 'Site Development', 'code': 'site development'}, {'name': 'Steam', 'code': 'steam'}, {'name': 'Storm Drain/Culvert', 'code': 'storm drain/culvert'}, {'name': 'Street Light', 'code': 'street light'}, {'name': 'Telecommunications', 'code': 'telecommunications'}, {'name': 'Traffic Signal', 'code': 'traffic signal'}, {'name': 'Traffic Signs', 'code': 'traffic signs'}, {'name': 'Unknown / Other', 'code': 'unknown / other'}, {'name': 'Water', 'code': 'water'}, {'name': 'Water Improvement', 'code': 'waterway improvement'}]}, 'defaultValue': None}, {'name': 'Emergency_Excavation', 'type': 'esriFieldTypeString', 'alias': 'Was the excavation activity in response to an emergency?', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'cvd_Emergency_Excavation', 'codedValues': [{'name': 'Yes', 'code': 'yes'}, {'name': 'No', 'code': 'no'}]}, 'defaultValue': None}, {'name': 'Emergency_Classification', 'type': 'esriFieldTypeString', 'alias': 'Which of the following best describes the emergency?', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'cvd_Emergency_Classification', 'codedValues': [{'name': 'Prevent Loss of Life', 'code': 'prevent loss of life'}, {'name': 'Mitigate Damage to Property', 'code': 'mitigate damage to property'}, {'name': 'Prevent Interruption of Essential Public Service', 'code': 'prevent interruption of essential public services'}, {'name': 'Prevent Customer Service Outage', 'code': 'prevent a customer service outage'}]}, 'defaultValue': None}, {'name': 'Q_ex_overall_image', 'type': 'esriFieldTypeString', 'alias': 'Do you have photos of the general area where excavation occurred?', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'cvd_Q_ex_overall_image', 'codedValues': [{'name': 'Yes', 'code': 'yes'}, {'name': 'No', 'code': 'no'}, {'name': 'Unknown', 'code': 'unknown'}]}, 'defaultValue': None}, {'name': '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?', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'cvd_markings_aboveground_facility', 'codedValues': [{'name': 'Yes', 'code': 'yes'}, {'name': 'No', 'code': 'no'}, {'name': 'Unknown', 'code': 'unknown'}]}, 'defaultValue': None}, {'name': 'markings_aboveground_facilities', 'type': 'esriFieldTypeString', 'alias': 'Select visible marking or aboveground facility type(s) and provide photo(s) below.', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'ex_equipment_tools', 'type': 'esriFieldTypeString', 'alias': 'What type of equipment was used onsite by the excavating party?', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'cvd_ex_equipment_tools', 'codedValues': [{'name': 'Auger', 'code': 'auger'}, {'name': 'Backhoe/Track Excavator', 'code': 'backhoe/track_excavator'}, {'name': 'Boring', 'code': 'boring'}, {'name': 'Drilling', 'code': 'drilling'}, {'name': 'Directional Drilling', 'code': 'directional drilling'}, {'name': 'Explosives', 'code': 'explosives'}, {'name': 'Farm Equipment', 'code': 'farm equipment'}, {'name': 'Grader/Scraper', 'code': 'grader/scraper'}, {'name': 'Hand Tools', 'code': 'hand tools'}, {'name': 'Milling Equipment', 'code': 'milling equipment'}, {'name': 'Probing Device', 'code': 'probing device'}, {'name': 'Trencher', 'code': 'trencher'}, {'name': 'Vacuum Equipment', 'code': 'vacuum equipment'}, {'name': 'Data Not Collected', 'code': 'data not collected'}, {'name': 'Unknown / Other', 'code': 'unknown / other'}]}, 'defaultValue': None}, {'name': 'ex_equipment_tools_image', 'type': 'esriFieldTypeString', 'alias': 'Do you have photos of the excavation equipment or tool used onsite?', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'cvd_ex_equipment_tools_image', 'codedValues': [{'name': 'Yes', 'code': 'yes'}, {'name': 'No', 'code': 'no'}, {'name': 'Unknown', 'code': 'unknown'}]}, 'defaultValue': None}, {'name': 'ex_equip_tool_Model', 'type': 'esriFieldTypeString', 'alias': 'Provide the model number for machine excavation equipment.', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'ex_damage_yes_no', 'type': 'esriFieldTypeString', 'alias': 'Did the excavation cause damage to an underground facility?', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'cvd_ex_damage_yes_no', 'codedValues': [{'name': 'Yes', 'code': 'yes'}, {'name': 'No', 'code': 'no'}]}, 'defaultValue': None}, {'name': 'ex_damage_image', 'type': 'esriFieldTypeString', 'alias': 'Do you have a photo of the damaged underground facility?', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'cvd_ex_damage_image', 'codedValues': [{'name': 'Yes', 'code': 'yes'}, {'name': 'No', 'code': 'no'}]}, 'defaultValue': None}, {'name': 'ex_damage_product_release', 'type': 'esriFieldTypeString', 'alias': 'Did the damage cause a utility outage or interrupt utility service?', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'cvd_ex_damage_product_release', 'codedValues': [{'name': 'Yes', 'code': 'yes'}, {'name': 'No', 'code': 'no'}, {'name': 'Unknown', 'code': 'unknown'}]}, 'defaultValue': None}, {'name': 'ex_damage_expose_unknown', 'type': 'esriFieldTypeString', 'alias': 'Was the facility exposed at the time of the damage?', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'cvd_ex_damage_expose_unknown', 'codedValues': [{'name': 'Yes', 'code': 'yes'}, {'name': 'No', 'code': 'no'}, {'name': 'Unknown', 'code': 'unknown'}]}, 'defaultValue': None}, {'name': 'ex_handtool_damage', 'type': 'esriFieldTypeString', 'alias': 'Did the damage occur with hand tools?', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'cvd_ex_handtool_damage', 'codedValues': [{'name': 'Yes', 'code': 'yes'}, {'name': 'No', 'code': 'no'}]}, 'defaultValue': None}, {'name': 'ex_hand_tools', 'type': 'esriFieldTypeString', 'alias': 'Select hand tool type.', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'cvd_ex_hand_tools', 'codedValues': [{'name': 'Drill', 'code': 'drill'}, {'name': 'Hammer', 'code': 'hammer'}, {'name': 'Pick', 'code': 'pick'}, {'name': 'Saw', 'code': 'saw'}, {'name': 'Sawzall', 'code': 'sawzall'}, {'name': 'Shovel', 'code': 'shovel'}]}, 'defaultValue': None}, {'name': 'emergency_officials', 'type': 'esriFieldTypeString', 'alias': 'Were emergency public officials notified or present onsite?', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'cvd_emergency_officials', 'codedValues': [{'name': 'Yes', 'code': 'yes'}, {'name': 'No', 'code': 'no'}, {'name': 'Unknown', 'code': 'unknown'}]}, 'defaultValue': None}, {'name': 'emergency_public_officials', 'type': 'esriFieldTypeString', 'alias': 'Please provide responding agencies.', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'excavation_activities_sum', 'type': 'esriFieldTypeString', 'alias': 'Please share anything else about events or additional information that supports your complaint of an alleged violation.', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'facility_type', 'type': 'esriFieldTypeString', 'alias': 'What is the type of underground facility?', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'cvd_facility_type', 'codedValues': [{'name': 'Cable', 'code': 'cable'}, {'name': 'Electric', 'code': 'electric'}, {'name': 'Natural Gas', 'code': 'natural gas'}, {'name': 'Liquid Propane', 'code': 'liquid propane'}, {'name': 'Sewer', 'code': 'sewer'}, {'name': 'Steam', 'code': 'steam'}, {'name': 'Telecommunications', 'code': 'telecommunications'}, {'name': 'Water', 'code': 'water'}, {'name': 'Unknown / Other', 'code': 'unknown / other'}]}, 'defaultValue': None}, {'name': 'branch_type', 'type': 'esriFieldTypeString', 'alias': 'Which line type is the underground facility?', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'cvd_branch_type', 'codedValues': [{'name': 'Main', 'code': 'main'}, {'name': 'Service', 'code': 'service'}]}, 'defaultValue': None}, {'name': 'facility_size', 'type': 'esriFieldTypeString', 'alias': 'Is the width of the underground facility greater than 2 inches?', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': {'type': 'codedValue', 'name': 'cvd_facility_size', 'codedValues': [{'name': 'Yes', 'code': 'yes'}, {'name': 'No', 'code': 'no'}]}, 'defaultValue': None}, {'name': 'CreationDate', 'type': 'esriFieldTypeDate', 'alias': 'CreationDate', 'sqlType': 'sqlTypeOther', 'length': 8, 'nullable': True, 'editable': False, 'domain': None, 'defaultValue': None, 'precision': 1}, {'name': 'Creator', 'type': 'esriFieldTypeString', 'alias': 'Creator', 'sqlType': 'sqlTypeOther', 'length': 128, 'nullable': True, 'editable': False, 'domain': None, 'defaultValue': None}, {'name': 'EditDate', 'type': 'esriFieldTypeDate', 'alias': 'EditDate', 'sqlType': 'sqlTypeOther', 'length': 8, 'nullable': True, 'editable': False, 'domain': None, 'defaultValue': None, 'precision': 1}, {'name': 'Editor', 'type': 'esriFieldTypeString', 'alias': 'Editor', 'sqlType': 'sqlTypeOther', 'length': 128, 'nullable': True, 'editable': False, 'domain': None, 'defaultValue': None}, {'name': 'complaint_start', 'type': 'esriFieldTypeDate', 'alias': 'complaint_start', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'precision': 1}, {'name': 'complaint_submitted_end', 'type': 'esriFieldTypeDate', 'alias': 'complaint_submitted_end', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'precision': 1}]
[{'name': 'GlobalIDIndex', 'fields': 'globalid', 'isAscending': False, 'isUnique': True, 'description': 'GlobalID index', 'indexType': 'Attribute'}, {'name': 'user_470.service_c436a7cc027548cdb05a1dc068410fb6_FORM_10_Shape_sidx', 'fields': 'Shape', 'isAscending': False, 'isUnique': False, 'description': 'Shape Index', 'indexType': 'Spatial'}, {'name': 'PK__service___5242E63205238632', 'fields': 'objectid', 'isAscending': True, 'isUnique': True, 'description': 'clustered, unique, primary key', 'indexType': 'Attribute'}, {'name': 'CreationDateIndex', 'fields': 'CreationDate', 'isAscending': True, 'isUnique': False, 'description': 'CreationDate Field index', 'indexType': 'Attribute'}, {'name': 'CreatorIndex', 'fields': 'Creator', 'isAscending': False, 'isUnique': False, 'description': 'Creator Field index', 'indexType': 'Attribute'}, {'name': 'EditDateIndex', 'fields': 'EditDate', 'isAscending': True, 'isUnique': False, 'description': 'EditDate Field index', 'indexType': 'Attribute'}, {'name': 'EditorIndex', 'fields': 'Editor', 'isAscending': False, 'isUnique': False, 'description': 'Editor Field index', 'indexType': 'Attribute'}]
nan
{'labelingInfo': None, '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}
[]
[{'name': 'New Feature', 'description': '', 'drawingTool': 'esriFeatureEditToolPoint', 'prototype': {'attributes': {'complaint_note': None, 'contact_note1': None, 'complianant_information': None, 'stakeholder_id': None, 'complianant_first_name': None, 'complainant_last_name': None, 'complainant_org': None, 'complainant_address': None, 'complainant_city': None, 'complainant_zip': None, 'complainant_phone': None, 'complainant_email': None, 'alternative_contact_yes_no': None, 'alternative_contact': None, 'alt_contact_muni': None, 'alternative_contact1': None, 'contact_note2': None, 'Stakeholder_Defendant_Offender': None, 'mulitple_utility_stakehholder_utility': None, 'mulitple_utility_stakehholder_muni1': None, 'mult_utility1': None, 'mult_muni': None, 'defendant_last_name': None, 'defendant_first_name': None, 'defendant_organization_company': None, 'defendant_address_address': None, 'defendant_city_city': None, 'defendant_zip_zip': None, 'defendant_phone': None, 'defendant_email_email': None, 'stakeholder_lic_number': None, 'lic_type': None, 'stakeholder_lic_text': None, 'stakeholder_lic_digit': None, 'general_sub': None, 'sub_verification': None, 'notification_locatingmarking_excavation_issue': None, 'complaint_category': None, 'too_many_catergory': None, 'many_catergory_discription': None, 'notification_practices': None, 'Insuf_one_call_notice_number': None, 'LocatingMarkingServices': None, 'OR_locating_Marking_Issue': None, 'insuf_excav_practices': None, 'OR_one_call_refer_number': None, 'complaint_discription': None, 'unable_to_locate': None, 'Q1_locate_image': None, 'Q2_locate_image': None, 'unable_to_locate_sum': None, 'mark_not_suff_description': None, 'Q1_locating_marking_image': None, 'mark_not_suff_description_sum': None, 'no_loc_mark': None, 'Q1_no_locating_marking': None, 'Q2_no_locating_marking': None, 'no_loc_marking_sum': None, 'ill_map_records': None, 'ill_map_records_sum': None, 'excavation_verification_yes_no': None, 'Excavation_dateTime': None, 'Excavation_begin_when': None, 'ExcavationYes_dateTime': None, 'ExcavationYes_date': None, 'Project_Type_of_Work': None, 'Emergency_Excavation': None, 'Emergency_Classification': None, 'Q_ex_overall_image': None, 'markings_aboveground_facility': None, 'markings_aboveground_facilities': None, 'ex_equipment_tools': None, 'ex_equipment_tools_image': None, 'ex_equip_tool_Model': None, 'ex_damage_yes_no': None, 'ex_damage_image': None, 'ex_damage_product_release': None, 'ex_damage_expose_unknown': None, 'ex_handtool_damage': None, 'ex_hand_tools': None, 'emergency_officials': None, 'emergency_public_officials': None, 'excavation_activities_sum': None, 'facility_type': None, 'branch_type': None, 'facility_size': None}}}]