Breaking sections by chainage values

[IoannisLampropoulos]

Hi everyone,

quick question. I have a shapefile with the road network in terms of  road sections. Each section is represented by a unique field in the table. I am processing some data from Excel that include each section multiple times. Now, two important fields in the Excel are start Chainage and End Chainage. I need to break down the above sections into these "new sections" with regard to the chainage lengths and create a new shapefile. Each of these lengths represents a different value that needs to be plotted accordingly.

Thanks in advance...

[IoannisLampropoulos]

Thanks Neil, got rid of the spaces and the table is on. So the first part is achieved. Now, how am I going to relate this table with my initial shapefile? Remember that in my shapefile each section can be found once while in the table I created each section is found more than one times.

[NeilAyres]

Sorry, not with you.

In the route events layer, everything in both the original polyline and the route identifier should be there.

If you now want to make this permanent, right click on the event layer and export into your db.

[IoannisLampropoulos]

Yes Neil, you are right. Everything is in the table. I couldn't export it into a shapefile before and that's why I wanted to find a way to join my table with the existing shapefile. But yes, the table with the routes was exported just fine on its own.

Thank you very much Neil, Wes, and Chris.

Quick question since it crossed my mind. If I had a shapefile with say for example 1000 sections and needed to keep only 50 of them (just by knowing the names of the sections), what's the best way to do it?

[WesMiller]

Select Layer By Attribute—Help | ArcGIS for Desktop ​"RoadNameField" in (Roads,Separated, by ,commas)

[NeilAyres]

Or, in the mxd, copy the layer several times and use a definition query on each one.

[IoannisLampropoulos]

Thanks everyone. Question answered.

[ChrisDonohue__GISP]

One approach would be to split your line shapefile(s) up by specified distances and then join the table back to the appropriate segments (make a copy of the data and work on it).

Methods for splitting line features:

ArcGIS Desktop

Also, if you have the third-party Extension XToolsPro, they offer similar functions with a more automated means accomplishing them (Feature Conversions, Split Polyline).

Chris Donohue, GISP

[IoannisLampropoulos]

Fair enough Chris and thanks for the reply. What if I've got different distances to specify for each segment?