POST
|
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.
... View more
05-01-2017
07:02 AM
|
0
|
0
|
2375
|
POST
|
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.
... View more
04-20-2017
05:37 AM
|
0
|
0
|
2375
|
POST
|
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
... View more
04-14-2017
12:37 PM
|
0
|
1
|
2375
|
DOC
|
04-14-2017
12:32 PM
|
0
|
0
|
475
|
DOC
|
04-14-2017
12:32 PM
|
0
|
0
|
753
|
DOC
|
04-14-2017
12:32 PM
|
0
|
0
|
413
|
POST
|
Hello, I work for the Department of Transportation in Pennsylvania. I was surprised, when I came to PennDOT that the majority of the GIS users were unfamiliar with ArcMap. Mostly they use GeoMedia and other "in-house" programs (Maintenance IQ) that work very well with Linear Referencing. These programs integrate with the supervisor's databases and spreadsheets and connect to maps quickly and relatively easily. PennDOT uses Line Segments, and segment offsets (both at the beginning of the segment and another offset at the end, to... say, establish a Roadwork route, such as paving or shoulder cutting). There doesn't seem to be a fast and easy way to take a spreadsheet with these segments and offsets and integrate it into a map in ArcMap with State Roads shapefiles. The "Make Route Event Layer" in ArcTools doesn't have enough options to make a route correctly based on the Beginning Offset and End Offset. It won't accept the State Route Number as an acceptable field as the "Route identifier" field. Then, it is impossible to choose the Seg_Beg as the "from" and the Seg_End as the "to". Furthermore, it doesn't have option for two separate Offsets. I'm not very familiar with Linear Referencing, so perhaps I'm going about it wrong. In my past job, I used x,y coordinates exclusively. Not sure if anyone can help or point me in the right direction. I really can't get into a huge, complex solution however. If it's not simple and quick, it won't happen. (3rd party software? Work around?)
... View more
04-05-2017
01:12 PM
|
1
|
9
|
4226
|
Title | Kudos | Posted |
---|---|---|
1 | 04-05-2017 01:12 PM |
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:24 AM
|