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