I'd like to join all adjacent geology faults within a table if they share the same attributes in f_type, f_class, f_name and f_conf columns. However I don't want to join adjacent lines with equal attributes if the line direction is different. I also don't want to join lines if they are intersected by more than one other line (is it correct to say if valence nodes are >2 don't join?). It actually gets more complicated but I'm hoping I can get started here --- even if I could just get going on the first part that would be great. I'm using postGIS for this.
Apparently I need a better reputation to post a picture (it's similar to this request Join intersecting lines with PostGIS... here I have described the picture I wanted to post... :/
Hopefully the picture helps. Lines with arrows are faults the lines traveling the same direction need to be joined as the attributes are the same (goal is to reduce # of rows in table). Notice the example attributes for the highlighted fault. Also notice the fault on the bottom faces the opposite direction and should not join. The contacts on the right are represented by dots. All the contact lines have the same attributes and should become on line. Direction is not important for contacts. Hope the picture helps.