<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Georgia;
panose-1:2 4 5 2 5 4 5 2 3 3;}
@font-face
{font-family:"Times New Roman \(Body CS\)";
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Georgia",serif;
font-variant:normal !important;
color:windowtext;
text-transform:none;
mso-contextual-alternates:no;
font-weight:normal;
font-style:normal;
text-decoration:none none;
vertical-align:baseline;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Georgia",serif;
font-variant:normal !important;
color:windowtext;
text-transform:none;
mso-contextual-alternates:no;
font-weight:normal;
font-style:normal;
text-decoration:none none;
vertical-align:baseline;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:"Consolas",serif;}
span.EmailStyle23
{mso-style-type:personal-reply;
font-family:"Georgia",serif;
font-variant:normal !important;
color:windowtext;
text-transform:none;
mso-contextual-alternates:no;
font-weight:normal;
font-style:normal;
text-decoration:none none;
vertical-align:baseline;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style>
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12.0pt;font-family:"Georgia",serif">Thanks for the info Patrick. I totally agree this is unwise, but the OSM (OpenStreetMap) dataset I am working with unfortunately comes with some of these (unwisely
chosen) attribute tags :-(<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12.0pt;font-family:"Georgia",serif">So indeed inconsistency in how that 's handled is annoying. In defence of QGIS programmers, I think it's because the different import/export formats have different
rules and defaults...<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12.0pt;font-family:"Georgia",serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12.0pt;font-family:"Georgia",serif">yours,<o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-family:"Georgia",serif">--<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Georgia",serif">Barend Köbben<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12.0pt;font-family:"Georgia",serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12.0pt;font-family:"Georgia",serif"><o:p> </o:p></span></p>
<div>
<div>
<p class="MsoNormal">On 12/03/2019, 11:45, "Qgis-user on behalf of Patrick Dunford" <<a href="mailto:qgis-user-bounces@lists.osgeo.org">qgis-user-bounces@lists.osgeo.org</a> on behalf of
<a href="mailto:enzedrailmaps@gmail.com">enzedrailmaps@gmail.com</a>> wrote:<o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p>Case sensitive names (from experience) are handled inconsistently within the Qgis software. It would be unwise to have two different columns where the names are only distinguished by case, unless the developers choose to address these issues in future.<o:p></o:p></p>
<div>
<p class="MsoNormal">On 12/03/19 12:20 AM, <a href="mailto:b.j.kobben@utwente.nl">
b.j.kobben@utwente.nl</a> wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12.0pt;font-family:"Georgia",serif">To answer my own question: the problem is actually not the amount of attributes, but the fact that there are (2x) attributes columns with the same name (although they
are different if you consider case sensitivity). Apparently GeoJSON is the only format that allows differentiating column names by upper/lowercase....</span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12.0pt;font-family:"Georgia",serif"> </span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12.0pt;font-family:"Georgia",serif">yours,</span><o:p></o:p></p>
<div>
<p class="MsoNormal"><span style="font-family:"Georgia",serif"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-family:"Georgia",serif">--</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-family:"Georgia",serif">Barend Köbben</span><o:p></o:p></p>
</div>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12.0pt;font-family:"Georgia",serif"> </span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12.0pt;font-family:"Georgia",serif"> </span><o:p></o:p></p>
<div>
<div>
<p class="MsoNormal">On 11/03/2019, 11:55, "Qgis-user on behalf of <a href="mailto:b.j.kobben@utwente.nl">
b.j.kobben@utwente.nl</a>" <<a href="mailto:qgis-user-bounces@lists.osgeo.org">qgis-user-bounces@lists.osgeo.org</a> on behalf of
<a href="mailto:b.j.kobben@utwente.nl">b.j.kobben@utwente.nl</a>> wrote:<o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Georgia",serif">Hi all,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Georgia",serif"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Georgia",serif">I have a problem that (I think) comes down to a limit in the amount of attributes per object the QGIS exporting tools can handle. Case in hand:</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Georgia",serif"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Georgia",serif">1) Import OSM data Points with many attributes (OSM tags), using QuickOSM – works</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Georgia",serif"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Georgia",serif">2) Temporary layer in QGIS is displayed - seems fine</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Georgia",serif"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Georgia",serif">3) "Make Permanent" or "Export As..." fails on all file formats (<u>except</u> GeoJSON!). Error message is (for the GeoPackage case):</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Georgia",serif"> </span><o:p></o:p></p>
<p class="MsoNormal">Export to vector file failed.<o:p></o:p></p>
<p class="MsoNormal">Error: Feature write errors:<o:p></o:p></p>
<p class="MsoNormal">Feature creation error (OGR error: sqlite3_exec(CREATE TABLE "test" ( "fid" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "geom" POINT, "full_id" TEXT(255), "osm_id" TEXT(255), "osm_type" TEXT(255), "highway" TEXT(255),
<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">... many more attributes...<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">"safe_place:school" TEXT(255), "safe_place:mosque" TEXT(255))) failed: duplicate column name: Operational_status)<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Feature creation error (OGR error: failed to prepare SQL: INSERT INTO "test" ( "geom", "full_id", "osm_id", "osm_type", "highway", "name",
<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">... again the same many more attributes...<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">"safe_place:school", "safe_place:mosque") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?))<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Georgia",serif">This happens even when I have only 2 features (see attached test file). The workaraound is to use GeoJSON, bacuse for some reason that one works, but in normal case I have 1000s
of points instead of two, and then a GeoJSON file becomes very large and unwieldy...</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Georgia",serif"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Georgia",serif">Any ideas if this is a bug or a limit in the actual formats such as GeoPackage...?</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Georgia",serif">yours,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-family:"Georgia",serif"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-family:"Georgia",serif">--</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-family:"Georgia",serif">Barend Köbben</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-family:"Georgia",serif">Senior Lecturer – ITC-University of Twente & ATLAS</span><o:p></o:p></p>
<p class="MsoNormal"><span lang="NL" style="font-family:"Georgia",serif">PO Box 217, 7500 AE Enschede (Netherlands)</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-family:"Georgia",serif">ITC Building (room 1-065)</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-family:"Georgia",serif">@barendkobben</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-family:"Georgia",serif">+31-(0)53 4874 253</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Georgia",serif"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Georgia",serif"> </span><o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Georgia",serif"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Georgia",serif"> </span><o:p></o:p></p>
<p class="MsoNormal"><br>
<br>
<o:p></o:p></p>
<pre>_______________________________________________<o:p></o:p></pre>
<pre>Qgis-user mailing list<o:p></o:p></pre>
<pre><a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><o:p></o:p></pre>
<pre>List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><o:p></o:p></pre>
<pre>Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><o:p></o:p></pre>
</blockquote>
</div>
</body>
</html>