[GRASS-user] Problems displaying d.vect.thematic

Hello:

The problem is with the d.vect.thematic command. It don't display
nothing on the monitor. Even when other commands do it right.

I did the following commands:

d.mon x0

d.vect.thematic -s map=JCE_M2006 type=area column=RD_ALIANZA layer=1 icon=basic/circle size=5 maxsize=20 nint=4 pointcolor=255:0:0 linecolor=0:0:0 startcolor=255:0:0 endcolor=0:0:255 themetype=graduated_colors monitor=none themecalc=interval colorscheme=blue-red;

And nothing is displayed. Here are the output errors:

**********

Segmentation fault
Thematic map legend for column RD_ALIANZA of map JCE_M2006
Value range: -
Mapped by 4 intervals of -inf
Color(R:G:B) Value
============ ==========
0:0:255 -
DBMI-DBF driver error:
SQL parser error: syntax error, unexpected AND processing 'and'
in statement:
SELECT cat FROM JCE_M2006 WHERE RD_ALIANZA >= and RD_ALIANZA<=
Error in db_open_select_cursor()

85:0:170 -
DBMI-DBF driver error:
SQL parser error: syntax error, unexpected AND processing 'and'
in statement:
SELECT cat FROM JCE_M2006 WHERE RD_ALIANZA > and RD_ALIANZA<=
Error in db_open_select_cursor()

170:0:85 -
DBMI-DBF driver error:
SQL parser error: syntax error, unexpected AND processing 'and'
in statement:
SELECT cat FROM JCE_M2006 WHERE RD_ALIANZA > and RD_ALIANZA<=
Error in db_open_select_cursor()

255:0:0 -
DBMI-DBF driver error:
SQL parser error: syntax error, unexpected AND processing 'and'
in statement:
SELECT cat FROM JCE_M2006 WHERE RD_ALIANZA > and RD_ALIANZA<=
Error in db_open_select_cursor()

**********

I installed ubuntu 6.10 on a Dell Mini 10. Then from the repositories
I installed GRASS 6.4.0RC5.

This is very strange because other commands are displaying well. Like
the following:

d.vect.chart map=PuntosCentralesM2006
type=point,line,boundary,centroid layer=1
columns=C_PLD,C_PRD,C_PRSC,C_OTROS ctype=pie ocolor=black
sizecol=P_OTROS size=15 scale=1 colors=purple,white,red,yellow;

I tried also with the GUI having the same problem.

Regards,

--
Omar Bautista González
- Coordinador de Investigación para el Desarrollo,
Diseño, Monitoreo y Evaluación
Visión Mundial República Dominicana

I tested, the same command on an older version of GRASS and it worked
(6.2.3). So I think this is a bug on this recent version (6.4.0RC5).

I also tried simpler commands with d.vect.thematic and didn't worked
with 6.4.0RC5. These commands worked well on 6.2.3.

¿What can we do to solve this module? I'm not programming on C now. If
I would I'll try to figure out some changes on d.vect.thematic module.

Att.

2009/12/7 Omar Bautista González <omarbautistag@gmail.com>:

Hello:

The problem is with the d.vect.thematic command. It don't display
nothing on the monitor. Even when other commands do it right.

I did the following commands:

d.mon x0

d.vect.thematic -s map=JCE_M2006 type=area column=RD_ALIANZA layer=1 icon=basic/circle size=5 maxsize=20 nint=4 pointcolor=255:0:0 linecolor=0:0:0 startcolor=255:0:0 endcolor=0:0:255 themetype=graduated_colors monitor=none themecalc=interval colorscheme=blue-red;

And nothing is displayed. Here are the output errors:

**********

Segmentation fault
Thematic map legend for column RD_ALIANZA of map JCE_M2006
Value range: -
Mapped by 4 intervals of -inf
Color(R:G:B) Value
============ ==========
0:0:255 -
DBMI-DBF driver error:
SQL parser error: syntax error, unexpected AND processing 'and'
in statement:
SELECT cat FROM JCE_M2006 WHERE RD_ALIANZA >= and RD_ALIANZA<=
Error in db_open_select_cursor()

85:0:170 -
DBMI-DBF driver error:
SQL parser error: syntax error, unexpected AND processing 'and'
in statement:
SELECT cat FROM JCE_M2006 WHERE RD_ALIANZA > and RD_ALIANZA<=
Error in db_open_select_cursor()

170:0:85 -
DBMI-DBF driver error:
SQL parser error: syntax error, unexpected AND processing 'and'
in statement:
SELECT cat FROM JCE_M2006 WHERE RD_ALIANZA > and RD_ALIANZA<=
Error in db_open_select_cursor()

255:0:0 -
DBMI-DBF driver error:
SQL parser error: syntax error, unexpected AND processing 'and'
in statement:
SELECT cat FROM JCE_M2006 WHERE RD_ALIANZA > and RD_ALIANZA<=
Error in db_open_select_cursor()

**********

I installed ubuntu 6.10 on a Dell Mini 10. Then from the repositories
I installed GRASS 6.4.0RC5.

