Category: OGF sysadmin

July, 2023, User Statistics for OGF

Here is a detailed user summary data for July. These results are ordered from highest number of objects touched to lowest number. I think number of objects touched (nodes, ways, relations) is a more meaningful way to evaluate user activity than changeset counts, which are highly variable depending on how individual users use available tools to connect to the database (iD vs JOSM, etc).

newflanders 3228 64 396146 1806 331 398283
Arlo 10218 539 224823 11204 367 236394
admin 215 48 188857 3655 1736 194248
Izaland Terramorphing Committee 15584 96 182807 7828 221 190856
UN1TY 2194 179 122649 10758 1099 134506
tars 10312 110 111864 2204 197 114265
Rustem Pasha 4928 12 87252 12534 102 99888
oneofbeatlefan 6427 20 89920 8645 140 98705
Liadrien 17542 48 93313 2216 209 95738
Davieerr 8029 52 94041 1393 43 95477
Geoc3ladus 14788 27 72715 5325 40 78080
Aad 22426 72 61943 3792 363 66098
Imperator 1141 92 55236 4793 332 60361
Glauber 14612 56 53974 5641 66 59681
ratsoff2u 1017 62 45375 7126 2 52503
jl06 18719 26 50507 1732 50 52289
JHolger 26671 31 45172 5388 0 50560
Bixelkoven 16933 30 43390 3193 173 46756
BMSOUZA 954 72 36613 7024 0 43637
Huachachi 15931 79 38691 3690 306 42687
lankusiek 23807 37 38879 1910 37 40826
sergjack 26317 208 35527 5086 69 40682
Toadwart 2322 23 31417 3216 94 34727
J33 26562 29 32794 1523 79 34396
Luciano 294 7 28657 3614 68 32339
sudo91 22243 35 27140 4518 50 31708
Otto Yamamoto 1368 78 25249 2664 9 27922
geoboi 5230 24 26980 598 55 27633
waterstealer 24870 82 24032 2293 34 26359
Juan&don 26552 87 22657 2498 61 25216
Taka 14001 43 22526 2100 332 24958
Enderbyte09 25083 21 23994 923 7 24924
clik 942 61 19527 4044 79 23650
Kalh79 401 54 20025 1900 18 21943
ItsTybear 17286 105 16952 4178 59 21189
elindio23 8153 25 18547 1836 68 20451
Aces California 759 24 16546 3502 22 20070
indyroads 344 48 17086 2831 4 19921
ruadh 2725 33 17877 1870 66 19813
plainoldbread 3272 17 18346 1428 13 19787
Timboh 324 10 18063 920 72 19055
Alexmar983 25870 177 14821 4195 12 19028
Mantan 25551 44 16487 1893 100 18480
wangi 468 4 17302 53 6 17361
MxCo 26119 35 13889 2922 146 16957
Lemuria 26719 145 13754 2833 9 16596
Olejowy 22566 144 12868 2710 13 15591
2amCereal 18270 7 13941 1321 18 15280
joebro 2580 6 14432 834 3 15269
Mie 22733 18 13863 1330 63 15256
kengoman 24572 14 12833 2151 95 15079
Z11 10855 28 13519 1253 81 14853
SSSACFGOOMA 25172 4 14811 37 1 14849
Reviriegu 25104 37 12312 2097 22 14431
Aiki 2336 32 11389 2069 342 13800
BDoyle 17873 40 11618 2048 0 13666
ThePhrogianOverlord 25594 29 11776 1533 15 13324
Charlie 26149 18 11434 1623 46 13103
forkymapper 14790 8 12454 368 2 12824
Pav 12292 95 10545 1762 33 12340
raxx 25343 93 8488 3544 1 12033
Singapura-Oriental 21382 54 10032 1805 27 11864
Pawl 1294 68 8420 2624 686 11730
Y Knott 1158 67 10724 770 52 11546
awesomeboy123 21391 28 8924 2443 3 11370
Dfltcher2 24710 29 9373 1940 7 11320
ifgus 4790 8 10783 523 8 11314
Icefur2 22747 42 9448 1722 9 11179
varnel_maiser 6691 28 10403 742 22 11167
Brunanter 1761 62 9840 1223 76 11139
gannman 2405 5 10692 419 0 11111
doomd10 26347 15 8367 1875 4 10246
Sweetykid 25913 50 8051 2064 81 10196
P Gaillard 25179 11 9310 691 41 10042
oicram 2930 72 8139 1633 0 9772
BelpheniaProject 1020 4 9576 166 0 9742
Myrcia 1630 8 7995 1710 6 9711
SAICO192 25445 21 8521 1017 1 9539
coshatiuav 18421 2 9232 97 0 9329
DanDo 25243 26 7557 1563 3 9123
CaribbeanIslandMapper 25002 112 7729 1022 157 8908
NorthTeaPower 14030 48 7349 1364 13 8726
Hilsonbergman 6375 5 7875 719 16 8610
AnimationSky 23612 19 7484 1052 42 8578
alessio2243 26462 39 7495 1027 2 8524
Zytik 13652 49 7093 1095 110 8298
NESW 25372 29 6789 1423 8 8220
Ghostizard 19299 30 6604 1587 8 8199
infinatious 12340 26 6566 1593 9 8168
MrArsalan 26711 127 6118 1842 3 7963
tasmeni 26450 25 6620 1224 6 7850
Reece202 1514 11 6889 802 42 7733
tparigo 1747 10 6101 1603 19 7723
Sarepava 239 19 6627 1083 4 7714
Rasmus Rasmusson 1139 56 6820 823 7 7650
Legoman 26243 27 6053 1378 3 7434
ante44 1822 12 6194 1187 20 7401
Martinawa 11407 17 6555 473 19 7047
Alfred 14361 44 5555 1159 1 6715
super_empath 25865 8 5501 1164 1 6666
Leowezy 1267 22 5977 652 3 6632
faru 24926 8 5586 1008 0 6594
Fluffr_Nuttr 6846 8 5780 680 25 6485
Γιάννης 4 2275 37 4994 1373 42 6409
QuartzSpoonOGF 26623 31 4964 1228 0 6192
Boge 224 12 5753 328 3 6084
NM$l 25192 34 5228 786 37 6051
PortCal 1477 40 5132 785 16 5933
anjn 24787 23 4437 1212 0 5649
Bulest 26434 32 4154 1423 0 5577
Poissott 26695 31 4356 797 4 5157
Vay 15996 5 4631 519 4 5154
roadyote 14592 29 4238 906 0 5144
confusedtoad 25218 18 4465 583 3 5051
Oriolet 4764 134 4091 903 0 4994
ethanxman 2516 6 4153 520 0 4673
yoyo21 1559 6 4528 98 7 4633
Paul Pfh 23089 45 3859 606 28 4493
cartographersurgeon 25890 38 3430 976 19 4425
beclabito 25726 11 3746 629 0 4375
Infrarrojo 9678 11 3396 944 0 4340
Christiaan de Vries 1228 58 3272 1037 6 4315
Ūdilugbulgidħū 1602 3 4136 37 27 4200
curiomap 11647 51 3181 956 0 4137
Patrikki 25710 26 3465 661 0 4126
Crarji 22595 13 3717 373 0 4090
sude 15789 25 3341 597 131 4069
DT_Planner 25648 14 3743 227 55 4025
anakes 1510 7 3629 373 0 4002
thermo_nuclear 2386 10 3428 522 11 3961
chazeltine 7402 18 3485 346 9 3840
Yuanls 1459 28 3532 278 2 3812
skquinn 1192 105 2716 1064 5 3785
LemonKing 8378 11 3095 618 0 3713
RobertTBS 26656 23 2887 809 6 3702
acv 24879 5 3415 199 1 3615
Stephenplays 7055 27 2941 645 7 3593
ElefantMapper 25653 15 3350 184 1 3535
jjrc1996 20575 2 2818 590 1 3409
ADB52 4597 24 2975 275 8 3258
theCubic 24412 1 2962 288 8 3258
Gubble 2713 4 2420 706 1 3127
MiLorde 26648 22 2530 547 43 3120
ParAvion 3527 5 2873 236 4 3113
pablopilar 875 9 2449 611 0 3060
antoon 217 4 2087 726 0 2813
fauxcartograph 2348 14 1953 857 0 2810
Arq635 24043 11 2591 217 2 2810
Kokerey 14213 12 2169 626 0 2795
cheakshibe 26049 27 2279 489 0 2768
ciaosamuu 24620 10 2399 288 1 2688
First3h 26597 15 2259 405 3 2667
deltanz 1438 15 2259 380 0 2639
TGSpace 25394 12 2043 559 11 2613
Stara Zagora 2514 7 2283 258 12 2553
bootmii 2615 16 1951 548 0 2499
kotnaoborot 26417 8 2138 219 1 2358
Chan Yun Kai 12958 10 1921 416 0 2337
sosa 16936 28 1862 447 0 2309
seasvnz 25153 7 2049 240 0 2289
Fayaan 18131 53 1557 685 37 2279
AmusingSage2454 25347 2 2220 41 0 2261
Le Mathou 790 35 1844 353 36 2233
cya 26130 12 1879 288 1 2168
MarcustheMapper 13156 23 1763 339 0 2102
JustSomeMapper 26026 8 1863 237 1 2101
pdplm 6697 21 1311 553 22 1886
WoW 25408 4 1431 440 2 1873
t833 19093 13 1395 455 0 1850
le créateur 26688 34 1341 428 3 1772
Jonesboro 14995 22 1522 180 13 1715
Mahita 20854 20 1391 295 7 1693
Anonymous21 23682 11 1195 464 1 1660
sjk23 23494 1 1500 149 3 1652
vjekoslav95 26587 16 1516 101 1 1618
Lithium-Ion 22476 5 1429 180 8 1617
Nikos 25999 12 1240 352 0 1592
AmpereBEEP 23019 7 1370 213 1 1584
TheMayor 14026 9 1090 442 16 1548
noncertifiedbruhs 22665 6 1281 262 0 1543
Vybranium 26206 8 1041 492 1 1534
Easky30 18 4 1284 219 0 1503
Karlchen 21635 2 1215 223 33 1471
Inkwinter Ye 25597 9 1062 281 0 1343
Koziu 24578 4 1039 302 1 1342
r23 26718 25 1041 275 24 1340
JJat 26743 18 916 423 0 1339
KTheBritMC 19188 6 1115 195 0 1310
Picard-Lindelöf 15483 3 1035 214 8 1257
trabantemnaksiezyc 2161 13 861 300 3 1164
mlnxy090326 26664 61 723 408 0 1131
mikumikumapper 25619 2 931 185 2 1118
Sortsdam 25841 13 967 145 2 1114
tistou26 22201 6 836 230 0 1066
koka_kola 26730 8 836 182 19 1037
diamantschiff 11298 14 713 258 10 981
Sparrow7 26685 20 860 66 0 926
Mike’s World 14591 5 765 159 0 924
jba487_14 6326 15 706 185 0 891
CrisChoky 18079 2 813 45 0 858
johnnyjohnnyyespapa 26739 3 762 93 0 855
CharlieG 4058 1 813 33 0 846
nehalem501 8554 9 697 125 0 822
blz 24720 9 531 251 0 782
JSanchez 253 4 665 110 0 775
elabo 1434 14 560 164 0 724
ellocomigue 10830 3 596 80 0 676
Abdy 18677 4 542 132 0 674
Roro54 26626 14 568 89 0 657
tothr 18890 17 586 42 12 640
Alessa 2664 7 469 122 38 629
快乐的老鼠宝宝 24171 19 524 89 6 619
LukeyBear 26686 10 512 74 0 586
Mattlas 17336 4 417 160 4 581
leotherocketman 26478 9 450 98 0 548
mic8per 25957 1 436 92 0 528
Duncan 18635 3 298 220 1 519
mapper941 25228 2 404 78 0 482
Marcello 3254 9 402 67 0 469
fngf3501 25280 1 409 59 0 468
UnitedPhzl 26658 4 359 92 0 451
iiEarth 12233 5 322 101 9 432
allenpatrick 26556 6 388 43 0 431
Thomas 26709 11 364 62 1 427
MKH1020 25447 3 325 55 0 380
KameKaza 25617 1 344 21 14 379
Eretra 11292 1 314 55 0 369
ayamanao 25630 5 278 73 0 351
CeleronIn 24056 8 284 57 2 343
jak 16 4 179 53 0 232
PaintedBlue 23793 5 190 32 3 225
SurgeonBrake 26727 3 201 23 0 224
snxkei 26670 4 177 45 0 222
kingfries 1956 13 166 41 0 207
coryandulysses 26725 2 132 64 1 197
ezesantillan 2100 7 152 44 0 196
drgtgd 24865 1 168 20 0 188
Ernestpkirby 232 3 145 21 1 167
dsilcott 15620 1 114 48 0 162
otter2714 26548 6 128 28 0 156
kantezakari 24611 1 142 7 0 149
Aaron212 26689 1 124 21 0 145
Arte Onions 26506 1 121 19 1 141
三浦地図 26610 3 124 14 0 138
Fer Jiménez 20466 2 85 46 0 131
Punkmonkey22 20035 2 125 5 0 130
Bienenbrot 22970 1 104 24 0 128
Hbot 1087 2 93 34 0 127
RhodeIslandWV 25253 1 118 5 0 123
VstupZakazan 26735 2 104 12 0 116
Ilthracna 22530 1 104 7 0 111
Greg_Rose 22777 1 93 16 0 109
SwissCrusader 12676 1 93 1 10 104
hanifalhusaini 20879 4 67 27 0 94
mrpeanuts 9055 3 71 18 0 89
georgecg 1504 2 84 4 0 88
trussell2019 17416 1 0 87 0 87
Distel 23033 1 52 31 0 83
Crétin_Dauphinois 25595 1 74 9 0 83
mstr 1973 3 62 16 1 79
bananaman101 25559 2 58 19 0 77
tule00 1405 1 45 26 0 71
oakani 26669 2 55 14 0 69
Tonny 26721 2 61 7 0 68
jemily2 24713 2 34 33 0 67
MylarDaleTolo 26643 1 45 12 0 57
ShavedParm 25749 2 43 13 0 56
ndgid 21484 4 14 24 1 39
Alfredocomm 26624 1 16 21 0 37
reCharged 17492 1 32 5 0 37
Dougieeee 26715 5 17 18 0 35
u5n7 24421 2 25 9 0 34
caillou15 23996 1 16 10 0 26
Bob Lee 18271 2 19 6 0 25
Tamanca 26288 2 18 6 0 24
MRrice 26703 2 18 2 0 20
ChaoticwasTaken 25995 1 15 5 0 20
Canada_LaVearn 22831 1 3 16 0 19
James69UK 13705 1 18 1 0 19
Nudelsuppe42 26181 1 12 5 0 17
Rémi_ 25852 1 16 1 0 17
Floytia 26592 1 15 1 0 16
Azerta 25571 1 10 4 0 14
lil_jumbuck 26717 2 8 3 0 11
The Torontarian 19888 1 9 1 0 10
reivax84 24953 1 3 2 0 5
Eevee 7443 1 3 0 0 3
xioma_sg 8636 1 0 0 1 1

June, 2023, User Statistics for OGF

Here is a detailed user summary data for June. These results are ordered from highest number of objects touched to lowest number. I think number of objects touched (nodes, ways, relations) is a more meaningful way to evaluate user activity than changeset counts, which are highly variable depending on how individual users use available tools to connect to the database (iD vs JOSM, etc).

