Ecars stats - a work in progress

Black_Knight

As some may know i've been pulling stats from ecars this while now. Until now it's been running on my home mini-pc, but I always wanted to make it more public. I had/have planned to re architect it to run as cheaply as I can in the cloud, and to add a few more insights (like peak times per charge point) but time is against me. For now, i've just moved it to a VM with certainly not enough memory (trying to keep costs down). It's not finished (it never will be) but for now I said i'd open it up and see how it runs (or falls over) with some traffic.

With that in mind, go gentle (on me and the queries). It's not fallen over on me yet (only have it running 24 hours now), but a few extra users throwing queries at it might be the tipping point. I'd like to keep the cost below a couple of hundred a year so i've a small margin to add more memory, but if it just can't handle the traffic it'll have to wait until I've time to re architect it entirely.

It's all grafana, and I didn't setup anonymous read only access yet, so it's user/password for now.

https://ecars-stats.com/d/eFhAZ1cMz/esb-charger-availablilty
test:testPassword

Kramer

........awaits DDOS attack from ECars..........:D.

Kramer

Fair play, great work .

innrain

Looks very nice.
If I understand correctly on the graphs y represents how many plugs are connected at any given moment. On you screen grab at 16:00 are 8 CHAdeMO, 5 CCS and 2 Type2 (in majority AC43). Or now 20:55 5 CHA and 4 CCS -> 10% of the network is in use. Cool

Black_Knight

Kramer wrote: »

........awaits DDOS attack from ECars..........:D.

I DOS them, they DDOS me. Checkmate

Kramer

Would you have the stats for the Thomond, Limerick rapid for those 13 days I posted overall throughput for, in this post?

https://www.boards.ie/vbulletin/showpost.php?p=115076440&postcount=2405

It might be interesting to see how many individual charges were recorded, the ratio between CCS & Chademo, the average kWh drawn, if anyone stayed beyond 45 minutes etc.

No AC usage in that time so it might be easier, if you have the data for that period.

Black_Knight

innrain wrote: »

Looks very nice.
If I understand correctly on the graphs y represents how many plugs are connected at any given moment. On you screen grab at 16:00 are 8 CHAdeMO, 5 CCS and 2 Type2 (in majority AC43). Or now 20:55 5 CHA and 4 CCS -> 10% of the network is in use. Cool

Yeah. For those graphs the Y axis is a count. The graphs over time are accurate to every 5 minutes. FYI the TYPE_2_MENNEKES is "Maxol Centra Antrim Road Filling Station". Says it's AC43 on the app, but when it's queried it's returns as TYPE_2_MENNEKES. If you go to that unit and filter by AC43 you won't see any results. Glitch I guess.

The single stat panels are a count of the type of socket used in that time period. eg. Filtering by "Today so far" I can see 49 CCS socket sites were in use* and 58 CHAdeMO socket sites were in use*. 20 AC43 were also in use during this time.


*In use is a loose term. The actual number represents the number of unique sites which were fully occupied for that socket today.

Under the "Units/Sites" row you can see that that 58/49/20 usage count sums up to 77 FCP sites being fully occupied today. I could probably break that down to DC FCP fully occupied and AC FCP fully occupied if wanted, though not sure how much use it is.

Black_Knight

Kramer wrote: »

Would you have the stats for the Thomond, Limerick rapid for those 13 days I posted overall throughput for, in this post?

https://www.boards.ie/vbulletin/showpost.php?p=115076440&postcount=2405

It might be interesting to see how many individual charges were recorded, the ratio between CCS & Chademo, the average kWh drawn, if anyone stayed beyond 45 minutes etc.

No AC usage in that time so it might be easier, if you have the data for that period.

You can do that.... in a somewhat roundabout way. Find the siteID for thomond (ctrl F really). site ID is 22

Pop 22 in the input at the top, and open the "general" row down the very bottom. It'll be messy, but it'll show you what the site was doing.

