Jump to content

Centroid: Difference between revisions

Centroid (view source)

Revision as of 15:27, 23 March 2021

1,423 bytes added ,  23 March 2021
no edit summary
VisualWikitext
(Updated Germany)
Tags: Mobile edit Mobile web edit
No edit summary
 
(22 intermediate revisions by one other user not shown)
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 38: Line 39:
| Albania || Tirana || Kamëz || 13 || 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]
Line 60: Line 61:
| France || Paris || Lyon || 7 || [https://docs.google.com/spreadsheets/d/1-G7VVZDE7xH6yzhsVYpmTTnu3rtgvadMC7WX9yIJqPc link]
| France || Paris || Lyon || 7 || [https://docs.google.com/spreadsheets/d/1-G7VVZDE7xH6yzhsVYpmTTnu3rtgvadMC7WX9yIJqPc link]
|-
|-
| Germany || Hannover || Bielefeld || 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 89: Line 98:
|-
|-
| Romania || Bucharest || Ploiești || 4 || [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]
|-
| Serbia - districts || Belgrad || Srem || 5 || [https://docs.google.com/spreadsheets/d/1ComqBolNvRQ7xYrvO4mMsKfcD39b4h6p4MwN7PAEqac/edit?usp=sharing link]
|-
|-
| Slovakia || Banská Bystrica || Nitra || 0.3 || [https://docs.google.com/spreadsheets/d/1lTXNbUIM5ATG1C0TpzsgmtGnHFBqt0m2PBtRvVul0XE/ link]
| Slovakia || Banská Bystrica || Nitra || 0.3 || [https://docs.google.com/spreadsheets/d/1lTXNbUIM5ATG1C0TpzsgmtGnHFBqt0m2PBtRvVul0XE/ 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
Line 104: Line 115:
| United Kingdom || Coventry || Leicester || 12 || [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 || Munich || Prague || 0.3 || link
| European Union - cities || 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
Retrieved from "https://test-wiki.openfoodfacts.org/Special:MobileDiff/16863...17022"