Skip to content

Instantly share code, notes, and snippets.

@migurski

migurski/OSMF-2021-Survey.qgz

Last active February 27, 2021 00:03
Show Gist options
  • Save migurski/dc9d1723a7438c4502754d02ae8b6f7a to your computer and use it in GitHub Desktop.
Save migurski/dc9d1723a7438c4502754d02ae8b6f7a to your computer and use it in GitHub Desktop.
Download ZIP
OSMF 2021 Survey Regions
Raw
demographic_sorted_by_country.csv
Country/Region count Country/Region quotient(sum Working group membercount Working group member) quotient(sum OSM Foundation membercount OSM Foundation member) quotient(sum Local chapter membercount Local chapter member) quotient(sum Local community membercount Local community member) quotient(sum Corporate sponsor employeecount Corporate sponsor employee) quotient(sum Company using OSM data employeecount Company using OSM data employee) quotient(sum Non-profit org using OSM employeecount Non-profit org using OSM employee) quotient(sum Mappercount Mapper) quotient(sum Communicatorcount Communicator) quotient(sum Data usercount Data user) quotient(sum Developercount Developer) quotient(sum Event organizercount Event organizer) quotient(sum Sysadmincount Sysadmin)
0 0.083 0.223 0.178 0.252 0.028 0.108 0.168 0.798 0.125 0.525 0.151 0.123 0.046
Africa-angl 83 0.205 0.313 0.325 0.398 0.000 0.000 0.265 0.952 0.241 0.530 0.072 0.277 0.048
Africa-rom 34 0.206 0.265 0.353 0.353 0.029 0.059 0.206 0.941 0.206 0.441 0.088 0.324 0.029
Americas 80 0.200 0.175 0.250 0.375 0.000 0.038 0.188 0.850 0.138 0.500 0.075 0.113 0.063
Australia 38 0.053 0.316 0.289 0.184 0.026 0.105 0.158 0.921 0.105 0.605 0.105 0.158 0.026
Austria 47 0.021 0.170 0.000 0.447 0.000 0.128 0.149 0.830 0.043 0.745 0.106 0.064 0.000
Belarus 26 0.038 0.269 0.038 0.346 0.077 0.346 0.154 0.731 0.115 0.654 0.423 0.077 0.077
Belgium 28 0.071 0.321 0.321 0.179 0.000 0.071 0.214 0.857 0.107 0.536 0.143 0.107 0.071
Brazil 52 0.077 0.154 0.115 0.558 0.019 0.096 0.192 0.846 0.115 0.615 0.173 0.096 0.077
Canada 41 0.049 0.146 0.073 0.220 0.000 0.073 0.171 0.805 0.024 0.610 0.122 0.024 0.073
China 24 0.208 0.167 0.208 0.458 0.042 0.042 0.375 0.625 0.083 0.542 0.167 0.000 0.042
EAsia/Oceania 35 0.200 0.257 0.229 0.257 0.029 0.057 0.114 0.771 0.114 0.571 0.057 0.057 0.057
EU 132 0.061 0.144 0.152 0.356 0.000 0.038 0.098 0.864 0.083 0.477 0.152 0.076 0.015
Europe 24 0.125 0.167 0.125 0.292 0.042 0.042 0.083 0.833 0.042 0.417 0.125 0.125 0.042
France 165 0.018 0.170 0.206 0.236 0.012 0.091 0.121 0.818 0.048 0.527 0.127 0.091 0.024
Germany 411 0.017 0.173 0.041 0.273 0.012 0.083 0.102 0.883 0.058 0.667 0.129 0.051 0.049
India 41 0.146 0.244 0.244 0.488 0.024 0.098 0.049 0.976 0.195 0.341 0.073 0.098 0.000
Indonesia 20 0.050 0.100 0.200 0.400 0.050 0.100 0.400 0.850 0.150 0.600 0.050 0.100 0.000
Italy 125 0.112 0.168 0.256 0.224 0.000 0.072 0.144 0.856 0.088 0.504 0.080 0.136 0.024
Japan 27 0.074 0.296 0.259 0.259 0.000 0.148 0.111 0.926 0.259 0.481 0.185 0.333 0.037
Middle East 40 0.150 0.275 0.200 0.400 0.025 0.150 0.200 0.675 0.200 0.425 0.200 0.225 0.100
Netherlands 39 0.077 0.205 0.026 0.282 0.000 0.103 0.077 0.897 0.026 0.462 0.154 0.077 0.026
Philippines 27 0.111 0.370 0.074 0.630 0.074 0.111 0.370 0.889 0.296 0.667 0.111 0.259 0.037
Poland 56 0.054 0.196 0.089 0.571 0.018 0.089 0.054 0.839 0.143 0.232 0.143 0.018 0.071
Russian Federation 61 0.016 0.082 0.000 0.344 0.016 0.115 0.246 0.705 0.098 0.705 0.279 0.033 0.000
S&W Asia 25 0.160 0.120 0.320 0.320 0.000 0.160 0.200 0.880 0.080 0.480 0.080 0.160 0.000
Spain 53 0.057 0.170 0.132 0.453 0.000 0.019 0.057 0.774 0.113 0.491 0.113 0.075 0.019
Sweden 24 0.083 0.125 0.000 0.292 0.000 0.042 0.042 0.917 0.000 0.458 0.000 0.042 0.000
Switzerland 50 0.060 0.220 0.260 0.120 0.020 0.060 0.120 0.840 0.040 0.680 0.080 0.040 0.060
Ukraine 36 0.056 0.139 0.139 0.528 0.056 0.139 0.139 0.833 0.028 0.639 0.167 0.056 0.000
United Kingdom 146 0.055 0.274 0.164 0.068 0.000 0.055 0.171 0.815 0.089 0.479 0.123 0.110 0.027
United States 294 0.061 0.248 0.214 0.160 0.088 0.197 0.139 0.895 0.105 0.554 0.177 0.133 0.034
Raw
feedback_sorted_by_country.csv
Country/Region avg Code Of Conduct avg Fundraising avg Software Investments avg iD avg Microgrants
3.8 4.2 4.2 4.1 4.0
Africa-angl 4.0 4.4 4.3 4.1 4.3
Africa-rom 4.0 4.4 4.1 3.8 4.2
Americas 4.0 4.4 4.4 4.0 4.1
Australia 3.9 4.1 4.2 4.0 4.1
Austria 3.9 4.0 4.3 4.5 3.9
Belarus 3.7 4.3 4.3 3.9 4.2
Belgium 3.8 4.4 4.3 4.4 4.2
Brazil 4.3 4.4 4.6 4.2 4.4
Canada 3.9 4.4 4.3 4.3 3.8
China 3.7 4.0 4.2 3.8 3.8
EAsia/Oceania 3.8 4.0 4.2 4.1 4.0
EU 3.5 4.3 4.2 4.2 4.1
Europe 3.9 4.3 4.2 4.2 4.0
France 4.0 4.3 4.2 4.2 4.1
Germany 3.8 4.0 4.2 4.2 4.0
India 4.0 4.2 4.1 4.4 4.0
Indonesia 4.3 4.5 4.4 4.1 4.2
Italy 4.0 4.2 4.3 4.1 4.1
Japan 3.7 4.2 4.0 4.0 3.7
Middle East 3.7 4.2 3.9 4.2 3.6
Netherlands 4.0 4.2 4.2 4.0 4.0
Philippines 4.0 4.6 4.5 4.5 4.6
Poland 3.4 4.4 4.2 4.2 4.1
Russian Federation 3.3 4.3 4.2 3.9 4.1
S&W Asia 4.2 4.4 3.9 4.1 4.0
Spain 4.0 4.1 4.2 4.1 4.0
Sweden 3.6 4.2 4.2 4.3 3.9
Switzerland 3.6 4.1 4.3 4.2 4.0
Ukraine 3.8 4.4 4.1 4.1 4.1
United Kingdom 3.8 4.2 4.1 4.1 4.1
United States 4.1 4.4 4.3 4.2 4.1
Display the source blob
Display the rendered blob
Raw
osmf-survey-response-labels.geojson
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Display the source blob
Display the rendered blob
Raw
osmf-survey-response-pies.geojson
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Display the source blob
Display the rendered blob
Raw
osmf-survey-response-regions-population.geojson
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Raw
region_editing_stats.csv
OSMF Region Responses Users - Non-Local Users - Local Changesets - Non-Local Changesets - Local Edits - Non-Local Edits - Local Users with > 1 day - Non-Local Users with > 1 day - Local Changesets from users with > 1 day - Non-Local Changesets from users with > 1 day - Local Editsfrom users with > 1 day - Non-Local Editsfrom users with > 1 day - Local Users with >= 42 Days - < 42 Days Users with >= 42 Days - >=42 Days ("Active Contributors") Changesets from users with >= 42 days - < 42 Days Changesets from users with >= 42 days - >=42 Days ("Active Contributors") Edits from users with >= 42 days - < 42 Days Edits from users with >= 42 days - >=42 Days ("Active Contributors")
1476 1016 30578 25326 3479179 3207869 1351 342 30271 24052 3453498 3176409 1675 817 12838 43066 2335037 4352011
Africa-anglophone No 1026 766 14451 11225 2919839 3019641 914 287 14137 9408 2888767 2895429 1315 477 10943 14733 1732372 4207108
Africa-anglophone Yes 8238 22122 188846 675869 26813058 135049065 6752 7612 184796 598656 26412794 128838295 28526 1834 360219 504496 42677949 119184174
Africa-romanophone No 2961 2411 41977 40583 8843234 9177125 2563 926 40753 31298 8717366 8471344 4645 727 43013 39547 5166276 12854083
Africa-romanophone Yes 5039 6066 84539 213397 20033019 51673930 4281 2200 82387 194760 19764536 50092020 9782 1323 110591 187345 16261434 55445515
Americas, NES No 4475 6735 106413 82696 11790080 5864840 3855 2170 104602 58978 11654700 4800423 10303 907 84273 104836 5748748 11906172
Americas, NES Yes 7405 19464 294787 1023535 31889110 80977350 6120 6155 290860 980099 30718461 79035494 24706 2163 204010 1114312 17178768 95687692
Australia Yes 992 3323 18574 148158 926562 15097688 873 1391 18311 141770 914727 13379950 3726 589 43109 123623 4940455 11083795
Austria Yes 2043 3540 23379 122350 1258557 9206645 1858 1666 23098 117482 1255267 9145143 4627 956 49126 96603 1282814 9182388
Belarus Yes 621 1638 19331 41950 1071227 6213592 577 618 19257 38861 1069840 6172999 1792 467 14994 46287 502627 6782192
Belgium Yes 1301 3376 20288 166813 1020886 11946943 1168 1551 20076 162127 1016823 11856768 3926 751 40817 146284 1632371 11335458
Brazil Yes 1568 7099 103931 748742 7534959 88675692 1457 2469 103740 736259 7526487 88175699 7565 1102 71716 780957 14318971 81891680
Canada Yes 1615 3747 31492 134659 5546549 24654381 1508 1532 31326 129040 5536734 24456457 4330 1032 48072 118079 9537935 20662995
China Yes 1236 2605 54773 114249 7088045 30064407 1148 1054 54636 110852 7076202 29921841 2990 851 25945 143077 3115518 34036934
EAsia/Oceania, NES No 1719 1580 57144 23532 5811664 3316165 1546 510 56592 20952 5785402 3263304 2440 859 21313 59363 2401517 6726312
EAsia/Oceania, NES Yes 3974 8822 210240 644332 16645685 50600765 3489 3347 207516 625345 16534432 49903686 11237 1559 187853 666719 10716645 56529805
EU, not elsewhere specified No 194 143 3194 2010 184082 265853 177 49 3166 1832 183751 262649 218 119 1900 3304 247243 202692
EU, not elsewhere specified Yes 4330 14319 100662 722492 10268815 64631934 3876 6774 99903 702162 10242686 64194350 16241 2408 214585 608569 13150217 61750532
Europe, NES No 664 853 20336 31909 1981787 5663381 630 290 20292 30621 1979983 5646881 1073 444 8712 43533 380553 7264615
Europe, NES Yes 1355 1960 47900 86260 4639298 39730292 1255 898 47701 83677 4629995 39614872 2573 742 43186 90974 9516120 34853470
France Yes 3194 16707 60780 902827 2437720 40297702 2771 7093 60047 878117 2411293 39984753 18097 1804 219407 744200 5435135 37300287
Germany Yes 3648 30200 148481 1412777 3906248 54446341 3073 15418 147334 1371955 3878197 54023277 31341 2507 465556 1095702 8506182 49846407
India Yes 4796 21311 62096 654820 9129452 44162535 3771 6534 59051 583592 8860942 41296873 24832 1275 396349 320567 16105276 37186711
Indonesia Yes 4302 17663 223258 496174 17768511 43563185 3378 5210 218452 416989 17353867 37919364 20913 1052 328609 390823 31968254 29363442
Italy Yes 2455 8060 33871 331198 1855886 24951566 2221 3900 33463 320141 1843802 24740756 9223 1292 109570 255499 4048759 22758693
Japan Yes 1285 3693 18534 190283 1757182 30650391 1182 1695 18354 181965 1732272 30227524 4413 565 59695 149122 5526891 26880682
Middle East No 1399 1844 23122 41294 1873668 2468952 1283 638 22870 38460 1854778 2357394 2627 616 32044 32372 1421368 2921252
Middle East Yes 3397 14125 89008 382943 10554642 27052216 2926 4848 87956 360709 10441244 26364716 16206 1316 118358 353593 6783899 30822959
Netherlands Yes 1252 3284 20094 163630 893540 11070069 1108 1445 19846 158942 889643 10996847 3846 690 40146 143578 919488 11044121
Philippines Yes 5182 7547 170414 212528 10764633 23928237 4363 2460 168187 188058 10592917 22584254 11782 947 127209 255733 8103051 26589819
Poland Yes 1259 6363 20018 342600 902802 40622709 1158 2842 19845 333547 896985 40483759 6711 911 94229 268389 3503305 38022206
Russian Federation Yes 1636 12953 82205 657569 5548869 74139949 1423 5334 81872 549977 5539339 72274505 13321 1268 303571 436203 13073521 66615297
S&W Asia, NES No 1249 661 21719 29184 2824413 5930122 1129 243 21476 27268 2803176 5812927 1488 422 12766 38137 1367693 7386842
S&W Asia, NES Yes 3536 7143 70891 167694 7710876 21672749 3131 2266 69724 147670 7594359 20689735 9567 1112 91157 147428 8393198 20990427
Spain Yes 1457 4744 23017 214064 2080389 22987538 1310 2077 22741 206367 2075417 22753217 5331 870 65481 171600 3968499 21099428
Sweden Yes 738 2161 11403 274422 4222061 13029376 656 1076 11241 271406 4215503 12935118 2465 434 228361 57464 5731479 11519958
Switzerland Yes 1816 3367 19917 115156 1032242 5212208 1624 1601 19605 110784 1026621 5163787 4282 901 47784 87289 1063618 5180832
Ukraine Yes 1061 4164 53984 177323 3399239 20031354 969 1679 53802 171569 3387721 19912897 4455 770 45311 185996 3085859 20344734
United Kingdom Yes 2162 9794 77504 592390 2646680 30985449 1870 4504 76914 578733 2633360 30688662 10640 1316 131181 538713 6383241 27248888
United States Yes 3933 25629 89493 4051416 9253533 215899476 3298 10237 87986 4003198 9155595 213311350 27042 2520 362641 3778268 45822326 179330683
Raw
sentiment_policies.txt
region AI ban AI no position AI blanket approval AI conditional approval AI No opinion VT pay non-competitively VT do nothing VT encourage volunteers VT pay competitively VT No opinion
Africa-angl 3 29 17 31 3 12 9 35 9 18
Africa-rom 2 8 5 15 4 4 1 17 6 6
Americas 8 25 15 30 2 7 5 23 20 25
Australia 1 19 3 12 3 2 5 7 13 11
Austria 6 20 4 15 2 3 3 19 11 11
Belarus 0 9 3 12 2 4 4 4 9 5
Belgium 1 9 3 10 5 6 1 6 6 9
Brazil 3 14 9 25 1 5 7 19 12 9
Canada 1 16 9 9 6 6 5 19 6 5
China 0 9 3 9 3 6 3 7 3 5
EAsia/Oceania 3 10 2 15 5 7 1 8 6 13
EU 11 61 13 39 8 11 15 48 27 31
Europe 4 10 1 8 1 1 2 7 9 5
France 11 65 18 40 31 11 6 54 49 45
Germany 47 159 31 135 39 39 28 140 106 98
India 2 7 14 13 5 5 1 14 10 11
Indonesia 2 5 3 10 0 4 4 5 3 4
Italy 13 42 23 34 13 12 21 31 30 31
Japan 0 16 3 8 0 4 2 12 5 4
Middle East 1 13 9 15 2 10 3 10 12 5
Netherlands 4 15 9 8 3 1 2 14 6 16
Philippines 0 10 4 13 0 7 3 6 5 6
Poland 3 18 9 20 6 15 6 18 13 4
Russian Federation 8 20 11 15 7 5 5 30 14 7
S&W Asia 3 5 3 13 1 6 3 11 3 2
Spain 5 15 5 20 8 4 4 11 14 20
Sweden 0 11 2 5 6 0 2 7 9 6
Switzerland 5 16 11 17 1 4 6 12 17 11
Ukraine 4 13 8 11 0 3 3 17 12 1
United Kingdom 7 73 14 32 20 8 15 55 28 40
United States 13 127 45 82 27 24 26 88 85 71
51 248 100 208 67 75 57 210 175 157
Raw
sentiment_priorities.csv
We can make this file beautiful and searchable if this error is corrected: It looks like row 2 should actually have 1 column, instead of 3 in line 1.
region task 1 task 2 task 3
Africa-angl Outreach to Local Chapters and Communities Stability of the core infrastructure (hardware, software, human capital) Fund-raising
Africa-rom Fund-raising Stability of the core infrastructure (hardware, software, human capital) Outreach to Local Chapters and Communities
Americas Stability of the core infrastructure (hardware, software, human capital) Outreach to Local Chapters and Communities Fund-raising
Australia Stability of the core infrastructure (hardware, software, human capital) Takeover protection Outreach to Local Chapters and Communities
Austria Stability of the core infrastructure (hardware, software, human capital) Takeover protection Fund-raising
Belarus Stability of the core infrastructure (hardware, software, human capital) Fund-raising Takeover protection
Belgium Stability of the core infrastructure (hardware, software, human capital) Takeover protection Outreach to Local Chapters and Communities
Brazil Stability of the core infrastructure (hardware, software, human capital) Fund-raising Recruitment for Working Groups
Canada Stability of the core infrastructure (hardware, software, human capital) Takeover protection Fund-raising
China Stability of the core infrastructure (hardware, software, human capital) Attribution guidelines Fund-raising
EAsia/Oceania Stability of the core infrastructure (hardware, software, human capital) Fund-raising Takeover protection
EU Stability of the core infrastructure (hardware, software, human capital) Takeover protection Outreach to Local Chapters and Communities
Europe Stability of the core infrastructure (hardware, software, human capital) Outreach to Local Chapters and Communities Takeover protection
France Stability of the core infrastructure (hardware, software, human capital) Takeover protection Outreach to Local Chapters and Communities
Germany Stability of the core infrastructure (hardware, software, human capital) Takeover protection Fund-raising
India Stability of the core infrastructure (hardware, software, human capital) Outreach to Local Chapters and Communities Fund-raising
Indonesia Stability of the core infrastructure (hardware, software, human capital) Outreach to Local Chapters and Communities Fund-raising
Italy Stability of the core infrastructure (hardware, software, human capital) Outreach to Local Chapters and Communities Fund-raising
Japan Stability of the core infrastructure (hardware, software, human capital) Takeover protection Outreach to Local Chapters and Communities
Middle East Stability of the core infrastructure (hardware, software, human capital) Fund-raising Takeover protection
Netherlands Stability of the core infrastructure (hardware, software, human capital) Takeover protection Fund-raising
Philippines Outreach to Local Chapters and Communities Stability of the core infrastructure (hardware, software, human capital) Takeover protection
Poland Stability of the core infrastructure (hardware, software, human capital) Takeover protection Fund-raising
Russian Federation Stability of the core infrastructure (hardware, software, human capital) Outreach to Local Chapters and Communities Takeover protection
S&W Asia Outreach to Local Chapters and Communities Stability of the core infrastructure (hardware, software, human capital) Fund-raising
Spain Stability of the core infrastructure (hardware, software, human capital) Outreach to Local Chapters and Communities Fund-raising
Sweden Stability of the core infrastructure (hardware, software, human capital) Takeover protection Fund-raising
Switzerland Stability of the core infrastructure (hardware, software, human capital) Takeover protection Fund-raising
Ukraine Stability of the core infrastructure (hardware, software, human capital) Outreach to Local Chapters and Communities Takeover protection
United Kingdom Stability of the core infrastructure (hardware, software, human capital) Takeover protection Fund-raising
United States Stability of the core infrastructure (hardware, software, human capital) Outreach to Local Chapters and Communities Takeover protection
Stability of the core infrastructure (hardware, software, human capital) Takeover protection Outreach to Local Chapters and Communities
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment