[Qgis-user] Unknown topology of empty WFS layer ?
Richard McDonnell
richard.mcdonnell at opw.ie
Tue Jul 4 02:37:38 PDT 2017
Hi again,
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.
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.
I am sorry I cant be of more help.
Regards,
Richard.
On 04/07/2017 08:33, Lars I. Nielsen, LIFA A/S wrote:
>
> Hi Richard,
>
> Thanks for the reply.
>
> 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.
>
> 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 ?
>
> 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) ?
>
> Med venlig hilsen
> *
> *Lars I. Nielsen, LIFA A/S
> GIS-konsulent
>
> *LIFA A/S Landinspektører
> *
> *T*6313 6800 *@ *lin at lifa.dk
> *D *6313 6849 *W *www.lifa.dk
> *M *2492 4866
>
>
> *Fra:*Richard McDonnell [mailto:richard.mcdonnell at opw.ie]
> *Sendt:* 30. juni 2017 12:39
> *Til:* Lars I. Nielsen, LIFA A/S; 'qgis-user at lists.osgeo.org'
> *Emne:* Re: [Qgis-user] Unknown topology of empty WFS layer ?
>
> Hi,
> Not sure if this is exactly what you are looking for.
> Your Layers, Ive no idea what database type you are using, but on
> PostgreSQL/PostGIS you can put in geometry Constraints using
>
> ALTER TABLE public."Table_Name"
>
> and one of the following, depending on what Geometry type you are
> looking at.
>
> ADD CONSTRAINT enforce_geotype_geom CHECK (geometrytype(geom) =
> 'MULTIPOLYGON'::text OR geom IS NULL);
>
> ADD CONSTRAINT enforce_geotype_geom CHECK (geometrytype(geom) =
> 'POLYGON'::text OR geom IS NULL);
>
> ADD CONSTRAINT enforce_geotype_geom CHECK (geometrytype(geom) =
> 'POINT'::text OR geom IS NULL);
>
> ADD CONSTRAINT enforce_geotype_geom CHECK (geometrytype(geom) =
> 'LINESTRING'::text OR geom IS NULL);
>
> I hope this helps
> Reagrds,
>
> Richard
>
> On 30/06/2017 10:39, Lars I. Nielsen, LIFA A/S wrote:
>
> Hi,
>
> I’m preparing a QGIS project for a customer, and have (among
> other) three layers with points, lines, and areas respectively.
>
> 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.
>
> 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”).
>
> 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.
>
> Is there any way, that I can tell QGIS that the layer should
> contain line features ?
>
> And how can I add suitable (line) styles to display the lines
> without any features present ?
>
> Using 2.18.7 (32+64) Windows
>
> Med venlig hilsen
> *
> *Lars I. Nielsen, LIFA A/S
> GIS-konsulent
>
>
> http://website.lifa.dk/lsp.gif
>
>
> *T*6313 6800 *@ *lin at lifa.dk <mailto:lin at lifa.dk>
> *D *6313 6849 *W *www.lifa.dk <http://www.lifa.dk>
> *M *2492 4866
>
>
>
>
> _______________________________________________
>
> Qgis-user mailing list
>
> Qgis-user at lists.osgeo.org <mailto:Qgis-user at lists.osgeo.org>
>
> List info:https://lists.osgeo.org/mailman/listinfo/qgis-user
>
> Unsubscribe:https://lists.osgeo.org/mailman/listinfo/qgis-user
>
> --
> *_Richard McDonnell_*
> *GIS Specialist PgD GIS AssocSCSI*
> *OPW FRM Data Management*
> *52 Stephens Green, Dublin 2.*
> TEL: 01 6476543
>
> <http://www.opw.ie/>
>
--
*_Richard McDonnell_*
*GIS Specialist PgD GIS AssocSCSI*
*OPW FRM Data Management*
*52 Stephens Green, Dublin 2.*
TEL: 01 6476543
OPW - Ag féachaint don am atá le teacht - Ag caomhnú ón am atá thart
OPW - Looking to the future - Caring for the past
***********************************************************
Email Disclaimer: http://www.opw.ie/en/disclaimer/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20170704/05c3a510/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 4785 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20170704/05c3a510/attachment.gif>
More information about the Qgis-user
mailing list