[GRASS-user] v.to.db: values not added to table

Rich Shepard rshepard at appl-ecosys.com
Fri Nov 2 12:55:48 PDT 2018


   Using 7.7.svn and pg.connect -p reporting the database is postgres.

   The table 'stations' currently has six attribute columns: site_nbr,
site_name, lat, lon, easting, and northing (the last two added using psql.)

   To add easting and northing values to the table I ran v.to.db with this
result:

v.to.db map=stations op=coor col=easting,northing units=meters --o
WARNING: Values in column <easting> will be overwritten
WARNING: Values in column <northing> will be overwritten
Reading features...
  100%
Updating database...
  100%
82 categories read from vector map (layer 1)
82 records selected from table (layer 1)
82 categories read from vector map exist in selection from table
82 records updated/inserted (layer 1)

which looks encouaging. But, when I query the database there are no values
in the easting and northing columns:

# select * from stations limit 5;
  site_nbr |                   site_name                   |     lon     |
   lat    | easting | northing 
----------+-----------------------------------------------+-------------+--
---------+---------+----------
  10332    | Willamette R. at SP&S RR Bridge (Portland)    | -122.747500 | 4
5.577944 |         |
  10335    | Willamette R. at Staff Jennings Marina        | -122.664139 | 4
5.466111 |         |
  10339    | Willamette R. at Canby Ferry                  | -122.690722 | 4
5.300333 |         |
  10340    | Willamette R. at I-5 (Wilsonville)            | -122.768194 | 4
5.291944 |         |
  10342    | Willamette R. at Hwy 219 (new Newberg bridge) | -122.942361 | 4
5.267639 |         | 
(5 rows)

   What have I missed here?

TIA,

Rich


More information about the grass-user mailing list