Welcome to Tesla Motors Club
Discuss Tesla's Model S, Model 3, Model X, Model Y, Cybertruck, Roadster and More.
Register
  • The final cut of the 9th episode of the Tesla Motors Club Podcast, featuring Chad Schwitters, the former president of Plug In America, is now available. You can watch it now on YouTube or listen to it on all major podcast networks.

TeslaMate [megathread]

Hi all.

Sorry if this has allready been asked & answered.

I have a install of teslamate on my own ubuntu VM, but I'm totally not familiar, working with docker. I want to connect to the psql database, at first just to view the collected data, but later on, to maybe make a custom website, with the data, displayed as on the teslascope website (I like that interface a bit more than the grafana one)

i have it installed and running with the docker_compose.yaml and the .env file combination. In this .env file, I've entered my username & password for the psql database.

When I now try tot connect to the database with "psql -h localhost -p 5432 -d docker -U teslamate --password" and I enter the password I used in the .env file, I get "FATAL: password authentication failed for user "teslamate""

Anyone have an idea what I'm doing wrong? Or maybe better, is there an easier way to remotely connect to this database ?
 

DaveW

Active Member
May 21, 2019
1,197
955
Beds, UK
Today's tinkering has led me to be able to work out my average miles per month and expected (avg) miles per annum :)

As a late comer to TeslaMate and not having the data in there, I've had to use variables to work out how many days/months I've had the car to then perform a div on the amount of miles done vs how long I've had it for the avg monthly and then x12 for the expected annual miles. I'm sure there's a nicer way to do it all in one query, but I have very (very) limited Sql knowledge.
 
I’m not near my laptop at the moment, so I can’t see the docker-compose yaml file, so apologies if I’m off base. However, I’ve a bit of docker knowledge (well, enough to be dangerous). Unless the port to your DB is explicitly exposed to the outside OS you won’t be able to connect a client to it. However, making that change is simple. In a command line docker run its -P option, so do a quick search for kexpose docker port’ and you should be OK.

Hi all.

Sorry if this has allready been asked & answered.

I have a install of teslamate on my own ubuntu VM, but I'm totally not familiar, working with docker. I want to connect to the psql database, at first just to view the collected data, but later on, to maybe make a custom website, with the data, displayed as on the teslascope website (I like that interface a bit more than the grafana one)

i have it installed and running with the docker_compose.yaml and the .env file combination. In this .env file, I've entered my username & password for the psql database.

When I now try tot connect to the database with "psql -h localhost -p 5432 -d docker -U teslamate --password" and I enter the password I used in the .env file, I get "FATAL: password authentication failed for user "teslamate""

Anyone have an idea what I'm doing wrong? Or maybe better, is there an easier way to remotely connect to this database ?
 
  • Helpful
Reactions: Roy W.
I’m not near my laptop at the moment, so I can’t see the docker-compose yaml file, so apologies if I’m off base. However, I’ve a bit of docker knowledge (well, enough to be dangerous). Unless the port to your DB is explicitly exposed to the outside OS you won’t be able to connect a client to it. However, making that change is simple. In a command line docker run its -P option, so do a quick search for kexpose docker port’ and you should be OK.

I've tried to connect with this command line:

psql -h localhost -p 5432 -d docker -U teslamate --password

I get the response to enter a password, so I'm assuming the outside connection is active, or am I wrong? The postgresql port set in the yaml file is 5432, which I also used in the command.

What is the exact command you want me to run?
 
@DaveW once I tweaked for my environment and setup it worked great! Will let it run tonight and see what happens.

Is there a reason you created a new variable for the day in your script?
I'm new to this so it may be bad practice but I named the backup file like this:

teslamate.bck_$(date +"%d")

Directly in the filename rather than a 'now' variable, any downside to doing it like that?
 

DaveW

Active Member
May 21, 2019
1,197
955
Beds, UK
@DaveW once I tweaked for my environment and setup it worked great! Will let it run tonight and see what happens.

Is there a reason you created a new variable for the day in your script?
I'm new to this so it may be bad practice but I named the backup file like this:

teslamate.bck_$(date +"%d")

Directly in the filename rather than a 'now' variable, any downside to doing it like that?

More than likely a lack of knowledge on my part, I was figuring it out as I was going along :)

If you’ve created a script and it worked displaying the date, then it sounds good to me.
 

DaveW

