[GRASS-user] [GRASSLIST:1144] d.vect.thematic query error

[Yves Jacolin]

Hello,
I had this error ! I success by opening a new windows with d.mon start=x0 
select=x0, the windows opened was not the same as the gis.m one byt as the 
old one (d.m).

Regards,

Y.
Le Jeudi 29 Juin 2006 23:07, Mike Dvorak a écrit :
> Hello all,
>
> I'm having an error using "d.vect.thematic".  I have illustrated the
> point using some US National Atlas data.  It seems that the actual value
> of the number I'm trying to use for the theme isn't getting put in the
> SQL query.  Any thoughts?
>
> Thanks!
> -Mike Dvorak
>
>
> Here's the command:
> d.vect.thematic -s map=state_nat_atlas type=point column=YEAR_ADM
> layer=1 icon=basic/circle size=5  maxsize=20 nint=2 pointcolor=255:0:0
> linecolor=0:0:0 startcolor=255:0:0 endcolor=0:0:255
> themetype=graduated_colors monitor=none  themecalc=interval
> colorscheme=cyan-yellow
>
>
>
> Here's the info about the data:
> v.info map=state_nat_atlas layer=1
> 
> +--------------------------------------------------------------------------
>--+
>
>  | Layer:    state_nat_atlas                Organization:
>  |
>  | Mapset:   PERMANENT                      Source Date:
>  |
>  | Location: renewables-nrdc-ll             Name of creator:
>  |
>  | Database: /Volumes/Data/gis-data
>  |
>  | Title:
>  |
>  | Map Scale:  1:1
>  |
>  | Map format: ogr
>  |
>  |-------------------------------------------------------------------------
>  |---| Type of Map:  Vector (level: 2)
>  |
>  |
>  |
>  |   Number of points:       0               Number of areas:      3150
>  |
>  |   Number of lines:        0               Number of islands:    3150
>  |
>  |   Number of boundaries:   3150            Number of faces:      0
>  |
>  |   Number of centroids:    2895            Number of kernels:    0
>  |
>  |
>  |
>  |   Map is 3D:              0
>  |
>  |   Number of dblinks:      1
>  |
>  |
>  |
>  |   Projection: Latitude-Longitude (zone 0)
>  |
>  |            N: 71.398        S: 17.675
>  |
>  |            E: 179.788       W: -179.133
>  |
>  |            B: 0.000         T: 0.000
>  |
>  |
>  |
>  |   Digitize threshold: 0.00000
>  |
>  |   Comments:
>
> 
> +--------------------------------------------------------------------------
>--+
>
> Displaying column types/names for database connection of layer 1:
> DOUBLE PRECISION|AREA
> DOUBLE PRECISION|PERIMETER
> DOUBLE PRECISION|STATESP020
> CHARACTER|STATE
> CHARACTER|STATE_FIPS
> INTEGER|ORDER_ADM
> CHARACTER|MONTH_ADM
> DOUBLE PRECISION|DAY_ADM
> DOUBLE PRECISION|YEAR_ADM
>
>
> Here's the error I get:
>
>
> *** You must open a display monitor ***
>
>
> Cannot start driver <(null)>
> awk: division by zero
>  input record number 1, file
>  source line number 1
> Thematic map legend for column YEAR_ADM of map state_nat_atlas
>
> Value range:  -
> Mapped by 2 intervals of
>
> Color(R:G:B)	Value
> ============	==========
> 0:255:255		 -
> ERROR 1: SQL: Attempt to compare numeric field `YEAR_ADM' to non-numeric
> value `and' is illegal.
> DBMI-OGR driver error:
> Cannot select:
> SELECT FID FROM statesp020 WHERE YEAR_ADM >=  and YEAR_ADM<=
>
>
> 255:255:0		 -
> ERROR 1: SQL: Attempt to compare numeric field `YEAR_ADM' to non-numeric
> value `and' is illegal.
> DBMI-OGR driver error:
> Cannot select:
> SELECT FID FROM statesp020 WHERE YEAR_ADM >  and YEAR_ADM<=

-- 
"J'aimerais être une cigarette pour naître au creux de tes mains, vivre sur 
tes lèvres et mourir à tes pieds."
---
Yves Jacolin
Appt. 55, 3e ét.
Val de Loire Nord
18 boulevard Aristide Briand
45 000 Orléans

Port. : 06 64 28 27 92
Tél. : 02 38 52 96 35
Freebox : 0872 14 2008
http://yjacolin.gloobe.org
http://questioniup.gloobe.org
http://www.gloobe.org

-- 
Yves Jacolin
-------------
http://yjacolin.gloobe.org
http://softlibre.gloobe.org