[GRASSLIST:10441] connect with selection???

GRASS GRASS user
1

Hello,
currently I keep in a pg table X,Y,value,type,date of meteostation and import the rain vector with:

echo "SELECT x,y,value FROM observation where type=rain and date='200602101200'" | db.select -c | v.in.ascii out=rain.200602101200

Conceptually the geometry is static and just the attribute are time dependent.

So I wonder if is there a way for select vector attributes based on WHERE statement?
What I need should be a sort of v.db.connect with table="SELECT bla bla FROM bla bla WHERE bla bla"...

Do you have some hints for doing the rigth thing?

Thanks,
Massimiliano

--

Eng. Massimiliano Cannata
Scuola Universitaria Professionale della Svizzera Italiana
Istituto Scienze della Terra
Via Trevano, c.p. 72
CH-6952 Canobbio-Lugano
Tel: +41 (0)58 666 62 18
Fax +41 (0)58 666 62 09

2

On Monday 20 February 2006 09:45 am, Massimiliano Cannata wrote:

Hello,
currently I keep in a pg table X,Y,value,type,date of meteostation and
import the rain vector with:

echo "SELECT x,y,value FROM observation where type=rain and
date='200602101200'" | db.select -c | v.in.ascii out=rain.200602101200

Conceptually the geometry is static and just the attribute are time
dependent.

So I wonder if is there a way for select vector attributes based on
WHERE statement?
What I need should be a sort of v.db.connect with table="SELECT bla bla
FROM bla bla WHERE bla bla"...

Do you have some hints for doing the rigth thing?

Thanks,
Massimiliano

I wonder if the GRASS PG driver support views? -- this would be exactly what
you are asking for i think.

cheers,

--
Dylan Beaudette
Soils and Biogeochemistry Graduate Group
University of California at Davis
530.754.7341