Thanks both. Geometries now fixed. The query 'CREATE TABLE lines_for_each_road....' has now been set running. Will report back when it's done. I suspect it may take a while!
James On 15 November 2013 11:03, Sandro Santilli <[email protected]> wrote: > On Fri, Nov 15, 2013 at 11:50:42AM +0100, Rémi Cura wrote: >> Yep, maybe something like >> >> UPDATE ukmajrdbuffer SET the_geom = ST_MakeValid(the_geom) >> WHERE ST_IsValid(the_geom) = FALSE > > ST_MakeValid internally checks for ST_IsValid, so no need > to add the condition (which would run the test twice). > > --strk; > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