This is very strange because other commands are displaying well. Like
the following:

d.vect.chart map=PuntosCentralesM2006
type=point,line,boundary,centroid layer=1
columns=C_PLD,C_PRD,C_PRSC,C_OTROS ctype=pie ocolor=black
sizecol=P_OTROS size=15 scale=1 colors=purple,white,red,yellow;

I tried also with the GUI having the same problem.

Regards,

--
Omar Bautista González
- Coordinador de Investigación para el Desarrollo,
Diseño, Monitoreo y Evaluación
Visión Mundial República Dominicana

--
Omar Bautista González
- Coordinador de Investigación para el Desarrollo,
Diseño, Monitoreo y Evaluación
Visión Mundial República Dominicana

Here, I report more information:

v.info JCE_M2006

+----------------------------------------------------------------------------+
| Layer: JCE_M2006 |
| Mapset: user1 |
| Location: MapeosElectorales |
| Database: /home/omar/grassdata |
| Title: |
| Map scale: 1:1 |
| Map format: native |
| Name of creator: |
| Organization: |
| Source date: |
|----------------------------------------------------------------------------|
| Type of Map: vector (level: 2) |
| |
| Number of points: 0 Number of areas: 9909 |
| Number of lines: 0 Number of islands: 8 |
| Number of boundaries: 20227 Number of faces: 0 |
| Number of centroids: 5078 Number of kernels: 0 |
| |
| Map is 3D: No |
| Number of dblinks: 1 |
| |
| Projection: Unknown projection |
| N: 2204990.860491 S: 1941029.08979587 |
| E: 571289.72171435 W: 182391.61052347 |
| |
| Digitization threshold: 0 |
| Comments: |
| |
+----------------------------------------------------------------------------+

db.describe table=JCE_M2006 driver=db

table:JCE_M2006
description:
insert:yes
delete:yes
ncols:31
nrows:151

column:CAT
description:
type:INTEGER
len:19
scale:0
precision:18
default:
nullok:yes
select:yes
update:yes

column:COD_JCE_M
description:
type:CHARACTER
len:3
scale:0
precision:0
default:
nullok:yes
select:yes
update:yes

column:CODIGO
description:
type:CHARACTER
len:8
scale:0
precision:0
default:
nullok:yes
select:yes
update:yes

column:COD_JCE_P
description:
type:CHARACTER
len:2
scale:0
precision:0
default:
nullok:yes
select:yes
update:yes

column:PROVINCIA
description:
type:CHARACTER
len:22
scale:0
precision:0
default:
nullok:yes
select:yes
update:yes

column:MUNICIPIO
description:
type:CHARACTER
len:26
scale:0
precision:0
default:
nullok:yes
select:yes
update:yes

column:A_GANADORA
description:
type:CHARACTER
len:5
scale:0
precision:0
default:
nullok:yes
select:yes
update:yes

column:ALIANZATRI
description:
type:CHARACTER
len:8
scale:0
precision:0
default:
nullok:yes
select:yes
update:yes

column:ALIANZAMAX
description:
type:DOUBLE PRECISION
len:5
scale:2
precision:3
default:
nullok:yes
select:yes
update:yes

column:R_ALIANZAM
description:
type:DOUBLE PRECISION
len:5
scale:2
precision:3
default:
nullok:yes
select:yes
update:yes

column:RD_ALIANZA
description:
type:DOUBLE PRECISION
len:4
scale:2
precision:2
default:
nullok:yes
select:yes
update:yes

column:ALIANZAMIN
description:
type:CHARACTER
len:9
scale:0
precision:0
default:
nullok:yes
select:yes
update:yes

column:ALIANZAMI2
description:
type:DOUBLE PRECISION
len:5
scale:2
precision:3
default:
nullok:yes
select:yes
update:yes

column:R_ALIANZA2
description:
type:DOUBLE PRECISION
len:5
scale:2
precision:3
default:
nullok:yes
select:yes
update:yes

column:PARTIDOMAX
description:
type:CHARACTER
len:8
scale:0
precision:0
default:
nullok:yes
select:yes
update:yes

column:PARTIDOMA2
description:
type:DOUBLE PRECISION
len:5
scale:2
precision:3
default:
nullok:yes
select:yes
update:yes

column:R_PARTIDOM
description:
type:DOUBLE PRECISION
len:4
scale:2
precision:2
default:
nullok:yes
select:yes
update:yes

column:RD_PARTIDO
description:
type:DOUBLE PRECISION
len:4
scale:2
precision:2
default:
nullok:yes
select:yes
update:yes

column:MINOR_AMAX
description:
type:CHARACTER
len:9
scale:0
precision:0
default:
nullok:yes
select:yes
update:yes

column:MINORIAMAX
description:
type:DOUBLE PRECISION
len:5
scale:2
precision:3
default:
nullok:yes
select:yes
update:yes

column:R_MINORIAM
description:
type:DOUBLE PRECISION
len:5
scale:2
precision:3
default:
nullok:yes
select:yes
update:yes

