Bug report #12796

Export Spatialite point layer to CSV fails on Geometry AS_XY

Added by Jochen Huber almost 10 years ago. Updated almost 10 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 almost 10 years ago

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

Revision 9ef8b29f
Added by Jürgen Fischer almost 10 years ago

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

(cherry picked from commit 518072e9b319fa15848237b2a42a472421a40627)

History

#1 Updated by Saber Razmjooei almost 10 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 almost 10 years ago

  • Target version set to Future Release - High Priority

#3 Updated by Jürgen Fischer almost 10 years ago

  • Status changed from Open to Feedback

Is that spatialite layer multipoint?

#4 Updated by Saber Razmjooei almost 10 years ago

It is MULTIPOINT, indeed.

#5 Updated by Jochen Huber almost 10 years ago

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

#6 Updated by Jürgen Fischer almost 10 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 almost 10 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 almost 10 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 almost 10 years ago

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

Also available in: Atom PDF