North American DCFC Weekly Update – #30

/ September 20, 2024

From The Network Architect Channel.

*Weekly updates on the following DCFC networks:*
Blink
Red-E
7-11 7Charge
Circle K
Mercedes-Benz Charging Hub
Pilot Flying J
Tesla Supercharger
Electrify America
ChargePoint
EV Connect
EVgo
Rivian Adventure Network

*Database Setup Vid:* https://youtu.be/OG-mfVuGcaU

*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;

Related posts