Postgis dissolve and keep values
Published On May 04, 2016
How to merge adjacent polygons of the same type keeping attributes?
This is a graphical idea of the problem.
The trick is to save all the grouped values into an array and then extract values from that array.
This is the query I have tested in a very simple case:
This is teh result you have:
This is the set query to run for the setup of this simple test case:
Look at this discussion on stackoverflow.
comments powered by