Bug report #12796
Export Spatialite point layer to CSV fails on Geometry AS_XY
| 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 
- Export from Spatialite point layer (EPSG:31468)
(191 Bytes)
Export_XY.csv
- Export from Spatialite point layer (EPSG:31468)
(1.84 KB)
Related issues
Associated revisions
expression: validate places value of format_number (fixes #12796)
expression: validate places value of format_number (fixes #12796)
(cherry picked from commit 518072e9b319fa15848237b2a42a472421a40627)
History
#1
Updated by Saber Razmjooei over 9 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 9 years ago
- Target version set to Future Release - High Priority
#3
Updated by Jürgen Fischer over 9 years ago
- Status changed from Open to Feedback
Is that spatialite layer multipoint?
#4
Updated by Saber Razmjooei over 9 years ago
It is MULTIPOINT, indeed.
#5
Updated by Jochen Huber over 9 years ago
Yes, it is MULTIPOINT. Tested with POINT, and it works okay.
#6
Updated by Jürgen Fischer over 9 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 9 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 9 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 9 years ago
You can always log another ticket as a feature request.
https://github.com/romain974/qspatialite/issues/32