Description
Description in the slides.
Unformatted Attachment Preview
Examination -1
EV Station Demand
Planning
Feb 20, 2024
Think with Data First.
Opportunity Description
Will EV Charging Station replace Gas Stations?
Changing
the Way
We Work
President Biden officially signed the bipartisan
infrastructure bill, including a $5 billion investment in
state-administered grants for deploying electric
vehicle (EV) charging stations nationwide. These
funds will help states develop charging networks
across communities that include rural, disadvantaged,
and hard to reach areas, propelling the
administration’s decarbonization goals forward
through state-level transportation projects. Now that
the bill is officially law, the next step is putting plans
in place to mobilize these new federal investments so
they can have the greatest impact in communities
across the country.
– Forbes, Nov 24, 2021
2
EV Demand Planning – Users
The data for EV Planning can also be monetized by the state to attract private enterprises to invest into communities.
Changing
the Way
We Work
Paul – State DOT – Planner
Emily – Electric Grid Planner
Needs
My state is behind in EV purchases. I need to understand
what drives the demand.
Needs
Our electric demand is rapidly changing. I need to do
a better job forecasting electric demand and supply.
Queries:
1. Where is the EV concentration in the state? How
does it compare to other states?
2. What are the factors driving EV purchases?
3. Where are the EV Stations getting built? How does it
compare to other states?
4. What factors drive EV Station location choice?
5. How do I attract and allocate funds from
Infratructure bill?
6. How do I use it to drive economic value to rural and
disadvantaged communities?
Queries:
1. How is EV charging driving electric consumption
in the state?
2. How is the consumption changing across the grid
by time of day, day of week?
3. What is the impact of infrastructure bill on
electric consumption?
4. Can I run scenarios on grid electric demand to
understand home and commercial electric
consumption?
3
EV Demand Planning – Causal Model
A causal model can be used to bring diverse factors involved in EV Demand Planning. Using data, we can
refine the model or utilize the model for demand forecasting
Changing
the Way
We Work
• Citizen EV purchase is driven by
charging station availability at
their convenience
• Government funding can act as a
catalyst for private sector funding
• Charging EVs is a lot slower
process, consumers will seek a
good charging experience.
• EV stations within walking
distance of hangout locations are
critical to improving charging
experience outside the home.
Citizen
Mobility
Needs
EV
Ownership
Government
Funding
Number of
EV Stations
EV
Charging
Experience
Private
Sector
Funding
Hangout
during
charging
4
EV Demand Planning – Examination 1 Questions
Changing
the Way
We Work
You can choose your question from the list below or create your own question to support EV
demand planning for your state
For the state assigned to you (see state assignment on last page of this deck)
• Q1: Identify your user persona (Paul – State DOT – Planner or Emily – Electric Grid Planner or someone else)
• Q2: Identify types of query you will build to support your user persona
• Q3: How will you identify and describe your data sources
• Q4: How would you prepare your data and provide data for your chosen state
• Q5: How can you use map to drive some additional insight
• Bonus Question Q6: How would you use maps and other visualization tools to present your results?
Please note that
1) Submit your Examination-1 document through Brightspace – Examination -1 Assignment
2) Attached document contains Appendix I containing example answers for Questions 1 through 5 for Maine State
3) I can create a Discussion forum to answer any question associated with this Examination-1.
4) You can use Excel, R or SPSS or Dataiku to describe your data preparation process.
5) Final document can be Word or power-point or excel document answering questions listed above or your answers to
your own questions.
6) Please email me if you have any issues in accessing data sources listed in the powerpoint document
5
EV Demand Planning – Data Sources
Here are some of the data sources available
Changing
the Way
We Work
1. https://www.energy.gov/eere/slsc/maps/lead-tool provides useful data by state and county
on number of housings and energy consumption by household.
2. https://afdc.energy.gov/data_download provides data on current and planned EV charging
stations
3. https://hepgis.fhwa.dot.gov/fhwagis/ViewMap.aspx?map=Highway+Information|National+
Highway+System provides a map of highways across US. You can use this map to find all
highways passing through a geolocation.
4. https://anl.maps.arcgis.com/apps/webappviewer/index.html?id=33f3e1fc30bf47609992322
4a1c1b3ee provides current EV locations and gaps across highways
5. https://hepgis.fhwa.dot.gov/fhwagis/ViewMap.aspx?map=Demographic+Information|Popul
ation+2020 demographic information
6
State assignment for students
No
Changing
the Way
We Work
Name
1 Alsowaylim, Abdullah
User Name
aalsoway
State Assignment
Arizona
2
New Mexico
3
Iowa
4
Michigan
5
Connecticut
6
Alabama
7
Missouri
8
Illinois
9
Kansas
10
Massachusetts
11
Minnesota
12
Colorado
13
Nebraska
14
15
Indiana
Wisconsin
16
California
7
Changing
the Way
We Work
Appendix I:
Example Answers and
Data Preparation
Process for “Maine”
8
Q1: Identify your user persona
Changing
the Way
We Work
User Persona
State DOT – Planner
Objectives
My state is behind in EV purchases. I need to understand what drives the demand
and where should I be placing the EV station to meet the demand
9
Q2: Identify types of query you will build to support your
user person
Changing
the Way
We Work
User Persona
State DOT – Planner
Objectives
My state is behind in EV purchases. I need to understand what drives the demand and
where should I be placing the EV station to meet the demand
Types of Queries:
1. Where is the EV concentration in my state?
2. What are the factors driving EV purchases?
3. Where are the EV Stations getting built?
4. What factors drive EV Station location choice?
5. Where should I be building EV station to meet my demand?
10
Q3 – How will you identify and describe your data sources
Here is the analysis of available data sources and new data source (highlighted in yellow) as needed
Changing
the Way
We Work
No
Source
Type Of Data
Granularity
Comments
Data is available as CSV file. 3 CSV files can be
combined to provide following at county or state
level. Total count includes following at State level
(FIPS Code 23) and
•
Annual Average Energy Cost
•
Annual Energy Burden
•
Housing Count
provides useful data by state and
https://www.energy.gov/eere/slsc/
county on number of housings and
maps/lead-tool
energy consumption by household
All US States and major
county within state
2
https://afdc.energy.gov/data_downl
oad
This is most comprehensive table containing current
and planned EV stations at City Level. If we need to
US State, City and Zip Codes combine this data with Data source #1, we need to
link county data from source #1 to zip code or city
data in source #2
3
provides a map of highways across
https://hepgis.fhwa.dot.gov/fhwagis
US. You can use this map to find all
/ViewMap.aspx?map=Highway+Info
highways passing through a
rmation|National+Highway+System
geolocation.
1
provides data on current and
planned EV charging stations
4
https://anl.maps.arcgis.com/apps/
provides current EV locations and
webappviewer/index.html?id=33f3e
gaps across highways
1fc30bf476099923224a1c1b3ee
5
https://hepgis.fhwa.dot.gov/fhwagis
/ViewMap.aspx?map=Demographic Provides Demographic information
+Information|Population+2020
6
New Data source procured from
Internet (Google search)
State map with Zip code
State and county level
US State, City and Zip Codes
Solid line shows highways. Dotted line shows gaps
across highway.
If we can super-impose Zip code map on this
highway map, then we can find gaps on highway
with high population zip area where EV station can
be placed.
11
State map with Zip code coupled with Data
Source
#4 will help identify zip codes with large population
which are missing EV locations
Q4: How would you prepare your data
Changing
the Way
We Work
Prepare data from Data Source 1
Data source #1 included Energy consumption data from following site
https://www.energy.gov/eere/slsc/maps/lead-tool
I Download Energy consumption data by state for each of the following 3 factors and computed data for all 3 factors for “Maine”
•
•
•
Annual Average Energy Cost
Annual Energy Burden
Housing Count
12
Q4: How would you prepare your data (Cont.)
Changing
the Way
We Work
Prepare data from Data Source 2
Data source #2 provides data on current and planned EV charging stations
https://afdc.energy.gov/data_download
Downloaded data following these steps
13
Q4: How would you prepare your data (Cont.)
Changing
the Way
We Work
Prepare data from Data Source 2
Data source #2 provides data on current and planned EV charging stations
https://afdc.energy.gov/data_download
Downloaded data for the state of “Maine”
14
Q4: How would you prepare your data (Cont.)
Changing
the Way
We Work
Prepare data from Data Source 3
Data source #3 provides a map of highways across US. You can use this map to find all highways
passing through a geolocation.
https://hepgis.fhwa.dot.gov/fhwagis/ViewMap.aspx?map=Highway+Information|National+Highway+
System
Data Available for Download
15
Q4: How would you prepare your data (Cont.)
Changing
the Way
We Work
Prepare data from Data Source 4
Data source #4 provides current EV locations and gaps across highways
https://anl.maps.arcgis.com/apps/webappviewer/index.html?id=33f3e1fc30bf476099923224a1c1b3e
e
Map of Maine
16
– – – line shows gaps across highways
Q4: How would you prepare your data (Cont.)
Changing
the Way
We Work
Prepare data from Data Source 4
Data source #4 provides current EV locations and gaps across highways
https://anl.maps.arcgis.com/apps/webappviewer/index.html?id=33f3e1fc30bf476099923224a1c1b3e
e
Map of Maine
17
– – – line shows gaps across highways
Q4: How would you prepare your data (Cont.)
Changing
the Way
We Work
Prepare data from Data Source 5
Data source #5 provides demographic information
https://hepgis.fhwa.dot.gov/fhwagis/ViewMap.aspx?map=Demographic+Information|Population+20
20
I selected the state “Maine”
18
Q4: How would you prepare your data (Cont.)
Changing
the Way
We Work
Prepare data from Data Source 5
Data source #5 provides demographic information
https://hepgis.fhwa.dot.gov/fhwagis/ViewMap.aspx?map=Demographic+Information|Population+20
20
Downloaded the population data under “Data” option
19
Q4: How would you prepare your data (Cont.)
Changing
the Way
We Work
Here are all extracted data from different data sources,
These data can be combined using Dataiku, R or Excel to create Analytics Base Table
20
Q5: How can you use map to drive additional insights
Changing
the Way
We Work
Data Source #4 provides current EV locations and gaps across highways.
If we overlay this map with Zip code map, we can identify Zip codes with missing EV Station
and based upon Population density, we can prioritize Zip code for possible EV locations
Maine Map with gaps (dashed line) across Highway
Maine Map with Zip Codes
21
Purchase answer to see full
attachment