[GRASS-user] reorder columns in vector attribute table

[Markus Metz]

On Wed, May 23, 2018 at 12:41 PM, Moritz Lennert <
mlennert at club.worldonline.be> wrote:
>
>
>
> Am 23. Mai 2018 12:23:45 MESZ schrieb Stefan Blumentrath <
Stefan.Blumentrath at nina.no>:
> >Ciao Vero,
> >
> >Unfortunately, it seems you have to create a new table with desired
> >column order, copy data into it (INSERT INTO FROM SELECT) and then link
> >the new table to your vector map (v.db.connect)…:
> >
https://stackoverflow.com/questions/20574113/sqlite3-how-to-reorder-columns-in-a-table
>
> Personally I would consider this as a bug. v.patch should match columns
by names
and type
> not order. But I haven't looked at the code yet to understand what this
would entail.

in theory this (ignore order, check name+type match) is easy to implement.
Please open a ticket.

Markus M
>
> Moritz
>
>
> >
> >Note that SQLite will launder column names to lower case if you don`t
> >quote them. Then they may not match even if in proper order
> >(speculating here)…
> >
> >Cheers
> >Stefan
> >
> >From: grass-user <grass-user-bounces at lists.osgeo.org> On Behalf Of
> >Veronica Andreo
> >Sent: onsdag 23. mai 2018 12.12
> >To: grass-user <grass-user at lists.osgeo.org>
> >Subject: [GRASS-user] reorder columns in vector attribute table
> >
> >Hi all,
> >
> >I want to use v.patch -e to patch geometries and attributes of polygon
> >maps belonging to different states in Australia and the column names in
> >the attr tables are the same (they only vary in the order in which they
> >are) but when making an attempt, I get:
> >
> >v.patch -e input=act_bushfire_2012_2017,tas_bushfire_2012_2017
> >output=test
> >ERROR: Column names differ
> >
> >Column names here:
> >
> >v.db.select tas_bushfire_2012_2017 | head
> >cat|FIRE_TYPE|OBJECTID|START_DATE|END_DATE|STATE|AREA_ha|PERIMETER_km
> >
> >v.db.select act_bushfire_2012_2017
> >cat|OBJECTID|FIRE_TYPE|START_DATE|END_DATE|STATE|AREA_ha|PERIMETER_km
> >
> >only OBJECTID and FIRE_TYPE are shifted.
> >
> >Is there an easy way to reorder columns in the attribute table of a
> >vector map?? I thought v.patch would match column names in the attr
> >table...
> >
> >Thanks much in advance,
> >Vero
> _______________________________________________
> grass-user mailing list
> grass-user at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/grass-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20180523/09092747/attachment-0001.html>