https://ecars-stats.com/d/eFhAZ1cMz/esb-charger-availablilty?orgId=1&from=1602611400000&to=1603828200000&var-SiteID=499&var-SocketType=All

Search Thomondgate. 14.17hours. Lines up pretty well with your data. 33kW average.

I could get a graph showing charging against time over that time period, but when I tried it there I think I OOM killed my DB.
EDIT: Got it:
https://ecars-stats.com/d/eFhAZ1cMz/esb-charger-availablilty?orgId=1&from=1602611400000&to=1603828200000&var-SiteID=22&var-SocketType=TYPE_COMBO_GERMANY

Hard to see the period of charing given the scale, but you can see how often CCS was used VS CHAdeMO. Just use the drop down up the top to change socket type.
From the Socket section I can see for that time period CCS:
2020-10-13 18:50:00 Circle K -Topaz Service Station, Sexton Street North, Thomondgate, Limerick City 22 8.25 hour
CHAdeMO:
2020-10-13 18:50:00 Circle K -Topaz Service Station, Sexton Street North, Thomondgate, Limerick City 22 5.92 hour

Black_Knight

Totally jumping to conclusions here, but I'm gonna say a Zoe broke the Frankfield hill charge point the other day. Spotted it red today when I drove past.
https://ecars-stats.com/d/eFhAZ1cMz/esb-charger-availablilty?orgId=1&from=1603890093588&to=1603898042909&var-SiteID=499&var-SocketType=All&var-Name=Circle%20K%20-%20Topaz%20Frankfield%20Service%20Station,%20Frankfield%20Road,%20Douglas,%20Cork

Goes from AC43 charging to unknown and unknown ever since.

30 hours out of use now. Good job ECars. Highly dependable.

Black_Knight

Added a heatmap for usage per unit over the last week (select the unit from the dropdown at the top). Not exactly what I'd want but for now it's all i've time for.

Ideally i'd aggregate 4 weeks of data into a week (split by days of the week) to give a rounder impression of typical usage per day. Needs thinking though. In the meantime, any feedback is welcome.

innrain

I think the idea to align the data sets based on weekdays it is very good. Not sure how difficult would be but having an average to compare to it is helpful. Say you want to compare today's usage pattern for a unit you need a reference and averaging all weekdays together might loose some insights. By comparing Mondays with Mondays you have a better picture.

I noticed that the graphs in the units/sites panels have an offset of 1? They never drop to zero.

Black_Knight

innrain wrote: »

I think the idea to align the data sets based on weekdays it is very good. Not sure how difficult would be but having an average to compare to it is helpful. Say you want to compare today's usage pattern for a unit you need a reference and averaging all weekdays together might loose some insights. By comparing Mondays with Mondays you have a better picture.

I noticed that the graphs in the units/sites panels have an offset of 1? They never drop to zero.