column:C_VOTOS
description:
type:DOUBLE PRECISION
len:19
scale:6
precision:17
default:
nullok:yes
select:yes
update:yes

column:P_VOTOS
description:
type:DOUBLE PRECISION
len:19
scale:6
precision:17
default:
nullok:yes
select:yes
update:yes

column:T_INSCRITO
description:
type:DOUBLE PRECISION
len:19
scale:6
precision:17
default:
nullok:yes
select:yes
update:yes

column:V_EMITIDOS
description:
type:DOUBLE PRECISION
len:19
scale:6
precision:17
default:
nullok:yes
select:yes
update:yes

column:P_VOTANTES
description:
type:DOUBLE PRECISION
len:19
scale:6
precision:17
default:
nullok:yes
select:yes
update:yes

column:C_ABSTENCI
description:
type:DOUBLE PRECISION
len:19
scale:6
precision:17
default:
nullok:yes
select:yes
update:yes

column:P_ABSTENCI
description:
type:DOUBLE PRECISION
len:19
scale:6
precision:17
default:
nullok:yes
select:yes
update:yes

column:ESPACIAL_C
description:
type:DOUBLE PRECISION
len:5
scale:2
precision:3
default:
nullok:yes
select:yes
update:yes

column:ESPACIAL_A
description:
type:DOUBLE PRECISION
len:4
scale:2
precision:2
default:
nullok:yes
select:yes
update:yes

column:ESPACIAL_P
description:
type:DOUBLE PRECISION
len:4
scale:2
precision:2
default:
nullok:yes
select:yes
update:yes

Regards,

2009/12/9 Omar Bautista González <omarbautistag@gmail.com>:

I tested, the same command on an older version of GRASS and it worked
(6.2.3). So I think this is a bug on this recent version (6.4.0RC5).

I also tried simpler commands with d.vect.thematic and didn't worked
with 6.4.0RC5. These commands worked well on 6.2.3.

¿What can we do to solve this module? I'm not programming on C now. If
I would I'll try to figure out some changes on d.vect.thematic module.

Att.

2009/12/7 Omar Bautista González <omarbautistag@gmail.com>:

Hello:

The problem is with the d.vect.thematic command. It don't display
nothing on the monitor. Even when other commands do it right.

I did the following commands:

d.mon x0

d.vect.thematic -s map=JCE_M2006 type=area column=RD_ALIANZA layer=1 icon=basic/circle size=5 maxsize=20 nint=4 pointcolor=255:0:0 linecolor=0:0:0 startcolor=255:0:0 endcolor=0:0:255 themetype=graduated_colors monitor=none themecalc=interval colorscheme=blue-red;

And nothing is displayed. Here are the output errors:

**********

Segmentation fault
Thematic map legend for column RD_ALIANZA of map JCE_M2006
Value range: -
Mapped by 4 intervals of -inf
Color(R:G:B) Value
============ ==========
0:0:255 -
DBMI-DBF driver error:
SQL parser error: syntax error, unexpected AND processing 'and'
in statement:
SELECT cat FROM JCE_M2006 WHERE RD_ALIANZA >= and RD_ALIANZA<=
Error in db_open_select_cursor()

85:0:170 -
DBMI-DBF driver error:
SQL parser error: syntax error, unexpected AND processing 'and'
in statement:
SELECT cat FROM JCE_M2006 WHERE RD_ALIANZA > and RD_ALIANZA<=
Error in db_open_select_cursor()

170:0:85 -
DBMI-DBF driver error:
SQL parser error: syntax error, unexpected AND processing 'and'
in statement:
SELECT cat FROM JCE_M2006 WHERE RD_ALIANZA > and RD_ALIANZA<=
Error in db_open_select_cursor()

255:0:0 -
DBMI-DBF driver error:
SQL parser error: syntax error, unexpected AND processing 'and'
in statement:
SELECT cat FROM JCE_M2006 WHERE RD_ALIANZA > and RD_ALIANZA<=
Error in db_open_select_cursor()

**********

I installed ubuntu 6.10 on a Dell Mini 10. Then from the repositories
I installed GRASS 6.4.0RC5.

This is very strange because other commands are displaying well. Like
the following:

d.vect.chart map=PuntosCentralesM2006
type=point,line,boundary,centroid layer=1
columns=C_PLD,C_PRD,C_PRSC,C_OTROS ctype=pie ocolor=black
sizecol=P_OTROS size=15 scale=1 colors=purple,white,red,yellow;

I tried also with the GUI having the same problem.

Regards,

--
Omar Bautista González
- Coordinador de Investigación para el Desarrollo,
Diseño, Monitoreo y Evaluación
Visión Mundial República Dominicana

--
Omar Bautista González
- Coordinador de Investigación para el Desarrollo,
Diseño, Monitoreo y Evaluación
Visión Mundial República Dominicana

--
Omar Bautista González
- Coordinador de Investigación para el Desarrollo,
Diseño, Monitoreo y Evaluación
Visión Mundial República Dominicana