joebro 2580 42 272841 6949 112 279902
Izaland Terramorphing Committee 15584 92 216087 11904 178 228169
BMSOUZA 954 211 190113 33293 5 223411
Arlo 10218 290 204692 5376 397 210465
EMKLI 17 24 125841 4617 41 130499
Hilsonbergman 6375 59 102485 16504 76 119065
oneofbeatlefan 6427 27 100823 1912 159 102894
Rustem Pasha 4928 11 91285 10026 87 101398
Imperator 1141 135 95921 4249 614 100784
Bixelkoven 16933 41 94164 5810 225 100199
tars 10312 58 65803 1196 161 67160
waterstealer 24870 56 65184 1494 46 66724
Liadrien 17542 36 52016 2414 107 54537
UN1TY 2194 99 46949 2094 91 49134
Geoc3ladus 14788 20 46744 2039 31 48814
Olejowy 22566 179 42627 4168 44 46839
Juan&don 26552 182 39648 5370 36 45054
Glauber 14612 39 41027 3322 36 44385
Mie 22733 44 38842 2484 104 41430
Huachachi 15931 63 34702 5011 154 39867
thermo_nuclear 2386 15 36474 617 44 37135
Otto Yamamoto 1368 73 31643 3738 1 35382
Alexmar983 25870 552 28999 5838 38 34875
Koziu 24578 99 28949 5676 47 34672
Toadwart 2322 33 27716 4794 181 32691
anjn 24787 83 26540 3586 34 30160
P Gaillard 25179 41 27694 2113 88 29895
jl06 18719 49 27770 1894 102 29766
Brunanter 1761 57 25789 2766 80 28635
elindio23 8153 41 24894 3562 18 28474
Fayaan 18131 314 23643 4247 108 27998
newflanders 3228 9 27338 542 111 27991
Pawl 1294 107 21192 4095 2473 27760
Zytik 13652 146 23933 3720 64 27717
Martinawa 11407 30 26802 505 107 27414
Luciano 294 8 21977 4118 21 26116
allenpatrick 26556 124 22391 3473 6 25870
plainoldbread 3272 31 22418 1766 17 24201
lankusiek 23807 22 20793 2639 35 23467
sergjack 26317 94 21381 1854 31 23266
Pav 12292 74 21714 1399 26 23139
geoboi 5230 9 22821 151 36 23008
Crarji 22595 32 22330 473 8 22811
Mantan 25551 70 19046 3222 411 22679
alessio2243 26462 104 19324 2557 2 21883
Enderbyte09 25083 23 18634 1412 9 20055
J33 26562 7 17592 1623 17 19232
Charlie 26149 26 16817 2406 1 19224
kengoman 24572 5 18153 893 66 19112
clik 942 28 17043 1632 6 18681
MxCo 26119 57 14791 3647 106 18544
acv 24879 11 17077 981 3 18061
oicram 2930 190 13117 3662 0 16779
ItsTybear 17286 69 13276 3373 57 16706
Davieerr 8029 67 13955 2136 15 16106
sudo91 22243 37 11563 4442 41 16046
Reece202 1514 5 15504 67 18 15589
raxx 25343 110 11147 4331 0 15478
Aces California 759 56 13096 2291 21 15408
varnel_maiser 6691 25 13997 1144 98 15239
First3h 26597 60 12497 1416 14 13927
ruadh 2725 28 12972 821 53 13846
BelpheniaProject 1020 4 13026 210 0 13236
2amCereal 18270 10 11728 1006 13 12747
Infrarrojo 9678 16 11661 1000 7 12668
AmusingSage2454 25347 8 12571 76 2 12649
Kalh79 401 47 11592 1024 0 12616
Reviriegu 25104 40 9948 1988 4 11940
Timboh 324 11 10104 1632 84 11820
CharlieG 4058 17 10808 975 20 11803
zhenkang 3225 18 10758 914 119 11791
Lithium-Ion 22476 9 11204 419 17 11640
BDoyle 17873 41 9720 1877 0 11597
Dfltcher2 24710 31 8502 2484 3 10989
seasvnz 25153 38 8896 2078 4 10978
Y Knott 1158 46 9141 1820 12 10973
indyroads 344 23 9580 1350 0 10930
Aiki 2336 17 9857 897 85 10839
Crétin_Dauphinois 25595 19 8730 1465 1 10196
MikesonZhang 26601 62 8534 1632 0 10166
jjrc1996 20575 14 8413 1535 2 9950
Myrcia 1630 10 8573 1161 0 9734
Taka 14001 23 7994 1040 156 9190
sude 15789 33 7744 832 39 8615
Alfred 14361 57 7060 1346 5 8411
Yishengjun 26598 56 7227 1045 6 8278
Singapura-Oriental 21382 23 6540 1352 1 7893
Leowezy 1267 26 6665 1188 18 7871
ante44 1822 8 7024 731 1 7756
NM$l 25192 37 6950 684 75 7709
SSSACFGOOMA 25172 11 7590 111 8 7709
CaribbeanIslandMapper 25002 58 6385 529 98 7012
ifgus 4790 14 6504 468 9 6981
Vay 15996 10 5993 811 17 6821
cheakshibe 26049 38 5398 1185 6 6589
tparigo 1747 13 5143 1168 33 6344
Icefur2 22747 22 5238 971 0 6209
Stara Zagora 2514 23 5358 816 31 6205
confusedtoad 25218 47 5006 1120 3 6129
Colombus 25535 23 4680 1302 6 5988
Eretra 11292 2 5508 420 10 5938
Sweetykid 25913 42 4222 1688 20 5930
t833 19093 25 4859 1063 2 5924
Sortsdam 25841 71 4497 1254 32 5783
Lanovkar 26555 22 4932 713 22 5667
Roro54 26626 83 4756 860 2 5618
tasmeni 26450 39 4202 906 6 5114
tistou26 22201 13 4899 190 0 5089
faru 24926 8 4927 151 0 5078
TGSpace 25394 27 4135 926 13 5074
infinatious 12340 11 4442 477 0 4919
deltanz 1438 133 3996 871 33 4900
Intergan 15076 5 4736 100 0 4836
yoyo21 1559 7 4588 195 2 4785
快乐的老鼠宝宝 24171 100 3861 595 258 4714
bananaman101 25559 18 3507 959 8 4474
Fluffr_Nuttr 6846 8 4041 310 3 4354
Ilthracna 22530 13 3288 934 1 4223
xioma_sg 8636 3 2440 1766 8 4214
antoon 217 4 3286 830 0 4116
coshatiuav 18421 2 3957 136 3 4096
cartographersurgeon 25890 31 3149 899 19 4067
vjekoslav95 26587 36 3207 813 11 4031
Rulania 3603 5 3827 178 0 4005
noncertifiedbruhs 22665 17 3270 731 1 4002
curiomap 11647 29 3187 811 0 3998
Bulest 26434 21 3219 744 3 3966
Alessa 2664 1 3565 328 2 3895
samnam 25605 5 3565 312 5 3882
Alejandro24 1811 2 3756 52 0 3808
awesomeboy123 21391 31 2708 975 0 3683
PortCal 1477 19 3061 405 2 3468
Azerta 25571 13 3134 281 3 3418
pablopilar 875 8 2969 358 0 3327
roadyote 14592 26 2681 604 22 3307
Boge 224 35 2547 578 15 3140
amicharski 24799 14 2656 405 9 3070
forkymapper 14790 1 3001 57 0 3058
Distel 23033 17 2328 678 0 3006
Easky30 18 11 2625 361 13 2999
Toad 23441 15 2427 513 8 2948
DT_Planner 25648 9 2640 283 8 2931
ThePhrogianOverlord 25594 4 2637 241 5 2883
Stephenplays 7055 12 2430 416 2 2848
htx 1874 2 2736 54 0 2790
blz 24720 20 1959 797 4 2760
Oriolet 4764 73 2201 478 0 2679
LemonKing 8378 9 2304 366 3 2673
drgtgd 24865 9 2296 303 9 2608
KTheBritMC 19188 16 2234 357 2 2593
Nocom889 26618 6 2342 245 3 2590
America 25550 27 1814 704 1 2519
Jonesboro 14995 38 2090 411 17 2518
TheMapper27 4694 28 2045 369 7 2421
ciaosamuu 24620 7 1939 426 3 2368
Chan Yun Kai 12958 7 1855 466 0 2321
Anonymous21 23682 17 1646 569 25 2240
Legoman 26243 7 1782 442 0 2224
Le Mathou 790 10 2138 58 8 2204
pdplm 6697 28 1481 646 50 2177
Mattlas 17336 4 1779 390 0 2169
ezesantillan 2100 6 1395 708 0 2103
Floytia 26592 17 1837 240 9 2086
Romhfvir 15174 11 1867 205 2 2074
Rasmus Rasmusson 1139 10 1858 208 5 2071
JSanchez 253 19 1753 259 6 2018
Christiaan de Vries 1228 19 1584 396 0 1980
ratsoff2u 1017 18 1472 492 3 1967
The Torontarian 19888 2 1594 162 0 1756
CrisChoky 18079 2 1576 173 0 1749
ellocomigue 10830 13 1486 212 0 1698
django07 25742 2 1419 172 1 1592
gmxr 1125 20 751 802 3 1556
thosehlar 1343 20 1171 325 1 1497
Gonzy 16354 3 1376 89 2 1467
No Way 1463 6 1227 235 1 1463
Z11 10855 3 1213 216 10 1439
tothr 18890 19 1256 138 11 1405
Ouponamap 25585 7 1203 187 0 1390
pzs111111 20225 2 1061 295 0 1356
wangi 468 17 1188 36 11 1235
jxpsert 26590 9 785 438 0 1223
stjur 2533 3 1019 184 12 1215
super_empath 25865 3 766 419 1 1186
waffledogefern 24973 4 1077 106 1 1184
huanfeng 26614 19 939 240 0 1179
Samu_Guasta1 26599 83 871 280 11 1162
Sarepava 239 2 1032 116 1 1149
Portier 15365 3 1098 20 0 1118
GFC 8666 3 815 296 0 1111
Tellis Joseph Frank 26151 12 848 258 0 1106
QuartzSpoonOGF 26623 5 845 246 0 1091
Halvarda 21685 4 973 31 17 1021
三浦地図 26610 19 767 192 0 959
KameKaza 25617 6 862 90 4 956
MarcustheMapper 13156 11 811 134 0 945
skquinn 1192 33 641 261 4 906
mikumikumapper 25619 1 761 139 1 901
ADB52 4597 7 845 42 5 892
james smith the great 26185 4 694 185 0 879
Arq635 24043 2 764 42 0 806
davisonwonghk 19373 13 688 103 0 791
ChaoticwasTaken 25995 1 685 100 0 785
Eduart 26589 2 672 110 0 782
ethanxman 2516 3 612 128 0 740
JustSomeMapper 26026 9 609 129 0 738
AmpereBEEP 23019 6 550 177 1 728
poweikao 12084 1 700 26 0 726
georgecg 1504 10 638 74 0 712
Black Baron 2822 4 666 43 1 710
Dudetri 26581 18 584 100 0 684
chazeltine 7402 6 571 103 4 678
jjmakesmaps 26505 12 580 94 0 674
Paul Pfh 23089 3 516 143 0 659
WoW 25408 2 485 167 0 652
Squizie3 17920 1 432 196 1 629
bou 26632 21 492 123 1 616
Intergalactic 1384 3 536 73 0 609
GamePancakes 1071 5 491 115 0 606
elabo 1434 18 458 147 0 605
MylarDaleTolo 26643 8 416 189 0 605
Kokerey 14213 7 417 175 0 592
iiEarth 12233 6 391 173 6 570
Inkwinter Ye 25597 4 491 55 8 554
Leo 26496 7 448 88 0 536
Ecchi Kei 25847 5 479 50 2 531
Larson 17593 5 408 117 0 525
DanDo 25243 5 420 103 1 524
PowerSculptor 26572 2 414 65 0 479
Trellux 1757 1 453 21 0 474
Karlchen 21635 2 373 85 10 468
ShavedParm 25749 2 397 45 0 442
RhodeIslandWV 25253 1 421 7 1 429
Yuanls 1459 13 313 95 1 409
Sant_at 26420 1 342 67 0 409
julijahaller 15972 6 383 24 0 407
Rhiney boi 16127 2 303 75 15 393
Thaman 26447 2 329 53 0 382
dsilcott 15620 3 316 63 0 379
trussell2019 17416 7 252 106 0 358
nehalem501 8554 2 291 24 0 315
Picard-Lindelöf 15483 1 252 38 3 293
CactiStaccingCrane 25991 3 246 26 0 272
Canada_LaVearn 22831 2 240 31 1 272
Arte Onions 26506 2 240 29 0 269
SwissCrusader 12676 2 227 27 14 268
ScribeHunter 26633 1 228 18 0 246
kotnaoborot 26417 1 221 9 0 230
Mahita 20854 7 156 70 1 227
admin 215 5 16 199 11 226
otter2714 26548 7 145 71 0 216
fauxcartograph 2348 1 171 39 0 210
Bob Lee 18271 5 166 29 0 195
nsenx 26093 1 169 12 0 181
fngf3501 25280 2 154 27 0 181
MarchisioThePal 25969 2 128 47 1 176
Hbot 1087 1 139 28 0 167
CasGroenigenFiction 26594 1 144 16 0 160
Gabry GA 2000 26551 3 146 2 0 148
Vine117 24863 7 93 46 0 139
Alfredocomm 26624 10 77 60 0 137
jak 16 1 112 20 0 132
The_Cute_Chick 9172 2 88 24 3 115
Marcello 3254 2 88 26 0 114
fbmdf1821 25986 1 102 5 2 109
TheMayor 14026 8 37 53 18 108
Scribe29 26568 2 99 4 0 103
mrpeanuts 9055 1 80 19 0 99
Chimune 26566 4 72 27 0 99
kingfries 1956 8 79 15 0 94
sam <3 26608 1 86 8 0 94
leon2396 12003 1 79 6 0 85
ChessesChrist 25903 1 54 20 0 74
Verkkuserkku 25787 6 50 23 0 73
natpeter816 26531 1 61 7 0 68
Eevee 7443 1 56 10 0 66
RicardoNolazcoC 1582 1 51 14 0 65
jemily2 24713 2 36 26 0 62
lewisdoc 26615 2 39 12 0 51
jhody 26593 2 39 9 0 48
OO_Raiser 26617 2 32 15 0 47
IlliaHai 17596 2 41 5 0 46
Mothusi 26640 1 35 3 0 38
ParAvion 3527 1 26 11 1 38
orlPL 25460 2 29 5 0 34
Soboko 8026 4 4 14 14 32
jba487_14 6326 1 23 8 0 31
IiF 26403 1 17 13 0 30
yonah2 25682 1 22 8 0 30
Sarius1997 26402 1 24 4 0 28
Prem 21334 1 13 14 0 27
Isol 19073 1 20 1 0 21
Tamanca 26288 1 14 5 0 19
ndgid 21484 2 16 3 0 19
Wowz 26563 1 10 1 0 11
Fifafo 17964 1 8 2 0 10
Pierater 26399 1 4 2 0 6
MOI N 17119 1 1 1 0 2
ayamanao 25630 1 0 2 0 2
SammyStar 26528 1 1 0 0 1
Turnsole80 1130 1 1 0 0 1
PaintedBlue 23793 1 1 0 0 1

April, 2023, User Statistics for OGF

Here is a detailed user summary data for April (I’ve decided to do these monthly). These are the results, ordered from highest number of objects touched to lowest number. I think number of objects touched (nodes, ways, relations) is a more meaningful way to evaluate user activity than changeset counts, which are highly variable depending on how individual users use available tools to connect to the database (iD vs JOSM, etc).

April, 2023, in OGF

