[postgis-users] Grid of points inside Polygon

[James David Smith]

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 <strk at keybit.net> 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
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users