Layers:

Layer: BES_Incident_Report (0)


Name: BES_Incident_Report

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

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:

XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326 (4326)


Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"BES Incident Report","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:

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)
• title_note (type: esriFieldTypeString, alias: Use this form to submit information about Health Safety Security Environmental (HSSE) incidents while working for the City of Portland. If you have an immediate life-safety emergency, call 911., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• reporttype (type: esriFieldTypeString, alias: What type of report would you like to submit?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [SafetyReport: Safety Incident Report], [AnonymousReport: Anonymous Safety Report])
• submitter_name (type: esriFieldTypeString, alias: Name of person reporting the situation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• involved_question (type: esriFieldTypeString, alias: Were you the person involved in the incident?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• involved_name (type: esriFieldTypeString, alias: Provide the name of person involved in the incident, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• submitter_email (type: esriFieldTypeString, alias: Please provide your work email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• report_type (type: esriFieldTypeString, alias: Choose type of situation to report, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [hazard: Hazard], [near_miss: Near Miss], [Incident: Incident])
• report_title (type: esriFieldTypeString, alias: Situation Title, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• report_description (type: esriFieldTypeString, alias: Situation Description, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• report_date_identified (type: esriFieldTypeDate, alias: Date Identified, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• report_date_reported (type: esriFieldTypeDate, alias: Date Reported, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• supervisor_notified (type: esriFieldTypeString, alias: Has your Supervisor been notified?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• supervisor_name (type: esriFieldTypeString, alias: Supervisor's name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• facility_location (type: esriFieldTypeString, alias: Facility Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [CBWTP: Columbia Boulevard Waste Treatment Plant], [TCWTP: Tyron Creek Waste Treatment Plant], [WPCL: Water Pollution Control Lab], ... 8 more ...)
• location_contractor (type: esriFieldTypeString, alias: Contractors, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• location_desc (type: esriFieldTypeString, alias: Detailed Facility Location Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• address (type: esriFieldTypeString, alias: Facility Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• facility_tpb_floor (type: esriFieldTypeString, alias: Portland Building Floor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 13 more ...)
• hazard_outcome (type: esriFieldTypeString, alias: What is the potential outcome if not addressed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Environmental_Release: Environmental Release], [Fire_Explosion: Fire/Explosion], [Injury_Illness: Injury/Illness], ... 5 more ...)
• hazard_outcome_other (type: esriFieldTypeString, alias: Other outcome description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• hazard_securityreporting_url (type: esriFieldTypeString, alias: Please fill out a Security Incident Report (click link below), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• hazard_sub (type: esriFieldTypeString, alias: Hazard Sub Category, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Slip_Trip_Fall: Slip Trip Fall], [Struck_By: Struck By], [Pinch_Point: Caught in Between/ Pinch Point], ... 5 more ...)
• hazard_sub_other (type: esriFieldTypeString, alias: Sub Categary Other description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• hazard_corrected (type: esriFieldTypeString, alias: Has Hazard been corrected?, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• hazard_corrected_action (type: esriFieldTypeString, alias: What was the corrective action?, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• hazard_suggestion (type: esriFieldTypeString, alias: What do you suggest as a corrective action?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• nearmiss_outcome (type: esriFieldTypeString, alias: what is the potential outcome if not addressed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Environmental_Release: Environmental Release], [Fire_Explosion: Fire/Explosion], [Injury_Illness: Injury/Illness], ... 5 more ...)
• nm_sub (type: esriFieldTypeString, alias: Injury Category, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Slip_Trip_Fall: Slip Trip Fall], [Struck_By: Struck By], [Pinch_Point: Caught in Between/ Pinch Point], ... 5 more ...)
• nm_ii_type (type: esriFieldTypeString, alias: Injury/Illness Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Laceration_Contusion: Laceration/Contusion], [Fractures: Fractures], [Amputation: Amputation], ... 6 more ...)
• nm_oii_other_injury (type: esriFieldTypeString, alias: Other Injury Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• nm_oii_body_part (type: esriFieldTypeString, alias: Injured Body Part, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [neck: Neck], [head: Head], [back: Back], ... 8 more ...)
• nm_oii_body_part_Other (type: esriFieldTypeString, alias: Other Body Part Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• nm_oii_body_side (type: esriFieldTypeString, alias: Side of body, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [right: Right], [left: Left])
• nm_oii_treatment_description (type: esriFieldTypeString, alias: Describe Medical Treatment (if any), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• nm_oii_workers_comp (type: esriFieldTypeString, alias: Injury Reported to workers Compensation Group?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• nm_oii_packet_801 (type: esriFieldTypeString, alias: Please fill out the Injured worker Packet 801 (click link below), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• nearmiss_outcome_other (type: esriFieldTypeString, alias: Other outcome description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• nearmiss_securityreporting_url (type: esriFieldTypeString, alias: Please fill out a Security Incident Report (click link below), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• nearmiss_sub (type: esriFieldTypeString, alias: Near Miss Sub Category, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Slip_Trip_Fall: Slip Trip Fall], [Struck_By: Struck By], [Pinch_Point: Caught in Between/ Pinch Point], ... 5 more ...)
• nearmiss_sub_other (type: esriFieldTypeString, alias: Sub Categary Other description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• nearmiss_witness (type: esriFieldTypeString, alias: Name of witnesses (If Any), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• nearmiss_corrected (type: esriFieldTypeString, alias: Has Hazard been corrected?, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• nearmiss_corrected_action (type: esriFieldTypeString, alias: What was the corrective action?, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• nearmiss_suggestion (type: esriFieldTypeString, alias: What do you suggest as a corrective action?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• incident_outcome (type: esriFieldTypeString, alias: What is the potential outcome if not addressed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Environmental_Release: Environmental Release], [Fire_Explosion: Fire/Explosion], [Injury_Illness: Injury/Illness], ... 5 more ...)
• oer_mat_name (type: esriFieldTypeString, alias: Material/Chemical Name:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• oer_cas (type: esriFieldTypeString, alias: CAS# if applicable, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• oer_hazard (type: esriFieldTypeString, alias: Hazard Classification, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• oer_chem_quantity (type: esriFieldTypeString, alias: Quantity of Chemical Released, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• oer_wind (type: esriFieldTypeString, alias: Wind Direction, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [north: North], [northeast: Northeast], [northwest: Northwest], ... 5 more ...)
• oer_weather (type: esriFieldTypeString, alias: Weather, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Sunny: Sunny], [Partly Sunny: Partly Sunny], [Cloudy: Cloudy], ... 6 more ...)
• oer_container_type (type: esriFieldTypeString, alias: Released from container type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [pipe: Pipe], [bulk tank: Bulk tank], [ibc: IBC - Tote Bin], ... 3 more ...)
• oer_released_to (type: esriFieldTypeString, alias: Released to, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [air: Air], [water: Water], [ground: Ground], ... 3 more ...)
• oer_contain_time (type: esriFieldTypeString, alias: Time to Contain, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ofe_wind (type: esriFieldTypeString, alias: Wind Direction, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [north: North], [northeast: Northeast], [northwest: Northwest], ... 5 more ...)
• ofe_weather (type: esriFieldTypeString, alias: Weather, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Sunny: Sunny], [Partly Sunny: Partly Sunny], [Cloudy: Cloudy], ... 6 more ...)
• ofe_origin (type: esriFieldTypeString, alias: Fire/Explosion Origin, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ofe_condition (type: esriFieldTypeString, alias: Igniting Object/condition, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ofe_evacuation (type: esriFieldTypeString, alias: Evacuation Needed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• ofe_response_desc (type: esriFieldTypeString, alias: Response Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Incident_sub (type: esriFieldTypeString, alias: Injury Category, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Slip_Trip_Fall: Slip Trip Fall], [Struck_By: Struck By], [Pinch_Point: Caught in Between/ Pinch Point], ... 5 more ...)
• oii_other (type: esriFieldTypeString, alias: Other Incident Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• oii_type (type: esriFieldTypeString, alias: Injury/Illness Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Laceration_Contusion: Laceration/Contusion], [Fractures: Fractures], [Amputation: Amputation], ... 6 more ...)
• oii_other_injury (type: esriFieldTypeString, alias: Other Injury Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• oii_body_part (type: esriFieldTypeString, alias: Injured Body Part, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [neck: Neck], [head: Head], [back: Back], ... 8 more ...)
• oii_body_part_Other (type: esriFieldTypeString, alias: Other Body Part Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• oii_body_side (type: esriFieldTypeString, alias: Side of body, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [right: Right], [left: Left])
• oii_treatment_description (type: esriFieldTypeString, alias: Describe Medical Treatment (if any), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• oii_workers_comp (type: esriFieldTypeString, alias: Injury Reported to workers Compensation Group?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• oii_packet_801 (type: esriFieldTypeString, alias: Please fill out the Injured worker Packet 801 (click link below), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• opd_type (type: esriFieldTypeString, alias: Type of Property Damaged, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• opd_description (type: esriFieldTypeString, alias: Description of Damage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• opd_cause (type: esriFieldTypeString, alias: Cause of Damage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• opd_service_removal (type: esriFieldTypeString, alias: Removed from service?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [na: N/A])
• opd_work_Order (type: esriFieldTypeString, alias: Work Order Created?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [na: N/A])
• opd_barricade (type: esriFieldTypeString, alias: Area barricade and tagged?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [na: N/A])
• oef_type (type: esriFieldTypeString, alias: Type of Equipment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• oef_asset_number (type: esriFieldTypeString, alias: Asset Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• oef_decscription (type: esriFieldTypeString, alias: Description of Failure, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• oef_cause (type: esriFieldTypeString, alias: Cause of Failure, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• oef_service_removal (type: esriFieldTypeString, alias: Removed from service?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [na: N/A])
• oef_work_Order (type: esriFieldTypeString, alias: Work Order Created?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [na: N/A])
• oef_barricade (type: esriFieldTypeString, alias: Area barricade and tagged?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [na: N/A])
• ova_type (type: esriFieldTypeString, alias: City or Personal Vehicle?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [city: City], [personal: Personal])
• ova_speed (type: esriFieldTypeInteger, alias: Vehicle Speed at the time of the incident:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ova_police (type: esriFieldTypeString, alias: Police at the scene?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [na: N/A])
• ova_traffic_control (type: esriFieldTypeString, alias: Traffic Controls present?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• ova_vehicle_type (type: esriFieldTypeString, alias: Type of Vehicle, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ova_other_driver (type: esriFieldTypeString, alias: Other Driver involved?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• ova_passengers (type: esriFieldTypeString, alias: Passengers in Car?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• ova_vehicle_make_model (type: esriFieldTypeString, alias: Vehicle Make and Model, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ova_license (type: esriFieldTypeString, alias: Vehicle License Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ova_liability_claim (type: esriFieldTypeString, alias: Evidence Envelope submitted to Risk Management Liability Claims?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• ova_accident_reporting_form (type: esriFieldTypeString, alias: Please fill out the vehicle accident reporting form. (click link below), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• incident_securityreporting_url (type: esriFieldTypeString, alias: Please fill out a Security Incident Report (click link below), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• o_other (type: esriFieldTypeString, alias: Other incident description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• incident_corrected (type: esriFieldTypeString, alias: Has Hazard been corrected?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• incident_corrected_action (type: esriFieldTypeString, alias: What was the corrective action?, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• incident_suggestion (type: esriFieldTypeString, alias: What do you suggest as a corrective action?, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• incident_911 (type: esriFieldTypeString, alias: Was 911 called?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• anonSafetyConcern (type: esriFieldTypeString, alias: What is your Safety Concern?, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• anonLeadHelp (type: esriFieldTypeString, alias: How can HSSE or BES leadership help with this safety concern?, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• anonAddInfo (type: esriFieldTypeString, alias: Is there any additional information that could help HSSE investigate this safety issue?, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• anonAnonymous (type: esriFieldTypeString, alias: Do you wish to remain Anonymous?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• anonName (type: esriFieldTypeString, alias: What's your name?, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• anonEmail (type: esriFieldTypeString, alias: What's your email address?, SQL Type: sqlTypeOther, length: 50, 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)
• hazard_suggestion_new (type: esriFieldTypeString, alias: What do you suggest as a corrective action?, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• nearmiss_suggestion_new (type: esriFieldTypeString, alias: What do you suggest as a corrective action?, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• incident_suggestion_new (type: esriFieldTypeString, alias: What do you suggest as a corrective action?, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:


Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/13/2025 7:08:45 PM

Schema Last Edit Date: 3/13/2025 7:08:35 PM

Data Last Edit Date: 3/13/2025 7:08:45 PM