<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Thanks Micha. I can now create the table.<div><br></div><div>Dave</div><div><br><div>
<span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="color: rgb(0, 0, 0); "><font class="Apple-style-span" color="#666666">Dave Kindem</font></div><div style="color: rgb(0, 0, 0); "><font class="Apple-style-span" color="#666666"><a href="mailto:dkindem@gmail.com">dkindem@gmail.com</a></font></div><div><font class="Apple-style-span" color="#666666"><br></font></div></span>
</div>
<br><div><div>On Jan 1, 2012, at 8:55 AM, Micha Silver wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div bidimailui-detected-decoding-type="preferred-charset" bgcolor="#FFFFFF" text="#000000" style="direction: ltr; ">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><div style="margin-bottom: 0cm; margin-top: 0pt; "><br></div></div></span><br class="Apple-interchange-newline"></blockquote></div><br></div></body></html>