Bug report #12796

Export Spatialite point layer to CSV fails on Geometry AS_XY

Added by Jochen Huber over 4 years ago. Updated over 4 years ago.

Status:Closed
Priority:Severe/Regression
Assignee:-
Category:-
Affected QGIS version:2.8.2 Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:duplicate
Crashes QGIS or corrupts data:No Copied to github as #:20892

Description

When exporting a Spatialite point layer via "Save as...", geometry is only exported when selecting "AS_WKT". When selecting AS_XY or AS_YX, only the attribute values are exported (see attached files).
When exporting from a Shapefile, the geometry is written correctly with the option AS_XY.

Export_WKT.csv Magnifier - Export from Spatialite point layer (EPSG:31468) (191 Bytes) Jochen Huber, 2015-05-21 02:02 AM

Export_XY.csv Magnifier - Export from Spatialite point layer (EPSG:31468) (1.84 KB) Jochen Huber, 2015-05-21 02:02 AM


Related issues

Related to QGIS Application - Bug report #10584: Saving as SpatiaLite fails with "save as" dialog when inp... Closed 2014-06-14
Duplicates QGIS Application - Bug report #11597: XY columns are not exported to csv Closed 2014-11-07

Associated revisions

Revision 518072e9
Added by Jürgen Fischer over 4 years ago

expression: validate places value of format_number (fixes #12796)

Revision 9ef8b29f
Added by Jürgen Fischer over 4 years ago

expression: validate places value of format_number (fixes #12796)

(cherry picked from commit 518072e9b319fa15848237b2a42a472421a40627)

History

#1 Updated by Saber Razmjooei over 4 years ago

  • Priority changed from Low to Severe/Regression
  • Operating System deleted (OSGeo4W)
  • OS version deleted (Windows 7 Prof. x64)

Confirmed also in master but not in 2.6.1.

It is a regression bug and marked as blocker.

#2 Updated by Giovanni Manghi over 4 years ago

  • Target version set to Future Release - High Priority

#3 Updated by Jürgen Fischer over 4 years ago

  • Status changed from Open to Feedback

Is that spatialite layer multipoint?

#4 Updated by Saber Razmjooei over 4 years ago

It is MULTIPOINT, indeed.

#5 Updated by Jochen Huber over 4 years ago

Yes, it is MULTIPOINT. Tested with POINT, and it works okay.

#6 Updated by Jürgen Fischer over 4 years ago

  • Status changed from Feedback to Closed
  • Resolution set to duplicate

Jochen Huber wrote:

Yes, it is MULTIPOINT. Tested with POINT, and it works okay.

So I guess it's another problem. AS_XY doesn't work for MULTIPOINT. Question is how the multipoint layer was created - maybe related to the two related tickets.

#7 Updated by Saber Razmjooei over 4 years ago

I think it is a problem with QSpatialite plugin. The ones converted to Spatialite through ogr2ogr are fine.

#8 Updated by Jochen Huber over 4 years ago

Yes, QSpatialite seems to always (often unnecessarily) generate MULTIPOINT feature sets when importing from QGIS layers.
An error message would be helpful in any case (e.g. "Option AS_XY not supported for MULTIPOINT datasets").
I even think it would be possible to export MULTIPOINT data with AS_XY:
Write one line for every POINT, using the same attributes for every MULTIPOINT part
Add a column "MULTIPART ID" with distinct values für distinct features and shared values for all parts of a MULTIPOINT.

#9 Updated by Saber Razmjooei over 4 years ago

You can always log another ticket as a feature request.
https://github.com/romain974/qspatialite/issues/32

Also available in: Atom PDF