[SQLGRASS] sql interface
sqlgrass at geog.uni-hannover.de
Mon, 12 Feb 2001 19:49:22 -0800 (PST)
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
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
> Performing query....
> 17 tuples returned.
> Divide the categories into equal intervals (y/n)?
> How many intervals do you want (please insert more than 2)?
> Please choose a color schema (1-6)?
I hope this question makes sense.
Sociology grad student
University of California, Rivserside
If you want to unsubscribe from SQLGRASS
mailing list write to:
subject 'unsubscribe sqlgrass'