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:
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:
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