Am 30.01.2021 um 19:20 schrieb Tomas Straupis:
Hi Tomas,
> This is also good, but it is not exactly what I ment.
> You cluster polygons with a distance of say 10m, simplify and buffer+- them.
> Then you cluster THE RESULT of the first action again but now with a
> distance of say 40m, simpl
2021-01-30, št, 15:56 Luca Bertoncello rašė:
>> 1. Reduce the number of vertexes in a polygon (say use st_simplify,
>> st_snaptogrid or other functions which reduce number of vertexes)
>
> I already did that with a query you suggest me:
>
> UPDATE city_boundaries SET way =
> ST_Multi(ST_Simplif
>
>
>
> UPDATE city_boundaries SET way = ST_Makevalid(ST_Buffer(ST_Buffer(wayn1,
> 50, 'join=miter'), -50, 'join=miter'));
>
quick side note: you are not expected to need MakeValid after Buffer. If
you ever have an invalid as an output of Buffer, that has to be reported as
a bug with specific inpu
Am 30.01.2021 um 14:50 schrieb Tomas Straupis:
Hi Tomas,
> If a polygon is too complex (which means it has too many vertexes),
> then you have several directions of actions:
> 1. Reduce the number of vertexes in a polygon (say use st_simplify,
> st_snaptogrid or other functions which reduce n
2021-01-30, št, 14:21 Luca Bertoncello rašė:
> Specially the first seems to need a huge amount of RAM and a fast CPU...
> Some polygon are very complex...
If a polygon is too complex (which means it has too many vertexes),
then you have several directions of actions:
1. Reduce the number of ve
Am 30.01.2021 um 13:00 schrieb Darafei "Komяpa" Praliaskouski:
Hi
> for one-offs, there can be done on huge computer in Google Colab:
> https://colab.research.google.com/gist/Komzpa/fb24368a746854e53ebf79481dc24f18/postgis-on-colab.ipynb
This could be interesting...
But I can't understand how I
Hello Luca,
for one-offs, there can be done on huge computer in Google Colab:
https://colab.research.google.com/gist/Komzpa/fb24368a746854e53ebf79481dc24f18/postgis-on-colab.ipynb
Another thing to check is that if it is really a memory issue: you can't
have intermediate results more that 1GB per
Hi Luca,
I might be able to help you with this,
Sent me some details of your project and requirements, and let's see if we
can move this forward
Best,
Nikos
On Sat, 30 Jan 2021, 11:44 Luca Bertoncello, wrote:
> Hi list!
>
> It seems that the generating of an help table with some data for Euro
Hi list!
It seems that the generating of an help table with some data for Europe
need too much resources and the PC I use for that (4 cores and 16 GB
RAM) doesn't have enough...
The table is ~130MB and has ~108.000 entries, so not really big, but the
"aggregation" with the PostGIS functions is to
