Sites And Attractions
North Somerset Council
@ukgov.sites_and_attractions_nsc
North Somerset Council
@ukgov.sites_and_attractions_nsc
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
);
Anyone who has the link will be able to view this.