display_name user_id count_changesets count_nodes count_ways count_rels count_objects
joebro 2580 63 480055 8825 54 488934
Izaland Terramorphing Committee 15584 153 320409 12667 360 333436
EMKLI 17 36 266871 15425 119 282415
Geoc3ladus 14788 47 258178 10986 75 269239
Alessa 2664 30 185640 1289 94 187023
oneofbeatlefan 6427 37 139348 16604 78 156030
newflanders 3228 36 116856 1119 155 118130
Martinawa 11407 96 115571 1787 147 117505
Mie 22733 52 104297 4207 87 108591
Rustem Pasha 4928 12 92089 8863 48 101000
thermo_nuclear 2386 59 82281 6497 66 88844
Bixelkoven 16933 36 75630 5177 117 80924
UN1TY 2194 124 64346 7646 62 72054
Liadrien 17542 45 67685 2938 77 70700
BMSOUZA 954 281 64036 6025 0 70061
Alexmar983 25870 900 53465 11954 34 65453
Davieerr 8029 156 61829 2588 116 64533
tars 10312 132 61155 2613 116 63884
zhenkang 3225 44 47553 948 58 48559
Halvarda 21685 77 40859 3756 666 45281
iBallasticwolf2 1355 27 40206 1419 17 41642
lankusiek 23807 28 38905 2611 99 41615
Enderbyte09 25083 61 37020 2475 19 39514
Intergan 15076 22 35122 2416 65 37603
sudo91 22243 62 33276 3690 99 37065
Hijikl 26371 28 30631 5714 24 36369
Fayaan 18131 273 30618 3466 186 34270
gannman 2405 39 31345 1674 10 33029
Eretra 11292 27 27990 3659 59 31708
Taka 14001 44 29149 1718 196 31063
Arlo 10218 53 27520 842 30 28392
Mantan 25551 82 21802 2451 39 24292
Toadwart 2322 31 21751 2220 186 24157
AustinBoath 17528 52 21484 2537 7 24028
Hilsonbergman 6375 25 23276 181 42 23499
Infrarrojo 9678 20 21828 1123 20 22971
sergjack 26317 253 20800 2077 25 22902
ShavedParm 25749 154 18569 3275 18 21862
plainoldbread 3272 22 20398 1352 16 21766
Alfred 14361 62 17313 3907 3 21223
Kalh79 401 75 18609 2434 3 21046
Aiki 2336 24 19631 760 130 20521
indyroads 344 41 18447 633 73 19153
Leowezy 1267 70 15757 3298 31 19086
waterstealer 24870 10 18630 148 26 18804
roadyote 14592 70 15062 3041 40 18143
varnel_maiser 6691 68 16003 1881 168 18052
Glauber 14612 34 15131 2740 74 17945
ruadh 2725 19 15266 2293 64 17623
P Gaillard 25179 35 15254 1468 164 16886
Vay 15996 8 14387 2044 5 16436
ItsTybear 17286 74 13096 3104 25 16225
Pav 12292 48 15022 1037 32 16091
Charlie 26149 28 13247 2604 39 15890
Otto Yamamoto 1368 59 14477 1279 1 15757
CrisChoky 18079 5 14680 812 8 15500
Reviriegu 25104 45 13460 1363 12 14835
Dfltcher2 24710 55 9959 3804 23 13786
jl06 18719 37 12104 1404 71 13579
kengoman 24572 10 10423 1909 87 12419
ifgus 4790 11 10780 1501 2 12283
Gubble 2713 7 10550 1483 0 12033
elindio23 8153 16 10666 1212 16 11894
Icefur2 22747 40 9978 1790 52 11820
CharlieG 4058 15 10809 835 47 11691
jjrc1996 20575 14 9603 1263 10 10876
BelpheniaProject 1020 4 10510 219 1 10730
Legoman 26243 50 8213 2467 0 10680
ante44 1822 11 9427 1003 12 10442
Lithium-Ion 22476 15 9686 739 13 10438
Souzzzzie 26176 59 8911 1287 28 10226
pablopilar 875 38 7966 2173 0 10139
Aad 22426 11 9291 409 3 9703
Sweetykid 25913 59 7755 1910 28 9693
Yongdinghe 26240 11 8852 819 2 9673
Y Knott 1158 49 7797 1813 30 9640
PaintedBlue 23793 74 8436 985 2 9423
super_empath 25865 20 7398 1846 1 9245
AmusingSage2454 25347 7 9021 203 4 9228
chazeltine 7402 27 8473 491 34 8998
津瀬tu 26428 22 7390 1601 0 8991
Imperator 1141 15 7479 1384 23 8886
Aces California 759 45 6577 1762 17 8356
cartographersurgeon 25890 52 6186 2146 16 8348
pdplm 6697 30 6065 1971 74 8110
doomd10 26347 54 6934 1117 6 8057
acv 24879 10 7574 450 9 8033
Crétin_Dauphinois 25595 14 6791 1136 0 7927
Timboh 324 12 6079 1722 110 7911
TheMayor 14026 19 6741 972 19 7732
kotnaoborot 26417 28 7352 328 4 7684
Soboko 8026 12 6968 692 2 7662
ciaosamuu 24620 42 6103 1084 5 7192
tparigo 1747 14 5775 1239 39 7053
2amCereal 18270 3 6174 790 1 6965
bananaman101 25559 59 5478 1277 23 6778
The Torontarian 19888 11 5951 799 0 6750
Bulest 26434 27 5349 1264 9 6622
Olejowy 22566 48 5472 1018 3 6493
Ksawery2137 25270 15 5409 818 0 6227
cheakshibe 26049 48 5094 1077 3 6174
SwissCrusader 12676 2 5346 513 9 5868
ThePhrogianOverlord 25594 15 5003 474 17 5494
Oriolet 4764 194 4433 881 1 5315
antoon 217 4 3063 2124 0 5187
ParAvion 3527 3 5032 116 8 5156
noncertifiedbruhs 22665 22 4071 1023 0 5094
Stephenplays 7055 19 4267 755 6 5028
mikumikumapper 25619 6 4327 306 0 4633
amicharski 24799 14 3823 653 27 4503
TGSpace 25394 25 3874 513 9 4396
ethanxman 2516 11 3461 807 1 4269
nsenx 26093 16 3742 499 0 4241
DanDo 25243 28 3385 827 2 4214
geoboi 5230 11 3425 661 71 4157
Yván 26362 16 3091 1065 0 4156
senju 19525 19 3607 510 16 4133
mic8per 25957 6 2974 1127 0 4101
Fer Jiménez 20466 20 3200 855 4 4059
Schandlers 19534 41 3641 372 34 4047
curiomap 11647 42 2812 1084 0 3896
JustSomeMapper 26026 29 3283 512 17 3812
Sarius1997 26402 31 3340 402 8 3750
Koziu 24578 23 2955 766 9 3730
Ecchi Kei 25847 24 3342 316 5 3663
RicardoNolazcoC 1582 21 3382 197 2 3581
coshatiuav 18421 9 3071 471 22 3564
Fluffr_Nuttr 6846 5 3123 433 1 3557
nejisadd 25152 71 2862 603 4 3469
trussell2019 17416 22 2705 744 2 3451
blz 24720 22 2246 1091 13 3350
Pentagone 26405 20 2603 692 4 3299
Yuanls 1459 74 2663 572 3 3238
Sant_at 26420 9 2641 559 4 3204
yonah2 25682 21 2612 569 0 3181
reCharged 17492 1 2311 813 2 3126
TheSeamonster 25941 51 2604 435 26 3065
yoyo21 1559 6 2873 173 0 3046
Ilthracna 22530 8 2496 439 0 2935
mapper941 25228 10 2631 251 4 2886
Anonymous21 23682 25 2294 415 147 2856
pzs111111 20225 4 2320 502 2 2824
Ouponamap 25585 22 2299 519 2 2820
JSanchez 253 16 2351 451 2 2804
MarcustheMapper 13156 20 2369 405 0 2774
hallowed_embers 24992 2 2111 567 1 2679
nichelyo 19757 4 2142 374 0 2516
Tjitze 25527 11 1998 503 0 2501
ChaoticwasTaken 25995 9 2084 289 1 2374
IlliaHai 17596 45 1876 488 3 2367
Singapura-Oriental 21382 12 2156 173 0 2329
MetroStoryWritter 26416 11 1731 564 0 2295
Qing_Jue 26304 9 1934 307 0 2241
Thaman 26447 16 1950 286 0 2236
Norsborg 10630 6 1864 346 2 2212
PLKartofel 26312 17 1357 671 0 2028
Easky30 18 5 1724 271 0 1995
Tellis Joseph Frank 26151 22 1494 485 7 1986
HostedDinner 1215 3 1612 337 0 1949
maddy-89 24522 5 1458 491 0 1949
Pawl 1294 10 1881 65 1 1947
Bob Lee 18271 6 1676 230 0 1906
MKH1020 25447 7 1585 253 3 1841
Reece202 1514 2 1632 181 0 1813
tasmeni 26450 5 1488 322 0 1810
Crarji 22595 3 1700 31 5 1736
NM$l 25192 10 1517 183 9 1709
ellocomigue 10830 16 1474 228 0 1702
Greg_Rose 22777 7 1601 48 3 1652
theCubic 24412 2 1408 215 2 1625
Brunanter 1761 27 1372 227 6 1605
Myrcia 1630 6 1240 349 2 1591
Rasmus Rasmusson 1139 12 1439 149 1 1589
Pandarius 25827 2 1359 183 0 1542
America 25550 18 1021 514 1 1536
jba487_14 6326 27 1255 229 0 1484
Chan Yun Kai 12958 3 1231 253 0 1484
Tamanca 26288 15 1167 293 0 1460
Aglet 26443 15 1247 184 3 1434
Nikolia 3685 2 1176 175 1 1352
AmpereBEEP 23019 8 1095 211 0 1306
poweikao 12084 2 1149 151 3 1303
Sortsdam 25841 14 1108 131 4 1243
fngf3501 25280 6 1142 95 1 1238
Blocky55 21281 2 1189 28 0 1217
Arq635 24043 6 1013 183 20 1216
drgtgd 24865 7 1039 175 0 1214
ratsoff2u 1017 20 877 310 2 1189
Masyas 26066 2 906 262 0 1168
james smith the great 26185 7 934 219 0 1153
Punkmonkey22 20035 3 970 68 0 1038
Boge 224 9 755 239 0 994
sjk23 23494 5 793 193 0 986
trabantemnaksiezyc 2161 14 659 306 17 982
Jonesboro 14995 18 820 142 2 964
Intergalactic 1384 8 835 99 12 946
faru 24926 1 876 63 0 939
Black Baron 2822 12 805 92 1 898
kingfries 1956 26 757 133 0 890
Savoj 26375 12 796 75 3 874
t833 19093 7 693 169 0 862
PortCal 1477 5 751 102 3 856
Chilver 26440 12 630 177 5 812
georgecg 1504 9 745 52 0 797
raxx 25343 10 557 231 0 788
theruler 12833 2 594 166 24 784
elabo 1434 12 600 164 0 764
KTheBritMC 19188 2 626 133 0 759
Christiaan de Vries 1228 12 588 146 0 734
NocoRoads 25882 7 592 134 2 728
Kokerey 14213 3 638 88 0 726
Vine117 24863 18 514 196 0 710
hornaszenko 26006 4 549 153 0 702
thosehlar 1343 14 510 180 3 693
Eevee 7443 3 655 23 0 678
Qwertyuiop 6884 2 565 106 0 671
Inkwinter Ye 25597 4 551 109 1 661
快乐的老鼠宝宝 24171 18 569 75 12 656
IiF 26403 7 469 181 6 656
skquinn 1192 13 405 235 2 642
jak 16 6 512 110 0 622
Turnsole80 1130 7 497 98 5 600
fbmdf1821 25986 7 543 42 13 598
James69UK 13705 7 533 52 0 585
tule00 1405 4 502 83 0 585
mrpeanuts 9055 5 413 157 0 570
Squizie3 17920 6 487 66 15 568
Vybranium 26206 1 424 131 0 555
shining-k 24800 3 445 102 0 547
wangi 468 27 280 233 28 541
sude 15789 10 159 288 76 523
Distel 23033 1 447 68 0 515
GamePancakes 1071 7 415 64 0 479
Picard-Lindelöf 15483 1 379 99 1 479
diamantschiff 11298 2 393 75 0 468
Mike’s World 14591 3 367 100 0 467
sosa 16936 2 419 40 0 459
AkariChiba 26373 2 383 68 0 451
Le Mathou 790 4 381 46 0 427
NorthTeaPower 14030 6 308 85 13 406
OhioRiverSSA 26088 4 327 78 0 405
Falleret 10964 7 269 123 0 392
Adamwp 26359 3 323 57 1 381
RayMaj7 26427 5 324 57 0 381
nehalem501 8554 4 334 46 0 380
eliaszuo 26396 15 280 88 0 368
iiEarth 12233 4 327 31 8 366
Mauser 25990 5 312 53 0 365
Stara Zagora 2514 2 308 50 3 361
DT_Planner 25648 1 357 4 0 361
TenOndra 26442 4 290 56 0 346
anakes 1510 2 269 68 0 337
BitJules 25397 1 261 61 0 322
htx 1874 2 231 91 0 322
MarchisioThePal 25969 2 237 66 0 303
Brestis 26395 5 224 71 0 295
ADB52 4597 2 267 20 0 287
fauxcartograph 2348 3 223 54 0 277
Revikens 26357 12 246 27 0 273
liam m m 26285 4 221 45 0 266
infinatious 12340 2 211 45 0 256
Ran DB 26318 2 194 59 0 253
GFC 8666 1 167 83 0 250
ByeBye25 26407 1 212 11 0 223
Karlchen 21635 1 122 77 4 203
ItsRiftzy 26432 2 174 27 0 201
Y_Eba 25684 1 181 7 0 188
GEOMaps 7233 1 152 35 0 187
KameKaza 25617 2 159 18 0 177
Ginepro 25716 1 135 36 0 171
ndgid 21484 6 141 27 0 168
Verkkuserkku 25787 2 123 35 0 158
seasvnz 25153 1 118 37 0 155
gıvro 26305 2 116 24 0 140
Bienenbrot 22970 1 118 17 0 135
Luciano 294 5 113 8 1 122
Alejandro24 1811 1 19 99 0 118
John1985 3461 1 84 32 0 116
stjur 2533 3 77 33 5 115
SomersetRoadie 26418 5 73 17 0 90
RedstoneRelic 10456 2 54 25 0 79
JuLn 15225 1 64 12 0 76
Maaaaax 26377 3 53 23 0 76
Jwillkur 26221 1 58 11 0 69
TSR 25078 1 55 5 0 60
bootmii 2615 1 34 17 0 51
Hbot 1087 1 34 14 0 48
mapenthusiast7 10784 1 28 12 0 40
qwarta_L 26364 2 31 4 0 35
helveticanewroman 26358 1 30 3 0 33
Tromero 25942 3 26 3 0 29
venetianlion 26263 1 15 13 0 28
deltanz 1438 2 24 3 0 27
dmeister 26444 1 21 5 0 26
Zoro 25236 1 19 1 0 20
lianotragouda 26430 1 14 2 0 16
camelCaseCo 26431 1 13 2 0 15
Alecc03 26446 1 9 3 0 12
jemily2 24713 1 6 1 0 7
MOI N 17119 1 2 1 0 3
Drogda 15815 2 2 0 0 2
Paul Pfh 23089 1 0 2 0 2
admin 215 1 0 0 2 2
histor 19 1 1 0 0 1
hanifalhusaini 20879 1 0 1 0 1

March, 2023, User Statistics for OGF

Because the January and February reports were popular on the OGFC Discord, I’ve extracted detailed user summary data for March. These are the results, ordered from highest number of objects touched to lowest number. I think number of objects touched (nodes, ways, relations) is a more meaningful way to evaluate user activity than changeset counts, which are highly variable depending on how individual users use available tools to connect to the database (iD vs JOSM, etc).

March, 2023, in OGF

