TeslaMate [megathread]

DaveW · Apr 27, 2021

Finally got round to updating the UK Superchargers - here are the new ones since last year

Code:

INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Uxbridge Supercharger', 51.545284491469566, -0.47596417539954844, 35, '2021-04-127 06:33:00 ', '2021-04-127 06:33:00 ', 0.24, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Adderstone Supercharger', 55.56441677193173, -1.7911817423281822, 35, '2021-04-127 06:33:00 ', '2021-04-127 06:33:00 ', 0.24, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Leicester Supercharger - Fosse Park, 52.59491209568436, -1.1798746134922729, 35, '2021-04-127 06:33:00 ', '2021-04-127 06:33:00 ', 0.24, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Nottingham-Loughborough Road Supercharger', 52.93576388286502, -1.1348387513326088, 35, '2021-04-02 21:00:00 ', '2021-04-02 23:28:00 ', 0.24, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Mansfield Supercharger - East Midlands Designer Outlet', 53.108021608596715, -1.312144650162736, 35, '2021-03-28 12:00:00 ', '2021-03-28 12:00:00 ', 0.24, NULL);

Also updated here: TeslaMate - How to bulk import UK Supercharger locations - TeslaEV.co.uk with the instructions on how to import them

EDIT - I've had to do some of these manually myself, I'm guessing as not many people have been out and about that they just aren't getting added to charge map, I'll submit the missing ones myself at some point unless anyone else fancies doing it

init6 · Apr 27, 2021

DaveW said:

Finally got round to updating the UK Superchargers - here are the new ones since last year

Code:

INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Uxbridge Supercharger', 51.545284491469566, -0.47596417539954844, 35, '2021-04-127 06:33:00 ', '2021-04-127 06:33:00 ', 0.24, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Adderstone Supercharger', 55.56441677193173, -1.7911817423281822, 35, '2021-04-127 06:33:00 ', '2021-04-127 06:33:00 ', 0.24, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Leicester Supercharger - Fosse Park, 52.59491209568436, -1.1798746134922729, 35, '2021-04-127 06:33:00 ', '2021-04-127 06:33:00 ', 0.24, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Nottingham-Loughborough Road Supercharger', 52.93576388286502, -1.1348387513326088, 35, '2021-04-02 21:00:00 ', '2021-04-02 23:28:00 ', 0.24, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Mansfield Supercharger - East Midlands Designer Outlet', 53.108021608596715, -1.312144650162736, 35, '2021-03-28 12:00:00 ', '2021-03-28 12:00:00 ', 0.24, NULL);

Also updated here: TeslaMate - How to bulk import UK Supercharger locations - TeslaEV.co.uk with the instructions on how to import them

EDIT - I've had to do some of these manually myself, I'm guessing as not many people have been out and about that they just aren't getting added to charge map, I'll submit the missing ones myself at some point unless anyone else fancies doing it

Do tell how and I'll happily do some.

DaveW · Apr 27, 2021

DurkaDurka said:
As I mentioned, you don't have to define the field - it will default to "per_kwh". Your import worked fine.

BTW, if you need help with the US ones just let me know your methods and maybe I can help out.

Added the two newest ones from Chargemap for the USA, there may be others I don't know about. They are in the DropBox location, but here they are for import:

Code:

INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Nashville-Brentwood', 35.969135, -86.804301, 35, '2021-02-23 06:27:00 ', '2021-02-23 06:27:00 ', 0, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Bensalem, Pa Supercharger', 40.125289, -74.96407, 35, '2021-02-23 06:26:00 ', '2021-02-23 06:26:00 ', 0, NULL);

Dave.

DaveW · Apr 27, 2021

init6 said:
Do tell how and I'll happily do some.

- Thanks @init6

Open Charge Map - Browse Charging Locations

openchargemap.org

You can then do add location and complete the details, missing at the moment seem to be Uxbridge, Adderton and Leicester. Co-ordinates you need are all above.

Just means when these are entered, I can do a much easier extract for TM

