<html style="direction: ltr;">
<head>
<meta content="text/html; charset=windows-1255"
http-equiv="Content-Type">
<style>body p { margin-bottom: 0cm; margin-top: 0pt; } </style>
</head>
<body style="direction: ltr;"
bidimailui-detected-decoding-type="preferred-charset"
bgcolor="#FFFFFF" text="#000000">
On 01/01/2012 15:43, Dave Kindem wrote:
<blockquote
cite="mid:84D60B76-26E4-450E-8568-90A26D9D231B@gmail.com"
type="cite">Hello,
<div><br>
</div>
<div>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:</div>
<div><br>
</div>
<div>
<blockquote type="cite">
<div>GRASS 6.4.1 (GRGHM_UTM):~ > v.proj input=accidents_xy
location=InterurbanTest output=accidents_utm</div>
<div>DBMI-SQLite driver error:</div>
<div>Cannot create table:</div>
<div>create table sqlite.accidents_utm ( Name text, cat
integer, Longitude double precision, Latitude double
precision, Type text, Description text )</div>
<div>unknown database sqlite</div>
</blockquote>
</div>
</blockquote>
<br>
Probably you have to first create an empty sqlite database. Check
what your db parameters are with: "db.connect -p"<br>
Then run "sqlite3 <path/to/database>"<br>
Where the path is from the above. Probably by default something
like: ~/grassdata/GRGHM_UTM/<mapset>/sqlite.db<br>
<br>
<blockquote
cite="mid:84D60B76-26E4-450E-8568-90A26D9D231B@gmail.com"
type="cite">
<div>
<blockquote type="cite">
<div><br>
</div>
<div>WARNING: Unable to create table
<sqlite.accidents_utm></div>
<div>WARNING: Unable to copy table
<sqlite.accidents_utm></div>
<div>WARNING: Failed to copy attribute table to output map</div>
<div>Building topology for vector map <accidents_utm>...</div>
<div>Registering primitives...</div>
<div>62 primitives registered</div>
<div>62 vertices registered</div>
<div>Building areas...</div>
<div> 100%</div>
<div>0 areas built</div>
<div>0 isles built</div>
<div>Attaching islands...</div>
<div>Attaching centroids...</div>
<div> 100%</div>
<div>Number of nodes: 62</div>
<div>Number of primitives: 62</div>
<div>Number of points: 62</div>
<div>Number of lines: 0</div>
<div>Number of boundaries: 0</div>
<div>Number of centroids: 0</div>
<div>Number of areas: 0</div>
<div>Number of isles: 0</div>
<div>GRASS 6.4.1 (GRGHM_UTM):~ > </div>
</blockquote>
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>Thanks for any suggestions about how to resolve the issue.</div>
<div><br>
</div>
<div>Dave</div>
<div><br>
</div>
<div>
<div style="color: rgb(0, 0, 0); font-size: 12px; "><font
class="Apple-style-span" color="#666666">Dave Kindem</font></div>
<div style="color: rgb(0, 0, 0); font-size: 12px; "><font
class="Apple-style-span" color="#666666"><a
moz-do-not-send="true" href="mailto:dkindem@gmail.com">dkindem@gmail.com</a></font></div>
<div style="font-size: 12px; "><font class="Apple-style-span"
color="#666666"><br>
</font></div>
</div>
<br>
</div>
<br>
<br>
This mail was received via Mail-SeCure System.<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
grass-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:grass-user@lists.osgeo.org">grass-user@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/grass-user">http://lists.osgeo.org/mailman/listinfo/grass-user</a>
This mail was received via Mail-SeCure System.
</pre>
</blockquote>
<p><br>
</p>
</body>
</html>