I'm returning to the same question all over again. I'm dealing with electrical network and I'd like to build topology for all network lines in database so I can construct nodes and edges dynamicly for network calculations.
What I have is 2D geography for lines and plenty of different types of points that should together build topology. What I need is a proper way to build nodes and construct edges where endpoint touches other line (with tolerance) or two endpoints touch. I've ended up writing SQL script that does that (uses lots of resources for 100.000 lines). I wonder if there is a better solution using topology?
For what I understand Topology-Geometry does not allow two edges to intersect, so this kind of topology is not useful for infrastructure/utility where conductors, pipelines or even roads cross each other but there is no "node".
So, is there Topology-Network for PostGIS implemented or there is no such thing yet? I remember I solved this problem in SpatiaLite back then for research purposes.