Now TeslaMate is up and running and performing automatic backups as expected, you can inject in the current (as of 12/5/2020) UK destination charger locations.
Connecting to the database
Firstly, ssh into your pi / box that TeslaMate is running on.
To access to the TeslaMate database, run the following command: docker exec -it teslamate_database_1 psql -U teslamate
If an error is returned, that it cannot find a database of this name, run: docker ps
This returns a list of running docker containers, you should then see the correct name of your database container, mine for example is pi_database_1
You can then adjust the command above (docker exec -it teslamate_database_1 psql -U teslamate) to the new value, in this example: docker exec -it pi_database_1 psql -U teslamate
Once connected, you can now check which geofence locations you already have listed with the following command: SELECT * FROM geofences;
If you already have some destination chargers you’ve already entered, I’d suggest removing them from the below list before importing.
Bulk importing
EDIT 5/10/2020 – This import list has been updated to reflect the new TeslaMate table in version 1.20, if you wish to use on an older version, you will need to search and replace the below text, swapping cost_per_unit with cost_per_kwh
Once you are ready to import, run the following:
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Grange Guest House', 51.945524, -3.386893, 35, '2020-09-27 05:30:00 ', '2020-09-27 05:30:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Balbirnie House', 56.209595, -3.143474, 35, '2020-08-05 05:33:00 ', '2020-08-05 05:33:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Castle Hotel', 51.015426, -3.104144, 35, '2020-03-15 09:42:00 ', '2020-03-15 09:42:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Ockenden Manor Hotel and Spa', 51.006566, -0.144636, 35, '2019-10-18 05:53:00 ', '2019-10-18 05:53:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Congham Hall Hotel & Spa', 52.776536, 0.535316, 35, '2019-10-12 05:46:00 ', '2019-10-12 05:46:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Bloomsburys Biddenden', 51.115045, 0.627198, 35, '2019-10-12 05:43:00 ', '2019-10-12 05:43:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Little Silver House', 50.971722, -3.964766, 35, '2019-10-12 05:42:00 ', '2019-10-12 05:42:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Bovey Castle Hotel', 50.647716, -3.802057, 35, '2019-09-08 05:35:00 ', '2019-09-08 05:35:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('University of Edinburgh - Salisbury Green Hotel', 55.938104, -3.171161, 35, '2019-09-08 05:34:00 ', '2019-09-08 05:34:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Ashford Designer Outlet', 51.136274, 0.87736, 35, '2019-09-07 05:32:00 ', '2019-09-07 07:30:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Trenderway Farm B&B and Wedding Venue', 50.351933, -4.512193, 35, '2019-08-28 20:07:00 ', '2019-08-28 20:07:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Radisson Blu Hotel Edinburgh', 55.950078, -3.186821, 35, '2019-08-28 20:01:00 ', '2019-08-28 20:01:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Lime Wood', 50.862364, -1.554802, 35, '2019-08-28 19:56:00 ', '2019-08-28 19:56:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Moat House, Acton Trussell', 52.756225, -2.09662, 35, '2019-08-28 19:52:00 ', '2019-08-28 19:52:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Helen Browning's Royal Oak', 51.552089, -1.648055, 35, '2019-08-28 19:51:00 ', '2019-08-28 19:51:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Queens Arms', 51.000471, -2.521205, 35, '2019-07-31 05:50:00 ', '2019-07-31 05:50:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Kingsley At Eversley', 51.348932, -0.872132, 35, '2019-07-30 09:33:00 ', '2019-07-30 09:33:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Tigh An Truish Inn', 56.31776, -5.584132, 35, '2019-07-30 09:27:00 ', '2019-08-28 19:49:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Blacksmiths Arms', 54.413944, -1.268319, 35, '2019-07-30 09:24:00 ', '2019-07-30 09:24:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Bagshaw Hall', 53.214315, -1.678081, 35, '2019-07-30 09:20:00 ', '2019-07-30 09:20:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Durrant House Hotel', 51.034214, -4.212188, 35, '2019-07-30 09:17:00 ', '2019-07-30 09:17:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Fraithwen Cottages', 52.5976839827516, -3.38449336307031, 35, '2019-07-27 12:31:00 ', '2019-07-30 09:39:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Bedruthan Hotel & Spa', 50.469472, -5.028714, 35, '2019-07-19 05:42:00 ', '2019-07-19 05:42:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Trevase Granary', 51.92598, -2.711679, 35, '2019-07-15 16:19:00 ', '2019-07-15 16:19:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Willowbeck Lodge', 54.887439, -2.874733, 35, '2019-07-15 16:19:00 ', '2019-07-15 16:19:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Baraset Barn', 52.202722, -1.663184, 35, '2019-07-15 16:18:00 ', '2019-07-15 16:18:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Goudhurst Parish Hall', 51.112304, 0.458989, 35, '2019-07-15 16:11:00 ', '2019-07-15 16:11:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Budock Vean Hotel', 50.105833, -5.132658, 35, '2019-07-15 16:08:00 ', '2019-07-15 16:08:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Angelo's Preston', 53.757734, -2.697432, 35, '2019-07-15 16:07:00 ', '2019-07-15 16:07:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Swan Hotel', 52.326206, 1.679486, 35, '2019-07-15 16:06:00 ', '2019-07-15 16:06:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Oxford Country Cottages', 51.810714, -1.201071, 35, '2019-06-13 06:05:00 ', '2019-06-13 06:05:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Grove End', 51.653968, -0.376298, 35, '2019-06-11 10:10:00 ', '2019-06-11 10:10:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Voco St David's Hotel', 51.460517, -3.167412, 35, '2019-06-05 12:01:00 ', '2019-06-05 12:01:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Maryculter House Hotel', 57.089645, -2.258955, 35, '2019-06-05 11:35:00 ', '2019-06-05 11:35:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Imperial Hotel', 53.323206, -3.823826, 35, '2019-05-22 05:39:00 ', '2019-05-22 05:39:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Best Western Plus Windmill Village Hotel, Golf Club & Spa', 52.426967, -1.575998, 35, '2019-05-17 05:49:00 ', '2019-05-17 05:49:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('South Lodge Hotel', 51.015448, -0.263598, 35, '2019-05-17 05:48:00 ', '2019-05-17 05:48:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Royal Berkshire Hotel', 51.407508, -0.634834, 35, '2019-05-16 05:42:00 ', '2019-05-16 05:42:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Pentillie Castle', 50.4593552384828, -4.24168086642294, 35, '2019-05-16 05:39:00 ', '2019-05-30 19:01:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Huntstile Organic Farm', 51.098375, -3.049415, 35, '2019-05-15 05:47:00 ', '2019-05-15 07:54:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Best Western Hotel Bristol At Newquay', 50.417432, -5.071411, 35, '2019-05-14 05:36:00 ', '2019-05-14 05:36:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Royal Crescent Hotel & Spa', 51.387342, -2.368139, 35, '2019-04-19 05:56:00 ', '2020-10-04 07:41:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Stormont Hotel', 54.593724, -5.839142, 35, '2019-04-19 05:55:00 ', '2019-04-19 05:55:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Glenapp Castle', 55.084021, -4.988205, 35, '2019-03-21 06:50:00 ', '2019-03-21 06:50:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Santos Higham Farm Hotel & Restaurant', 53.125839, -1.418979, 35, '2019-03-14 23:32:00 ', '2019-03-14 23:32:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Cheshire Oaks Designer Outlet', 53.265172, -2.881299, 35, '2019-03-14 23:30:00 ', '2019-03-14 23:30:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Derby Conference Centre', 52.904484, -1.448363, 35, '2019-03-14 23:29:00 ', '2019-03-14 23:29:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Beechenhill Farm', 53.069769, -1.808354, 35, '2019-03-14 23:29:00 ', '2019-03-14 23:29:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Ship Hotel', 52.962966, 0.638358, 35, '2019-03-14 23:28:00 ', '2019-03-14 23:28:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('De Vere Tortworth Court', 51.630529, -2.443997, 35, '2019-03-14 23:23:00 ', '2019-03-14 23:23:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Mansion House Llansteffan', 51.795576, -4.367758, 35, '2019-03-14 23:22:00 ', '2019-04-20 05:33:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Bewicke Arms and Hare Pie Rooms', 52.560318, -0.83903, 35, '2019-03-14 23:08:00 ', '2019-03-14 23:08:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Potarch Cafe and Restaurant', 57.064838, -2.650853, 35, '2019-03-14 23:07:00 ', '2019-03-14 23:07:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Chapter One Restaurant', 51.365871, 0.053105, 35, '2019-02-12 11:38:00 ', '2019-02-12 11:38:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Duncombe Arms', 52.98619, -1.826397, 35, '2019-02-12 11:35:00 ', '2019-02-12 11:35:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Skeabost House Hotel', 57.454418, -6.314832, 35, '2019-01-19 06:35:00 ', '2019-01-19 06:35:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Rickman Barn Warter Priory Estate', 53.9443646, -0.6694364, 35, '2019-01-18 06:38:00 ', '2019-01-18 06:38:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Loch Fyne Oyster Oyster Bar and Deli', 56.271957, -4.927212, 35, '2019-01-04 06:37:00 ', '2019-01-04 06:37:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Gleneagles', 56.283383, -3.75199, 35, '2019-01-04 06:36:00 ', '2019-01-04 06:36:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('South Lodge Boutique B&B', 52.024315, -0.661978, 35, '2019-01-03 08:10:00 ', '2019-01-03 08:10:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('New Place Hotel', 50.91852, -1.194756, 35, '2019-01-03 08:09:00 ', '2019-11-26 11:37:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Van Hage Garden Centre', 51.794335, -0.019857, 35, '2019-01-03 08:04:00 ', '2019-01-03 08:04:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Pennyhill Park Hotel & Spa', 51.356898, -0.708899, 35, '2019-01-03 08:03:00 ', '2019-01-03 08:34:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Mottram Hall Hotel', 53.312196, -2.173484, 35, '2019-01-03 08:02:00 ', '2019-01-03 08:02:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Wellington Arms', 51.336993, -0.999648, 35, '2019-01-03 07:54:00 ', '2019-01-03 07:54:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Pool House', 57.766515, -5.602653, 35, '2019-01-03 07:53:00 ', '2019-01-03 08:51:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Maunsel House', 51.06568, -2.993692, 35, '2019-01-03 07:48:00 ', '2019-01-03 07:48:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Silverlake', 50.691168, -2.347711, 35, '2019-01-03 06:45:00 ', '2019-01-03 06:45:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Pant du', 53.053461, -4.271632, 35, '2019-01-02 22:06:00 ', '2019-01-02 22:06:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Beechfield House Hotel', 51.390026, -2.140125, 35, '2019-01-02 22:05:00 ', '2019-01-02 22:05:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Sunseeker Poole', 50.714549, -1.992038, 35, '2019-01-02 22:05:00 ', '2019-01-02 22:05:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Ramada Birmingham Sutton Coldfield', 52.53636, -1.807692, 35, '2019-01-02 22:03:00 ', '2019-01-02 22:03:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Alderley Edge Hotel', 53.298634, -2.234038, 35, '2019-01-02 22:00:00 ', '2019-01-02 22:00:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Gilwell Park', 51.648851, 0.003133, 35, '2019-01-02 21:59:00 ', '2019-01-02 21:59:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Raffles', 50.729368, -3.527845, 35, '2019-01-02 21:58:00 ', '2019-01-02 21:58:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Abbeyfield Lodge', 54.520455, -1.357175, 35, '2019-01-02 21:57:00 ', '2019-01-02 21:57:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Bidwell Farm Cottages', 50.857717, -3.131476, 35, '2019-01-02 21:50:00 ', '2019-01-02 21:50:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Belfry Hotel & Resort', 52.554266, -1.731653, 35, '2019-01-02 21:47:00 ', '2019-01-02 21:47:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Beacon Hill Farm', 55.21768, -1.772388, 35, '2019-01-02 21:43:00 ', '2019-01-02 21:43:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Impeccable Pig', 54.653993, -1.448381, 35, '2019-01-02 21:40:00 ', '2019-01-02 21:40:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Lords of the Manor', 51.906492, -1.774743, 35, '2019-01-02 21:35:00 ', '2019-01-02 21:35:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Amhurst Hotel', 51.574688, -0.079415, 35, '2019-01-02 21:34:00 ', '2019-01-02 21:34:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Castlecourt Shopping Centre', 54.600554, -5.93401, 35, '2019-01-02 21:33:00 ', '2019-01-02 21:33:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Orchard Hotel & East Midlands Conference Centre', 52.939233, -1.202268, 35, '2019-01-02 21:32:00 ', '2019-01-02 21:32:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Casa Hotel', 53.250759, -1.423999, 35, '2019-01-02 21:27:00 ', '2019-01-02 21:27:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Mackays Hotel', 58.441213, -3.093845, 35, '2018-10-11 14:40:00 ', '2018-10-11 14:40:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Cooden Beach Hotel', 50.833172, 0.427386, 35, '2018-10-11 14:36:00 ', '2018-10-11 14:36:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Goblin Parking', 51.3767, -2.725675, 35, '2018-10-11 14:34:00 ', '2018-10-11 14:34:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Coast View Holiday Park', 50.534673, -3.503398, 35, '2018-10-11 14:32:00 ', '2018-10-11 14:32:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Mains of Newhall', 57.657867, -4.175886, 35, '2018-10-11 14:30:00 ', '2018-10-11 14:30:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Rialto Lounge', 51.230305, -0.334356, 35, '2018-10-11 14:24:00 ', '2018-10-11 14:24:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Cavendish Hotel', 53.24552, -1.616198, 35, '2018-10-11 14:23:00 ', '2018-10-11 14:23:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Jockey Club Rooms', 52.243055, 0.404978, 35, '2018-10-11 14:18:00 ', '2018-10-11 14:18:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Plas Coch Holiday Park', 53.190417, -4.233559, 35, '2018-10-11 14:16:00 ', '2018-10-11 14:16:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Eastwell Manor', 51.191723, 0.884945, 35, '2018-10-11 14:15:00 ', '2018-10-11 14:15:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Crab & Boar', 51.464135, -1.345669, 35, '2018-10-11 14:13:00 ', '2018-10-11 14:13:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Hotel Plas Hyfryd', 51.800553, -4.745481, 35, '2018-10-11 14:07:00 ', '2018-10-11 14:07:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Morley Hayes', 52.975428, -1.404159, 35, '2018-10-11 14:07:00 ', '2018-10-11 14:07:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Incom House - Manchester United Car Parking', 53.466788, -2.294976, 35, '2018-10-11 14:06:00 ', '2018-10-11 14:06:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Black Boy Inn', 53.141267, -4.275942, 35, '2018-10-11 13:53:00 ', '2018-10-11 13:53:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Stonehenge Campsite and Glamping Pods', 51.164319, -1.89469, 35, '2018-10-11 13:52:00 ', '2018-10-11 13:52:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Esplanade Hotel', 50.412163, -5.103441, 35, '2018-10-11 13:51:00 ', '2018-10-11 13:51:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Higher Wiscombe', 50.733902, -3.162412, 35, '2018-10-11 13:51:00 ', '2018-10-11 13:51:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Frilford Heath Golf Club', 51.678889, -1.361854, 35, '2018-10-11 13:49:00 ', '2018-10-11 13:49:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Knock Castle Hotel & Spa', 56.380648, -3.846406, 35, '2018-10-11 13:48:00 ', '2018-10-11 13:48:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Bourne Valley Inn', 51.246825, -1.391967, 35, '2018-10-11 13:47:00 ', '2018-10-11 13:47:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Platform Lifestyle, Home & Gift', 57.667259, -2.504158, 35, '2018-10-11 13:37:00 ', '2018-10-11 13:37:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Old Barn Tregonetha', 50.441052, -4.881115, 35, '2018-10-11 13:31:00 ', '2018-10-11 13:31:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Gara Rock Hotel', 50.22102, -3.751569, 35, '2018-10-11 13:29:00 ', '2018-10-11 13:29:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Park House Hotel', 50.960783, -0.774322, 35, '2018-10-11 13:24:00 ', '2018-10-11 13:24:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Crown', 53.296088018584, -2.09186626721316, 35, '2018-10-11 13:23:00 ', '2019-06-07 06:04:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Duncombe Arms Waresley', 52.17529, -0.173312, 35, '2018-10-11 13:19:00 ', '2018-10-11 13:19:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Dunalastair Hotel Suites', 56.700737, -4.187606, 35, '2018-10-11 13:13:00 ', '2018-10-11 13:13:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Forthside Car Park', 56.117575, -3.929941, 35, '2018-10-11 13:08:00 ', '2018-10-11 13:08:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Badgemore Park', 51.542472, -0.923848, 35, '2018-10-11 13:06:00 ', '2018-10-11 13:06:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Knockendarroch Hotel', 56.703645, -3.727347, 35, '2018-10-11 13:01:00 ', '2018-10-11 13:01:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Fisherman's Retreat', 53.655762, -2.290255, 35, '2018-10-11 12:58:00 ', '2018-10-11 12:58:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Upper Vobster Farm', 51.244346, -2.425788, 35, '2018-10-11 12:51:00 ', '2018-10-11 12:51:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Manor By the Lake', 51.892218, -2.126606, 35, '2018-10-11 12:49:00 ', '2018-10-11 12:49:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('White Horse Graffham', 50.950135, -0.683522, 35, '2018-10-11 12:49:00 ', '2018-10-11 12:49:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Bicester Hotel Golf & Spa', 51.886358, -1.197036, 35, '2018-10-11 12:45:00 ', '2018-10-11 12:45:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Glynnmeddig Barn', 51.970089, -3.582229, 35, '2018-10-11 12:43:00 ', '2018-10-11 12:43:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Glencoe House', 56.687745, -5.099769, 35, '2018-10-11 12:42:00 ', '2018-10-11 12:42:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Carnegie Club At Skibo Castle', 57.873125, -4.132442, 35, '2018-10-11 12:37:00 ', '2018-10-11 12:44:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Caer Beris Manor Hotel & Restaurant', 52.145899, -3.419994, 35, '2018-10-11 12:37:00 ', '2018-10-11 12:37:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Anchor Inn', 51.18836, -0.903896, 35, '2018-10-11 12:37:00 ', '2018-10-11 12:38:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Homeplay Experience Centre', 51.415915, -0.430213, 35, '2018-10-11 12:34:00 ', '2019-01-03 06:33:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Three Acres Inn & Restaurant', 53.608493, -1.675404, 35, '2018-10-11 12:29:00 ', '2018-10-11 12:29:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('West Compton Manor', 50.746058, -2.62077, 35, '2018-10-11 12:29:00 ', '2018-10-11 12:29:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Fistral Beach Hotel & Spa', 50.412192, -5.106451, 35, '2018-10-11 12:28:00 ', '2018-10-11 12:28:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The White Horse', 50.923853, -0.823455, 35, '2018-10-11 12:25:00 ', '2018-10-11 12:25:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Bryn Elltyd Eco Guesthouse', 52.984863, -3.966485, 35, '2018-10-03 18:55:00 ', '2018-10-03 18:55:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Kingham Plough', 51.9152786, -1.62122039999997, 35, '2018-08-28 09:01:00 ', '2018-10-12 05:35:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Lake of Menteith Hotel', 56.182191, -4.285272, 35, '2018-06-23 05:30:00 ', '2018-10-03 14:52:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Boulder Hut', 53.293712, -2.918056, 35, '2018-06-17 05:36:00 ', '2018-10-03 17:48:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Val Wyatt Marine', 51.507627, -0.87058, 35, '2018-06-17 05:33:00 ', '2018-10-03 22:28:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Boringdon Hall Hotel and Gaia Spa', 50.4016, -4.056363, 35, '2018-06-17 05:33:00 ', '2018-10-03 18:25:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Pipe and Glass Inn', 53.895633, -0.535119, 35, '2018-06-17 05:33:00 ', '2018-10-03 21:31:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Cawdor', 51.882965, -3.992978, 35, '2018-06-17 05:30:00 ', '2018-10-03 15:07:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Artist Residence Oxford', 51.774723, -1.433803, 35, '2018-06-17 05:29:00 ', '2018-10-03 18:26:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Retreat East', 52.134322, 1.121377, 35, '2018-06-08 05:38:00 ', '2018-10-03 18:49:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Chapel Farm Guest House', 51.129246, -4.225431, 35, '2018-06-08 05:35:00 ', '2018-10-03 19:59:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Beach House Restaurant', 51.557063, -4.161065, 35, '2018-06-08 05:33:00 ', '2018-10-03 14:41:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Shipton Mill', 51.620039, -2.130961, 35, '2018-06-08 05:33:00 ', '2018-10-03 19:33:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Brewery House Bed & Breakfast', 54.963404, -4.485371, 35, '2018-06-08 05:32:00 ', '2018-10-03 21:22:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Kernock Cottages', 50.450996, -4.293139, 35, '2018-06-08 05:31:00 ', '2018-10-03 17:50:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Park Cornwall', 50.464978, -5.024464, 35, '2018-06-08 05:28:00 ', '2018-10-03 20:42:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Radisson Red Glasgow', 55.858578, -4.283023, 35, '2018-06-06 05:38:00 ', '2018-10-03 20:46:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Green House', 50.719526, -1.86817, 35, '2018-06-06 05:35:00 ', '2018-10-03 22:29:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Knockaloe Beg Farm', 54.209458, -4.703778, 35, '2018-06-06 05:31:00 ', '2018-10-03 19:54:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Holiday Inn Newport', 51.600069, -2.927657, 35, '2018-06-06 05:31:00 ', '2018-10-03 19:46:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Westwood Cross Shopping Centre', 51.359431, 1.392518, 35, '2018-05-26 05:41:00 ', '2018-10-12 05:31:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Seaview Holiday Park', 50.237213, -4.819088, 35, '2018-05-26 05:38:00 ', '2018-10-03 21:03:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Roehampton Club', 51.462948, -0.24512, 35, '2018-05-26 05:33:00 ', '2018-10-03 21:43:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Summer Lodge Hotel Restaurant & Spa', 50.838401, -2.605612, 35, '2018-05-26 05:32:00 ', '2018-10-03 14:15:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Idle Rocks Hotel', 50.15914, -5.013321, 35, '2018-05-20 05:43:00 ', '2018-10-03 17:47:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Aviator', 51.279313, -0.754894, 35, '2018-05-20 05:40:00 ', '2018-10-03 14:45:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Wooldown Holiday Cottages', 50.803284, -4.517118, 35, '2018-05-20 05:39:00 ', '2018-10-03 22:08:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Lower Mill Estate', 51.651803, -1.971886, 35, '2018-05-20 05:38:00 ', '2018-10-03 15:08:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The White Hart - Sherington', 52.112144, -0.69978, 35, '2018-05-20 05:37:00 ', '2018-10-03 16:41:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Orkney Distillery', 58.984492, -2.962882, 35, '2018-05-20 05:36:00 ', '2018-10-03 14:42:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Dandy's Topsoil', 53.205904, -2.955098, 35, '2018-05-20 05:29:00 ', '2018-10-03 15:53:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Bijou', 53.998485, -1.547124, 35, '2018-05-18 05:35:00 ', '2018-10-03 17:41:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Mannin Hotel', 54.157603, -4.47767, 35, '2018-05-18 05:34:00 ', '2018-10-03 19:21:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Penblaith Barn', 51.876102, -2.727669, 35, '2018-05-18 05:33:00 ', '2018-10-03 19:57:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Nook', 50.86183, -3.379127, 35, '2018-05-05 05:55:00 ', '2018-10-03 18:34:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Alexandra Hotel & Restaurant', 50.724969, -2.937107, 35, '2018-05-05 05:53:00 ', '2018-10-03 19:17:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Northcote Hotel', 53.809178, -2.447541, 35, '2018-05-05 05:44:00 ', '2018-10-03 17:00:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Angel Hotel', 51.821228, -3.017742, 35, '2018-05-04 05:46:00 ', '2018-10-03 21:40:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Neuadd Cottages', 51.847417, -3.155876, 35, '2018-05-04 05:44:00 ', '2018-10-03 21:18:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Oakley Hall Hotel', 51.246272, -1.200399, 35, '2018-05-04 05:41:00 ', '2018-10-03 16:55:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Manor Arms', 52.308466, -2.363561, 35, '2018-05-04 05:40:00 ', '2018-10-03 17:09:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Riverside At Aymestrey', 52.283917, -2.844314, 35, '2018-05-04 05:40:00 ', '2018-10-03 15:54:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Brooks Country House', 51.927975, -2.665882, 35, '2018-05-04 05:38:00 ', '2018-10-03 19:01:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Savoy Jersey', 49.191688, -2.109773, 35, '2018-05-04 05:36:00 ', '2018-10-03 17:30:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Ardgye House', 57.64803, -3.415786, 35, '2018-05-04 05:32:00 ', '2018-10-03 19:22:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Housing Units', 53.516067, -2.153164, 35, '2018-05-04 05:31:00 ', '2018-10-03 14:42:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Old Rectory', 52.712304, -0.44691, 35, '2018-05-04 05:31:00 ', '2018-10-03 17:09:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Sopwell House Hotel', 51.734835, -0.326967, 35, '2018-05-04 05:31:00 ', '2018-10-03 20:32:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Ynyshir Restaurant and Rooms', 52.544703, -3.944609, 35, '2018-05-04 05:30:00 ', '2018-10-03 15:17:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Ston Easton Park Hotel', 51.28482, -2.538786, 35, '2018-05-03 06:14:00 ', '2018-10-03 17:40:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Bull', 50.921106, -0.114709, 35, '2018-05-03 06:08:00 ', '2018-10-03 18:27:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Great Tangley Manor', 51.20903, -0.54141, 35, '2018-05-03 06:07:00 ', '2018-10-03 15:03:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Langley Castle Hotel', 54.957351, -2.258098, 35, '2018-05-03 06:06:00 ', '2018-10-03 22:25:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Shorefield Country Park', 50.736253, -1.617557, 35, '2018-04-16 05:06:00 ', '2018-10-03 16:17:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Storehouse', 57.601319, -4.454244, 35, '2018-04-16 05:04:00 ', '2018-10-03 21:23:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('10 Castle Street', 50.917563, -1.921482, 35, '2018-04-16 04:54:00 ', '2018-10-03 20:49:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('New Forest Lodge Retreat', 50.736249, -1.617557, 35, '2018-04-16 04:52:00 ', '2018-10-03 17:47:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Woodlands Farm', 54.351295, -1.310569, 35, '2018-04-16 04:52:00 ', '2018-10-03 15:18:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Baskerville Hall Hotel', 52.07872, -3.156996, 35, '2018-04-16 04:49:00 ', '2018-10-03 21:12:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Loch Tay Highland Lodges', 56.494009, -4.250902, 35, '2018-04-16 04:40:00 ', '2018-10-03 18:38:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Baylis House Hotel', 51.518666, -0.603956, 35, '2018-04-16 04:38:00 ', '2018-10-03 14:28:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Smile Style Dental Care Centre', 52.800851, -2.107937, 35, '2018-04-16 04:36:00 ', '2018-10-03 14:35:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Staniland Marina', 53.611202, -0.971956, 35, '2018-04-16 04:36:00 ', '2018-10-03 17:55:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Stanneylands Hotel', 53.342974, -2.22745, 35, '2018-04-16 04:35:00 ', '2018-10-03 17:35:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Citipark Church Watford', 51.654712, -0.397127, 35, '2018-03-30 05:55:00 ', '2018-10-03 18:15:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Kids Today LTD', 50.979224, -1.393462, 35, '2018-03-30 05:51:00 ', '2018-10-03 20:41:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Grange Guest House', 51.86795, 0.169746, 35, '2018-03-30 05:48:00 ', '2018-10-03 14:14:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Haven Hall', 50.636882, -1.170496, 35, '2018-03-30 05:45:00 ', '2018-10-03 21:25:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Grafton Manor Hotel', 52.320617, -2.090698, 35, '2018-03-30 05:43:00 ', '2018-10-03 19:02:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Business Aviation Centre', 55.869102, -4.425442, 35, '2018-03-10 07:04:00 ', '2018-10-03 14:36:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Battle Brewery', 50.923638, 0.463742, 35, '2018-03-10 07:03:00 ', '2018-10-03 14:22:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Gordon Castle Walled Garden and Cafe', 57.617702, -3.092091, 35, '2018-03-10 06:54:00 ', '2018-10-03 22:05:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Castle Lodge', 52.402802, 0.270345, 35, '2018-03-10 06:48:00 ', '2018-10-03 19:46:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Lochan Lodge', 57.341143, -3.517515, 35, '2018-03-10 06:47:00 ', '2018-10-03 18:28:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Horspool Retreat', 53.028472, -0.933407, 35, '2018-02-09 06:48:00 ', '2018-10-03 14:43:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Holiday Inn Express Wigan', 53.554934, -2.666903, 35, '2018-02-06 06:47:00 ', '2018-10-03 21:52:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Pennsylvania Castle', 50.538887, -2.430422, 35, '2018-02-06 06:41:00 ', '2018-10-03 17:53:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Lowry Hotel', 53.483121, -2.250559, 35, '2018-02-01 07:11:00 ', '2018-10-03 15:23:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Druidstone Hotel', 51.809787, -5.101992, 35, '2018-02-01 07:11:00 ', '2018-10-03 21:19:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Flackley Ash Hotel & Restaurant', 50.978348, 0.676587, 35, '2018-02-01 07:10:00 ', '2018-10-03 20:55:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Halston Aparthotel', 54.892651, -2.931875, 35, '2018-02-01 07:09:00 ', '2018-10-03 19:35:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Intercontinental London Park Lane', 51.503851, -0.150187, 35, '2018-02-01 07:02:00 ', '2018-10-03 19:33:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Groes Inn', 53.24907, -3.834715, 35, '2018-01-26 06:53:00 ', '2018-10-03 21:46:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Red Lion', 53.631076, -2.370914, 35, '2018-01-26 06:49:00 ', '2018-10-03 22:32:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Old Parsonage', 51.297847, -2.532994, 35, '2018-01-26 06:46:00 ', '2018-10-03 18:07:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Trearddur Bay Hotel', 53.280792, -4.622538, 35, '2018-01-26 06:46:00 ', '2018-10-03 15:44:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('J.W. Lees Brewery', 53.541817, -2.173266, 35, '2018-01-21 17:51:00 ', '2018-10-03 18:17:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Bell At Iden', 50.982048, 0.730917, 35, '2018-01-21 17:41:00 ', '2018-10-03 21:55:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('JJ'S Fuel Station, Convenience Store & Garden Centre', 53.143806, -0.23926, 35, '2018-01-21 17:39:00 ', '2018-10-03 20:18:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('House in the Yard', 53.18761, -4.340583, 35, '2018-01-21 17:36:00 ', '2018-10-03 21:39:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Anglesey Arms', 53.22272, -4.166325, 35, '2018-01-21 17:25:00 ', '2018-10-03 21:55:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Rookery Manor Hotel and Spa', 51.274792, -2.920342, 35, '2018-01-21 17:25:00 ', '2018-10-03 20:10:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Cynfal Farm Cottages', 52.59677, -4.051771, 35, '2018-01-21 17:23:00 ', '2018-10-03 16:32:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Taymouth Marina', 56.579129, -4.003527, 35, '2018-01-21 16:56:00 ', '2018-10-03 18:59:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Golden Pheasant', 53.273948, -2.418634, 35, '2018-01-21 16:55:00 ', '2018-10-03 17:04:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Ducati Manchester', 53.430532, -2.318762, 35, '2018-01-21 16:54:00 ', '2018-10-03 16:47:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Belmore At Sale', 53.412376, -2.31989, 35, '2018-01-21 16:48:00 ', '2018-10-03 21:32:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Balgove Larder', 56.345497, -2.823472, 35, '2018-01-21 16:46:00 ', '2018-10-03 17:58:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('London Luton Airport', 51.877474, -0.373728, 35, '2018-01-21 16:45:00 ', '2018-10-03 17:43:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Botleys Mansion', 51.37391, -0.533845, 35, '2018-01-21 16:44:00 ', '2018-10-03 19:22:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Crescent Link Retail Park', 54.998647, -7.27343, 35, '2018-01-21 16:42:00 ', '2018-10-03 18:52:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Kenwick Park Golf Hotel & Spa.', 53.344266, 0.019434, 35, '2018-01-21 16:42:00 ', '2018-10-03 15:48:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Croft Acre Holiday Cottages', 51.545176, -4.209902, 35, '2018-01-21 16:42:00 ', '2018-10-03 14:27:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Kings Arms Hotel', 51.666337, -0.618314, 35, '2018-01-21 16:39:00 ', '2018-10-03 15:20:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Purewell', 50.739976, -1.743149, 35, '2018-01-21 16:35:00 ', '2018-10-03 15:26:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Huntsman Inn', 53.570356, -1.83982, 35, '2018-01-21 16:34:00 ', '2018-10-03 16:26:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Old Hall Country Breaks', 52.742343, 0.317568, 35, '2018-01-21 16:32:00 ', '2020-08-05 05:31:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Glan Yr Afon Inn', 53.255279, -3.20757, 35, '2018-01-21 16:30:00 ', '2018-10-03 14:35:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Soar Mill Cove Hotel', 50.224692, -3.818012, 35, '2018-01-21 16:24:00 ', '2018-10-03 21:38:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Brackenborough Hotel', 53.389477, -0.017335, 35, '2018-01-21 16:21:00 ', '2018-10-03 17:51:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Scourie Lodge', 58.354532, -5.153566, 35, '2018-01-21 16:21:00 ', '2018-10-03 20:03:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Great Fosters', 51.417011, -0.544561, 35, '2018-01-21 16:20:00 ', '2018-10-03 21:31:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Sudbury House', 51.658624, -1.577048, 35, '2018-01-21 15:57:00 ', '2018-10-03 19:49:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Penton Hook Marina', 51.410405, -0.508057, 35, '2018-01-21 15:56:00 ', '2018-10-03 19:38:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Thornham Deli', 52.95919, 0.573176, 35, '2018-01-21 15:53:00 ', '2018-10-03 19:02:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Tyn Y Cornel Hotel', 52.667401, -3.903532, 35, '2018-01-21 15:53:00 ', '2018-10-03 18:12:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Glyn Y Coed Hotel', 52.920238, -4.230054, 35, '2018-01-21 15:52:00 ', '2018-10-03 14:07:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Boathouse', 53.188948, -2.881718, 35, '2018-01-21 15:51:00 ', '2018-10-03 19:07:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Gwesty Links Hotel', 53.3170614011294, -3.81911148122333, 35, '2018-01-21 15:51:00 ', '2019-08-31 10:59:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Parade House', 51.174912, -4.211622, 35, '2018-01-21 15:43:00 ', '2018-10-03 19:40:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Felbrigg Lodge', 52.897644, 1.251284, 35, '2018-01-21 15:43:00 ', '2018-10-03 16:23:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Mill Park Caravan & Camping', 51.204766, -4.064086, 35, '2018-01-21 15:35:00 ', '2018-10-03 20:12:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Battlesteads', 55.085873, -2.22048, 35, '2018-01-21 15:27:00 ', '2018-10-03 18:40:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Kings Aparthotel', 52.243366, 0.405848, 35, '2018-01-21 15:25:00 ', '2018-10-03 17:10:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Hotel Number Four', 51.917093, -1.725337, 35, '2018-01-21 15:17:00 ', '2018-10-03 20:39:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Trossachs Pier', 56.233315, -4.428674, 35, '2018-01-21 15:15:00 ', '2018-10-03 15:37:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Pure Green Energy', 51.37169, -1.417123, 35, '2018-01-21 15:14:00 ', '2018-10-03 18:59:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Roadhouse Restaurant', 51.8251955375787, -4.59468841552734, 35, '2017-11-19 10:18:00 ', '2018-10-03 19:43:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Orchard Cottage Ulverston', 54.163396, -3.145813, 35, '2017-11-12 06:53:00 ', '2018-10-03 21:32:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The White House', 52.945165, 0.68074, 35, '2017-11-12 06:53:00 ', '2018-10-03 20:18:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Mansefield Hotel', 57.646198, -3.319917, 35, '2017-11-12 06:51:00 ', '2018-10-03 18:13:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Brownsover Hall Hotel', 52.393495, -1.25599, 35, '2017-11-12 06:51:00 ', '2018-10-03 19:36:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Tree Top Escape', 50.965021, -4.009333, 35, '2017-11-12 06:47:00 ', '2019-04-02 11:00:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Foxhill Manor', 52.045532, -1.839849, 35, '2017-11-05 07:07:00 ', '2018-10-03 18:03:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Radisson Blu Edwardian New Providence Wharf', 51.50656, -0.003953, 35, '2017-11-05 07:06:00 ', '2018-10-03 22:05:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Devonshire Arms Hotel & Spa', 53.974887, -1.893851, 35, '2017-11-05 07:04:00 ', '2018-10-03 14:19:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Bull - Beaumaris', 53.263608, -4.091592, 35, '2017-11-05 07:03:00 ', '2018-10-03 15:11:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Boughton Golf Club', 51.296189, 0.938451, 35, '2017-11-05 07:02:00 ', '2018-10-03 19:31:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Fish Hotel', 52.046878, -1.841694, 35, '2017-11-05 07:02:00 ', '2018-10-03 21:00:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Hurley House Hotel', 51.534832, -0.791157, 35, '2017-11-05 07:01:00 ', '2018-10-03 17:12:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Grange Hotel York', 53.965789, -1.091182, 35, '2017-11-05 07:01:00 ', '2018-10-03 21:48:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Crown Inn', 51.666293, -0.616727, 35, '2017-11-05 06:59:00 ', '2018-10-03 21:27:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Radisson Blu Edwardian Heathrow Hotel', 51.481476, -0.440958, 35, '2017-11-05 06:59:00 ', '2018-10-03 16:07:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Devonshire Fell', 54.044245, -1.953381, 35, '2017-11-05 06:58:00 ', '2018-10-03 17:07:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Barnsley House', 51.743257, -1.890791, 35, '2017-11-05 06:58:00 ', '2018-10-03 17:34:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Slieve Donard Resort & Spa', 54.215748, -5.885667, 35, '2017-11-05 06:57:00 ', '2018-10-03 21:21:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Sheraton Grand Hotel & Spa', 55.946718, -3.208237, 35, '2017-11-05 06:57:00 ', '2018-10-03 22:08:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('English Oak Vineyard', 50.766851, -2.073197, 35, '2017-11-05 06:57:00 ', '2018-10-03 19:57:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Etchinghill Golf Club', 51.117691, 1.092621, 35, '2017-11-05 06:56:00 ', '2018-10-03 19:24:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Culloden Hotel & Spa', 54.652147, -5.802209, 35, '2017-11-05 06:55:00 ', '2018-10-03 18:32:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Sharvedda', 58.574434, -4.014016, 35, '2017-11-05 06:54:00 ', '2018-10-03 16:46:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Calcot Manor Hotel & Spa', 51.652471, -2.231946, 35, '2017-11-05 06:54:00 ', '2018-10-03 17:46:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Barns Hotel', 52.124744, -0.430171, 35, '2017-11-05 06:54:00 ', '2018-10-03 17:11:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Gillingham Retail Park', 51.368895, 0.577833, 35, '2017-11-05 06:54:00 ', '2019-12-12 16:22:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Bower House Inn', 54.390547, -3.33964, 35, '2017-11-05 06:53:00 ', '2018-10-03 19:55:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Cow Co. & Tom's Eco Lodge', 50.679503, -1.469999, 35, '2017-11-05 06:53:00 ', '2019-12-30 19:06:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Wyboston Lakes', 52.201358, -0.291466, 35, '2017-11-05 06:52:00 ', '2018-10-03 21:45:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Wyboston Lakes', 52.202122735279204, -0.2919944336260869, 35, '2017-11-05 06:52:00 ', '2020-10-02 05:18:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Boskerris Hotel', 50.196282, -5.465052, 35, '2017-10-22 05:46:00 ', '2018-10-03 22:03:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Daylesford Farm', 51.929015, -1.642669, 35, '2017-10-22 05:46:00 ', '2018-10-03 17:10:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Cononley Hall Bed & Breakfast', 53.91857, -2.018793, 35, '2017-10-22 05:44:00 ', '2018-10-03 21:17:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Taste Perthshire', 56.49179, -3.506574, 35, '2017-10-20 05:44:00 ', '2018-10-03 14:47:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Beach Lodge Hotel', 53.336436, 0.269174, 35, '2017-10-20 05:43:00 ', '2018-10-03 16:17:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Country Park Hotel', 53.715245, -0.454318, 35, '2017-10-20 05:40:00 ', '2018-10-03 19:39:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Mill House', 53.786105, -0.451577, 35, '2017-10-20 05:39:00 ', '2018-10-03 20:01:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Manchester Fort Shopping Park', 53.497949, -2.234909, 35, '2017-09-27 19:36:00 ', '2018-10-03 15:01:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Chateau Rhianfa', 53.2382, -4.14395, 35, '2017-09-27 19:31:00 ', '2018-10-03 17:36:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Devon Hotel', 50.69202, -3.517897, 35, '2017-09-27 19:29:00 ', '2018-10-03 15:45:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Strattons Hotel', 52.649129, 0.687113, 35, '2017-09-27 19:25:00 ', '2018-10-03 20:08:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Lanhydrock Hotel & Golf Club', 50.449689, -4.714279, 35, '2017-09-27 19:20:00 ', '2018-10-03 20:25:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('River Dart Country Park', 50.517219, -3.789148, 35, '2017-09-27 19:19:00 ', '2018-10-03 21:03:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Carrington Arms', 52.068429, -0.670838, 35, '2017-09-15 05:36:00 ', '2018-10-03 14:46:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('St Moritz Hotel', 50.567, -4.9201, 35, '2017-09-15 05:36:00 ', '2018-10-03 22:08:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Tankersley Manor', 53.489404, -1.486268, 35, '2017-09-15 05:34:00 ', '2018-10-03 18:43:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Grove of Narberth', 51.782833, -4.763913, 35, '2017-09-15 05:30:00 ', '2018-10-03 22:31:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('St. Brides Spa Hotel', 51.7089, -4.6982, 35, '2017-09-15 05:30:00 ', '2018-10-03 20:05:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Devonshire Arms At Beeley', 53.203328, -1.60467, 35, '2017-09-08 05:43:00 ', '2018-10-03 20:48:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Punch Bowl Inn and Restaurant', 54.313074, -2.852743, 35, '2017-09-08 05:41:00 ', '2018-10-03 21:51:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Bailey Ground Hotel', 54.39432, -3.483791, 35, '2017-09-07 06:01:00 ', '2018-10-03 14:49:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Feversham Arms Hotel & Verbena Spa', 54.247294, -1.063175, 35, '2017-09-07 05:59:00 ', '2018-10-03 17:57:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Coast Restaurant', 51.71642, -4.693882, 35, '2017-09-07 05:58:00 ', '2018-10-03 14:11:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Pig At Combe', 50.773982, -3.21689, 35, '2017-09-07 05:57:00 ', '2018-10-03 20:04:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Beach Boys', 50.530075, -5.012034, 35, '2017-09-07 05:53:00 ', '2018-10-03 15:18:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Ashbourne Hotel', 53.639621, -0.269843, 35, '2017-09-07 05:46:00 ', '2018-10-03 19:04:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Pig in the Wall', 50.899077, -1.407, 35, '2017-09-07 05:45:00 ', '2018-10-03 14:28:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('South Sands Hotel & Restaurant', 50.224615, -3.784584, 35, '2017-09-01 05:47:00 ', '2018-10-03 18:32:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Brecon Retreat - Aberyscir', 51.965554, -3.452627, 35, '2017-09-01 05:45:00 ', '2018-12-13 11:49:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Kellbank Hotel', 54.4175, -3.4309, 35, '2017-09-01 05:42:00 ', '2018-10-03 20:07:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Park Hotel', 51.678292, -4.709391, 35, '2017-09-01 05:39:00 ', '2018-10-03 19:31:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Hotel Felix', 52.224454, 0.094236, 35, '2017-09-01 05:36:00 ', '2019-08-23 19:07:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Wowo Campsite', 50.993114, -0.007874, 35, '2017-09-01 05:36:00 ', '2018-10-03 21:04:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Cringletie House Hotel', 55.688439, -3.218717, 35, '2017-09-01 05:35:00 ', '2018-10-03 14:22:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Titanic Hotel Liverpool', 53.42218, -2.999052, 35, '2017-09-01 05:35:00 ', '2018-10-03 17:57:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Belle Vue Barn', 53.640852, -1.875987, 35, '2017-09-01 05:35:00 ', '2018-10-03 15:21:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Another Place', 54.602941, -2.848902, 35, '2017-09-01 05:34:00 ', '2018-10-03 21:39:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Eagle Brae', 57.400085, -4.680843, 35, '2017-09-01 05:34:00 ', '2018-10-03 22:18:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Cheltenham Park Hotel', 51.874817, -2.053748, 35, '2017-09-01 05:33:00 ', '2018-10-03 16:40:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Manor House', 51.493458, -2.232071, 35, '2017-09-01 05:31:00 ', '2018-10-03 19:36:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Links Country Park Hotel and Golf Club', 52.934128, 1.246359, 35, '2017-09-01 05:31:00 ', '2018-10-03 16:33:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Baileys Farm Bed and Breakfast', 51.882058, -0.327134, 35, '2017-09-01 05:30:00 ', '2018-10-03 14:30:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Victoria Hotel', 50.677089, -3.244075, 35, '2017-09-01 05:30:00 ', '2018-10-03 19:32:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Meldrum House Country Hotel & Golf Course', 57.351312, -2.313174, 35, '2017-08-24 05:59:00 ', '2018-10-03 17:54:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Brampton Grange Estate', 52.282887, -0.931097, 35, '2017-08-18 07:42:00 ', '2018-10-03 19:40:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Gravetye Manor', 51.089302, -0.056507, 35, '2017-08-18 07:40:00 ', '2018-10-03 16:38:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Renaissance Club', 56.051556, -2.809547, 35, '2017-08-18 07:38:00 ', '2018-10-03 21:33:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Steading', 57.894827, -4.05345, 35, '2017-08-02 05:36:00 ', '2018-10-03 20:54:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Old Green Dragon', 53.058692, -1.061694, 35, '2017-08-02 05:31:00 ', '2018-10-03 18:32:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Saunton Sands Hotel', 51.11842, -4.221135, 35, '2017-08-02 05:29:00 ', '2018-10-03 16:35:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Raemoir House Hotel', 57.08549, -2.505439, 35, '2017-08-02 05:29:00 ', '2018-10-03 14:10:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Bluestone National Park Resort', 51.783396, -4.801274, 35, '2017-07-28 05:46:00 ', '2018-10-03 20:37:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Bayview Hotel', 55.215594, -6.544306, 35, '2017-07-28 05:43:00 ', '2018-10-03 17:50:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Sygun Fawr Country House', 53.015329, -4.089655, 35, '2017-07-28 05:42:00 ', '2018-10-03 15:16:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Glenfall House', 51.89421, -2.031568, 35, '2017-07-28 05:40:00 ', '2018-10-03 22:30:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Old Downton Lodge Restaurant With Rooms', 52.35558, -2.84229, 35, '2017-07-28 05:37:00 ', '2018-10-03 17:33:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Diggerland Durham', 54.801434, -1.675714, 35, '2017-07-28 05:36:00 ', '2018-10-03 16:19:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Stawley Wood Farm', 50.999347, -3.334576, 35, '2017-07-28 05:31:00 ', '2018-10-03 17:07:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Red Rail Farm Bed & Breakfast', 51.950392, -2.658989, 35, '2017-07-28 05:30:00 ', '2018-10-03 14:59:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Nanteos Mansion', 52.388265, -4.028988, 35, '2017-07-28 05:30:00 ', '2018-10-03 17:50:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Devonshire Arms At Pilsley', 53.235946, -1.640703, 35, '2017-07-28 05:28:00 ', '2018-10-03 21:20:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Bryncir Garden Centre and Cafe', 52.974161, -4.263637, 35, '2017-07-28 05:27:00 ', '2018-10-03 20:21:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Peckforton Castle', 53.117897, -2.698638, 35, '2017-07-28 05:25:00 ', '2020-07-18 05:35:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Donnington Valley Hotel & Spa', 51.42374, -1.328098, 35, '2017-07-13 21:28:00 ', '2018-10-03 16:53:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('170 Marylebone Road Car Park', 51.522022, -0.159412, 35, '2017-07-13 15:28:00 ', '2018-10-03 16:48:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Hoburne Naish Holiday Park', 50.740565, -1.687432, 35, '2017-07-13 15:22:00 ', '2018-10-03 15:25:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Portsonachan Hotel', 56.339353, -5.158073, 35, '2017-07-13 15:21:00 ', '2018-10-03 18:33:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Northney Marina', 50.833464, -0.969182, 35, '2017-07-13 15:09:00 ', '2018-10-03 22:06:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Shamrock Quay', 50.909757, -1.38154, 35, '2017-07-13 14:52:00 ', '2018-10-03 14:43:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Crowne Plaza Gerrards Cross', 51.595456, -0.597343, 35, '2017-07-13 14:49:00 ', '2018-10-03 18:13:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Royal Golf Hotel', 57.879504, -4.023029, 35, '2017-07-13 14:36:00 ', '2018-10-03 21:13:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Cherry Tree Lodge', 56.12934, -3.585835, 35, '2017-07-13 14:36:00 ', '2018-10-03 17:26:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('East Cambusmoon Holiday Cottages', 56.036423, -4.519517, 35, '2017-07-13 14:31:00 ', '2018-10-03 14:30:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Mercury Yacht Harbour', 50.870977, -1.313358, 35, '2017-07-13 14:29:00 ', '2018-10-03 22:09:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Donnington Valley Golf Club', 51.424781, -1.329515, 35, '2017-07-13 14:14:00 ', '2018-10-03 19:22:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Woolverstone Marina', 52.00665, 1.194251, 35, '2017-07-13 14:13:00 ', '2018-10-03 20:02:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Horseshoe Guesthouse', 52.300341, -3.51307, 35, '2017-07-13 14:11:00 ', '2018-10-03 18:55:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Lainston House', 51.082265, -1.369665, 35, '2017-06-09 14:01:00 ', '2018-10-03 21:28:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('St David's Shopping Centre', 51.479103, -3.174819, 35, '2017-06-09 13:39:00 ', '2018-10-03 15:07:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Qbic Hotel London City', 51.516146, -0.06752, 35, '2017-06-09 13:06:00 ', '2018-10-03 20:26:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Isle of Eriska Hotel and Spa', 56.533528, -5.41183, 35, '2017-06-09 12:52:00 ', '2019-11-09 21:08:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Clarendon Hotel', 51.468616, 0.009909, 35, '2017-06-01 06:15:00 ', '2018-10-11 12:21:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Bloomfields Shopping Centre', 54.647366, -5.656311, 35, '2017-05-27 05:52:00 ', '2018-10-03 14:56:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Ravenstone Lodge Hotel', 54.657235, -3.187692, 35, '2017-05-27 05:52:00 ', '2018-10-03 19:17:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Coach House At Lodge Farm', 52.548064, 0.386225, 35, '2017-05-27 05:52:00 ', '2018-10-03 20:28:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Best Western Rockingham Forest Hotel', 52.508648, -0.713252, 35, '2017-05-24 06:03:00 ', '2018-10-03 16:35:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Citipark Gade Car Park', 51.657402, -0.400939, 35, '2017-05-21 05:28:00 ', '2018-10-03 15:23:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Old Tredegar', 51.786649, -3.804058, 35, '2017-05-21 05:28:00 ', '2018-10-03 18:46:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Fairfield the Old Rectory', 53.21382, -0.969085, 35, '2017-05-21 05:27:00 ', '2018-10-03 14:34:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Bankburn House', 58.820246, -2.955429, 35, '2017-05-21 05:26:00 ', '2018-10-03 17:49:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Exmoor White Horse Inn', 51.133114, -3.641299, 35, '2017-05-20 05:35:00 ', '2018-10-03 20:59:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The White Swan Inn', 54.245886, -0.777369, 35, '2017-05-19 05:33:00 ', '2018-10-03 16:54:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Storrs Hall', 54.339078, -2.936193, 35, '2017-05-19 05:31:00 ', '2019-11-15 04:38:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Watergate Bay Hotel', 50.444752, -5.041104, 35, '2017-05-18 05:41:00 ', '2018-10-03 17:22:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Erneside Shopping Centre', 54.342478, -7.635394, 35, '2017-05-18 05:39:00 ', '2018-10-03 15:52:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Park Hotel', 51.075185, -4.053657, 35, '2017-05-16 05:27:00 ', '2018-10-03 14:52:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Little Coombe Farm', 50.373373, -3.620392, 35, '2017-05-15 05:28:00 ', '2018-10-03 16:14:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Back to the Garden', 52.903474, 1.041804, 35, '2017-05-06 05:27:00 ', '2018-10-03 20:14:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Donington Park Farmhouse Hotel', 52.824899, -1.386217, 35, '2017-05-03 05:28:00 ', '2018-10-03 16:06:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Diggerland Devon', 50.877788, -3.379079, 35, '2017-05-02 05:24:00 ', '2018-10-03 20:33:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Diggerland Yorkshire', 53.717362, -1.383567, 35, '2017-05-02 05:24:00 ', '2018-10-03 19:38:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Seaview Hotel', 50.720493, -1.10985, 35, '2017-04-12 05:41:00 ', '2018-10-03 19:16:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Norfolk River Cottages', 52.69920908643359, 1.4676698592271853, 35, '2017-04-10 05:38:00 ', '2019-01-01 11:22:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Abbotsford Lodge', 56.241248, -4.202774, 35, '2017-04-09 05:40:00 ', '2018-10-03 17:24:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The White Swan', 53.916342, -1.277242, 35, '2017-04-08 05:41:00 ', '2018-10-03 18:14:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Tewin Bury Farm Hotel', 51.811017, -0.164831, 35, '2017-04-06 05:43:00 ', '2018-10-03 19:25:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Duke of York', 53.987683, -0.95066, 35, '2017-04-06 05:43:00 ', '2019-01-02 22:07:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Dragon Hotel', 51.621436, -3.944424, 35, '2017-04-06 05:41:00 ', '2018-10-03 21:08:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Crowne Plaza Resort, Colchester Five Lakes', 51.786238, 0.804974, 35, '2017-04-05 05:40:00 ', '2018-10-03 18:07:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Ashbrook Lets', 51.566745, -1.239634, 35, '2017-03-27 05:25:00 ', '2018-10-03 19:08:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Swan & Talbot', 53.929479, -1.385126, 35, '2017-03-26 05:26:00 ', '2018-10-03 19:15:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Redpoint Climbing Centre', 51.433797, -2.611556, 35, '2017-03-24 06:30:00 ', '2018-10-03 20:49:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Gardeners Arms', 51.99872, -2.002626, 35, '2017-03-24 06:29:00 ', '2018-10-03 15:51:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Ocean View Chalets', 55.191617, -6.242496, 35, '2017-03-23 06:29:00 ', '2018-10-03 16:11:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Concierge Camping', 50.851885, -0.848095, 35, '2017-03-23 06:28:00 ', '2018-10-03 17:20:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Outlet', 54.331207, -6.276309, 35, '2017-03-23 06:28:00 ', '2018-10-03 21:37:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Grey Seal Coffee Roastery', 52.931908, 1.037459, 35, '2017-03-22 06:36:00 ', '2018-10-03 19:06:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Oakley Court Hotel', 51.490159, -0.672405, 35, '2017-03-22 06:36:00 ', '2018-10-03 20:12:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Dunston Hall Hotel', 52.5714346986175, 1.28315868105507, 35, '2017-03-22 06:36:00 ', '2019-10-22 05:47:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Queen's Head', 54.011137, -1.655352, 35, '2017-03-22 06:35:00 ', '2018-10-03 18:48:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Junction 1 Antrim Outlet', 54.730532, -6.233081, 35, '2017-03-22 06:34:00 ', '2018-10-03 19:47:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Galgorm Castle', 54.855313, -6.31209, 35, '2017-03-21 18:52:00 ', '2018-10-03 18:30:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Trattoria San Marco', 53.696245, -2.810528, 35, '2017-03-21 18:51:00 ', '2018-10-03 21:22:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Alexander House Hotel', 51.107856, -0.066426, 35, '2017-03-21 18:51:00 ', '2018-10-03 21:09:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Centre Livingston', 55.8848884395316, -3.51416725552212, 35, '2017-03-21 18:51:00 ', '2019-08-29 05:34:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Rooms Inn', 54.968488, -1.632041, 35, '2017-02-26 06:35:00 ', '2018-10-03 18:52:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Sandbanks Hotel', 50.694552, -1.930783, 35, '2017-02-25 06:37:00 ', '2018-10-03 22:07:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Champneys Springs Health Resort', 52.711603, -1.47919, 35, '2017-02-25 06:36:00 ', '2018-10-03 20:53:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Citipark Clements Road', 51.557413, 0.07284, 35, '2017-02-24 06:37:00 ', '2018-10-03 17:26:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Parc le Breos House', 51.584496, -4.124613, 35, '2017-02-24 06:36:00 ', '2018-10-03 19:13:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Arundell Arms Hotel', 50.643243, -4.284137, 35, '2017-02-16 17:30:00 ', '2018-10-03 19:00:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Tylney Hall Hotel', 51.291671, -0.983266, 35, '2017-02-16 17:30:00 ', '2018-10-03 20:58:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Clevedon Hall', 51.437214, -2.864817, 35, '2017-02-16 17:26:00 ', '2018-10-03 20:47:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Citipark 30 Tariff Street', 53.48154, -2.231821, 35, '2017-02-16 17:23:00 ', '2018-10-03 15:10:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Moresby Hall', 54.57382, -3.573709, 35, '2017-02-16 17:20:00 ', '2018-10-03 15:42:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Citipark Bell Street', 51.520409, -0.169598, 35, '2017-02-16 17:07:00 ', '2018-10-03 14:04:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Stapleford Park Hotel', 52.754039, -0.795858, 35, '2017-02-16 17:04:00 ', '2018-10-03 15:25:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Sprowston Manor Marriott Hotel', 52.664274, 1.341352, 35, '2017-02-16 16:58:00 ', '2018-10-03 16:06:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Mandarin Oriental Hyde Park', 51.502148, -0.159996, 35, '2017-02-16 16:57:00 ', '2018-10-03 22:35:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Hideaway House', 50.804713, -4.524367, 35, '2017-02-16 14:53:00 ', '2018-10-03 20:03:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Middlesex Stadium', 51.58669, -0.441616, 35, '2017-02-03 15:40:00 ', '2018-10-03 15:46:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Greenbanks', 52.68039600647736, 0.8423342910460851, 35, '2017-02-03 15:30:00 ', '2019-01-01 11:24:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Hamble Yacht Services', 50.862351, -1.3132496, 35, '2017-02-03 15:27:00 ', '2018-10-03 14:12:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Rockliffe Hall', 54.47874, -1.544861, 35, '2017-02-03 15:11:00 ', '2018-10-03 18:10:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Chelsea Design Centre', 51.474985, -0.181761, 35, '2017-02-03 15:06:00 ', '2018-10-03 20:37:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Stoneleigh Park Lodge', 52.339949, -1.527122, 35, '2017-02-03 14:59:00 ', '2018-10-03 22:25:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Royal Duchy Hotel', 50.147491, -5.059909, 35, '2017-02-03 14:57:00 ', '2018-10-03 17:23:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Citipark Sutton', 51.658417, -0.395483, 35, '2017-02-03 14:50:00 ', '2018-10-03 16:32:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Citipark Clipstone Street', 51.521862, -0.140954, 35, '2017-02-03 14:43:00 ', '2018-10-03 16:23:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Burgh Island Hotel', 50.279813, -3.898081, 35, '2017-02-03 14:39:00 ', '2018-10-03 18:09:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Holiday Inn Garden Court Wolverhampton', 52.603618, -2.141018, 35, '2017-02-03 14:34:00 ', '2018-10-03 17:55:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Hellidon Lakes Golf & Spa Hotel', 52.217197, -1.260284, 35, '2017-02-03 14:32:00 ', '2018-10-03 20:00:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Citipark Merrion Centre', 53.802178, -1.543019, 35, '2017-02-03 13:58:00 ', '2018-10-03 15:16:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Linen Mill Film & Television Studios', 54.339022, -7.304325, 35, '2017-02-03 13:56:00 ', '2018-10-03 17:01:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Champneys Henlow', 52.031714, -0.27668, 35, '2017-02-03 13:55:00 ', '2018-10-03 19:58:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Goldsborough Hall', 53.999045, -1.416372, 35, '2017-02-03 13:54:00 ', '2018-10-03 21:20:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Haven Hotel', 50.683042, -1.947168, 35, '2017-02-03 13:41:00 ', '2018-10-03 21:15:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The White Horse', 52.966055, 0.678897, 35, '2017-02-03 13:39:00 ', '2018-10-03 14:38:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Fairmont St Andrews', 56.320419, -2.730775, 35, '2017-02-03 13:39:00 ', '2018-10-03 19:25:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Talbot Hotel', 51.301481, -0.489212, 35, '2017-02-03 13:36:00 ', '2018-10-03 18:42:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Salcombe Harbour Hotel & Spa', 50.235264, -3.768555, 35, '2017-02-03 13:34:00 ', '2018-10-03 17:01:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Plume of Feathers', 50.351357, -5.009725, 35, '2017-02-03 13:24:00 ', '2018-10-03 17:26:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Doubletree By Hilton Cadbury House', 51.381558, -2.806812, 35, '2017-02-03 11:53:00 ', '2018-10-03 20:00:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Cotswold House Hotel and Spa', 52.050554, -1.782291, 35, '2017-02-03 11:18:00 ', '2019-11-09 13:22:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Novotel London Greenwich', 51.477586, -0.01415, 35, '2017-02-03 11:16:00 ', '2018-10-03 18:32:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Fox', 51.961173, -0.2199, 35, '2017-02-03 11:13:00 ', '2018-10-03 22:26:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Fonab Castle', 56.697811, -3.74045, 35, '2017-02-03 09:14:00 ', '2018-10-03 20:25:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Harbour Heights Hotel', 50.699218, -1.930397, 35, '2017-02-03 09:13:00 ', '2018-10-03 22:02:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Bedford Lodge Hotel', 52.25101, 0.415356, 35, '2017-02-03 09:12:00 ', '2018-10-03 14:57:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Lucknam Park Hotel', 51.455099, -2.259527, 35, '2017-02-03 09:08:00 ', '2018-10-03 18:17:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Bents Garden & Home', 53.4760414966117, -2.49404357678941, 35, '2017-02-02 22:52:00 ', '2018-10-03 20:51:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Ellenborough Park Hotel', 51.926518, -2.041776, 35, '2017-02-02 22:47:00 ', '2018-10-03 18:06:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Whatley Manor Hotel and Spa', 51.583676, -2.1491, 35, '2017-02-02 17:28:00 ', '2018-10-03 18:05:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Carlyon Bay Hotel', 50.337394, -4.739296, 35, '2017-02-02 17:27:00 ', '2018-10-03 18:27:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('No 38 the Park', 51.905982, -2.070301, 35, '2017-02-01 09:43:00 ', '2018-10-03 21:21:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Meon Valley Marriott Hotel & Country Club', 50.921647, -1.210175, 35, '2017-02-01 09:33:00 ', '2018-10-03 21:52:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Club and Spa', 51.381069, -2.808293, 35, '2017-01-30 18:36:00 ', '2018-10-03 19:30:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Ardnamurchan Distillery', 56.691483, -5.940657, 35, '2017-01-30 17:53:00 ', '2018-10-03 15:15:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Three Glens House', 55.18522, -3.911187, 35, '2017-01-29 18:11:00 ', '2018-10-03 14:55:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Old Piggery', 52.810236, 1.498429, 35, '2016-12-14 20:25:00 ', '2018-10-03 22:35:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Four Seasons Hotel Hampshire', 51.257236, -0.89615, 35, '2016-12-14 20:25:00 ', '2018-10-03 18:09:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Carbis Bay Hotel', 50.198227, -5.466627, 35, '2016-12-14 19:37:00 ', '2018-10-03 15:34:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Q-Park Oxford Street', 51.516593, -0.144297, 35, '2016-12-14 19:30:00 ', '2018-10-03 14:07:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Ocean Village Marina', 50.896945, -1.388259, 35, '2016-12-14 17:55:00 ', '2018-10-03 22:12:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Pendragon Country House', 50.652631, -4.628714, 35, '2016-12-14 17:55:00 ', '2018-10-03 16:15:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Parc-Y-Scarlets', 51.678578, -4.127873, 35, '2016-12-14 17:55:00 ', '2018-10-03 17:45:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Champneys Forest Mere', 51.064152, -0.835497, 35, '2016-12-14 17:36:00 ', '2018-10-03 20:30:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Champneys Tring', 51.770056, -0.629643, 35, '2016-12-14 17:36:00 ', '2018-10-03 14:38:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Dales Country House Hotel', 52.931584, 1.185421, 35, '2016-12-14 17:34:00 ', '2018-10-03 19:51:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Gonville Hotel', 52.199851, 0.128561, 35, '2016-12-14 17:32:00 ', '2018-10-03 20:02:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Harrods', 51.499395, -0.163234, 35, '2016-12-14 17:25:00 ', '2018-10-03 18:13:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Langaller Manor House', 51.036076, -3.044447, 35, '2016-12-14 17:24:00 ', '2018-12-20 12:34:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('l'Ortolan Restaurant', 51.40864, -0.954065, 35, '2016-12-14 17:02:00 ', '2018-10-03 14:23:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Babington House', 51.257913, -2.425058, 35, '2016-12-14 17:00:00 ', '2018-10-03 17:21:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Q-Park Harley Street', 51.517933, -0.145537, 35, '2016-12-14 17:00:00 ', '2018-10-03 14:57:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Rudding Park Hotel', 53.973773, -1.492644, 35, '2016-12-14 16:58:00 ', '2018-10-03 15:02:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Glyndebourne Opera', 50.878292, 0.064169, 35, '2016-12-14 16:41:00 ', '2018-10-03 19:30:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Imperial Hotel', 52.613105, 1.737679, 35, '2016-12-14 16:41:00 ', '2018-10-03 15:28:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Wild Boar Inn', 54.350961, -2.870612, 35, '2016-12-14 16:39:00 ', '2018-10-03 17:30:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Luton Hoo Hotel Golf and Spa', 51.854446, -0.39796, 35, '2016-12-14 16:38:00 ', '2018-10-03 17:10:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Elen's Castle Hotel and Restaurant', 53.054727, -3.885812, 35, '2016-12-14 16:04:00 ', '2019-04-26 09:26:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Stoke Park', 51.535297, -0.605029, 35, '2016-12-13 20:56:00 ', '2018-10-03 17:34:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Lewinnick Lodge', 50.411985, -5.120182, 35, '2016-12-13 20:55:00 ', '2018-10-03 22:13:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Ashdown Park Hotel & Country Club', 51.070971, 0.041044, 35, '2016-12-11 18:22:00 ', '2018-10-03 19:08:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Camberley', 53.996658, -1.540473, 35, '2016-12-11 18:22:00 ', '2018-10-03 19:01:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Linthwaite House Hotel', 54.352693, -2.912637, 35, '2016-12-11 18:19:00 ', '2018-10-03 15:06:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Montagu Arms Hotel', 50.818394, -1.451415, 35, '2016-12-11 18:18:00 ', '2018-10-03 22:22:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Brimstone Hotel', 54.437159, -3.039814, 35, '2016-12-11 18:11:00 ', '2018-10-03 15:10:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Samling Hotel', 54.414629, -2.950827, 35, '2016-12-11 18:11:00 ', '2018-10-03 16:44:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Torridon', 57.528688, -5.528182, 35, '2016-12-11 17:59:00 ', '2018-10-03 18:19:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Hamble Point Marina', 50.855836, -1.316898, 35, '2016-12-11 14:29:00 ', '2018-10-03 17:30:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Cobb Quay Marina', 50.721772, -2.003477, 35, '2016-12-11 14:29:00 ', '2018-10-03 18:43:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Royal Oak Hotel Restaurant and Pub', 51.466953, -1.206437, 35, '2016-12-11 14:28:00 ', '2018-10-03 17:54:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Hambleton Hall', 52.657344, -0.668105, 35, '2016-12-11 13:46:00 ', '2018-10-03 14:51:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Diggerland', 51.38258, 0.478702, 35, '2016-12-11 10:18:00 ', '2018-10-03 18:38:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Citipark Leeds Dock', 53.790416, -1.530348, 35, '2016-12-11 10:18:00 ', '2018-10-03 21:02:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Q-Park Tower Bridge', 51.502367, -0.073739, 35, '2016-12-10 16:38:00 ', '2018-10-03 21:37:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Scarlet Hotel', 50.468163, -5.02977, 35, '2016-12-10 16:36:00 ', '2018-10-03 22:22:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Pig Brockenhurst', 50.82435, -1.553656, 35, '2016-12-10 16:26:00 ', '2018-10-03 20:07:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Soho Farmhouse', 51.940126, -1.42165, 35, '2016-12-09 09:56:00 ', '2018-10-03 19:27:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('TWR Y Felin Hotel', 51.8795684568384, -5.26028756322944, 35, '2016-12-06 12:17:00 ', '2018-10-03 15:48:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Indigo West India Quay', 51.508362, -0.023907, 35, '2016-12-04 21:55:00 ', '2018-10-03 14:47:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Pontlands Park', 51.70923, 0.50793, 35, '2016-12-04 21:50:00 ', '2018-10-03 14:57:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Tag Farnborough Airport', 51.283219, -0.776574, 35, '2016-12-04 10:59:00 ', '2018-10-03 22:27:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Old Rectory', 50.693404, -4.657036, 35, '2016-12-04 10:52:00 ', '2018-10-03 17:31:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Queen Anne's Marina', 50.365046, -4.128979, 35, '2016-12-03 19:43:00 ', '2018-10-03 19:10:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Tewkesbury Park', 51.979296, -2.171702, 35, '2016-12-02 18:11:00 ', '2018-10-03 14:16:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Royal Sportsman Hotel', 52.928395, -4.133445, 35, '2016-12-02 18:10:00 ', '2018-10-03 21:08:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Careys Manor Hotel & Senspa', 50.823201, -1.571568, 35, '2016-12-02 18:05:00 ', '2018-10-03 22:24:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Mayfair Car Park', 51.50497, -0.151181, 35, '2016-12-02 18:05:00 ', '2018-10-03 15:43:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Penderyn Distillery', 51.763688, -3.52129, 35, '2016-12-02 18:04:00 ', '2018-10-03 22:30:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Hintlesham Hall Hotel', 52.053384, 1.036673, 35, '2016-12-02 17:52:00 ', '2018-10-03 16:42:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('The Browns B&B', 51.7710028312483, -4.46224389259032, 35, '2016-11-19 16:51:00 ', '2018-10-03 16:33:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Bunchrew House Hotel', 57.482401790514, -4.30027306079864, 35, '2016-09-20 09:37:00 ', '2018-10-03 21:44:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('National Motorcycle Museum', 52.4437595298002, -1.7070333749939, 35, '2015-12-02 14:44:00 ', '2018-10-03 18:18:00 ', 0, NULL); INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Tesla Store and Service Centre', 51.1353243390917, -0.191257379167951, 35, '2015-10-19 16:01:00 ', '2016-11-23 19:57:00 ', 0, NULL);
Quit the DB session
run \q
to quit
Removing entries
If you want to remove any entries, you can either do so via the command line, or via the geo-fences section within TeslaMate (http://raspberrypi:4000/geo-fences – replacing raspberrypi with whatever the name of your pi is called)
To do it via the command line, first you need to run: SELECT * FROM geofences;
Once you have the ID of the entry you wish to remove, you can delete it with the following command (replacing XX with the relevant ID you got from the above command: DELETE FROM geofences WHERE id = XX;
UK Supercharger locations
The exact same guide is available here to add the current UK Supercharger locations in bulk to TeslaMate