Get Bulk EV Charging Events

  • Example use cases.

    • Distribution system planning. A list of charging events including kW peak, time, and kWh help distribution system planners create better models and proactively upgrade or defer upgrades down to the secondary of distribution transformers, as required.

    • EV programs. Knowledge of EV charging loads help EV program groups target appropriate customers and design better rates for EV programs, optimizing marketing O&M, and participation in programs.

    • Data scientists. Forecasting loads and creating models of EV charging behavior may be performed by data scientists in utilities for distribution system planning and EV program impacts.

  • Data product ID. 8e08938a-160a-4dea-b0ff-a96a7933f5c6

  • Data latency. Three minutes or greater, depending on query parameters.

  • Data availability. Last 13 months.

All examples in this section are presented as cURL or CSV files.

Request

Copy 
POST /data-products/8e08938a-160a-4dea-b0ff-a96a7933f5c6 /subscriptions/{subscriptionId}/batch-request
{
    "FileType": "Csv",
    "Tokens":
    {
        "StartRecievedDatetime": "2023-1-1",
        "EndRecievedDatetime": "2023-1-31",
        "StartEventDate": "2023-1-1",
        "EndEventDate": "2023-1-31",
        "EntityType": "Transformer",
        "EntityId": "X1-01-A",
    }
}

Parameters

Name

Description

Operators

Required

Type

Format

Default

Range

Origination

StartEventDate

Start date being queried as Min(EventDate)

Greater than or equal to

No

Datetime

YYYY-MM-DDTHH:MM:SSZ

2020-01-01T00:00:00.0Z

(Current UTC Date) to (Current UTC Date - 13 months)

Edge app

EndEventDate

End date being queried as Max(EventDate)

Less than or equal to

No

Datetime

YYYY-MM-DDTHH:MM:SSZ

9999-12-31T00:00:00.0Z

(Current UTC Date) to (Current UTC Date - 13 months)

Edge app

StartReceivedDatetime

Min ReceivedTime data

Greater than or equal to

No

Datetime

YYYY-MM-DDTHH:MM:SSZ

2020-01-01T00:00:00.0Z

(Current UTC Date) to (Current UTC Date - 13 months)

App Platform

EndReceivedDatetime

Max ReceivedTime data

Less than or equal to

No

Datetime

YYYY-MM-DDTHH:MM:SSZ

9999-12-31T00:00:00.0Z

(Current UTC Date) to (Current UTC Date - 13 months)

App Platform

EntityType

Servicepoint, Meter, ESN, Transformer, premises, None

Equals

No

String

N/A

N/A

N/A

CIS

MDMS

GIS

EntityId

Dependent on EntityType

In list

No

String

N/A

N/A

N/A

CIS

MDMS

GIS

Response file

Example CSV:

