Questions tagged [st-union]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
22 views

Counting geometries which intersect another geometry using PostGIS

I'm trying to calculate the total area for each layer I have within a specific area and count the geometries which intersects with that specific area. I can calculate the area and the results seem ...
2
votes
0answers
33 views

Virtual layers w/ spatial query not working as before (3.18.1 vs 3.20.3)

I have a set of maps that intensively utilizes virtual layers, but last week our boss updated from QGis 3.10/3.18 to 3.20.3 in all PCs, and now the layers are not loading. Normally they would refresh ...
0
votes
1answer
71 views

Using ST_Union to aggregate polygon parts resulting of ST_SubDivide leads to a GEOS TopologyException

Follow up on this topic: Optimizing an intersection between a single massive multipolygon (WKT) and many features from PostGIS I noticed I have to run an ANALYZE (not VACUUM ANALYZE!) on the table for ...