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

[st_kiefer at web.de]

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 at 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 at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/grass-user