[GRASS-user] creating sqlite database for point vector

[Markus Neteler]

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

On Fri, Jun 12, 2009 at 4:24 PM, Kurt Springs<ferret_bard at 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