Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Can't export lines to geopackage due to duplicated column names #431

Open
asongtoruin opened this issue Nov 11, 2022 · 0 comments
Open

Can't export lines to geopackage due to duplicated column names #431

asongtoruin opened this issue Nov 11, 2022 · 0 comments
Labels
bug An identified bug

Comments

@asongtoruin
Copy link

What is the bug?

Hello, I have successfully (and very easily!) downloaded some OSM data - however, when I try to save the lines output to a geopackage, QGIS gives an error due to duplicated column names. I can't seem to find the error as copyable text, so here's a screenshot:

image

From looking at the data, it seems as though the download includes both type and TYPE as separate columns and I believe geopackage insists on all lower-case column names.

It looks like this might be a quirk on the OSM-side, but would there be any way for QuickOSM to pre-process the data and ensure uniqueness of (lower case) column names?

The query I ran is as follows:

{"query": ["[out:xml] [timeout:25];\n(\n    node( {{bbox}});\n    way( {{bbox}});\n    relation( {{bbox}});\n);\n(._;>;);\nout body;"], "description": ["All OSM objects in the canvas or layer extent are going to be downloaded."], "advanced": false, "file_name": "", "query_layer_name": [""], "query_name": ["Query1"], "type_multi_request": [[]], "keys": [[""]], "values": [[""]], "area": [""], "bbox": [{"__extent__": "-3.246191445775106 55.94311319126636 -3.155759203527417 55.97216842876525"}], "output_geom_type": [[{"__enum__": "LayerType.Points"}, {"__enum__": "LayerType.Lines"}, {"__enum__": "LayerType.Multilinestrings"}, {"__enum__": "LayerType.Multipolygons"}]], "white_list_column": [{"multilinestrings": null, "points": null, "lines": null, "multipolygons": null}], "output_directory": [""], "output_format": [""]}

Environment

  • QuickOSM version: 2.1.1
  • QGIS version: 3.24.0
  • OS: Windows 10
@asongtoruin asongtoruin added the bug An identified bug label Nov 11, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug An identified bug
Projects
None yet
Development

No branches or pull requests

1 participant