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
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@gmail.com>
Reply-To: <joel.pitt@gmail.com>
Date: Thu, 13 Jul 2006 13:57:34 +1200
To: GRASS user list <grassuser@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
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@gmail.com>
> Reply-To: <joel.pitt@gmail.com>
> Date: Thu, 13 Jul 2006 13:57:34 +1200
> To: GRASS user list <grassuser@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@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