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

[Michael Barton]

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
> 
>