Yeah, I did that because some of the graphs were jumping to 0 (when metrics were missed in a 5 minute period). And I only store data on the current active state of the site, not every state (ie. if you're charging, then available=0, occupied=0, preparing=0 etc). It looked a bit janky.

I've updated it now so a lack of a metric will be a zero value. Let me know what you think


Also. 99 fast charger sites! Galway will likely be the 100th.

Black_Knight

Added anonymous access. No need for a login anymore

jusmeig

Great work!!!!

Black_Knight

Can see the rush on Cashel on the 18th (inter county travel permitted) after work.



Does everyone flock there because Ionity is a backup, but then not want to use it because it's so expensive. Other surrounding DC units seemed relatively quiet.

Created a slim down dashboard to just check individual sites.
https://ecars-stats.com/d/1CqPEh1Gk/ecars-single-site-data?orgId=1

Wanted to have aggregated view of the week for each site ready for the Christmas rush, but zero time to get it together.

zg3409

Slightly different but similar project from NI, to collect details from NI ESB and non ESB sites. The aim is to use as proof to lobby for improvement to public charging network.

Read only manual data entered here:

https://docs.google.com/spreadsheets/d/1TOSPH63cx8Ez3RAbuP3MDy-d5bbTpx3fo8J8fUitObs/edit?usp=sharing

From NI EV owners Facebook

Sam Johnston , Everybody :

I have attempted to create an online database of Charge points in Northern Ireland. I've not done this with fancy API's, just a few late nights using cpinfo's last archive, cross referenced with plugshare and easygo to get the current online status. This is not complete, because cpinfo archive does not include newer( e.g. lidl ) chargers.

The data is now in a google sheet so available for any of us to update ( or spam with fake news !)

So here's state of the [partial] network as of this week

Link below is the non-editable google sheet for review. If you have any more chargers you want me to add, let me know and I'll update it until it a) gets unmanageable or b) someone has webz skillz and volunteers to add a nice webfront end to automate updating.

Why bother doing this? Because we can create proper stats on the overall network, something that is very much absent in the existing system, where you have to piecemeal enter individual chargepoints.

Anyone with better google sheet skills than me can also use this data set to get some really good info, like geographic dead spots etc.

obviously those postal regions without *any* chargers don't appear on the map at all, but from my reading of the pivot table, BT30,35,36,37,41,45,47 and 78 are particularly badly in need of repair.

The numbers of chargers: I've been generous and counted every socket, not just the stations. This also allows us to mark every non-functional cable as many stations have one working and one offline.

I've set anything as "Not working" where Easygo reports broken, or no communication. I've also been generous and assumed every station that doesn't explicitly mention power is outputting 22kW AC - if you know ones that should be 11 or 7 ( or 43 ) please let me know.

Goog Sheet : https://docs.google.com/spreadsheets/d/1TOSPH63cx8Ez3RAbuP3MDy-d5bbTpx3fo8J8fUitObs/edit?usp=sharing

Black_Knight

zg3409 wrote: »

Slightly different but similar project from NI, to collect details from NI ESB and non ESB sites. The aim is to use as proof to lobby for improvement to public charging network.

Read only manual data entered here:

https://docs.google.com/spreadsheets/d/1TOSPH63cx8Ez3RAbuP3MDy-d5bbTpx3fo8J8fUitObs/edit?usp=sharing

From NI EV owners Facebook

Ugh. Manual will never work out. I might reach out and share my site. I've bumped the spec of the machine so it can query maybe a week, but sure you know yourself week on week everything changes. I've some logic to build report data for every unit per day, and then roll that up into a week, but I've no time to look into visualising that. It'd likely need something custom made and my front end skills ain't there.

New baby hasn't afforded me much spare time.

Black_Knight

After lots of twiddling my thumbs I finally did a bit of work on this. Nothing to do with "busy times" or anything like that, but moreso the "how's progress going" side of things.

https://ecars-stats.com/d/N7D-5-VMk/ecars-marked-for-upgrade

List of added and removed units (literally just finished now so no historical data):



I improved the charger lookup also, so if you search "Kilmartins" you now see the list of every unit on that site, ie. 2.

Also made the single site data a bit more performant and robust.
https://ecars-stats.com/d/1CqPEh1Gk/ecars-single-site-data


I want to build a better "peak times" widget, but I don't think it's possible in Grafana, and certainly too heavy on system memory. I can calculate the peak times per day, and then roll that up into a 4 week period no problem, but displaying it is a different story, and i'm certainly not a front end developer.

Black_Knight

I'd like to say i've been working on getting something a bit more useful out there for the last few months, but sadly time is very limited. I've been doing some backend work to build data on each sites chargers sockets usage so I can put that data into a heatmap, and that's gone pretty well, but my lack of web front end skills is really showing now.
Had a few hours this weekend to try put something together. Not sure it's the right direction to be going, but i'm learning by doing so as I learn i'll hopefully improve it, or get frustrated, scrap it and start again.

http://test.ecars-stats.com/plotly.html
It's not dynamic yet, only shows CCS, and the numbers don't really mean anything (a 1 indicates that over the last 4 weeks on that day at that hour the site was in use for 5 minutes).

Next steps are to:
* get the numbers signifying minutes
* Account for sites with multiple of the same socket
* Allow selection of any site
* Display all socket types at a site

innrain

I think it is brilliant the fact you manage to align the data. I can read a color chart even without numbers. They could be useful when comparing two different chargers otherwise the color is enough. The sum of the minutes used divided to the bin size (60 mins) should do the trick.
I would use the rainbow color scheme as it is more granular but that is something personal.
Yesterday you had Lucan on the page and by comparison with N11 you could see the former was in the city with check ins @1am. EV drivers not risking being out of juice so late on the motorway

Black_Knight

Updated now to have selectable locations. Nevermind duplicates, it's returning addresses for each unit rather than being reduced to 1 per site.

The data shown is an accumulation of when a socket (CCS only for now) has been charging (or unavailable to use because the other plug, CHAdeMO, is in use).

Multi unit sites (mayfield etc) will look busier, but that's just because there's more charging going on at those places. I'll scale that down so the numbers are percentage of use per hour divided by available sockets.

eg. If only 1 CCS socket was in use for a full hour (3pm-4pm) at mayfield should only represent 16% usage for that hour, as there's 6 CCS plugs there. I'm trying to give a visualisation on the likelihood when you arrive at a site, there'll be an available socket for you.

Also plan to map out the faulty sockets in a similar fashion.

innrain

Talbot Hotel Stillorgan Saturday @6am close to the max bracket The other Stillorgan P&R utilized nearly 24h on Saturdays Who said Blanch and Lucan are bad.
M9 Kilcullen used up 24h on Mon/Tue (probably bank holiday spur). Nice data. And this is CCS only.

Black_Knight

innrain wrote: »

Talbot Hotel Stillorgan Saturday @6am close to the max bracket The other Stillorgan P&R utilized nearly 24h on Saturdays Who said Blanch and Lucan are bad.
M9 Kilcullen used up 24h on Mon/Tue (probably bank holiday spur). Nice data. And this is CCS only.

All the more reason for me to handle sites with multiple chargers better, and get the values in % terms rather than what they currently are (I won't go into it, but at the moment 48 would mean for the last 4 weeks CCS has been in full use that hour).
Where there's X CCS plugs at a site, divide the number in the box by X. Or wait for me to fix it so they're all uniform.

Nice spot though. They're crazy busy!

innrain wrote: »

And this is CCS only.

True, but it does take into account when CHAdeMO is in use and thus blocking CCS from being used.

Data when CCS charging or CCS unavailable because CHAdeMO is in use:


Data when CCS charging only:


The combo would suggest a lot of late night charging... i'll look into that. That seems unlikely. Do I need to stick a bit BETA sticker all over the page?


EDIT: It's not a bug. That's someone not charging but plugged in. Makes sense at a hotel. Unit has status "AVAILABLE" but when you look at the socket itself it's "CHARGING". Explains why I can see CHAdeMO socket being much more available than the CCS one at Talbot hotel - the CCS spends most its time plugged into cars not charging.

Calahonda52

Great project:)
1: Can the week start on Monday, makes comparing busy times at weekend easier, for weekends away
2: why just one Lidl: is it a pay one?
3: Randels garage Tralee, is it open on Sundays?: I use it when down there 5 euro a fill: they closed the long weekend

innrain

Black_Knight wrote: »

The combo would suggest a lot of late night charging... i'll look into that. That seems unlikely. Do I need to stick a bit BETA sticker all over the page?


EDIT: It's not a bug. That's someone not charging but plugged in. Makes sense at a hotel. Unit has status "AVAILABLE" but when you look at the socket itself it's "CHARGING". Explains why I can see CHAdeMO socket being much more available than the CCS one at Talbot hotel - the CCS spends most its time plugged into cars not charging.

No it does not need beta. The link is called test which is self-explanatory.



Interesting. Maybe someone from the nearby apartments charging overnight?

innrain

Calahonda52 wrote: »

Great project:)
1: Can the week start on Monday, makes comparing busy times at weekend easier, for weekends away
2: why just one Lidl: is it a pay one?
3: Randels garage Tralee, is it open on Sundays?: I use it when down there 5 euro a fill: they closed the long weekend

