Dissolve keeping all attributes values (concatenation/aggregation)?

celati Laurent laurent.celati at gmail.com
Tue Sep 30 10:11:20 PDT 2025


Thanks.
The table union_v4 is in public schema.
When i execute SHOW search_path :

"$user", public

I'm taking the liberty to give an additional information regarding my needs.
In additional to preserve/keep all attributes duraing the dissolve, i would
like to dissolve polygonal geometries depending on the values on one
attribute.
In my case, this attribute is 'max_hierar'.
Thanks.

Le mar. 30 sept. 2025 à 17:37, Erik Wienhold <ewie at ewie.name> a écrit :

> On 2025-09-30 17:29 +0200, celati Laurent wrote:
> > But when i rerun the query with the edit (adding the closing
> parenthesis) :
> >
> > *SELECT     min(union_v4.max_hierar) as id,     array_agg(union_v4.id)
> >  as ids,     union_v6.geomFROM union_v4,    (SELECT
> >       (ST_Dump(St_multi(ST_Union(geom)))).geom as geom    FROM
> > union_v6)WHERE     st_intersects(union_v4.geom, union_v6.geom)GROUP BY
> > union_v6.geom*
> >
> > *I obtain this time the message : * ERROR: la relation « union_v4 »
> > n'existe pas LINE 5: FROM union_v4, ^ ERREUR: la relation « union_v4 »
> > n'existe pas SQL state: 42P01 Character: 105
> >
> > However, i have one table called "union_v4" within my postgis db.
> > thanks so much.
>
> * In which schema is union_v4 defined?
>
> * What is your current search_path setting?  Check SHOW search_path;
>
> --
> Erik Wienhold
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20250930/c02ee761/attachment.htm>


More information about the postgis-users mailing list