Straight-line vs road distance for 119 city pairs
=================================================

Great-circle distance, fastest-route road distance and driving time for 119 city pairs in Europe, Iran, Russia, Japan, Turkey and Indonesia, and the detour index (road km divided by straight-line km).

Article: https://mapatlas.eu/blog/distance-as-the-crow-flies
Data date: 2026-09-29
Rows: 119 (one per city pair)

Files
-----
distance-as-the-crow-flies-2026-09-29.csv  (UTF-8, comma separated, header row, empty cell = no value)
distance-as-the-crow-flies-2026-09-29.geojson  (one straight two-point LineString per pair (from and to point); properties repeat the key CSV columns)

Columns
-------
region_code               DE, FR, IT, EU (rest of Europe, incl. cross-border), IR, RU, JP, TR, ID
region                    Region group used in the article
from_city                 Origin city (English name)
to_city                   Destination city
from_lat                  Origin point, WGS 84 latitude (city centre chosen by us)
from_lon                  Origin point longitude
to_lat                    Destination point latitude
to_lon                    Destination point longitude
great_circle_km           Haversine distance on a sphere of radius 6,371 km
road_km                   Length of the fastest car route, MapAtlas Directions API, default options
drive_time_min            Free-flow driving time of that route, minutes, no live traffic
detour_index              road_km / great_circle_km
route_has_ferry           true if the route uses a ferry or car shuttle
route_has_toll            true if the route uses a toll road
excluded_from_statistics  true for the 3 ferry routes left out of the medians in the article
data_date                 Date the routes were requested

Sources
-------
- MapAtlas Directions API (https://mapatlas.eu), routing on OpenStreetMap road data

Licence
-------
- MapAtlas, CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Road distances and times are computed on OpenStreetMap road data, © OpenStreetMap contributors (https://www.openstreetmap.org/copyright).

How to cite
-----------
MapAtlas (2026). Straight-line vs road distance for 119 city pairs. https://mapatlas.eu/blog/distance-as-the-crow-flies (data date 2026-09-29).

Built by scripts/data/build-blog-datasets.mjs from the research file(s) listed in the article.