I need to prepare a layout in arcmap, in which i have to show the table showing road stretch and width. Example - Stretch - Width 0 to 5 km - 10m, 5 to 12 km - 07m Like this.... I have segment wise length in my attributes, which is showing like a below image.enter image description here

For example road HHD68 starts with HHD68A at 0m and ended at 4019m, HHD68B started at 4019m and ended at 4053m, and so on up to HHD68M.

  • You might find it easier to complete your table in Excel and then embed it into your layout. The .dbf file of a shapefile can be opened by Excel but do not save, rather save as type XLS, saving a dbf in Excel will break the shapefile. – Michael Stimson Jul 18 '18 at 5:47
  • Do you want to 1) group road segments using field subroad ID and then classify each road by length or 2) classify road segments without grouping? – Mr. Che Jul 18 '18 at 6:34
  • @BERA Yes, it's not the same road, that is why i have arrowed only same road segments in above image, u can see that HHD68A length is 4019m, HHD68B is 33.97m, i need to represent in a table as a stretch in which 0 TO 4019 M and 4019 To 4053 m (4019 + 33.97 = 4053approx) and so on. How to do this? – rajesh kumar Jul 18 '18 at 6:51
  • @Mr.Che I need to classify each road segment (HHD68A) by it width. Example- HHD68A started at 0M and ended at 4019M its width is 10M, like wise HHD68B started at 4019M and ended at 4053M its width is 7M. How to do this? – rajesh kumar Jul 18 '18 at 6:53
  • @BERA I want to group by start and end point of that segment (Assumption - HHD68A is started at 0M and ended at 4019M, HHD68B started at 4019M and ended at 4053M, and so on upto HHD68M) highlighted A to C just to make professionals understand, Actually as u mentioned it goes up to HHD68M. – rajesh kumar Jul 18 '18 at 7:39

I think you have to write python function and run a field calculator with it.

As mentioned by Michael Stimson, if you need to do that once - the easiest way is to:

1) Copy table into excel.

2) Sort table by Sub road ID field

3) Create column Text in excel and using formulaes fill it with values you need.

4) Copy Text column values.

5) Create new text field in ArcGIS.

6) Paste Text values into vector file.

  • Thank you very much Mr. Che. really it worked. Thank you. – rajesh kumar Jul 18 '18 at 10:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.