@2 It is from the 3rd party list off the ecars map. No data from that unit anyway. I think it is AC now but ecars doesn't know

@3 It is Killarney not Tralee is in the petrol station and it is accessible overnight.

Black_Knight

Calahonda52 wrote: »

Great project:)
1: Can the week start on Monday, makes comparing busy times at weekend easier, for weekends away
2: why just one Lidl: is it a pay one?
3: Randels garage Tralee, is it open on Sundays?: I use it when down there 5 euro a fill: they closed the long weekend

Sure. Gimme a sec

Black_Knight

Calahonda52 wrote: »

Great project:)
1: Can the week start on Monday, makes comparing busy times at weekend easier, for weekends away
2: why just one Lidl: is it a pay one?
3: Randels garage Tralee, is it open on Sundays?: I use it when down there 5 euro a fill: they closed the long weekend

Black_Knight wrote: »

Sure. Gimme a sec

Done.

Calahonda52

innrain wrote: »

@2 It is from the 3rd party list off the ecars map. No data from that unit anyway. I think it is AC now but ecars doesn't know

@3 It is Killarney not Tralee is in the petrol station and it is accessible overnight.

specsavers1
Thanks

Black_Knight

Numbers are now a % chance that socket is not going to be available when you land there (either in use or unavailable because DC is in use by the other plug).

