Re: [GRASS-user] Managing the Harmonized World Soil Database in GRASS
On 25/03/2011 11:25, Luigi Ponti wrote: Dear Rich, The HWSD is composed of a raster image file and a linked attribute database stored in Microsoft Access 2003 format. It would be nice if the attributes were made available in a format using open standards. That would make it available to those of us who don't do windows. Rich You are right. [...] I have inquired the data provider about the issue, and will let the list know. Here is what the data provider replied: Thank you for your suggestion. The raster file is already available in an open format, since it is just a binary table. In the database file (HWSD.mdb), there is one main table in the database, the HWSD_Data table, that contains all the soil data. The other tables simply describe the codes and abbreviations. The simplest and most transferable option would be to export this HWSD_Data as a text file along with a document listing all the codes and abbreviations. At the moment, anyone with Access can do this for others. However, your point is well taken and we will consider making such a text file and perhaps other database formats available on our website with our next update. The viewer cannot so easily be transferred to other operating systems and we have no plan to do so. Kind regards, Luigi ___ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user
Re: [GRASS-user] Managing the Harmonized World Soil Database in GRASS
Dear Rich, The HWSD is composed of a raster image file and a linked attribute database stored in Microsoft Access 2003 format. It would be nice if the attributes were made available in a format using open standards. That would make it available to those of us who don't do windows. Rich You are right. There is a driver apparently more advanced than the OpenOffice.org one, which I haven't tried yet: http://www.kexi-project.org/wiki/wikiview/index@mdbdriver.html I have inquired the data provider about the issue, and will let the list know. Kind regards, Luigi ___ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user
Re: [GRASS-user] Managing the Harmonized World Soil Database in GRASS
Hi, some month ago I had to make some maps with the HWSD database. I used the mdbtool (http://mdbtools.sourceforge.net/) to extract all tables from the .mdb file to some sql files. Then I just imported all the table in a postgres database, and it is quite easy to access them in GRASS ... Regards, Sylvain 2011/3/24 Luigi Ponti lpo...@inbox.com Dear listers, I seem to have successfully imported the Harmonized World Soil Database (HWSD) in BIL format to GRASS 6.4.svn via r.in.gdal. The data is available at http://www.iiasa.ac.at/Research/LUC/luc07/External-World-soil-database/HTML/index.html The HWSD is composed of a raster image file and a linked attribute database stored in Microsoft Access 2003 format. According to the documentation (page 28) http://www.iiasa.ac.at/Research/LUC/External-World-soil-database/HWSD_Documentation.pdf using the HWSD database in a GIS should be straightforward. The MU_GLOBAL attribute column in the database is also stored in each raster cell, and may therefore be considered as the link to the raster. My goal would be to obtain more raster maps that show other (soil) attributes from the database or combination of different attributes based on computations. The documentation suggests the following work flow: - if necessary, realize the appropriate calculations (ex: after exporting from Access to Excel); - convert final attributes table to a compatible GIS format; - join the MU_GLOBAL attribute and the GRID value (dbf or txt formats); - convert the attribute to a new GRID (in the case it is needed). What comes to mind is value replacement using r.recode but maybe there is a better course of action. This is seemingly the best available soil GIS database with global coverage, so I thought my question may be useful to others. Kind regards and thanks in advance for any hint, Luigi ___ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user ___ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user
Re: [GRASS-user] Managing the Harmonized World Soil Database in GRASS
On Fri, 25 Mar 2011, Luigi Ponti wrote: There is a driver apparently more advanced than the OpenOffice.org one, which I haven't tried yet: http://www.kexi-project.org/wiki/wikiview/index@mdbdriver.html Luigi, How interesting! I use OO.o to translate .doc to .odt and .xls to ods, but it has not occurred to me to try it with a .mdb file. I suppose that is because almost all my writing is done in LyX/LaTeX and I have little need for spreadsheets so I don't use OO.o unless I must. Thank you for the idea and URL, Rich ___ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user
Re: [GRASS-user] Managing the Harmonized World Soil Database in GRASS
On 25/03/2011 11:44, Sylvain Maillard wrote: Hi, some month ago I had to make some maps with the HWSD database. I used the mdbtool (http://mdbtools.sourceforge.net/) to extract all tables from the .mdb file to some sql files. Then I just imported all the table in a postgres database, and it is quite easy to access them in GRASS ... Regards, Sylvain Hi Sylvain, Thanks for your answer. I see your point. After exporting the .mdb to PostgreSQL you can db.connect to it from the GRASS mapset where the HWSD soil map is. However, I do not see how you can then get the data on the map, given that a database links to a vector whereas the HWSD map is a raster. How did you map the connected database? It would be nice if you could share a bit more of your experience with mapping HWSD data. Kind regards and thank you, Luigi 2011/3/24 Luigi Ponti lpo...@inbox.com mailto:lpo...@inbox.com Dear listers, I seem to have successfully imported the Harmonized World Soil Database (HWSD) in BIL format to GRASS 6.4.svn via r.in.gdal. The data is available at http://www.iiasa.ac.at/Research/LUC/luc07/External-World-soil-database/HTML/index.html The HWSD is composed of a raster image file and a linked attribute database stored in Microsoft Access 2003 format. According to the documentation (page 28) http://www.iiasa.ac.at/Research/LUC/External-World-soil-database/HWSD_Documentation.pdf using the HWSD database in a GIS should be straightforward. The MU_GLOBAL attribute column in the database is also stored in each raster cell, and may therefore be considered as the link to the raster. My goal would be to obtain more raster maps that show other (soil) attributes from the database or combination of different attributes based on computations. The documentation suggests the following work flow: - if necessary, realize the appropriate calculations (ex: after exporting from Access to Excel); - convert final attributes table to a compatible GIS format; - join the MU_GLOBAL attribute and the GRID value (dbf or txt formats); - convert the attribute to a new GRID (in the case it is needed). What comes to mind is value replacement using r.recode but maybe there is a better course of action. This is seemingly the best available soil GIS database with global coverage, so I thought my question may be useful to others. Kind regards and thanks in advance for any hint, Luigi ___ grass-user mailing list grass-user@lists.osgeo.org mailto:grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user ___ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user
[GRASS-user] Managing the Harmonized World Soil Database in GRASS
Dear listers, I seem to have successfully imported the Harmonized World Soil Database (HWSD) in BIL format to GRASS 6.4.svn via r.in.gdal. The data is available at http://www.iiasa.ac.at/Research/LUC/luc07/External-World-soil-database/HTML/index.html The HWSD is composed of a raster image file and a linked attribute database stored in Microsoft Access 2003 format. According to the documentation (page 28) http://www.iiasa.ac.at/Research/LUC/External-World-soil-database/HWSD_Documentation.pdf using the HWSD database in a GIS should be straightforward. The MU_GLOBAL attribute column in the database is also stored in each raster cell, and may therefore be considered as the link to the raster. My goal would be to obtain more raster maps that show other (soil) attributes from the database or combination of different attributes based on computations. The documentation suggests the following work flow: - if necessary, realize the appropriate calculations (ex: after exporting from Access to Excel); - convert final attributes table to a compatible GIS format; - join the MU_GLOBAL attribute and the GRID value (dbf or txt formats); - convert the attribute to a new GRID (in the case it is needed). What comes to mind is value replacement using r.recode but maybe there is a better course of action. This is seemingly the best available soil GIS database with global coverage, so I thought my question may be useful to others. Kind regards and thanks in advance for any hint, Luigi ___ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user
Re: [GRASS-user] Managing the Harmonized World Soil Database in GRASS
On Thu, 24 Mar 2011, Luigi Ponti wrote: The HWSD is composed of a raster image file and a linked attribute database stored in Microsoft Access 2003 format. It would be nice if the attributes were made available in a format using open standards. That would make it available to those of us who don't do windows. Rich ___ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user