sven4all

{
    "areaVisibility": true,
    "maxTransferDistance": 1000,
    "htmlAnnotations": true,
    "fares": {
      "type": "off"
    },
    "dataImportReport": true,
    "extraEdgesStopPlatformLink": true
}

sven4all

2019-10-02 06:51:06.201 [error] <0.492.0>@vmq_diversity_script_state:handle_info:172 can't call function auth_on_register with args [{addr,<<"10.133.94.70">>},{port,36376},{mountpoint,<<>>},{client_id,<<"test-client">>},{username,<<"test-user">>},{password,<<"123">>},{clean_session,true}] in "./share/lua/auth/postgres.lua" due to {badarg,'#',[false]}
2019-10-02 06:56:48.049 [error] <0.491.0>@vmq_diversity_script_state:handle_info:172 can't call function auth_on_register with args [{addr,<<"10.244.1.1">>},{port,54702},{mountpoint,<<>>},{client_id,<<"test-client">>},{username,<<"test-user">>},{password,<<"123">>},{clean_session,true}] in "./share/lua/auth/postgres.lua" due to {badarg,'#',[false]}

sven4all

mkdir -p /tmp/data/chb
cd /tmp/data/chb

echo "Import CHB passengerstopassignment started"

wget "data.ndovloket.nl/haltes/"
PSFILE="$(wget data.ndovloket.nl/haltes/ -O- | grep -o '<a class="link" href=".*">Passenger.*</a>' |  sed -r  's/<([^>]*?)>//g')"

if [ -n "$PSFILE" ]; then
    wget "data.ndovloket.nl/haltes/${PSFILE}" -O  new_passenger_stop_assignment_export.xml.gz

sven4all

-- Database structure that was used to store the data
-- Postgresql 10.5 + PostGis 2.4.4

CREATE TABLE cycle_measurement (
    sample_id INT,
    bike_id VARCHAR(255),
    location GEOGRAPHY,
    bike_type VARCHAR(10)
);