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

Lineární referencování pro DOT pomocí ArcMap?

RaymondArotin1

<\/HEAD>

Dobrý den,<\/P>

Pracuji pro Department of Transportation v Pensylvánii. Byl jsem překvapen, když jsem přišel do PennDOT, že většina uživatelů GIS nezná ArcMap. Většinou používají GeoMedia a jiné "in-house" programy (Maintenance IQ), které velmi dobře fungují s lineárním referencováním. Tyto programy se integrují s databázemi a tabulkami nadřízených a rychle a relativně snadno se připojují k mapám. PennDOT používá Line Segments a segmentové offsety (jak na začátku segmentu, tak další offset na konci, například k vytvoření trasy Roadwork, jako je pokládka asfaltu nebo řezání krajnice).<\/P>

<\/P>

Zdá se, že neexistuje rychlý a snadný způsob, jak vzít tabulku s těmito segmenty a offsety a integrovat ji do mapy v ArcMap se shapefily State Roads. "Make Route Event Layer" v ArcTools nemá dostatek možností pro správné vytvoření trasy na základě Beginning Offset a End Offset. Nepřijme State Route Number jako platné pole pro "Route identifier". Dále není možné zvolit Seg_Beg jako "from" a Seg_End jako "to". Navíc nemá možnost pro dva samostatné Offsets.<\/P>

<\/P>

Nevím o lineárním referencování příliš mnoho, takže možná to dělám špatně. V mé předchozí práci jsem používal výhradně x,y souřadnice. Nejsem si jistý, jestli mi někdo může pomoci nebo mě nasměrovat správným směrem. Opravdu však nemohu přijít s rozsáhlým, složitým řešením. Pokud to nebude jednoduché a rychlé, nestane se to. (Software třetích stran? Obcházení?)<\/P><\/BODY><\/HTML>

Najděte více příspěvků označených jako

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

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

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