<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<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.<br>
</p>
<div class="moz-cite-prefix">On 12/03/19 12:20 AM,
<a class="moz-txt-link-abbreviated" href="mailto:b.j.kobben@utwente.nl">b.j.kobben@utwente.nl</a> wrote:<br>
</div>
<blockquote type="cite"
cite="mid:B6861299-EB2E-44AC-9DB7-EA8970BC3410@utwente.nl">
<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;}
/* 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;}
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.EmailStyle18
{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.EmailStyle19
{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>
<div class="WordSection1">
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Georgia",serif"
lang="EN-GB">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....<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Georgia",serif"
lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Georgia",serif"
lang="EN-GB">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">--<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
style="font-size:12.0pt;font-family:"Georgia",serif"
lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Georgia",serif"
lang="EN-GB"><o:p> </o:p></span></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"
moz-do-not-send="true">
b.j.kobben@utwente.nl</a>" <<a
href="mailto:qgis-user-bounces@lists.osgeo.org"
moz-do-not-send="true">qgis-user-bounces@lists.osgeo.org</a>
on behalf of
<a href="mailto:b.j.kobben@utwente.nl"
moz-do-not-send="true">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
style="font-family:"Georgia",serif" lang="NL">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>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
List info: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
</body>
</html>