No description
  • Python 40.1%
  • TypeScript 26.5%
  • HTML 19%
  • Swift 7.9%
  • CSS 3.4%
  • Other 3.1%
Find a file
Repository files (latest commit first)
Filename Latest commit message Latest commit date
Martin Faust fcc22442d1
Some checks failed
CI / games (push) Failing after 1m1s
CI / frontend (push) Successful in 1m19s
CI / backend (push) Successful in 52s
Einkehren: Hinweis „Recherche läuft“ entfernt (Startseite, Unterwegs, Einkehren)
Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
Claude-Session: https://claude.ai/code/session_01VAPiqE8t24yAgwaqxo9xFK
2026-11-12 09:43:29 +01:00
.forgejo/workflows CI + Regressionstest gegen den PWA-Weißbild-Fehler 2026-08-09 08:38:46 +02:00
agents Require maintained city resources and document quarterly link review 2026-10-29 15:35:09 +01:00
backend Öffentliche Restaurantseiten /einkehren/<slug>; Bundesland-Seiten mit Top-20-Zielen und Restaurants 2026-11-11 22:36:35 +01:00
design Spiele: Prompt-Sammlung für on-brand Illustrationen 2026-08-08 08:42:48 +02:00
docs Konzept: Instagram-Kooperationen mit kleineren Attraktionen (Entwurf) 2026-11-11 22:44:09 +01:00
enrichment-playbooks Admin unter /admin/…, für Nicht-Admins überall 404, Admin-Werkzeuge raus aus der öffentlichen App 2026-10-20 21:50:50 +02:00
frontend Einkehren: Hinweis „Recherche läuft“ entfernt (Startseite, Unterwegs, Einkehren) 2026-11-12 09:43:29 +01:00
games JS-Fehlermeldungen auf allen Seiten und in den Spielen, zusammengefasst und gedrosselt 2026-11-11 08:46:07 +01:00
ios iOS-TODO: neues App-Icon im Geometrie-Look mit dem Restaurant-Update 2026-11-08 22:13:24 +01:00
studio Add Bilderbuch portal peeking character sprites 2026-11-11 23:17:00 +01:00
tools Startseite: ruhiger Hero mit Deutschlandkarte und Beispielrouten statt Slideshow und Kacheln 2026-11-10 22:49:11 +01:00
work-items Reciprocal profiles, favorites modal, admin charts/CRUD, DB source-of-truth 2026-07-29 07:04:00 +02:00
.gitignore Initial commit: off-the-path backend (FastAPI + PostGIS) 2026-07-22 20:42:58 +02:00
CLAUDE.md Tägliche Aufgabenliste (Mails, OSM-Antworten, OSM-Edit, Instagram-Planung) 2026-11-08 21:20:16 +01:00
enrichment-at.md data: Austria — 98 family attractions across all 9 Bundesländer 2026-07-26 02:42:03 +02:00
enrichment-be.md data: Benelux — NL (113), BE (98), LU (28) family attractions 2026-07-26 09:10:49 +02:00
enrichment-ch.md data: Switzerland — 109 family attractions across 25 cantons (trilingual) 2026-07-26 03:17:47 +02:00
enrichment-countries.md Aufnahmekriterien für Ausflugsziele zentral festgehalten 2026-10-27 11:10:21 +01:00
enrichment-fr.md data: France — 139 family attractions across all 13 régions 2026-07-26 13:29:47 +02:00
enrichment-it.md data: Italy fix pass — re-research 46 low-confidence/ODbL rows 2026-07-26 02:03:28 +02:00
enrichment-lu.md data: Benelux — NL (113), BE (98), LU (28) family attractions 2026-07-26 09:10:49 +02:00
enrichment-nl.md data: Benelux — NL (113), BE (98), LU (28) family attractions 2026-07-26 09:10:49 +02:00
enrichment.md docs: Welle 2 als erledigt vermerken (alle 481 Ziele angereichert) 2026-07-24 00:06:42 +02:00
README.md Initial commit: off-the-path backend (FastAPI + PostGIS) 2026-07-22 20:42:58 +02:00
TODO.md JS-Fehlermeldungen auf allen Seiten und in den Spielen, zusammengefasst und gedrosselt 2026-11-11 08:46:07 +01:00

off-the-path

A web app for family road trips: enter a start and end (driving only for now), and it shows kid-friendly attractions along the route on a map. Starts with Germany (Mecklenburg-Vorpommern seed data), built to expand across Europe.

Stack

  • Backend: FastAPI + SQLAlchemy 2.0 + GeoAlchemy2, PostgreSQL + PostGIS. Attractions "along the route" are found with a PostGIS corridor query (ST_DWithin + order by ST_LineLocatePoint). Routing/geocoding via OpenRouteService (driving-car), kept behind our own API so it can be swapped or self-hosted later. Until an ORS key is set, /route uses a straight line between the two points and start/end must be given as lat,lon (no geocoding).
  • Frontend: (planned) Vite + React + MapLibre GL.
  • API: auto OpenAPI/Swagger at /docs — the basis for the future phone app.

Backend — run locally

Needs a PostGIS database and an OpenRouteService API key.

cd backend
python -m venv .venv && source .venv/bin/activate
pip install -r requirements.txt
cp .env.example .env    # set DATABASE_URL + ORS_API_KEY
uvicorn app.main:app --reload

Postgres with PostGIS for local dev:

docker run -d --name otp-db -e POSTGRES_USER=offthepath -e POSTGRES_PASSWORD=offthepath \
  -e POSTGRES_DB=offthepath -p 5432:5432 postgis/postgis:17-3.5

On first start the app enables PostGIS, creates the schema, and seeds the initial attractions.

Endpoints

  • GET /api/health
  • GET /api/attractions?country=DE&age=6
  • GET /api/route?start=52.52,13.40&end=54.31,13.09&radius_km=20&age=6 (start/end are lat,lon; once an ORS key is set they also accept place names)

Deployment

Deployed from the mf-server repo (Ansible): a container behind Caddy at off-the-path.martinfaust.com, using the shared PostGIS instance (ensure_db), frontend served static with /api reverse-proxied to this backend.

Notes / TODO

  • Websites for the seed attractions are not filled in yet.
  • Add Alembic migrations once the schema settles.
  • Cache computed routes to stay within the ORS free-tier quota.