nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

ArcMapを使用したDOTの線形参照？

RaymondArotin1

<\/HEAD>

こんにちは、<\/P>

私はペンシルベニア州のDepartment of Transportationで働いています。PennDOTに来て驚いたのは、ほとんどのGISユーザーがArcMapに不慣れだったことです。主に彼らはGeoMediaや他の「in-house」プログラム（Maintenance IQ）を使用しており、これらは線形参照と非常にうまく連携しています。これらのプログラムはスーパーバイザーのデータベースやスプレッドシートと統合され、地図に迅速かつ比較的簡単に接続できます。PennDOTではLine Segmentsとセグメントオフセット（セグメントの開始時と終了時の両方に別々のオフセットがあり、例えば舗装や肩部切断などのRoadworkルートを確立するため）を使用しています。<\/P>

<\/P>

これらのセグメントとオフセットを含むスプレッドシートをState Roadsのシェープファイルと一緒にArcMapの地図に統合する迅速かつ簡単な方法はなさそうです。ArcToolsの「Make Route Event Layer」には、開始オフセットと終了オフセットに基づいて正しくルートを作成するための十分なオプションがありません。「Route identifier」フィールドとしてState Route Numberを受け入れません。また、「from」としてSeg_Beg、「to」としてSeg_Endを選択することも不可能です。さらに、2つの別々のオフセット用のオプションもありません。<\/P>

<\/P>

私は線形参照にはあまり詳しくないので、おそらく間違った方法で取り組んでいるかもしれません。以前の仕事では、x,y座標のみを使用していました。誰か助けてくれるか正しい方向を示してくれる人がいればと思います。ただし、大規模で複雑なソリューションには対応できません。簡単で迅速でなければ実現しません。（サードパーティソフトウェア？回避策？）<\/P><\/BODY><\/HTML>

タグ付きの投稿をもっと見る

Accepted answers

All comments

TedKowal

This may help you understand the basics of ArcGIS linear referencing. What is linear referencing?—Help | ArcGIS for Desktop

Penndot, if memory serves correctly, uses a Quadrant system in tangent to a linear referencing line.

You may want to contact some of these folks who wrote article....

PennDOT Integrates ArcGIS for Modernized Field Data Collection

Ted

Anonymous User

Hello Raymond. I think there should be a relatively simple way to translate between offset system that you use at PennDOT and a standard ArcGIS Route system. Would you be willing to share some of your route and event data? I'd be willing to take a look at it and see if a simple translation is possible.

RaymondArotin1

Tom,

Thank you very much for reaching out to me. I would appreciate any tutorial guidance or insight on this that you can provide.

I uploaded three shapefiles which are all you need to create a simple map of Jefferson County, Pennsylvania.

PaCounty2015_01 – these are polygons of all the counties in PA.
Jefferson_Municipalities – polygons of all the Municipalities in Jefferson County
RMSSEG_Roads_Jefferson_County_PA – Polylines of all the State Roads in Jefferson County

The RMSSEG Roads shapefile is a “stripped down” version. Usually it has many, many columns with various information about Lane Counts, Pavement conditions, and more. But none of that is relevant to this discussion, so I took those out and kept the shapefile as basic as possible.

The most important Fields are these…

ST_RT_NO – The State Route Number. (Route 536, Route 1012, etc.)

SEG_NO – Each State road is divided into Segments. Not all segments are the same length. They are usually numbered as such: Seg 0010, 0020, 0030, etc.

SEG_LNGTH_ - This is the length in feet of each segment.

CUM_OFFSET – This is basically the cumulative feet at the beginning of each segment. So the first segment would say “0”. The next segment might begin at “3725” feet.

CUM_OFFS_1 – This is the cumulative feet at the end of each segment. So, the first segment would say “3725” feet, if the entire first segment is 3725 feet. The 2^nd segment might say “7011”. So that would be 3725 + 3286 (the cumulative feet of the first segment plus the cumulative feet of the second segment).

Event Table.

I also uploaded an Excel spreadsheet with 3 “events”. (An Event table).

I kept this very simple. I made 3 events. So this is how a Supervisor would normally show where an Event is happening. (Usually the spreadsheets are much more complex with lots and lots of data such as material, crews, payroll info, equipment numbers, etc…. but none of that is relevant to this either.)

Anyway I created 3 events just north of Punxsutawney, PA (Phil the Groundhog’s hometown!). Punxsutawney is located at the very bottom (South) in Jefferson County.

The three events are “Paving”, “Tree Trimming” and “Line Painting”.

