search

NREL / developer.nrel.gov

An issue tracker for NREL's APIs available at https://developer.nrel.gov
43 stars 39 forks source link

standardize identifier for vehicle IDs #338

Open MatthewSteen opened 7 months ago

MatthewSteen commented 7 months ago

Suggestion

It would be helpful to use a standardized identifier, such as ISO 3779 Vehicle Identification Number (VIN), for the ID of each record in the database (vehicle make, model, trim, etc.) so that users can easily combine data across APIs.

This would obviously require coordination across maintainers/organizations (e.g. NREL and ORNL), but I think it would make these datasets/tools more useful.

Problem

I'd like to calculate metrics such as purchase price per mile of range ($/mi) for all 2023 EVs by using the Alternative Fuel Vehicles API to get all vehicles for a model year, and the FuelEconomy.Gov Tax Incentive API to get the available tax incentives for those vehicles. Currently (unless I'm missing something), I would have to write a script to somehow match the models across datasets or manually enter these in a spreadsheet for analysis.

Example

The Ford F-150 Lightning with Extended Range battery model is identified differently depending on the API.

API Vehicle Model
NREL Alternative Fuel Vehicles F150 Lightning 4WD Plat/Ext. Range
ORNL Fuel Economy Incentive F-150 Lightning (Extended Range Battery)

NREL Alternative Fuel Vehicles

<?xml version="1.0" encoding="UTF-8"?>
  <response>
    <metadata>
      <version>0.1.0</version>
    </metadata>
    <inputs>
      <id>13317</id>
    </inputs>
    <status type="integer">200</status>
    <result>
      <id type="integer">13317</id>
      <fuel-id type="integer">41</fuel-id>
      <phev-type nil="true"/>
      <light-duty-fuel-configuration-id type="integer">1</light-duty-fuel-configuration-id>
      <light-duty-manufacturer-id type="integer">219</light-duty-manufacturer-id>
      <light-duty-category-id type="integer">25</light-duty-category-id>
      <model>F150 Lightning 4WD Plat/Ext. Range</model>

ORNL Fuel Economy Incentive

<taxCreditVehicleCMBC>
  <atvType>EV</atvType>
  <baseModel>F-150 Lightning</baseModel>
  <createdOn>2023-06-01T00:00:00-04:00</createdOn>
  <irsMake>Ford</irsMake>
  <irsModel>F-150 Lightning (Extended Range Battery)</irsModel>

Solution(s)

Possible solution(s) could be...

  1. Use VIN data from manufacturers. https://vpic.nhtsa.dot.gov/decoder/
  2. Use UUIDs.