display_name user_id count_changesets count_nodes count_ways count_rels count_objects
joebro 2580 60 406661 7806 71 414538
tars 10312 189 297656 3839 390 301885
elindio23 8153 48 216716 19434 15 236165
Arlo 10218 379 193790 10887 220 204897
Izaland Terramorphing Committee 15584 96 190716 5369 167 196252
Geoc3ladus 14788 50 178794 12146 54 190994
Bixelkoven 16933 34 167439 4473 42 171954
oneofbeatlefan 6427 51 148708 4468 118 153294
Rustem Pasha 4928 11 88781 9960 275 99016
Hilsonbergman 6375 56 80211 16215 119 96545
Liadrien 17542 60 88475 2732 216 91423
Davieerr 8029 292 81844 8815 137 90796
UN1TY 2194 173 80894 8070 336 89300
iBallasticwolf2 1355 51 79625 3215 121 82961
Le Mathou 790 463 64523 5268 426 70217
Alexmar983 25870 798 56000 11906 79 67985
varnel_maiser 6691 112 51930 2969 256 55155
Timboh 324 29 43890 6243 245 50378
Glauber 14612 55 45205 3491 55 48751
CharlieG 4058 15 45746 2536 15 48297
Luciano 294 9 42277 5810 61 48148
Reviriegu 25104 75 44480 2421 0 46901
Fayaan 18131 371 41149 4719 440 46308
Enderbyte09 25083 39 44004 1537 27 45568
ifgus 4790 66 38164 7191 59 45414
Mie 22733 32 42056 1874 38 43968
Taka 14001 67 39542 3140 735 43417
jl06 18719 68 39848 2567 63 42478
Alessa 2664 28 39991 2420 40 42451
BMSOUZA 954 190 38755 2897 3 41655
plainoldbread 3272 26 38399 2403 33 40835
Toadwart 2322 46 33936 3289 308 37533
thermo_nuclear 2386 55 34461 2887 95 37443
Otto Yamamoto 1368 50 32501 4921 1 37423
Legoman 26243 125 24770 6420 1 31191
ruadh 2725 27 25342 3298 41 28681
chazeltine 7402 33 27713 412 61 28186
Halvarda 21685 87 25174 2270 205 27649
Y Knott 1158 96 21601 5521 48 27170
Intergan 15076 11 25900 819 48 26767
ShavedParm 25749 173 22300 2767 32 25099
Vay 15996 14 23745 932 38 24715
Lithium-Ion 22476 48 22111 2234 53 24398
Yongdinghe 26240 23 20899 2777 19 23695
Leowezy 1267 84 20390 2783 69 23242
newflanders 3228 13 22543 499 53 23095
Turnsole80 1130 22 22373 553 71 22997
Imperator 1141 14 22627 226 42 22895
super_empath 25865 27 18112 4391 33 22536
diamantschiff 11298 25 20044 1003 146 21193
2amCereal 18270 9 19898 1112 26 21036
lankusiek 23807 39 18221 2621 16 20858
BelpheniaProject 1020 11 19572 537 4 20113
Infrarrojo 9678 31 17312 1826 28 19166
indyroads 344 27 17354 1215 1 18570
Kalh79 401 74 15867 2137 204 18208
Gubble 2713 14 15155 2276 0 17431
Sweetykid 25913 78 13887 2715 36 16638
Distel 23033 51 13702 2888 0 16590
P Gaillard 25179 24 14839 1371 60 16270
Rasmus Rasmusson 1139 148 12237 2923 4 15164
Mantan 25551 45 13322 1470 13 14805
Rhett McDonald I 25918 79 11416 3089 41 14546
ItsTybear 17286 74 11342 2804 20 14166
Charlie 26149 18 10161 2834 4 12999
shining-k 24800 29 11580 1230 1 12811
Aiki 2336 16 11315 363 127 11805
Pav 12292 78 9835 1066 13 10914
wangi 468 46 10449 253 208 10910
Koziu 24578 55 8728 2027 5 10760
NM$l 25192 28 10050 692 7 10749
NorthTeaPower 14030 55 8990 1657 27 10674
Olejowy 22566 78 8765 1801 33 10599
cartographersurgeon 25890 68 8283 2248 20 10551
sudo91 22243 21 9115 1168 52 10335
CheesyJeb 25950 14 8798 1209 3 10010
jamigg 25347 10 9547 207 0 9754
pzs111111 20225 11 8882 517 40 9439
stjur 2533 8 8813 270 63 9146
oluap 23204 11 8599 286 2 8887
Ping_a_ding 25311 9 7116 1178 0 8294
kengoman 24572 6 6986 1207 20 8213
raxx 25343 78 5535 2631 7 8173
Fluffr_Nuttr 6846 9 7402 470 79 7951
ante44 1822 14 7081 845 4 7930
Sortsdam 25841 90 6218 1552 47 7817
Eevee 7443 44 6512 1240 7 7759
DanDo 25243 35 6785 437 1 7223
ThePhrogianOverlord 25594 14 6429 736 13 7178
PaintedBlue 23793 73 6098 1007 28 7133
Souzzzzie 26176 56 5828 1172 19 7019
AustinBoath 17528 33 5845 855 1 6701
Quint 26279 104 5274 1045 137 6456
Reece202 1514 17 5499 840 56 6395
ciaosamuu 24620 37 5184 1117 10 6311
zhenkang 3225 13 5554 731 16 6301
mapper941 25228 16 5572 710 12 6294
CrisChoky 18079 4 5623 645 2 6270
pablopilar 875 27 4849 1410 0 6259
Aces California 759 56 5031 1179 44 6254
roadyote 14592 41 5008 1240 3 6251
anakes 1510 11 5590 637 0 6227
Tamanca 26288 56 5060 1125 0 6185
t833 19093 27 4961 1171 7 6139
nichelyo 19757 10 5350 619 34 6003
sergjack 26317 119 4958 964 5 5927
curiomap 11647 61 4936 990 0 5926
ethanxman 2516 11 5066 750 1 5817
Vybranium 26206 22 4150 1587 2 5739
Soboko 8026 9 5002 362 3 5367
MarcustheMapper 13156 32 4713 599 0 5312
tparigo 1747 12 4236 999 54 5289
amicharski 24799 10 4774 504 0 5278
America 25550 40 3471 1758 13 5242
antoon 217 4 3010 2228 0 5238
acv 24879 6 5017 169 2 5188
Fer Jiménez 20466 33 4098 1058 6 5162
mikumikumapper 25619 18 4399 701 4 5104
fngf3501 25280 18 4343 481 10 4834
fbmdf1821 25986 27 4512 267 48 4827
快乐的老鼠宝宝 24171 69 4152 467 77 4696
dsilcott 15620 32 3885 709 1 4595
Oriolet 4764 99 3780 809 0 4589
blz 24720 29 3346 1135 20 4501
Huachachi 15931 20 3852 439 77 4368
Tellis Joseph Frank 26151 36 3249 984 38 4271
Anonymous21 23682 52 3194 747 271 4212
Mattlas 17336 17 3398 752 8 4158
Ernestpkirby 232 12 3452 288 6 3746
Mapper89062 24351 25 2955 644 7 3606
Qing_Jue 26304 9 3223 288 0 3511
Crarji 22595 25 3059 248 124 3431
Mike’s World 14591 7 3044 375 0 3419
cheakshibe 26049 30 2806 592 7 3405
Black Baron 2822 19 3154 158 5 3317
JSanchez 253 27 2738 521 2 3261
ratsoff2u 1017 26 1119 2053 6 3178
Brunanter 1761 14 2745 356 40 3141
Dfltcher2 24710 18 2087 929 1 3017
reCharged 17492 2 2455 504 5 2964
JustSomeMapper 26026 21 2363 435 6 2804
lasklajov 13741 19 2138 663 0 2801
Nikolia 3685 2 2158 621 3 2782
Paul Pfh 23089 22 2296 457 1 2754
deltanz 1438 82 2571 139 24 2734
Icefur2 22747 11 2337 378 1 2716
TheSeamonster 25941 58 2028 567 73 2668
Drogda 15815 12 2320 288 5 2613
TheMayor 14026 17 1708 871 18 2597
Martinawa 11407 1 2520 14 2 2536
TGSpace 25394 13 1898 622 7 2527
jjrc1996 20575 21 1950 528 4 2482
DT_Planner 25648 5 2374 75 0 2449
Stephenplays 7055 34 2117 297 9 2423
OhioRiverSSA 26088 9 2015 323 0 2338
Bddfan 26233 30 1509 813 0 2322
PortCal 1477 15 1993 240 6 2239
trussell2019 17416 13 1660 514 0 2174
理塘丁真 25542 6 1804 230 0 2034
drgtgd 24865 9 1824 201 9 2034
theCubic 24412 1 1977 25 0 2002
AmpereBEEP 23019 8 1693 271 0 1964
Arq635 24043 12 1633 283 15 1931
King James III 13047 29 1574 328 0 1902
ChaoticwasTaken 25995 14 1535 352 3 1890
possumbasement 26343 5 1521 343 0 1864
tule00 1405 5 1617 232 6 1855
Rhiney boi 16127 12 1446 334 23 1803
forest_ 26268 4 1253 545 0 1798
Inkwinter Ye 25597 2 1700 90 0 1790
Easky30 18 5 1501 195 4 1700
Fifafo 17964 3 1432 238 19 1689
Jonesboro 14995 37 1219 374 12 1605
Chan Yun Kai 12958 7 1301 292 1 1594
Schmortn34 26278 11 1254 337 0 1591
yoyo21 1559 4 1455 123 1 1579
Boge 224 13 1209 348 0 1557
Masyas 26066 3 1307 230 0 1537
shmaiss 26173 8 1388 146 0 1534
hoodieman1250 26184 19 1080 447 7 1534
Mchcm 26244 12 1257 247 1 1505
The Torontarian 19888 5 1187 314 0 1501
PLKartofel 26312 16 1195 299 0 1494
django07 25742 10 1156 266 0 1422
thosehlar 1343 13 1249 137 7 1393
waterstealer 24870 7 1314 39 11 1364
Mapputaniumist 26202 14 1042 316 0 1358
venetianlion 26263 19 995 339 0 1334
Christiaan de Vries 1228 18 1015 302 0 1317
forkymapper 14790 2 1232 74 0 1306
liam m m 26285 12 1071 214 1 1286
nsenx 26093 4 1139 140 0 1279
_zM 1789 3 1120 115 2 1237
faru 24926 1 946 253 0 1199
Verkkuserkku 25787 15 889 291 0 1180
Intergalactic 1384 1 1084 49 5 1138
ellocomigue 10830 9 909 223 0 1132
skquinn 1192 42 808 314 5 1127
Mauser 25990 17 899 213 0 1112
bananaman101 25559 14 886 214 5 1105
Ejayy 25141 7 782 296 0 1078
seasvnz 25153 5 805 175 1 981
Friedrich does things 26234 34 801 87 0 888
Rulania 3603 1 815 31 0 846
fauxcartograph 2348 6 622 175 0 797
Suettulanti 1390 4 630 162 0 792
KameKaza 25617 8 671 116 0 787
Karlchen 21635 3 558 163 36 757
Washnmachine7 26293 4 622 98 2 722
Schandlers 19534 9 673 47 0 720
Greg_Rose 22777 3 596 71 2 669
iiEarth 12233 6 565 90 1 656
MarchisioThePal 25969 3 525 120 0 645
jak 16 5 534 82 0 616
samstag 24771 6 478 126 1 605
ndgid 21484 6 549 44 2 595
MetroManMelbourne 24420 1 501 68 0 569
Toad 23441 2 468 80 0 548
Portier 15365 2 525 8 0 533
Kokerey 14213 5 430 85 0 515
Y_Eba 25684 8 468 44 3 515
Trellux 1757 1 431 48 9 488
Braddie 24279 1 389 82 0 471
sude 15789 9 337 113 20 470
Ecchi Kei 25847 4 431 16 1 448
pdplm 6697 5 310 137 0 447
Sehentsin 26217 1 423 15 0 438
u5n7 24421 7 308 123 0 431
Tjitze 25527 2 339 84 0 423
Yousernaim 26309 5 379 41 0 420
火箭苦力怕i 25217 2 349 54 0 403
geoboi 5230 6 213 137 46 396
james smith the great 26185 2 327 63 0 390
NvdW1997 25376 1 359 26 0 385
Jappie051 26241 2 338 28 1 367
infinatious 12340 4 264 98 0 362
ezesantillan 2100 2 211 104 0 315
Logan 25956 5 264 42 6 312
GEOMaps 7233 3 251 58 0 309
nehalem501 8554 4 279 26 0 305
Jwillkur 26221 2 285 19 0 304
Duncan 18635 2 239 60 0 299
Bob Lee 18271 4 215 39 0 254
confusedtoad 25218 5 209 39 3 251
htx 1874 1 240 8 0 248
cya 26130 6 196 49 0 245
JPM 26229 6 172 66 0 238
jba487_14 6326 4 164 74 0 238
julijahaller 15972 2 228 6 0 234
leo武 26247 6 169 49 0 218
RicardoNolazcoC 1582 4 189 29 0 218
Gao07 26187 2 167 42 0 209
nejisadd 25152 6 165 33 4 202
kingfries 1956 11 156 41 0 197
DougDommadome 26336 1 152 36 0 188
Picard-Lindelöf 15483 2 123 61 1 185
orion78 1564 5 116 56 0 172
BlooXen 25715 2 150 22 0 172
Mon 26256 2 108 64 0 172
Vinzenz13 26296 4 133 38 0 171
Hello2048440gn0285 23524 2 148 16 0 164
panorrrama 25773 5 114 31 2 147
JuLn 15225 1 130 9 0 139
Kisarazu Funya 26025 4 100 37 0 137
Ouponamap 25585 2 100 28 0 128
Luis Daza 26284 2 82 34 0 116
georgecg 1504 4 91 22 0 113
ixocrito 26222 2 83 28 0 111
augg 26094 1 81 24 0 105
Dan2611 26329 1 84 17 0 101
gıvro 26305 1 74 9 3 86
NocoRoads 25882 1 66 15 0 81
mstr 1973 1 60 17 0 77
yonah2 25682 3 51 26 0 77
admin 215 3 26 41 6 73
Arbhin 25454 2 54 6 0 60
elabo 1434 3 41 12 0 53
malynemec 26280 1 42 9 0 51
matematysek 25477 1 48 2 0 50
Hbot 1087 1 38 7 0 45
Angel Bobadilla 26276 6 25 18 0 43
MonicaE 26273 1 28 9 0 37
leg21 16589 4 9 20 0 29
doomd10 26347 8 15 12 0 27
Marcello 3254 1 22 4 0 26
JBstad1 159 1 24 1 0 25
KAB 20875 5 15 5 3 23
adminbot 23845 2 7 15 0 22
Mari 26266 1 13 8 0 21
sorby 25307 1 16 2 0 18
Rayx 10814 2 8 5 2 15
NotLanoas 22969 1 8 6 0 14
xioma_sg 8636 7 1 1 12 14
Alex0441 20733 1 0 14 0 14
Punkmonkey22 20035 1 11 2 0 13
nabi 26260 1 5 4 0 9
Laura 26271 1 7 1 0 8
yong0315 26111 1 3 5 0 8
El profe Manuel 26237 1 5 3 0 8
jemily2 24713 1 6 1 0 7
Valen 26261 1 3 4 0 7
yeetfictiongeo 26295 1 1 3 0 4
SSSACFGOOMA 25172 1 4 0 0 4
Ralph & Mackey 26242 4 3 1 0 4
eurotec 25948 2 2 0 0 2
tommysilva 26315 1 1 0 0 1
Tahadagal 20218 1 1 0 0 1
Alejandro24 1811 1 1 0 0 1
ClarkStuff 26307 1 1 0 0 1

Meanwhile, in unrelated technical news, the OGF overpass crashed last night. I started out with an ambition to maybe get a new instance of overpass running, with some corrections to the original install configuration to prevent these random segmentation faults from occurring, but I became increasingly frustrated. Overpass is badly documented, and horrendously opaque, and in the end I simply didn’t have the knowledge or patience to do it. So I reloaded (rebuilt) the database in the existing instance, despite all its known problems, and have let it go at that, for now.

If any overpass dev or maintainer happens to read this, just know that I said cusswords about you this morning.

Some user statistics for OGF

I decided to play around more with some queries on the OGF API database.

I extracted detailed user summary data for January and February of this year, and put each month in a separate table.

For January, these are the results, ordered from highest number of objects touched to lowest number. I think number of objects touched (nodes, ways, relations) is a more meaningful way to evaluate user activity than changeset counts, which are highly variable depending on how individual users use available tools to connect to the database (iD vs JOSM, etc).

