dc mapping
Crash fields (10)
| Target (MMUCC6) | Rule kind | Source |
|---|---|---|
StateCode |
Constant | Always DistrictOfColumbia (USStateNumericCode) |
StateUniqueCrashID |
Column | Raw passthrough of column 'CCN' |
AgencyOrPoliceJurisdiction |
Column | Raw passthrough of column '__NO_AGENCY_FIELD__' (default "Metropolitan Police Department" if blank) |
PoliceReportedCrashCode |
Constant | Always Yes (StandardSelectionYesNoCode) |
StateReportableCrashCode |
Constant | Always Yes (StandardSelectionYesNoCode) |
CrashDate |
EpochMillisDateTimeSplit | Unix epoch-milliseconds date/time split from column 'REPORTDATE' |
RoadwayClearanceDate |
SameAs | Copies the already-computed value of 'CrashDate' |
RoadwayClearanceTime |
ConstantSentinel | Always the sentinel RoadClearanceTimeExtCode.Unknown (no real source data for this field) |
CrashCountyCode |
CountyLookup | County FIPS lookup from column 'COUNTY_CODE' via county-crosswalk.csv |
GlobalPosition |
CoordinatePair | Lat/long pair from 'LATITUDE' (lat) / 'LONGITUDE' (lon) - (0,0) treated as "no location" |
Vehicle fields (2)
| Target (MMUCC6) | Rule kind | Source |
|---|---|---|
VehicleNumber |
IntColumn | Integer passthrough of column 'VEHICLE_SEQ' |
VehicleBodyCategory.VehicleBodyTypeCode |
Lookup | Crosswalk lookup: column 'INVEHICLETYPE_CODE' via vehicle-body-style.csv |
Person fields (4)
| Target (MMUCC6) | Rule kind | Source |
|---|---|---|
PersonTypeCode |
Lookup | Crosswalk lookup: column 'PERSONTYPE_CODE' via person-type.csv (default PersonTypeCode.UnknownOccupantTypeInAMotorVehicleInTransport if unmapped) |
VehicleNumber |
IntColumn | Integer passthrough of column 'VEHICLE_SEQ' |
InjuryStatusCode |
Lookup | Crosswalk lookup: column 'INJURY_CODE' via injury-status.csv |
NonMotorist.VehicleNumberofMVStrikingNonMotorist |
IntColumn | Integer passthrough of column 'VEHICLE_SEQ' |