<p></p>
<p dir="auto">Hi <a class="user-mention" data-hovercard-type="user" data-hovercard-url="/users/joto/hovercard" data-octo-click="hovercard-link-click" data-octo-dimensions="link_type:self" href="https://github.com/joto">@joto</a>,</p>
<p dir="auto">Thanks. After re-reading the documentation, I realized this as well.</p>
<p dir="auto">I have now been able though, using the information of the osm2pgsql manual, to adjust the osm2pgsql Lua flex style file, to have osm2pgsql output an extra column in the 'planet-osm-admin' table, that now includes the OSM IDs of the two boundary relations making up a border line. See the attached image, where the column highlighted in red contains a semi-colon concatenated list of the corresponding OSM IDs. This actually makes the <strong>multiple_relations</strong> boolean column, that Paul initially added, superfluous, and I will probably drop it in favor of the new more informative column.</p>
<p dir="auto">The blue highlighted section, shows the ways conforming to the Liechtenstein (OSM ID '1155955') and Switzerland (OSM ID '51701') border, also see the second image for the selection displayed spatially.</p>
<p dir="auto">This means it should now be a breeze to dissolve the lines by simply selecting the <strong>relation_ids</strong> column as input for the dissolve process.</p>
<p dir="auto">It actually cost me two days to figure out how to do it, as I was initially mis-interpreting the documentation and how osm2psql processes the data and Lua file, and the Lua flex style code, thinking it would require adjustments to the <strong>osm2pgsql.process_relation()</strong> function, while in the end, it turned out to only require minimal changes to Paul's well structured work, and the addition of just a few lines of code in a few specific places.</p>
<p dir="auto"><a target="_blank" rel="noopener noreferrer" href="https://user-images.githubusercontent.com/7635726/146978320-de4725e6-bcd0-4c91-93ba-cc161dd1c5b9.png"><img src="https://user-images.githubusercontent.com/7635726/146978320-de4725e6-bcd0-4c91-93ba-cc161dd1c5b9.png" alt="afbeelding" style="max-width: 100%;"></a></p>
<p dir="auto"><a target="_blank" rel="noopener noreferrer" href="https://user-images.githubusercontent.com/7635726/146979007-49fea72b-4293-4051-b801-b3ad1de6b092.png"><img src="https://user-images.githubusercontent.com/7635726/146979007-49fea72b-4293-4051-b801-b3ad1de6b092.png" alt="afbeelding" style="max-width: 100%;"></a></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/osm2pgsql/discussions/1595#discussioncomment-1854351">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AA6353TPHRRZHYQPCDEVNHDUSDBILANCNFSM5KKQ4F3Q">unsubscribe</a>.<br />Triage notifications on the go with GitHub Mobile for <a href="https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675">iOS</a> or <a href="https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub">Android</a>.
<br />You are receiving this because you are subscribed to this thread.<img src="https://github.com/notifications/beacon/AA6353X7UF6VGUHGKWCPF33USDBILA5CNFSM5KKQ4F32YY3PNVWWK3TUL52HS4DFWFCGS43DOVZXG2LPNZBW63LNMVXHJKTDN5WW2ZLOORPWSZGOAAOEXDY.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/osm2pgsql/repo-discussions/1595/comments/1854351</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/osm2pgsql/discussions/1595#discussioncomment-1854351",
"url": "https://github.com/openstreetmap/osm2pgsql/discussions/1595#discussioncomment-1854351",
"name": "View Discussion"
},
"description": "View this Discussion on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
}
]</script>