As you can see from the spreadsheet, typically an event is shown in PennDOT’s data as the State Route it is on (ST_RT_NO), then which Segment it begins in (SEG_BEG), then the exact “offset” place of beginning within that segment (OFF_BEG). So, for example… if the (OFF_BEG) is “0”, then the Event is beginning right at the exact beginning of the segment. If the (OFF_BEG) said “1,000” then the exact beginning of the Event is starting 1,000 feet from the beginning of the segment.

Then the segment where the Event is ending is stated as (SEG_END) and the exact location of its end is (OFF_END). This is the number of feet from the beginning of that segment. So, again, if it said “0” that would mean the Event is ending right at the very beginning of that segment. If it said “1,000” then it is ending exactly 1,000 feet from the beginning of that segment.

So, how would I link this simple Event table to my Map and show the exact places (as Lines, not points) where the three events are taking place? I’ve attached a simple illustration showing each Event and approximately where they would be happening on the map if you successfully did this.

I would like to take any spreadsheet with those Fields list above and quickly map Events (as Lines) in ArcMap. Is this possible? Usually we would need to map hundreds of events, and even overlapping events, so doing this all by hand is out of the question. Thank you for any help you can provide.

Raymond

PaCounty2015.zip

THREE EVENTS - Jefferson County.xlsx

Jefferson Municipalities.zip

RMSSEG Roads.zip

PennDOT Segment Map with EVENTS.jpg

Anonymous User

Thanks Raymond. I will take a look at this, this week.

Tom

RaymondArotin1

I just wanted to add some additional information. I found a tutorial method that is used with GeoMedia. ATTACHED PDF. I'm just including this as an example of what I was expecting within ArcMap (the general method, the dialog boxes). It seems to be a very simple straight forward method. In particular, (page 3) shows the Measure field options that allow you to pick SEG_BEG, OFFSET_BEG, SEG_END, and OFFSET_END.

Again, thanks for any help you can provide.

GeoMedias Method.pdf

RaymondArotin1

Has anyone figured anything out on this yet? It will be tremendously beneficial to our Agency to be able to use our Segment-based method to quickly map features. Otherwise, we have to go about this another way. Thanks for any help. I'm going to need to figure something out soon.

Anonymous User

Raymond,

Apologies for taking so long with this. I just got slammed with other work. But I think I have a good solution for you. First off, as you already know, the ArcGIS approach is different from the segment approach you have. Instead of locating using segments and offsets, we use a continuous route with cumulative measures. With the Roads and Highways extension we do support offsets natively. This is done by converting offsets locations to route and measure. The nice thing about this approach is you can offset from any point geography, like a sign or reference marker. Out of curiosity, are you segments referenced along the roadway with physical signs or markers? If so, those would be the offset features in Roads and Highways. If you don’t have that physical reference in the field, how do field people locate these LRS locations using segment and offset?

With all that said, we can locate your events using some simple geoprocessing. In the attached zip there is a toolbox called “Toolbox.tbx” that contains the following three models.

Create PennDOT Routes. This model creates a continuous route system using CITY_CODE and ST_RT_NO. These are the LRS key fields that you setup in Geomedia. I saw in the PDF that you shared that you also use SIDE_IND as a LRS key field but I didn’t find that in the data that you provided. This could be easily included if you needed it. This model only needs to be run once to generate the PolylineM routes in ArcGIS. I already ran them on the data you provided and the result is “Routes “ in the PennDOT.gdb Geodatabase.
Convert Excel Table. This is a built in function for converting an Excel worksheet to a table. I just included it in this toolbox for easy access. The Locate model needs to have a table input so you need to run this first to convert the worksheet to a table.
Locate PennDOT Events. This model locates an event table using the following parameters: City Code, State Route Number, Segment Begin ID, Begin Offset, Segment End ID, and End Offset. The model takes that input and converts it to RouteID, FromMeasure, and ToMeasure and then locates it on the PolylineM Routes.

Locate PennDOT Events Geoprocessing tool

The nice things about this approach is once you have your ArcGIS routes created you can execute the “Locate PennDOT Events” tool as many times as you want. You could also publish it to ArcGIS Server and execute it from a Web AppBuilder web application. If your interested in this, just let me know. Actually I’d be happy to talk with you about this process. If you are interested just email me your contact information at tbrenneman@esri.com.

I hope you find this useful. Please let me know if you have any follow up questions.

Tom

PennDOTLRSLocate.zip

Anonymous User

And just the toolboxes in 10.5 and 10.3 format.

PennDOTLRSLocateToolboxes.zip

JohnFix1

Raymond,

PennDOT has a web app called "GIS-IQ" that allows you to drag and drop an excel file with county/route/segment (begin/end)/offset (begin/end) and map those features in the app. It's very easy to use. This app was created in BPR's GID.

It is an Esri based app, supported with ArcGIS Enterprise.

I hope this helps.

John

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.