SELECT [ActivityType], count([ObjectId]) as Edits
FROM .[RH].[LRS_EDIT_LOG]
group by ActivityType
order by ActivityType
SELECT [ActivityType], count([ObjectId]) as Edits
FROM .[RH].[LRS_EDIT_LOG]
WHERE (NetworkId = 1 AND Substring(RouteID, 4 ,1) in (1, 2, 3, 4)) OR (NetworkId =2 AND Substring(RouteID, 1 ,1) in (1, 2, 3, 4))
group by ActivityType
order by ActivityType
SELECT [ActivityType], count([ObjectId]) as Edits
FROM .[RH].[LRS_EDIT_LOG]
WHERE NetworkId = 1
AND Substring(RouteID, 4 ,1) not in (1, 2, 3, 4)
group by ActivityType
order by ActivityType
This SQL query give me breakdowns by state/nonstate system
Total:
ActivityType Edits
1 9
2 1203
4 86
5 11
6 35
7 17
12 107
13 3
State System Edits (we have 2 LRMS with state system) including ramps
ActivityType Edits
1 2
2 243
4 31
5 5
6 6
7 1
12 51
Non State System Edits
ActivityType Edits
1 7
2 960
4 55
5 6
6 29
7 16
12 56
The 3 "13" edit types were from a consultant and have null values on the row, I can't explain that.
It is an interesting performance metric. I thought our State System edits would be higher, but this makes sense because we put our greatest effort into loading the State System as clean as possible. Most of these edits are calibrations of the nonstate classified system. I can also break them down by editor - we have three editors, one has done about 89 edits, one has done about 15, and the third did all the rest. I'm mostly surprised that we have not done or accounted for any reverse route edits.