FODC Car Parks

CREATE TABLE fodc_car_park_charges (
  "applicable_charge_scheme" VARCHAR,
  "vehicle_types" VARCHAR,
  "charge_up_to_one_hour" DOUBLE  -- Charge (Ł) - Up To One Hour,
  "charge_over_one_hour_not_exceeding_two_hours" DOUBLE  -- Charge (Ł) - Over One Hour & Not Exceeding Two Hours,
  "charge_over_two_hours_not_exceeding_three_hours" DOUBLE  -- Charge (Ł) - Over Two Hours & Not Exceeding Three Hours,
  "charge_over_three_hours_not_exceeding_four_hours" DOUBLE  -- Charge (Ł) - Over Three Hours & Not Exceeding Four Hours,
  "charge_over_four_hours_not_exceeding_five_hours" DOUBLE  -- Charge (Ł) - Over Four Hours & Not Exceeding Five Hours,
  "charge_over_five_hours_not_exceeding_six_hours" DOUBLE  -- Charge (Ł) - Over Five Hours & Not Exceeding Six Hours,
  "charge_over_six_hours_not_exceeding_seven_hours" DOUBLE  -- Charge (Ł) - Over Six Hours & Not Exceeding Seven Hours,
  "charge_over_seven_hours_not_exceeding_eight_hours" DOUBLE  -- Charge (Ł) - Over Seven Hours & Not Exceeding Eight Hours,
  "charge_over_eight_hours" DOUBLE  -- Charge (Ł) - Over Eight Hours,
  "charge_within_1_hour_of_car_park_closing" DOUBLE  -- Charge (Ł) - Within 1 Hour Of Car Park Closing
);

CREATE TABLE fodc_car_parks (
  "car_park_name" VARCHAR,
  "town" VARCHAR,
  "postcode" VARCHAR,
  "parking_charges" VARCHAR,
  "latitude_y" DOUBLE  -- Latitude (y),
  "longitude_x" DOUBLE  -- Longitude (x),
  "spaces" BIGINT
);