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

Delete existing Centerlines which are associated to routes (Roads and Highways Extension)

PeterStiegler2

Hello Departments of Transportation‌ ‌ Team

I have a question about deleting centerlines which are associated to routes. I know there is the possibility to work with date, so that the centerline is no longer displayed. In that case, however, the geometry will be removed.

Is there a suitable workflow for this?

Is it sufficient to remove the Centerline ID from the Centerline table and then delete the geometry? Shown in the screenshot.

Is there anything to consider?

I would be very happy about a solution.

Many thanks in advanced.

Peter@

Find more posts tagged with

Accepted answers

All comments

PeterStiegler2

Hi Nathan and Clive

thank you very much for your help and that detailed information. I will try the option to reload route.

Of course i will test that in my test ALRS geodatabase enviroment.

Thank you very much!

Peter

CliveReece

Hi Peter,

Seems like Reload route is still a good option, although Retire Route (portion) backdated to when you first introduced the 'bad' centerline is an alternative. Either way, I would recommend you testing each option out in a test ALRS geodatabase environment.

Realign Route using a correct centerline is yet another option (setting the date to when the 'bad' centerline was introduced.

Clive

NathanEasley

Hi Peter,

In order to remove a centerline, you need to remove any route associated with it. In the Roads and Highways information model, the centerlines provide the geometry for routes. If you just deleted the centerline, you could have routes with incorrect geometry (due to missing centerlines) and even have calibration points no longer located on the route (which would result in no or incorrect calibration). Because the centerlines are the building blocks for the routes, in order to remove a centerline, you must also remove any dependent routes that use that centerline for their geometry.

As mentioned in previous posts, there are a few different ways to remove the centerline. I would encourage you to choose the method that best aligns with your business processes to complete the removal of the erroneous centerline.

Thanks,

Nathan

PeterStiegler2

Hi Clive

the Centerline was created by a mistake and assigened to a route. So the geometry must be deleted to clean up the database. Therefore Retire Route is unfortunatley no option.

If I understand correctly, I have to delete the whole route (With Delete Routes) and reload only those centerlines (Create a Backup from the Existing) that are desired?
Is there not a better workflow for this? For customers, this is a bit inconvenient. My described workflow is not working?

Many thanks

Peter

CliveReece

Hi Peter,

Perhaps we need to revisit what the purpose is for deleting one of the centerlines that compose the route?

One thought is you could use the R&H activity Retire Route to retire the portion of the route that covers the centerline. Another option would be to reload the route in question without the portion that covers the undesired centerline geometry. Temporality would need to be considered when reloading.

However, it's hard to say which is the better approach without knowing more about what you are trying to achieve.

Thanks in advance,

Clive

PeterStiegler2

Hi Nathan,

many thanks for your response.

I know the tool delete routes. In this case I do not want to delete the route but only one centerline. The route consists of several centerlines.

There is also the delete Centerline Tool but you can use the tool if you have no affiliation to a route.

So thats the point that i would use the described workflow above. Is this not suitable?

Many thanks

Peter

NathanEasley

Hi Peter,

There is a geoprocessing tool within the Roads and Highways toolbox to handle this exact case you're mentioning above. The delete routes tool will make sure that all records related to the route/centerline combination you want to delete are removed correctly (http://desktop.arcgis.com/en/arcmap/latest/tools/location-referencing-roads-toolbox/delete-routes.htm) from the geodatabase. I would encourage you to use this tool to complete your workflow. Just select the route (or routes) that are associated with the centerline you want to remove from the system and make sure to check the delete associated centerlines option in the tool.

Good luck.

Nathan

Esri Roads and Highways team

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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