[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. ___ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user
Re: [GRASS-user] Vector dbf files + Spatial join
On Tue, Jun 24, 2008 at 11:31 AM, Wesley Roberts <[EMAIL PROTECTED]> 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 ___ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user
Re: [GRASS-user] Vector dbf files + Spatial join
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 <[EMAIL PROTECTED]>: > 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 ___ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user
Re: [GRASS-user] Vector dbf files + Spatial join
Hi Markus, Thanks for the help but unfortunately I don't seem to have the v.db.join application. When I execute v.db.join within grass I get an error bash: v.db.join: command not found I am using Grass version 6.2.2 do I need to upgrade to 6.3 or is the v.db.join a sqlite command? 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
Re: [GRASS-user] Vector dbf files + Spatial join
On Tue, Jun 24, 2008 at 12:19 PM, Wesley Roberts <[EMAIL PROTECTED]> wrote: > Hi Markus, > > Thanks for the help but unfortunately I don't seem to have the v.db.join > application. When I execute v.db.join within grass I get an error > bash: v.db.join: command not found > > I am using Grass version 6.2.2 do I need to upgrade to 6.3 or is the > v.db.join a sqlite command? Yes, it was introduced in 6.3.0: http://grass.osgeo.org/announces/announce_grass630.html You will like all the other improvements, too :) Best Markus ___ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user
Re: [GRASS-user] Vector dbf files + Spatial join
Hi Markus, I tried to upgrade using the links from the announcement. I added the respective repositories to my sources.list file and upgraded no problem. I now have 6.2.3, unfortunately this does not include the v.db.join. I am now downloading the 6.3 source and am going to compile using that. Do I need to uninstall 6.2.3 before I compile? Also I found the v.db.join script at http://trac.osgeo.org/grass/browser/grass/branches/develbranch_6/scripts Can I use this script in 6.2.3? If so how do I go about compiling and using? 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 >>> "Markus Neteler" <[EMAIL PROTECTED]> 06/24/08 12:26 PM >>> On Tue, Jun 24, 2008 at 12:19 PM, Wesley Roberts <[EMAIL PROTECTED]> wrote: > Hi Markus, > > Thanks for the help but unfortunately I don't seem to have the v.db.join > application. When I execute v.db.join within grass I get an error > bash: v.db.join: command not found > > I am using Grass version 6.2.2 do I need to upgrade to 6.3 or is the > v.db.join a sqlite command? Yes, it was introduced in 6.3.0: http://grass.osgeo.org/announces/announce_grass630.html You will like all the other improvements, too :) Best Markus -- 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
Re: [GRASS-user] Vector dbf files + Spatial join
Hi Wesley, On Tue, Jun 24, 2008 at 1:50 PM, Wesley Roberts <[EMAIL PROTECTED]> wrote: > Hi Markus, > > I tried to upgrade using the links from the announcement. I added the > respective repositories to my sources.list file and upgraded no problem. I > now have 6.2.3, unfortunately this does not include the v.db.join. As mentioned, we introduced it in 6.3.0. > I am now downloading the 6.3 source and am going to compile using that. Do I > need to uninstall 6.2.3 before I compile? No, you can keep both in parallel. > Also I found the v.db.join script at > http://trac.osgeo.org/grass/browser/grass/branches/develbranch_6/scripts > Can I use this script in 6.2.3? If so how do I go about compiling and using? I am not sure of v.db.join makes use of 6.3.0 functionality. It's just a script (so copying is enough in theory). Say, it's rather unlikely that it works with 6.2.x. You can try of course. Markus ___ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user