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

[Mike Dvorak]

Thanks for the response Yves.  I actually just had figured out the
problem.  I was using v.external instead of v.in.ogr for the layers that
were causing the problems.  I'm guessing the DBF file was not linked and
that's what was causing the null data problem.  It took me a while to
figure this out though.

Cheers,
-Mike

Mike Dvorak wrote:
> 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<=
> 
>