init6 · Apr 27, 2021

So just to get my head around this, when new superchargers come online, they don't necessarily get added to Open Charge Map? I'll try to keep an eye on the SuC thread in future

DaveW · Apr 27, 2021

init6 said:
So just to get my head around this, when new superchargers come online, they don't necessarily get added to Open Charge Map? I'll try to keep an eye on the SuC thread in future

My understanding is they are all user submitted, I think I added the previous 3 or 4.

When I checked it today to update the import list there were 5 new ones, but only 2 of those had made it onto Openchargemap.

The way I normally do this is by reading the API data from openchargemap into a Google sheet I’ve made, that then uses formulas and concats to transform the output into the TM importable strings that I share with you guys

I’m sure other people use the openchargemap data too, so it’s a good thing to do.

init6 · Apr 27, 2021

I've updated Adderstone and Uxbridge, but looks like Leicester is still being built or at least that's what TOGUK says and it doesn't appear on the Tesla page.

DaveW · Apr 27, 2021

init6 said:
I've updated Adderstone and Uxbridge, but looks like Leicester is still being built or at least that's what TOGUK says and it doesn't appear on the Tesla page.

Thanks

Open again according to: supercharge.info

DaveW · Apr 28, 2021

Flint now tested as live today!

Updated my guide and here's the details, along with the ones from yesterday - which I messed the date up on 3 of them - due to the edit functionality being locked down I can't correct them:

Code:

INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Flint Supercharger', 53.22806027518491, -3.1420445269845456, 35, '2021-04-28 06:33:00 ', '2021-04-28 06:33:00 ', 0.24, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Uxbridge Supercharger', 51.545284491469566, -0.47596417539954844, 35, '2021-04-27 06:33:00 ', '2021-04-27 06:33:00 ', 0.24, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Adderstone Supercharger', 55.56441677193173, -1.7911817423281822, 35, '2021-04-27 06:33:00 ', '2021-04-27 06:33:00 ', 0.24, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Leicester Supercharger - Fosse Park, 52.59491209568436, -1.1798746134922729, 35, '2021-04-27 06:33:00 ', '2021-04-27 06:33:00 ', 0.24, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Nottingham-Loughborough Road Supercharger', 52.93576388286502, -1.1348387513326088, 35, '2021-04-02 21:00:00 ', '2021-04-02 23:28:00 ', 0.24, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Mansfield Supercharger - East Midlands Designer Outlet', 53.108021608596715, -1.312144650162736, 35, '2021-03-28 12:00:00 ', '2021-03-28 12:00:00 ', 0.24, NULL);

Rugby Moto due Friday apparently, so another update to follow

Medved_77 · Apr 28, 2021

Thanks @DaveW!

Could you edit the blob and stick an apostrophe in after 'Leicester Supercharger - Fosse Park?

DaveW · Apr 28, 2021

Medved_77 said:
Thanks @DaveW!

Could you edit the blob and stick an apostrophe in after 'Leicester Supercharger - Fosse Park?

Damn, I’m afraid not without paying for membership, edit capabilities disappear very quickly.

Take 3:

Code:

INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Flint Supercharger', 53.22806027518491, -3.1420445269845456, 35, '2021-04-28 06:33:00 ', '2021-04-28 06:33:00 ', 0.24, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Uxbridge Supercharger', 51.545284491469566, -0.47596417539954844, 35, '2021-04-27 06:33:00 ', '2021-04-27 06:33:00 ', 0.24, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Adderstone Supercharger', 55.56441677193173, -1.7911817423281822, 35, '2021-04-27 06:33:00 ', '2021-04-27 06:33:00 ', 0.24, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Leicester Supercharger - Fosse Park', 52.59491209568436, -1.1798746134922729, 35, '2021-04-27 06:33:00 ', '2021-04-27 06:33:00 ', 0.24, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Nottingham-Loughborough Road Supercharger', 52.93576388286502, -1.1348387513326088, 35, '2021-04-02 21:00:00 ', '2021-04-02 23:28:00 ', 0.24, NULL);
INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Mansfield Supercharger - East Midlands Designer Outlet', 53.108021608596715, -1.312144650162736, 35, '2021-03-28 12:00:00 ', '2021-03-28 12:00:00 ', 0.24, NULL);

