<p dir="auto">This removes both the pl/pgsql version and the shared library version of the <code class="notranslate">tile_for_point</code> SQL function. This function was only used in some old migrations, and is not required for production usage.</p>
<p dir="auto">Removing this function simplifies the installation and configuration for new developers.</p>
<p dir="auto">These SQL functions are separate from the <code class="notranslate">tile_for_point</code> ruby/C function which is part of the quad_tile gem. This function is still used when creating and updating database records.</p>
<p dir="auto"><span class="issue-keyword tooltipped tooltipped-se" aria-label="This pull request closes issue #3110.">Fixes</span> <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="815848562" data-permission-text="Title is private" data-url="https://github.com/openstreetmap/openstreetmap-website/issues/3110" data-hovercard-type="issue" data-hovercard-url="/openstreetmap/openstreetmap-website/issues/3110/hovercard" href="https://github.com/openstreetmap/openstreetmap-website/issues/3110">#3110</a>.</p>

<hr>

<h4>You can view, comment on, or merge this pull request online at:</h4>
<p>  <a href='https://github.com/openstreetmap/openstreetmap-website/pull/3830'>https://github.com/openstreetmap/openstreetmap-website/pull/3830</a></p>

<h4>Commit Summary</h4>
<ul>
  <li><a href="https://github.com/openstreetmap/openstreetmap-website/pull/3830/commits/479c1575e119d93a0d239fb192ad4ed3d03cad88" class="commit-link">479c157</a>  Remove tile_for_point SQL functions</li>
</ul>

<h4 style="display: inline-block">File Changes </h4> <p style="display: inline-block">(<a href="https://github.com/openstreetmap/openstreetmap-website/pull/3830/files">14 files</a>)</p>
<ul>
  <li>
    <strong>M</strong>
    <a href="https://github.com/openstreetmap/openstreetmap-website/pull/3830/files#diff-1db27d93186e46d3b441ece35801b244db8ee144ff1405ca27a163bfe878957f">.github/workflows/tests.yml</a>
    (1)
  </li>
  <li>
    <strong>M</strong>
    <a href="https://github.com/openstreetmap/openstreetmap-website/pull/3830/files#diff-7b529b3af70da49fbbf1f49523d108b62b1cfe4ee42175a0bbab967b6f11c92e">CONFIGURE.md</a>
    (2)
  </li>
  <li>
    <strong>M</strong>
    <a href="https://github.com/openstreetmap/openstreetmap-website/pull/3830/files#diff-09b140a43ebfdd8dbec31ce72cafffd15164d2860fd390692a030bcb932b54a0">INSTALL.md</a>
    (46)
  </li>
  <li>
    <strong>D</strong>
    <a href="https://github.com/openstreetmap/openstreetmap-website/pull/3830/files#diff-2b311d41ce300754ae4a9883f1da19eeb868b020e1e9d5c959ca7ffdf23ac289">db/functions/.gitignore</a>
    (2)
  </li>
  <li>
    <strong>D</strong>
    <a href="https://github.com/openstreetmap/openstreetmap-website/pull/3830/files#diff-ee4cdba0408becd760ffe0997b4036df3c985c58c64e3f2eebbf0893a2fde51d">db/functions/Makefile</a>
    (25)
  </li>
  <li>
    <strong>D</strong>
    <a href="https://github.com/openstreetmap/openstreetmap-website/pull/3830/files#diff-92aa00569f3142997e90b50226f26c54819d4f2a51a3556a1d66090b2b68a689">db/functions/functions.sql</a>
    (42)
  </li>
  <li>
    <strong>D</strong>
    <a href="https://github.com/openstreetmap/openstreetmap-website/pull/3830/files#diff-fb1b43d2f231513b374a479b9313e484d8baf8b0723717f4f3973c29d6c9e959">db/functions/quadtile.c</a>
    (29)
  </li>
  <li>
    <strong>M</strong>
    <a href="https://github.com/openstreetmap/openstreetmap-website/pull/3830/files#diff-543f7d05c070f0e4058f1e9954fea280287121a636315c3371bcdaeb11b0f1f8">db/migrate/005_tile_tracepoints.rb</a>
    (12)
  </li>
  <li>
    <strong>M</strong>
    <a href="https://github.com/openstreetmap/openstreetmap-website/pull/3830/files#diff-99c9fd1b7eaacb6b76b3913c374715db18f803147ad63cb672175fc9c7abbc30">db/migrate/006_tile_nodes.rb</a>
    (27)
  </li>
  <li>
    <strong>M</strong>
    <a href="https://github.com/openstreetmap/openstreetmap-website/pull/3830/files#diff-5c9fa7f1500af2291f835619f6a7e9a8f50a68a71ae7dcb31f45322a598bad6d">db/migrate/20180204153242_tile_users.rb</a>
    (6)
  </li>
  <li>
    <strong>M</strong>
    <a href="https://github.com/openstreetmap/openstreetmap-website/pull/3830/files#diff-1dd5a8f580b9615769ddc19a64a98f455d9d20eb149c443f41d9d3c797d39b12">db/structure.sql</a>
    (35)
  </li>
  <li>
    <strong>M</strong>
    <a href="https://github.com/openstreetmap/openstreetmap-website/pull/3830/files#diff-bd8bda025306c9c437bac4a1a71d22019525ce2c43a43ddd39dfb796e9339834">docker/postgres/Dockerfile</a>
    (5)
  </li>
  <li>
    <strong>M</strong>
    <a href="https://github.com/openstreetmap/openstreetmap-website/pull/3830/files#diff-b71ed5c9e0bf1004606be9f68c61c8fc1b2aaa7e5fd333fad6246bc59bed66ce">docker/postgres/openstreetmap-postgres-init.sh</a>
    (3)
  </li>
  <li>
    <strong>M</strong>
    <a href="https://github.com/openstreetmap/openstreetmap-website/pull/3830/files#diff-dcd17c18ef06dc1c5c49caa05ecb7aabc1230dbc967d7e4e2bf1e3e51c06a9b1">script/vagrant/setup/provision.sh</a>
    (15)
  </li>
</ul>

<h4>Patch Links:</h4>
<ul>
  <li><a href='https://github.com/openstreetmap/openstreetmap-website/pull/3830.patch'>https://github.com/openstreetmap/openstreetmap-website/pull/3830.patch</a></li>
  <li><a href='https://github.com/openstreetmap/openstreetmap-website/pull/3830.diff'>https://github.com/openstreetmap/openstreetmap-website/pull/3830.diff</a></li>
</ul>

<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/pull/3830">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AAK2OLKEHOQDMQQ4HRZCT5LWMDB45ANCNFSM6AAAAAASXCXBMM">unsubscribe</a>.<br />You are receiving this because you are subscribed to this thread.<img src="https://github.com/notifications/beacon/AAK2OLOBPQACXNAPWZONMZ3WMDB45A5CNFSM6AAAAAASXCXBMOWGG33NNVSW45C7OR4XAZNFJFZXG5LFVJRW63LNMVXHIX3JMTHFQXBQAI.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/pull/3830</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/pull/3830",
"url": "https://github.com/openstreetmap/openstreetmap-website/pull/3830",
"name": "View Pull Request"
},
"description": "View this Pull Request on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
}
]</script>