0
votes
1answer
64 views

How to union polygons and add attribute values of combined output features

I have a layer containing 10 polygons all overlapping at various locations. Each polygon has a value of '1' in a column called "value" How do I Union the polygons (rows) together such that the ...
1
vote
1answer
54 views

ST_Union to merge tables containing lines?

I have to build a street network with Postgis that will be used with pgrouting. I have two tables: 1) the_network (182 lines): is a MULTILINESTRING table. Having columns road_name (varchar) / ...
0
votes
2answers
279 views

postGIS union multiple tables, big dataset, faster approach?

my goal is simple. I want to union a given set of shapefiles. In the shapefile are stored polygons. The data bounding box is germany, so the data is relatively big. I tried to use all functions ...
1
vote
3answers
345 views

Is there a dissolve / ST_Union function that will close gaps between features?

I've been reading a number of related threads about ST_Union, ST_SnapToGrid and ST_Dump but I haven't been able to solve my problem. The problem is I am trying to merge Tiger/line census tracts that ...
2
votes
1answer
650 views

PostGIS Dissolve/Union close polygons

I have approximately 1 million polygons that have been split by lines. However, this has caused one half of a polygon to be separated by approximately 50cm from its other half. After doing a lot of ...
0
votes
1answer
173 views

st_linemerge does not work

I have two LINESTRING's which intersect by checking with st_intersects. Then i try to collect/union both linestrings into one Multistring, then try to merge with st_linemerge, but it fails with: ...
3
votes
2answers
375 views

PostGIS - ST_Collect but only include POLYGONs not POINTs?

In PostGSI, is there anyway to turn a GEOMETRYCOLLECTION into a MULTIPOLYGON by dropping all non-POLYGONs/non-MULTIPOLYGONs? I'm doing a query that cuts a bunch of geometries (using ST_Intersection) ...
7
votes
2answers
307 views

PostGIS Union Between Two Tables, Preserving Attributes

I'm trying to union US State level upper- and lower-level government boundaries in such a way that generates one PostGIS table with both the upper and lower level names for each shape. In my example ...
2
votes
1answer
214 views

Why doesn't PostGIS use gist index when doing a ST_DUMP(ST_UNION)?

My query: DROP TABLE IF EXISTS tmp; CREATE TEMP TABLE tmp AS SELECT *, ST_BUFFER(the_geom::GEOGRAPHY, 3000)::GEOMETRY AS buffer FROM af_modis_master LIMIT 20000; CREATE INDEX idx_tmp_the_geom ON tmp ...
5
votes
1answer
441 views

PostGIS - Why are my ST_Union results (stored in a new table) outputting as points and not polygons?

I've decided to move to PostGIS to merge polygons rather than spend hours doing in in QGIS. However, I'm hitting an issue where the results of an ST_Union query are being stored, or at least outputted ...
4
votes
2answers
328 views

PostGIS algorithm to unite points of two geometries that are within specified radius

I want to find an PostGIS algorithm to unite points of two geometries that are "near" to each other. That is: I want a function, that takes as input two geometries, and returns 1 geometry, that ...
2
votes
2answers
1k views

Merge polygons in postgis

I have a hand-digitized coverage stored in postgis. There, I have a few shiver-polygons I would like to get rid of by including them into one of the neighbouring polygons. are there any commands that ...
5
votes
3answers
322 views

Trying to combine nearby points into a polygon

We have collected millions of cell phone strength readings. I am trying to group points of the same strenght that are within a distance of each other in to a polygon. I asked on the postgis mailing ...
4
votes
2answers
532 views

memory issue when trying to buffer/union large dataset using postgis

I am trying to generated a dissolved buffer of a large point dataset (Ideally 29 million points - Address data in Great-Britain, but I receive the data by chunks of 1 million points, so these could be ...