1,535 reputation
218
bio website
location
age
visits member for 2 years, 11 months
seen 2 hours ago

May
22
revised Why the execution of a query is very slow using PostGis?
deleted 15 characters in body
May
22
comment Why the execution of a query is very slow using PostGis?
I did some tests with two layers (4M and 800K rows). It took 1060545,590 ms to write the output of 3.3G to a file. However, I had to adjust my swap space as postgresql was running out of memory. And I am running on SSD hard drive.
May
22
revised Why the execution of a query is very slow using PostGis?
added 107 characters in body
May
22
revised Why the execution of a query is very slow using PostGis?
deleted 1 character in body
May
22
answered Error when creating new view using ST_Union (PostGIS)
May
22
comment Why the execution of a query is very slow using PostGis?
If it works as expected, please mark the answer as correct. Thanks.
May
22
revised Why the execution of a query is very slow using PostGis?
remove alias from having clause
May
22
comment Why the execution of a query is very slow using PostGis?
distance is not a column, it is just an alias for a.geom <-> b.geom. Answer update - column alias from having clause removed.
May
22
comment Why the execution of a query is very slow using PostGis?
my answer updated
May
22
revised Why the execution of a query is very slow using PostGis?
added 245 characters in body
May
22
answered Why the execution of a query is very slow using PostGis?
May
21
comment how to insert area of polygon into a column named area in a polygon map in cartodb?
Are you sure you did not forget to use semicolon at the end of the query?
May
15
answered QGIS how to delete virtual fields?
May
2
comment How to fix broken geometry after joining features in PostGIS
Is it possible mapshaper corrupts topology? If so, it might be better to generalize geometries with GRASS. You can try to run ST_MakeValid after doing union, it might help.
Apr
24
answered Change name of category heading in legend
Apr
18
answered POSTGIS query - extracting common point from polygon data
Apr
12
answered Problem with a PostGIS trigger
Apr
6
comment ST_MakePoint returns an error when using Python
Does it work with raw SQL, e.g. without using python?
Apr
6
comment GeoDjango: Find all points within radius?
No it is not, this ratio only works for equator.
Apr
6
comment ST_MakePoint returns an error when using Python
You say casting doesn't seem to help either. What did you cast it to? double precision?