Changes

Jump to navigation Jump to search
Line 101: Line 101:  
The centroid sheet lists the centroid for each country in the world. With OSM the closest town has been identified. In order to be able to calculate distances by road through OpenStreetMap, we need identify the closest town to this centroid.
 
The centroid sheet lists the centroid for each country in the world. With OSM the closest town has been identified. In order to be able to calculate distances by road through OpenStreetMap, we need identify the closest town to this centroid.
   −
The centroids were taken from [http://worldmap.harvard.edu/data/geonode:country_centroids_az8 here].  
+
The centroids were taken from [http://worldmap.harvard.edu/data/geonode:country_centroids_az8 here]. The countries in this list have been used as a starting point.
    +
The worksheet contains the following rows and columns.
 +
===== rows =====
 +
The rows represent areas for the origin or destination using a specific port of entry into that area. An area can be a country or part of the country. A part of the country can be anything that makes sense and refines the logistics impact.
 +
 +
All these rows should repeated on other spreadsheets both as rows and as columns.
 +
 +
===== columns =====
 +
1 - area name + entry point :
 +
2 - centroid : the latitude and longitude of the (geographic centroid)
 
For logistics that includes a maritime part, we need to know the closest container port for each country. There might be multiple container ports required for each country (east/west coast US, Atlantic/Mediterranean France).  
 
For logistics that includes a maritime part, we need to know the closest container port for each country. There might be multiple container ports required for each country (east/west coast US, Atlantic/Mediterranean France).  
  
3,393

edits

Navigation menu