search

ptrv / gpx2spatialite

GNU General Public License v3.0
23 stars 8 forks source link

Updatelocations function doesn't insert 'Unknown' location #4

Closed belasco closed 11 years ago

belasco commented 11 years ago

I'm not sure if this is expected behaviour or not but running gpx2spatialite with the updatelocations option recently I noticed that locations that should be labelled 'Unknown' were remaining as NULL.

For me, this impacts on various analyses I do on the database and will also impact on the labelling for the animation.

belasco commented 11 years ago

Looking at this issue a bit more, I wonder if there's a structural problem with the database. I get an sql error when I try and run an update query on a row with NULL in citydefs: SQL error: "no such function: RTreeAlign"

Hmm...

ptrv commented 11 years ago

Yes, citydef_uid has not been set if it was NULL. Is fixed now. And with commenting out the foreign_key line makes it possible to to update again. The database structure should be checked again for other problems with foreign key dependencies. What kind of updates did you want to do besides updating citydef_uids in trackpoints?

belasco commented 11 years ago

At the moment, I can't think of another update I would need to make, other than simply adding new files as normal. Adding new locations to the database will always mean updating citydef_uids.

I've also found a related issue which I will now open.