<div style="display: flex; flex-wrap: wrap; white-space: pre-wrap; align-items: center; "><img height="20" width="20" style="border-radius:50%; margin-right: 4px;" decoding="async" src="https://avatars.githubusercontent.com/u/170263?s=20&v=4" /><strong>biodranik</strong> left a comment <a href="https://github.com/openstreetmap/openstreetmap-website/issues/6100#issuecomment-2972847642">(openstreetmap/openstreetmap-website#6100)</a></div>
<p dir="auto">Thanks for the reference to a similar <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="430010870" data-permission-text="Title is private" data-url="https://github.com/openstreetmap/openstreetmap-website/issues/2201" data-hovercard-type="issue" data-hovercard-url="/openstreetmap/openstreetmap-website/issues/2201/hovercard" href="https://github.com/openstreetmap/openstreetmap-website/issues/2201">#2201</a> issue. I read comments there, and do not understand why this (and that) issue was closed:</p>
<ol dir="auto">
<li><a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="430010870" data-permission-text="Title is private" data-url="https://github.com/openstreetmap/openstreetmap-website/issues/2201" data-hovercard-type="issue" data-hovercard-url="/openstreetmap/openstreetmap-website/issues/2201/hovercard" href="https://github.com/openstreetmap/openstreetmap-website/issues/2201">#2201</a> was closed just because nobody commented there. The problem of duplication in the database has not been solved yet, right? Why close both issues? Before creating this one, I was looking for something related and didn't find anything.</li>
<li>How many duplicated data (excluding notes) are now in the OSM database? Is it still an issue? With notes, it is an annoying issue because they are resolved manually by people. Here are some stats <a href="https://dupnotes.webmapping.cyou/" rel="nofollow">https://dupnotes.webmapping.cyou/</a> with a <a href="https://dupnotes.webmapping.cyou/organic-maps/om-dupe-notes.json" rel="nofollow">subset of Organic Maps duplicated notes</a>. So it is still an issue.</li>
<li>How do you propose to solve it on a client without changes on the server? Query the data first before creating a note? That will double the HTTP server load. Clients are losing network connection frequently, as was mentioned already many times. This is the reality.</li>
<li><a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="430010870" data-permission-text="Title is private" data-url="https://github.com/openstreetmap/openstreetmap-website/issues/2201" data-hovercard-type="issue" data-hovercard-url="/openstreetmap/openstreetmap-website/issues/2201/hovercard" href="https://github.com/openstreetmap/openstreetmap-website/issues/2201">#2201</a> discusses different <em>complex</em> approaches to solve the problem on a server or server+client side, and I agree with <a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url="/users/tomhughes/hovercard" data-octo-click="hovercard-link-click" data-octo-dimensions="link_type:self" href="https://github.com/tomhughes">@tomhughes</a> that proposed solutions there are <em>too complex</em> to implement.</li>
<li>I did not check the current OSM notes DB schema and don't know the current typical server load (if it is a bottleneck already). <a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url="/users/tomhughes/hovercard" data-octo-click="hovercard-link-click" data-octo-dimensions="link_type:self" href="https://github.com/tomhughes">@tomhughes</a> is it expensive to compare coordinates+text from a note create request with content in the DB before actually creating a record, without storing/modifying the database with any hashes? Or use coords+initial note text as a unique index in the DB?</li>
</ol>

<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/6100#issuecomment-2972847642">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AAK2OLJWPRTG5AHS5LMVIEL3DRBRJAVCNFSM6AAAAAB7JZRYEKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDSNZSHA2DONRUGI">unsubscribe</a>.<br />You are receiving this because you are subscribed to this thread.<img src="https://github.com/notifications/beacon/AAK2OLNDCZNINF6ALLKA72T3DRBRJA5CNFSM6AAAAAB7JZRYEKWGG33NNVSW45C7OR4XAZNMJFZXG5LFINXW23LFNZ2KUY3PNVWWK3TUL5UWJTVRGIHBU.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/6100/2972847642</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/6100#issuecomment-2972847642",
"url": "https://github.com/openstreetmap/openstreetmap-website/issues/6100#issuecomment-2972847642",
"name": "View Issue"
},
"description": "View this Issue on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
}
]</script>