Hey Sandro, Thanks for this, it is at least twice faster =)
Cheers, Rémi-C 2013/11/15 James David Smith <[email protected]> > 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 >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
