[GRASS-user] v.db.join error

[Patrick_schirmer]

Skipped content of type multipart/alternative-------------- next part --------------
GRASS 7.0.svn (Survey):~ > v.info -c GR_xy_wohnort
Displaying column types/names for database connection of layer <1>:
INTEGER|cat
INTEGER|plz
CHARACTER|ort
CHARACTER|strasse
CHARACTER|nr
INTEGER|id
CHARACTER|lat
CHARACTER|lon
DOUBLE PRECISION|x_wohn
DOUBLE PRECISION|y_wohn
DOUBLE PRECISION|dist_arbei
DOUBLE PRECISION|dist_lwohn
DOUBLE PRECISION|x_arbeit
DOUBLE PRECISION|y_arbeit
DOUBLE PRECISION|x_lastwohn
DOUBLE PRECISION|y_lastwohn
CHARACTER|nan


GRASS 7.0.svn (Survey):~ > v.info -c GR_xy_arbeitsort
Displaying column types/names for database connection of layer <1>:
INTEGER|cat
INTEGER|plz
CHARACTER|ort
CHARACTER|strasse
CHARACTER|nr
INTEGER|id
CHARACTER|lat
CHARACTER|lon
DOUBLE PRECISION|x_arbeit
DOUBLE PRECISION|y_arbeit
GRASS 7.0.svn (Survey):~ > 

GRASS 7.0.svn (Survey):~ > v.db.connect -p GR_xy_wohnort
Vector map <GR_xy_wohnort> is connected by:
layer <1/xy_wohnort> table <GR_xy_wohnort> in database <schirpat> through driver <pg> with key <cat>

GRASS 7.0.svn (Survey):~ >GRASS 7.0.svn (Survey):~ > v.db.connect -p GR_xy_arbeitsort
Vector map <GR_xy_arbeitsort> is connected by:
layer <1/xy_arbeitsort> table <GR_xy_arbeitsort> in database <schirpat> through driver <pg> with key <cat>
GRASS 7.0.svn (Survey):~ > 

GRASS 7.0.svn (Survey):~ > db.describe table=GR_xy_wohnort
table:GR_xy_wohnort
description:
insert:?
delete:?
ncols:17
nrows:502

column:cat
description:
type:INTEGER
len:4
scale:0
precision:0
default:
nullok:yes
select:?
update:?

column:plz
description:
type:INTEGER
len:4
scale:0
precision:0
default:
nullok:yes
select:?
update:?

column:ort
description:
type:CHARACTER
len:80
scale:0
precision:0
default:
nullok:yes
select:?
update:?

column:strasse
description:
type:CHARACTER
len:80
scale:0
precision:0
default:
nullok:yes
select:?
update:?

column:nr
description:
type:CHARACTER
len:80
scale:0
precision:0
default:
nullok:yes
select:?
update:?

column:id
description:
type:INTEGER
len:4
scale:0
precision:0
default:
nullok:yes
select:?
update:?

column:lat
description:
type:CHARACTER
len:80
scale:0
precision:0
default:
nullok:yes
select:?
update:?

column:lon
description:
type:CHARACTER
len:80
scale:0
precision:0
default:
nullok:yes
select:?
update:?

column:x_wohn
description:
type:DOUBLE PRECISION
len:8
scale:0
precision:0
default:
nullok:yes
select:?
update:?

column:y_wohn
description:
type:DOUBLE PRECISION
len:8
scale:0
precision:0
default:
nullok:yes
select:?
update:?

column:dist_arbei
description:
type:DOUBLE PRECISION
len:8
scale:0
precision:0
default:
nullok:yes
select:?
update:?

column:dist_lwohn
description:
type:DOUBLE PRECISION
len:8
scale:0
precision:0
default:
nullok:yes
select:?
update:?

column:x_arbeit
description:
type:DOUBLE PRECISION
len:8
scale:0
precision:0
default:
nullok:yes
select:?
update:?

column:y_arbeit
description:
type:DOUBLE PRECISION
len:8
scale:0
precision:0
default:
nullok:yes
select:?
update:?

column:x_lastwohn
description:
type:DOUBLE PRECISION
len:8
scale:0
precision:0
default:
nullok:yes
select:?
update:?

column:y_lastwohn
description:
type:DOUBLE PRECISION
len:8
scale:0
precision:0
default:
nullok:yes
select:?
update:?

column:nan
description:
type:CHARACTER
len:3
scale:0
precision:0
default:
nullok:yes
select:?
update:?
GRASS 7.0.svn (Survey):~ > 

GRASS 7.0.svn (Survey):~ > db.describe table=GR_xy_arbeitsort
table:GR_xy_arbeitsort
description:
insert:?
delete:?
ncols:10
nrows:330

column:cat
description:
type:INTEGER
len:4
scale:0
precision:0
default:
nullok:yes
select:?
update:?

column:plz
description:
type:INTEGER
len:4
scale:0
precision:0
default:
nullok:yes
select:?
update:?

column:ort
description:
type:CHARACTER
len:80
scale:0
precision:0
default:
nullok:yes
select:?
update:?

column:strasse
description:
type:CHARACTER
len:80
scale:0
precision:0
default:
nullok:yes
select:?
update:?

column:nr
description:
type:CHARACTER
len:80
scale:0
precision:0
default:
nullok:yes
select:?
update:?

column:id
description:
type:INTEGER
len:4
scale:0
precision:0
default:
nullok:yes
select:?
update:?

column:lat
description:
type:CHARACTER
len:80
scale:0
precision:0
default:
nullok:yes
select:?
update:?

column:lon
description:
type:CHARACTER
len:80
scale:0
precision:0
default:
nullok:yes
select:?
update:?

column:x_arbeit
description:
type:DOUBLE PRECISION
len:8
scale:0
precision:0
default:
nullok:yes
select:?
update:?

column:y_arbeit
description:
type:DOUBLE PRECISION
len:8
scale:0
precision:0
default:
nullok:yes
select:?
update:?
GRASS 7.0.svn (Survey):~ > 


Having a look at the table via PGAdmin III will show:

CREATE TABLE gr_xy_wohnort
(
  cat integer,
  plz integer,
  ort character varying(80),
  strasse character varying(80),
  nr character varying(80),
  id integer,
  lat character varying(80),
  lon character varying(80),
  x_wohn double precision,
  y_wohn double precision,
  dist_arbei double precision,
  dist_lwohn double precision,
  x_arbeit double precision,
  y_arbeit double precision,
  x_lastwohn double precision,
  y_lastwohn double precision,
  nan character varying(3)
)

Example of value x_arbeit: 683950.999985278
Example of value y_arbeit: 245281.003081325
Exampe of value x_wohnort: 696969.00272016
Example of value y_wohnort: 241017.00360929