iowa mapping
← All states
Crash fields (13)
| Target (MMUCC6) |
Rule kind |
Source |
|---|
StateCode |
Constant |
Always Iowa (USStateNumericCode) |
StateUniqueCrashID |
Column |
Raw passthrough of column 'CRASH_KEY' |
AgencyOrPoliceJurisdiction |
Column |
Raw passthrough of column 'COUNTY_NAME' (default "(not available in this source)" if blank) |
PoliceReportedCrashCode |
Constant |
Always Yes (StandardSelectionYesNoCode) |
StateReportableCrashCode |
Constant |
Always Yes (StandardSelectionYesNoCode) |
CrashDate |
EpochMillisDateTimeSplit |
Unix epoch-milliseconds date/time split from column 'CRASH_DATETIME' |
RoadwayClearanceDate |
SameAs |
Copies the already-computed value of 'CrashDate' |
RoadwayClearanceTime |
ConstantSentinel |
Always the sentinel RoadClearanceTimeExtCode.Unknown (no real source data for this field) |
AtmosphericConditionsCode |
ListLookup |
Crosswalk lookup (single value wrapped in a list): column 'WEATHER' via weather.csv |
LightConditionCode |
Lookup |
Crosswalk lookup: column 'LIGHT' via light-condition.csv |
MannerofCollisionCode |
Lookup |
Crosswalk lookup: column 'CRCOMNNR' via manner-of-collision.csv |
CrashCountyCode |
CountyLookup |
County FIPS lookup from column 'COUNTY_NUMBER' via county-crosswalk.csv |
GlobalPosition |
WebMercatorCoordinatePair |
Web Mercator (EPSG:3857) coordinate pair from 'GEOM_X' (x) / 'GEOM_Y' (y), converted to lat/long |
Vehicle fields (5)
| Target (MMUCC6) |
Rule kind |
Source |
|---|
VehicleNumber |
SequentialIndex |
Assigned sequentially (1, 2, 3, ...) by position within the crash |
MotorVehicleModelYearCode |
NumericUnionValue |
Raw numeric passthrough of column 'VYEAR' (no sentinel handling) |
ExtentofDamageCode |
Lookup |
Crosswalk lookup: column 'DAMAGE' via extent-of-damage.csv |
VehicleStatusPriortoCriticalEventCode |
Lookup |
Crosswalk lookup: column 'VACTION' via vehicle-action.csv |
TrafficControlDeviceCode |
Lookup |
Crosswalk lookup: column 'TRAFCONT' via traffic-control-device.csv |
Person fields (0)
Not mapped this pass - see the state's own StateMappingConfig source for why.