[postgis-users] Grid of points inside Polygon

[Rémi Cura]

It should be finished by now,
can you check you have geom indexes on :
"ukmajrdbuffer.geom" and  "all_lines.the_geom"


How many geoms do you have in "ukmajrdbuffer"?

Cheers,
Rémi-C


2013/11/15 Rémi Cura <remi.cura at gmail.com>

> 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/14ce94f6/attachment.html>