[Qgis-user] Easy way to use categorical classification on 'array' type fields?
Greg Troxel
gdt at lexort.com
Thu Mar 6 04:47:06 PST 2025
Richard Duivenvoorde via QGIS-User <qgis-user at lists.osgeo.org> writes:
> We have vector data with one field in that data which is an "n array of (freeform) tags"...
>
> So having 10 records, we may have 30 different tags.
>
> Is there a way to 'explode' those records within QGIS (without manipulating the source), so we could create a 'classification' of all individual tags...
> My idea would be to see a record with 3 tags then 3x in QGIS, but being able to only check ONE of the tags, my user could view the data base on individual tags...
If you're willing to store this in postgresql/postgis, you can probably
create a view to do this reasonably easily. Then you aren't changing
the source, or needing to synchronize, but you can still have a single
tag column and multiple rows.
postgresql also has hstore, but I don't think that's what you want:
https://www.postgresql.org/docs/current/hstore.html
More information about the QGIS-User
mailing list