Active Member
May 21, 2019
1,197
955
Beds, UK
Final tweak to my overview dashboard (for now at least). Managed to work out a hamfisted way of doing all the calculations I was doing in an excel sheet to work out my cost savings (factoring in the extra per month the Model 3 is, taking into account cheaper insurance etc..).

Very glad you posted this thread @Roy W. :)

Not a bad saving in nine months, it would be more by now, but where I'm not going anywhere, but still paying extra for the car and the lack of free charging at work etc..

DW TM Dash final.jpg
 
  • Like
Reactions: Stach and Roy W.

Roy W.

Battery running low...
Jun 3, 2019
2,334
2,401
Derby, UK
Final tweak to my overview dashboard (for now at least). Managed to work out a hamfisted way of doing all the calculations I was doing in an excel sheet to work out my cost savings (factoring in the extra per month the Model 3 is, taking into account cheaper insurance etc..).

Very glad you posted this thread @Roy W. :)

Not a bad saving in nine months, it would be more by now, but where I'm not going anywhere, but still paying extra for the car and the lack of free charging at work etc..

View attachment 540130
I’m so glad I posted the thread too. It’s been mutually beneficial, to say the least. I’m gradually learning little bits and bobs, although I’ll never be a coder!

I’m just so impressed with the work that Adrian Klumph has done, and now you and others are adding to it.

I really like the look of your Overview dashboard, but presumably there is additional work to do each time TeslaMate is updated?
 

DaveW

Active Member
May 21, 2019
1,197
955
Beds, UK
I’m so glad I posted the thread too. It’s been mutually beneficial, to say the least. I’m gradually learning little bits and bobs, although I’ll never be a coder!

I’m just so impressed with the work that Adrian Klumph has done, and now you and others are adding to it.

I really like the look of your Overview dashboard, but presumably there is additional work to do each time TeslaMate is updated?

My coding days started and ended at college sadly, known enough to be dangerous ever since :D

The dash shouldn’t require much in the way of changing unless some of the backend DB tables get changed. All of the other values I’ve added in are saved as variables within the specific dash I’ve made (saved a copy locally just in case :) )
 
  • Like
Reactions: Roy W.
I've tried to connect with this command line:

psql -h localhost -p 5432 -d docker -U teslamate --password

I get the response to enter a password, so I'm assuming the outside connection is active, or am I wrong? The postgresql port set in the yaml file is 5432, which I also used in the command.

What is the exact command you want me to run?

Are you sure you are connecting to the container, not something that runs locally on you machine?

Port mapping on a running container cant be changed, you should stop the container and restart using the correct directive in the Docker compose file.
Compose file version 3 reference.

in my case it would be:

Code:
  database:
    image: postgres:12
    restart: always
    environment:
      - POSTGRES_USER=${TM_DB_USER}
      - POSTGRES_PASSWORD=${TM_DB_PASS}
      - POSTGRES_DB=${TM_DB_NAME}
    volumes:
      - teslamate-db:/var/lib/postgresql/data
ports:
      - 5432:5432

this would work assuming you don't have already anything running on this port in your local ubuntu.

You can always map this port to other available port e.g -8890:5432

