On 01/01/2012 15:43, Dave Kindem wrote:
Hello,

I have created a vector layer from a database table in an XY location (accidents_xy).  Both the topology and a database table (accidents_xy) seem to have been created correctly.  When I try to re-project the layer into a UTM location using r.proj, I receive the following error:

GRASS 6.4.1 (GRGHM_UTM):~ > v.proj input=accidents_xy location=InterurbanTest output=accidents_utm
DBMI-SQLite driver error:
Cannot create table:
create table sqlite.accidents_utm ( Name text, cat integer, Longitude double precision, Latitude double precision, Type text, Description text )
unknown database sqlite

Probably you have to first create an empty sqlite database. Check what your db parameters are with: "db.connect -p"
Then run "sqlite3 <path/to/database>"
Where the path is from the above. Probably by default something like: ~/grassdata/GRGHM_UTM/<mapset>/sqlite.db


WARNING: Unable to create table <sqlite.accidents_utm>
WARNING: Unable to copy table <sqlite.accidents_utm>
WARNING: Failed to copy attribute table to output map
Building topology for vector map <accidents_utm>...
Registering primitives...
62 primitives registered
62 vertices registered
Building areas...
 100%
0 areas built
0 isles built
Attaching islands...
Attaching centroids...
 100%
Number of nodes: 62
Number of primitives: 62
Number of points: 62
Number of lines: 0
Number of boundaries: 0
Number of centroids: 0
Number of areas: 0
Number of isles: 0
GRASS 6.4.1 (GRGHM_UTM):~ > 

The topology layer is created and displays (accidents_utm), but there is no database table.   I am running GRASS 6.4.1 and the Python GUI on a Mac, OS X 10.6.8.

Thanks for any suggestions about how to resolve the issue.

Dave

Dave Kindem




This mail was received via Mail-SeCure System.


_______________________________________________
grass-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/grass-user

This mail was received via Mail-SeCure System.



_______________________________________________
grass-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/grass-user

Reply via email to