[GRASS-user] tables connection in database
mlennert at club.worldonline.be
Tue Jun 30 10:07:42 EDT 2009
On 26/06/09 16:38, achim wrote:
> Thats exactly the problem: It shows nothing.
> None of my lines has any cat.
Well, then you need to add them with 'v.category option=add'
> Moritz Lennert wrote:
>> On 26/06/09 15:24, achim wrote:
>>> Hi Moritz,
>>> thanks for reply and this detailed explanation.
>>> I try to report my problem with an example:
>>> reset to initial point
>>> v.db.connect -d map=my_lines at achim
>>> db.droptable -f table=testtable
>>> | Type of Map: vector (level: 2)
>>> | Number of points: 0 Number of areas: 0
>>> | Number of lines: 2326 Number of islands: 0
>>> | Number of boundaries: 0 Number of faces: 0
>>> | Number of centroids: 0 Number of kernels: 0
>>> | Map is 3D: No
>>> | Number of dblinks: 0
>>> Number of nodes: 2410
>>> (with grass65 wx-gui)
>>> v.db.addtable map=my_lines at achim table=testtable
>>> Using user specified table name: testtable
>>> Creating new DB connection based on default mapset settings...
>>> Creating table with columns (cat integer)
>>> The table <testtable> is now part of vector map <my_lines at achim> and
>>> may be deleted or overwritten by GRASS modules
>>> Select privileges were granted on the table
>>> Reading features...
>>> Updating database...
>>> 0 categories read from vector map (layer 1)
>>> 0 records updated/inserted (layer 1)
>>> Current attribute table links:
>>> layer <1> table <testtable> in database </home/achim/grass/sqlite_db>
>>> through driver <sqlite> with key <cat>
>>> Vector map <my_lines at achim> is connected by:
>>> ?here no records updated/inserted
>> Probably none of your lines have categories. What does v.category
>> my_lines option=report show ?
More information about the grass-user