Route Viewer

Skip all this and head to route markup or read-only browser.

Append to database instead of clearing
Disable annotating features, read-only

Visualize geo.routes

Do a query in DBeaver or DataGrip or wherever and paste the rows here:

Routes for a user

Query a database for a user and dt. If the date is not set, downloads the last few routes for the user.

Source: geo.routes geo.history pgsql de pgsql ru
User: Date:
Enrich geo.routes data with geo.history points.

Random ClickHouse Routes

For annotation we need to fill the database with some routes.

Count:

Import JSONL

JSONLines file:

File format

Each line is a GeoJSON feature, looks like this:

{
  "type": "Feature",
  "geometry": {
    "type": "LineString",
    "coordinates": [[1.0, 3.0], [2.0, 5.0], ...]
  },
  "properties": {
    "timestamps": [23424234234, 12312312312, ...],
    "modes": [[0, "stop"], [5, "walk"], ...],
    "jumps": [8, 9, 15, 29],
    "stops": [[3, [4.0, 1.0]], [22, [10.4, 3.9], "bus"]]
  }
}

All properties are optional. The result would also have "processed" property if the set was annotated.

Download JSONL

You can get the contents of the database with
Only processed entries