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

GRASS GRASS user
1

   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

2

Hi Rich,
do you still have trouble filling the columns? You probably should give also the type of the feature for the query, like type=point.

v.to.db map=stations op=coor like type=point col=easting,northing units=meters --o

If this is not successfull you might have to (re)build topology (v. clean, v.build).

Regards.

Stefan

Rich Shepard <rshepard@appl-ecosys.com> hat am 2. November 2018 um 20:55 geschrieben:

   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
_______________________________________________
grass-user mailing list
grass-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/grass-user

3

On Mon, 5 Nov 2018, st_kiefer@web.de wrote:

v.to.db map=stations op=coor type=point col=easting,northing units=meters
--o

Stefan,

   Thank you. I assumed that default type and units did not need to be
explicitly stated. They do. Adding those two to the command did the job.

Regards,

Rich