<html xmlns:v="urn:schemas-microsoft-com:vml" 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 14 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Arial Narrow";
panose-1:2 11 6 6 2 2 2 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
color:black;
mso-fareast-language:EN-US;}
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
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
pre
{mso-style-priority:99;
mso-style-link:"Formateret HTML Tegn";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Markeringsbobletekst Tegn";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";
color:black;
mso-fareast-language:EN-US;}
span.FormateretHTMLTegn
{mso-style-name:"Formateret HTML Tegn";
mso-style-priority:99;
mso-style-link:"Formateret HTML";
font-family:Consolas;
color:black;
mso-fareast-language:EN-US;}
span.MarkeringsbobletekstTegn
{mso-style-name:"Markeringsbobletekst Tegn";
mso-style-priority:99;
mso-style-link:Markeringsbobletekst;
font-family:"Tahoma","sans-serif";}
span.EmailStyle22
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
span.EmailStyle23
{mso-style-type:personal;
font-family:"Arial Narrow","sans-serif";
color:windowtext;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
span.EmailStyle24
{mso-style-type:personal-reply;
font-family:"Arial Narrow","sans-serif";
color:windowtext;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:3.0cm 2.0cm 3.0cm 2.0cm;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor="white" lang="DA" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:windowtext">Hi Richard,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:windowtext">Yes, I’ve come to much the same conclusion: dummy features of the correct topology is the easiest way to force QGIS.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:windowtext"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:windowtext">I tried to publish the geometry_column table via WFS, as this contains the topology designations, and have QGIS load that via WFS.
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:windowtext"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:windowtext">But it seems that this logic unfortunately isn’t a general thing in QGIS, only a specifically database thing.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:windowtext"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:windowtext">I’ll go with the dummy features for now.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:windowtext"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:windowtext"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial Narrow","sans-serif";mso-fareast-language:DA">Med venlig hilsen<br>
</span><b><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";mso-fareast-language:DA"><br>
</span></b><span style="font-size:10.0pt;font-family:"Arial Narrow","sans-serif";mso-fareast-language:DA">Lars I. Nielsen, LIFA A/S<br>
GIS-konsulent<br>
</span><span style="font-size:8.0pt;font-family:"Verdana","sans-serif";mso-fareast-language:DA"><br>
</span><b><span style="font-size:10.0pt;font-family:"Arial Narrow","sans-serif";mso-fareast-language:DA">LIFA A/S Landinspektører<br>
</span></b><span style="font-size:8.0pt;font-family:"Arial Narrow","sans-serif";mso-fareast-language:DA"><br>
</span><b><span style="font-size:10.0pt;font-family:"Arial Narrow","sans-serif";color:red;mso-fareast-language:DA">T</span></b><span style="font-size:10.0pt;font-family:"Arial Narrow","sans-serif";color:red;mso-fareast-language:DA">
</span><span style="font-size:10.0pt;font-family:"Arial Narrow","sans-serif";mso-fareast-language:DA">6313 6800 </span><b><span style="font-size:10.0pt;font-family:"Arial Narrow","sans-serif";color:red;mso-fareast-language:DA">@
</span></b><span style="font-size:10.0pt;font-family:"Arial Narrow","sans-serif";mso-fareast-language:DA">lin@lifa.dk<br>
</span><b><span style="font-size:10.0pt;font-family:"Arial Narrow","sans-serif";color:red;mso-fareast-language:DA">D
</span></b><span style="font-size:10.0pt;font-family:"Arial Narrow","sans-serif";mso-fareast-language:DA">6313 6849
</span><b><span style="font-size:10.0pt;font-family:"Arial Narrow","sans-serif";color:red;mso-fareast-language:DA">W
</span></b><span style="font-size:10.0pt;font-family:"Arial Narrow","sans-serif";mso-fareast-language:DA">www.lifa.dk <br>
</span><b><span style="font-size:10.0pt;font-family:"Arial Narrow","sans-serif";color:red;mso-fareast-language:DA">M
</span></b><span style="font-size:10.0pt;font-family:"Arial Narrow","sans-serif";mso-fareast-language:DA">2492 4866<br>
<br>
<br>
</span><span style="font-family:"Arial Narrow","sans-serif";color:windowtext"><o:p></o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext;mso-fareast-language:DA">Fra:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext;mso-fareast-language:DA"> Richard
McDonnell [mailto:richard.mcdonnell@opw.ie] <br>
<b>Sendt:</b> 4. juli 2017 11:38<br>
<b>Til:</b> Lars I. Nielsen, LIFA A/S<br>
<b>Cc:</b> 'qgis-user@lists.osgeo.org'<br>
<b>Emne:</b> Re: SV: [Qgis-user] Unknown topology of empty WFS layer ?<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt">Hi again,<br>
Having the constraint in does appear, when loading tables directly into QGIS, to help QGIS in defining what kind of Geometry the table has. I don't believe that it will help you much in relation to the WFS though.<br>
Might I suggest you add a "Place Holder" to your dataset, as in a Temporary Line (polygon or point), at the far extents of your dataset for example 0,0 to 10,0 or something like that, that will give you a feature from which , when the WFS is loaded, QGIS can
see that it is a certain geometry.<br>
I am sorry I cant be of more help.<br>
Regards,<br>
<br>
Richard.<o:p></o:p></p>
<div>
<p class="MsoNormal">On 04/07/2017 08:33, Lars I. Nielsen, LIFA A/S wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal"><span lang="EN-US" style="color:windowtext">Hi Richard, </span>
<o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US" style="color:windowtext"> </span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US" style="color:windowtext">Thanks for the reply.</span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US" style="color:windowtext"> </span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US" style="color:windowtext">I failed to mention, that I’m using MS/SQL 2016 as my database, but I should be able to add geometry constraint in it.</span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US" style="color:windowtext"> </span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US" style="color:windowtext">But then again, I want to tell QGIS that it’s a line layer, and I’m uncertain whether such proposed database constraints will do that, Postgres or not ?</span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US" style="color:windowtext"> </span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US" style="color:windowtext">Is there not any way to tell/force QGIS to recognize/designate a WFS layer with no features to be of a certain topology (here: lines) ?</span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US" style="color:windowtext"> </span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US" style="color:windowtext"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt">Med venlig hilsen<br>
</span><b><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";mso-fareast-language:DA"><br>
</span></b><span style="font-size:10.0pt">Lars I. Nielsen, LIFA A/S<br>
GIS-konsulent<br>
</span><span style="font-size:8.0pt;font-family:"Verdana","sans-serif";mso-fareast-language:DA"><br>
</span><b><span style="font-size:10.0pt">LIFA A/S Landinspektører<br>
</span></b><span style="font-size:8.0pt"><br>
</span><b><span style="font-size:10.0pt">T</span></b><span style="font-size:10.0pt"> 6313 6800 <b>@
</b><a href="mailto:lin@lifa.dk">lin@lifa.dk</a><br>
<b>D </b>6313 6849 <b>W </b><a href="http://www.lifa.dk">www.lifa.dk</a> <br>
<b>M </b>2492 4866<br>
<br>
<br>
<br>
</span><o:p></o:p></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext;mso-fareast-language:DA">Fra:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext;mso-fareast-language:DA"> Richard
McDonnell [<a href="mailto:richard.mcdonnell@opw.ie">mailto:richard.mcdonnell@opw.ie</a>]
<br>
<b>Sendt:</b> 30. juni 2017 12:39<br>
<b>Til:</b> Lars I. Nielsen, LIFA A/S; '<a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a>'<br>
<b>Emne:</b> Re: [Qgis-user] Unknown topology of empty WFS layer ?</span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt">Hi,<br>
Not sure if this is exactly what you are looking for.<br>
Your Layers, Ive no idea what database type you are using, but on PostgreSQL/PostGIS you can put in geometry Constraints using
<br>
<br>
ALTER TABLE public."Table_Name"<br>
<br>
and one of the following, depending on what Geometry type you are looking at.<br>
<br>
ADD CONSTRAINT enforce_geotype_geom CHECK (geometrytype(geom) = 'MULTIPOLYGON'::text OR geom IS NULL);<br>
<br>
ADD CONSTRAINT enforce_geotype_geom CHECK (geometrytype(geom) = 'POLYGON'::text OR geom IS NULL);<br>
<br>
ADD CONSTRAINT enforce_geotype_geom CHECK (geometrytype(geom) = 'POINT'::text OR geom IS NULL);<br>
<br>
ADD CONSTRAINT enforce_geotype_geom CHECK (geometrytype(geom) = 'LINESTRING'::text OR geom IS NULL);<br>
<br>
I hope this helps<br>
Reagrds,<br>
<br>
Richard<o:p></o:p></p>
<div>
<p class="MsoNormal">On 30/06/2017 10:39, Lars I. Nielsen, LIFA A/S wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal"><span lang="EN-US">Hi,</span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US">I’m preparing a QGIS project for a customer, and have (among other) three layers with points, lines, and areas respectively.</span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US">I’m adapting the project from a previously made project by altering the data connections. The databases are identical in structure, so it works. The layers are all fetched using WFS-T.</span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US">So far I only have data in the points and areas layers, none in the lines layer. The lines dataset (table) in the database is present, and published as WFS (Geoserver), and all metadata (afaik) is present (i.e. “geometry_columns”).</span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US">I would like to be able to digitize lines into the line layer, but apparently QGIS cannot determine the topology, and (I suppose that’s also why) I can’t add any styles via the “properties” dialog or elsewhere.</span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US">Is there any way, that I can tell QGIS that the layer should contain line features ?</span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US">And how can I add suitable (line) styles to display the lines without any features present ?</span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal">Using 2.18.7 (32+64) Windows<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:10.0pt">Med venlig hilsen<br>
<b><br>
</b>Lars I. Nielsen, LIFA A/S<br>
GIS-konsulent<br>
</span><span style="font-size:8.0pt;font-family:"Verdana","sans-serif";mso-fareast-language:DA"><br>
</span><span style="font-size:8.0pt"><br>
<img border="0" width="270" height="77" id="Billede_x0020_1" src="cid:image001.gif@01D2F4DC.28B1D050" alt="http://website.lifa.dk/lsp.gif"><br>
</span><span style="font-size:8.0pt;font-family:"Verdana","sans-serif";mso-fareast-language:DA"><br>
<br>
</span><b><span style="font-size:10.0pt">T</span></b><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:red;mso-fareast-language:DA">
</span><span style="font-size:10.0pt">6313 6800 <b>@ </b><a href="mailto:lin@lifa.dk">lin@lifa.dk</a><br>
<b>D </b>6313 6849 <b>W </b><a href="http://www.lifa.dk">www.lifa.dk</a> <br>
<b>M </b>2492 4866</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:12.0pt"><br>
<br>
<br>
<br>
</span><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>
<p class="MsoNormal"><span style="font-size:12.0pt"> </span><o:p></o:p></p>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt">-- <br>
<b><u>Richard McDonnell</u></b><br>
</span><b><span style="font-size:7.5pt">GIS Specialist PgD GIS AssocSCSI</span></b><span style="font-size:12.0pt"><br>
</span><b><span style="font-size:10.0pt">OPW FRM Data Management</span></b><span style="font-size:12.0pt"><br>
</span><b><span style="font-size:10.0pt">52 Stephens Green, Dublin 2.</span></b><span style="font-size:12.0pt"><br>
</span><span style="font-size:7.5pt">TEL: 01 6476543</span><o:p></o:p></p>
</div>
<p class="MsoNormal"><span style="font-size:12.0pt"><a href="http://www.opw.ie/"><span style="text-decoration:none"><img border="0" width="405" height="225" id="_x0000_i1026" src="http://www.opw.ie/en/media/opw-logo-december-2016.gif"></span></a></span><o:p></o:p></p>
</blockquote>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:DA"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:DA">--
<br>
<b><u>Richard McDonnell</u></b><br>
</span><b><span style="font-size:7.5pt;font-family:"Times New Roman","serif";mso-fareast-language:DA">GIS Specialist PgD GIS AssocSCSI</span></b><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:DA"><br>
</span><b><span style="font-size:10.0pt;font-family:"Times New Roman","serif";mso-fareast-language:DA">OPW FRM Data Management</span></b><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:DA"><br>
</span><b><span style="font-size:10.0pt;font-family:"Times New Roman","serif";mso-fareast-language:DA">52 Stephens Green, Dublin 2.</span></b><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:DA"><br>
</span><span style="font-size:7.5pt;font-family:"Times New Roman","serif";mso-fareast-language:DA">TEL: 01 6476543</span><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:DA"><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:DA"><a href="http://www.opw.ie/"><span style="text-decoration:none"><img border="0" width="405" height="225" id="_x0000_i1027" src="http://www.opw.ie/en/media/opw-logo-december-2016.gif"></span></a><o:p></o:p></span></p>
</div>
</body>
</html>