Changes

Jump to navigation Jump to search
Line 169: Line 169:  
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.
 
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].
+
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] (black).
   −
There are many maritime routes that use the same sea passages, such as the Gibraltar straits. Instead of looking up all the routes in [https://www.searates.com/services/distances-time/ Searates], it is easier to look up the distances to a port on the strait and just copy the corresponding data. Only for the water basin behind the strait we need to do the lookup.
+
Ports that are not listed in Searates (or could not be found) have been taken from Shiptraffic. This requires conversion from nautical miles to kilometres (light green 1)
 +
 
 +
Some (landlocked) countries share ports. In that case the distances are linked, either between rows of the same port (light red 1) or between columns (orange).
 +
 
 +
There are many maritime routes that use the same sea passages, such as the Gibraltar straits. Instead of looking up all the routes in [https://www.searates.com/services/distances-time/ Searates], it is easier to look up the distances to a port on the strait and just copy the corresponding data. Only for the water basin behind the strait we need to do the lookup. The distances obtained via these strait ports have been coloured.
    
This can be done for:
 
This can be done for:
* Baltic sea / Copenhagen port
+
* Baltic sea <-> North Sea : Copenhagen port (cornflower blue)
* Black sea / Istanbul port
+
* Black sea <-> Mediterranean : Istanbul port (cyan)
* Adriatic sea / Tirana port
+
* Adriatic sea <-> Mediterranean / Durres port (cornflower blue)
* Mediterranean / Gibraltar and Damietta
+
* Mediterranean <-> Atlantic Ocean / Algeciras (Gibraltar) (cyan)
* Great Ocean / Panama
+
* Mediterranean <-> Red Sea / Damietta (purple)
 +
* Great Ocean <-> Atlantic Ocean / Panama (green)
 +
 
 +
For some ports there are some exceptions to the rules described above:
 +
* Faroer (Tórshavn) - is only supplied through Reykjavik and Helsingor (Denmark). The distances are calculated by the distance to Copenhagen plus 1870 km.
 +
* Svalbard (Longyearbyen) - is only supplied through Tromsø (Norway. The distances are calculated by the distance to Oslo + 1695 nautical miles.
    
==== Maritime Route matrix worksheet ====
 
==== Maritime Route matrix worksheet ====
Line 207: Line 216:     
The impact is normalised in order to calculate the score.
 
The impact is normalised in order to calculate the score.
 +
 +
==== Export matrix worksheet ====
 +
This worksheet shows the scores as used by OFF and are setup such that they can easily be imported. Instead of the country names the [https://en.wikipedia.org/wiki/ISO_3166-2 ISO 3166-2] codes are used. Rows and columns are alphabetically sorted on these codes. Each cell contains a formula to extract the data from the '''Score matrix worksheet'''.
 +
 +
Adding a new country can be done by:
 +
* inserting a column in the right (alphabetical) location;
 +
* linking the header of the new column to the corresponding row header;
 +
* copying a formula from an existing cell to all the rows of the new column;
    
==== Update Procedure ====
 
==== Update Procedure ====
Line 314: Line 331:  
The eco-score calculation is based on countries. As some countries are very big, any transport in such a country might be seen as greenwashing. Also it makes comparison between countries impossible.  
 
The eco-score calculation is based on countries. As some countries are very big, any transport in such a country might be seen as greenwashing. Also it makes comparison between countries impossible.  
   −
Instaead of using countries as smallest entity, one could use territories of a country as smallest entity. For France this would mean the Régions, for Germany the Länder, etc. If the purchase and production location fall within a single territory, the bonus score would be 100. Any transport between territories would imply a lower bonus score.
+
Instead of using countries as smallest entity, one could use territories of a country as smallest entity. For France this would mean the Régions, for Germany the Länder, etc. If the purchase and production location fall within a single territory, the bonus score would be 100. Any transport between territories would imply a lower bonus score. This might be offered as an option to a user, who wants to be more transportation conscious.
    
If both the purchase and production location are not known, we could fall back to the country based eco-score. If either the purchase or the production location is unknown, we can make the assumption that the it is in the most populous territory and calculate the eco-score based on this.
 
If both the purchase and production location are not known, we could fall back to the country based eco-score. If either the purchase or the production location is unknown, we can make the assumption that the it is in the most populous territory and calculate the eco-score based on this.
   −
Need an example to see what the effect would be. For instance purchasing a Camembert in Nice, etc.
+
This idea can be explored a bit further. The first step is that we need to know the territory of the user. Then we have the following three situations:
 +
# Producer in the same territory - this will result in a score of 100 and thus a maximum bonus;
 +
# Producer in another territory - the distance between the territory centroids determines the distance used in the score calculation;
 +
# Producer in another country - the centroid distance between the consumer territory and the centroid of the country is added to the standard calculation;
 +
 
 +
A sample calculation with the Olives Niçoises (producer in department Alpes-Maritimes, région PACA):
 +
* Standard:
 +
** consumer in France: score = 100 (0 km);
 +
** consumer in Germany: score = 62 (769 km);
 +
* Territory:
 +
** consumer in région PACA: score = 100 (0 km);
 +
** consumer in région Hauts de France: score = 52 (966 km);
 +
** consumer in department Somme: score = 45 (1110 km), using Alpes-Maritimes;
 +
** consumer in Germany: score = 25 (722+769 km)
 +
** consumer in Bavaria: score = 7 (722+769+366 km)
 +
 
 +
The effect of the location of the consumer can be well seen.
    
=== Distances ===
 
=== Distances ===
 
It also possible to look at the various [[transportation distances]] outside the context of the ecoscore.
 
It also possible to look at the various [[transportation distances]] outside the context of the ecoscore.
4,101

edits

Navigation menu