<p>No that's not what he said. What he said is that it assumes the data is referentially correct - there are a number of ways you could load a single country and have if meet that definition:</p>
<ul>
<li>You could load those objects outside the country that objects in the country refer to</li>
<li>You could remove references from objects in the country to other objects that aren't present</li>
</ul>
<p>You have used an extract which doesn't do either of those things (because they're hard to do) and hence you have a problem.</p>
<p>In general the API database does not really make any special attempt to support imports at all - it assumes that you will start an empty database and that it will be in control of ensuring that referential integrity is maintained. There are, to my knowledge, no tools for easily importing a referentially correct extract.</p>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br />You are receiving this because you are subscribed to this thread.<br />Reply to this email directly, <a href="https://github.com/openstreetmap/openstreetmap-website/issues/1988#issuecomment-419835904">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/ABWnLTTIwXGGbB3izaQJ5wbZsMFac372ks5uZibTgaJpZM4Wg3ow">mute the thread</a>.<img src="https://github.com/notifications/beacon/ABWnLRUv1hX04QdGBwBV1fZdqfftnfCsks5uZibTgaJpZM4Wg3ow.gif" height="1" width="1" alt="" /></p>
<script type="application/json" data-scope="inboxmarkup">{"api_version":"1.0","publisher":{"api_key":"05dde50f1d1a384dd78767c55493e4bb","name":"GitHub"},"entity":{"external_key":"github/openstreetmap/openstreetmap-website","title":"openstreetmap/openstreetmap-website","subtitle":"GitHub repository","main_image_url":"https://assets-cdn.github.com/images/email/message_cards/header.png","avatar_image_url":"https://assets-cdn.github.com/images/email/message_cards/avatar.png","action":{"name":"Open in GitHub","url":"https://github.com/openstreetmap/openstreetmap-website"}},"updates":{"snippets":[{"icon":"PERSON","message":"@tomhughes in #1988: No that's not what he said. What he said is that it assumes the data is referentially correct - there are a number of ways you could load a single country and have if meet that definition:\r\n\r\n* You could load those objects outside the country that objects in the country refer to\r\n* You could remove references from objects in the country to other objects that aren't present\r\n\r\nYou have used an extract which doesn't do either of those things (because they're hard to do) and hence you have a problem.\r\n\r\nIn general the API database does not really make any special attempt to support imports at all - it assumes that you will start an empty database and that it will be in control of ensuring that referential integrity is maintained. There are, to my knowledge, no tools for easily importing a referentially correct extract."}],"action":{"name":"View Issue","url":"https://github.com/openstreetmap/openstreetmap-website/issues/1988#issuecomment-419835904"}}}</script>
<script type="application/ld+json">[
{
"@context": "http://schema.org",
"@type": "EmailMessage",
"potentialAction": {
"@type": "ViewAction",
"target": "https://github.com/openstreetmap/openstreetmap-website/issues/1988#issuecomment-419835904",
"url": "https://github.com/openstreetmap/openstreetmap-website/issues/1988#issuecomment-419835904",
"name": "View Issue"
},
"description": "View this Issue on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
},
{
"@type": "MessageCard",
"@context": "http://schema.org/extensions",
"hideOriginalBody": "false",
"originator": "AF6C5A86-E920-430C-9C59-A73278B5EFEB",
"title": "Re: [openstreetmap/openstreetmap-website] ActionView::Template::Error (undefined method `redacted?' for nil:NilClass) in app/views/browse/_relation_member.html.erb (#1988)",
"sections": [
{
"text": "",
"activityTitle": "**Tom Hughes**",
"activityImage": "https://assets-cdn.github.com/images/email/message_cards/avatar.png",
"activitySubtitle": "@tomhughes",
"facts": [

]
}
],
"potentialAction": [
{
"name": "Add a comment",
"@type": "ActionCard",
"inputs": [
{
"isMultiLine": true,
"@type": "TextInput",
"id": "IssueComment",
"isRequired": false
}
],
"actions": [
{
"name": "Comment",
"@type": "HttpPOST",
"target": "https://api.github.com",
"body": "{\n\"commandName\": \"IssueComment\",\n\"repositoryFullName\": \"openstreetmap/openstreetmap-website\",\n\"issueId\": 1988,\n\"IssueComment\": \"{{IssueComment.value}}\"\n}"
}
]
},
{
"name": "Close issue",
"@type": "HttpPOST",
"target": "https://api.github.com",
"body": "{\n\"commandName\": \"IssueClose\",\n\"repositoryFullName\": \"openstreetmap/openstreetmap-website\",\n\"issueId\": 1988\n}"
},
{
"targets": [
{
"os": "default",
"uri": "https://github.com/openstreetmap/openstreetmap-website/issues/1988#issuecomment-419835904"
}
],
"@type": "OpenUri",
"name": "View on GitHub"
},
{
"name": "Unsubscribe",
"@type": "HttpPOST",
"target": "https://api.github.com",
"body": "{\n\"commandName\": \"MuteNotification\",\n\"threadId\": 377715248\n}"
}
],
"themeColor": "26292E"
}
]</script>