[GRASS-user] Vector dbf files + Spatial join

Hi All,

Before I head into learning mySQL I would like to know if grass has a command that can merge / spatial join dbf attribute tables (similar to the spatial join used in ESRI).

Reading the archives I see people have used anything from PostgreSQL to mySQL to combine the attributes of vectors. I have a 13 point data sets with 15625 points with attributes attached. I would like to combine all 13 into one dbase file and then import into a stats package.

Do I need to use something like mySQL or does GRASS have a builtin function for this sort of application? If not could someone point me towards a GRASS orientated mySQL tutorial

Many thanks,
Wesley

Wesley Roberts MSc.
Researcher: Forest Assessment (Remote Sensing & GIS)
Forestry and Forest Products Research Centre
CSIR
Tel: +27 (31) 242-2353
Fax: +27 (31) 261-1216
http://ffp.csir.co.za/

"To know the road ahead, ask those coming back."
- Chinese proverb

--
This message is subject to the CSIR's copyright terms and conditions, e-mail legal notice, and implemented Open Document Format (ODF) standard.
The full disclaimer details can be found at http://www.csir.co.za/disclaimer.html.

This message has been scanned for viruses and dangerous content by MailScanner,
and is believed to be clean. MailScanner thanks Transtec Computers for their support.

Hi,

using e.g. postgres or mysql as storage backend for vector data you can use
modules like v.db.join or db.execute for complex querying your vector data.

Regards,
Christian.

Zitat von Wesley Roberts <wroberts@csir.co.za>:

Hi All,

Before I head into learning mySQL I would like to know if grass has a command
that can merge / spatial join dbf attribute tables (similar to the spatial
join used in ESRI).

Reading the archives I see people have used anything from PostgreSQL to mySQL
to combine the attributes of vectors. I have a 13 point data sets with 15625
points with attributes attached. I would like to combine all 13 into one
dbase file and then import into a stats package.

Do I need to use something like mySQL or does GRASS have a builtin function
for this sort of application? If not could someone point me towards a GRASS
orientated mySQL tutorial

Many thanks,
Wesley

Wesley Roberts MSc.
Researcher: Forest Assessment (Remote Sensing & GIS)
Forestry and Forest Products Research Centre
CSIR
Tel: +27 (31) 242-2353
Fax: +27 (31) 261-1216
http://ffp.csir.co.za/

"To know the road ahead, ask those coming back."
- Chinese proverb

--
This message is subject to the CSIR's copyright terms and conditions, e-mail
legal notice, and implemented Open Document Format (ODF) standard.
The full disclaimer details can be found at
http://www.csir.co.za/disclaimer.html.

This message has been scanned for viruses and dangerous content by
MailScanner,
and is believed to be clean. MailScanner thanks Transtec Computers for their
support.

_______________________________________________
grass-user mailing list
grass-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user

----------------------------------------------------------------
This mail was sent through http://webmail.uni-jena.de

On Tue, Jun 24, 2008 at 11:31 AM, Wesley Roberts <wroberts@csir.co.za> wrote:
...

Do I need to use something like mySQL or does GRASS have a builtin function for
this sort of application?

There is v.db.join. Using SQLite is sufficient for this task, then you can
export db.out.ogr to some table file format.

Markus