4.2.2. Data Processing
First, the datasets of the 16 criteria were examined in the form of GIS layers. Data cleaning was then performed to remove incomplete, duplicate, or irrelevant data from supply and demand dimensions. To protect confidential information, only the processed data are presented. Next, a base layer is created where the study area is divided into a 100 × 100 m hexagon-grid (vertical and horizontal spacing). This transformation was conducted to enable the evaluation of the potential of EV charging infrastructure in each cell within the total area of Bottrop as illustrated in
Figure 6. The size of the hexagon cell was determined on the account of providing a meaningful and conclusive location evaluation while maintaining its applicability for the different dataset resolutions. After that, the data values of each criterion were projected to the corresponding cells either by their sum or average, depending on the layer type (which are described in the section below).
The geo-analysis for supply criteria is conducted by either the intersection of these criteria, or their exclusion.
Starting from the three criteria related to infrastructure availability, a buffering and intersection analysis was applied. First, the road network comes naturally as a fundamental requirement for electric vehicles to access and to park on the sideways for recharging. Since the dataset is formed of polylines, a 50 m buffer width was applied to ensure a full coverage of the road and the sideways. Second are the existing electricity grid connection points provided by the municipality to ensure that the locations of the charging stations do not require a major expansion of the grid network which entails excessive investments. A conservative and reasonable buffer radius of 15 m was set to minimize cable extension work and cost compared to 50 m from a study by Gkatzoflias et al. [
17]. The capacity and type of the existing connection points were not provided for this study and might require a separate case-by-case evaluation from the distribution system operator (DSO) if it needs to be upgraded. Such data can have a critical impact on location selection where high investments on the grid are needed. Therefore, this falls outside the scope of this study. As a preferable recommendation by the municipality, the third criterion is the proximity from streetlight poles. The rationale behind it was to offer more visibility for the driver to spot the charging station while driving and later to use it. Accordingly, the location points provided were buffered with a radius of 10 m to resemble the lighting coverage of a streetlight post. The final spatial analysis step for the supply criteria, ensures that they coincide by performing a geometric intersection across the three layers. The resulting layer is a representation of all the areas where infrastructure is available.
Regarding the spatial constraints, protected areas such as historic sites and environmental zones were excluded from the infrastructure availability layer produced above. The second constraint is related to the preservation of trees located in public areas. The point layer provided includes the possible crown radii of trees which were used as buffer radii for exclusion, assuming they are equal to the root crowns to avoid damaging the roots when constructing a charging station. The third constraint is the existing charging infrastructure which might lead to oversupplied service areas as the city currently hosts 31 public and semi-public charging stations. In consultation with IKEM, it was assumed that a normal-charging station has a service area that lies within a 300 m radius, whereas a fast-charging station’s service radius was assumed at 400 m as an educated guess. Accordingly, buffer zones were created and excluded. Finally, the remaining areas represents the final areas of infrastructure availability and were projected to the grid base layer. Wherever those areas exist in a cell, a value of one is attributed to it, otherwise a zero values is applied.
Figure 7 shows the finalized layer for infrastructure availability.
The geo-analysis for demand criteria is conducted by sum or average depending on each criterion type and resolution. Layers were transformed into grid-layers by projecting their data to the corresponding overlaying cells. The following represents a description of each criterion and how it was projected to a separate base grid layer:
Households: The number of households offers an improved overview of the population density since it is not limited by age groups. The attractiveness and potential of a charging station’s location is greater where the household density is higher. In this study, the municipality provided the most recent household distribution on a statistical district level.
Type of buildings: The type of building can indicate the likelihood of home charging or public charging. Houses of single-family detached type often have a parking garage or space, hence a higher prospect to install private chargers. On the other end, apartment buildings tend to rely more on roadside and public parking lots, hence a higher prospect for public charging. The available data provided by the municipality from the land registry data provide the average number of floors on building block level. Although a better representation could be obtained if municipalities could collect data on housing types, a correlation between number of floors and type of buildings was adopted. Hence, the evaluation was based on the number of floors instead. The higher the average number of floors is in a given building block, the more attractive it is for the location of a public charging station.
Buildings: The number of residential buildings was considered an indication of the level of utilization and the local coverage of a charging station. The more buildings there are, the more the charging station be utilized, and the better it can serve the charging demand. The residential building data were extracted on a single-building level from OpenStreetMap which enabled a higher resolution analysis.
New residential developments: In line with the development plan of charging infrastructure in 2030, the new residential developments in the city were considered. The current development projects for residential units are represented by the number of buildings and units in the construction phase at a building resolution. It relies on the data provided by the municipality from the residential real estate developers. The number of units was selected to evaluate the volume of new developments which is positively correlated to the potential locations of charging stations.
Long-term unemployment: A survey conducted on EV adopters in Germany revealed that EV users have significantly higher incomes than drivers of conventional cars, adding that 70% of respondents were in full-time employment [
41]. It was concluded that the economic condition has a positive and strong correlation to car ownership and in particular EV adoption. Consistently, the Mobility in Germany (MiD) survey in 2017 stated that lower incomes and lower employment rates play a role in car ownership in Germany. In addition, it was found that nearly half of the mileage of passenger cars is made in the course of commuting to work or business activities [
36]. It is worth noting that this criterion counters the equitable deployment of public chargers and widens the access gap in favor of privileged communities. Its implications should be carefully understood by decision-makers while rating it. This criterion, provided by the municipality, has a close and negative correlation to EV adoption and, consequently, to charging stations’ potential locations.
Vehicle registrations: The number of cars registered in each statistical district provided by the municipality helps determine the city’s passenger vehicles distribution. This can lead to a better allocation of charging stations by factoring in multiple passenger car ownership of households and companies. In addition, since private vehicles in most cases are underutilized assets, this criterion marks the areas where the corresponding vehicles will be parked for most of their time. Therefore, a positive correlation can be drawn from the number of vehicles registered and the potential location of charging stations.
Companies: The number of companies can provide a valuable indication for two main use cases. The first use case is for the company’s customers, while the second is for their employees who might use nearby street or public parking for opportunity charging.
Traffic: Besides characterizing traffic flows and volume for maximizing road network efficiency, traffic analysis offers a valuable insight on the attractiveness of the charging station location model. Roads with high traffic volume inherently generate higher demand on charging. In addition, charging stations located on these roads have increased visibility, which in turn drives more positive EV perception. The hourly peak volume of motor vehicle traffic in relevant roads was analyzed and classified according to an ordinance called RASt-06 (Richtlinie für die Anlage von Stadtstraßen) published by the Research Association for Roads and Traffic in Cologne [
42]. The classification resulted in five levels of traffic flows ranging from low to high.
Parking lots: Public charging takes place mainly in street parking or parking lots. While the first is accounted for in the supply criteria as a fundamental requirement, the latter emerges as an attractive factor for locating a charging station. Since the development of charging infrastructure is on a municipal level, only public parking lots were considered, excluding the possibility of semi-public charging infrastructure.
POI: Unlike traditional gas refueling, EV users will recharge their vehicles in areas where they spend time while their vehicles are parked. Hence, points of interest are naturally a prominent part of the planning of public charging network. Activities related to private errands, recreation, or shopping are plausible opportunities for EV users to recharge their vehicles publicly [
9].
Table 3 shows the compiled list of POIs that were considered in this analysis, which were extracted from OpenStreetsMap data.
After projecting all the demand criteria and generating the corresponding base grid layers, a scoring scheme was applied to normalize the different dataset ranges. This step aims to bring all criteria into proportion by transforming their values into a specific range. To reflect the suitability of each cell, all demand criteria values were transformed to a five-point scoring system. Five mutually exclusive classes were constructed specifically for each criterion based on its frequency distribution, transforming all ranges from zero to five. An exception was made for parking lots and POIs’ base grid layers since only their availability was considered in the analysis due to the absence of valuable data to rate them. Therefore, two mutually exclusive classes were constructed on the same range. While the availability of the criterion is rated at ‘5’, the absence of it is ‘0’. After this step, every base grid layer has the same score range from ‘0’ to ‘5’ in each cell, positively correlated to the attractiveness of the location for a public charging station. A detailed overview on the scoring of each criterion is provided in the
Supplementary Material.