This article outlines the crash attribute logic Numetric has incorporated for the City of Charlotte.
Intersection Related
If Signal ID is greater than or equal to "1"
CMV Related
If the column Unit Type is "Commercial"
Pedestrian Related
If the column Crash Type contains "Pedestrian"
Alcohol Involved
If the column Hazardous Action is "Alcohol Use"
Motorcycle Related
If the column Vehicle Type is "Motorcycle"