[GRASS-user] R.proj Problems Creating Table

[Dave Kindem]

Thanks Micha.  I can now create the table.

Dave

Dave Kindem
dkindem at gmail.com


On Jan 1, 2012, at 8:55 AM, Micha Silver wrote:

> 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
>> dkindem at gmail.com
>> 
>> 
>> 
>> 
>> This mail was received via Mail-SeCure System.
>> 
>> 
>> _______________________________________________
>> grass-user mailing list
>> grass-user at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/grass-user
>> 
>> This mail was received via Mail-SeCure System.
>> 
>> 
> 
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/grass-user/attachments/20120101/9b4fcb0f/attachment-0001.html