Re: [postgis-users] Checking Road Network Topology

2015-01-22 Thread Rémi Cura
Wow this seems like really impressive work, at a very cool scale! It is more or less the kind of tool I dreamt to have. Processing a 1.2 million topology is really not easy, I wonder if CGAL implementation is multiprocessed. Cheers, Rémi-C 2015-01-22 8:00 GMT+01:00 Paolo Cavallini

Re: [postgis-users] Possible for ST_Intersects to not include the perimeter?

2015-01-22 Thread toni hernández
Joseph, With St_Relate (http://postgis.net/docs/ST_Relate.html) we can get all kind of relations between geometries. You can get boundary intersections, interior intersections, interior intersections without boundary intersections all possibilities are supported. St_Relate uses the

Re: [postgis-users] Checking Road Network Topology

2015-01-22 Thread toni hernández
Steve, I had the same issue when working with geometries using srid=4326 . I was also following the same link (http://blog.mathieu-leplatre.info/use-postgis-topologies-to-clean-up-road-networks.html) Then I tried with some projected geometries (units = meters) and the problem was gone. I am

Re: [postgis-users] Possible for ST_Intersects to not include the perimeter?

2015-01-22 Thread Ben Madin
For two cents, a quick but inaccurate solution might be to shrink your polygon slightly by using st_buffer() with a negative radius? Ben On 22 January 2015 at 16:50, toni hernández t...@sigte.udg.edu wrote: Joseph, With St_Relate (http://postgis.net/docs/ST_Relate.html) we can get all kind

Re: [postgis-users] Checking Road Network Topology

2015-01-22 Thread Miller, Stephan
Thanks. I think I am ensuring the geometries are both projected to 32648 (zone 48N UTM). The tolerance being sent to topology.toTopoGeom is 1.0, presumably this is in meters. I will try the next run with 0.001 which is appropriate if the tolerance is being applied to 4326 coordinates

Re: [postgis-users] Checking Road Network Topology

2015-01-22 Thread toni hernández
Steve, I transformed the geometries into a new table. From there I created a new topology using the new reference system (25831) On 22/01/2015 16:35, Miller, Stephan wrote: Thanks. Here is the code as it now stands. I was using 4326 and topology will not work for geography coordinates.