I have a roads centreline layer (raw data table) constructed from a points layer. The centreline has the fields asset number, road number, road name and locality as well as other fields. Only the asset number and road number are unique. I’m currently in the process of breaking the road centrelines up into their respective road hierarchy classifications based on chainages.
I have a points layer (raw data table) that I derived the centrelines from consisting of a point every 10 to 20 metres which was collected in the field by a vehicle driven along the roads and has chainages, width, sealed\unsealed. One problem with this table is that it doesn’t have a unique ID to match against the centreline layer but I could spatially join these two layers. I think that will resolve that issue and will also then act as the nodes for the changes in width and seal. The points layer has a record number for every point plotted and a run number for every road which is unique within the points layer.
From these two base tables I need to construct a series of road surface footprints based on the centreline alignment. The footprints need to show width, sealed or unsealed surface, chainage and segment number accordingly.
I would prefer to use the “Create Parallel” instead of "Buffer" command as this will give me 90 degree angles on the footprint edges instead of chamfers.
The entire point data set consists of approx. 334,000 points equivalent to about 1500 roads. Some of the roads are non-continuous and have therefore been run in sections which provides a challenge for chainages.
Data Sets uploaded
Combined Points 22 Jan – raw data point table
Raw Centreline Data 22 Jan – centrelines derived from the point data
Road Surface Segments – final table
I am a complete beginner when it comes to writing scripts so any help would be much appreciated.
Kind Regards, Angelene