Thanks Micha. I can now create the table. Dave
Dave Kindem [email protected] 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 >> [email protected] >> >> >> >> >> 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
