Layer: BES_Incident_Report (ID:0)

View In: Map Viewer

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:

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:

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:

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

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