R&H usage

5725
35
06-11-2019 05:59 AM
RyanKoschatzky
Occasional Contributor III

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?

35 Replies

all of our KDOT stats start in early July 2019 when we implemented into production roads and highways

NicoleHanson1
Occasional Contributor

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 

NicoleHanson1
Occasional Contributor

We've been in PROD since 2017.

0 Kudos
RyanKoschatzky
Occasional Contributor III

Nicole,

Are those total numbers or just 2018 or 2019? 

0 Kudos
NicoleHanson1
Occasional Contributor

That's just 2019.  Sorry. thought I made sure to reply on the 2019 string!  LOL

0 Kudos
RyanKoschatzky
Occasional Contributor III

I think you did. I am still getting used to how geonet breaks out different replies. 

0 Kudos
MarshallStevenson__SHA_
New Contributor

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

MichaelClement
New Contributor II

Iowa's Numbers:

ACTIVITYTYPEEDITS_2019EDITS_2018EDITS_2017EDITS_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
RyanKoschatzky
Occasional Contributor III

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. 

0 Kudos
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.