<p></p>
<blockquote>
<p dir="auto">Of course then they will just switch to uploading multiple smaller batches into one changeset.</p>
</blockquote>
<p dir="auto">But what if we sum up the area of the last edits? It seems that it will be enough to add after line 49 something like</p>
<p dir="auto"><a href="https://github.com/openstreetmap/openstreetmap-website/blob/2d09b9408b4f3f9a7c7a5782098c6c5b81ae1206/lib/database_functions.rb#L49-L54">https://github.com/openstreetmap/openstreetmap-website/blob/2d09b9408b4f3f9a7c7a5782098c6c5b81ae1206/lib/database_functions.rb#L49-L54</a></p>
<p dir="auto">Something like</p>
<div class="highlight highlight-source-sql" dir="auto"><pre class="notranslate"><span class="pl-k">SELECT</span> COALESCE(<span class="pl-c1">SUM</span>((<span class="pl-c1">changesets</span>.<span class="pl-c1">max_lon</span> <span class="pl-k">/</span> <span class="pl-c1">10000000</span> <span class="pl-k">-</span> <span class="pl-c1">changesets</span>.<span class="pl-c1">min_lon</span> <span class="pl-k">/</span> <span class="pl-c1">10000000</span>) <span class="pl-k">+</span>
                    (<span class="pl-c1">changesets</span>.<span class="pl-c1">max_lat</span> <span class="pl-k">/</span> <span class="pl-c1">10000000</span> <span class="pl-k">-</span> <span class="pl-c1">changesets</span>.<span class="pl-c1">min_lat</span> <span class="pl-k">/</span> <span class="pl-c1">10000000</span>)), <span class="pl-c1">0</span>)
INTO recent_changesets_area
<span class="pl-k">FROM</span> changesets
<span class="pl-k">where</span> <span class="pl-c1">changesets</span>.<span class="pl-c1">created_at</span> <span class="pl-k">>=</span> <span class="pl-c1">CURRENT_TIMESTAMP</span> AT <span class="pl-k">TIME</span> ZONE <span class="pl-s"><span class="pl-pds">'</span>UTC<span class="pl-pds">'</span></span> <span class="pl-k">-</span> <span class="pl-s"><span class="pl-pds">'</span>5 minute<span class="pl-pds">'</span></span>::interval;

max_changes :<span class="pl-k">=</span> max_changes <span class="pl-k">/</span> GREATEST(recent_changesets_area, <span class="pl-c1">1</span>);</pre></div>
<p dir="auto">This will skip the first big edit, but it will give DWG and the community time to react to big edits.</p>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br />Reply to this email directly, <a href="https://github.com/openstreetmap/openstreetmap-website/issues/4805#issuecomment-2175654253">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AAK2OLL6ARC34LCGF6DESZDZH75R5AVCNFSM6AAAAABH3OHEU2VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCNZVGY2TIMRVGM">unsubscribe</a>.<br />You are receiving this because you are subscribed to this thread.<img src="https://github.com/notifications/beacon/AAK2OLJE372G2A4AZMNLNU3ZH75R5A5CNFSM6AAAAABH3OHEU2WGG33NNVSW45C7OR4XAZNMJFZXG5LFINXW23LFNZ2KUY3PNVWWK3TUL5UWJTUBVXMW2.gif" height="1" width="1" alt="" /><span style="color: transparent; font-size: 0; display: none; visibility: hidden; overflow: hidden; opacity: 0; width: 0; height: 0; max-width: 0; max-height: 0; mso-hide: all">Message ID: <span><openstreetmap/openstreetmap-website/issues/4805/2175654253</span><span>@</span><span>github</span><span>.</span><span>com></span></span></p>
<script type="application/ld+json">[
{
"@context": "http://schema.org",
"@type": "EmailMessage",
"potentialAction": {
"@type": "ViewAction",
"target": "https://github.com/openstreetmap/openstreetmap-website/issues/4805#issuecomment-2175654253",
"url": "https://github.com/openstreetmap/openstreetmap-website/issues/4805#issuecomment-2175654253",
"name": "View Issue"
},
"description": "View this Issue on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
}
]</script>