I have a sewer network comprising:
- Manholes - a points layer
- Pipes - a polyline layer, with attributes comprising the upstream and downstream manhole
I have a spreadsheet of pipe defects (from a CCTV contractor), where each defect is identified by the following data. Each defect is logged on a separate line with the following attributes:
- Pipe ID
- Starting Manhole
- Ending Manhole
- Distance from Starting manhole
- A range of attributes on observations made
I want to create a set of points for each defect so that I can then analyse the defects. As there can be a huge number of defects, I want to create a workflow to bring the points into QGIS so I can prioritise them.
I can see how to generate points at vertices, crossings or equidistant. However I am not certain where to even start in this task.