[GRASS-user] d.vect.thematic - dbf only?

[Markus Neteler]

Hi,

I have tested it with sqlite, works.

The program does:
 table=`v.db.connect $GIS_OPT_MAP -g | grep -w $GIS_OPT_LAYER | awk '{print $2}'`
 database=`v.db.connect $GIS_OPT_MAP -g | grep -w $GIS_OPT_LAYER | awk '{print $4}'`

Could you run and post:

v.db.connect sduo_land -g
v.db.connect sduo_land -g | grep -w 1 | awk '{print $4}'

?

Markus


On Thu, Jul 13, 2006 at 08:35:58PM -0700, Michael Barton wrote:
> D.vect.thematic will recognize whatever table is connected via
> v.db.connect--including pgsql ones (AFAIK -- I don't use pgsql).
> 
> Michael
> __________________________________________
> Michael Barton, Professor of Anthropology
> School of Human Evolution & Social Change
> Center for Social Dynamics & Complexity
> Arizona State University
> 
> phone: 480-965-6213
> fax: 480-965-7671
> www: http://www.public.asu.edu/~cmbarton
> 
> 
> 
> > From: Joel Pitt <joel.pitt at gmail.com>
> > Reply-To: <joel.pitt at gmail.com>
> > Date: Thu, 13 Jul 2006 13:57:34 +1200
> > To: GRASS user list <grassuser at grass.itc.it>
> > Subject: [GRASS-user] d.vect.thematic - dbf only?
> > 
> > Hi all,
> > 
> > I tried using d.vect.thematic today, but it fails when it tries to
> > read the dbf database resulting in the SQL statements being
> > incomplete. This isn't suprising though because the attribute table is
> > stored in a pqsql:
> > 
> > --------------
> > GRASS 6.1.cvs (world_clim):~ > v.db.connect -p sduo_land
> > Vector map <sduo_land> is connected by:
> > layer <1> table <aa_in_counties_full> in database
> > <host=localhost,dbname=grass> through driver <pg> with key <cat>
> > --------------
> > 
> > The output from d.vect.thematic:
> > 
> > --------------
> > GRASS 6.1.cvs (world_clim):~ > d.vect.thematic map=sduo_land
> > where="year>0" column=year layer=1
> > 
> > DBMI-DBF driver error:
> > Cannot open dbf database: host=localhost,dbname=grass
> > 
> > Thematic map legend for column year of map sduo_land
> > 
> > Value range:  -
> > Mapped by 4 intervals of -inf
> > 
> > Color(R:G:B)    Value
> > ============    ==========
> > 0:0:255          -
> > DBMI-Postgres driver error:
> > Cannot select:
> > SELECT cat FROM aa_in_counties_full WHERE year >=  and year<= AND year>0
> > ERROR:  operator does not exist: real >=
> > HINT:  No operator matches the given name and argument type(s). You
> > may need to add explicit type casts.
> > 
> > etc.
> > -------------
> > 
> > Any body have any ideas? Does d.vect.thematic only work on DBF tables,
> > or is there anyway to tell d.vect.thematic to use pqsql?
> > 
> > Thanks
> > 
> > -- 
> > -Joel
> > 
> > "Wish not to seem, but to be, the best."
> >                 -- Aeschylus
> > 
> > 
> 
> _______________________________________________
> grassuser mailing list
> grassuser at grass.itc.it
> http://grass.itc.it/mailman/listinfo/grassuser

-- 
Markus Neteler  <neteler itc it>  http://mpa.itc.it/markus/
ITC-irst -  Centro per la Ricerca Scientifica e Tecnologica
MPBA - Predictive Models for Biol. & Environ. Data Analysis
Via Sommarive, 18        -       38050 Povo (Trento), Italy