Am 23. Mai 2018 12:23:45 MESZ schrieb Stefan Blumentrath <[email protected]>: >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 <[email protected]> On Behalf Of >Veronica Andreo >Sent: onsdag 23. mai 2018 12.12 >To: grass-user <[email protected]> >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 [email protected] https://lists.osgeo.org/mailman/listinfo/grass-user
