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