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; } } }

Lineare Referenzierung für DOT mit ArcMap?

RaymondArotin1

<\/HEAD>

Hallo,<\/P>

ich arbeite für das Department of Transportation in Pennsylvania. Ich war überrascht, als ich zu PennDOT kam, dass die Mehrheit der GIS-Nutzer mit ArcMap nicht vertraut war. Meistens verwenden sie GeoMedia und andere "in-house" Programme (Maintenance IQ), die sehr gut mit Linear Referencing funktionieren. Diese Programme integrieren sich mit den Datenbanken und Tabellenkalkulationen der Vorgesetzten und verbinden sich schnell und relativ einfach mit Karten. PennDOT verwendet Liniensegmente und Segmentversätze (sowohl am Anfang des Segments als auch einen weiteren Versatz am Ende, um beispielsweise eine Baustellenroute wie Asphaltierung oder Bankettfräsen festzulegen).<\/P>

<\/P>

Es scheint keinen schnellen und einfachen Weg zu geben, eine Tabelle mit diesen Segmenten und Versätzen zu nehmen und sie in eine Karte in ArcMap mit State Roads Shapefiles zu integrieren. Die Funktion "Make Route Event Layer" in ArcTools bietet nicht genügend Optionen, um eine Route korrekt basierend auf dem Anfangs- und Endversatz zu erstellen. Sie akzeptiert die State Route Number nicht als gültiges Feld für das Feld "Route identifier". Außerdem ist es unmöglich, Seg_Beg als "from" und Seg_End als "to" auszuwählen. Darüber hinaus gibt es keine Option für zwei separate Versätze.<\/P>

<\/P>

Ich bin mit Linear Referencing nicht sehr vertraut, daher mache ich es vielleicht falsch. In meinem vorherigen Job habe ich ausschließlich x,y-Koordinaten verwendet. Ich bin mir nicht sicher, ob mir jemand helfen oder mich in die richtige Richtung weisen kann. Ich kann mich jedoch wirklich nicht auf eine große, komplexe Lösung einlassen. Wenn es nicht einfach und schnell ist, wird es nicht passieren. (Software von Drittanbietern? Workaround?)<\/P><\/BODY><\/HTML>

Finde mehr Beiträge mit dem Tag

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

Nimm an der Diskussion teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

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