AS24 Site Locations – SQL / CSV Download.

A ZIP file containing the locations of most of the AS24 fuel sites in Europe (two or three sites have been removed because I could not find co-ordinates for them). This ZIP file contains the AS24 site locations in the following formats:

  • SQL (for databases such as MySQL).
  • CSV (CSV files will also open in Excel and can be used to convert the data into other formats such as JSON, etc).
  • XML

A sample PHPMyAdmin screenshot of the location data, which was gathered on the 6th of May, 2015:

AS24 Locations

As you can see, the file contains information about:

  • The address of the site (a general location).
  • The name of the country that the AS24 site is located in.
  • Coordinates: Latitude and longitude values (Map data for GPS, etc).
  • If the station sells AdBlue or not.
  • Whether it supports Tak&Drive (digital tachograph uploads).
  • FOD.
  • GNR.

Countries that are included:

  • Austria
  • Belgium
  • Bulgaria
  • Croatia
  • Czech Republic
  • Denmark
  • Germany
  • France
  • Georgia
  • Hungary
  • Ireland
  • Italy
  • Lithuania
  • Luxembourg
  • Macedonia, the former Yugoslav Republic of
  • Netherlands
  • Poland
  • Portugal
  • Romania
  • Russian Federation
  • Serbia
  • Slovakia
  • Slovenia
  • Spain
  • Sweden
  • United Kingdom
  • Ukraine

Example MySQL query – Selecting all AS24 sites in Ireland:

This query gives the following results:

Ireland AS24 Locations

As you can see, what you do with the data is up to you.

Comments

comments