On Wed, 7 Nov 2018, Markus Metz wrote:
I am afraid that manually adding a cat column and populating it with sequential numbers will not work: how do you assure that the cat numbers and corresponding attribute values indeed correspond to the cat values of the vector features? Chances are high that vector features get linked to wrong attributes.
Markus M, Grass told me the stations table has no categories, which it does not because the map's attribute table was derived from the pre-existing postgres database table and the geometry created by the easting/northing pairs in that table. The other maps and tables were created from agency-sourced GIS repositories and grass created cat columns for them, so it's only the stations table needing that column to be added.
db.select sql="select * from stations limit 3"
site_nbr|site_name|lon|lat|easting|northing|start_date|end_date|howmany|bin_col|cat 10332|Willamette R. at SP&S RR Bridge (Portland)|-122.7475|45.577944|||1979-11-06|2003-06-19|25|231:00:231| 10917|Pudding R. at Hwy 99E (Aurora)|-122.748972|45.233806|||1979-11-06|2008-03-26|22|231:00:231| 10376|McKenzie R. at Coburg Road|-123.046194|44.112722|||1980-05-07|2011-01-04|40|231:173:00| No cat values there now. But, updating the table and setting a distinct cat number for each site_nbr will fill that column. Thanks, Rich _______________________________________________ grass-user mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/grass-user