PR-UK · Apr 28, 2021

For those using Grafana I see that the TrackerMap plugin has now been updated officially on the Grafana Plugin Page which should fix the dot tracking (on the map) when you mouse over the driving stats on the Drive Details page. I'm using it in a docker container and had to manually update it by typing the following in to the CLI:

Code:

grafana-cli plugins update pr0ps-trackmap-panel

Also had to do a shift+refresh to clear the browser cache for it to start working again.

DaveW · Apr 30, 2021

Rugby MOTO super chargers are live

Code:

INSERT INTO public.geofences (name, latitude, longitude, radius, inserted_at, updated_at, cost_per_unit, session_fee) VALUES ('Rugby Supercharger', 52.37309060905267, -1.2641284317527341, 35, '2021-04-30 06:33:00 ', '2021-04-30 06:33:00 ', 0.30, NULL);

mvrlogins · May 10, 2021

Is there a way to see the exactly how long a drive took?

I must be missing something obvious - but I've looked

In the list of drives, drive times are rounded to the nearest hour after 59min
On the drive details page - it's the same

I can't see either the end time of a drive or the length

JupiterMan · May 10, 2021

mvrlogins said:
Is there a way to see the exactly how long a drive took?

Just checked mine.... in the drives, if you hover your mouse arrow above the duration of the drive in question on the drive page, (i.e. 2 hours) it should then show hours & minutes in a separate little box by the arrow e.g. (1:50)

sp33dm3 · May 23, 2021

Question to the ones using Teslamate on GCP micro-f1 server :

My free trial period expired and to make Teslamate work again I had to switch to a paid account, which I did as I thought that the micro-f1 server was free.
It turns out not to be free, I am being charged for some costs.
Not that it is much or that I mind, but it's the thought that counts here....

I just want to know if other experience the same thing.
Most of the costs come from "Balanced PD Capacity", whatever that may be.

init6 · May 23, 2021

Nope. Not been charged anything. Check to see if your disks are Standard. Sounds like you've selected a (relatively) more expensive balanced disk option.

This guide mentions the disk type to use:

How to set up a free micro VPS on Google Cloud Platform

Configuring a virtual private server (VPS) on Google Cloud Platform that is “always free”

hbmy289.medium.com

sp33dm3 · May 24, 2021

init6 said:
Nope. Not been charged anything. Check to see if your disks are Standard. Sounds like you've selected a (relatively) more expensive balanced disk option.

This guide mentions the disk type to use:

How to set up a free micro VPS on Google Cloud Platform

Configuring a virtual private server (VPS) on Google Cloud Platform that is “always free”

hbmy289.medium.com

Up until recently I wasn't charged of anything as well.
Only when my free trial was up and I had to upgrade my billing account, it started to charge costs.

I have a normal micro-f1 server, exactly set up according to that manual you posted, with a standard disk that is.

init6 · May 24, 2021

That looks exactly the same as mine and I'm not getting charged anything. Happy to compare other parameters via chat if you want to see if there is anything else different.

sp33dm3 · May 24, 2021

I think I have found the cause....

Besides a VM for TeslaMate, I also created a second VM for TeslaLogger to test that.
However, that never worked and so I stopped the VM.

When I check "Disks" in GCP, I saw that my TeslaLogger VM was using a "Balanced PD capacity" disk and that was exactly what the costs were about.
I'll check it again in a couple of days.

TeslaMate [megathread]

Active Member

Active Member

Active Member

Active Member

Active Member

Active Member

Active Member

Active Member

Active Member

TM3 SR+ | MSM+Black | No FSD

Active Member

Member

Active Member

Member

Active Member

Member

Active Member

Member

Attachments

Active Member

Attachments

Member

Similar threads