R&H usage

[RyanKoschatzky]

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?

[CharlesMcNeel]

I'm a little late to the discussion but wanted to get in here.

WV numbers are this:

1 - Create Route	351
2 - Calibrate Route	2194
3 - Reverse Route	1
4 - Retire Route	15
5 - Extend Route	3
6 - Reassign Route	64
7 - Realign Route	10
12 - Cartographic Realignment	6379
TOTAL	9017

A note is needed.  WVDOT has two LRM's and these are numbers for NetworkID "1".  Further I'm not all that confident in those numbers since as I look at the NetworkID compared to the RouteID I see that they don't always match.  In other words, we use a different format for the RouteID between our LRM's so we can tell at a glance which network it is.  Problem is that doesn't always match the recorded attribute for NetworkID.  Makes me wonder how much we can glean from this table.

[RyanKoschatzky]

"I'm a little late to the discussion but wanted to get in here."

Charles, welcome aboard and there is no way to be late as we all start at different times. Interesting find with multiply LRMs.

[KyleGonterwitz]

I'm still going on about this edit log thing here.  According to this link Migrating an LRS from a file geodatabase to a multiuser geodatabase—Roads and Highways Desktop | Arc...  the LRS EDIT LOG should be versioned, and I get much different results querying the versioned view of the edit log.

SELECT [ActivityType], count([ObjectId]) as Edits
FROM .[RH].[LRS_EDIT_LOG_evw]
group by ActivityType
order by ActivityType

ActivityType Edits
1 254
2 5504
3 43
4 1529
5 138
6 2470
7 135
12 518
13 3

SELECT [ActivityType], count([ObjectId]) as Edits
FROM .[RH].[LRS_EDIT_LOG_evw]
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

ActivityType Edits
1 116
2 967
3 8
4 103
5 35
6 121
7 36
12 181

SELECT [ActivityType], count([ObjectId]) as Edits
FROM .[RH].[LRS_EDIT_LOG_evw]
WHERE NetworkId = 1
AND Substring(RouteID, 4 ,1) not in (1, 2, 3, 4)
group by ActivityType
order by ActivityType

ActivityType Edits
1 138
2 4537
3 35
4 1426
5 103
6 2349
7 99
12 337

Lately my geodatabase compresses to about 30 or 31 states.  These numbers make more sense and contain all the stuff I thought I was missing when I queried the base table Edit Log.

[RyanKoschatzky]

It's that time of year again.

TransactionDate > '1/3/2020' AND TransactionDate < '1/1/2021' AND ActivityType = X
Edit log Code/R&H Route action name/number of records
1 Create Route 3274
3 Reverse Route 69
4 Retire Route 1421
5 Extend Route 1446
6 Reassign Route 583
7 Realign Route 844
12 Cartographic Realignment 84236
Total 91873

[KyleGonterwitz]

USE KHUB
SELECT [ActivityType], count([ObjectId]) as Edits
FROM [RH].[LRS_EDIT_LOG_evw]
WHERE TransactionDate BETWEEN '1/1/2020' AND '1/1/2021'
group by ActivityType
order by ActivityType

1 930
2 649
3 489
4 793
5 433
6 1003
7 534
12 24

[RyanKoschatzky]

Thought it would be interesting to see what everyone's numbers where last year and what version your at 10.8

TransactionDate > '1/3/2023' AND TransactionDate < '12/31/2023' AND ActivityType = X
Edit log Code/R&H Route action name/number of records
1 Create Route 2534
3 Reverse Route 107
4 Retire Route 638
5 Extend Route 1082
6 Reassign Route 604
7 Realign Route 668
12 Cartographic Realignment 28922
Total 34555