Changes

Jump to navigation Jump to search
1,824 bytes added ,  15:27, 23 March 2021
no edit summary
Line 1: Line 1:  +
[[Category:Eco-Score]]
 
The [https://en.wikipedia.org/wiki/Centroid centroid] of a country (or area) can de defined in multiple ways. On the earth surface it is more useful to speak of the [https://en.wikipedia.org/wiki/Geographical_centre geographical center]. It is possible to find lists of these centers for area's on earth. ([[Eco-score transport - en|parent page]])
 
The [https://en.wikipedia.org/wiki/Centroid centroid] of a country (or area) can de defined in multiple ways. On the earth surface it is more useful to speak of the [https://en.wikipedia.org/wiki/Geographical_centre geographical center]. It is possible to find lists of these centers for area's on earth. ([[Eco-score transport - en|parent page]])
   Line 28: Line 29:  
* distance worksheet: this worksheet contains the distances between the cities noted on the population spreadsheet. The distances are taken from OpenStreetMap. Only the fields above the diagonal need to be filled. The fields below the diagonal are filled subsequently;
 
* distance worksheet: this worksheet contains the distances between the cities noted on the population spreadsheet. The distances are taken from OpenStreetMap. Only the fields above the diagonal need to be filled. The fields below the diagonal are filled subsequently;
 
* weighted sum: this worksheet is calculated based on the two worksheets mentioned above. The row at the bottom (the one without a city) is the sum of a column. The column with the smallest sum is the city we are looking for. To determine the quality of this city, the entries weighted dethroning distance, dethroning distance and real distance need to be changed. The weighted dethroning distance should have the weighted sum of the runnerup city minus the weighted sum of the centroid city. The dethroning distance is the weighted dethroning distance divided by the population fraction of the latest city that has been added. And the real distance is a reference to the real distance between the centroid and runnerup city. The larger the difference betzeen dethroning distance and real distance, the better the quality;
 
* weighted sum: this worksheet is calculated based on the two worksheets mentioned above. The row at the bottom (the one without a city) is the sum of a column. The column with the smallest sum is the city we are looking for. To determine the quality of this city, the entries weighted dethroning distance, dethroning distance and real distance need to be changed. The weighted dethroning distance should have the weighted sum of the runnerup city minus the weighted sum of the centroid city. The dethroning distance is the weighted dethroning distance divided by the population fraction of the latest city that has been added. And the real distance is a reference to the real distance between the centroid and runnerup city. The larger the difference betzeen dethroning distance and real distance, the better the quality;
* growth worksheet: this worksheet allows to see how the weighted sums grow with each added city. Especially to see what happens between the centroid and runnerup city;
+
* size worksheet: this worksheet allows to estimate the transportation size of a country. The cumulative weighted sum is plotted against the cumulative population fraction. A logarithmic fit is made, and the transportation size is estimated at a population fraction of 1, i.e. the entire population;
    
== Result ==
 
== Result ==
Line 34: Line 35:  
{| class="wikitable sortable"
 
{| class="wikitable sortable"
 
|-
 
|-
! Country !! Centroid city !! quality !! spreadsheet
+
! Country !! Centroid city !! Runnerup city !! quality !! spreadsheet
 
|-
 
|-
| Albania || Tirana || || link
+
| Albania || Tirana || Kamëz || 13 || link
 
|-
 
|-
| Algeria || Algers || || link
+
| Algeria || Algers || Blida || 15 || link
 
|-
 
|-
| Austria || Vienna ||  || [https://docs.google.com/spreadsheets/d/1joXvrjWDmabsyFqf4V6bBsmCJHp0fhCB5oAy8nOStRU/ link]
+
| Austria || Vienna || Baden bei Wien || 61 || [https://docs.google.com/spreadsheets/d/1joXvrjWDmabsyFqf4V6bBsmCJHp0fhCB5oAy8nOStRU link]
 
|-
 
|-
| Belgium || Brussels || 0.7 || [https://docs.google.com/spreadsheets/d/1-_DRQi9VUrV2o5oVRL01DUBz9iT3ZvVPlvxvz9O_ZLg link]
+
| Belgium || Brussels || Antwerp ||  0.7 || [https://docs.google.com/spreadsheets/d/1-_DRQi9VUrV2o5oVRL01DUBz9iT3ZvVPlvxvz9O_ZLg link]
 
|-
 
|-
| Bosnia and Herzegovina || Zenica || 0.6 || link
+
| Bosnia and Herzegovina || Zenica || || 0.6 || link
 
|-
 
|-
|- Bulgaria || Sofia || || [https://docs.google.com/spreadsheets/d/193RBhO4Dnd4ZwPbepP2oeyF5PkOMDeoxszSNuMW8VrQ link]
+
| Bulgaria - provinces || Stara Zagora || Plovdiv || 44 || [https://docs.google.com/spreadsheets/d/193RBhO4Dnd4ZwPbepP2oeyF5PkOMDeoxszSNuMW8VrQ link]
 
|-
 
|-
| Croatia || Zagreb || || link
+
| Croatia || Zagreb || Velika Gorica || 30 || [https://docs.google.com/spreadsheets/d/1aWRYBN87i9pO8GbbxcemB38LIexrWnDgZMVqXOAwRaA link]
 
|-
 
|-
| Czech Republic || Prague ||  || [https://docs.google.com/spreadsheets/d/1QlsggBo0dOK-gvXR3-wOeeIQOLDSQ6J9TAGijCZ0ENg/ link]
+
| Czech Republic || Prague || ||  9 || [https://docs.google.com/spreadsheets/d/1QlsggBo0dOK-gvXR3-wOeeIQOLDSQ6J9TAGijCZ0ENg/ link]
 
|-
 
|-
| Denmark || Copenhagen || 16 || [https://docs.google.com/spreadsheets/d/1uB0MooOA0xT8z9bRfZ1iaKxNph1FQgeUby0HmXSOrKw link]
+
| Denmark || Copenhagen || Roskilde || 5 || [https://docs.google.com/spreadsheets/d/1uB0MooOA0xT8z9bRfZ1iaKxNph1FQgeUby0HmXSOrKw link]
 
|-
 
|-
| Estonia || Tallinn || || [https://docs.google.com/spreadsheets/d/1nhs-FE32-n0taDLiNHxZ71VBGC2mYrBHjLlwI_PNMsQ/ link]
+
| Estonia || Tallinn || Maardu || 12 || [https://docs.google.com/spreadsheets/d/1nhs-FE32-n0taDLiNHxZ71VBGC2mYrBHjLlwI_PNMsQ/ link]
 
|-
 
|-
| Finland || Helsinki ||  || [https://docs.google.com/spreadsheets/d/1OXHdXZDUJ9So5oSP67ZWzkDdSaQADQdZbDMnp7ekXcU/ link]
+
| Finland || Helsinki ||  || 5 || [https://docs.google.com/spreadsheets/d/1OXHdXZDUJ9So5oSP67ZWzkDdSaQADQdZbDMnp7ekXcU/ link]
 
|-
 
|-
| France || Paris || || [https://docs.google.com/spreadsheets/d/1-G7VVZDE7xH6yzhsVYpmTTnu3rtgvadMC7WX9yIJqPc link]
+
| France || Paris || Lyon || 7 || [https://docs.google.com/spreadsheets/d/1-G7VVZDE7xH6yzhsVYpmTTnu3rtgvadMC7WX9yIJqPc link]
 
|-
 
|-
| Germany || Hannover || 19 || [https://docs.google.com/spreadsheets/d/1HSNFq2sJiRxarSvY_mHtEOiSIq9fwFAyTh9lA4DfgF4 link]
+
| Germany - cities || Hannover || Bielefeld || 19 || [https://docs.google.com/spreadsheets/d/1HSNFq2sJiRxarSvY_mHtEOiSIq9fwFAyTh9lA4DfgF4 link]
 
|-
 
|-
| Greece || Athens || || [https://docs.google.com/spreadsheets/d/1RN6YIwDWLgLrultpRt49D83s3UCeAuQErZb4Orriv-Q link]
+
| Germany - states || Hesse || Thuringia || 2 || [https://docs.google.com/spreadsheets/d/1HSNFq2sJiRxarSvY_mHtEOiSIq9fwFAyTh9lA4DfgF4 link]
 
|-
 
|-
| Hungary || Budapest || || [https://docs.google.com/spreadsheets/d/16VZjIhacrZqKWNp95POnc2qKuLgpfTcIgs8Ygt6nxPI link]
+
| Greece || Athens || || || [https://docs.google.com/spreadsheets/d/1RN6YIwDWLgLrultpRt49D83s3UCeAuQErZb4Orriv-Q link]
 
|-
 
|-
| Iceland || Reykjavik || || [https://docs.google.com/spreadsheets/d/1skWHDUfRtpaUkjXy-WiCWhqGBI8st-FB9sjcMaIRiCc link]
+
| Hungary || Budapest ||  || || [https://docs.google.com/spreadsheets/d/16VZjIhacrZqKWNp95POnc2qKuLgpfTcIgs8Ygt6nxPI link]
 
|-
 
|-
| Ireland || Dublin || || [https://docs.google.com/spreadsheets/d/15KY_dUl_3PB_taWZNkfdhcv9RhX7YgcyUC21aNADOdE link]
+
| Iceland || Reykjavik || Kópavogur || 10 || [https://docs.google.com/spreadsheets/d/1skWHDUfRtpaUkjXy-WiCWhqGBI8st-FB9sjcMaIRiCc link]
 
|-
 
|-
| Italy || Rome || || [https://docs.google.com/spreadsheets/d/19GxxwjgUrsMB522Vv_3zUCg-bJVyg054WwMK5S3tkP0 link]
+
| Ireland || Dublin || 56  || || [https://docs.google.com/spreadsheets/d/15KY_dUl_3PB_taWZNkfdhcv9RhX7YgcyUC21aNADOdE link]
 +
|-
 +
| Italy || Rome || Florence || 0.6 || [https://docs.google.com/spreadsheets/d/19GxxwjgUrsMB522Vv_3zUCg-bJVyg054WwMK5S3tkP0 link]
 +
|-
 +
| Kosovo - districts || Pristina || Ferizaj || 2 || [https://docs.google.com/spreadsheets/d/1vZLvWIn1DKnzpRC37v4LVUSdiaO7k6HOJw23f12GpH4/edit?usp=sharing link]
 
|-  
 
|-  
| Latvia || Riga || 25 || [https://docs.google.com/spreadsheets/d/1Ls57Onx80PpDggjztZgjOMDc0ikybXH2Rv7hsIIIav8/ link]
+
| Latvia || Riga || || 25 || [https://docs.google.com/spreadsheets/d/1Ls57Onx80PpDggjztZgjOMDc0ikybXH2Rv7hsIIIav8/ link]
 
|-  
 
|-  
| Lithuania || Kaunas || || [https://docs.google.com/spreadsheets/d/1gz49-FMuaVvFIro2QgoIaxot24ysm1k_2fn6RJJxLF4 link]
+
| Lithuania || Kaunas || || || [https://docs.google.com/spreadsheets/d/1gz49-FMuaVvFIro2QgoIaxot24ysm1k_2fn6RJJxLF4 link]
 +
|-
 +
| Montenegro || Podgorica || Tuzi || 5 || [https://docs.google.com/spreadsheets/d/1GyGKUNo1OVRjRAAWNjHCJnFYKMmuxoVYT-2FdkZv3og/edit?usp=sharing link]
 +
|-
 +
| Morocco || Temara || Rabat || 2.8 || link
 +
|-
 +
| Netherlands - cities || Utrecht || Amsterdam || 4  || [https://docs.google.com/spreadsheets/d/1x8Vfb2ZIjsTmb0lRrO-8YHC6NKmgc58HtP_cNSjeOQY link]
 +
|-
 +
| Netherlands - provinces || Utrecht || Zuid-Holland || 15  || [https://docs.google.com/spreadsheets/d/1uyw9WAFAPtyx-hRyJ4j3PyLSVrEB48fhMUZD28VhzfI/edit?usp=sharing link]
 +
|-
 +
| North Macedonia || Skopje || Vardar ||  0.1 || [https://docs.google.com/spreadsheets/d/1EAb2rOX7l2SkcBhKNCpvHPGXsExJKjtzPDiTDnWlNcY/edit?usp=sharing link]
 
|-
 
|-
| Montenegro || Bijelo Polje || 15 || link
+
| Norway || Skien || Oslo || 0.7 || [https://docs.google.com/spreadsheets/d/1e3vPPWMyJu6k5rdbqDC9EGgOCgmAmsGZ2JO1oMrCbXw/edit link]
 
|-
 
|-
| Morocco || Temara || || link
+
| Poland || Łódź || Warschau || 24 || [https://docs.google.com/spreadsheets/d/1wBNuc3qItIouZHKLI-c9TrJcL2skF-T6sw_Yh1gPxM4 link]
 
|-
 
|-
| Netherlands || Utrecht || || [https://docs.google.com/spreadsheets/d/1x8Vfb2ZIjsTmb0lRrO-8YHC6NKmgc58HtP_cNSjeOQY link]
+
| Portugal || Loures || Lissabon || 1.1 || [https://docs.google.com/spreadsheets/d/1DBTu9pNtdLhf0hBPGqnYbLYXnxhAkX0f7eDcRBIrZGU link]
 
|-
 
|-
| Norway || Skien || || [https://docs.google.com/spreadsheets/d/1e3vPPWMyJu6k5rdbqDC9EGgOCgmAmsGZ2JO1oMrCbXw/edit link]
+
| Romania || Bucharest || Ploiești || 4 || [https://docs.google.com/spreadsheets/d/1V-39ygo6LszL2PWHUVi8VFtci1CExjpQLN7Y2w-nUXQ link]
 
|-
 
|-
| Poland || Łódź || 24 || [https://docs.google.com/spreadsheets/d/1wBNuc3qItIouZHKLI-c9TrJcL2skF-T6sw_Yh1gPxM4 link]
+
| Serbia - districts || Belgrad || Srem || 5 || [https://docs.google.com/spreadsheets/d/1ComqBolNvRQ7xYrvO4mMsKfcD39b4h6p4MwN7PAEqac/edit?usp=sharing link]
 
|-
 
|-
| Portugal || Lisboa || || [https://docs.google.com/spreadsheets/d/1DBTu9pNtdLhf0hBPGqnYbLYXnxhAkX0f7eDcRBIrZGU link]
+
| Slovakia || Banská Bystrica || Nitra || 0.3 || [https://docs.google.com/spreadsheets/d/1lTXNbUIM5ATG1C0TpzsgmtGnHFBqt0m2PBtRvVul0XE/ link]
 
|-
 
|-
| Romania || Bucharest || || [https://docs.google.com/spreadsheets/d/1V-39ygo6LszL2PWHUVi8VFtci1CExjpQLN7Y2w-nUXQ link]
+
| Slovenia || Ljubljana || Domžale || 74 || [https://docs.google.com/spreadsheets/d/1CVV7NGr2XZ-iYhE4c48Vm7WBhXPOxa79XrdV5GVck5E/ link]
 
|-
 
|-
| Slovakia || Banská Bystrica || || [https://docs.google.com/spreadsheets/d/1lTXNbUIM5ATG1C0TpzsgmtGnHFBqt0m2PBtRvVul0XE/ link]
+
| Spain || Madrid || Barcelona || 1.1 || [https://docs.google.com/spreadsheets/d/1Zf0ks3MiWOHbh9CSNiZQwW3yy9jW3l7qFahGYBH-uc8 link]
 
|-
 
|-
| Slovenia || Ljubljana || || [https://docs.google.com/spreadsheets/d/1CVV7NGr2XZ-iYhE4c48Vm7WBhXPOxa79XrdV5GVck5E/ link]
+
| Sweden || Nörrköping || Stockholm || 3 || [https://docs.google.com/spreadsheets/d/16kjE6_IIoqiOHdFB-x1rpJiEesRbNqhwXSv8HTyy_NQ link]
 
|-
 
|-
| Spain || Madrid ||  || [https://docs.google.com/spreadsheets/d/1Zf0ks3MiWOHbh9CSNiZQwW3yy9jW3l7qFahGYBH-uc8 link]
+
| Switzerland || Olten || Solothurn || 6 || [https://docs.google.com/spreadsheets/d/1VJ08fAdkbvnKAFDnn1RnNXQxWn9nzTK1y5GJ5AJFa1Y link]
 
|-
 
|-
| Sweden || Nörrköping || || [https://docs.google.com/spreadsheets/d/16kjE6_IIoqiOHdFB-x1rpJiEesRbNqhwXSv8HTyy_NQ link]
+
| Tunisia || Tunis || || || link
 
|-
 
|-
| Switzerland || Olten || 36  || [https://docs.google.com/spreadsheets/d/1VJ08fAdkbvnKAFDnn1RnNXQxWn9nzTK1y5GJ5AJFa1Y link]
+
| United Kingdom || Coventry || Leicester || 12 || [https://docs.google.com/spreadsheets/d/1xbNe-QDLIZt6h1HvLAa4jzTQoyifdLaiTr4UgaqbHNk link]
 
|-
 
|-
| Tunisia || Tunis || || link
+
| European Union - cities || Munich || Prague || 0.3 || [ link]
 
|-
 
|-
| United Kingdom || Coventry || || [https://docs.google.com/spreadsheets/d/1xbNe-QDLIZt6h1HvLAa4jzTQoyifdLaiTr4UgaqbHNk link]
+
| European Union - countries || Luxemburg || Germany || 29 || [https://docs.google.com/spreadsheets/d/13OGmvv8BMbShdGuncfYYCjs3_YpKeC8wVftFVb1pbHk/edit link]
 
|-
 
|-
| European Union || Prague || || link
+
| Bouches du Rhône || Marseille || Les Pennes Mirabeau || 30 || link
 
|}
 
|}
 
This approach of finding a centroid seems to give good results. As more cities are added the centroid does not change for most countries.
 
This approach of finding a centroid seems to give good results. As more cities are added the centroid does not change for most countries.

Navigation menu