January, 2023, in OGF

          display_name  user_id  count_changesets  count_nodes  count_ways  count_rels  count_objects
 joebro 2580 115 876127 4925 181 881233
 Izaland Terramorphing Committee 15584 95 272316 4647 261 277224
 oneofbeatlefan 6427 56 229775 8773 144 238692
 Davieerr 8029 229 113578 8576 123 122277
 Rustem Pasha 4928 10 88384 8535 67 96986
 tars 10312 130 76519 2524 142 79185
 Alexmar983 25870 416 62113 12954 323 75390
 mstr 1973 61 58629 12944 20 71593
 Arlo 10218 59 59661 3014 36 62711
 Luciano 294 21 57199 2571 1083 60853
 Lithium-Ion 22476 52 53638 2313 30 55981
 Liadrien 17542 40 53436 1368 115 54919
 BMSOUZA 954 305 44925 9735 18 54678
 sudo91 22243 101 47564 4976 147 52687
 Imperator 1141 23 43743 7746 29 51518
 Bixelkoven 16933 32 46131 1940 99 48170
 coshatiuav 18421 9 44517 161 1 44679
 jl06 18719 73 41748 1363 172 43283
 Reece202 1514 21 39957 943 92 40992
 2amCereal 18270 35 36653 2565 268 39486
 Zytik 13652 20 35123 1292 38 36453
 Glauber 14612 37 32139 4188 27 36354
 Toadwart 2322 38 31485 3022 218 34725
 Distel 23033 103 26942 5645 0 32587
 varnel_maiser 6691 128 26603 3409 176 30188
 faru 24926 23 24446 4997 0 29443
 DT_Planner 25648 43 26843 1385 43 28271
 Masyas 26066 33 23455 4301 43 27799
 Leowezy 1267 61 25397 2157 95 27649
 Aiki 2336 25 26732 404 136 27272
 Fayaan 18131 425 21673 5191 108 26972
 UN1TY 2194 96 23499 3350 25 26874
 newflanders 3228 12 26100 369 50 26519
 BelpheniaProject 1020 14 25435 720 0 26155
 ItsTybear 17286 107 20963 4653 33 25649
 ruadh 2725 44 22597 2676 64 25337
 Ernestpkirby 232 91 22066 2838 32 24936
 Conny879 25434 144 17499 5443 361 23303
 Kalh79 401 40 21758 1104 0 22862
 Sortsdam 25841 271 17933 4105 104 22142
 Y Knott 1158 49 16500 4174 10 20684
 Soboko 8026 27 18132 2058 53 20243
 ifgus 4790 68 16246 2878 52 19176
 Mantan 25551 71 15408 3349 45 18802
 MOI N 17119 11 16858 1234 208 18300
 Halvarda 21685 25 16998 529 36 17563
 Taka 14001 35 14226 2395 191 16812
 Paul Pfh 23089 128 13269 3013 35 16317
 Timboh 324 17 13146 2331 131 15608
 jjrc1996 20575 5 13310 2237 8 15555
 zhenkang 3225 32 14618 661 68 15347
 快乐的老鼠宝宝 24171 190 13270 1763 173 15206
 Anonymous21 23682 62 12030 2925 51 15006
 Geoc3ladus 14788 12 13621 1292 67 14980
 Rasmus Rasmusson 1139 132 10805 3297 7 14109
 Pav 12292 101 12634 1208 77 13919
 SSSACFGOOMA 25172 26 11095 2436 5 13536
 Mie 22733 22 11597 1920 13 13530
 NM$l 25192 70 11657 1592 37 13286
 BDoyle 17873 42 11701 1157 0 12858
 Aces California 759 76 10715 1903 23 12641
 super_empath 25865 20 10414 2119 9 12542
 JustSomeMapper 26026 65 10786 1677 31 12494
 chazeltine 7402 29 11468 784 29 12281
 Gubble 2713 17 10025 1936 6 11967
 Turnsole80 1130 51 9624 2013 155 11792
 Stephenplays 7055 68 9114 2317 7 11438
 PaintedBlue 23793 114 9887 1398 51 11336
 ParAvion 3527 13 10507 756 9 11272
 Brunanter 1761 48 9945 891 89 10925
 ciaosamuu 24620 46 9275 1473 16 10764
 indyroads 344 21 9206 1457 0 10663
 plainoldbread 3272 13 9666 431 2 10099
 lankusiek 23807 9 9191 805 3 9999
 ante44 1822 14 8545 1406 15 9966
 No Way 1463 20 7947 1973 7 9927
 Reviriegu 25104 47 8090 1172 6 9268
 Tahadagal 20218 29 8619 500 40 9159
 pablopilar 875 41 7264 1847 0 9111
 Vay 15996 9 7810 1190 14 9014
 CartographerKing 5562 14 8268 703 18 8989
 Sweetykid 25913 84 7528 1210 12 8750
 Le Mathou 790 5 8199 115 5 8319
 Infrarrojo 9678 14 7305 890 9 8204
 Fer Jiménez 20466 43 6418 1705 0 8123
 jamigg 25347 7 7868 199 3 8070
 tparigo 1747 17 6550 1379 86 8015
 waterbuckey 24951 18 7340 675 0 8015
 tule00 1405 18 7288 544 12 7844
 wangi 468 19 7619 209 12 7840
 Huachachi 15931 28 6474 1249 33 7756
 ThePhrogianOverlord 25594 18 6880 777 4 7661
 mic8per 25957 14 5797 1688 3 7488
 OhioRiverSSA 26088 18 6547 783 4 7334
 Christiaan de Vries 1228 113 5496 1669 13 7178
 curiomap 11647 62 5873 1240 0 7113
 seasvnz 25153 35 5872 1127 49 7048
 Otto Yamamoto 1368 48 6064 701 4 6769
 CrisChoky 18079 8 5836 820 52 6708
 ShavedParm 25749 128 4312 2379 6 6697
 Enderbyte09 25083 14 5995 699 3 6697
 mapeator 25655 20 5955 686 0 6641
 Ecchi Kei 25847 31 5316 1183 28 6527
 Oriolet 4764 144 5400 1083 6 6489
 DanDo 25243 28 5479 924 8 6411
 reCharged 17492 4 5663 733 4 6400
 kengoman 24572 6 4986 1045 26 6057
 Bob Lee 18271 31 5241 762 2 6005
 fngf3501 25280 14 5772 229 2 6003
 Olejowy 22566 37 5274 494 9 5777
 hallowed_embers 24992 10 4826 935 11 5772
 cheakshibe 26049 37 4657 1081 22 5760
 blz 24720 33 3875 1551 12 5438
 Eevee 7443 43 4226 1209 1 5436
 SwissCrusader 12676 6 4296 982 17 5295
 nsenx 26093 38 4236 898 4 5138
 Öllöjoumi 10082 27 4581 420 1 5002
 Alessa 2664 3 4663 330 3 4996
 MarcustheMapper 13156 22 4321 644 0 4965
 htx 1874 8 4314 544 0 4858
 acv 24879 3 4323 436 0 4759
 roadyote 14592 21 4117 583 6 4706
 Intergan 15076 5 4254 338 6 4598
 TheSeamonster 25941 69 3565 967 11 4543
 Marcello 3254 36 3939 548 1 4488
 mapper941 25228 19 3934 415 2 4351
 Deus Omnia 24999 26 3626 595 44 4265
 P Gaillard 25179 6 3816 370 12 4198
 Eshaan011 22496 16 3528 609 17 4154
 stjur 2533 9 3398 737 2 4137
 Fluffr_Nuttr 6846 16 3557 446 20 4023
 Dfltcher2 24710 17 2827 1170 4 4001
 TheMayor 14026 18 3400 578 18 3996
 turtle-bienhoa 26085 3 3867 65 1 3933
 Arq635 24043 7 2870 675 59 3604
 ethanxman 2516 7 2905 605 0 3510
 KTheBritMC 19188 18 3021 465 2 3488
 AnimationSky 23612 2 3266 196 0 3462
 NorthTeaPower 14030 21 3035 380 16 3431
 Easky30 18 11 2813 378 1 3192
 Stara Zagora 2514 17 2589 520 49 3158
 ChaoticwasTaken 25995 29 2316 641 1 2958
 gannman 2405 3 2774 177 0 2951
 shining-k 24800 13 2311 460 0 2771
 cartographersurgeon 25890 20 2095 672 0 2767
 JSanchez 253 23 2026 727 3 2756
 drgtgd 24865 20 2331 398 26 2755
 PortCal 1477 34 2391 325 7 2723
 Jarrodcamo 11452 5 2113 441 0 2554
 BillionPenny 26055 8 1942 462 2 2406
 antoon 217 4 1907 378 0 2285
 mikumikumapper 25619 7 1818 433 0 2251
 iJustLeyxo 24937 10 2076 162 7 2245
 elindio23 8153 11 1820 395 4 2219
 KameKaza 25617 9 1986 219 0 2205
 geoboi 5230 3 1827 317 46 2190
 Toad 23441 5 1934 241 4 2179
 Martinawa 11407 7 1443 553 143 2139
 Mahita 20854 34 1560 386 66 2012
 Rhett McDonald I 25918 21 1596 384 1 1981
 LunaU 23404 15 1713 250 2 1965
 Tianyi__Miku 26079 7 1810 123 0 1933
 The Torontarian 19888 9 1613 243 0 1856
 julijahaller 15972 15 1679 132 15 1826
 Usa 26113 13 1398 423 0 1821
 MxCo 26119 12 1226 442 39 1707
 Ejayy 25141 14 1325 376 0 1701
 AmpereBEEP 23019 13 1351 333 4 1688
 America 25550 19 1174 452 0 1626
 trussell2019 17416 9 1317 290 0 1607
 Boge 224 10 1299 276 5 1580
 TGSpace 25394 6 1228 288 8 1524
 Ouponamap 25585 15 1255 252 0 1507
 KAB 20875 6 1329 136 2 1467
 Jonesboro 14995 30 1169 252 3 1424
 GFC 8666 4 1064 354 0 1418
 skquinn 1192 60 899 503 0 1402
 t833 19093 23 947 443 4 1394
 pzs111111 20225 2 1112 274 0 1386
 sjk23 23494 7 1071 283 0 1354
 Picard-Lindelöf 15483 3 1284 63 1 1348
 Crarji 22595 16 961 319 0 1280
 Intergalactic 1384 2 1174 86 4 1264
 fbmdf1821 25986 10 1018 192 2 1212
 ellocomigue 10830 11 909 203 0 1112
 thermo_nuclear 2386 2 1070 38 1 1109
 GamePancakes 1071 8 837 239 0 1076
 iiEarth 12233 7 857 158 9 1024
 lmills29 25896 4 848 106 1 955
 frefromwig 26062 4 839 95 0 934
 mariusvnh 17201 13 850 81 0 931
 yong0315 26111 10 713 215 0 928
 Mapper89062 24351 4 680 221 10 911
 xioma_sg 8636 3 751 132 5 888
 HostedDinner 1215 1 754 104 1 859
 pdplm 6697 10 581 243 2 826
 Black Baron 2822 33 552 174 92 818
 suburbandecay 19215 1 755 58 0 813
 adminbot 23845 1 29 763 0 792
 poweikao 12084 1 748 39 0 787
 Jacko-Recio 24753 3 653 112 0 765
 Sloyment 26087 13 555 182 0 737
 Mike’s World 14591 1 649 75 0 724
 Tjitze 25527 3 598 108 0 706
 idmdvan93 26063 7 551 153 1 705
 waffledogefern 24973 2 630 59 0 689
 mt_CSC 22340 4 528 145 2 675
 elabo 1434 13 510 156 0 666
 Mawoka 26074 25 414 198 0 612
 dsilcott 15620 2 482 74 0 556
 Squizie3 17920 1 522 31 0 553
 Scotty129 26030 69 40 506 0 546
 Yuanls 1459 20 402 111 0 513
 Trellux 1757 2 469 25 10 504
 NocoRoads 25882 5 427 59 1 487
 nehalem501 8554 6 411 73 0 484
 bautyechev_ 26035 2 450 20 0 470
 django07 25742 1 428 42 0 470
 jba487_14 6326 10 359 108 2 469
 infinatious 12340 5 343 92 0 435
 Hasdrubal Sauradan 8881 7 395 30 0 425
 thosehlar 1343 3 324 78 1 403
 georgecg 1504 4 292 108 0 400
 bananaman101 25559 10 296 90 0 386
 Ilthracna 22530 1 240 134 0 374
 jak 16 9 336 35 0 371
 James69UK 13705 5 313 51 0 364
 Jōvīst 6964 10 290 64 0 354
 Ping_a_ding 25311 1 298 51 0 349
 waterstealer 24870 1 316 16 4 336
 augg 26094 3 270 62 0 332
 GullibleMappazoi 26078 5 248 61 0 309
 joschi81 4 2 255 44 0 299
 Alfred 14361 3 225 64 0 289
 Slam4 26091 5 260 27 0 287
 Duncan 18635 3 195 91 0 286
 AndrewNuzha 19082 4 253 30 0 283
 JuLn 15225 4 268 12 0 280
 Taksine 26047 8 189 84 0 273
 Verkkuserkku 25787 5 205 63 0 268
 lucko 25878 2 202 32 0 234
 amicharski 24799 3 184 41 0 225
 Le Solognot 25893 1 180 44 0 224
 Das 26067 8 147 64 0 211
 rickymex 24708 3 139 53 0 192
 fauxcartograph 2348 3 148 38 0 186
 S2SA 26070 4 165 16 0 181
 kingfries 1956 12 127 50 0 177
 theruler 12833 1 123 39 3 165
 Drogda 15815 5 124 36 3 163
 trabantemnaksiezyc 2161 1 111 36 1 148
 Gustavo Rocha 26050 1 120 13 0 133
 forkymapper 14790 2 82 36 0 118
 orion78 1564 5 99 17 0 116
 Gonzy 16354 3 63 44 0 107
 Arbhin 25454 2 83 22 0 105
 APP6A 14811 1 97 6 0 103
 dfmeow 25033 1 79 8 0 87
 deltanz 1438 4 57 21 0 78
 RhodeIslandWV 25253 2 54 21 0 75
 formamamat 26045 1 45 19 0 64
 Hello2048440gn0285 23524 1 57 4 0 61
 3236cuber 26104 2 51 3 0 54
 orlPL 25460 1 42 8 0 50
 dragonaut88 24934 4 46 2 0 48
 jemily2 24713 2 37 7 0 44
 ndgid 21484 2 29 8 0 37
 GFS 26028 1 24 9 0 33
 LELAION 26075 2 25 7 0 32
 RH9 22241 3 26 3 0 29
 Kisarazu Funya 26025 1 21 8 0 29
 Knocko 25891 1 20 9 0 29
 ADB52 4597 1 6 10 1 17
 Fried Bananas 25949 2 7 4 0 11
 哈布斯堡的忍之助 25899 2 7 2 0 9
 japyeong131 26121 1 3 1 0 4
 AtlanticIsles 25943 1 2 1 0 3
 tom the windows man 26097 1 1 0 0 1

