Select to view content in your preferred language

create milepost feature class from road feature class that includes bmp and emp

4672
15
Jump to solution
01-05-2023 12:21 PM
L77
by
Frequent Contributor

I have a line feature class road dataset that includes beginning and ending miles posts. Some of the roads have beginning mileposts that don't start at zero, but start at something else like 1.52.

I need to create a milepost point layer, that I can publish in ArcGIS online in web app builder, that is generated from the road bmp and emp data in the road feature class.

I tried using the Generate Points Along Lines tool, but this doesn't seem to account for the lines that start with a BMP value that is greater than zero. It also doesn't label the points and there are over 2,000 of them so it would be time consuming to manually label them.

screenshot of tool:

Lorraine77_0-1672949177643.png

Here is an example of a road that begins at milepost 1.52 instead of zero.

Lorraine77_1-1672949338094.png

 

You can see that the 1st milepost is placed at the location of 2.52 instead of 1:

Lorraine77_2-1672949430086.png

 

Next I followed these instructions to draw hatch symbols along lines and it seems to works really well in Arc Pro, (except it didn't label two of my roads).

Is there a way to export the symbol marker layer as a feature class and have it keep the points and have it add the mile number in the attribute table?

Is there a better way to go about doing this?

Example of the two roads where the mile marker symbology didn't load:

Lorraine77_3-1672949966717.png

Lorraine77_4-1672949992880.png

Lorraine77_5-1672950021469.png

 

Thank you!

 

 

 

Tags (1)
0 Kudos
15 Replies
AyanPalit
Esri Regular Contributor

@GerhardMaree1 Does this thread help with your need to create mile markers along a calibrated route?

Ayan Palit | Principal Consultant Esri
0 Kudos
GerhardMaree1
Emerging Contributor

How would such a table look like as input.  My route was calibrated using mile markers. However the markers don't necessarily start at 1 and they differ for each route.  Would one need to create a separate table for each route with its 1/10 of a mile start and ends? 

0 Kudos
AyanPalit
Esri Regular Contributor

@GerhardMaree1 Each Route has its own start and end. Start measure is usually zero but can be non-zero and increase from that number through the end. Perhaps you can post a graphic / sample illustration of what the outcome should look like. 

Ayan Palit | Principal Consultant Esri
0 Kudos
GerhardMaree1
Emerging Contributor

Please see the image attached.

The red flags is the mile posts I used to calibrate the routes to.  The black dots is a 1/10 of a mile marker symbols placed at measured units along that route.  I basically want to export those black dots to a separate feature. Ideally using "create points along line" would be ideal but it still uses the distance and not the calibrated measure. 

Creating a table to state the measure fields where each route is unique in terms of start and end seems clunky for a fairly simple exercise. 

Regardless I will give it a try. Thanks @AyanPalit  

GerhardMaree1_0-1747804700169.png

 

0 Kudos
AyanPalit
Esri Regular Contributor

@GerhardMaree1 Thanks for posting the graphic. So you have the route calibrated correctly.

  • create a mile marker table with desired measure
  • use the Make Route Event Layer tool: used the Route ID column and the desired measure column

You can follow the example posted in this thread.

Ayan Palit | Principal Consultant Esri
0 Kudos
L77
by
Frequent Contributor

@GerhardMaree1A friend of mine helped me use chatgpt to create a milepost table, I don't know how to do it by myself to show you. He had it create a python script to run on my table of road numbers and BMP, and EMP, and he had it create 100 mileposts per mile. It did it very quickly.

Then I used the table in the Make Route Event tool to plot the points.

Then I exported the features to a new feature class, and that was the milepost layer.