Reputation
1,750
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
5 19
Newest
 Enthusiast
Impact
~32k people reached

Aug
31
comment How to create a bounding box around a point using postgis
What CRS do you use?
Aug
31
answered How to create a bounding box around a point using postgis
Aug
27
comment Snapping points to nearest road - query is extremely slow
If you don't use spatial indexes, each geometry from table A is compared to each geometry from table B. You definitely don't want to do that. That's also the answer to your second question: the more geometries you have (not indexed) the more st_dwithin calls, the slower it becomes.
Aug
27
comment Snapping points to nearest road - query is extremely slow
Have you built spatial indexes on both tables? ST_Distance is known to be slow, I guess you could get away with spatial operators, but they might not be suitable for your use case.
Aug
19
answered ST_Intersects not working with ST_Expand from a point
Aug
19
answered Rule based labels using QGIS?
Aug
19
comment Problem with PostgreSQL View layer in QGIS
And if you do some edits? Still no messages from the database?
Aug
19
comment Problem with PostgreSQL View layer in QGIS
Could you share message log from your postgresql database? The one from QGIS View -> Panels -> Log Messages would suffice.
Aug
19
comment Problem with PostgreSQL View layer in QGIS
Views in Postgresql can't have primary keys. If you have a look into messages PostGIS sends when you try to add the layer, you probably see something like "No primary key defined for table_name".
Aug
18
answered Problem with PostgreSQL View layer in QGIS
Aug
18
answered How to calculate the form (or shape) factor of a polygon?
Aug
15
comment PostGIS connect points to 1 closing/bounding line
How about postgis.net/docs/ST_ConvexHull.html then? :-)
Aug
15
comment PostGIS connect points to 1 closing/bounding line
Have you seen postgis.net/docs/ST_ConcaveHull.html?
Aug
4
answered Avoid intersection is missing QGIS 2.10, 2.8.2
Jul
28
comment Find Overlap Between Two Polygons
Please see the docs :-)
Jul
28
answered Find Overlap Between Two Polygons
Jul
28
awarded  Enthusiast
Jul
27
comment ST_Union based on attribute
Use ST_Multi() to promote linestrings to multilinestrings.
Jul
27
answered ST_Union based on attribute
Jul
27
comment Postgis ST_AsSVG renders a tiny SVG
Might this be of any help?