[GRASS-user] Display behavior of table attribute data

Rich Shepard rshepard at appl-ecosys.com
Wed Oct 6 08:24:57 PDT 2021

I learned something surprising this morning using a combination of the GUI
management window's map 'display table attributes' and db.execute.

The two adjacent bathymetric point files imported with a Z-int column with
type double precision for the integer depths. However, the depth values
displayed are in double precision format (ending in .00).

I added a new column, depth_int (type int), and copied (using SQL's 'alter
table') the Z-int double precision values to the depth_int column, then
deleted the Z-int column. The GUI's attribute table management dialog
confirmed that the depth_int is of type integer.

After re-displaying these maps the depth values are still double precision
while the column data type is integer. Oh well.


More information about the grass-user mailing list