[GRASS-dev] [GRASS GIS] #1208: v.to.db option=start/end fails to populate database

GRASS GIS trac at osgeo.org
Tue Nov 2 15:53:13 EDT 2010


#1208: v.to.db option=start/end fails to populate database
----------------------+-----------------------------------------------------
 Reporter:  voncasec  |       Owner:  grass-dev@…              
     Type:  defect    |      Status:  new                      
 Priority:  normal    |   Milestone:  6.4.1                    
Component:  Vector    |     Version:  svn-releasebranch64      
 Keywords:  v.to.db   |    Platform:  Linux                    
      Cpu:  x86-64    |  
----------------------+-----------------------------------------------------
 I am unable to upload the start or end coordinates of a line segment to a
 database using the v.to.db command.

 v.to.db map=IPLines_NorthBlock at IdealizedGrid option=start qcolumn=Start

 I have tested using the North Carolina database as follows:

 v.db.addcol map=busroute11 at PERMANENT columns=test double
 v.to.db map=busroute11 at PERMANENT option=end columns=test
 (Same error is reported for option=start)

 v.to.db -p does successfully print all of the coordinates

 Reading features...
 Updating database...
 DBMI-DBF driver error:
 SQL parser error: syntax error, unexpected '(', expecting
 NAME processing '('
 in statement:
 update busroute11 set  test = 637239.56871539, (null) =
 226030.942582791  where cat = 1
 Error in db_execute_immediate()
 1 categories read from vector map (layer 1)
 1 records selected from table (layer 1)
 1 categories read from vector map exist in selection from table
 0 records updated/inserted (layer 1)
 1 update/insert errors (layer 1)

-- 
Ticket URL: <http://trac.osgeo.org/grass/ticket/1208>
GRASS GIS <http://grass.osgeo.org>



More information about the grass-dev mailing list