R&H usage

2031
34
06-11-2019 05:59 AM
RyanKoschatzky
Regular Contributor

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?

34 Replies
CharlesMcNeel
New Contributor II

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

WV numbers are this:

   

1 - Create Route351
2 - Calibrate Route2194
3 - Reverse Route1
4 - Retire Route15
5 - Extend Route3
6 - Reassign Route64
7 - Realign Route10
12 - Cartographic Realignment6379
TOTAL9017

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
Regular Contributor

"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.

0 Kudos

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.

0 Kudos
RyanKoschatzky
Regular Contributor

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

 

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