[SQLGRASS] Raster maps and PG

[Alex Shevlakov]

Hi,

just read the new html mans for the d.rast.pg and
d.what.r(v).pg modules.

You can simply reclass by d.rast.pg using any integer
column from postgres table for creating reclass rule:
old_val=new_val

I guess the first part of your problem can be done by
d.what.v.pg - from this module you can generate a list
of comma-separated values; or use the "update" as
given in example in manpage to insert values picked
from the screen into a postgres table.

--alex

--- Peter Löwe <peter.loewe@gmx.de> wrote:
> Hello,
> 
> I am relatively inexperienced with the
> db.xxxx-Interface of Grass5 and could
> use 
> some advice:
> For the task of exporting data from raster maps into
> tables I am using a
> PERL 
> script which basically does a 
> "cat CREATE TABLE mydata | db.execute" as described
> in the db.execute man 
> page.
> I am using UnixODBC, with its original PG-driver.
> 
> The overall performance is incredibely slow (makes
> my PIII feel like an old
> 8bit 
> machine) . Are there ways to speed things up? Are
> there alternative 
> approaches?
> 
> Further, I have to get data from a PG-table back
> into a Grass-raster. 
> How can that be done except for lengthy
> ascii-import/export procedures?
> 
> Happy holidays,
> Peter
> 
> -- 
> Dipl. Geogr. Peter Loewe
> <peter.loewe@gmx.de>
> <loewe@.informatik.uni-wuerzburg.de>
> 
> Lehrstuhl VI (Angewandte Informatik und Künstliche
> Intelligenz)
> Informatik
> Am Hubland
> D 97074 Wuerzburg
> Germany
> 
> GMX - Die Kommunikationsplattform im Internet.
> http://www.gmx.net
> 
> 
> -- 
> Dipl. Geogr. Peter Loewe
> <peter.loewe@gmx.de>
> <loewe@.informatik.uni-wuerzburg.de>
> 
> Lehrstuhl VI (Angewandte Informatik und Künstliche
> Intelligenz)
> Informatik
> Am Hubland
> D 97074 Wuerzburg
> Germany
> 
> GMX - Die Kommunikationsplattform im Internet.
> http://www.gmx.net
> 
> 
> -- 
> Dipl. Geogr. Peter Loewe
> <peter.loewe@gmx.de>
> <loewe@.informatik.uni-wuerzburg.de>
> 
> Lehrstuhl VI (Angewandte Informatik und Künstliche
> Intelligenz)
> Informatik
> Am Hubland
> D 97074 Wuerzburg
> Germany
> 
> GMX - Die Kommunikationsplattform im Internet.
> http://www.gmx.net
> 
> _______________________________________________
> sqlgrass mailing list
> sqlgrass@grass.itc.it
> http://grass.itc.it/mailman/listinfo/sqlgrass


__________________________________________________
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com