Changes

Jump to navigation Jump to search
1,506 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 36: Line 37:  
! Country !! Centroid city !! Runnerup 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 || || 184 || [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 || ||  9  || [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 || Maardu || 12 || [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]
Line 58: Line 59:  
| Finland || Helsinki ||  || 5 || [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]
 +
|-
 +
| Germany - states || Hesse || Thuringia || 2 || [https://docs.google.com/spreadsheets/d/1HSNFq2sJiRxarSvY_mHtEOiSIq9fwFAyTh9lA4DfgF4 link]
 
|-
 
|-
 
| Greece || Athens || || || [https://docs.google.com/spreadsheets/d/1RN6YIwDWLgLrultpRt49D83s3UCeAuQErZb4Orriv-Q link]
 
| Greece || Athens || || || [https://docs.google.com/spreadsheets/d/1RN6YIwDWLgLrultpRt49D83s3UCeAuQErZb4Orriv-Q link]
Line 71: Line 74:  
|-
 
|-
 
| Italy || Rome || Florence || 0.6 || [https://docs.google.com/spreadsheets/d/19GxxwjgUrsMB522Vv_3zUCg-bJVyg054WwMK5S3tkP0 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]
Line 76: Line 81:  
| 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 || Bijelo Polje || || 15 || 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]
 
|-
 
|-
| Morocco || Temara || ||  || link
+
| Netherlands - provinces || Utrecht || Zuid-Holland || 15 || [https://docs.google.com/spreadsheets/d/1uyw9WAFAPtyx-hRyJ4j3PyLSVrEB48fhMUZD28VhzfI/edit?usp=sharing link]
 
|-
 
|-
| Netherlands || Utrecht || Amsterdam || 4 || [https://docs.google.com/spreadsheets/d/1x8Vfb2ZIjsTmb0lRrO-8YHC6NKmgc58HtP_cNSjeOQY link]
+
| North Macedonia || Skopje || Vardar ||  0.1 || [https://docs.google.com/spreadsheets/d/1EAb2rOX7l2SkcBhKNCpvHPGXsExJKjtzPDiTDnWlNcY/edit?usp=sharing link]
 
|-
 
|-
 
| Norway || Skien || Oslo ||  0.7 || [https://docs.google.com/spreadsheets/d/1e3vPPWMyJu6k5rdbqDC9EGgOCgmAmsGZ2JO1oMrCbXw/edit link]
 
| Norway || Skien || Oslo ||  0.7 || [https://docs.google.com/spreadsheets/d/1e3vPPWMyJu6k5rdbqDC9EGgOCgmAmsGZ2JO1oMrCbXw/edit link]
Line 86: Line 95:  
| Poland || Łódź || Warschau || 24 || [https://docs.google.com/spreadsheets/d/1wBNuc3qItIouZHKLI-c9TrJcL2skF-T6sw_Yh1gPxM4 link]
 
| Poland || Łódź || Warschau || 24 || [https://docs.google.com/spreadsheets/d/1wBNuc3qItIouZHKLI-c9TrJcL2skF-T6sw_Yh1gPxM4 link]
 
|-
 
|-
| Portugal || Lisboa || || 0.5 || [https://docs.google.com/spreadsheets/d/1DBTu9pNtdLhf0hBPGqnYbLYXnxhAkX0f7eDcRBIrZGU link]
+
| Portugal || Loures || Lissabon || 1.1 || [https://docs.google.com/spreadsheets/d/1DBTu9pNtdLhf0hBPGqnYbLYXnxhAkX0f7eDcRBIrZGU link]
 
|-
 
|-
| Romania || Bucharest || || || [https://docs.google.com/spreadsheets/d/1V-39ygo6LszL2PWHUVi8VFtci1CExjpQLN7Y2w-nUXQ link]
+
| Romania || Bucharest || Ploiești || 4 || [https://docs.google.com/spreadsheets/d/1V-39ygo6LszL2PWHUVi8VFtci1CExjpQLN7Y2w-nUXQ link]
 
|-
 
|-
| Slovakia || Banská Bystrica || || || [https://docs.google.com/spreadsheets/d/1lTXNbUIM5ATG1C0TpzsgmtGnHFBqt0m2PBtRvVul0XE/ link]
+
| Serbia - districts || Belgrad || Srem || 5 || [https://docs.google.com/spreadsheets/d/1ComqBolNvRQ7xYrvO4mMsKfcD39b4h6p4MwN7PAEqac/edit?usp=sharing link]
 
|-
 
|-
| Slovenia || Ljubljana || || 33 || [https://docs.google.com/spreadsheets/d/1CVV7NGr2XZ-iYhE4c48Vm7WBhXPOxa79XrdV5GVck5E/ link]
+
| Slovakia || Banská Bystrica || Nitra || 0.3 || [https://docs.google.com/spreadsheets/d/1lTXNbUIM5ATG1C0TpzsgmtGnHFBqt0m2PBtRvVul0XE/ link]
 +
|-
 +
| Slovenia || Ljubljana || Domžale || 74 || [https://docs.google.com/spreadsheets/d/1CVV7NGr2XZ-iYhE4c48Vm7WBhXPOxa79XrdV5GVck5E/ link]
 
|-
 
|-
 
| Spain || Madrid || Barcelona || 1.1 || [https://docs.google.com/spreadsheets/d/1Zf0ks3MiWOHbh9CSNiZQwW3yy9jW3l7qFahGYBH-uc8 link]
 
| Spain || Madrid || Barcelona || 1.1 || [https://docs.google.com/spreadsheets/d/1Zf0ks3MiWOHbh9CSNiZQwW3yy9jW3l7qFahGYBH-uc8 link]
Line 98: Line 109:  
| Sweden || Nörrköping || Stockholm || 3 || [https://docs.google.com/spreadsheets/d/16kjE6_IIoqiOHdFB-x1rpJiEesRbNqhwXSv8HTyy_NQ link]
 
| Sweden || Nörrköping || Stockholm || 3 || [https://docs.google.com/spreadsheets/d/16kjE6_IIoqiOHdFB-x1rpJiEesRbNqhwXSv8HTyy_NQ link]
 
|-
 
|-
| Switzerland || Olten || || 36 || [https://docs.google.com/spreadsheets/d/1VJ08fAdkbvnKAFDnn1RnNXQxWn9nzTK1y5GJ5AJFa1Y link]
+
| Switzerland || Olten || Solothurn || 6 || [https://docs.google.com/spreadsheets/d/1VJ08fAdkbvnKAFDnn1RnNXQxWn9nzTK1y5GJ5AJFa1Y link]
 
|-
 
|-
 
| Tunisia || Tunis || || || link
 
| Tunisia || Tunis || || || link
 
|-
 
|-
| United Kingdom || Coventry || || || [https://docs.google.com/spreadsheets/d/1xbNe-QDLIZt6h1HvLAa4jzTQoyifdLaiTr4UgaqbHNk link]
+
| United Kingdom || Coventry || Leicester || 12 || [https://docs.google.com/spreadsheets/d/1xbNe-QDLIZt6h1HvLAa4jzTQoyifdLaiTr4UgaqbHNk link]
 +
|-
 +
| European Union - cities || Munich || Prague || 0.3 || [ link]
 
|-
 
|-
| European Union || Munich || Prague || 0.3 || link
+
| European Union - countries || Luxemburg || Germany || 29 || [https://docs.google.com/spreadsheets/d/13OGmvv8BMbShdGuncfYYCjs3_YpKeC8wVftFVb1pbHk/edit link]
 
|-
 
|-
 
| Bouches du Rhône || Marseille || Les Pennes Mirabeau || 30 || link
 
| Bouches du Rhône || Marseille || Les Pennes Mirabeau || 30 || link

Navigation menu