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).
 +
 
 +
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:
 +
* Baltic sea <-> North Sea : Copenhagen port (cornflower blue)
 +
* Black sea <-> Mediterranean : Istanbul port (cyan)
 +
* Adriatic sea <-> Mediterranean / Durres port (cornflower blue)
 +
* Mediterranean <-> Atlantic Ocean / Algeciras (Gibraltar) (cyan)
 +
* 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 198: 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 273: Line 299:  
=== Olives niçoises ===
 
=== Olives niçoises ===
 
The ''olives niçoises'' is a small black olive variety that comes from the region around Nice (or so they say). They are my preferred ones. What is the transport bonus for these olives. Well if you liven in France there a bonus score of 100, wherever you live in France, even if you live 1200 km away. However if you live 10km away in Monaco, the score is 62. The reason for this difference is the fact that the size of the respective countries are not taken into account. A [[Country correction]] is needed.
 
The ''olives niçoises'' is a small black olive variety that comes from the region around Nice (or so they say). They are my preferred ones. What is the transport bonus for these olives. Well if you liven in France there a bonus score of 100, wherever you live in France, even if you live 1200 km away. However if you live 10km away in Monaco, the score is 62. The reason for this difference is the fact that the size of the respective countries are not taken into account. A [[Country correction]] is needed.
 +
 +
=== Impossible maritime routes ===
 +
The maritime distances have been calculated with Searates. This site also shows any available shipping companies or the corresponding route. For many of the distances there is no available shipper. Probably one has to ship via another port to each the required destination. This will make the shipping distances longer. And it requires more work to find the shortest (cheapest) shipping route.
 +
 +
=== Best or worst estimate ===
 +
There are two choices in calculating the transportation impact: the best estimate and the worst estimate. The best estimate uses the distances between country centroids, so that the calculation is valid for the majority of users. The worst estimate uses the longest distance between the outskirts of a country. In fact this worst calculation is now used for the calculation of the EU.
 +
 +
The rationale behind the worst estimate, is that we would like the producers to give more information on their supply chain (where is the factory? where are the ingredients come from?, etc), so that there is more transparency.
 +
 +
=== Individualised ecoscores ===
 +
The Ecoscore is in some extent an individualised score: it depends on the location of the consumer. In the official explanation this fact is hidden, but it is based on the assumption that the consumers lives/consumes in France.
    
== Adjustments ==
 
== Adjustments ==
Line 294: 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.
3,390

edits

Navigation menu