Name: Issues

Display Field: objectid

Type: Table

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: objectid

Unique ID Field:

Name : objectid

IsSystemMaintained : True

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)
• multi_issue_note (type: esriFieldTypeString, alias: If your complaint involves more than one root issue for the location, please use the plus "+" button and enter additional information. , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• complaint_category (type: esriFieldTypeString, alias: Complaints about damage prevention activities generally fall into one of the following root categories and issues. Please select a root issue that best fits the reason for your complaint. Thank you., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [no_locate_request: No Locate Request], [excavation_practices: Excavation Practices], [invaild_request_use: Invalid Use of Locate Request by Excavator], ... 1 more ...)
• no_811_reason (type: esriFieldTypeString, alias: To better understand more about "No Locate Request," was there was an apparent reason why this occurred? Please select the appropriate "known" reason below. If information is not available, please select "unknown/data not collected.", SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [unaware_of_811: Unaware of one-call center/811 notification], [thought_exempt: Thought they were exempt from rules], [thought_only_4_Pro Ex: Thought it only applied to professional excavators], ... 6 more ...)
• ex_practices (type: esriFieldTypeString, alias: Excavation practices captures issues where something went wrong in the physical digging process. Please select the appropriate root issue below. If information is not available, please select "unknown/data not collected.", SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [ex_clearance: Excavator failed to maintain clearance after verifying marks], [ex_no_potholing: Excavator dug prior to verifying marks by potholing], [ex_failure_support: Excavator failed to shore/support facilities after exposure], ... 3 more ...)
• invalid_811_use (type: esriFieldTypeString, alias: Invalid use of request by excavator is generally a misuse of the notification process or timeliness. Please select the appropriate root issue below. If information is not available, please select "unknown/data not collected.", SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [dug_prior: Excavator dug prior to valid date/start], [dug_after: Excavator dug after valid ticket expired], [dug_outside_area: Excavator dug outside the area described/outlined in the notification], ... 2 more ...)
• locate_pract (type: esriFieldTypeString, alias: For locating and marking practices, please select the appropriate root issue below. If information is not available, select "unknown/data not collected.", SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [mark_inaccur: Facility marked inaccurately due to locator error], [marked_inaccur_bad_map: Facility marked inaccurately due to inaccurate facility map/record], [marked_inaccur_tracer_issue: Facility marked inaccurately due to tracer wire issue], ... 8 more ...)
• Q_ticket_number (type: esriFieldTypeString, alias: Do you know the ticket number issued by Oregon's 811 one-call center?Visit the Oregon One-Call Center: https://or.itic.occinc.com/ and search for ticket numbers. Registering is not required to search for ticket number., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
• ticket_number (type: esriFieldTypeString, alias: Please provide the Oregon One-Call ticket number., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• facility_type (type: esriFieldTypeString, alias: What type of underground facility is involved with your root concern?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [cable: Cable], [electric: Electric], [naturalgas: 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], [primary: Primary], [secondary: Secondary], ... 2 more ...)
• 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], [unknown: Unknown])
• gas_pressure (type: esriFieldTypeString, alias: Please provide operating pressure., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• insuf_ex_practices (type: esriFieldTypeString, alias: Please describe the job/project and how damage prevention practices were inadequate as it relates to the root issue you identified., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• loc_practice_description (type: esriFieldTypeString, alias: Please describe how or why locating and marking services were inadequate as it relates to the root issue you identified., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• photo_Loc_gen (type: esriFieldTypeString, alias: Photos and documents are useful when investigating inaccurate locating and marking services provided by a Utility. You can attach photos to this complaint that supports your root issue.Do you have documentation to attach with this complaint?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• Pho_inn_note (type: esriFieldTypeString, alias: Please provide photo(s) showing inaccurate locating and marking for the location. This should illustrate marking distance of from the actual location of underground facility., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• photo_Loc_gen_2 (type: esriFieldTypeString, alias: Photos and documents are useful to demonstrate insufficient locating and marking services provided by a Utility. You can attach photos to this complaint that supports your root issue.Do you have documentation to attach with this complaint?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• Pho_no_note (type: esriFieldTypeString, alias: Please provide photo(s) of facilities without locating and marking. Photo(s) should illustrate the area or specific facilities that were not located and marked., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Loc_activiity_summary (type: esriFieldTypeString, alias: Do you have other information to share about this root issue for the investigation? If so, please provide it below., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Ex_verif_note (type: esriFieldTypeString, alias: Verification of Excavation Activities, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• excavation_verif_1 (type: esriFieldTypeString, alias: Notification to Oregon's one call/811 center is required for proposed excavations. Are you able to verify whether excavation took place? Additional information is needed for an investigation., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• Project_Type_of_Work (type: esriFieldTypeString, alias: What type of work was being done when proposed or actual 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 ...)
• excavation_know (type: esriFieldTypeString, alias: When did you discover or have knowledge of excavation taking place?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes_date_time: I know the date and time], [no: Unsure], [yes_date_not_time: I know the date but not the time])
• excavation_know_yes_date_time (type: esriFieldTypeDate, alias: Please provide date and time., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• excavation_know_yes_date (type: esriFieldTypeDate, alias: Please provide the date., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• excavation_began (type: esriFieldTypeString, alias: Do you know approximately when excavation activity started for the project?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes_date_time: I know the date and time], [no: Unsure], [yes_date_not_time: I know the date but not the time])
• excavation_yes_date_time (type: esriFieldTypeDate, alias: Please provide date and time., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• excavation_yes_date (type: esriFieldTypeDate, alias: Please provide the date., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ex_overall_image (type: esriFieldTypeString, alias: Do you have photos of the general area where excavation occurred? It would be helpful to see the overall location/site where excavation took place., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• Q_mark_aboveground_facility (type: esriFieldTypeString, alias: In the area of excavation or proposed excavation, are there any aboveground markers, utility facilities, vault lids, meters, service drops, conduits, visible or faint paint markings that would indicate presence of an underground facility?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• within_24_inches (type: esriFieldTypeString, alias: Are there any underground facilities within 24 inches of the immediate area of excavation or proposed excavation? If so, photos with measurements for reference is helpful. Thank you., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• 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 ...)
• Q_ex_equipment_tools (type: esriFieldTypeString, alias: Do you have photos of the excavation equipment or tools used at the location onsite?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• ex_damage_occur (type: esriFieldTypeString, alias: Did excavation cause damage to an underground facility? Please provide photos., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
• Pot_hole (type: esriFieldTypeString, alias: Was the exact location of the underground facility determined by the excavator?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
• potholed_description (type: esriFieldTypeString, alias: Describe the insufficient method used to determine the exact location of the underground facility. If the facility was not potholed, provide description and known reason why., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• utility_expose (type: esriFieldTypeString, alias: Was the facility exposed and visible 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], [unknown: Unknown])
• 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)
• outage_interuption_leak (type: esriFieldTypeString, alias: Did the damage cause an outage, product release or service interruption?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• outage_interuption_leak_info (type: esriFieldTypeString, alias: Please describe the impact of the damage., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Ex_activities_sum (type: esriFieldTypeString, alias: Do you have other information to share about this root issue for the investigation? If so, please provide it below., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: true, editable: true)
• 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)

Relationships:

• Form_3_Issues (2) -- Related To: Form_3 (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/29/2022 6:10:58 PM

Schema Last Edit Date: 12/29/2022 6:10:58 PM

Data Last Edit Date: 12/29/2022 6:10:58 PM

Supported Operations:   Add Features   Apply Edits   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat