1

I have a network shapefile that between its vertices , there are edges that have multiple geometric objects. When I try to node it in postgis, it creates multiple segments in the database that topologically are actually one single edge.To clarify, imagine from node A to node B, I have one edge. In the database, this topologically one edge, has been divided into multiple segments and saved in the database. Could someone please let me know how I could reconstruct the network to have a network with singlepart edges in ArcGIS-Desktop or using any other tool?

8
  • You tagged ArcGIS but do not mention that in your question so I have removed it, because also note you should use ArcGIS-Desktop, not just ArcGIS. Can you confirm you are working with ArcGIS? When you say multiple edges, do you mean you have multipart lines, or that there are multiple lines stacked on top of each other for the same edge but they are separate records? I'm pretty sure tools exist in PostGIS, but I could only address those specific to Arc. There are solutions to both multiparts-to-singleparts/explode and with proper license level topology checks to correct stacked objects. – Chris W Jul 12 '15 at 20:02
  • I am working with both ArcGIS-Desktop and PostGIS. With saying multiple edges,database-wise, I mean there are multiple records for a topologically one edge (ARC). To make it clearer, I used pgr_nodenetwork and pgr_createTopology to create a topologically-right graph. It did work in terms of creating nodes in right position. However, each graph still consists of multiple records in the database. Also, I have tried multiparts-to-singleparts in ArcGIS-Desktop that did not what I needed to do. – Arash Kaviani Jul 12 '15 at 23:08
  • Have you got topologically equals edges. If so have you tried to add distinct predicate over edges geometries? – dmitry.v.kiselev Jul 13 '15 at 5:32
  • I am not sure if I truly understand you when saying topologically equal edge? But to clarify, imagine from node A to node B, I have one edge. In the database, this topologically one edge, has been divided into multiple segments and saved in the database. I think I need to edit the post to reflect it better. – Arash Kaviani Jul 14 '15 at 3:59
  • Although I finally ended up using dissolve in ArcMAP to deal with this issue, still happy to hear from any solution someone may have. – Arash Kaviani Jul 14 '15 at 4:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.