Skip to main content

Road Number Runoff loss of control driver side Runoff loss of control passenger side off path Head on loss of control Head on overtaking Intersection Property access Other Fatals Serious CRA_ROUTE = 1 CRA_RUM_CO IN(72,73,82,83,84,85) CRA_RUM_CO IN(70,71,80,81,86,87 ) CRA_RUM_CO IN(74, 75, 79, 88, 89) CRA_RUM_CO = 20 CRA_RUM_CO = 50 CRA_RUM_CO IN(10,11,12,13,14,15) CRA_RUM_CO = 47 CRA_RUM_CO IN(30-39, 40-46, 48-49, 51-69, 90-99) CRA_DEG_1 = 1 CRA_DEG_1 = 2

Somewhat making a guess at what you're trying to accomplish: I think the InLineQuerier might give you what you want, with a SQL query something like:

SELECT COUNT(*) AS "Headon Loss Of Control", "CRA_ROUTE_" FROM "InputData"  where "CRA_RUM_CO" in (20) GROUP BY "CRA_ROUTE_"; 

0684Q00000ArJtIQAV.jpg

The results are a summary accident report :

0684Q00000ArJqRQAV.jpg

I've also attached an FME Template file with your data and the workspace (FME 2017.1)

summaryaccidentreport2017.fmwt