Layers:

Layer: ParksNearMissReport (0)


Name: ParksNearMissReport

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

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":"Parks Near Miss 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)
• facility_abbrev (type: esriFieldTypeString, alias: facility_abbrev, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• id_datetime (type: esriFieldTypeString, alias: id_datetime, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• facility_friendly_name (type: esriFieldTypeString, alias: facility_friendly_name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• region_friendly_name (type: esriFieldTypeString, alias: region_friendly_name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• hidden_extra_1 (type: esriFieldTypeString, alias: hidden_extra_1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• hidden_extra_2 (type: esriFieldTypeString, alias: hidden_extra_2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• hidden_extra_3 (type: esriFieldTypeString, alias: hidden_extra_3, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• hidden_extra_4 (type: esriFieldTypeString, alias: hidden_extra_4, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• report_id (type: esriFieldTypeString, alias: Near Miss Report ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• region (type: esriFieldTypeString, alias: Region, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [02: Allegany], [05: Central], [04: Finger Lakes], ... 8 more ...)
• facility (type: esriFieldTypeString, alias: Facility, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• nearmiss_datetime (type: esriFieldTypeDate, alias: Near Miss Date and Time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• NearMiss_date_year (type: esriFieldTypeString, alias: NearMiss_date_year, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• NearMiss_date_month_name (type: esriFieldTypeString, alias: NearMiss_date_month_name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• NearMiss_date_day_name (type: esriFieldTypeString, alias: NearMiss_date_day_name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• nearmiss_time_24hour (type: esriFieldTypeInteger, alias: nearmiss_time_24hour, SQL Type: sqlTypeOther, nullable: true, editable: true)
• property_info_present (type: esriFieldTypeString, alias: Is there any property associated with this near miss?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• repair_needed (type: esriFieldTypeString, alias: Is there a need for a maintenance work order because of this near miss?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• repair_description (type: esriFieldTypeString, alias: Repair description, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• repair_contact_name (type: esriFieldTypeString, alias: Name of point of contact, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• repair_contact_phone (type: esriFieldTypeString, alias: Phone number of point of contact, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• location_type (type: esriFieldTypeString, alias: Type of location where the near miss occurred?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Area closed to public: Area closed to public], [Ballfields: Ballfields (soccer, softball, basketball etc.)], [Bathroom: Bathroom], ... 22 more ...)
• location_description (type: esriFieldTypeString, alias: Area name or description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• nearmiss_narrative (type: esriFieldTypeString, alias: Narrative, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• nearmiss_status (type: esriFieldTypeString, alias: NearMiss Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Open: Open], [Closed: Closed])
• nearmiss_turned_over_to (type: esriFieldTypeString, alias: Turned Over To:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Park Police: Park Police], [Park Manager: Park Manager], [Park Ranger 2: Park Ranger 2], ... 4 more ...)
• reporter_name (type: esriFieldTypeString, alias: Report Completed By:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• reporter_title (type: esriFieldTypeString, alias: Title, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• reporter_date (type: esriFieldTypeDate, alias: Date Report Completed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• submission_code (type: esriFieldTypeString, alias: Submission Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• report_approval (type: esriFieldTypeString, alias: Approval, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Not Approved: Not Approved], [Approved: Approved])
• reviewer_name (type: esriFieldTypeString, alias: Report Reviewed By:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• reviewer_title (type: esriFieldTypeString, alias: Title, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• reviewer_date (type: esriFieldTypeDate, alias: Date, SQL Type: sqlTypeOther, length: 255, 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)
• supervisor_comments (type: esriFieldTypeString, alias: Supervisor Comments, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• type (type: esriFieldTypeString, alias: Type of Near Miss, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [nearmiss: Near-Miss], [safetyconcern: Safety Concern], [safetyidea: Safety Idea/Suggestion], ... 1 more ...)
• type_other (type: esriFieldTypeString, alias: Other (Type of Near Miss), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• concern (type: esriFieldTypeString, alias: Type of Concern:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [unsafeact: Unsafe Act], [unsafearea: Unsafe Condition of Area], [unsafeequip: Unsafe Condition of Equipment], ... 3 more ...)
• concern_other (type: esriFieldTypeString, alias: Other Concern, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• nm_witnesses (type: esriFieldTypeString, alias: Witnesses, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• safety_violation (type: esriFieldTypeString, alias: Were any safety procedures violated?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• safety_comment (type: esriFieldTypeString, alias: If yes, please describe, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• inspection (type: esriFieldTypeString, alias: Incident Site Inspection:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• recommendation (type: esriFieldTypeString, alias: Recommendations/steps to take to prevent a similar incident:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• name (type: esriFieldTypeString, alias: Name (optional):, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• date_reported (type: esriFieldTypeDate, alias: Date Reported:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• action_taken (type: esriFieldTypeString, alias: Action Taken:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• report_status (type: esriFieldTypeString, alias: NearMiss Report Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Open: Open], [Closed: Closed])
• status (type: esriFieldTypeString, alias: Near Miss Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Substantiated: Substantiated], [Unsubstantiated: Unsubstantiated])
• response_date (type: esriFieldTypeDate, alias: Date of Response, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RSM (type: esriFieldTypeString, alias: Name of RSM, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• chainsaw (type: esriFieldTypeString, alias: Is this report required by OPRHP’s Chainsaw Safety Program?, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)

Templates:

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


Relationships:
• Form_3_missing_areas_searched (1) -- Related To: missing_areas_searched (1)
• Form_3_witness (2) -- Related To: witness (2)
• Form_3_property_items (3) -- Related To: property_items (3)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/13/2026 4:06:53 PM

Schema Last Edit Date: 7/1/2026 8:34:43 PM

Data Last Edit Date: 8/13/2026 4:06:53 PM

Tables:

missing_areas_searched (1)


Name: missing_areas_searched

Display Field: objectid

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

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)
• missing_search_area (type: esriFieldTypeString, alias: Area Searched, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• missing_search_time (type: esriFieldTypeString, alias: Time Searched, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• witness_search_name (type: esriFieldTypeString, alias: Searched By, 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_missing_areas_searched (1) -- Related To: ParksNearMissReport (0)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/13/2026 4:06:53 PM

Schema Last Edit Date: 7/1/2026 8:34:43 PM

Data Last Edit Date: 8/13/2026 4:06:53 PM

witness (2)


Name: witness

Display Field: objectid

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

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)
• witness_name (type: esriFieldTypeString, alias: Witness Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• witness_address (type: esriFieldTypeString, alias: Witness Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• witness_phone (type: esriFieldTypeString, alias: Witness Phone Number, 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_witness (2) -- Related To: ParksNearMissReport (0)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/13/2026 4:06:53 PM

Schema Last Edit Date: 7/1/2026 8:34:43 PM

Data Last Edit Date: 8/13/2026 4:06:53 PM

property_items (3)


Name: property_items

Display Field: objectid

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

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)
• property_item_status (type: esriFieldTypeString, alias: Property Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Burned: Burned], [Counterfeited_Forged: Counterfeited/Forged], [Destroyed_Damaged_Vandalized: Destroyed/Damaged/Vandalized], ... 7 more ...)
• property_item_status_other (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• property_item_type (type: esriFieldTypeString, alias: Property Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Money: Money], [Credit_Debit Card: Credit/Debit Card], [Negotiable_Instruments: Negotiable Instruments], ... 41 more ...)
• property_item_type_other (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• property_item_make_model (type: esriFieldTypeString, alias: Make and\or Model, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• property_item_description (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• property_item_value (type: esriFieldTypeString, alias: Value, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• property_item_vehicle_plate (type: esriFieldTypeString, alias: License Plate Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• property_item_vehicle_state (type: esriFieldTypeString, alias: License Plate State, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• property_item_vehicle_color (type: esriFieldTypeString, alias: Vehicle Color, 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_property_items (3) -- Related To: ParksNearMissReport (0)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/13/2026 4:06:53 PM

Schema Last Edit Date: 7/1/2026 8:34:43 PM

Data Last Edit Date: 8/13/2026 4:06:53 PM