Figure A below is the visual representation of what i have in my road data set. Line 1, Line 2, Line 3 in illustration are each represented as 1 row postgis DB inside a geometry column, some of these geometry fields are LINESTRING some of them are MULTILINESTRING. So i totally have 3 rows in database for Figure A.
What i would like to do is to convert this data set to Figure B. In Figure B Line 1 and Line 2 are each broken in to 2 lines since they intersect with Line 3.
After this operation i would like have 5 rows represented as lines in DB instead of 3. I have no clue on how to achieve this.
Figure A
Line 1-----------------------------------
|
|
| Line 2
Line 3-----------------------------------
Figure B
Line 1.1 -------- --------------------------- Line 1.2
|
|
| Line 3
Line 2.1 -------- --------------------------- Line 2.2
Of course this can be done easily after examining the data manually. Problem is i have 30K lines which need to be converted to more lines like this.
