[SQLGRASS] sql interface

[Jason Martinez]

Hello,

I have searched (and searched, and searched) the GRASS website for 
information about a module that doesn't seem to exist. I have a large 
database containing patient discharge data for the entire state in 
California. It is stored in postgres. Individual is the unit of analysis.

I have a couple of vector maps that I have been able to import via r.poly 
(etc....). The unit of analysis for these maps are zipcodes and cities 
for particular counties in CA. I have sucessfully labeled the polygons 
and I have been able to run queries and color particular polygon regions 
on the map.

I have been able to perform complex queries with a sql file (i.e., 
perform joins, group by's etc...), but each time I want to add a new 
color on the map I have to perform a new query. Does a module exist in 
Grass that could allow me to do this w/o having to run a unique query 
each time?

I am imagining an interface that works something to the effect of:

>d.vect.sql.pg -s select zipcodes from demographics where age<=2 group by 
zipcodes;

> Performing query....
> Done.

> 17 tuples returned.
> Divide the categories into equal intervals (y/n)?
 y
> How many intervals do you want (please insert more than 2)?
  6
> Please choose a color schema (1-6)?
....

I hope this question makes sense.

Jason





----
Sociology grad student
University of California,  Rivserside

---------------------------------------- 
If you want to unsubscribe from SQLGRASS 
mailing list write to:
minordomo@geog.uni-hannover.de with
subject 'unsubscribe sqlgrass'