import

Documentation

Overview

cmd/import imports Dublin cycle parking data from Smart Dublin's open dataset and inserts stands that don't already exist in the database.

Usage:

go run ./cmd/import [--dry-run] [--type "Sheffield Stand"] [--url <geojson-url>]

Deduplication uses two signals combined:

Distance alone    ≤5m              → skip  (same physical rack regardless of count)
Distance + count  ≤20m, same count → skip  (same stand, counted consistently)
Distance alone    ≤20m             → warn  (close but counts differ — opposite side of road?)
Distance + count  ≤50m, same count → warn  (same count, suspiciously nearby)

Stand count is only used as a signal when both sides have a recorded value > 0.

Environment variables (same as main server):

DBP_DB_DIALECT          sqlite3 (default) | mysql
DBP_DB_CONNECTION_STRING ./demo.db (default)