Name: Damage_Assessment

Display Field: objectid

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: objectid

Unique ID Field:

Name : objectid

IsSystemMaintained : True

Global ID Field: globalid

Type ID Field:

Fields:

• objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• Damage_Assesment (type: esriFieldTypeString, alias: Damage Assesment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0 No Damage: 0 No Damage], [1 Affected: 1 Affected: (Damage is mostly cosmetic)], [2 Minor: 2 Minor: (Repairable non-structural damage)], ... 2 more ...)
• 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)
• First_Due (type: esriFieldTypeString, alias: First Due, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Battalion (type: esriFieldTypeString, alias: Battalion, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Division (type: esriFieldTypeString, alias: Division, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Verified_Report (type: esriFieldTypeString, alias: Verification of Report?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Verified: Verified by Fire Department Personnel], [3rd Party: 3rd Party Report to Fire Department Personnel (unverified)])
• Reporting_Party (type: esriFieldTypeString, alias: Reporting Party Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Reporting_Party_Phone (type: esriFieldTypeString, alias: Reporting Party Phone Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Company (type: esriFieldTypeString, alias: Fire Company, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FD_ID (type: esriFieldTypeString, alias: Fire Department ID#, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FD_Name (type: esriFieldTypeString, alias: Fire Personnel Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Date_Time (type: esriFieldTypeDate, alias: Date & Time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Building_Type (type: esriFieldTypeString, alias: Building Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Type 1: Type 1 [Fire Resistive]], [Type 2: Type 2 [Non-Combustible]], [Type 3: Type 3 [Ordinary]], ... 2 more ...)
• Building_Stories (type: esriFieldTypeInteger, alias: Building Stories, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Building_Occupancy (type: esriFieldTypeString, alias: Building Occupancy Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Community College: Community College], [Child Development Center: Child Development Center], [Day Care Center: Day Care Center], ... 21 more ...)
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Fire (type: esriFieldTypeString, alias: Building Fire?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No: No], [Burning: Burning], [Out: Out])
• Roads (type: esriFieldTypeString, alias: Road Conditions, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Clear: Clear], [No Access: No Access], [Obstruction: Obstruction])
• Obstruction (type: esriFieldTypeString, alias: Obstruction, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Gas (type: esriFieldTypeString, alias: Gas Hazard, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Main Break: Main Break], [House Main: House Main], [Odor: Odor], ... 1 more ...)
• Water (type: esriFieldTypeString, alias: Water Hazard, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Main Break: Main Break], [House Main: House Main], [Flooding: Flooding], ... 1 more ...)
• Electrical (type: esriFieldTypeString, alias: Electrical Hazard, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Power Outage: Power Outage], [Downed Line: Downed Line], [Arcing: Arcing], ... 1 more ...)
• HazMat (type: esriFieldTypeString, alias: HazMat Hazard, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Sewer Leak: Sewer Leak], [Chemical Spill: Chemical Spill], [None: None], ... 1 more ...)
• Hazard_Comments (type: esriFieldTypeString, alias: Hazard Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Trapped_Casualties (type: esriFieldTypeInteger, alias: Trapped Casualties, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Dead_Casualties (type: esriFieldTypeInteger, alias: Dead/Black Tag Casualties, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Immediate_Casualties (type: esriFieldTypeInteger, alias: Immediate/RED Casualties, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Delayed_Casualties (type: esriFieldTypeInteger, alias: Delayed/Yellow Casualties, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Green_Casualties (type: esriFieldTypeInteger, alias: Walking Wounded/ Green Casualties, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Total_Casualties (type: esriFieldTypeInteger, alias: Total Casualties, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Resource_Needs (type: esriFieldTypeString, alias: Resources Needed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Engines (type: esriFieldTypeInteger, alias: Engines, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Trucks (type: esriFieldTypeInteger, alias: Trucks, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Rescue_Squad (type: esriFieldTypeInteger, alias: Rescue Squads, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Battalions (type: esriFieldTypeInteger, alias: Battalions, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Divisions (type: esriFieldTypeInteger, alias: Divisions, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Ambulances (type: esriFieldTypeInteger, alias: Ambulances, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Rescue_Captain (type: esriFieldTypeInteger, alias: Rescue Captains, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Mobile_Air_Unit (type: esriFieldTypeInteger, alias: Mobile Air Units, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Light_Rescue (type: esriFieldTypeInteger, alias: Light Rescues, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Hose_Tender (type: esriFieldTypeInteger, alias: Hose Tenders, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HazMat_Units (type: esriFieldTypeInteger, alias: HazMat Units, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Mini_Pumps (type: esriFieldTypeInteger, alias: Mini Pumps, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Flatbeds (type: esriFieldTypeInteger, alias: Flatbeds, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Forklifts (type: esriFieldTypeInteger, alias: Forklifts, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Hand_Crews (type: esriFieldTypeInteger, alias: Hand Crews, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Excavators (type: esriFieldTypeInteger, alias: Excavators, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Confined_Space (type: esriFieldTypeInteger, alias: Confined Space Rescue Units, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Live_Victim_K9 (type: esriFieldTypeInteger, alias: Live Victim Canines, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USAR (type: esriFieldTypeInteger, alias: Urban Search And Rescue Teams, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Buildings_On_Fire (type: esriFieldTypeInteger, alias: Number of buildings on fire?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Conflagration (type: esriFieldTypeString, alias: Potential for Conflagration?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Exposure_A (type: esriFieldTypeString, alias: Exposure A, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Exposure_B (type: esriFieldTypeString, alias: Exposure B, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Exposure_C (type: esriFieldTypeString, alias: Exposure C, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Exposure_D (type: esriFieldTypeString, alias: Exposure D, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Exposure_Comments (type: esriFieldTypeString, alias: Exposure Comments, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/6/2025 6:52:29 PM

Schema Last Edit Date: 6/2/2025 5:01:36 PM

Data Last Edit Date: 7/19/2025 4:02:58 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Attachments   Add Features   Update Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat