kansas mapping
← All states
Crash fields (12)
| Target (MMUCC6) |
Rule kind |
Source |
|---|
StateCode |
Constant |
Always Kansas (USStateNumericCode) |
StateUniqueCrashID |
Column |
Raw passthrough of column 'ACCIDENT_KEY' |
AgencyOrPoliceJurisdiction |
Column |
Raw passthrough of column 'REPORTING_AGENCY' (default "(not available in this source)" if blank) |
PoliceReportedCrashCode |
Constant |
Always Yes (StandardSelectionYesNoCode) |
StateReportableCrashCode |
Constant |
Always Yes (StandardSelectionYesNoCode) |
CrashDate |
EpochMillisDatePlusHourOnlyTimeSplit |
(EpochMillisDatePlusHourOnlyTimeSplit) |
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_CODE' via weather.csv |
LightConditionCode |
Lookup |
Crosswalk lookup: column 'LIGHT_CODE' via light-condition.csv |
CrashCountyCode |
CountyLookup |
County FIPS lookup from column 'COUNTY_CODE' via county-crosswalk.csv |
GlobalPosition |
CoordinatePair |
Lat/long pair from 'DOT_LATITUDE' (lat) / 'DOT_LONGITUDE' (lon) - (0,0) treated as "no location" |
Vehicle fields (0)
| Target (MMUCC6) |
Rule kind |
Source |
|---|
Person fields (0)
Not mapped for this state yet.