Copy 
ServicePointId ,MeterId,MeterNumber,ElectronicSerialNumber,TransformerId,PremiseId,ChargeStartTime,ChargeEndTime,AvgLoad,AvgVoltage,AvgVoltageBeforeCharge,RecievedTime
9000372474,1000634831,1000634831,2.16.840.1.114416.15.80.1000634831,4929542183-90777887,,2023-09-13T00:29:55.55Z,2023-09-13T00:59:55.55Z,44.38334,112.59,120.32,2023-09-13T00:29:55.55Z
9000502815,1000838385,1000838385,2.16.840.1.114416.15.80.1000838385,--,,2023-09-13T00:29:55.55Z,2023-09-13T00:59:55.55Z,128.1167,112.67,120.03,2023-09-13T00:29:55.55Z
9000053282,1000092413,1000092413,2.16.840.1.114416.15.80.1000092413,2594744147-91918635,,2023-09-13T00:29:55.55Z,2023-09-13T00:59:55.55Z,148.7167,111.94,120.45,2023-09-13T00:29:55.55Z
9000585414,1000448760,1000448760,2.16.840.1.114416.15.80.1000448760,2662535221-10734063,,2023-09-13T00:29:55.55Z,2023-09-13T00:59:55.55Z,176.55,112.48,120.42,2023-09-13T00:29:55.55Z
9000594308,1000508737,1000508737,2.16.840.1.114416.15.80.1000508737,2949637457-92808645,,2023-09-13T00:29:55.55Z,2023-09-13T00:59:55.55Z,111.8667,112.05,120.06,2023-09-13T00:29:55.55Z
9000580263,1000071660,1000071660,2.16.840.1.114416.15.80.1000071660,2435841314-92195447,,2023-09-13T00:29:55.55Z,2023-09-13T00:59:55.55Z,221.2667,112.30,120.12,2023-09-13T00:29:55.55Z
9000372477,1000836297,1000836297,2.16.840.1.114416.15.80.1000836297,4495046038-10795431,,2023-09-13T00:29:55.55Z,2023-09-13T00:59:55.55Z,104.4,112.80,120.01,2023-09-13T00:29:55.55Z
9000007738,1000561269,1000561269,2.16.840.1.114416.15.80.1000561269,2604141857-10581404,,2023-09-13T00:29:55.55Z,2023-09-13T00:59:55.55Z,185.5167,112.31,120.16,2023-09-13T00:29:55.55Z
9000389087,1000326772,1000326772,2.16.840.1.114416.15.80.1000326772,2768938379-10477102,,2023-09-13T00:29:55.55Z,2023-09-13T00:59:55.55Z,152.65,112.05,120.31,2023-09-13T00:29:55.55Z
9000530026,1000062826,1000062826,2.16.840.1.114416.15.80.1000062826,2302540356-10169202,,2023-09-13T00:29:55.55Z,2023-09-13T00:59:55.55Z,196.4,112.66,120.31,2023-09-13T00:29:55.55Z
9000098919,1000567185,1000567185,2.16.840.1.114416.15.80.1000567185,3393042722-93886808,,2023-09-13T00:29:55.55Z,2023-09-13T00:59:55.55Z,167.1167,112.75,120.29,2023-09-13T00:29:55.55Z
9001805366,1000846429,1000846429,2.16.840.1.114416.15.80.1000846429,--,,2023-09-13T00:29:55.55Z,2023-09-13T00:59:55.55Z,34.23333,112.06,120.74,2023-09-13T00:29:55.55Z

Data values

Name

Description

Type

Units

Range

Format

Nullable

Origination

ServicePointId

Service Point ID as of EventDate

String

N/A

N/A

N/A

No

CIS

MDMS

GIS

MeterId

Meter ID as of EventDate

String

N/A

N/A

N/A

No

CIS

MDMS

GIS

MeterNumber

Meter Number as of EventDate

String

N/A

N/A

N/A

Yes

CIS

MDMS

GIS

ElectronicSerialNumber

Electronic Serial Number

String

N/A

N/A

N/A

No

CIS

MDMS

GIS

TransformerId

Transformer ID as of EventDate

String

N/A

N/A

N/A

Yes

CIS

MDMS

GIS

PremiseId

Premise ID as of EventDate

String

N/A

N/A

N/A

Yes

CIS

MDMS

GIS

ChargeStartTime

Start datetime of EV charging event

Datetime

N/A

N/A

YYYY-MM-DDTHH:MM:SSZ

No

Edge app

ChargeEndTime

End datetime of EV charging event

Datetime

N/A

N/A

YYYY-MM-DDTHH:MM:SSZ

No

Edge app

AvgLoad

kW of EV charging event

Real

kW

0 to 655.35

N.NN

No

Edge app

AvgVoltage

Average voltage during charge

Real

Volts

0 to 655.35

N.NN

No

Edge app

AvgVoltageBeforeCharge

Average voltage during the 15-minute time just before the charge began

Real

Volts

0 to 655.35

N.NN

No

Edge app

ReceivedTime

When the data was received by the App Platform

Datetime

N/A

N/A

YYYY-MM-DDTHH:MM:SSZ

No

App Platform