[GRASS-user] reorder columns in vector attribute table

[Moritz Lennert]

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 not order. But I haven't looked at the code yet to understand what this would entail.

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