How do I create a boundary points layer with updated Highway Postmile values?

5628
35
11-02-2016 05:47 PM
DanielBrenner
Occasional Contributor

I have a polyline layer for State Highways and a polygon layer of Urban Areas.   I need to create a points layer where the highways intersect the boundaries of the Urban Areas.  

Also, the highways layer has Postmile values in it.   When I create the "boundary points" layer, I need to have updated Postmile values.

For example:  If I have a Highway with Begin Postmile = 0 and End Postmile = 19, if the Highway intersects the boundary of the Urban Area at 6, then my Points layer should have fields looking like this:

BEGIN  END

0            6

6            10

I have done something similar using another software but I'd like to think its simpler in ArcGIS.

Thanks,

Dan B

0 Kudos
35 Replies
DanielBrenner
Occasional Contributor

Correct.

Thank you,

Daniel T. Brenner

RESEARCH ANALYST I (GEOGRAPHIC INFORMATION SYSTEMS)

DIVISION OF RESEARCH, INNOVATION, and SYSTEM INFORMATION

Highway System Information and Performance

1120 N Street MS 38

Sacramento, CA 95814

(916) 657-4277

(510) 593-7547 cell

daniel.brenner@dot.ca.gov

“Consider the unconsidered.”

“Certainty is not a sure thing!”

0 Kudos
RichardFairhurst
MVP Honored Contributor

So to be clear, please separately confirm that you had no LRS routes based on postmiles already created prior to posting this issue.  If that is the case, then I am assuming that the postmile values in your fields were measured/estimated by field staff relative to actual mile posts or by some other means that did not involved using LRS techniques and route calibration.  Do you have any point layer for the actual mile posts positions that can be used for calibration in addition to the polyline end points?  If such points exist between the end points of your lines they could alter the accuracy of the postmile distances interpolated between the line end points.

Please let me know if the following example accurately describes what you want to accomplish.

1.  Say I have a highway made up of 5 polyline segments with the following from and to postmiles.

0 to 2

2 to 5

5 to 8

8 to 12

12 to 19

2.  If the urban boundaries intersected these segments at postmile positions 1 to 6 inclusive and 10 to 17 inclusive that would produce the following segments designated either Rural or Urban as follows:

0 to 1 Rural

1 to 2 Urban

2 to 5 Urban

5 to 6 Urban

6 to 8 Rural

8 to 10 Rural

10 to 12 Urban

12 to 17 Urban

17 to 19 Rural

3.  If I ignore the Rural segments and just extract the 5 Urban segments I would create two new fields to hold the reapportionment of the Urban postmile measures.  I would continue to use the first postmile measures of 1 to 6 for the first sets of 3 urban segments, but I would adjust the postmile measures of the second set of 2 urban segments to eliminate the postmile offset created by the gap separating it from the first set of urban segments.  So taking just the 5 urban segments I would have a polyline with two fields showing the original postmile measures and two fields showing the reapportioned postmile measures as follows:

1 to 2 original urban and 1 to 2 reapportioned urban

2 to 5 original urban and 2 to 5 reapportioned urban

5 to 6 original urban and 5 to 6 reapportioned urban

10 to 12 original urban and 6 to 8 reapportioned urban

12 to 17 original urban and 8 to 13 reapportioned urban

Total Urban postmiles = Beginning at original highway postmile 1 there are 12 Urban postmiles covered by these polylines (To postmile minus From postmile = postmile 13 - postmile 1 = 12 postmiles).

If the above example is a correct presentation of what you want to do, this can be done using LRS techniques to obtain the postmile segments of section 2, but you would need a custom Python script to perform the steps needed to create the output shown in section 3.

0 Kudos
DanielBrenner
Occasional Contributor

You are somewhat on the right track but there is a key point you are

missing( although I need to clarify an issue on my end as well). Please go

back to the very beginning.

The key problem with the line work right now is that there are a good

number of segments (the layer is 2500+ segments BTW) that cross urban

boundaries. I need the segments to BREAK at urban boundaries after the

polylines have been aggregated into another total value.

Your examples in #1 and 2 are what I need, and I am even figuring that I

do need new fields for the new measurement values, but the

"reapportionment" stuff (and needing a Python script) is messing things up.

I will be in the Office in the next hour or less and can tell you more.

Thank you for your efforts. Can you doenload the routes and cities layers

from an earlier email?

0 Kudos
RichardFairhurst
MVP Honored Contributor

I am not sure what earlier e-mail you are referring to that contains links for downloading the routes and cities layers.  I have scanned the posts in this thread and am unable to pick out any post that has provided such a link.  If I have overlooked it please provide the date and time of the post.

The reapportionment step is where the thread got confusing for me.  I see no way to avoid a Python script for that step given the calibration requirements you have emphasized. However, using a Python script does not necessarily mess things up.  In fact I would recommend writing a Python script to do the entire process so that it can be repeated easily in the future as the Urban boundaries and highway network continue to change.  A well written Python script will document your process, provide a huge performance gain and can ultimately make that last update step as easy as pressing a button.

Also in an earlier post you mentioned that you offset the rural segments from the urban segments by a distance of 0.001 miles to separate the ends of the polylines.  However, that amount of offset translates to over 5 feet of separation, which would create a significant sink hole if that amount of pavement was to open up and separate in the real world.  If you insist on applying an artificial offset to separate the end points of the lines I would recommend that you reexamine your resolution and tolerance settings and consider an offset value closer to the equivalent of a crack in the pavement, not a sink hole.

0 Kudos
DanielBrenner
Occasional Contributor

Richard,

For the time being, just as a basic FYI, just in case it might be an

issue, I would hold off on putting in any more effort on the question I am

having as I just heard I need to use the Odometer measures instead of the

Postmiles, which may lead to different end results which also may not be as

hard to ascertain.

I will be in touch again if I need your assistance.

Thanks again and again for your help.

Daniel Brenner

0 Kudos
DanielBrenner
Occasional Contributor

Richard,

THANK YOU for everything you have done. I was pleasantly frazzled to see

as much as you did on the Weekend (couldn't drink fast enough while my

favorite College Football team went down in the rain).

Apologies if this isn't ArcGIS centric but this is a video that comes

veryclose to what I need (points at boundaries with correct

measurements). It is for a product called Geomedia Professional 2014.

Have a pleasant 4 day weekend.

Cheers,

Daniel Brenner

Vid_3_Getting_New_Points.zip

<https://drive.google.com/file/d/0BylRmhhZJe0wZUFWWmFXTFFaQXM/view?usp=drive_web>

0 Kudos