Baselight

Sites And Attractions

North Somerset Council

@ukgov.sites_and_attractions_nsc

Loading...
Loading...

About this Dataset

Sites And Attractions

This dataset includes tourist attractions, local producers, heritage sites, arts and crafts.

Information is maintained by North Somerset Council to support essential service delivery and is being made available as open to support wider usage and promotion of North Somerset as an attractive location to live, visit and invest in.

The information in the dataset will continue to grow based on feedback received and suggestions from the Discover North Somerset website. If errors or omissions are found, these can be reported and will be updated as soon as possible.
Publisher name: North Somerset Council
Last updated: 2024-09-14T14:43:16Z

Tables

Sites And Attractions

@ukgov.sites_and_attractions_nsc.sites_and_attractions
  • 99.1 KB
  • 122 rows
  • 52 columns
Loading...

CREATE TABLE sites_and_attractions (
  "publisher_label" VARCHAR,
  "publisher_uri" VARCHAR,
  "site_reference" BIGINT,
  "site_name" VARCHAR,
  "summary" VARCHAR,
  "description_1" VARCHAR,
  "description_2" VARCHAR,
  "type_1" VARCHAR,
  "type_2" VARCHAR,
  "tags" VARCHAR,
  "address_1" VARCHAR,
  "address_2" VARCHAR,
  "address_3" VARCHAR,
  "postcode" VARCHAR,
  "website_1" VARCHAR,
  "website_2" VARCHAR,
  "email" VARCHAR,
  "phone" VARCHAR,
  "category_attraction" BIGINT,
  "category_arts_and_culture" BIGINT,
  "category_food_drink_producer" BIGINT,
  "category_nature_environment" BIGINT,
  "category_history_heritage" BIGINT,
  "category_ative_lifestyles_sports" BIGINT,
  "category_open_spaces" BIGINT,
  "category_shopping_retail" BIGINT,
  "category_family_friendly" BIGINT,
  "category_venue_for_events" BIGINT,
  "venue_description" VARCHAR,
  "all_weather" VARCHAR,
  "opening_times" VARCHAR,
  "accessibility" VARCHAR,
  "pet_friendly" VARCHAR,
  "parking" VARCHAR,
  "visit_time" VARCHAR,
  "uprn" DOUBLE,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "nsc_map_link" VARCHAR,
  "google_map_link" VARCHAR,
  "walk_time_bus" VARCHAR,
  "nearest_bus_stop" VARCHAR,
  "walk_time_train" VARCHAR,
  "nearest_train_station" VARCHAR,
  "directions" VARCHAR,
  "nearest_bus_service" VARCHAR,
  "image" VARCHAR,
  "cost_free" DOUBLE,
  "cost_details" VARCHAR,
  "slug" VARCHAR
);

Share link

Anyone who has the link will be able to view this.