The repo helps to scan the trajectory figures to a local SQLite3 database. In addtion, it can help create the done_filelist.txt for trajectory figures, which is essential for appending the trajectory figures into the PollyNET database.
git clone https://github.com/ZPYin/traj_file_scanner.git
or click here for direct download.
conda create -n traj_scanner
activate traj_scanner # windows
source activate traj_scanner # linux
cd traj_file_scanner
conda install python=3.6
pip install -r requirements.txt
👉 Remember you need to rename all the configuration files with removing the suffix of .sample!!!
setup done_filelist
You need to configure the TRAJECTORY_ROOT POLLYAPP_CONFIG_FILE and DONE_FILELIST, according to your own demands.
scan into SQLite3 DB
You need to configure the TRAJECTORY_ROOT and db_path.
cd src
python trajectory_scanner.py
Note
The command line interface is not setup for the script. Therefore, you may need to comment and uncommet the code in the main function to control the functionality.
structure
table
ID
- auto-increment from 1
- INT
imgpath
- fullpath of the figure
- TEXT
category
- product type
| value | type |
|---|---|
| 1 | geonames-abs-regions-ens-below2.0 |
| 2 | geonames-abs-regions-ens-below5.0 |
| 3 | geonames-abs-regions-ens-below8.0 |
| 4 | geonames-abs-regions-ens-belowmd |
| 5 | land-use-occ-ens-below2.0 |
| 6 | land-use-occ-ens-below5.0 |
| 7 | land-use-occ-ens-below8.0 |
| 8 | land-use-occ-ens-belowmd |
| 9 | trajectories_map |
| 10 | trajectories_prof |
pollynet_station
- PollyNET station name
- TEXT
gdas1_station
- gdas1 station name
- TEXT
Note: this name is unique and it can be projected to multiple PollyNET station name. The lookup table can be found in name_lookup_table.
ending_height
- ending height of the trajectories.
- REAL
start_time
- start time of the figure
- TEXT
stop_time
- stop time of the figure
- TEXT
upload_time
- upload time of the figure
- TEXT
insert_time
- insert time of the entry
- TEXT
- Zhenping
- zhenping@tropos.de