Numbers now also take into account how many sockets of a certain type there are at a site.

Next:
- Filterable dropdown
- Add the other sockets to the page/ability to toggle between CCS/CHAdeMO etc. (I assume one would only really care about 1 socket type, rather than rendering both at the same time on screen.
- Add the same view but for how often a unit is faulty.
- Make it less crap looking... gonna struggle here for sure. :pac:

innrain

That is pretty neat. Now you just need a mobile app where the user select the charger they want to go to and get advised if the charger is likely to be free @ arrival time. Get notified if the charger is getting used while driving towards it with an revised likelihood of being free @ arrival time. Considering our network will remain behind the EV take out for a very long time the app would be useful enough. Find a way to monetize this and you're flying with Bezoos to the moon

Black_Knight

innrain wrote: »

That is pretty neat. Now you just need a mobile app where the user select the charger they want to go to and get advised if the charger is likely to be free @ arrival time. Get notified if the charger is getting used while driving towards it with an revised likelihood of being free @ arrival time. Considering our network will remain behind the EV take out for a very long time the app would be useful enough. Find a way to monetize this and you're flying with Bezoos to the moon

So I heard you say... add "buy me a coffee" to the page. Gotcha. The expense to be fair isn't much. €20 a month to host the VM everything is running on. The personal time I put in is probably the biggest expense but at least I get some enjoyment from it when it goes well.

Never really thought about mobile, though it's a very valid point. Who uses a laptop/desktop anymore!? That'll be ways away though. Front end (obviously) is not my forte. I'll put it on the list.

Predicting when a unit would be available is a bit more complicated. You'd want to be getting average charge durations at different times of the day and applying that to the current status of the unit. That's machine learning territory. Won't be going that direction. I really just want somewhere that folks can digest their ability to use a charging site at different days and times. Baby steps

listermint

You need to connect with a data analysis grad probably somewhere like NCI for example. There's potential product in here with the mobile first being the approach. The machine learning part is alot less cumbersome than it sounds a decent project orientated grad could be quite interested in this.

Black_Knight

listermint wrote: »

You need to connect with a data analysis grad probably somewhere like NCI for example. There's potential product in here with the mobile first being the approach. The machine learning part is alot less cumbersome than it sounds a decent project orientated grad could be quite interested in this.

Probably right, just right now for me it's not worth the time and expense to do anything like that. I'll always look to add more to it, but right now it's about getting something basic out there.

Ideally i'd move all this to run on some cloud services, ideally as many free ones as possible, but it was a battle between getting something out soon vs ramping up on new tech.

Black_Knight

You can toggle between socket types now.

Calahonda52

Black_Knight wrote: »

You can toggle between socket types now.

Great, it might be good to include the link each time..:
easier than scrolling up to find it

Black_Knight

Calahonda52 wrote: »

Great, it might be good to include the link each time..:
easier than scrolling up to find it

You mean you've not bookmarked it? :pac:

I've asked mods to add http://test.ecars-stats.com/ to the original post on this thread.

Oh, and i've made the dropdown more searchable.

Up next is probably:
A site summary for the week/month - #of units, #of each socket, % of time not dead
Map site downtime this week/month
Handle removed units (backend work)
Handle slow chargers (fingers crossed my backend work/data gathering is correct)

And of course, what fallout comes from the esb map update tomorrow.

Black_Knight

A crucial milestone. :pac::pac::pac:

https://www.buymeacoffee.com/ecarsstats

Calahonda52

Thanks again
There is no data for Barlow Nissan , a dealer charger, just wonder why its there, Randles in TRALEE, another dealer is not listed which is what I expect

Black_Knight

Calahonda52 wrote: »

Thanks again
There is no data for Barlow Nissan , a dealer charger, just wonder why its there, Randles in TRALEE, another dealer is not listed which is what I expect

Hey. So I can probably handle that. Thanks for pointing out out.
The list of sites is, currently, just every site which ESB categories as FAST or ULTRA_FAST, regardless of whether there's usage data behind it. The lookup is just a bit more efficient this way. I'll probably leave them, but I need to handle scenarios where there's no data better:
Sites without a certain socket/plug
3rd party sites with no data


http://test.ecars-stats.com/


Edit: randles in Tralee works fine for me.

Calahonda52

Black_Knight wrote: »

Hey. So I can probably handle that. Thanks for pointing out out.
The list of sites is, currently, just every site which ESB categories as FAST or ULTRA_FAST, regardless of whether there's usage data behind it. The lookup is just a bit more efficient this way. I'll probably leave them, but I need to handle scenarios where there's no data better:
Sites without a certain socket/plug
3rd party sites with no data


http://test.ecars-stats.com/


Edit: randles in Tralee works fine for me.

Thanks again, at the risk of being a PITA, its Randles Killarney you have listed, which is an ESB rig on the garage site, whereas Randles Tralee is inside the garage compound and not a public CP.

Its a really interesting resource showing demand, sites like Blanch SC is astounding usage

ps Hutton and Meade ( nissan garage) looks like another blank as does IKEA Belfast (Brexit so no X border )

Black_Knight

Calahonda52 wrote: »

Thanks again, at the risk of being a PITA, its Randles Killarney you have listed, which is an ESB rig on the garage site, whereas Randles Tralee is inside the garage compound and not a public CP.

Its a really interesting resource showing demand, sites like Blanch SC is astounding usage

ps Hutton and Meade ( nissan garage) looks like another blank as does IKEA Belfast (Brexit so no X border )

Ah sorry. You're saying you expect Randles in Tralee to not be listed. I follow you now.

Yeah, ESB removed a bunch of Nissan garages from the app last year, but not all of them. Not sure why they're there in the first place.

Fix incoming....

Black_Knight

Black_Knight wrote: »

Fix incoming....

Fixed.

Now to get back to my real job. :eek:

innrain

Calahonda52 wrote: »

Thanks again, at the risk of being a PITA, its Randles Killarney you have listed, which is an ESB rig on the garage site, whereas Randles Tralee is inside the garage compound and not a public CP.

Its a really interesting resource showing demand, sites like Blanch SC is astounding usage

ps Hutton and Meade ( nissan garage) looks like another blank as does IKEA Belfast (Brexit so no X border )

H&M are not Nissan anymore. They are Hyundai. And the charger is disconnected. The 3rd party chargers from ecars is a legacy list which was not updated in at least 3 years. Lidl Drogheda is an example.

The one in Killarney is even badly located on the app sending people to a B&B. Fortunately Google Maps knows better.:)

Black_Knight

Copy pasta'd some css templating to make it less horrible looking.

http://test.ecars-stats.com/

Changes:
- The UI clearly
- Handled stations with no data for a specified plug.
- Backend work done to get unavailability of a site over the last 4 weeks, though unavailability over the last 1 week might be a bit more useful. I'll have a think on this.

Enjoy. Any feedback is always welcome.

innrain

If only businesses from around Stillorgan Hotel would capitalize on this data. This charger is in use at any hour of the day and any day of the week (almost). There are a lot of apartments in the area.
So above 50% is most likely in use and around 25% you got good chance of finding it free? Which is the highest number? I found Lucan Saturday morning @10:00 and evening @ 16:00 87.5% Can you do the color scale unique for all the chargers? That would help in comparing chargers. Right now you assign the darkest red to the peak value of the charger. What if instead you assign it for 100%. The best is to find the peak value of all chargers but that would require more code.

Black_Knight

innrain wrote: »

If only businesses from around Stillorgan Hotel would capitalize on this data. This charger is in use at any hour of the day and any day of the week (almost). There are a lot of apartments in the area.
So above 50% is most likely in use and around 25% you got good chance of finding it free? Which is the highest number? I found Lucan Saturday morning @10:00 and evening @ 16:00 87.5% Can you do the color scale unique for all the chargers? That would help in comparing chargers. Right now you assign the darkest red to the peak value of the charger. What if instead you assign it for 100%. The best is to find the peak value of all chargers but that would require more code.

