Belfast Council Car Parks

CREATE TABLE belfast_council_car_parks (
  "name" VARCHAR,
  "address" VARCHAR,
  "postcode" VARCHAR,
  "non_designated_bays" BIGINT,
  "x_co_ordinate" BIGINT,
  "y_co_ordinate" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "blue_badge_bays" DOUBLE,
  "family_friendly_bays" DOUBLE,
  "e_car_bays" DOUBLE,
  "tariff" VARCHAR,
  "charged_hours" VARCHAR
);

CREATE TABLE belfast_council_car_park_tariffs (
  "name" VARCHAR,
  "tariff" VARCHAR,
  "n_0_to_1_hours" VARCHAR  -- 0 TO 1 HOURS,
  "n_1_to_2_hours" VARCHAR  -- 1 TO 2 HOURS,
  "n_2_to_3_hours" VARCHAR  -- 2 TO 3 HOURS,
  "n_3_to_4_hours" VARCHAR  -- 3 TO 4 HOURS,
  "n_4_to_5_hours" VARCHAR  -- 4 TO 5 HOURS,
  "n_5_to_6_hours" VARCHAR  -- 5 TO 6 HOURS,
  "n_6_to_7_hours" VARCHAR  -- 6 TO 7 HOURS,
  "n_7_to_8_hours" VARCHAR  -- 7 TO 8 HOURS,
  "n_8_hours" VARCHAR  -- 8+ HOURS,
  "monthly_season_ticket" VARCHAR,
  "quarterly_season_ticket" VARCHAR
);