[GRASS-user] creating sqlite database for point vector

GRASS GRASS user
1

Hi again,

I am trying to create a sqlite database for my project and need some guidance.

1. Do particular field names have to appear in the database for GRASS to recognize them? Exampl STR_1?

2. How do I use the various field types (eg. TEXT, NUMERIC, BLOB, and INTEGER PRIMARY KEY)?

3. Do I need an entry number, or is the first number sufficient?

What I am doing currently is entering tombs. I currently need easing and northing data for UTM coordinates and catalog numbers (which enters as CAT. 1, CAT. 2, upto CAT. 75). Later, I may want to add fields like Townland name, finds, astronomical orientation, etc.

Thanks for any guidance you can offer.

Kurt

2

[please don't post to grassuser@grass.itc.it but to
<grass-user@lists.osgeo.org>]

On Fri, Jun 12, 2009 at 4:24 PM, Kurt Springs<ferret_bard@mac.com> wrote:

Hi again,

I am trying to create a sqlite database for my project and need some
guidance.

1. Do particular field names have to appear in the database for GRASS to
recognize them? Exampl STR_1?

No. Just avoid SQL reserved names.

2. How do I use the various field types (eg. TEXT, NUMERIC, BLOB, and
INTEGER PRIMARY KEY)?

db.execute should do everything which is supported by the DB backend.

3. Do I need an entry number, or is the first number sufficient?

What does that mean?

What I am doing currently is entering tombs. I currently need easing and
northing data for UTM coordinates and catalog numbers (which enters as CAT.
1, CAT. 2, upto CAT. 75). Later, I may want to add fields like Townland
name, finds, astronomical orientation, etc.

Should be possible.
Note that the new wxPython graphical user interface has a graphical attribute
manager.

Markus