February, 2023, in OGF

          display_name  user_id  count_changesets  count_nodes  count_ways  count_rels  count_objects
 tars 10312 223 226412 5408 432 232252
 elindio23 8153 70 206437 21622 59 228118
 Luciano 294 39 185353 33494 435 219282
 Izaland Terramorphing Committee 15584 108 119642 8916 269 128827
 joebro 2580 21 109041 2269 66 111376
 Liadrien 17542 73 106470 3917 231 110618
 Huachachi 15931 135 96693 8655 337 105685
 oneofbeatlefan 6427 33 90789 10304 78 101171
 UN1TY 2194 135 75821 12728 51 88600
 Bixelkoven 16933 44 76985 5504 237 82726
 Rustem Pasha 4928 10 69934 8182 62 78178
 Alexmar983 25870 472 61442 13307 159 74908
 Davieerr 8029 134 56989 4707 74 61770
 varnel_maiser 6691 107 58645 2900 154 61699
 jl06 18719 61 53376 1660 73 55109
 Geoc3ladus 14788 18 50946 1499 26 52471
 Toadwart 2322 38 47187 4923 298 52408
 Le Mathou 790 56 50694 1535 55 52284
 ifgus 4790 52 44151 4541 42 48734
 Fayaan 18131 326 37778 4004 209 41991
 Mie 22733 47 37411 2996 410 40817
 Halvarda 21685 56 39084 1333 106 40523
 thermo_nuclear 2386 45 35603 1975 84 37662
 Distel 23033 101 30770 5951 3 36724
 Timboh 324 24 31161 4250 394 35805
 chazeltine 7402 34 34899 736 70 35705
 Hilsonbergman 6375 15 33146 1851 64 35061
 ItsTybear 17286 103 20089 5188 43 25320
 Anonymous21 23682 75 23488 1051 331 24870
 eleinads 6085 120 19619 4688 16 24323
 Leowezy 1267 78 20410 3529 47 23986
 ShavedParm 25749 246 19331 4117 49 23497
 Glauber 14612 41 19465 3597 63 23125
 ante44 1822 20 21636 1476 9 23121
 Gubble 2713 17 18453 3408 14 21875
 Mantan 25551 67 19525 2277 43 21845
 Arlo 10218 23 20943 583 59 21585
 Rasmus Rasmusson 1139 180 15133 4144 9 19286
 Vay 15996 21 16327 2600 60 18987
 forkymapper 14790 5 18429 179 24 18632
 sudo91 22243 27 16132 2353 44 18529
 iBallasticwolf2 1355 22 17362 1146 3 18511
 PaintedBlue 23793 77 17116 1138 31 18285
 NM$l 25192 117 14661 3296 92 18049
 Sweetykid 25913 70 14240 3204 20 17464
 Infrarrojo 9678 33 15310 1449 17 16776
 Pav 12292 113 14592 2021 14 16627
 Lithium-Ion 22476 20 14866 1149 52 16067
 Zytik 13652 5 15828 41 11 15880
 MxCo 26119 70 10681 4049 79 14809
 super_empath 25865 30 11535 2855 24 14414
 plainoldbread 3272 13 12895 1268 3 14166
 Enderbyte09 25083 22 12752 1198 37 13987
 2amCereal 18270 8 12390 1347 91 13828
 jjrc1996 20575 39 11472 2225 10 13707
 indyroads 344 39 11814 1721 11 13546
 lankusiek 23807 36 11811 888 8 12707
 Kalh79 401 20 11928 204 26 12158
 Soboko 8026 13 11135 595 0 11730
 Reviriegu 25104 42 10312 1344 6 11662
 kengoman 24572 14 9638 1671 99 11408
 Fer Jiménez 20466 56 9284 2060 7 11351
 Charlie 26149 21 8676 2526 0 11202
 Sortsdam 25841 172 8351 2253 71 10675
 diamantschiff 11298 43 9368 769 22 10159
 Y Knott 1158 278 8228 1597 284 10109
 CrisChoky 18079 2 9652 420 1 10073
 Taka 14001 23 8372 1301 33 9706
 BelpheniaProject 1020 4 8902 344 2 9248
 Paul Pfh 23089 47 8157 1028 47 9232
 Rhett McDonald I 25918 64 6950 1664 12 8626
 Intergan 15076 10 7816 799 8 8623
 No Way 1463 22 6998 1326 22 8346
 快乐的老鼠宝宝 24171 105 7182 995 94 8271
 Otto Yamamoto 1368 35 7180 984 6 8170
 tparigo 1747 17 6297 1401 48 7746
 Stephenplays 7055 54 6408 1320 4 7732
 pablopilar 875 27 5986 1719 0 7705
 shining-k 24800 43 5761 1608 6 7375
 Eevee 7443 36 6329 785 2 7116
 zhenkang 3225 18 6296 739 12 7047
 makiodeblois 23546 44 5772 1249 0 7021
 ruadh 2725 27 6181 628 100 6909
 nsenx 26093 33 5836 953 30 6819
 Aiki 2336 14 5869 639 166 6674
 NorthTeaPower 14030 44 5405 1146 13 6564
 Arq635 24043 19 5817 633 90 6540
 P Gaillard 25179 14 5713 621 14 6348
 mikumikumapper 25619 14 5374 939 15 6328
 MarcustheMapper 13156 26 5538 745 0 6283
 ciaosamuu 24620 29 5301 955 20 6276
 Mapper89062 24351 24 4784 1399 7 6190
 acv 24879 2 5881 272 3 6156
 Masyas 26066 11 4856 1231 17 6104
 jamigg 25347 7 5857 91 0 5948
 poweikao 12084 6 5498 418 17 5933
 faru 24926 5 4297 1624 0 5921
 Dfltcher2 24710 31 4203 1661 0 5864
 mapper941 25228 19 5235 606 4 5845
 TGSpace 25394 17 4735 969 3 5707
 Mapping Expert 17027 8 5099 583 1 5683
 theCubic 24412 1 5550 111 0 5661
 geoboi 5230 9 4958 482 108 5548
 ParAvion 3527 8 4760 578 2 5340
 Reece202 1514 8 4715 427 48 5190
 DanDo 25243 16 4388 552 39 4979
 Ernestpkirby 232 19 4568 393 1 4962
 yong0315 26111 28 4051 380 0 4431
 cheakshibe 26049 52 3793 619 12 4424
 Souzzzzie 26176 18 3684 587 4 4275
 TheSeamonster 25941 81 3383 811 42 4236
 America 25550 34 2945 1255 21 4221
 Mike’s World 14591 5 3956 260 0 4216
 JustSomeMapper 26026 33 3417 746 13 4176
 cartographersurgeon 25890 35 3097 1053 7 4157
 james smith the great 26185 27 3286 746 22 4054
 OhioRiverSSA 26088 14 3537 406 2 3945
 sjk23 23494 9 3275 618 0 3893
 PortCal 1477 30 3176 698 4 3878
 gannman 2405 8 3384 421 0 3805
 curiomap 11647 38 2921 854 0 3775
 Sloyment 26087 39 2918 702 29 3649
 理塘丁真 25542 8 3110 400 4 3514
 AmpereBEEP 23019 21 2653 819 22 3494
 roadyote 14592 15 2755 542 0 3297
 Oriolet 4764 97 2637 557 1 3195
 Christiaan de Vries 1228 62 2265 915 4 3184
 antoon 217 3 1828 1204 0 3032
 Fluffr_Nuttr 6846 2 2917 87 2 3006
 Imperator 1141 1 2904 17 5 2926
 TheMayor 14026 14 2398 494 21 2913
 tistou26 22201 12 2523 338 2 2863
 Öllöjoumi 10082 34 2370 486 4 2860
 cya 26130 28 1992 850 12 2854
 Ping_a_ding 25311 5 2311 522 0 2833
 KTheBritMC 19188 10 2276 477 0 2753
 ethanxman 2516 2 2368 222 0 2590
 Lyriax 14982 10 2266 275 1 2542
 SwissCrusader 12676 3 2138 333 4 2475
 dsilcott 15620 19 1777 587 2 2366
 23Hubin 25761 17 1715 636 0 2351
 trussell2019 17416 24 1677 638 0 2315
 Nikolia 3685 3 1965 331 0 2296
 mrelpa 26140 7 1863 415 3 2281
 drgtgd 24865 11 1947 315 1 2263
 Gao07 26187 12 1788 456 1 2245
 Vybranium 26206 12 1718 479 0 2197
 stefano20p 25821 4 1887 278 0 2165
 Mapputaniumist 26202 20 1552 564 0 2116
 Alfred 14361 7 1638 386 0 2024
 NvdW1997 25376 8 1810 182 2 1994
 The Torontarian 19888 8 1508 452 0 1960
 Tellis Joseph Frank 26151 26 1406 527 19 1952
 Boge 224 8 1755 167 0 1922
 Suettulanti 1390 11 1578 331 0 1909
 Ejayy 25141 22 1318 586 0 1904
 cloud_francis 26138 7 1396 506 0 1902
 DT_Planner 25648 9 1769 109 4 1882
 JSanchez 253 20 1504 365 9 1878
 Jōvīst 6964 15 1148 683 1 1832
 blz 24720 15 1098 700 1 1799
 Easky30 18 12 1517 209 2 1728
 jba487_14 6326 17 1278 440 0 1718
 CharlieG 4058 2 1595 67 14 1676
 KameKaza 25617 16 1305 301 14 1620
 hallowed_embers 24992 6 1100 511 0 1611
 Prem 21334 8 1358 250 0 1608
 Black Baron 2822 20 1329 255 6 1590
 Ecchi Kei 25847 11 1359 189 17 1565
 Braddie 24279 4 1255 263 2 1520
 ellocomigue 10830 14 1217 255 0 1472
 xioma_sg 8636 4 1095 332 19 1446
 hoodieman1250 26184 16 1070 345 1 1416
 ElefantMapper 25653 5 1170 124 0 1294
 Canada_LaVearn 22831 6 1157 126 6 1289
 Qwertyuiop 6884 3 1017 204 0 1221
 fivedollarlamp 21982 3 1059 162 0 1221
 ThePhrogianOverlord 25594 4 1083 101 4 1188
 MarchisioThePal 25969 6 979 188 1 1168
 CaribbeanIslandMapper 25002 5 1079 65 6 1150
 KAB 20875 4 878 125 1 1004
 Jonesboro 14995 20 810 167 2 979
 t833 19093 11 741 192 5 938
 Brunanter 1761 11 754 170 0 924
 Martinawa 11407 4 791 117 6 914
 raxx 25343 20 563 291 0 854
 Aces California 759 9 666 178 2 846
 Zoro 25236 3 728 115 0 843
 bhj867 178 3 828 11 0 839
 confusedtoad 25218 7 602 216 2 820
 AnimationSky 23612 2 680 113 3 796
 Logan 25956 8 697 76 17 790
 pzs111111 20225 1 638 144 0 782
 Ūdilugbulgidħū 1602 1 752 2 0 754
 coshatiuav 18421 3 699 50 3 752
 skquinn 1192 29 470 254 2 726
 Verkkuserkku 25787 17 492 182 0 674
 Grif1n30 26198 35 535 114 0 649
 BMSOUZA 954 7 566 69 0 635
 iiEarth 12233 5 548 73 4 625
 Ouponamap 25585 9 430 126 0 556
 Szybki 24519 3 381 164 2 547
 georgecg 1504 11 474 68 0 542
 ChaoticwasTaken 25995 8 335 172 0 507
 Bob Lee 18271 3 425 58 0 483
 elabo 1434 12 356 84 0 440
 fngf3501 25280 3 370 48 0 418
 nehalem501 8554 6 343 74 0 417
 NocoRoads 25882 4 335 67 0 402
 PRASEOD- 26201 1 301 94 5 400
 julijahaller 15972 3 374 21 0 395
 seasvnz 25153 3 318 70 0 388
 BlooXen 25715 7 299 77 3 379
 Tahadagal 20218 1 318 44 13 375
 cellularAutomaton 26146 8 309 60 0 369
 BDoyle 17873 1 316 47 0 363
 Kokerey 14213 4 284 67 0 351
 ayamanao 25630 5 298 34 0 332
 kingfries 1956 20 255 76 0 331
 WoW 25408 1 246 70 0 316
 ratsoff2u 1017 3 259 53 0 312
 moots_126 26103 3 261 50 0 311
 Nudelsuppe42 26181 5 232 59 1 292
 Ilthracna 22530 1 196 90 0 286
 ndi8093 24707 4 184 95 0 279
 FRANK 26144 1 191 80 0 271
 mstr 1973 5 228 5 1 234
 mrpeanuts 9055 5 164 58 2 224
 Inkwinter Ye 25597 1 181 33 0 214
 Mahita 20854 6 123 63 7 193
 NotLanoas 22969 5 141 42 0 183
 andytws 26203 1 155 26 0 181
 Koziu 24578 2 144 16 0 160
 dragonaut88 24934 2 107 18 9 134
 Ossi 25148 2 99 24 0 123
 Arbhin 25454 5 97 24 0 121
 DnaX 26142 1 91 30 0 121
 tule00 1405 2 90 27 1 118
 bootmii 2615 2 83 30 2 115
 ADB52 4597 3 97 13 3 113
 augg 26094 1 83 27 0 110
 CheesyJeb 25950 1 98 11 0 109
 fauxcartograph 2348 1 74 29 0 103
 fedcd 25649 2 75 20 1 96
 arnaudfrance 26145 5 68 22 1 91
 Sarepava 239 1 78 11 0 89
 Hashtags Mappings 25314 1 66 21 0 87
 shmais 26165 2 61 13 0 74
 marsomyx880 26150 6 59 12 0 71
 James69UK 13705 1 69 1 0 70
 Mauser 25990 10 46 23 0 69
 Yamadaic 26183 3 43 17 6 66
 JuLn 15225 1 53 5 0 58
 John1985 3461 2 40 13 0 53
 The_Cute_Chick 9172 1 1 47 0 48
 Gonzy 16354 1 30 18 0 48
 wangi 468 14 3 34 9 46
 Turnsole80 1130 2 40 4 0 44
 Crarji 22595 3 30 13 1 44
 amicharski 24799 2 36 6 0 42
 Delta13 26190 1 22 9 0 31
 Portier 15365 2 22 5 0 27
 Nickollas Matt 25656 1 18 8 0 26
 jemily2 24713 1 18 1 0 19
 bananaman101 25559 1 13 4 0 17
 deltanz 1438 1 15 2 0 17
 Yuanls 1459 1 9 8 0 17
 RicardoNolazcoC 1582 1 15 1 0 16
 jak 16 1 8 2 0 10
 ndgid 21484 1 8 2 0 10
 Miroslav Suchy 26174 1 6 3 0 9
 sude 15789 1 7 1 0 8
 thosehlar 1343 1 0 6 0 6
 gbohflam 26135 1 2 3 0 5
 swoop_hearts6224 26200 1 1 4 0 5
 theruler 12833 1 0 4 0 4
 admin 215 2 0 1 2 3
 Punkmonkey22 20035 1 1 1 0 2
 Knocko 25891 1 1 0 0 1
 u5n7 24421 1 1 0 0 1

Notably, the active user counts for these two months are almost identical, with 279 for January and 281 for February.

For those who are interested in the technical side, here is a sample of  the query I ran on the API database. It’s really quite simple once you get the syntax right.

select
 users.display_name,
 changesets.user_id,
 count ( distinct objects.changeset_id ) as count_changesets,
 sum ( objects.count_nodes ) as count_nodes,
 sum ( objects.count_ways ) as count_ways,
 sum ( objects.count_rels ) as count_rels,
 sum ( objects.count_rels + objects.count_ways + objects.count_nodes ) as count_objects
from ( 
 select 
   changeset_id, 
   count ( node_id ) as count_nodes,
   0 as count_ways,
   0 as count_rels
  from nodes 
  where visible = 't' and timestamp >= '2023-02-01' and timestamp < '2023-02-28' 
  group by changeset_id 
 union select 
   changeset_id, 
   0 as count_nodes,
   0 as count_ways,
   count ( relation_id ) as count_rels
  from relations
  where visible = 't' and timestamp >= '2023-02-01' and timestamp < '2023-02-28' 
  group by changeset_id 
 union select 
   changeset_id, 
   0 as count_nodes,
   count ( way_id ) as count_ways,
   0 as count_rels
  from ways 
  where visible = 't' and timestamp >= '2023-02-01' and timestamp < '2023-02-28' 
  group by changeset_id 
) as objects
join changesets
on objects.changeset_id = changesets.id
join users
on changesets.user_id = users.id
group by
 users.display_name,
 changesets.user_id
order by 
 count_objects desc;

OpenGeofiction Aggregate Active User Data (Since Migration)

I decided to try to brush off some very rusty SQL skills and write a query against the OGF database to find out what our monthly active user counts looked like.

