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