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

[Mike Dvorak]

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


-- 
==========================================
Mike Dvorak
Atmosphere/Energy MS Student
Dept. of Civil & Environmental Engineering
Stanford University
==========================================