MobilityDB Workshop

Every module in this workshop illustrates a usage scenario of MobilityDB. The data sets and the tools are described inside each of the modules.

Quickstart

Run the workshop locally with Docker. The image bundles PostgreSQL 18, PostGIS 3.6, MobilityDB 1.3, and the workshop datasets under /Workshop, so no downloads or edits are required.

docker run --name mobilitydb -d -p 5432:5432 mobilitydb/mobilitydb:18-3.6-1.3-workshop

Build the GTFS trips from the bundled data:

docker exec -w /Workshop/gtfs_data mobilitydb \
  psql -U docker -d mobilitydb -f load_gtfs.sql -f load_mobilitydb.sql

Query the result:

docker exec -it mobilitydb \
  psql -U docker -d mobilitydb -c "SELECT trip_id, duration(trip) FROM trips_mdb ORDER BY trip_id LIMIT 5;"

The AIS dataset is bundled at /Workshop/ais_data/ais.csv. Follow the chapters for the full tutorials.

Documentation

You can generate the workshop documentation from the sources. Go to /docs directory and run:

• In HTML format

  xsltproc --stringparam html.stylesheet "docbook.css" --stringparam chunker.output.encoding "UTF-8"  --xinclude -o index.html /usr/share/xml/docbook/stylesheet/docbook-xsl/html/chunk.xsl mobilitydb-workshop.xml

• In PDF format

  dblatex -s texstyle.sty -T native -t pdf -o mobilitydb-workshop.pdf mobilitydb-workshop.xml 

• In EPUB format

  dbtoepub -o mobilitydb-workshop.epub mobilitydb-workshop.xml

In addition, pregenerated versions of them are available for the master branch.

• HTML: master
• PDF: master
• EPUB: master

How the Repo is Organized

• /data: raw data files used for some workshops
• /docs: files needed to generate the workshop documentation from sources

Docker container

A prebuilt Docker image is available with PostgreSQL 18, PostGIS 3.6, and MobilityDB 1.3, with the workshop data files pre-bundled.

• Pull the image:

  docker pull mobilitydb/mobilitydb:18-3.6-1.3-workshop

• Run the container:

  docker run --name mobilitydb -d -p 5432:5432 mobilitydb/mobilitydb:18-3.6-1.3-workshop

• Connect to the database:

  docker exec -it mobilitydb psql -U docker -d mobilitydb

The workshop data files are pre-loaded under /Workshop/gtfs_data/ and /Workshop/ais_data/ inside the container.

License

This workshop is licensed under a Creative Commons Attribution-Share Alike 3.0 License