Insights Data Products

Definitions and methodologies

 

Welcome to the Zapmap Insights data products subscriber help page.

In here you'll find all of the field definitions and calculation methodologies to super-charge your value realisation, whether you're a Profile, Monitor, or Empower customer.

 

Locations

Reliability

Utilisation

Pricing (coming soon)

 

 

Locations

Background

Fieldname Description
Connector_UID OCPI unique identifier for a connector
EVSE_UID OCPI unique identifier for an EVSE
Zapmap_Device_UID Zapmap unique identifier for a physical device
Zapmap_Location_UID Zapmap unique identifier for a site of one or more physical devices
Network Charge Point Operator (CPO)
Zapmap_Location_Name  
ExtRef Reference provided by CPO to identify a connector or EVSE
Zapmap_ChargeDeviceRef Reference provided by CPO to identify a connector or EVSE by Zapmap
Zapmap_DateAdded The date the device was added to Zapmap
Latitude  
Longitude  
Thoroughfare  
PostTown  
Postal_code  
County  
Country_code  
London Borough  
Region  
Zapmap_LocationClass Zapmap classification by On-street, En-route, Destination for the physical device
Zapmap_PrimaryLocationCategory Zapmap classification of the location the physical device is situated
Zapmap_SecondaryLocationCategory Zapmap sub-classification of the location the physical device is situated (coming soon)
Zapmap_BrandLocationCategory Zapmap sub-classification of the location the physical device is situated (coming soon)
Contactless The physical device accepts contactless payment (1 = yes, 0 = no)
Zap_Pay The Network accepts Zap-Pay (1 = yes, 0 = no)
Taxi Only The charge point is restricted to taxi only use (1 = yes, 0 = no)
Connector_type Connector type
Power_type AC or DC
Max_Power The maximium advertised power for the connector

 

 

 

Reliability

Background

The Zapmap consumer app uses 4 statuses: Available, Charging, Unavailable, and Unknown, which are derived from the statuses (both OCPI - many versions - and bespoke) returned by c.70% of the UK's charge point network.

The data was - and continues to be - collected for the purpose of informing the consumer base whether a device is available to connect to, or not.  It was not collected for reliability purposes, therefore assumptions have been made.

The status data is held at a physical device level, rather than EVSE.  This will have the effect of recording Available if a single device has more than one  EVSE, and at least one is online and able to be used.

The status data held covers every minute from the moment the "dynamic" (Zapmap speak for "live") charge point is added to the database.

 

For the purposes of this Reliability analysis, these Zapmap statuses have been mapped to:

Zapmap status PCPR status
Available or Charging In service
Unavailable OOS
Unknown Exempt

The PCPR Reliability requirements only apply to Rapid and Ultra-rapid EVSE. 

Pre-2024, Zapmap has not - in its line of business - recognised EVSE as a measurable unit base, instead preferring the consumer-friendly physical device.

The power rating of a physical device is attributed using the maximum power of the highest rated connector across all - where applicable - internal EVSE.

A device with a 22kWh and a 150kWh connector is allocated Ultra-rapid, as 150 > 22.

 

Definitions & Methodology

Each 24 hours, is been split into 288 individual 5-minute blocks.  The status recorded for each individual device during each 5-minute block is collected and aggregated.              

At the end of 2023, this is approximately 10 million rows of status data per day, or 1 billion rows per quarter.              

               

In this situation, and for the purpose of Reliability reporting, a PCPR status is derived using the following hierarchy:

Any “In Service” Zapmap statuses during the 5-minute block, the 5-minute block shall be mapped to “In service”.
Else, if there are any “Time Exempt” statuses during the 5-minute block, the 5-minute block shall be mapped to “Time exempt”.
Else, if there are any “Out of Service” statuses during the 5-minute block, the 5-minute block shall be mapped to “OOS”.
Else, "Other".

The device-level statistics are aggregated up to give a total in minutes, for "In service", "OOS", "Time Exempt", and "Other".

"Other" is a QA check.  A zero count for "Other" ensures all 5-minute blocks are accounted for, enabling a simplified Reliability calculation to be completed:

i.e. In service + OOS + Time Exempt + Other = All possible minutes

If Other = zero, then all possible minutes are accounted for within the remaining 3 statuses.

 

Reliability therefore becomes:

Reliability calculation

The above calculation is applied to the aggregated data.

 

Utilisation 

Location Types

  Definition
Hotel / Accommodation Any business or airbnb taking paying guests overnight. If the location is a pub with overnight rooms use "Attraction".
Retail car park A car park specifically for (next to, above or below) shop/s and or a / restaurant / cafe, this will include retail parks where shoppers will park.
Public car park A car park not on the same site as shops and / or a pub / restaurant / cafe. Will often be council run car parks or run by a parking company such as NCP. If car park is at a council office use "Public estate".
Park and Ride self explanatory
NHS Property A hospital or doctors surgery or any other location related to providing a health service
Dealership forecourt car dealership or a car garage
Educational establishment A university, school or college
Attraction a tourist venue (eg National Trust), pub, restaurant, garden centre or landmark
Leisure centre self explanatory, can also be a gym or health centre
Workplace car park In the majority of cases if network = Zap Work then this location type should be used (but can also be hotel / accommodation, attraction or other). Often in business or industrial parks located next to warehouses or offices. Do not use this for council buildings (they're public estate). Charger will be owned by the business (not a network).
Sports ground A football club, golf club, athletics stadium, tennis club, shooting ground or any other venue where sport is played
On-street devices that are on a pavement and where user has to park on the road. Lots of these will be Ubitricity points in London for example. Will often have a specific name with a number at the start.
Other multi purpose buildings where it's not clear what the main purpose is. Any location that doesn't fit into the other categories.
Service station fuel forecourt or motorway services, will normally be on a A road or next to a motorway. Tends to be rapid devices.
Public estate car park at a council building, mainly used for staff, a village hall or a library. Any other government run / publicly funded property including community centres
Airport self explanatory, can also be a heliport
Railway Station self explanatory, can also be a tram station
Bus Station self explanatory
Ferry Terminal self explanatory