SqliteError: no such column: geojson.is_alt

[orangejulius]

Since our recent changes to use Who's on First data hosted by Geocode Earth made in #487, people using older WOF dist files from dist.whosonfirst.org will see the following error:

/code/pelias/csv-importer/node_modules/pelias-whosonfirst/src/components/sqliteStream.js:10
    this._iterator = this._db.prepare(sql).iterate();
                              ^
SqliteError: no such column: geojson.is_alt
    at new SQLiteStream (/code/pelias/csv-importer/node_modules/pelias-whosonfirst/src/components/sqliteStream.js:10:31)
    at /code/pelias/csv-importer/node_modules/pelias-wof-admin-lookup/src/pip/readStream.js:26:12
    at CombinedStream._realGetNext (/code/pelias/csv-importer/node_modules/combined-stream/lib/combined_stream.js:104:3)

To anyone seeing this error, the fix is to remove all your Who's on First data and run the downloader again. That will download new data from Geocode Earth.

However, since already several people have reported seeing this, I wonder if it makes sense to add some code to detect this condition and message appropriately.

[petertoner]

I am setting up a new North America installation this week. All data downloaded from scratch following along with the Docker instructions and still got the same error as this. What steps are necessary after downloading WOF data again? Other considerations? Any help would be appreciated!

[stefanocudini]

I have same problem!

[orangejulius]

@stefanocudini can you post the output of ls -lh as well as md5sum *.db for all your wof SQLite db files? They should be in $DATA_DIR/whosonfirst

This really shouldn't be a problem these days, so unless you are using very old data (before april of this year), something else might be going on that we aren't aware of.