fTools Add geometry column fails to add XCOORD if source is GPX file or PostGIS Layer

[marisn]

Plugins -> GPS -> GPS tools -> load waypoint GPX file -> fTools -> Geometry tools -> Export/add geometry column -> Choose GPX waypoint layer -> Choose any output name -> OK -> Open attribute table: only YCOORD is present, XCOORD is missing.

Saving GPX as shapefile and then running fTools add geometry column works just fine for WGS84 and projected files.

QGIS 1.4.0 and trunk r13529 fTools 0.5.10

[lutra]

Hi,

I noticed that if you open the GPX file trough the standard "add vector" interface things are pretty different: the attribute table is different and the "Export/add geometry column" works fine. So it should not be a ftools problem after all, but a problem of QGIS GPS tools toolbox.

[lutra]

this should not be a ftools problem. Please leave further feedback and change the summary if you confirm my observations.

[hdus]

I found the same behaviour with PostGIS layers as well. The bug depends on the position of the geometry column in the column-list.

With the following POINT table-definition, geometry column at the beginning of the columns list:

CREATE TABLE test1
(
  id serial NOT NULL,
  wkb_geometry geometry,
  feld1 text,
  feld2 text,
  feld3 integer,
  CONSTRAINT test1_pkey PRIMARY KEY (id)
)

only the YCOORD column will be exported.

With the following POINT table-definition, with geometry at the end of the columns list:

CREATE TABLE test1
(
  id serial NOT NULL,
  feld1 text,
  feld2 text,
  feld3 integer,
  wkb_geometry geometry
  CONSTRAINT test1_pkey PRIMARY KEY (id)
)

all columns XCOORD and YCOORD will be exported fine.