Create the dataset

Database Structure

Template Database

Download the SQLite file and edit the tables within.

Table	Type	Description
bewa_Overview	Table	The table that defines your trips. One trip per row.
bewb_Events	Table	The table containg detailed notes from your trips. One row per day (date).
bewx_ParticipantGroups	Table	Your travel groups. Feel free to edit.
bewx_TripDomains	Table	Trip types.
bewxx_Settings	Table	App settings storage (used when you bind the file to browser via File API).

For more detailed instructions, follow the Trip Syntax.

Coordinate tool

To obtain coordinates for a given position, you can use the Coordinate Tool and easily copy and paste the coordinates into the SQLite file.

Views

Views

The template contains some views too, used by the app. Do not edit these!

View	Type	Description
IIBa_Overview	View	Used by the app. Do not edit.
IIBaa_OverviewCountry	View	Used by the app. Do not edit.
IIBb_Events	View	Used by the app. Do not edit.
IIBc_BorderCrossings	View	Used by the app. Do not edit.