[postgis-users] Grid of points inside Polygon

Rémi Cura remi.cura at gmail.com
Fri Nov 15 04:28:38 PST 2013


Hey Sandro,

Thanks for this, it is at least twice faster =)

Cheers,
Rémi-C




2013/11/15 James David Smith <james.david.smith at gmail.com>

> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131115/c3f0830d/attachment.html>


More information about the postgis-users mailing list