Name: Person

Display Field: CID

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

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:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• CID (type: esriFieldTypeString, alias: Crash ID, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
• CID_UID (type: esriFieldTypeString, alias: Crash ID - Vehicle ID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• CID_UID_PID (type: esriFieldTypeString, alias: Crash ID - Vehicle ID - Person ID, SQL Type: sqlTypeOther, length: 34, nullable: true, editable: true)
• PER_TYPE (type: esriFieldTypeInteger, alias: Person Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Driver], [2: Pedestrian], [3: Pedalcyclist], ... 6 more ...)
• SEAT_POS (type: esriFieldTypeInteger, alias: Seating Position, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Driver], [2: Center front], [3: Passenger], ... 10 more ...)
• INJ_SEV (type: esriFieldTypeInteger, alias: Injury Severity, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No indication of injury], [1: C-injury], [2: B-injury], ... 2 more ...)
• AGE (type: esriFieldTypeInteger, alias: Age, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SEX (type: esriFieldTypeString, alias: Sex, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• SAF_EQI (type: esriFieldTypeInteger, alias: Safety Equipment, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: None Used/Not Applicable], [2: Shoulder and Lap Belt Used], [3: Seat Belts Not Used], ... 17 more ...)
• AIRBAG (type: esriFieldTypeInteger, alias: Airbag Deployment, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: With seat belt], [2: Without seat belt], [3: Not applicable], ... 7 more ...)
• EJECT (type: esriFieldTypeInteger, alias: Ejection, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: None], [2: Totally ejected], ... 3 more ...)
• DR_CON (type: esriFieldTypeInteger, alias: Driver Physical Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Normal], [2: Impaired-alcohol], [3: Impaired-drugs], ... 12 more ...)
• DR_VISION (type: esriFieldTypeInteger, alias: Driver Vision, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Not obscured], [2: Windshield (water, ice)], [3: Trees, plants], ... 12 more ...)
• PD_VISION (type: esriFieldTypeInteger, alias: Pedestrian Visibility, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: No contrasting clothing], [2: Contrasting clothing], [3: Reflective material], ... 3 more ...)
• DR_ACTION (type: esriFieldTypeInteger, alias: Driver Action, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: None], [2: Failed to Yield], [3: Disregarded control devices], ... 18 more ...)
• PD_ACTION (type: esriFieldTypeInteger, alias: Pedestrian Action, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: Turning left], [4: Turning right], [20: Enter from drive or alley], ... 21 more ...)
• PD_LOC (type: esriFieldTypeInteger, alias: Pedestrian Location, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: In roadway], [2: In crosswalk], [3: Not in available crosswalk], ... 8 more ...)
• DR_LIC_ST (type: esriFieldTypeString, alias: Driver License State, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• YEAR (type: esriFieldTypeInteger, alias: Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WasDistracted (type: esriFieldTypeString, alias: Was Distracted, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• DistractionReason (type: esriFieldTypeString, alias: Distraction Reason, SQL Type: sqlTypeOther, length: 98, nullable: true, editable: true)
• IsIncidentResponder (type: esriFieldTypeString, alias: Is Incident Responder, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• IncidentResponder (type: esriFieldTypeString, alias: Incident Responder, SQL Type: sqlTypeOther, length: 160, nullable: true, editable: true)
• EjectionPath (type: esriFieldTypeString, alias: Ejection Path, SQL Type: sqlTypeOther, length: 102, nullable: true, editable: true)
• Pedestrian (type: esriFieldTypeInteger, alias: Pedestrian, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Pedalcyclist (type: esriFieldTypeInteger, alias: Pedalcyclist, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Younger_Driver__16_20_ (type: esriFieldTypeInteger, alias: Younger_Driver__16_20_, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Older_Driver__65__ (type: esriFieldTypeInteger, alias: Older_Driver__65__, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Unrestrained_Occupants (type: esriFieldTypeInteger, alias: Unrestrained_Occupants, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Impaired_Driver (type: esriFieldTypeInteger, alias: Impaired_Driver, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Distracted_Fatigued_Drowsy_Driv (type: esriFieldTypeInteger, alias: Distracted_Fatigued_Drowsy_Driver, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Speeding_Aggressive_Driver (type: esriFieldTypeInteger, alias: Speeding_Aggressive_Driver, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Wrong_Way_Driving (type: esriFieldTypeInteger, alias: Wrong_Way_Driving, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Roadway_Departure (type: esriFieldTypeInteger, alias: Roadway_Departure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Highway_Railroad_Grade_Crossing (type: esriFieldTypeInteger, alias: Highway_Railroad_Grade_Crossings, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Work_Zone (type: esriFieldTypeInteger, alias: Work_Zone, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Animal (type: esriFieldTypeInteger, alias: Animal, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Heavy_Vehicle (type: esriFieldTypeInteger, alias: Heavy_Vehicle, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Motorcycle (type: esriFieldTypeInteger, alias: Motorcycle, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Intersection_Related (type: esriFieldTypeInteger, alias: Intersection_Related, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: Person
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Relationships:

• Crash (1) -- Related To: Ped Bike Crashes 2005-2021 (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/9/2023 5:57:51 PM

Schema Last Edit Date: 3/9/2023 5:57:51 PM

Data Last Edit Date: 3/9/2023 5:57:51 PM

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