gpx2spatialite
Project description
A script for importing GPX files into a SpatiaLite database.
Using Tomo Krajina’s gpx module, import a file record, trackpoints and tracklines to a database (SQL for database below)
Installation
gpx2spatialite is available via pip. To install it with user scope run the following command:
pip install gpx2spatialite --user
Make sure that $HOME/.local/bin is available in your PATH environment variable. Otherwise the gpx2spatialite executable will not be found when you run it from the shell:
PATH=$PATH:$HOME/.local/bin
Usage
It is possible to read in single files:
gpx2spatialite -d <path/to/database> -u <user_id> <path/to/gpx>
Or multiple folders:
gpx2spatialite -d <path/to/database> -u <user_id> <path/to/folder1> <path/to/folder2>
Files and folders can be specified both at the same time:
gpx2spatialite -d <path/to/database> -u <user_id> <path/to/folder1> <path/to/gpx>
Create a new database
Run script to create a new database and initialize it:
gpx2spatialite_create_db <path/to/new/database>
CityDefs
Each trackpoint has a location assigned to it which is used for the drawinglife animation.
These are defined at import time unless the option -s or –skip-locations is passed.
Locations are defined in the citydefs table in the database, created and populated automatically by ‘gpx2spatialite_create_db’.
Import citydefs into existing database:
gpx2spatialite_citydefs -i <path/to/input.sql> <path/to/database>
Export citydefs table:
gpx2spatialite_citydefs -e <path/to/output.sql> <path/to/database>
After adding new locations to the citydefs table, you can look for currently unknown trackpoints and assign them to any relevant, newly defined locations with:
gpx2spatialite_updatelocs <path/to/database>
If you have redefined currently assigned locations or completely changed the citydefs table, you will want to redefine every trackpoint in the database, for which you use the -a or -all-locations option to the above script:
gpx2spatialite_updatelocs -a <path/to/database>
Unit tests
The repository contains the standalone py.test (version 2.5.2) script runtests.py.
Run the following command to run the tests:
python setup.py test
Dependencies
gpxpy
sqlite library with loading extension support or pyspatialite
Local Variables: mode: rst End:
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.