Reputation
938
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
5 15
Impact
~32k people reached

9h
comment Postgis spatial join performance (point on area)
Update on actual tests seems that st_within is the winner in my cenario , i havent tried yet the recreation of the full table as @Nicklas Avén proposed. ST_Contains(po.geom, pt.geom) 34.2 secs execution time. ST_Intersects(po.geom, pt.geom) 36.2 secs execution time. ST_Within(po.geom, pt.geom) 21.4 secs execution time.
1d
comment Postgis spatial join performance (point on area)
@Vince you mean reversing it but using ST_Within() instead of ST_Contains ?
1d
comment Postgis spatial join performance (point on area)
adding a LIMIT 1000 at end of this query ; seems not to work. Any ideia how to limit this query ?
1d
comment Postgis spatial join performance (point on area)
they are not complex , but they are many and points are millions . Do you belleive this should be the most performant query for this operation ?
1d
asked Postgis spatial join performance (point on area)
Mar
31
answered FME 2016 - FeatureMerger, row data to columns
Mar
15
revised How to calculate width and lengths of street layer in Postgis/PostgreSQL?
code block expanded
Mar
15
suggested approved edit on How to calculate width and lengths of street layer in Postgis/PostgreSQL?
Feb
11
comment Qgis slow on loading project
As far as I understand when you start a project that has layers with no reference qgis warns you and will not load them, the layers do have geometry types set , It indicates on the bottom bar loading and name of the layer loading plus the he progress bar keeps stainless for wile on every layer that is loading . not sure what your millions are but I'm talking about layers of more than 50 million objects that I display at certain zoom levels only.
Feb
11
asked Qgis slow on loading project
Nov
27
awarded  Popular Question
Oct
27
revised Postgis poligonize. How to create polygon in postgis from linestring
some spelling
Oct
27
suggested approved edit on Postgis poligonize. How to create polygon in postgis from linestring
Oct
26
comment Compiling Postgis 2.2.0 on Raspian error doesn't install postgis extension
yes test did run. I edited the question (EDIT 1) copied the results of the tests , i think they failed. Correct i will list my self on the postgis users list , will probably have more audience. Thanks for all see you soon :-)
Oct
25
revised Compiling Postgis 2.2.0 on Raspian error doesn't install postgis extension
EDIT 1 : after results 'make check'
Oct
25
comment Compiling Postgis 2.2.0 on Raspian error doesn't install postgis extension
so i run the 'make check' - EDIT 1 :
Oct
24
comment Compiling Postgis 2.2.0 on Raspian error doesn't install postgis extension
Seems to complete with some warnings --- PostGIS is now configured for armv7l-unknown-linux-gnueabihf.configure: WARNING: --------- GEOS VERSION WARNING ------------ configure: WARNING: You are building against GEOS 3.3.3 configure: WARNING: To take advantage of all the features of configure: WARNING: PostGIS we recommend you build using configure: WARNING: GEOS 3.5.0 or higher. You can download configure: WARNING: the latest versions from configure: WARNING: trac.osgeo.org/geos configure: WARNING:
Oct
23
comment Compiling Postgis 2.2.0 on Raspian error doesn't install postgis extension
Dont remember if did , so did it again but still have no contrib dir. At the end of make install received this 2 lines > make[2]: Leaving directory '/temp_postgis/postgis-2.2.0/extensions/postgis_topology' > make[1]: Leaving directory '/temp_postgis/postgis-2.2.0/extensions' Expected or something else
Oct
23
comment Compiling Postgis 2.2.0 on Raspian error doesn't install postgis extension
that's what i was afraid , i have no usr/share/contrib/postgis-2.2 folder , this seems bad
Oct
22
asked Compiling Postgis 2.2.0 on Raspian error doesn't install postgis extension