My setup may be a bit different to yours as my teslamate and grafana is hosted in Azure and available on the internet, but in the instance of Postgres it would be identical (with yours having probably default values in the password and user sections
 
Last edited:
  • Like
Reactions: goul
Not sure if this is of use to others, but a couple of months back I bulk created geofences for all of the UK Supercharger locations based on data taken from OpenChargeMap.

You can run the SQL below to add these to your existing Teslamate database, however you might need to clean-out any duplicates if you already have some of these defined.

Code:
## To access the Teslamate database (on the default Docker install), from a CLI shell run:
docker exec -it teslamate_database_1 psql -U teslamate

## To check what geofences currently exist run this SQL:
SELECT * FROM geofences;

## To remove a geofence run this SQL, replacing xxx with the Geofence ID found from the output generated above:
DELETE FROM geofences WHERE id = xxx;

## To exit from the Postgres CLI shell type:
\q

Code:
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('North Greenwich Supercharger', 51.502543, -0.000031, 35, '2020-03-21 22:36:34', '2020-03-21 22:36:34', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Park Royal Supercharger', 51.526810, -0.283526, 35, '2020-03-21 22:36:53', '2020-03-21 22:36:53', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Eurocentral Supercharger', 55.835905, -3.984377, 35, '2020-03-21 22:36:53', '2020-03-21 22:36:53', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Manchester-South Supercharger', 53.430272, -2.179346, 35, '2020-03-21 22:36:53', '2020-03-21 22:36:53', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Wokingham Supercharger', 51.428333, -0.898835, 35, '2020-03-21 22:36:53', '2020-03-21 22:36:53', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('The Royal Crescent Hotel & Spa', 51.387342, -2.368139, 35, '2020-03-21 22:36:53', '2020-03-21 22:36:53', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Liphook Supercharger', 51.076481, -0.831521, 35, '2020-03-21 22:36:53', '2020-03-21 22:36:53', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Tesla London-Brent Cross', 51.576293, -0.223638, 35, '2020-03-21 22:36:53', '2020-03-21 22:36:53', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('London-Brent Cross Supercharger', 51.577530, -0.223753, 35, '2020-03-21 22:36:53', '2020-03-21 22:36:53', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Perth Supercharger', 56.386024, -3.479455, 35, '2020-03-21 22:36:53', '2020-03-21 22:36:53', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Membury Eastbound Supercharger', 51.483904, -1.556787, 35, '2020-03-21 22:36:53', '2020-03-21 22:36:53', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Burtonwood Supercharger', 53.417576, -2.639682, 35, '2020-03-21 22:36:53', '2020-03-21 22:36:53', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Scotch Corner Supercharger', 54.442066, -1.671229, 35, '2020-03-21 22:36:53', '2020-03-21 22:36:53', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Kent Bluewater', 51.438598, 0.269440, 35, '2020-03-21 22:36:53', '2020-03-21 22:36:53', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Aviemore Supercharger', 57.189837, -3.836126, 35, '2020-03-21 22:36:53', '2020-03-21 22:36:53', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Fleet Supercharger (Eastbound)', 51.296116, -0.857413, 35, '2020-03-21 22:36:53', '2020-03-21 22:36:53', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Membury Westbound Supercharger', 51.481232, -1.556154, 35, '2020-03-21 22:36:53', '2020-03-21 22:36:53', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Portsmouth Supercharger', 50.847768, -0.991083, 35, '2020-03-21 22:36:53', '2020-03-21 22:36:53', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Penrith, UK - Tebay Southbound Supercharger', 54.453346, -2.605861, 35, '2020-03-21 22:36:53', '2020-03-21 22:36:53', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Telford Supercharger', 52.677440, -2.399171, 35, '2020-03-21 22:36:53', '2020-03-21 22:36:53', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Stoke-on-Trent Northbound Supercharger', 52.992960, -2.290314, 35, '2020-03-21 22:36:53', '2020-03-21 22:36:53', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Michaelwood Northbound Supercharger', 51.656236, -2.434815, 35, '2020-03-21 22:36:53', '2020-03-21 22:36:53', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Lifton Supercharger', 50.643682, -4.284655, 35, '2020-03-21 22:36:53', '2020-03-21 22:36:53', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Warwick - Southbound Supercharger', 52.219170, -1.501274, 35, '2020-03-21 22:36:53', '2020-03-21 22:36:53', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Newport Pagnell - Southbound Supercharger', 52.084312, -0.748467, 35, '2020-03-21 22:36:53', '2020-03-21 22:36:53', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Woodall Southbound Supercharger', 53.314145, -1.281904, 35, '2020-03-21 22:36:53', '2020-03-21 22:36:53', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Warwick - Northbound Supercharger', 52.216065, -1.504796, 35, '2020-03-21 22:36:53', '2020-03-21 22:36:53', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Grantham Supercharger', 52.948600, -0.678092, 35, '2020-03-21 22:36:53', '2020-03-21 22:36:53', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Heathrow Supercharger', 51.478172, -0.515604, 35, '2020-03-21 22:36:53', '2020-03-21 22:36:53', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Bristol - Cribbs Causeway Supercharger', 51.526694, -2.599806, 35, '2020-03-21 22:36:53', '2020-03-21 22:36:53', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Charnock Richard (Northbound) Supercharger', 53.630500, -2.692696, 35, '2020-03-21 22:36:53', '2020-03-21 22:36:53', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Sarn Supercharger', 51.535351, -3.577637, 35, '2020-03-21 22:36:54', '2020-03-21 22:36:54', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Thetford Supercharger', 52.386434, 0.664575, 35, '2020-03-21 22:36:54', '2020-03-21 22:36:54', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Doubletree (Hilton) Car Park', 56.466441, -3.062970, 35, '2020-03-21 22:36:54', '2020-03-21 22:36:54', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Gordano Services Tesla Supercharger', 51.477207, -2.706308, 35, '2020-03-21 22:36:54', '2020-03-21 22:36:54', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Tesla Leeds Supercharger', 53.732797, -1.585612, 35, '2020-03-21 22:36:54', '2020-03-21 22:36:54', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Washington Supercharger', 54.887620, -1.557413, 35, '2020-03-21 22:36:54', '2020-03-21 22:36:54', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Tesla Barnsley Supercharger', 53.489393, -1.486223, 35, '2020-03-21 22:37:40', '2020-03-21 22:37:40', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Tesla Gretna Green Supercharger', 55.007810, -3.083087, 35, '2020-03-21 22:37:41', '2020-03-21 22:37:41', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Tesla London-Westfield London', 51.507888, -0.221972, 35, '2020-03-21 22:37:41', '2020-03-21 22:37:41', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Tesla Birchanger Green Supercharger', 51.871093, 0.194248, 35, '2020-03-21 22:37:41', '2020-03-21 22:37:41', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Tesla Folkestone - Eurotunnel Terminal Supercharger', 51.097070, 1.120452, 35, '2020-03-21 22:37:41', '2020-03-21 22:37:41', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Tesla London Heathrow', 51.510887, -0.460554, 35, '2020-03-21 22:37:41', '2020-03-21 22:37:41', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Tesla Stoke-on-Trent Southbound Supercharger', 52.994202, -2.290657, 35, '2020-03-21 22:37:41', '2020-03-21 22:37:41', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Tesla London - The Royal Victoria Docks Supercharger', 51.507719, 0.015861, 35, '2020-03-21 22:37:41', '2020-03-21 22:37:41', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Tesla Abington Supercharger', 55.507919, -3.694857, 35, '2020-03-21 22:37:41', '2020-03-21 22:37:41', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Tesla Supercharger Northampton', 52.186047, -0.891123, 35, '2020-03-21 22:37:41', '2020-03-21 22:37:41', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Tesla Warrington Supercharger', 53.339874, -2.571076, 35, '2020-03-21 22:37:41', '2020-03-21 22:37:41', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Tesla London Tower Supercharger / Tower Hotel', 51.506599, -0.073374, 35, '2020-03-21 22:37:41', '2020-03-21 22:37:41', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Tesla Dartford Supercharger', 51.438103, 0.268898, 35, '2020-03-21 22:37:41', '2020-03-21 22:37:41', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Tesla Maidstone Supercharger', 51.286220, 0.546082, 35, '2020-03-21 22:37:41', '2020-03-21 22:37:41', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('South Mimms Welcome Break M25 Services Supercharger', 51.687523, -0.223616, 35, '2020-03-21 22:37:41', '2020-03-21 22:37:41', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Reading Supercharger', 51.420600, -0.987965, 35, '2020-03-21 22:37:41', '2020-03-21 22:37:41', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Tesla Supercharger - Norton Park Hotel', 51.167228, -1.328010, 35, '2020-03-21 22:37:41', '2020-03-21 22:37:41', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Exeter Supercharger', 50.685449, -3.448778, 35, '2020-03-21 22:37:41', '2020-03-21 22:37:41', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Canary Wharf Tesla Supercharger', 51.504622, -0.016295, 35, '2020-03-21 22:37:41', '2020-03-21 22:37:41', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Oxford Supercharger', 51.737350, -1.094870, 35, '2020-03-21 22:44:09', '2020-03-21 22:44:09', 0.2400, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_kwh, session_fee) VALUES ('Hopwood Park Services Tesla Supercharger', 52.363145, -1.945500, 35, '2020-03-21 22:37:41', '2020-03-28 11:07:40', 0.2400, NULL);
 

Products we're discussing on TMC...

About Us

Formed in 2006, Tesla Motors Club (TMC) was the first independent online Tesla community. Today it remains the largest and most dynamic community of Tesla enthusiasts. Learn more.

Do you value your experience at TMC? Consider becoming a Supporting Member of Tesla Motors Club. As a thank you for your contribution, you'll get nearly no ads in the Community and Groups sections. Additional perks are available depending on the level of contribution. Please visit the Account Upgrades page for more details.


SUPPORT TMC
Top