This OpenRefine Templating export format template will generate a geojson file containing a lists of points and connections between them.
Requires:
- the name of the column containing the from marker description (from in the example);
- the name of the column containing the to marker description (to in the example);
- a column containing numerical latitude co-ordinate value for the from location (from_lat in the example);
- a column containing numerical longitude co-ordinate value for the from location (from_lon in the example);
- a column containing numerical latitude co-ordinate value for the to location (to_lat in the example);
- a column containing numerical longitude co-ordinate value for the to location (to_lon in the example).
Lines are created between from/to locations specified on the same line.
Example data:
from,to,from_lon,from_lat,to_lon,to_lat
"London, UK","Cambridge, UK",-0.1276597, 51.5072759, 0.124862, 52.2033051
"Cambridge, UK", "Paris, France", 0.124862, 52.2033051, 2.3521334, 48.8565056
Note that a marker is added each time a place name is encountered.
Show...