Name: Wisconsin_Collection_Results_Join

Display Field:

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: false

Source Schema Changes Allowed: false

Sources

Description: AttributeJoin

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: -166.106983302317
YMin: -6.13728012274539
XMax: 106.872092137438
YMax: 66.9035414917036
Spatial Reference: 4326 (4326)

Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"Fire Fatality Data Collector v3","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:

• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• pic (type: esriFieldTypeString, alias: pic, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• location_date (type: esriFieldTypeString, alias: Location & Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• test_data (type: esriFieldTypeString, alias: Please indicate whether this data is for testing purposes, or if it contains real-world fire incident data., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [test: Test Data], [real: Real-World Data])
• incident_date (type: esriFieldTypeDate, alias: Incident Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• city (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• county (type: esriFieldTypeString, alias: County:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• state_abbr (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• address (type: esriFieldTypeString, alias: Incident Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• x (type: esriFieldTypeDouble, alias: X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• y (type: esriFieldTypeDouble, alias: Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• area_description (type: esriFieldTypeString, alias: Area Description:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• weather (type: esriFieldTypeString, alias: Weather, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• temperature (type: esriFieldTypeInteger, alias: Temperature:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• wind (type: esriFieldTypeString, alias: Wind Speed:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [calm_<1_mph_: Calm (<1 mph)], [light_breeze_1_7_mph_: Light Breeze (1-7 mph)], [moderate_breeze_8_18_mph_: Moderate Breeze (8-18 mph)], ... 4 more ...)
• direction (type: esriFieldTypeString, alias: Wind Direction:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [north: North], [northeast: Northeast], [east: East], ... 5 more ...)
• weather_conditions (type: esriFieldTypeString, alias: Weather Conditions:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• basic_fire_information (type: esriFieldTypeString, alias: Basic Fire Information, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_of_fatalities (type: esriFieldTypeInteger, alias: Number of Fatalities:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• primary_responding_fire_departm (type: esriFieldTypeString, alias: Primary Responding Fire Department:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fire_department_id (type: esriFieldTypeString, alias: Fire Department ID:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fire_fatality_id (type: esriFieldTypeString, alias: Fire Fatality ID:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• type_of_fire_ (type: esriFieldTypeString, alias: Type of Fire:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [structure_fire: Structure Fire], [vehicle_fire: Vehicle Fire], [open_area_wildland_fire: Open Area/ Wildland Fire])
• structure_information (type: esriFieldTypeString, alias: Structure Information:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_of_buildings_involved (type: esriFieldTypeDouble, alias: Number of Buildings Involved:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ibc_construction_type (type: esriFieldTypeString, alias: IBC Construction Type:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [type_1:_fire_resistive: Type 1: Fire-resistive], [type_2:_non_combustible: Type 2: Non-combustible], [type_3:_ordinary: Type 3: Ordinary], ... 2 more ...)
• occupancy_category (type: esriFieldTypeString, alias: Occupancy Category:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [residential: Residential], [private_commercial_or_industria: Private commercial or industrial], [public_area: Public area], ... 2 more ...)
• occupancy_category_other (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• occupancy_type (type: esriFieldTypeString, alias: Occupancy Type:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [single_family_dwelling: Single-Family Dwelling], [multi_family_dwelling: Multi-Family Dwelling], [apartment: Apartment], ... 10 more ...)
• occupancy_type_other (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• was_the_structure_owner_occupie (type: esriFieldTypeString, alias: Was the structure owner-occupied?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [n_a_unoccupied: N/A - Unoccupied], ... 1 more ...)
• property_assessor_information (type: esriFieldTypeString, alias: Property Assessor Information, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• structure_size_ (type: esriFieldTypeDouble, alias: Structure Size:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• year_built (type: esriFieldTypeDouble, alias: Year Built:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• structure_age (type: esriFieldTypeDouble, alias: Structure Age:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• room_of_origin (type: esriFieldTypeString, alias: Room of Origin:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• alarm_automatic_suppression_sys (type: esriFieldTypeString, alias: Alarm & Suppression System Presence, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• were_smoke_alarms_present (type: esriFieldTypeString, alias: Were Smoke Alarms Present?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [n_a: N/A], ... 1 more ...)
• number_of_alarms_present (type: esriFieldTypeDouble, alias: Number of Alarms Present:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• did_smoke_alarms_alert_the_occu (type: esriFieldTypeString, alias: Did Smoke Alarms Alert the Occupants?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [n_a: N/A], ... 1 more ...)
• did_fire_crews_hear_alarms (type: esriFieldTypeString, alias: Did Fire Crews Hear Alarms?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• were_sprinklers_or_other_automa (type: esriFieldTypeString, alias: Were Sprinklers or Other Automatic Suppression Systems Present?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [n_a: N/A], ... 1 more ...)
• did_the_sprinkler_system_activa (type: esriFieldTypeString, alias: Did the Sprinkler System Activate and Operate Effectively?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• did_an_occupant_use_a_fire_exti (type: esriFieldTypeString, alias: Did an Occupant Use a Fire Extinguisher in an Attempt to Extinguish the Fire?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• codes_enforcement (type: esriFieldTypeString, alias: Codes Enforcement, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• does_the_local_ahj_have_an_adop (type: esriFieldTypeString, alias: Does the Local AHJ have an Adopted Residential Building Code?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [n_a: N/A], ... 1 more ...)
• which_code_is_adopted (type: esriFieldTypeString, alias: Which Code is Adopted?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• other_structure_information (type: esriFieldTypeString, alias: Other Structure Information, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• was_hoarding_a_factor (type: esriFieldTypeString, alias: Was Hoarding a Factor?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• was_medical_oxygen_present (type: esriFieldTypeString, alias: Was Medical Oxygen Present?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• what_is_the_fire_departments_wa (type: esriFieldTypeString, alias: What is the Fire Department's Water Source for Structure Fires?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [municipal_water_source: Municipal water source], [well_water_municipal_water_unav: Well water, municipal water unavailable], [well_water_municipal_water_avai: Well water, municipal water available], ... 2 more ...)
• what_was_the_extent_of_the_fire (type: esriFieldTypeString, alias: What was the Extent of the Fire Damage?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• vehicle_information (type: esriFieldTypeString, alias: Vehicle Information, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• vehicle_type (type: esriFieldTypeString, alias: Vehicle Type:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• vehicle_make (type: esriFieldTypeString, alias: Vehicle Make:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• vehicle_model (type: esriFieldTypeString, alias: Vehicle Model:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• vehicle_year (type: esriFieldTypeDouble, alias: Vehicle Year:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• vehicle_usage (type: esriFieldTypeString, alias: Vehicle Usage:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [daily_travel: Daily travel], [long_distance_travel: Long-distance travel], [hauling_non_combustible_materia: Hauling non-combustible materials], ... 5 more ...)
• vehicle_usage_other (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• vehicle_condition_before_the_fi (type: esriFieldTypeString, alias: Vehicle Condition Before the Fire:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [new_or_like_new_condition: New or like new condition], [good_used_condition_maintained_: Good (used condition, maintained well)], [poor_condition_not_maintained_m: Poor condition (not maintained, missing parts, etc.)], ... 1 more ...)
• vehicle_condition_before_the_fi_other (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• vehicle_fire_information (type: esriFieldTypeString, alias: Vehicle Fire Information, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• factors_leading_to_the_fire (type: esriFieldTypeString, alias: Factors Leading to the Fire:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• factors_leading_to_the_fire_spe (type: esriFieldTypeString, alias: Speeding, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [primary: Primary], [secondary: Secondary])
• factors_leading_to_the_fire_dis (type: esriFieldTypeString, alias: Distracted driving, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [primary: Primary], [secondary: Secondary])
• field_51_2 (type: esriFieldTypeString, alias: Smoking, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [primary: Primary], [secondary: Secondary])
• impaired_driving_alcohol (type: esriFieldTypeString, alias: Impaired driving (alcohol), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [primary: Primary], [secondary: Secondary])
• factors_leading_to_the_fire_imp (type: esriFieldTypeString, alias: Impaired driving (other), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [primary: Primary], [secondary: Secondary])
• factors_leading_to_the_fire_med (type: esriFieldTypeString, alias: Medical issue, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [primary: Primary], [secondary: Secondary])
• factors_leading_to_the_fire_elu (type: esriFieldTypeString, alias: Eluding, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [primary: Primary], [secondary: Secondary])
• factors_leading_to_the_fire_rec (type: esriFieldTypeString, alias: Reckless driving, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [primary: Primary], [secondary: Secondary])
• field_51_8 (type: esriFieldTypeString, alias: Intentional ignition by someone other than victim (including criminal acts), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [primary: Primary], [secondary: Secondary])
• field_51_9 (type: esriFieldTypeString, alias: Intentional ignition by victim, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [primary: Primary], [secondary: Secondary])
• factors_leading_to_the_fire_oth (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [primary: Primary], [secondary: Secondary])
• other_vehicles_involved (type: esriFieldTypeString, alias: List other vehicles involved:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• mobile_property_involved (type: esriFieldTypeString, alias: Mobile Property Involved:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [not_involved_in_ignition_but_bu: Not Involved in Ignition, but Burned], [involved_in_ignition_but_did_no: Involved in Ignition, but did not Burn], [involved_in_ignition_and_burned: Involved in Ignition and Burned])
• number_of_acres_burned (type: esriFieldTypeDouble, alias: Number of Acres Burned:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• factors_contributing_to_the_fir (type: esriFieldTypeString, alias: Factors Contributing to the Fire:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• close_proximity_to_fireflammabl (type: esriFieldTypeString, alias: Close proximity to fire/flammable material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [primary: Primary], [secondary: Secondary])
• improper_use_of_flammable_mater (type: esriFieldTypeString, alias: Improper use of flammable material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [primary: Primary], [secondary: Secondary])
• field_50_2 (type: esriFieldTypeString, alias: Medical issue, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [primary: Primary], [secondary: Secondary])
• field_50_3 (type: esriFieldTypeString, alias: Smoking, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [primary: Primary], [secondary: Secondary])
• field_50_4 (type: esriFieldTypeString, alias: Intentional ignition by someone other than victim (including criminal acts), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [primary: Primary], [secondary: Secondary])
• field_50_5 (type: esriFieldTypeString, alias: Intentional ignition by victim, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [primary: Primary], [secondary: Secondary])
• field_50_6 (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [primary: Primary], [secondary: Secondary])
• what_items_were_burning (type: esriFieldTypeString, alias: What Items Were Burning?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• nature_of_fire (type: esriFieldTypeString, alias: Nature of Fire:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [unintentional: Unintentional], [intentional: Intentional], [act_of_nature: Act of Nature], ... 1 more ...)
• most_probable_cause_reported_by (type: esriFieldTypeString, alias: Most Probable Cause Reported by Primary Investigation :, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [arson: Arson], [cooking: Cooking], [electrical_: Electrical], ... 12 more ...)
• most_probable_cause_reported_by_other (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• causes_unable_to_be_ruled_out (type: esriFieldTypeString, alias: Cause(s) Unable to be Ruled Out:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• causes_associated_with_fire_saf (type: esriFieldTypeString, alias: Cause(s) Associated with Fire Safety Education, Enforcement, etc., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• primary_investigation_agency_st (type: esriFieldTypeString, alias: Primary Investigation Agency Status:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [local_pending: Local Pending], [local_complete: Local Complete], [state_pending: State Pending], ... 1 more ...)
• other_issues_contributing_to_ig (type: esriFieldTypeString, alias: Other Issues Contributing to Ignition:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• issues_contributing_to_fire_spr (type: esriFieldTypeString, alias: Issues Contributing to Fire Spread:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• incident_information (type: esriFieldTypeString, alias: Incident Information, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• property_value (type: esriFieldTypeDouble, alias: Property Value:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• property_loss (type: esriFieldTypeDouble, alias: Property Loss:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• exposures (type: esriFieldTypeString, alias: Exposures:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• insurance_company (type: esriFieldTypeString, alias: Insurance Company:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• call_history_at_incident_locati (type: esriFieldTypeString, alias: Call History at Incident Location:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• response_information (type: esriFieldTypeString, alias: Response Information, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• did_someone_other_than_the_fire (type: esriFieldTypeString, alias: Did Someone Other than the Fire Department Attempt Rescue?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes_successful_entry_: Yes- Successful entry], [yes_made_attempt_no_entry: Yes- Made attempt, no entry], [no_citizens_were_around_no_one_: No- Citizens were around, no one made attempt], ... 3 more ...)
• number_of_apparatus (type: esriFieldTypeInteger, alias: Number of Apparatus:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• mutual_aid (type: esriFieldTypeString, alias: Automatic/Mutual Aid:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• other_agency_involvement (type: esriFieldTypeString, alias: Other Agency Involvement:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• additional_cause_information (type: esriFieldTypeString, alias: Additional Cause Information, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• initial_call_notes (type: esriFieldTypeString, alias: Initial Call Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• extinguishing_or_fire_control_m (type: esriFieldTypeString, alias: Extinguishing or Fire Control Methods Used by Citizen/Occupant:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fire_department_search_results (type: esriFieldTypeString, alias: Fire Department Search Results:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• search_notes (type: esriFieldTypeString, alias: Search Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• media_information (type: esriFieldTypeString, alias: Media Information, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• was_the_incident_reported_in_lo (type: esriFieldTypeString, alias: Was the Incident Reported in Local Media?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• news_article_urls (type: esriFieldTypeString, alias: News Article URLs, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_of_survivors (type: esriFieldTypeInteger, alias: Number of Survivors:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• gender_and_age_of_survivors (type: esriFieldTypeString, alias: Gender and Age of Survivors:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• nfirs (type: esriFieldTypeString, alias: NFIRS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• nfirs_report_status (type: esriFieldTypeString, alias: NFIRS Report Status:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [primary_fd_complete: Primary FD Complete], [primary_fd_incomplete: Primary FD Incomplete], [mutual_aid_fd_complete: Mutual Aid FD Complete], ... 1 more ...)
• nfirs_incident_key (type: esriFieldTypeString, alias: NFIRS Incident Key:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• law_enforcement_information (type: esriFieldTypeString, alias: Law Enforcement Information, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• law_enforcement_agency_involved (type: esriFieldTypeString, alias: Law Enforcement Agency Involved:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ori_number (type: esriFieldTypeString, alias: ORI Number:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fire_marshal_notification_and_n (type: esriFieldTypeString, alias: Fire Marshal Notification and Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• date_of_fire_marshal_notificati (type: esriFieldTypeDate, alias: Date of Fire Marshal Notification:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fire_marshal_notification_metho (type: esriFieldTypeString, alias: Fire Marshal Notification Method:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [duty_chief: Duty Chief], [state_watch_warning_point: State Watch/Warning Point], [media: Media], ... 1 more ...)
• researcher_narrative (type: esriFieldTypeString, alias: Researcher Narrative:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• crr_efforts_requested_by_fire_d (type: esriFieldTypeString, alias: CRR Efforts Requested by Fire Department:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fire_department_point_of_contac (type: esriFieldTypeString, alias: Fire Department Point of Contact, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fire_department_contacts_full_n (type: esriFieldTypeString, alias: Fire Department Contact's Full Name:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• phone_number (type: esriFieldTypeString, alias: Phone Number:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• email (type: esriFieldTypeString, alias: Email:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• additional_notes (type: esriFieldTypeString, alias: Additional Notes:, 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)
• total_reported (type: esriFieldTypeInteger, alias: Total number of victims reported in the Basic Fire Information section, SQL Type: sqlTypeOther, nullable: true, editable: true)
• total_victims (type: esriFieldTypeInteger, alias: Total number of victims added to this incident:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• add_victims_note (type: esriFieldTypeString, alias: Ensure that the two values above match., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• researcher_narrative_2 (type: esriFieldTypeString, alias: Researcher Narrative:, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• crr_efforts_requested_by_fire_2 (type: esriFieldTypeString, alias: CRR Efforts Requested by Fire Department:, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• additional_notes_2 (type: esriFieldTypeString, alias: Additional Notes:, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• weather_factor (type: esriFieldTypeString, alias: Was extreme weather a factor?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• responder_submission (type: esriFieldTypeString, alias: To the best of my knowledge, the information entered for this incident is correct., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes])
• basic_incident_approval (type: esriFieldTypeString, alias: This incident's details have been reviewed by the State Fire Marshal's office and has been approved for inclusion in the NASFM Fire Fatality dataset., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [approved: Approved - Continue data collection below], [followup: Needs follow-up by State Fire Marshal's Office], [delete: Delete - Mark this incident for deletion], ... 1 more ...)
• globalid_1709141546696 (type: esriFieldTypeGUID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• victim_information (type: esriFieldTypeString, alias: Victim Information, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_95 (type: esriFieldTypeString, alias: Name of the Victim:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_96 (type: esriFieldTypeInteger, alias: Age of the Victim:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• field_97 (type: esriFieldTypeString, alias: Race of the Victim:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_98 (type: esriFieldTypeString, alias: Gender of the Victim:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_99 (type: esriFieldTypeString, alias: Occupation of the Victim:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_100 (type: esriFieldTypeDate, alias: Date of Fatality:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• treatment_and_transport (type: esriFieldTypeString, alias: Treatment and Transport, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_102 (type: esriFieldTypeString, alias: Treatment Rendered, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_102_0 (type: esriFieldTypeString, alias: Medical Treatment Rendered?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• field_102_1 (type: esriFieldTypeString, alias: Was the Victim Accessible?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• field_102_2 (type: esriFieldTypeString, alias: Was the Victim Dead Before Arrival?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• field_102_3 (type: esriFieldTypeString, alias: Did Citizens Render First Aid?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• field_102_4 (type: esriFieldTypeString, alias: Did First Responders Render ALS?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• field_102_5 (type: esriFieldTypeString, alias: Did First Responders Render BLS?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• field_102_6 (type: esriFieldTypeString, alias: Did EMS Render ALS?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• field_102_7 (type: esriFieldTypeString, alias: Did EMS Render BLS?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• field_102_8 (type: esriFieldTypeString, alias: Was the Victim Transported?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• field_103 (type: esriFieldTypeString, alias: If Transported, What Hospital Received the Victim?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_104 (type: esriFieldTypeString, alias: ICD-10 Code on Death Certificate:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_106 (type: esriFieldTypeString, alias: Toxicology or Autopsy Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• group_23 (type: esriFieldTypeString, alias: Activity at the Time of the Incident, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_107 (type: esriFieldTypeString, alias: Activity at Time of Awareness:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [awake_recreation: Awake-Recreation], [burning_intentional_noncriminal: Burning- Intentional, Noncriminal], [burning_intentional_criminal: Burning- Intentional, Criminal], ... 15 more ...)
• field_107_other (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_108 (type: esriFieldTypeString, alias: Activity at Time of Incapacitation:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [same_activity_as_awareness_no_t: Same activity as awareness/ no time to react to the emergency], [escape_unsuccessful: Escape- Unsuccessful], [escape_successful_incl_meeting_: Escape- Successful (incl. meeting FD)], ... 12 more ...)
• field_108_other (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_109 (type: esriFieldTypeString, alias: Factors Affecting Ability to Escape:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• location_and_distance_traveled (type: esriFieldTypeString, alias: Location and Distance Traveled:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_110 (type: esriFieldTypeString, alias: Location at the Time of Incident:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_113 (type: esriFieldTypeString, alias: Distance from Egress to Awareness (in feet):, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_111 (type: esriFieldTypeString, alias: Distance from Egress to Incapacitation (in feet):, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_114 (type: esriFieldTypeString, alias: Distance Victim Traveled from Awareness to Incapacitation (in feet):, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• symptoms_and_injury (type: esriFieldTypeString, alias: Symptoms and Injury, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_115 (type: esriFieldTypeString, alias: Primary Apparent Symptom:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_116 (type: esriFieldTypeString, alias: Primary Area of Body Injured:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_117 (type: esriFieldTypeString, alias: Factors Contributing to Injury:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_118 (type: esriFieldTypeString, alias: Cause of Injury:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_119 (type: esriFieldTypeString, alias: Human Factors Contributing to Injury:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• total_reported_1709141546696 (type: esriFieldTypeInteger, alias: Total number of victims reported in the Basic Fire Information section, SQL Type: sqlTypeOther, nullable: true, editable: true)
• total_victims_1709141546696 (type: esriFieldTypeInteger, alias: Total number of victims added to this incident:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• add_victims_note_1709141546696 (type: esriFieldTypeString, alias: Ensure that the two values above match., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• CreationDate_1709141546696 (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator_1709141546696 (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate_1709141546696 (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor_1709141546696 (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)

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: 6/25/2025 1:24:08 PM

Schema Last Edit Date: 2/28/2024 4:16:17 PM

Data Last Edit Date: 2/28/2024 4:16:17 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Attachments   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat