North American DCFC Weekly Update - #21
HTML-код
- Опубликовано: 23 авг 2024
- Weekly updates on the following DCFC networks:
Walmart
RaceTrac
7-11 7Charge
Circle K
Mercedes-Benz Charging Hub
Pilot Flying J
Tesla Supercharger
Electrify America
ChargePoint
EV Connect
EVgo
Rivian Adventure Network
Francis Energy
Database Setup Vid: • National EV Database M...
SQL used in this video:
select Station_Name, City, State, EV_Network, EV_DC_Fast_Count as '# of Stalls', Open_Date from NewData where (City like 'Cross%' or City like 'Springdal%') and (State like 'TX' or State like 'AR');
select Station_Name, City, State, EV_Network, EV_DC_Fast_Count as '# of Stalls', Open_Date from NewData where Station_Name like 'RaceTrac%' and isnumber(EV_DC_Fast_Count) = 1 order by Open_Date;
select Station_Name, City, State, EV_Network, EV_DC_Fast_Count as '# of Stalls', Open_Date, id from NewData where EV_Network like '7%' and isnumber(EV_DC_Fast_Count) = 1 order by id;
select Station_Name, City, State, EV_Network, EV_DC_Fast_Count as '# of Stalls', Open_Date, id from NewData where EV_Network like 'Circle%' and isnumber(EV_DC_Fast_Count) = 1 order by id;
select substring(Station_Name, 1, length(Station_Name)-4) as Station_Name, City, State, EV_Network, sum(EV_DC_Fast_Count) as '# of Stalls', Open_Date from NewData where (Station_Name like 'Bucees%' or Station_Name like 'MB-USA HQ%') and isnumber(EV_DC_Fast_Count) = 1 group by City order by Open_Date;
select Station_Name, City, State, EV_Network, EV_DC_Fast_Count as '# of Stalls', Open_Date from NewData where (isnumber(Station_Name) = 1 or Station_Name like 'Pilot%' or Station_Name like 'Flying%') and EV_Network like 'eVgo%';
select NewData.Station_Name, NewData.City, NewData.State, NewData.EV_Network, NewData.EV_DC_Fast_Count as '# of Stalls', NewData.Open_Date from NewData left join OldData on OldData.Station_Name = NewData.Station_Name where OldData.Station_Name is null and NewData.Station_Name like '%esla Su%' order by NewData.id;
select count(id) from NewData where Station_Name like '%esla Su%';
select NewData.Station_Name, NewData.City, NewData.State, NewData.EV_Network, NewData.EV_DC_Fast_Count as '# of Stalls', NewData.Open_Date, NewData.id from NewData left join OldData on OldData.Station_Name = NewData.Station_Name where OldData.Station_Name is null and NewData.EV_Network like 'Electrify A%' and isnumber(NewData.EV_DC_Fast_Count) = 1 order by NewData.id;
select count(id) from NewData where EV_Network like '%lectrify A%';
select NewData.Station_Name, NewData.City, NewData.State, NewData.EV_Network, NewData.EV_DC_Fast_Count as '# of Stalls', NewData.Open_Date, NewData.id from NewData left join OldData on OldData.Station_Name = NewData.Station_Name where OldData.Station_Name is null and NewData.EV_Network like 'ChargePoi%' and isnumber(NewData.EV_DC_Fast_Count) = 1 and not (NewData.Station_Name like 'Bucees%' or NewData.Station_Name like 'MB-USA HQ%') order by NewData.id;
select count(id) from NewData where EV_Network like 'ChargePoi%' and isnumber(NewData.EV_DC_Fast_Count) = 1;
select NewData.Station_Name, NewData.City, NewData.State, NewData.EV_Network, NewData.EV_DC_Fast_Count as '# of Stalls', NewData.Open_Date, NewData.id from NewData left join OldData on OldData.Station_Name = NewData.Station_Name where OldData.Station_Name is null and NewData.EV_Network like 'eVgo%' and not (isnumber(NewData.Station_Name) = 1 or NewData.Station_Name like 'Pilot%' or NewData.Station_Name like 'Flying%') order by NewData.id;
select count(id) from NewData where EV_Network like 'eVgo%';
select substring(NewData.Station_Name, 1, length(NewData.Station_Name)-15) as Station_Name, NewData.City, NewData.State, NewData.EV_Network, sum(NewData.EV_DC_Fast_Count) as '# of Stalls', NewData.Open_Date, NewData.id from NewData left join OldData on OldData.Station_Name = NewData.Station_Name where OldData.Station_Name is null and NewData.EV_Network like 'RIVIAN_A%' group by NewData.City, NewData.State order by NewData.id;
select count(id) from NewData where EV_Network like 'RIVIAN_A%';
Thanks Walter. Looking forward to the next Pilot/Flying J update. PlugShare now has a photo of the Sulphur Springs Tx Pilot Center, it’s getting close.
I will check it out. Thx!
Thanks for these updates! I just got back from a 500 mile x 2 drive and noticed an appreciable improvement in the 2024 charging infrastructure vs the 2023 clown show. Between PFJ and Circle K having new stations, V3+ Superchargers now open to Rivian and Ford, plus improved EA reliability the whole experience is miles ahead of where we were last year.
Good 2 hear
Morning. For your EVgo update, Mechanicsville is a northeast suburb of Richmond, VA. The I-295 loop around Richmond runs through there. Thank you for your updates!
Thanks for the info!
On my way back from my big road trip to Virginia last week I almost went to the PFJ site in Checotah but was really tired so I went the shorter path home. I noticed you found some images of it under construction this week and now see I should have visited it. Hopefully both it and the Roland site are quick builds.
I’m now watching my local Tulsa FJ much more closely for activity since they are clearly very active in Oklahoma right now.
Two in OK open. Two more known to be under construction. Becoming a big state for builds
I’ll post the Texarkana Pilot tomorrow
@@pyharpinthank you
Mechanicsville, VA is the north-eastern suburbs of Richmond off 295 bypass interstate. This one is at a shopping center off 295, but locals know you have to take the Tappahannock exit, not Mechanicsville to get there. Fun fact, the Kohls it’s listed at used to be the old non-supercenter Walmart back when I was in grade school.
A company called Blink has mostly L2 chargers but a few DCFC, I noticed a few in Delaware.
The Flying J location in Beaverdam Ohio has screens on but showing out of service. Should be up any day now.
Exciting!
I find it so frustrating that so little is being done in the northern states this summer. I live in the Minneapolis metro and go back to ND on occasion. It would be nice if there were some construction going on since the ability to work outside up here is fleeting!
I agree. Now is the time to get while getting is good up there. Not sure Y
4:10 It looks like Mechanicsville is a suburb of Richmond. I've heard a lot of East Coast folk saying that Richmond needs more EV charging support, so maybe this will help.
It’s needed. Especially away from I-95 along the 295/288 ring roads. Interestingly enough, even for Tesla, there’s only one supercharger directly off I-64 between Waynesboro and Newport News.
@@ALRinaldi That's good, then. Walter is doing a great job tracking the Pilot-Flying J build out, but unfortunately, I don't know that there's been effective tracking of the GM-Energy Metro build out, which is supposed to be 3,250 chargers in 50+ metro regions. If Richmond is one of those regions, it should be getting 10 to 15 total 350 kW EVgo sites. It's just a matter of how long that will take, and how far we are into that build out.
plus on the I-95 route, so good to add all that can be added there for passers by.
Thanks, Walter! 2:20 So that site has finally gone live! Do we know whether the Circle K chargers are also open?
We do. CirK was live before TesSC.
5:10 That's great news for Vegas. The Superchargers and public DC in Vegas are regularly slammed. It's primarily EA at this point, with only a couple EVgo locations. Another 8-stall public charger will go a long way.
I just got to the Vegas one. Unfortunately it’s the normal 4-stall two-plug like most of the Electrify Americas. Not an obvious area for a queue, like everything else.
@@BumpCty Odd. That seems like a strange configuration. I wonder if there was some sort of disconnect with the site designer. I believe each of those units is capable of power splitting, which is different than the typical EA location with two plugs per dispenser.
Hey Eric, I'm hoping to hear soon that you'll be in Weed to check out the charging situation up there
@@anthonyc8499 Yeah, I need to take another drive that direction, but I was really hoping for some of those sites to go live before I do. Right now, there are at least half a dozen sites that should have been opened in the last month or two, and not a single one has been powered up yet. Basically, I might just be driving around looking at installed units with no power.
@@newscoulomb3705 did you see that ElectricEra invited you to tour their PowerNode station?
New to the channel - what database is that you are querying?
Walkthrough vid in description. NREL AFDC
The Pilot station in Grand Ledge is shown as active on EVGO website, but has been taken completely off the PlugShare website. This is confusing since EVGO owns PlugShare.
My PS still has it. Maybe u have a filter in place?
@@thenetworkarchitectchannelThanks. I did have a filter blocking the site.
will you be noting tesla real v4(1000v) chargers?
No not in these updates. The database does not contain that level of granularity
Thank you sir. Unfortunately I know of a lot of them out of service here in Houston! 🥲. That is definitely a downside of EVs.
4 sure. Nothing worse than posting up to a station needed to charge & it's off😔