2

QGIS 2.18.2 I am downlaoding OSM data for a QGIS project.
The first 2 steps work fine: Vector/OpenStreetMap/Download data and Import topology from XML. However when I try to execute step 3 - Export topology to SpatiaLite - I get an error "Failed to export OSM data: Unable to create table. Duplicate column name FIXME." The error occurs for all 3 export types, point, line and polygon.

Improve this question
5
  • Can you add the bounding box where you downloaded the data to reproduce the error?
    – AndreJ
    Commented Feb 3, 2017 at 6:45
  • What tags are you trying to save?
    – HeikkiVesanto ♦
    Commented Feb 3, 2017 at 14:26
  • 1
    does this answer help? I sometimes find there are two or more (case-sensitive) spellings of 'fixme'. If you uncheck one of them the error will go away (but you may lose some of the 'fixme' data)
    – Steven Kay
    Commented Feb 3, 2017 at 20:38
  • If the raw .osm file is not too big, you can search&replace any FIXME with fixme before step 2 to avoid data loss.
    – AndreJ
    Commented Feb 4, 2017 at 6:35
  • Under Exported Tags I clicked on 'Load from DB' and then 'Select All'. I think this was the cause of the problem. If I select only one tag, all goes well. The case FIXME in the error message was all upper. Lack of understanding of what was happening I suspect was my main problem. Thanks all.
    – Bill C
    Commented Feb 5, 2017 at 3:21

1 Answer 1

Reset to default
1

I too experienced the same problem. The error is caused if two(or more) data columns in the attribute tables have the same name. Resolve it by loading them in separately and editing the and later merge them. Here's an example of me using an osm data set the entries FIXme and fixme are the same and have to be edited separatelyimage showing the two data points to be loaded in the database

Hope this helps and happy GIS

edit: other common stuff you may find may be Name/Notes etc So go through everything

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.