Changes

Jump to navigation Jump to search
Line 113: Line 113:  
The spreadsheet is setup is such a way, that the environmental impact of logistics can be calculated for any territory or country in the world.
 
The spreadsheet is setup is such a way, that the environmental impact of logistics can be calculated for any territory or country in the world.
   −
==== Centroid sheet ====
+
==== Centroid worksheet ====
 
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.
   Line 119: Line 119:     
The worksheet contains the following rows and columns.
 
The worksheet contains the following rows and columns.
===== rows =====
+
'''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.
 
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.
 
All these rows should repeated on other spreadsheets both as rows and as columns.
   −
===== columns =====
+
'''columns'''
 
# area name: the name of the country or smaller area, such as a specific island;
 
# area name: the name of the country or smaller area, such as a specific island;
 
# centroid: the latitude and longitude of the (geographic) centroid;
 
# centroid: the latitude and longitude of the (geographic) centroid;
 
# centroid name: the geographic name that corresponds to the centroid, according to Open Street Map;
 
# centroid name: the geographic name that corresponds to the centroid, according to Open Street Map;
# sea port: the name of the main container sea port (as a link to the sea ports worksheet);
+
# sea port: the name of the main container sea port (as a link to the sea ports worksheet). The sea port does not have to lie inside the area (land-locked countries);
 
# sea covered: the sea covered by the port. An area can have multiple sea ports, one for each sea covered (Pacific/Atlantic for the UAS, Atlantic/Mediterranean for France, etc.);
 
# sea covered: the sea covered by the port. An area can have multiple sea ports, one for each sea covered (Pacific/Atlantic for the UAS, Atlantic/Mediterranean for France, etc.);
 
# distance: the distance (in km) between the sea port and the centroid of the area;
 
# distance: the distance (in km) between the sea port and the centroid of the area;
 
# OSM-link: the link to the directions on Open Street Map, from which the distance was taken.
 
# OSM-link: the link to the directions on Open Street Map, from which the distance was taken.
 +
 +
==== Container port worksheet ====
 +
For each of the area's on the ''Centroid-worksheet'' a row and a column is created in the ''Container port worksheet''. In addition two columns that document a port have been added: one column is a link the wikipedia-page of the port and one column is a link to the port authority of the port.
 +
 +
Each cell that links to ports shows the maritime distance between the two ports, as calculated by [https://www.searates.com/services/distances-time/ Searates].
 +
 +
==== Route matrix ====
    
==== Intra country logistics ====
 
==== Intra country logistics ====
Line 137: Line 144:     
A worksheet is reserved for the recording of the mean size and the environmental impact.
 
A worksheet is reserved for the recording of the mean size and the environmental impact.
  −
==== Container ports ====
  −
We can start out with [https://en.wikipedia.org/wiki/List_of_container_ports this list].
  −
  −
==== Route matrix ====
      
== Thoughts ==
 
== Thoughts ==
3,393

edits

Navigation menu