This data can only be compiled accurately for dates since the “migration”, which was in August, 2021. Before that changesets are not properly dated as they were all loaded at once from the old instance (Thilo’s) to the new instance (Luciano’s).

I decided to categorize unique user counts for each month by their “start year” (e.g. a user like myself would be under start year 2014). That way I could also see how old “generations” of users drop off over time.

I started with a nested SQL query, which is basically what I used to do professionally about 20 years ago, but it’s been a while since I wrote raw queries against complex data like this. It comes back fairly quickly though, and this is definitely the result of a little bit of trial and error. I’m working with two tables in the openstreetmap PostgreSQL database: users and changesets. I’m counting changesets by the month they occur and by a breakdown of users by when they started using the OGF site (with a special category for users who are “new” in the month they are active).

Here’s the query I made and ran at the PSQL prompt on the server (these data structures are all public knowledge, part of the OSM specification, so I don’t feel worried sharing it).

SELECT 
 t.changeset_month,
 t.user_first_year, 
 t.new_user_flag,
 COUNT(DISTINCT t.user_id) AS count_users,
 COUNT(t.changeset_id) AS count_changesets
FROM ( 
  SELECT
   i.changeset_id,
   i.changeset_month,
   i.user_id,
   LEFT(i.creation_month, 4) AS user_first_year,
   CASE
    WHEN i.creation_month = i.changeset_month
    THEN 'new_user'
    ELSE 'old_user'
   END AS new_user_flag
  FROM ( 
    SELECT 
     to_char(changesets.closed_at, 'YYYY-MM') AS changeset_month,
     changesets.user_id AS user_id, 
     changesets.id AS changeset_id, 
     to_char(users.creation_time, 'YYYY-MM') as creation_month
    FROM changesets INNER JOIN users 
    ON users.id = changesets.user_id 
    WHERE changesets.closed_at >= '2021-10-01'::date
    AND changesets.closed_at <= '2022-12-31'::date
  ) AS i
) AS t
GROUP BY 
 t.changeset_month,
 t.user_first_year, 
 t.new_user_flag
ORDER BY 
 t.changeset_month,
 t.user_first_year, 
 t.new_user_flag DESC;

Here’s the raw output I got.

changeset_month | user_first_year | new_user_flag | count_users | count_changesets
-----------------+-----------------+---------------+-------------+------------------
2021-10         | 2013            | old_user      |          10 |              112
2021-10         | 2014            | old_user      |          17 |             1098
2021-10         | 2015            | old_user      |          23 |              720
2021-10         | 2016            | old_user      |          24 |              448
2021-10         | 2017            | old_user      |          34 |              787
2021-10         | 2018            | old_user      |          45 |             1088
2021-10         | 2019            | old_user      |          35 |              750
2021-10         | 2020            | old_user      |          28 |              557
2021-10         | 2021            | old_user      |          34 |              492
2021-10         | 2021            | new_user      |          24 |              280
2021-11         | 2012            | old_user      |           1 |                1
2021-11         | 2013            | old_user      |           8 |              207
2021-11         | 2014            | old_user      |          19 |              687
2021-11         | 2015            | old_user      |          26 |              697
2021-11         | 2016            | old_user      |          21 |              408
2021-11         | 2017            | old_user      |          36 |              738
2021-11         | 2018            | old_user      |          41 |             1271
2021-11         | 2019            | old_user      |          29 |              663
2021-11         | 2020            | old_user      |          26 |              749
2021-11         | 2021            | old_user      |          28 |              439
2021-11         | 2021            | new_user      |          23 |              498
2021-12         | 2013            | old_user      |          10 |              335
2021-12         | 2014            | old_user      |          17 |              773
2021-12         | 2015            | old_user      |          23 |              892
2021-12         | 2016            | old_user      |          25 |              657
2021-12         | 2017            | old_user      |          31 |              703
2021-12         | 2018            | old_user      |          43 |             1506
2021-12         | 2019            | old_user      |          29 |              769
2021-12         | 2020            | old_user      |          25 |              664
2021-12         | 2021            | old_user      |          45 |              854
2021-12         | 2021            | new_user      |          22 |              250
2022-01         | 2012            | old_user      |           1 |                3
2022-01         | 2013            | old_user      |           7 |              174
2022-01         | 2014            | old_user      |          13 |             1023
2022-01         | 2015            | old_user      |          22 |              805
2022-01         | 2016            | old_user      |          23 |              568
2022-01         | 2017            | old_user      |          32 |              753
2022-01         | 2018            | old_user      |          39 |             1642
2022-01         | 2019            | old_user      |          30 |             1062
2022-01         | 2020            | old_user      |          30 |              878
2022-01         | 2021            | old_user      |          42 |              703
2022-01         | 2022            | new_user      |          24 |              192
2022-02         | 2013            | old_user      |          10 |              397
2022-02         | 2014            | old_user      |          19 |             1251
2022-02         | 2015            | old_user      |          21 |              768
2022-02         | 2016            | old_user      |          22 |              540
2022-02         | 2017            | old_user      |          30 |             1136
2022-02         | 2018            | old_user      |          41 |             1612
2022-02         | 2019            | old_user      |          25 |              617
2022-02         | 2020            | old_user      |          27 |              888
2022-02         | 2021            | old_user      |          41 |              722
2022-02         | 2022            | old_user      |           8 |              117
2022-02         | 2022            | new_user      |          21 |              234
2022-03         | 2013            | old_user      |           8 |               61
2022-03         | 2014            | old_user      |          17 |             1384
2022-03         | 2015            | old_user      |          25 |              927
2022-03         | 2016            | old_user      |          22 |              705
2022-03         | 2017            | old_user      |          35 |             1498
2022-03         | 2018            | old_user      |          41 |             1211
2022-03         | 2019            | old_user      |          33 |              861
2022-03         | 2020            | old_user      |          30 |             1018
2022-03         | 2021            | old_user      |          38 |             1458
2022-03         | 2022            | old_user      |          13 |              491
2022-03         | 2022            | new_user      |          27 |              758
2022-04         | 2013            | old_user      |           7 |              186
2022-04         | 2014            | old_user      |          17 |              871
2022-04         | 2015            | old_user      |          24 |              500
2022-04         | 2016            | old_user      |          19 |              683
2022-04         | 2017            | old_user      |          30 |             1093
2022-04         | 2018            | old_user      |          39 |             1291
2022-04         | 2019            | old_user      |          29 |              833
2022-04         | 2020            | old_user      |          28 |              673
2022-04         | 2021            | old_user      |          32 |              753
2022-04         | 2022            | old_user      |          25 |              900
2022-04         | 2022            | new_user      |          21 |              231
2022-05         | 2012            | old_user      |           1 |                1
2022-05         | 2013            | old_user      |           8 |              214
2022-05         | 2014            | old_user      |          22 |             1093
2022-05         | 2015            | old_user      |          25 |              526
2022-05         | 2016            | old_user      |          25 |              899
2022-05         | 2017            | old_user      |          28 |             1100
2022-05         | 2018            | old_user      |          40 |             1097
2022-05         | 2019            | old_user      |          30 |              873
2022-05         | 2020            | old_user      |          30 |              673
2022-05         | 2021            | old_user      |          34 |             1328
2022-05         | 2022            | old_user      |          27 |              558
2022-05         | 2022            | new_user      |          30 |              348
2022-06         | 2013            | old_user      |           7 |              249
2022-06         | 2014            | old_user      |          17 |              979
2022-06         | 2015            | old_user      |          26 |              605
2022-06         | 2016            | old_user      |          26 |              593
2022-06         | 2017            | old_user      |          30 |              988
2022-06         | 2018            | old_user      |          39 |              941
2022-06         | 2019            | old_user      |          27 |              985
2022-06         | 2020            | old_user      |          26 |              783
2022-06         | 2021            | old_user      |          36 |              919
2022-06         | 2022            | old_user      |          44 |              606
2022-06         | 2022            | new_user      |          31 |              523
2022-07         | 2013            | old_user      |           8 |               84
2022-07         | 2014            | old_user      |          19 |             1414
2022-07         | 2015            | old_user      |          25 |              630
2022-07         | 2016            | old_user      |          24 |              558
2022-07         | 2017            | old_user      |          29 |             1209
2022-07         | 2018            | old_user      |          39 |             1199
2022-07         | 2019            | old_user      |          27 |              632
2022-07         | 2020            | old_user      |          29 |              796
2022-07         | 2021            | old_user      |          35 |             1082
2022-07         | 2022            | old_user      |          41 |              750
2022-07         | 2022            | new_user      |          38 |              632
2022-08         | 2013            | old_user      |          10 |              165
2022-08         | 2014            | old_user      |          17 |             1236
2022-08         | 2015            | old_user      |          24 |              687
2022-08         | 2016            | old_user      |          25 |              636
2022-08         | 2017            | old_user      |          29 |              961
2022-08         | 2018            | old_user      |          41 |             1145
2022-08         | 2019            | old_user      |          35 |              808
2022-08         | 2020            | old_user      |          25 |              585
2022-08         | 2021            | old_user      |          38 |              847
2022-08         | 2022            | old_user      |          50 |             1049
2022-08         | 2022            | new_user      |          40 |              589
2022-09         | 2013            | old_user      |          10 |              175
2022-09         | 2014            | old_user      |          19 |             1534
2022-09         | 2015            | old_user      |          20 |              604
2022-09         | 2016            | old_user      |          24 |              750
2022-09         | 2017            | old_user      |          23 |              735
2022-09         | 2018            | old_user      |          41 |             1302
2022-09         | 2019            | old_user      |          28 |              841
2022-09         | 2020            | old_user      |          24 |              503
2022-09         | 2021            | old_user      |          30 |              609
2022-09         | 2022            | old_user      |          54 |             1035
2022-09         | 2022            | new_user      |          25 |              261
2022-10         | 2012            | old_user      |           1 |                3
2022-10         | 2013            | old_user      |           8 |              231
2022-10         | 2014            | old_user      |          18 |             1112
2022-10         | 2015            | old_user      |          22 |              433
2022-10         | 2016            | old_user      |          25 |              789
2022-10         | 2017            | old_user      |          25 |              809
2022-10         | 2018            | old_user      |          39 |             1267
2022-10         | 2019            | old_user      |          28 |              895
2022-10         | 2020            | old_user      |          30 |              736
2022-10         | 2021            | old_user      |          27 |              382
2022-10         | 2022            | old_user      |          54 |             1040
2022-10         | 2022            | new_user      |          17 |              173
2022-11         | 2013            | old_user      |           8 |              248
2022-11         | 2014            | old_user      |          16 |             1164
2022-11         | 2015            | old_user      |          22 |              357
2022-11         | 2016            | old_user      |          23 |              675
2022-11         | 2017            | old_user      |          25 |              927
2022-11         | 2018            | old_user      |          37 |              897
2022-11         | 2019            | old_user      |          25 |              702
2022-11         | 2020            | old_user      |          25 |              679
2022-11         | 2021            | old_user      |          25 |              577
2022-11         | 2022            | old_user      |          49 |             1100
2022-11         | 2022            | new_user      |          31 |             1641
2022-12         | 2013            | old_user      |           6 |              317
2022-12         | 2014            | old_user      |          18 |              981
2022-12         | 2015            | old_user      |          23 |              543
2022-12         | 2016            | old_user      |          20 |              541
2022-12         | 2017            | old_user      |          25 |              941
2022-12         | 2018            | old_user      |          34 |              973
2022-12         | 2019            | old_user      |          28 |              935
2022-12         | 2020            | old_user      |          22 |              500
2022-12         | 2021            | old_user      |          29 |              432
2022-12         | 2022            | old_user      |          59 |             1623
2022-12         | 2022            | new_user      |          25 |              317

I plugged these data into a spreadsheet, did a few changes and a pivot table. Here’s a graph of the result.

picture

The top band, in light blue, is the “new users” band – these are users each month who are active in their first month of joining OGF. The lower bands represent each year back to OGF’s founding, in 2012 (there were only 2 users in the first year, Thilo and Joschi).

Based on that graph, I would say really OGF is quite stable. We acquire a certain number of new users each month, we lose about an equal proportion of old users, but some subset of long-term users stick around.

On Castine and its many tribulations

Castine is an imaginary country that once existed on the imaginary planet I prefer to call Ogieff. In fact, the imaginary planet doesn’t have an official name – it’s hosted at opengeofiction.net, which all the users call, simply, “OGF”. That initialism leads to my preferred name for the planet – just sound it out.

There is a real place called Castine – it’s a small town in Maine, USA. This is not that Castine.

I joined OGF in 2014, and Castine appeared and began evolving sometime in the year after that, I think – in 2015. I also became an admin on the opengeofiction.net website in that year.

During the period from 2015 to 2017, Castine became the locus of a kind of meta-proxy-war, where I used it as a stand-in for a never-ending argument I liked to have with my fellow OGF admins.

The issue in question was the rule about “verisimilitude”. I had long felt (and continue to feel) that OGF’s verisimilitude rule is a bad idea – it’s vague and impossible to enforce consistently. It has no objectivity. The principle is that mapping on the OGF world is supposed to be “realistic” in the sense that it eschews fantasy and sci-fi elements, and doesn’t contain cultural or cartographic artifacts that couldn’t reasonably exist in the real world. Hence, people who build 50 km bridges or tunnels are called out for violating verisimilitude, likewise more science-fictional elements like space elevators or fantasy elements like dens of dragons or nations of 1920’s-era talking sheep (all these examples really occurred at various times on the OGF planet).

Castine was (is) a borderline case of violating verisimilitude. Some users felt it violated the rule, others felt it was okay. My position was always something like: “since we can’t decide if this violates verisimilitude or not, but it’s really good mapping… c’cmon, people, let’s drop (or at least, fix) this stupid rule.”

Of course, this was an unpopular stance. And in the long run, I lost the battle to remove or even alter the verisimilitude rule on Ogieff, and I made my peace with it.

One way that I made that peace with it, was to create my own, separate planet! In 2016, I started the planet Arhet as a kind of alternative project to Ogieff. By 2018, it had several active mappers and its own emerging community. The principle concept behind Arhet is to be a kind of “libertarian” reinterpretation of OGF. It has very few rules: no verisimilitude rule, no assigned territories, etc. And somewhat to my own surprise, it sorta kinda works. The key to it working, I reckon, is that unlike OGF, Arhet is not “open” to any and all comers. There’s an application process to join, and although I enforce almost no rules for the planet, I do stand firm that arguments or disagreements between users that escalate to my remit will simply result in immediate banning of all parties. That keeps everyone participating on best behavior, I guess.

The irony is that then, in 2021, I took over the hosting of the original opengeofiction.net. So now I host a little federation of two imaginary planets, Ogieff and Arhet, which have substantially overlapping user communities but having quite different rule systems. And I’m okay about that. I inevitably yield to my fellow admins, whose hard work and dedication to the project I admire, when it comes to matters of rules and judgements on Ogieff. But off to the side, I run Arhet singularly, and I insist on its fundamentally anarchic state.

In around 2020, the creator of Castine (Ramasham) was banned from Ogieff – ultimately for violating another, different rule: the rule prohibiting direct upload of data copied from OSM. OSM is OpenStreetMap, which is a map of the Real World™ in the same technological vein as our two imaginary planets. This is the so-called “slippy map” paradigm, originally popularized by mapquest and perfected and dominated by google maps. OSM runs on and supports a whole complex ecosystem of software that is all open source, as a kind of alternative to google maps, and that’s why it’s easy (uh, “easy” in a financial sense, not “easy” in a technical sense) for us to use the same software to run OGF and Arhet.

Anyway, there is (and there has always been) a rule prohibiting copying OSM data into OGF. Ostensibly this is motivated by paranoia about copyright violation, but in fact copyright has little to do with it, in my own estimation – there are easy ways to avoid issues around copyright as long as you follow along with OSM’s “attribution and re-use” rules. The real motivation for the prohibition is legitimate, though: on OGF, we want to discourage mappers from spamming the planet’s map with cut-n-paste copies of real-world places. It’s low effort geofiction and discourages creativity.

