United States AFDC Manual Sync Project

Introduction

The Alternative Fuel Data Center provided by the United States Department of Energy provides data on new and existing alternative fuel stations and points in the United States and Canada. For this project, each week, GA_Kevin is planning to export the AFDC database, filter by previous week, then make the data suitable for OSM syntax. This project only covers EV Fast Charging sites that are public access in the USA. After the file is cleaned and syntax is set, load into JOSM, using the conflation tool to check if any stations already exist in the OSM database, then merge tags where appropriate or add nodes where needed. Since this is a US-spanning changeset, each changeset will be tagged with this URL for reference.

AFDC -> OSM Syntax

Fields in AFDC and OSM

AFDC	OSM
Street Address (house number)	addr:housenumber=*
Street Address (street name)	addr:street=*
City	addr:city=*
State	addr:state=*
ZIP code	addr:postcode=*
Country	addr:country=*
Station Phone	network:phone=*
Access Days Time	opening_hours=*
EV Network	network=*
EV Network Web	network:website=*
Open Date	start_date=*
Date Last Confirmed	check_date=*
Station ID	ref:afdc=*
EV CCS Connector Count	socket:type1_combo=*
EV CCS Power Output (kW)	socket:output=*
EV CHAdeMO Connector Count	socket:chademo=*
EV CHAdeMO Power Output (kW)	socket:chademo:output=*
EV J3400 Connector Count	socket:nacs=*
EV J3400 Power Output (kW)	socket:output=*

Overpass query for newly touched charging stations to conflate

[out:json][timeout:100];
area["name"="United States"]["admin_level"="2"]->.usa;
(
	nwr["amenity"="charging_station"](area.usa)(newer:"YYYY-MM-DDT00:00:00Z");
	nwr["man_made"="charge_point"](area.usa)(newer:"YYYY-MM-DDT00:00:00Z");
);
(._;>;);
out meta;

Weekly File Repository

You can subscribe to the RSS feed

Week	CSV File	GeoJSON File	Changeset	State of Charge
May 18-24, 2025	Codeberg	Codeberg	OSM
May 25-31, 2025	Codeberg	Codeberg	OSM	Discourse
June 1-7, 2025	Codeberg	Codeberg	OSM	Discourse
June 8-14, 2025	Codeberg	Codeberg	OSM	Discourse
June 15-21, 2025			OSM	Discourse
June 22-28, 2025	GitHub	GitHub	OSM	Discourse