Welcome to Tesla Motors Club
Discuss Tesla's Model S, Model 3, Model X, Model Y, Cybertruck, Roadster and More.
Register

TeslaMate [megathread]

This site may earn commission on affiliate links.
#221
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 ?
 
#222
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.
 
#224
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.

Houseofdreams said:
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 ?
Click to expand...
 
  • Helpful
Reactions: Roy W.
#226
goul said:
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.
Click to expand...

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?
 
#227
@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?
 
#228
bhanorthy said:
@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?
Click to expand...

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.
 
#229
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.
#230
DaveW said:
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
Click to expand...
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?
 
#231
Roy W. said:
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?
Click to expand...

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.
#233
Houseofdreams said:
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?
Click to expand...

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
#238
#240
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);
 
  • Like
Reactions: piotroek, drewpost, mpandrew and 3 others
You must log in or register to reply here.

Similar threads

K
M3 windows opened/vented themselves this morning
Replies
5
Views
520
The UK and Ireland
dirty_park
D
J
Question: How to report cameras to Tesla navigation's new speed camera detection feature?
Replies
10
Views
637
Software: Firmware Updates, Features, Tesla App
Cley
C
X
Using Fleet API to Control My Powerwall Reserve Percentage
Replies
25
Views
2K
Tesla Energy
Mark Purcell
Mark Purcell
A
Switch from TeslaMate to Tessie
Replies
3
Views
4K
Software: Firmware Updates, Features, Tesla App
Muffstic
M
J
Why has Tesla taken so long to sort how 2 Gateways are "seen" in the app?
Replies
6
Views
561
Tesla Energy
BGbreeder
B
Top
Back
Blog
New
Forum list
Marketplace
Menu