It's on the long list. I've noticed that, had a very brief go at fixing it, but not got further. Tonight was spent enjoying a few beers with a friend (first time in a long time) so I'll try get to that soon.

Black_Knight

innrain wrote: »

Can you do the color scale unique for all the chargers? That would help in comparing chargers. Right now you assign the darkest red to the peak value of the charger. What if instead you assign it for 100%. The best is to find the peak value of all chargers but that would require more code.

Done.
- Darkest colour is now 100%, rather than busiest hour.
- Unit unavailability is now shown (for the last 7 days only).
- Found a "bug" though. The times are all UTC, so i'll have to think about fixing that properly, or hackily. :pac:

http://test.ecars-stats.com/

the_amazing_raisin

Do you have stats for the AC units hidden anywhere or is it just DC only? I'd like to see the usage of Plunkett train station in Waterford as I suspect only one plug is ever in use since one of the spaces is almost inaccessible (to my parking abilities at least)

Black_Knight

the_amazing_raisin wrote: »

Do you have stats for the AC units hidden anywhere or is it just DC only? I'd like to see the usage of Plunkett train station in Waterford as I suspect only one plug is ever in use since one of the spaces is almost inaccessible (to my parking abilities at least)

I'll open it up sure. Main reason I "hid" them was because the dropdown was massive, and not searchable. Obviously you'll have to select the untethered connector. Bad UX, but I can fix that in my own time.

Disclaimer - SCP are handled a little different. I'll have to double check my logic for them but my gut tells me they should be ok.

You should be able to search all chargers now.

You'll see some 12.5% occupancy on plunkett train station. That's basically of the last 4 weeks, on one of the Sundays, 1 socket was in use for the full hour. If both sockets were in use it should say 25%. If both sockets were in use every Sunday at those same hours it would say 100%. I'll double check the logic later to be sure.

Black_Knight

Getting close to something like going live.

Site is now on https://ecars-stats.com/ and i've reverted it back to just showing FAST chargers.

http://test.ecars-stats.com/ will be a bit more test like from now on. It has the slow chargers on it too, but I want to get a bit more confidence in the logic behind their data before I go releasing it.