That said, when I set up Arhet I decided to also not enforce OGF’s “no real-world (OSM) data” rule. And indeed I myself played around with cutting and pasting some data from OSM, including an ephemeral instance of country I called “Lingit Aani” (this is Tlingit language) – a copy of the islands of Southeast Alaska but minus any nearby continent, as an open-ocean archipelago. I later deleted this, but there are multiple copy-the-real-world geofiction projects going on in Arhet, these days, including clones of Sakhalin Island (Siberia) and Romania’s Bucharest, and at least two Polands – perhaps more.

I guess Castine’s creator, Ramasham, had been doing some copy-pasting of OSM data to increase the detail and complexity of Castine’s cartography. Notably, this airport is a modified cut-n-paste copy of one in the real world, with only the names of things altered. And so Ramasham was banned from OGF. Rules are rules, and that “no copy from OSM” rule is actually probably the most common reason for mappers to be banned from the site.

Now we come to February of this year (2022). The admin team at OGF, moving to “clean up” various abandoned territories around our (imaginary) globe, decided finally to delete Castine once and for all. And I had a moment of deep sadness and regret. Despite my having leveraged Castine back in 2016 as part of my proxy war with the other admins over the verisimilitude rule, in fact I really, really like Castine.

From a technical standpoint, Ramasham was at best a mediocre mapper. But the imaginary country is full of cartographic whimsy and playfulness, the naming is thorough and inventive and culturally intriguing, and the detail in some parts is quite incredible. I thought it was worth preserving.

So I considered: Ramasham’s ban from OGF was for violating the “No OSM data” rule; if there were any other issues with Castine, they were issues with the “verisimilitude” rule; so… hey – Arhet doesn’t have those rules!

The solution was obvious. I decided I’d move Castine to Arhet. And even more conveniently, the exact latitude and longitude of Castine’s old Ogieff location was open an unused on Arhet. I figured it should be quite easy to simply “cut-n-paste” the whole of Castine into Arhet.

Yikes! This turned out to be the far from the case – it was not easy. Not at all. Castine included almost 2 million distinct GIS objects: nodes, ways, relations. This was not trivial to simply cut, paste, and upload into the new site. And further, the data quality was quite poor, from a technical standpoint. Thousands of improperly stacked ways on shared nodes, hundreds of lazily-crafted or incomplete data relations, etc.

I have spent the last week in a kind of Alice-in-Wonderland nightmare of trying to rescue Castine and upload it to the Arhet planet. I think that as of this morning, that I have succeeded, but not before almost destroying the Arhet server altogether in the process.

Without going into a lot of detail, it seems that there were a couple of relations (a technical term in this case for a type of data object used in OSM GIS software) that were apparently so badly constructed that they broke the server’s database. Since I had to do a kind of trial-and-error search to finally identify these objects, it took a very long time. I’d upload some subset of the full Castine dataset, and watch to see if the database crashed or not. If it didn’t, fine, I’d try another set of data. If it crashed, I’d have to go back to the last backup of the server, restore it, and try again. I think I did a backup-restore cycle maybe 12 or 14 times over the last week on the Arhet server. It was painful, and tedious, and immensely frustrating.

The crash-provoking objects in question are puzzling. I still don’t understand why they crash the database. And given my difficulties in identifying them (and surviving them – see below), I probably won’t spend time, any time soon, trying to figure them out. They are “Giant Chessboards” – three of them. Interestingly, Castine also has other “Giant Chessboards” (e.g. here) that do not cause any kind of data problem. They are apparently implemented differently, in their details.

The problem was compounded yesterday, when, much to my shocked dismay, the server-level backup-restore functionality offered by my hosting provider, Linode – that I’d been so repeatedly abusing – suddenly and inexplicably failed to work.

So for a day (yesterday) the world was Arhetless. The server was down. I was in a panic because it seemed I’d have to fully rebuild the server from scratch. And it was only pure luck that I even had a copy of the map data, because I was still running a kludgey render engine (map drawing process) for Arhet on a different machine.

I wrangled with tech support at Linode, and they finally held my hand (or was it that they held my server’s hand?) through a successful if stressful restoration of the server’s image.

Let’s just say, these days Castine now has a quite colorful meta-history.

I reached out to the creator of Castine, sending an email to the address on record at OGF, announcing its restoration in Arhet. I would absolutely welcome and be pleased if that person would come back and take up work on the country, again – they won’t be constrained by the rules and regulations on Ogieff. Unfortunately I haven’t heard back. I speculate that there might be some bitterness about the whole business of having been first praised and then banned, back a few years ago.

The link to Castine-in-Arhet is here:

https://arhet.rent-a-planet.com/relation/10996

Please feel free to explore. I decided not to bother with adding extensive screenshots for this blog post – the point of having the Castine map hosted on the server is that you can explore easily directly on the website.

Happy mapping.

Music to view geofiction to: Dawg Yawp, “Lost At Sea.”

The State of the OGF Topo Layer

This will be a fairly long write-up, so depending on your interests, you can skip sections that aren’t useful to you.

First I will write about the OGF topo layer, and give a tour of its current status, with some discussion of how it works.

Then in subsequent sections I will try to discuss how to create or edit your own contributions to the OGF Topo layer.

Part I – Introducing The OGF Topo Layer

The term “topo” (short for topographic) refers to a style of map that shows the physical elevation of land, either through shading or drawing contour lines or both. There are many topo renders available for the OpenStreetMap platform. My own favorite for daily use is the Cycle Map layer on OSM – not for any specific reason except that it’s easy to get to – it’s included right there in the layer selector for the OSM site. The best known, however, and one of the oldest, is the separately built and maintained OpenTopoMap. The code for OpenTopoMap is freely available on github.

All the various implementations of topo style for OpenStreetMap rely on the easy availability of free data from the United States’ NASA. This agency did a planet-wide survey of the elevation of all the land in the world on an arc-second (approx. 30-meter) grid, using radar, and published that data, online, for anyone to use. This data is called “SRTM”. Developers implementing OpenStreetMap’s various topo layers are able to download and use this SRTM data to use as a raw source of the detailed topographic information needed to draw the map. So, in the case of OpenTopoMap, the SRTM data is loaded to the render machine, processed in various ways, and turned into the hillshading, contour lines, and map-elevation color shading that we all know and love.

For the real world, getting topo data is matter of launching a spacecraft or satellite with a little radar range-finder on it, and flying over the surface of the earth finding how high each part of the earth is relative to some baseline (i.e. mean high sea level). Easy! But OpenGeofiction is on a fictional planet. To repurprose Virginia Woolf’s famous line: There’s no there, there.

Instead we have to sit down and make up each square of elevation information – there’s got to be a 30-meter square grid for our entire imaginary planet, and we have to invent the elevation for each and every square! And just randomizing this isn’t going to work – real world topographic data betrays the evolved geophysical patterns of our planet, influenced by everything from plate tectonics to vulcanism to erosion to human landscaping. The data is going to have to either be “drawn” by creative human hands, or “drawn” by well-trained machine-learning AI’s. Both are possible in principle, but then we have the data problem.

The data problem is this: the NASA SRTM format was developed for storing real world data. But no one ever thought: we need a nice, user-friendly, SRTM file editor! Why? Because no one needs to edit real-world data. It came from a super-precise scientific gadget, who’s going to need to edit that? They could only mess it up.

So there simply does not exist any easy way to get the “imaginary” SRTM files that we need for our topo layer. Some geofiction genius is going to need to write a converter.

Luckily, OpenGeofiction has such a genius. The original creator of OpenGeofiction, Thilo, wrote a little program that turns a standard OSM XML format file (.osm) that has been filled with hand-drawn contour lines (tagged contour=elevation / ele=nnn) into a pseudo-SRTM format file (.hgt). Then we just need to install the standard OpenTopoMap software on our render server, copy the pseudo-SRTM files across, and voila, topo for OGF!

Still, we have a whole planet to cover. At this point in time (the time of writing this article, early 2022) the overall coverage for OGF’s topo layer is tiny, and of fairly low quality, on average, so far.

One of the main reasons I started my “OGF Mirror” project, last year, was because Thilo had decided he could no longer invest the time and energy required to support the topo layer for OpenGeofiction. I had a strong desire to see the topo layer continue to be supported and expand. Eventually that “OGF Mirror” became the migration project and I and user wangi and some other admin took over running OGF from Thilo, with his blessing. So it was my interest in topo that led to my taking on all this work for OGF, and therefore it remains of a focus of my efforts, moving forward.

Part II – The Current OGF Topo Zones

OpenGeofiction currently has 14 actively maintained topo zones. Here they are, in alphabetical order.

zone-alved

This zone has been created by mapper SwissCrusader. It’s a first draft, and clearly needs a lot of cleanup work, but it’s an excellent and ambitious start.

picture

zone-gobras

This zone actually is two smaller areas that have been combined because of their close proximity. The older is the topo work for Khaiwoon, on the eastern tip of the Gobrassanya peninsula. The territory is one of the oldest on OGF. It was developed by user isleño with a lot of additional mapping by user histor. The contours were drawn as a collaboration between thilo and isleño. The other is the background topo for Gobras City, to the northwest. Gobras City is one of the most successful wholly public and collaborative projects on OGF, created by a very large number of different mappers over almost a decade, now. User Ūdilugbulgidħū volunteered to draw contours for the city, and in my opinion, they are quite excellent. Obviously, since the contours were drawn after much of the city, and since there is work in the city drawn without a strong awareness of the contours, there are areas where the human development (roads, etc) doesn’t really properly “match” the contours as drawn.

picture

zone-gwynian

This zone is also actually two adjacent areas combined because of proximity. The older part, to the west, is my own work (user Luciano), drawn for my territory Ardisphere, in 2014-2016. I think it has well-done areas, but it’s quite noticeably incomplete, full of lacunae and missing expanses and weird glitches where the contour work is too sparse to properly cover the map. The newer part, currently in development by user Martinawa, is the largest single expanse of topo work on OGF, and still in early stages across most of the territory, but it’s got a lot of promise.

picture

zone-hesperis

This is a quite small but complete set of contours for an island territory drawn by mapper Ūdilugbulgidħū.

picture

zone-iscu

This zone includes several islands in a chain called Iscu, drawn by mapper Lithium-Ion. The contours are quite detailed and excellent.

picture

zone-izaland

This zone includes a few of the southern islands of a the nation called Izaland, by the user Izaland Terramorphing Committee. I’m looking forward to seeing more of Izaland getting contours.

picture

zone-january

I (user Luciano) drew these islands as part of a collaborative effort between myself and mapper deltanz. I later turned over the islands to deltanz. Personally I think they are my “most complete” set of contours among those I have done.

picture

zone-kofuku

This is a new effort by mapper Huachachi. Kofuku is an immense territory and so far these are just a few islands off that country’s north coast. They are excellently done, and I’m looking forward to seeing more of Kofuku with contours.

picture

zone-kojo

I (user Luciano) did a small spot of contours in collaboration with user Leowezy some years ago, in the southernmost spot of this zone, at the Joenji Peninsula. Leowezy has subsequently been gradually adding other areas of coverage for his territory, Kojo. Hopefully will come in the future.

picture

zone-makaska

This zone actually overlaps not just the territory of Makaska, but also the one to the south, called Ooayatais. I (user Luciano) own both of these territories. The northern territory, Makaska, has a very complete set of contours and is work I’m quite proud of. The southern territory, Ooayatais is much lower quality and, for now, also quite incomplete. It’s my “current project” with contour mapping, however, and hopefully sometime later this year I’ll upload a major update.

picture

zone-roantra

This is the oldest and, arguably, best of all the topo zones on OGF. User thilo, the original creator of OpenGeofiction, uploaded this topo zone when he first created the OGF server, for his territory Roantra. It is the archetype of OSM-style topo work.

picture

zone-ruanerara

This is a small project done by user Toadwart for his outlying (overseas) territory of his country, KA076 (apparently this mapper recently decided to change the name of the country, and the new name hasn’t been decided on). Anyway, the contours are clearly still in development but I’m looking forward to seeing more progress.

picture

zone-tapira

This zone, a small island, was created by mapper Ūdilugbulgidħū, but he subsequently gave up the territory. It’s someone’s chance to take on an already-existing topo project.

picture

zone-tarrases

This is another of my own (user Luciano) territories. The Duchy of Tárrases is the one case where I quite successfully imposed a set of contours on an already-created map. I’m quite happy with the result. The surrounding islands used to be owned by me, too, but for now they are in a bit of limbo. For that reason I haven’t bothered to repair the mess of half-finished contours on those surrounding islands.

picture

Part III – Create A New Topo Zone

There is quite a bit of work involved in creating a new topo zone for the ogf-topo rendering process. Multiple new working and data directories must be created, code must be added to xml layer specifications and data-processing scripts, and the proper raw contour templates need to be created and populated with initial draft contour data.

Therefore if you want to create a new topo zone for your OGF territory, you need to contact me and we can discuss, so I can get things set up and I can create the templates you’ll need to draw your contours (see next section). There is nothing wrong with diving in and drawing contours for yourself before contacting me, but bear in mind you’ll probably end up doing a lot of cutting and pasting and manipulation using the JOSM editor once I’ve created those templates for you, because I will no longer accept contour data drawn in files other than the pre-created templates.

If you’re trying to decide whether or not you want to create a topo zone, one good way to get a feel for what’s involved is to download one of the osm-squares from the server (see below) and just go ahead and open that up in JOSM and try to get a feel for how it works and what’s involved. Start with something small, complete and well-done, like the January Islands or Hesperis (see above).

Part IV – Edit or Improve An Existing Topo Zone

In the past, I’ve allowed users to simply submit new, hand-drawn “contour files” which I then clean up and process using the tools at hand. However, I have found that the first step – cleaning up the submitted files – can be quite tedious and time-consuming, and further, I often end up repeating work as newly submitted files have the same problems as previous iterations.

I would like to move toward a more reliable system of iterative improvement. To do this, if there is an already-existing topo zone and you want to add to it or improve it, you must download the existing osm-squares (contour files) from the ogfsrtm server, edit those, and send the edited copies of those files back to me. Do not try to bypass this process – I have special tags embedded in those contour files as found on the server, and I’ll know if you haven’t used those as a basis for your edits.

You can find downloadable individual squares for most topo zones at this location on the ogfsrtm server: https://ogfsrtm.rent-a-planet.com/osm-squares/

If a given square is missing from the server, contact me and I’ll create an initial template for that square and post it there, that you can then edit. Don’t try to create squares not found on the server.

Part V – An Alternative Pathway To Maintaining Your Own Topo Zone

If all this business of drawing vast numbers of contour lines in JOSM is not your style, there is, in fact, an alternative. You can directly submit NASA-SRTM format compliant .hgt files. This bypasses the whole contour conversion process, and would be quite a bit easier for me to do.

That said, so far, no one has done this successfully. There have been challenges to finding a program that produces .hgt files in the exact NASA-SRTM format expected by the OpenTopoMap rendering software. If, as a community, we find such a tool in the future, that may make a lot of what’s written above obsolete and we’ll have a better way to do things, moving forward.

Regardless, if you want to try doing it this way, you still need to contact me in advance, so I can set up the new zone on the render server – that aspect won’t change. Then you’d send me the pseudo-SRTM files (.hgt) so I can post them on the ogfsrtm server in the proper directory, since that’s where the render server expects to find them.

Music to draw contours to: Haddaway, “What is love?”

On render “ghosts”

Thank you to everyone on the Opengeofiction server.

We had unexpected longer downtime last night and this morning.

The render server had some problem (not really clear what went wrong), and needed to be restored from backup (not part of the plan), and then the ogf-carto render was reset (which had been the plan).

Just want to say thank you to the community for your patience.

Those who have been struggling with “render ghosts” – I think they are all fixed now. You can see one really good example here:

picture

For comparison, the ogf-topo render still has the ghosts (yes, topo needs maintenance work, I know!):

picture

UPDATE: by the way, Happy mapping!

Music to fix servers by: Cake, “Long Line Of Cars.”