Dear All,
I am having some difficulty viewing an attribute table from a vector file that is connected to a sqlite database table.
Here is the terminal snippet of my commands with errors:
GRASS 6.4.0RC5 (SantaMonicaBayMM):~ > v.in.db driver=sqlite database=/USers/andrewlewin/MM_SMB.db table=MMSightings1 x=LONG y=LAT key=cat out=MMSightings_layer2Writing features...
100%
Copying attributes...
DBMI-SQLite driver error:
Cannot scan date:"Date"
WARNING: Unable to fetch data from table <MMSightings1>
WARNING: Unable to copy table
Building topology for vector map <MMSightings_layer2>...
Registering primitives...
1897 primitives registered
1897 vertices registered
Building areas...
100%
0 areas built
0 isles built
Attaching islands...
Attaching centroids...
100%
Number of nodes: 1803
Number of primitives: 1897
Number of points: 1897
Number of lines: 0
Number of boundaries: 0
Number of centroids: 0
Number of areas: 0
Number of isles: 0
v.in.db complete. 1897 points written to vector map.
GRASS 6.4.0RC5 (SantaMonicaBayMM):~ > v.info MMSightings_layer2
+----------------------------------------------------------------------------+
| Layer: MMSightings_layer2 |
| Mapset: PERMANENT |
| Location: SantaMonicaBayMM |
| Database: /Users/andrewlewin/grass |
| Title: |
| Map scale: 1:1 |
| Map format: native |
| Name of creator: andrewlewin |
| Organization: |
| Source date: Tue Mar 2 15:03:07 2010 |
|----------------------------------------------------------------------------|
| Type of Map: vector (level: 2) |
| |
| Number of points: 1897 Number of areas: 0 |
| Number of lines: 0 Number of islands: 0 |
| Number of boundaries: 0 Number of faces: 0 |
| Number of centroids: 0 Number of kernels: 0 |
| |
| Map is 3D: No |
| Number of dblinks: 0 |
| |
| Projection: x,y |
| N: 34:58:27.012N S: 0 |
| E: 0 W: 119:18:54.72W |
| |
| Digitization threshold: 0 |
| Comments: |
| |
+----------------------------------------------------------------------------+
GRASS 6.4.0RC5 (SantaMonicaBayMM):~ > v.info -c MMSightings_layer2
ERROR: Database connection for map <MMSightings_layer2> is not defined in
DB file
GRASS 6.4.0RC5 (SantaMonicaBayMM):~ > v.db.connect map=MMSightings_layer2 table=MMSightings driver=sqlite database=/Users/andrewlewin/MM_SMB.db
The table <MMSightings> is now part of vector map <MMSightings_layer2> and
may be deleted or overwritten by GRASS modules
DBMI-SQLite driver error:
Cannot create index:
create unique index MMSightings_cat on MMSightings ( cat )
table MMSightings has no column named cat
WARNING: Cannot create index
Select privileges were granted on the table
GRASS 6.4.0RC5 (SantaMonicaBayMM):~ > v.db.connect -p map=MMSightings_layer2
Vector map <MMSightings_layer2@PERMANENT> is connected by:
layer <1> table <MMSightings> in database </Users/andrewlewin/MM_SMB.db> through driver <sqlite> with key <cat>
There are errors from the point at which I try to make a point vector from the table. Any help would be appreciated.
Andrew
Andrew Lewin, M.Sc., Adv. Dipl. GIS
Email: andrew.lewin@sympatico.ca
Tel: (905) 639-4646
Mobile: (905) 630-8441
Skype: andrew.lewin99