I have three shapefiles which represent a conduit network with valves and hydrants. The pipe grid consists of line features in a shapefile and the valves and hydrant each are a point layer in a shapefile.
For the planning of flushing proceedings I need to select some of the pipe elements (the line features) in a certain order which are to be flushed. The underlying attribute table of the pipe elements is also important for the planning process.
Ideally there is a way to create many different flushing selections (e.g. pipe no. 1-5, pipe no. 18-45, etc.) and save them in another layer, let's call it flushings. It is essential that the selection of pipes is assigned a new identifier the flushing ID.
So the flushing layer would contain flushing no. 1,2,3... with each flushing itself containing or refering to a previos made selection of pipe elements. I then would like to export the generated information of a pipe selection and an assigned flushing ID to either a shapefile or any other way which I can use in my PostGIS database.
pipe elements attribute table:
id material diameter 1 PE 80 2 PE 80 3 PE 100 4 PE 100
I need something like this in my database:
flushing_id pipe_id order f1 2 1 f1 3 2 f1 4 3 f2 1 1 f2 2 2 f2 3 3
Is there an easy workflow for pipe selection and assigning a flushing id to the selection to import it in a database later? It would also be helpful if each selection could be colored differently to make it easier to work with.