I know Nathan has stated the Lrs_Edit_Log is not meant for human consumption and I don’t disagree, but one can still find what I believe is useful information, especially if you compare years. Here is the type/number of edits I calculated for NCDOT for 2018 using 10.5.1:
TransactionDate > '1/1/2018' AND TransactionDate < '1/1/2019' AND ActivityType = X
Edit log Code/R&H Route action name/number of records
1 Create Route 4684
3 Reverse Route 140
4 Retire Route 1260
5 Extend Route 1070
6 Reassign Route 1020
7 Realign Route 349
12 Cartographic Realignment 19139
What are your stats?
all of our KDOT stats start in early July 2019 when we implemented into production roads and highways
1- Create Route: 6571
2- Calibrate Route: 466
3- Reverse Route: 54
4- Retire Route: 117
5- Extend Route: 451
6- Reassign Route: 6
7- Realign Route: 14
12- Carto Realign: 246
13- Load: 0
LOL
We've been in PROD since 2017.
Nicole,
Are those total numbers or just 2018 or 2019?
That's just 2019. Sorry. thought I made sure to reply on the 2019 string! LOL
I think you did. I am still getting used to how geonet breaks out different replies.
Maryland's Report:
1 - Create Route - 227
2 - Calibrate Route - 4443
3 - Reverse Route - 37
4 - Retire Route - 175
5 - Extend Route - 51
6 - Reassign Route - 198
7 - Realign Route - 689
12 - Cartographic Realignment - 4037
13 - Load Route - 0
Iowa's Numbers:
ACTIVITYTYPE | EDITS_2019 | EDITS_2018 | EDITS_2017 | EDITS_2016 |
---|---|---|---|---|
1 | 402 | 574 | 257 | 356 |
2 | 2137 | 3081 | 1655 | 625 |
3 | 15 | 34 | 7 | 5 |
4 | 340 | 334 | 232 | 126 |
5 | 293 | 452 | 175 | 203 |
6 | 210 | 257 | 84 | 37 |
7 | 223 | 270 | 130 | 78 |
12 | 429 | 600 | 429 | 72 |
Thanks Andrew, Kyle, Marshall and Michael for responding.
Have any of you broken down the edit types per route class or system vs nonsystem? I have not yet for our data but that is planned.
When looking at the activity type record numbers, did any of the values surprise you for the way your departments are set up? I was expecting most of our values to increase based on what the mid year results showed but not by the numbers I saw.
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.