QGIS » QGIS Application

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.

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

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.

Salvatore Larosa wrote:

Anyone can confirms?

In my case with sample data of the comment n.3, both columns (XCOORD and YCOORD) are not esported!

I still can confirm the behaviour described in #2733-3. now I will test with gpx files.

Salvatore Larosa wrote:

Anyone can confirms?

In my case with sample data of the comment n.3, both columns (XCOORD and YCOORD) are not esported!

and I confirm also the behaviour described in the original ticket description and #2733-1

Right now, the problems are two:
ext/add geometry tool does not work:

1) with data from database (not sure for Spatialite)
2) if the position of the field geometry is intermediate to the other, not at the end of the list.

In fact, dataProvider().fields().keys() returns [0, 2, 3] if the table is defined as follows:

CREATE TABLE test (
id serial NOT NULL < ----------------- 0
geom geometry <----------------------- 1
name text <--------------------------- 2
descr text <-------------------------- 3
CONSTRAINT test_pkey PRIMARY KEY (id)
)

well, I succeeded in solving this and I'll do a pull request after doing some more tests!
XCOORD and YCOORD work fine, I still have to test for linear and polygonal geometries!

Can anyone send me a GPX data to test it?

"... I forgot a thing very curious ....
extract/add geometry tool works even if the attribute table is open! (ref. #5335)"

1) with data from database (not sure for Spatialite)

it works

The "ftools" category is being removed from the tracker, changing the category of this ticket to "Processing/QGIS" to not leave the category orphaned.