Re: [Qgis-user] Import German population data

[Bernhard Ströbl via QGIS-User]

Hallo Jonathan,

you can import the data as points using the X and Y fields (see manual 
[1]) but I suspect you want to display them as raster data 
(Hektarraster). Therefore you need to get the Hektarraster 1km grid data 
(from here I guess [2]). Each grid cell has an identifier (Field id); 
change your Gitter_ID_1km field's contents (or create a new field) to 
match the id field and join your csv data to the Hektarraster - done.


[1] 
https://docs.qgis.org/3.34/en/docs/user_manual/managing_data_source/opening_data.html#index-9
[2] 
https://gdz.bkg.bund.de/index.php/default/geographische-gitter-fur-deutschland-in-utm-projektion-geogitter-national.html


hope this helps

Bernhard


Am 06.07.24 um 14:47 schrieb Jonathan Berschauer via QGIS-User:

Hi Randy,

thank you for your quick answer!
Yes, i tried this, but then i got no layer, which i can select and 
convert into a grid (Vector -> Data Management Tools -> Join attributes 
by location (summary) [or something like that, i use an german ui).

Or how is the way to create a 1km/1km grid for this data?

Thanks!




Am 06.07.24 um 14:39 schrieb Randal Hale via QGIS-User:
Did you change the import to use a custom delimiter of semicolon and a 
geometry definition of "No Geometry"?


Randy


On 7/6/24 08:23, Jonathan Berschauer via QGIS-User wrote:

Hi everyone!

I want to import German population data ( 
https://www.statistikportal.de/de/veroeffentlichungen/georeferenzierte-bevoelkerungszahlen ) into QGIS.

The data is in ETRS89/LAEA / EPSG-3035 format.
I modified the CSV, so it looks like this:

==
Gitter_ID_1km;Zeitraum;Einwohner;X;Y
CRS3035RES1000mN3516000E4281000;2021;1403;4281000;3516000
CRS3035RES1000mN3516000E4282000;2021;1804;4282000;3516000
==

But when I import it as a layer, no data is shown...

Can anyone help?

Thank you very much!
Jonathan

___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user



___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user


___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Using Processing for nightly ETL jobs

[Bernhard Ströbl via QGIS-User]

Hi Björn,

yes that works. Only challenge is that you have to tell the algorithm which 
geometry type the data is, whereas QGIS' native PostGIS writer does check that 
for itself and use an appropriate one. Being not able to tell beforehand I 
established a geometry filter and use the multi type in the writer.

Bernhard

> pathmapper  hat am 30.05.2024 09:37 CEST geschrieben:
> 
>  
> Hi Bernhard,
> 
> not sure about the native "Export to PostgreSQL" algorithm, but there's 
> also a GDAL alg "Export to PostgreSQL (new connection)" which allows to 
> configure the DB access. Using this one in your model should do the 
> trick..
> 
> Cheers,
> Björn
> 
> On 30.05.2024 08:47, Bernhard Ströbl via QGIS-User wrote:
> > Hello everybody,
> > 
> > I did some experiments in the last couple days and your help was very
> > valuable. I succeeded in creating two models that - when run within
> > QGIS or from the console - download data of different types and write
> > it into a PostgreSQL database. For automation purposes I want to run
> > my models on a Linux server. I am wondering how I would configure the
> > database access. The algorythm "Export to PostgreSQL" takes the
> > connection name as input. The connection name is the name of a
> > pg-connection configured using the GUI (and backed by a saved
> > authentication in this case). There will be no GUI (and probably no
> > graphic server either) on the server machine. Does anybody know if
> > creating a profile with the connection (without authentication) and
> > placing that as default profile in the home directory of the user
> > running the model will do the trick? Or would I need a different
> > approach?
> > I cannot try it out because currently I still have no access to the 
> > server.
> > 
> > Any help appreciated
> > Bernhard
> > 
> > 
> >> Germán Carrillo  hat am 22.05.2024 23:30 
> >> CEST geschrieben:
> >> 
> >> 
> >> Hi All,
> >> 
> >> have a look at:
> >> 
> >> https://github.com/gacarrillor/AppendFeaturesToLayer
> >> 
> >> It has ready-to-use models to perform transform and upsert (update or
> >> insert) operations.
> >> 
> >> You can run it via standalone processing (Python) scripts or via QGIS
> >> Process.
> >> 
> >> Regards,
> >> 
> >> Germán
> >> 
> >> 
> >> El mié, 22 may 2024 a las 12:20, Etienne Trimaille via QGIS-User (<
> >> qgis-user@lists.osgeo.org>) escribió:
> >> 
> >> > Hi,
> >> >
> >> > https://docs.qgis.org/3.34/en/docs/user_manual/processing/standalone.html
> >> >
> >> > Le mer. 22 mai 2024 à 18:52, NOSPAM via QGIS-User <
> >> > qgis-user@lists.osgeo.org> a écrit :
> >> >
> >> >> Dear List,
> >> >>
> >> >> has anybody already used QGIS' processing framework for performing
> >> >> nightly ETL jobs?
> >> >>
> >> >> I need to have nightly jobs run that
> >> >> 1) download data (e.g. from a WFS server),
> >> >> 2) perform some tasks like renaming fields or the like
> >> >> 3) and finally load them into a PostGIS database.
> >> >>
> >> >> My idea would be to design the process using the modeller. How can I
> >> >> have the thus created model run non interactively?
> >> >>
> >> >> Any ideas are welcome
> >> >>
> >> >> Bernhard
> >> >> ___
> >> >> QGIS-User mailing list
> >> >> QGIS-User@lists.osgeo.org
> >> >> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> >> >> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
> >> >>
> >> > ___
> >> > QGIS-User mailing list
> >> > QGIS-User@lists.osgeo.org
> >> > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> >> > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
> >> >
> >> 
> >> 
> >> --
> >> ---
> >>|\__
> >> (:>__)(
> >>|/
> >> Soluciones Geoinformáticas Libres
> >> http://geotux.tuxfamily.org/
> >> https://twitter.com/GeoTux2 <http://twitter.com/GeoTux2>
> > ___
> > QGIS-User mailing list
> > QGIS-User@lists.osgeo.org
> > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Using Processing for nightly ETL jobs

[Bernhard Ströbl via QGIS-User]

Hello everybody,

I did some experiments in the last couple days and your help was very valuable. 
I succeeded in creating two models that - when run within QGIS or from the 
console - download data of different types and write it into a PostgreSQL 
database. For automation purposes I want to run my models on a Linux server. I 
am wondering how I would configure the database access. The algorythm "Export 
to PostgreSQL" takes the connection name as input. The connection name is the 
name of a pg-connection configured using the GUI (and backed by a saved 
authentication in this case). There will be no GUI (and probably no graphic 
server either) on the server machine. Does anybody know if creating a profile 
with the connection (without authentication) and placing that as default 
profile in the home directory of the user running the model will do the trick? 
Or would I need a different approach?
I cannot try it out because currently I still have no access to the server.

Any help appreciated
Bernhard


> Germán Carrillo  hat am 22.05.2024 23:30 CEST 
> geschrieben:
> 
>  
> Hi All,
> 
> have a look at:
> 
> https://github.com/gacarrillor/AppendFeaturesToLayer
> 
> It has ready-to-use models to perform transform and upsert (update or
> insert) operations.
> 
> You can run it via standalone processing (Python) scripts or via QGIS
> Process.
> 
> Regards,
> 
> Germán
> 
> 
> El mié, 22 may 2024 a las 12:20, Etienne Trimaille via QGIS-User (<
> qgis-user@lists.osgeo.org>) escribió:
> 
> > Hi,
> >
> > https://docs.qgis.org/3.34/en/docs/user_manual/processing/standalone.html
> >
> > Le mer. 22 mai 2024 à 18:52, NOSPAM via QGIS-User <
> > qgis-user@lists.osgeo.org> a écrit :
> >
> >> Dear List,
> >>
> >> has anybody already used QGIS' processing framework for performing
> >> nightly ETL jobs?
> >>
> >> I need to have nightly jobs run that
> >> 1) download data (e.g. from a WFS server),
> >> 2) perform some tasks like renaming fields or the like
> >> 3) and finally load them into a PostGIS database.
> >>
> >> My idea would be to design the process using the modeller. How can I
> >> have the thus created model run non interactively?
> >>
> >> Any ideas are welcome
> >>
> >> Bernhard
> >> ___
> >> QGIS-User mailing list
> >> QGIS-User@lists.osgeo.org
> >> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> >> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
> >>
> > ___
> > QGIS-User mailing list
> > QGIS-User@lists.osgeo.org
> > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
> >
> 
> 
> -- 
> ---
>|\__
> (:>__)(
>|/
> Soluciones Geoinformáticas Libres
> http://geotux.tuxfamily.org/
> https://twitter.com/GeoTux2 
___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Using Processing for nightly ETL jobs

[Bernhard Ströbl via QGIS-User]

Hi Germán,

thank you for your answer. That will definitely solve part of my needs.

all the best
Bernhard

> Germán Carrillo  hat am 22.05.2024 23:30 CEST 
> geschrieben:
> 
>  
> Hi All,
> 
> have a look at:
> 
> https://github.com/gacarrillor/AppendFeaturesToLayer
> 
> It has ready-to-use models to perform transform and upsert (update or
> insert) operations.
> 
> You can run it via standalone processing (Python) scripts or via QGIS
> Process.
> 
> Regards,
> 
> Germán
> 
> 
> El mié, 22 may 2024 a las 12:20, Etienne Trimaille via QGIS-User (<
> qgis-user@lists.osgeo.org>) escribió:
> 
> > Hi,
> >
> > https://docs.qgis.org/3.34/en/docs/user_manual/processing/standalone.html
> >
> > Le mer. 22 mai 2024 à 18:52, NOSPAM via QGIS-User <
> > qgis-user@lists.osgeo.org> a écrit :
> >
> >> Dear List,
> >>
> >> has anybody already used QGIS' processing framework for performing
> >> nightly ETL jobs?
> >>
> >> I need to have nightly jobs run that
> >> 1) download data (e.g. from a WFS server),
> >> 2) perform some tasks like renaming fields or the like
> >> 3) and finally load them into a PostGIS database.
> >>
> >> My idea would be to design the process using the modeller. How can I
> >> have the thus created model run non interactively?
> >>
> >> Any ideas are welcome
> >>
> >> Bernhard
> >> ___
> >> QGIS-User mailing list
> >> QGIS-User@lists.osgeo.org
> >> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> >> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
> >>
> > ___
> > QGIS-User mailing list
> > QGIS-User@lists.osgeo.org
> > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
> >
> 
> 
> -- 
> ---
>|\__
> (:>__)(
>|/
> Soluciones Geoinformáticas Libres
> http://geotux.tuxfamily.org/
> https://twitter.com/GeoTux2 
___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Using Processing for nightly ETL jobs

[Bernhard Ströbl via QGIS-User]

Hi Etienne,

I did read the docs, but that particular chapter slipped my attention, so thank 
you for nudging me. Seems like exactly what I might need.

Bernhard 

> Etienne Trimaille  hat am 22.05.2024 19:19 CEST 
> geschrieben:
> 
>  
> Hi,
> 
> https://docs.qgis.org/3.34/en/docs/user_manual/processing/standalone.html
> 
> Le mer. 22 mai 2024 à 18:52, NOSPAM via QGIS-User 
> a écrit :
> 
> > Dear List,
> >
> > has anybody already used QGIS' processing framework for performing
> > nightly ETL jobs?
> >
> > I need to have nightly jobs run that
> > 1) download data (e.g. from a WFS server),
> > 2) perform some tasks like renaming fields or the like
> > 3) and finally load them into a PostGIS database.
> >
> > My idea would be to design the process using the modeller. How can I
> > have the thus created model run non interactively?
> >
> > Any ideas are welcome
> >
> > Bernhard
> > ___
> > QGIS-User mailing list
> > QGIS-User@lists.osgeo.org
> > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
> >
___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Removal of overlap geometries within the same layer - merge to largest neighbor polygon

[Bernhard Ströbl via QGIS-User]

Hi Andreas,

I would like to give some explanations on your comment concerning the eliminate 
algorithm: During development the goal was to have a method that can get rid of 
sliver polygons (I explained my workflow for detecting them in my previous 
post). The algorithm simply merges the selected polygons with their specified 
neighbours. The attribute values of the neighbour stay as they are. What would 
you expect attributewise? Furthermore no definition of the polygons to 
eliminate is defined in the code thus it is up to the user to decide which 
polygons should go, hence it works on the selection. Making a tool that merely 
eliminates all overlaps would be a different task. The eliminate tool as it is 
has a broader use range, examples: You can only eliminate certain overlaps 
while keeping others. You can use it to generalize by getting rid of polygons 
smaller than a certain size. You have landuse data that contains polygons for a 
river but you want to use lines for the river, so get rid of all river 
polygons

regards 

Bernhard

> Andreas Neumann via QGIS-User  hat am 26.07.2023 
> 14:15 CEST geschrieben:
> 
>  
> Hi,
> 
> Thank you all for your feedback!
> 
> @Nyall - the GEOS/JTS capabilities for cleaning and validating geometries
> look definitely interesting. Something for an upcoming QGIS-CH grant
> perhaps ...
> 
> @Bernhard - I also had a look at and tested the "Eliminate selected
> polygons" algorithm - but it doesn't have a way to specify attribute
> handling nor grouping - and it is also strange that I have to select the
> polygons first and cannot run the algorithm on the whole data set as is
> 
> About SAGA: I couldn't get the SAGA stuff to work anymore
> About GRASS: it could be an option, but a native solution in QGIS would be
> preferred
> 
> So in summary: there are several options around for cleaning overlaps - but
> it isn't as straight-forward and user friendly yet as it could/should be.
> 
> I haven't looked at the gaps yet ...
> 
> Thank you all and greetings,
> Andreas
> 
> 
> On Tue, 25 Jul 2023 at 13:13, Bernhard Ströbl via QGIS-User <
> qgis-user@lists.osgeo.org> wrote:
> 
> > Hi Andreas,
> >
> > the Algorithm "Eliminate selected polygons" was originally created to
> > address these questions. I usually imported the data into GRASS ran a clean
> > there and reexported the results into a non topolgical dataset. Thus
> > overlapping areas and gaps (only if closed) are identified and can be
> > eliminated using the algorithm named above (selecting only a certain
> > area-circumference relation) by merging it with the adjacent polygon with
> > the smallest/largest area or the longest common boundary.
> > For your case you could have used this algorithm after the union to
> > identify overlaps.
> > As for an algorithm that does all this in one go: You would need something
> > that detects holes between polygons without the help of a toplogical data
> > format.
> >
> > regards
> > Bernhard
> >
> > > Andreas Neumann via QGIS-User  hat am
> > 25.07.2023 12:01 CEST geschrieben:
> > >
> > >
> > > Hi,
> > >
> > > A friend of mine has a dirty input data set with lots of overlapping
> > > geometries (within the same layer) and asked me if there is a tool
> > > within QGIS to automatically remove the overlaps and assign the
> > > overlapping area to the neighbor polygon with the largest area.
> > >
> > > The solution was surprisingly hard to find, although I am pretty sure
> > > there are multiple combinations of algorithms that would solve the
> > > problem. Here is the solution I came up with:
> > > https://github.com/qgis-ch/overlap_removal/tree/main [1]- perhaps you
> > > have better ideas - more elegant solutions?
> > >
> > > Wouldn't it be great if QGIS had a processing tool to solve this overlap
> > > cleaning within the same layer "out of the box" without having to use a
> > > graphical model or a more or less complicated sequence of algorithms in
> > > the processing toolbox? Apparently, ArcGIS has such a tool ...
> > >
> > > Saga and GRASS also might have such tools - but I couldn't get the SAGA
> > > based QGIS plugin "Dissect and dissolve overlaps"
> > > (https://plugins.qgis.org/plugins/dissect_dissolve_overlaps).
> > >
> > > The same problem exists for automatically filling small gaps in the
> > > polygon data set ...
> > >
> > > Andreas
> > >
> > >
> > >
> > > Links:
> > > --
> > > [1]
> 

Re: [Qgis-user] Removal of overlap geometries within the same layer - merge to largest neighbor polygon

[Bernhard Ströbl via QGIS-User]

Hi Andreas,

the Algorithm "Eliminate selected polygons" was originally created to address 
these questions. I usually imported the data into GRASS ran a clean there and 
reexported the results into a non topolgical dataset. Thus overlapping areas 
and gaps (only if closed) are identified and can be eliminated using the 
algorithm named above (selecting only a certain area-circumference relation) by 
merging it with the adjacent polygon with the smallest/largest area or the 
longest common boundary.
For your case you could have used this algorithm after the union to identify 
overlaps.
As for an algorithm that does all this in one go: You would need something that 
detects holes between polygons without the help of a toplogical data format. 

regards
Bernhard

> Andreas Neumann via QGIS-User  hat am 25.07.2023 
> 12:01 CEST geschrieben:
> 
>  
> Hi,
> 
> A friend of mine has a dirty input data set with lots of overlapping 
> geometries (within the same layer) and asked me if there is a tool 
> within QGIS to automatically remove the overlaps and assign the 
> overlapping area to the neighbor polygon with the largest area.
> 
> The solution was surprisingly hard to find, although I am pretty sure 
> there are multiple combinations of algorithms that would solve the 
> problem. Here is the solution I came up with: 
> https://github.com/qgis-ch/overlap_removal/tree/main [1]- perhaps you 
> have better ideas - more elegant solutions?
> 
> Wouldn't it be great if QGIS had a processing tool to solve this overlap 
> cleaning within the same layer "out of the box" without having to use a 
> graphical model or a more or less complicated sequence of algorithms in 
> the processing toolbox? Apparently, ArcGIS has such a tool ...
> 
> Saga and GRASS also might have such tools - but I couldn't get the SAGA 
> based QGIS plugin "Dissect and dissolve overlaps" 
> (https://plugins.qgis.org/plugins/dissect_dissolve_overlaps).
> 
> The same problem exists for automatically filling small gaps in the 
> polygon data set ...
> 
> Andreas
> 
> 
> 
> Links:
> --
> [1] 
> https://github.com/qgis-ch/overlap_removal/tree/main___
> QGIS-User mailing list
> QGIS-User@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Request for Guidance on Using 'Dissolve' Tool in QGIS with IUCN Data

[Bernhard Ströbl via QGIS-User]

Hi Marcello,

you can choose which fields QGIS should use for the dissolve process. Only 
features that are homogeneous throughout the chosen fields will be dissolved 
into a new feature.
Hope this helps
Bernhard


> Marcello Bilancioni via QGIS-User  hat am 
> 26.06.2023 01:54 CEST geschrieben:
> 
>  
> Good morning,
> 
> I am currently working with the mammal species distribution data provided
> by IUCN, and analyzing these shape files in QGIS.
> 
> As part of my analysis, I have been using the 'Dissolve' tool in QGIS to
> merge rows of the same species into a single entry. This operation is aimed
> at creating a single comprehensive polygon that represents each species'
> entire distribution range. However, while the tool successfully
> consolidates the geometries, it looses important attribute data from the
> original attribute table. In particular, this leads to the loss of valuable
> information within the "Presence" and "Origin" columns, where the values
> can differ across entries for the same species.
> 
> Could you provide any recommendations on how to avoid such data loss? Is
> there a strategy or method that could effectively summarize or retain this
> varied information while processing the data using the 'Dissolve' tool?
> 
> Furthermore, in my dataset, I have noticed some specific values under the
> "Presence" and "Origin" columns: "presence 3", "presence 6", and "origin 5"
> (I have attached a list with those species here). According to the IUCN
> guidelines, these values need to be updated or adjusted. Do you happen to
> know how to update these entries within QGIS best?
> 
> Thank you in advance for any assistance you can provide.
> 
> Best regards,
> 
> Marcello Bilancioni
> ___
> QGIS-User mailing list
> QGIS-User@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Shape file - Change "Polygon" to "Multipolygon"

[Bernhard Ströbl via QGIS-User]

If I remember it right there is no difference in the file itself. A shape file 
can digest single and multi geometries without changing its format. Are your 
polygons single or multi? If they are single it says single. Try adding some 
multi polygons and look what happens.
Bernhard

> Riccardo via QGIS-User  hat am 27.04.2023 12:06 
> CEST geschrieben:
> 
>  
> Good morning to all,
> 
> 
> I'm here again because I need another hint.
> 
> 
> I have shape file already created for a standard delivery.
> 
> 
> The geometry type of this shape file is “Polygon” and I have to change it 
> into “Multipolygon”.
> 
> 
> Is it possible? And how can I change this property in a shape file already 
> created without creating a new one?
> 
> 
> Many many thanks!
> 
> 
> Best Regards.
> 
> 
> Riccardo.
> 
> ___
> QGIS-User mailing list
> QGIS-User@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] [EXTERN] Re: Restrict User's access to extensions

[Bernhard Ströbl via QGIS-User]

Hi,

if the plugins are considered a security risk (no matter by whom and no matter 
if this is justified or not) then probably you should block access to all urls 
holding plugins on the network level. Your proposed approach is "security by 
obscurity" IMHO.
A more bureaucratic approach would be to have the users sign something that 
they agree not to download any plugins if not explicitly authorized by 
.

my 2 cents
Bernhard

> Rummer, Patrick (SGD Süd) via QGIS-User  hat am 
> 23.03.2023 09:06 CET geschrieben:
> 
>  
> Hello Richard,
> 
> thank you very much for your answer. I meant plugins, not "extensions", sry. 
> 
> Also, i found a way to simply disable the whole plugin menu within the " 
> QGISCUSTOMIZATION3.ini". 
> That's the easiest way and none of our users will find it, since it's under 
> %appdata%.
> 
> Also, i'm not the one who wants to block the plugins ;) but unfortunately i 
> have to.
> 
> Kind regards,
> 
> Patrick
> 
> 
> -Ursprüngliche Nachricht-
> Von: Richard Duivenvoorde  
> Gesendet: Donnerstag, 23. März 2023 09:00
> An: Rummer, Patrick (SGD Süd) ; 
> qgis-user@lists.osgeo.org
> Betreff: [EXTERN] Re: [Qgis-user] Restrict User's access to extensions
> 
> 
> Pff, best to use paper maps and a calculator then ;-)
> 
> But seriously: disabling selective extensions (I think you mean the python 
> 'plugins') is hard and totally remove python makes QGIS a lot less 
> productive/usable.
> 
> Not sure if you can remove the default qgis plugins repo (or make it 
> unreachable for your users), but if(!) so, you could try to remove that url, 
> and create your own repo which ONLY holds plugins you allow (but then you are 
> responsible to periodically update them). And off course a user can always 
> download the plugin from plugins.qgis.org as zip and install it (or even copy 
> it from another computer).
> 
> Or do you mean other extensions?
> 
> Regards,
> 
> Richard Duivenvoorde
> 
> 
> 
> On 3/22/23 14:00, Rummer, Patrick (SGD Süd) via QGIS-User wrote:
> > Hello there,
> > 
> > i don’t know if this ist he right list, so pardon me if not.
> > 
> > I have the unpleasant task to deploy QGIS to all of our users via matrix42 
> > which is a problem in itself.
> > 
> > Anyways, the question of our - let’s call him „CSO“ – is if we can restrict 
> > the access to extensions.
> > 
> > I know that you can disable it from within the program but anyone could 
> > simply reactivate it or use zip-files or whatever.
> > 
> > Is it possible to restrict that somehow?
> > 
> > Kind regards,
> > 
> > Patrick
> > 
> > 
> > ___
> > QGIS-User mailing list
> > QGIS-User@lists.osgeo.org
> > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
> 
> ___
> QGIS-User mailing list
> QGIS-User@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Incredibly slow attribute view/access from postgresv3.16

[Bernhard Ströbl]

Hi,
just a few ideas: Do you have a spatial index on the table?
I have no clue how QGIS handles the attribute table (loading all 
datasets in the first place and then select or else) maybe editing this 
many features is better done directly on the DB?


Bernhard

Am 05.10.2021 um 23:51 schrieb Andrew Hughes:

Hi All,

Just to get this out the way... *I don't believe this is a problem with 
the primary key or its index. *


I have a postgis datasource with approx 3 million features (road 
segments). Yep, lot-a-data.


The rendering performance is ok & visible @ 1:50,000+ . Takes a few 
seconds but hey, it's a lot of data and certainly not disappointing.


However, severe performance problems are seen whenever I am trying to 
work with anything related to attribution, such as "Open Attribute 
Table" or "modify the selected features or all attributes 
simultaneously". We're talking around 10 minutes of "/Not Responding/".


Note: I have altered the QGIS "/Settings -> Options -> Data Sources -> 
Feature Attributes and Tables/"    so that "/Show selected features/" is 
now the default attribute table behaviour. So _hopefully_, this doesn't 
attempt to load all 3million features.


Can anyone offer any guidance as to what I might be able to do to track 
down this issue (or just fix it)? For reference, we are trying to put 
together a simple editor that will allow a user to browse, select (road 
segment) features, and edit a single text attribute value on all 
selected features only. Fairly simple, but the UI elements we need 
appear to be in a world of pain.


Thanks in advance,
Andrew



___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user




__ Information from ESET Mail Security, version of virus signature 
database 24076 (20211005) __

The message was checked by ESET Mail Security.
http://www.eset.com






__ Information from ESET Mail Security, version of virus signature 
database 24078 (20211006) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Multi User - QGIS

[Bernhard Ströbl]

Hi,
i use a sequence for this and a trigger, that ensures that the sequence 
is used, no matter what user input comes from QGIS;


trigger function:

CREATE FUNCTION shema.table_ensure_sequence()
RETURNS trigger
AS $BODY$
DECLARE
str_execute text;
BEGIN
IF (TG_OP = 'INSERT') THEN
NEW.id := nextval('schema.table_id_seq'); -- use sequence
ELSIF (TG_OP = 'UPDATE') THEN
NEW.id := OLD.id; -- do not allow user changes in id
END IF;
RETURN NEW;
END;
$BODY$;

Bernhard


Am 13.09.2021 um 08:27 schrieb Alexander Klemm - km3 teledienst GmbH:

Hello,

we want to use QGIS to document our cable Infrastructure (We are an 
ISP). Now the Problem is, that 3 or 4 persons have to work with QGIS. 
Now my Idea was to provide a Postgresql Server with postgis installed. 
Thats working fine. The Project and the Layers are stored into the 
Postgresql Server and all Persons could work with it. Now my Problem is, 
that the Contents of the Layers must have an unique ID. The ID is set by 
the default value at the attribute form with/"maximum($id)+1"/. If two 
persons are working on the QGIS System, the Problem is, that there are 
duplicated IDs, because the IDs will not be stored immediately. Is there 
a solution for this problem?


thank you for helping
best regards

Alexander Klemm

Mit freundlichen Grüßen
Alexander Klemm


km3 teledienst GmbH - August-Bebel-Str. 86 - 08344 Grünhain-Beierfeld
Tel. +49 (0)3774 13931-0 - Fax +49 (0)3774 13931-02
bu...@km3.de - https://www.km3.de
Geschäftsführer: Heiko Lötzsch und Mike Bielagk
Registergericht: Amtsgericht Chemnitz - Handelsregister: B Nr. 18881
Umsatzsteuer-ID: DE 216 086 551 - Steuer-Nr.: 218 / 112 / 02921



__ Information from ESET Mail Security, version of virus 
signature database 23952 (20210913) __


The message was checked by ESET Mail Security.
http://www.eset.com 

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user




__ Information from ESET Mail Security, version of virus signature 
database 23952 (20210913) __

The message was checked by ESET Mail Security.
http://www.eset.com






__ Information from ESET Mail Security, version of virus signature 
database 23952 (20210913) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] remove slivers

[Bernhard Ströbl]

Hi Ursula,
try "eliminate selected polygons" from the processing toolbox
first step is to select, normally you would use the area-circumference 
ratio for the selection

second step "eliminate selected polygons"
Bernhard

Am 17.06.2021 um 15:33 schrieb Ursula Heinze:

Hi,
I do have a problem with sliver polygons in my layer. I read, that 
v.clean could be used to solve it, but I can´t access it.
Is there any easy method to automatically remove slivers? They are far 
too many to work with the Topology checker.

Thank you very much in advance!
Ursula


__ Information from ESET Mail Security, version of virus 
signature database 23478 (20210617) __


The message was checked by ESET Mail Security.
http://www.eset.com 

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user




__ Information from ESET Mail Security, version of virus signature 
database 23478 (20210617) __

The message was checked by ESET Mail Security.
http://www.eset.com






__ Information from ESET Mail Security, version of virus signature 
database 23478 (20210617) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Best practice, database vs WFS

[Bernhard Ströbl]

Hi,

I want to add my 2 cents (all AFAIK):
WFS is a standard for data exchange as has been pointed out by 
Alessandro already. The data are in an XML format (GML) which is _slow_ 
compared to data from a database for several reasons. QGIS downloads the 
complete layer as GML which, depending on the amount of datasets, can be 
huge. There is no spatial index helping QGIS in rendering. Using a layer 
from a database is fast because - assuming you created a spatial index - 
QGIS only loads the data needed for the particular part of the map you 
are currently viewing.


AFAIU you are running different database systems in you network (or 
different instances of the same system or different databases on one 
system). Depending on the amount of layers e.g. PostreSQL's concept of 
foreign data wrappers might be a solution (I do not know anything about 
performance though) enabling you to bundle all your layers in one 
PostgreSQL database.


Apart from the technical perspective: If you have e.g. several hundred 
layers you will always face the problem of how users know where to find 
a particular layer, even if theses layers are all in the same database 
(same would be true for several hundred WFS layers on one server btw). 
In this case you will always need some kind of metadata system where 
users can search for data and that tells them how they can access them.


regards
Bernhard


Am 06.01.2021 um 16:48 schrieb Paul Wittle:

Hi Alessandro,

I guess the key is ease of data discovery. So if all your geodata is on one 
database then it is all easy enough but if you have multiple database types / 
instances then you are relying a lot on users being able to find the right 
database / instance and then having potentially different login mechanisms for 
each database.

This is why the idea of WFS seems appealing because we can authenticate at 
access to the WFS server using a single method; expose all the accessible 
datasets in a single list and in theory potentially employ greater consistency 
to the method of updates.

We have found that the SQL issued by each database driver can vary in terms of 
the SQL optimisation because each one is developed independently of others 
(i.e. the Oracle data access is not necessary developed with much reference to 
the Postgres or SQL database data access clients). Whilst fundamentally the SQL 
statements are still in effect translated into the appropriate SQL for each 
database type the original statement should in theory be more consistent?

In terms of speed; I suspect you are definitely correct hence my asking the 
question really.

The comments above are really to simply flesh out the question as to whether or 
not using a database is really simpler though.

That said; we may also use something like a custom plugin or GeoNetwork as a 
data discovery tool which is another way of helping users add the right layer 
without needing to know which database it comes from.

I hope that clarifies the question a little better?

Cheers,
Paul

-Original Message-
From: Alessandro Pasotti 
Sent: 06 January 2021 15:11
To: Paul Wittle 
Cc: qgis-user@lists.osgeo.org
Subject: Re: [Qgis-user] Best practice, database vs WFS

Hi Paul,

if you want to share geodata within your organization on a private network a 
database is the best solution: faster and simpler. The constraint is that you 
will need an application (like QGIS) to access your data..

WFS is a web service standard for interoperability, it is ideal for sharing 
data on the internet over HTTP, there is no need for a particular application 
to use the service: any HTTP client is able to do that.

Regards


On Wed, Jan 6, 2021 at 3:43 PM Paul Wittle  
wrote:


Hi,



As I’m sure is clear from the number of posts I’ve done of late we are 
currently looking at how we use QGIS within our business. I thought I’d ask a 
question here to see if others are considering it as I can’t find too much chat 
online about it but I wondered if perhaps there should be some.



We have concluded that in theory the WFS and WFS-T protocols are an OGC 
standard (https://www.ogc.org/standards/wfs) and that using an OGC compliant 
server they can be used to front various data source formats; i.e. Postgres, 
Oracle, SQL Server etc. In theory that means that if you use WFS and WFS-T in 
QGIS it should mean that user experience becomes more consistent for the people 
using those layers in QGIS.



That all sounds great, but I can’t seem to even get my WFS to load correctly in 
QGIS at present and it doesn’t seem to be something that is recommended online. 
Given that both WFS and direct database access both return full details (vector 
geometries and attributes) to QGIS; would you expect performance of WFS to be 
similar or significantly slower?



Is the use of OGC compliant WFS something that you personally feel is something 
we should be aspiring to use more widely at the local / network level in QGIS 
or do you favour just loading directly from 

Re: [Qgis-user] QGIS slows PC to a point it is unusable

[Bernhard Ströbl]

Hi Peter,
to me this sounds like a problem with a badly coded plugin. Unload _all_ 
plugins and see if the permformance improves. If it does reload the 
plugins one by one to identify which is causing the trouble.
Of course you can also improve performance by indexing your shape files 
or using another data provider altogeher as has been proposed.

Bernhard

Am 09.01.2020 um 21:42 schrieb Peter Cornelissen:

Hi

I am finding that although my ShapeFIle tables in QGIS are not huge, my Windows 
10 PC virtually comes to a grinding halt and becomes unusable once I get to 
something like 50 layers. I am using about 6 or 7 ShapeFiles with different 
filters. I think it is related to the fact that approx. most of them having a 
rule based styles, some with about 20 rules per layer.

Restarting the PC sorts things out for a while, but soon as I start working on 
the project it quickly gets slower and again comes to a point where it again 
slows right down.

I've not seen anything relate to this issue online and I've seen tables which 
must be huge. Is it likely to be my PC or am I using the wrong methods? Would I 
be better using SpatiaLite to store the tables?

Thought?

Peter



__ Information from ESET Mail Security, version of virus signature 
database 20646 (20200109) __

The message was checked by ESET Mail Security.
http://www.eset.com



___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user





__ Information from ESET Mail Security, version of virus signature 
database 20648 (20200110) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Adding topological vertices

[Bernhard Ströbl]

Hi Jan,
sorry I cannot reproduce the behaviour you describe in QGIS 3.4.10. Be 
sure to read about the new vertex tool (and its changed behaviour 
compared to 2.*) in the manual [1]


Bernhard

[1] 
https://docs.qgis.org/3.4/en/docs/user_manual/working_with_vector/editing_geometry_attributes.html#vertex-tool


Am 09.08.2019 um 14:35 schrieb Jan Hartmann:

Hi all,

In QGIS 2 I could add a vertex on a segment shared by two polygons just 
by double-clicking on that segment. When topological editing was 
enabled, a new vertex was added to both polygons, and I could move them 
both just by dragging.


In QGIS 3, when topological editing is enabled, moving a shared vertex 
is a bit more complex. I cannot just click on that vertex and then click 
on the destination location, for then only one of the shared vertices is 
moved. I have to shift-drag around the vertex, then click on the 
selected vertices, and only then all shared vertices are moved. No 
problem with that, by the way.


The real problem is when I want to add a vertex on a shared segment. 
When I double-click on that segment, a new vertex appears, but only on 
one of the segments. I can move that vertex, but only one segment is 
moved. The underlying segments remain in place. To move them too, I have 
to create vertices on all of them, and move them all to the new 
location. This *is* a problem.


Is there a solution for this? Do I overlook something?

Regards,

Jan Hartmann
Amsterdam


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user




__ Information from ESET Mail Security, version of virus signature 
database 19852 (20190814) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Can't print large QGIS file

[Bernhard Ströbl]

Hi,

could that be a RAM problem? I remember that (in times of QGIS2) running 
32bit QGIS on Windows the RAM limit per application (I remember 4 GB) 
made it impossible to print larger maps (large in sense of large paper 
format with many features).

What system are you running QGIS on?

Bernhard

Am 18.07.2019 um 07:47 schrieb Genene Schumacher:
I am using QGIS 3.4.1   I have a map of the water & sewer assets for the 
authorities region.


I have a list of about 20 maps created and showing in Layout Manager.  
Most maps print but the one with lots of data (pipes) showing won’t 
export to pdf. QGIS crashes every time.


Any ideas how to get it into a pdf ?

Regards,

*Genene*




This e-mail, including any attachments, is confidential and for the sole 
use of the intended recipient(s). It may contain copyright and/or 
legally privileged material and/or personal information. If you are not 
the intended recipient, you are not authorised to disclose, copy, use, 
distribute or in any other way make use of the information contained in 
it, and such activities are prohibited. If you have received this e-mail 
in error, please notify the sender by reply e-mail, delete the document 
and destroy all copies of the original message.


There is no warranty that this email is error or virus free. Please 
consider the environment before printing.



__ Information from ESET Mail Security, version of virus 
signature database 19705 (20190718) __


The message was checked by ESET Mail Security.
http://www.eset.com

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user





__ Information from ESET Mail Security, version of virus signature 
database 19705 (20190718) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Auxiliary storage: not editable if layer is not editable

[Bernhard Ströbl]

Hi Paul,

thanks for your feedback. I figured out that the label-positioning 
buttons do indeed work but I was after setting an x-y offset for a point 
symbol.

I created a ticket meanwhile:
https://github.com/qgis/QGIS/issues/30376

Bernhard

Am 25.06.2019 um 14:25 schrieb Paul Blottiere:

Hi Bernhard,

 > I was under the impression that the auxiliary storage was designed to 
cover exactly this kind of situation.


Indeed you're right.

Actually you just have to use the "Move Label" map tool directly on 
labels, and their positions will be stored in auxiliary storage 
automatically. If you want to manually create corresponding fields, you 
have to use the "Store Data in the project" button in data defined menu.


Paul

Le lun. 24 juin 2019 à 10:07, Bernhard Ströbl <mailto:bernhard.stro...@jena.de>> a écrit :


Hi all,
I have a PostGIS relation that is not editable in QGIS (user has only
SELECT rights). I created a field in the auxiliary storage to insert
positioning information. I cannot edit this field because "toggle
editing" is disabled. I was under the impression that the auxiliary
storage was designed to cover exactly this kind of situation.
Anything I
am missing?

BTW I am using QGIS 3.4.8.

Bernhard


__ Information from ESET Mail Security, version of virus
signature database 19573 (20190624) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org <mailto:Qgis-user@lists.osgeo.org>
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user





__ Information from ESET Mail Security, version of virus signature 
database 19580 (20190625) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Auxiliary storage: not editable if layer is not editable

[Bernhard Ströbl]

Hi all,
I have a PostGIS relation that is not editable in QGIS (user has only 
SELECT rights). I created a field in the auxiliary storage to insert 
positioning information. I cannot edit this field because "toggle 
editing" is disabled. I was under the impression that the auxiliary 
storage was designed to cover exactly this kind of situation. Anything I 
am missing?


BTW I am using QGIS 3.4.8.

Bernhard


__ Information from ESET Mail Security, version of virus signature 
database 19573 (20190624) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Moving nodes

[Bernhard Ströbl]

The vertex tool has been redesigned for QGIS3, see [1]
You can lock a feature by right-clicking on it but you can also e.g. 
move nodes without locking the feature. Moving nodes is now left click 
(attach node to mouse) + left click (drop node at current mouse position)

Bernhard

[1] 
https://docs.qgis.org/3.4/en/docs/user_manual/working_with_vector/editing_geometry_attributes.html#vertex-tool


Am 02.04.2019 um 11:12 schrieb Amila Bajic:

Hi,

I'm trying to move one node from polygon, e.i I'm trying to modify one 
polygon (you can see the process on the attached image), I worked in 
QGIS before, but I had an older version.
I can't add new node to the polygon, I can't delete a node, I can't edit 
anything about the nodes of polygons, lines or points. I hope you 
understand what I'm asking.


<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail> 
	Virus-free. www.avast.com 
<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail> 



<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

On Tue, Apr 2, 2019 at 10:47 AM Bernhard Ströbl 
mailto:bernhard.stro...@jena.de>> wrote:


Hi Amila,
please be more specific and describe
a) what you do
b) what you expect to happen
c) what happens instead
Bernhard

Am 02.04.2019 um 10:34 schrieb Amila Bajic:
 > Hi Bernhard,
 >
 > I'm doing like that, but it doesn't work anyway. I've tried with the
 > right or left or both clicks, but nothing happens.
 >
 >
 >

<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail>

 >       Virus-free. www.avast.com <http://www.avast.com>
 >

<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail>

 >
 >
 > <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
 >
 > On Tue, Apr 2, 2019 at 10:01 AM Bernhard Ströbl
 > mailto:bernhard.stro...@jena.de>
<mailto:bernhard.stro...@jena.de <mailto:bernhard.stro...@jena.de>>>
wrote:
 >
 >     Hi Amila,
 >     1) Make layer editable (click on the "pencil")*
 >     2) use the vertex tool to edit nodes, e.g. move
 >     3) save edits (click on "pencil" again)
 >
 >     see
 >

https://docs.qgis.org/3.4/en/docs/user_manual/working_with_vector/editing_geometry_attributes.html#digitizing-an-existing-layer
 >
 >     * if the pencil is greyed out, you must not edit this layer
 >
 >     Bernhard
 >
 >     Am 02.04.2019 um 09:53 schrieb Amila Bajic:
 >      > Dear QGIS users,
 >      >
 >      > I'm using QGIS 3.6.0 (I tried this with QGIS 3.4.0 too, but it
 >     doesn't
 >      > work), but I can't move the nodes, it's such an easy
process, but it
 >      > doesn't work for me. I followed a lot of advices from
internet and
 >      > froums.  Do you know how could I fix that?!
 >      >
 >      > Best regards,
 >      > /Amila
 >      >
 >      >
 >   



__ Information from ESET Mail Security, version of virus signature 
database 19127 (20190402) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Moving nodes

[Bernhard Ströbl]

Hi Amila,
1) Make layer editable (click on the "pencil")*
2) use the vertex tool to edit nodes, e.g. move
3) save edits (click on "pencil" again)

see 
https://docs.qgis.org/3.4/en/docs/user_manual/working_with_vector/editing_geometry_attributes.html#digitizing-an-existing-layer


* if the pencil is greyed out, you must not edit this layer

Bernhard

Am 02.04.2019 um 09:53 schrieb Amila Bajic:

Dear QGIS users,

I'm using QGIS 3.6.0 (I tried this with QGIS 3.4.0 too, but it doesn't 
work), but I can't move the nodes, it's such an easy process, but it 
doesn't work for me. I followed a lot of advices from internet and 
froums.  Do you know how could I fix that?!


Best regards,
/Amila

 
	Virus-free. www.avast.com 
 



<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>




__ Information from ESET Mail Security, version of virus signature 
database 19126 (20190402) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] leicht verschobene Geometrien ansnappen/entzerren

[Bernhard Ströbl]

Hallo,
wenn Du einmal GRASS über den Datensatz "laufen" lässt, werden Dir 
überlappende Polygone und Löcher angezeigt. Hat der Datensatz keine 
gewollten Überlappungen und Löcher, kannst Du mit dem QGIS-Werkzeug 
"Splitterpolygone beseitigen" wieder eine saubere Topologie herstellen 
(dabei werden Deine Flächen natürlich minimal verändert, aber das geht 
ja gar nicht anders). Hat er gewollte, musst Du evtl. über das 
Verhältnis Umfang/Fläche die gewollten von den ungewollten (= 
Splitterpolygone) trennen.


Bernhard

Am 07.03.2019 um 08:26 schrieb Andreas Sauter:

Hallo Günter,

vielen Dank für die Antwort. Genau das ist das Problem! Befinde mich 
auch in BW und nutze BWTA2017. Hatte gehofft, dass über das Werkzeug 
"snapgeometry" oder das grass tool v.clean eine ausgewählte Geometrie 
wieder sauber an die benachbarte anzupassen... leider ohne Erfolg. Falls 
es eine Möglichkeit gäbe wäre das natürlich super, da ich viele 
benachbarte Geometrieben habe, die mir jetzt bei Verschnitten immer 
Splitterpolygone produzieren.


Viele Grüße
Andreas

---

Hallo Andreas,

die Liste ist nach meiner Kenntnis nur für englische Kommunikation.
In deutscher Sprache würde ich es in der 
fossgis-talk-liste-boun...@fossgis.de Liste probieren.


Zum Problem:
Ich verstehe nicht ganz wann "gesnappt" wurde aber zu diesem Thema kann 
ich auch nichts beitragen.


Bei der Transformation von GK nach UTM gibt es immer geringe 
Abweichungen im Millimeterbereich. Bei uns hier in BW (Transformation 
mit der BWTA2017) sind das nach meiner Erfahrung max. 5 mm. Aber diese 
lassen sich auch nicht vermeiden und sie sind auch unterschiedlich gross.


Wenn es größere Differenzen von einigen Dezimetern bis zu einem Meter 
sind, dann wurde wahrscheinlich für die Transformation von GK nach UTM 
nicht die landesspezifische Transformationsmatrix (in BW die BWTA2017) 
verwendet wurde, sondern die deutschlandweite BETA2007.


Gruß,   Günter

INGENIEURBÜRO HOMBURGER
www.forstlabor.de
Telefon: 07733 982588
Telefax: 07733 982589
Lupfenstr. 8
78234 Engen

Am 06.03.19 um 17:21 schrieb Andreas Sauter:

Hallo Zusammen,

habe ein kleines Problem mit digitalisierten Geometrien. Habe die 
Geometrien teilweise vor der Umstellung des Qgis-Projekts von Gauss 
Krüger auf UTM 32 digitalisiert und zum Teil danach. Nun wurde 
sichtbar, dass vermeintlich aneinander angesnappte, benachbarte 
Geometrien leicht verschoben zueinander liegen.


Wenn ich nun allerdings die Geometrien durch verschieben wieder 
aneinander snappen möchte, gelingt dies nur an dem einem Vertex 
perfekt, den man zum verschieben des Polygons verwendet. Bei extremem 
Zoomlevel sieht man, dass bei allen anderen Vertex-Punkten, die auf 
der selben Linie mit dem benachbarten Polygon liegen eine minimale 
Abweichung besteht.


Woran liegt das und weiß jemand von euch, wie kann man das beheben kann?

Viele Grüße
Andreas


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user




__ Information from ESET Mail Security, version of virus signature 
database 18986 (20190307) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] North arrow in QGIS

[Bernhard Ströbl]

Hi,

Am 13.02.2019 um 09:49 schrieb Richard Duivenvoorde:

On 2/13/19 9:30 AM, Werner Macho wrote:

Hi,

while I see that a lot of "other" GIS Software has its own button for
north arrows I am against adding a north-arrow button.

reasons:
While this is one of the few points which is not intuitive at a first
glance the user has to learn how to add the north arrow (and learn that
a north arrow is nothing else than an ordinary image).


To be honest I'm not so much a user of the Layout-part of QGIS, but
shouldn't the a North arrow be an essential property of a map, 


IMHO not, if north is at the top of the map; yes if otherwise


AND
should the North-arrow not always point to the North of the given crs?


yes



Trying out here in a layout, if I rotate the map 10 degrees, the arrow
image is fixed to top. Or do I miss something, like that you can 'fix an
image to the north' or so?



you have to connect the image with that map, so if the map is rotated so 
is the image (aka north arrow)




Another question that pops up: are all crs's always pointing to 0
degrees North? And if not is a crs aware of that?


There exist three different north directions:
a) magnetic north (probably not of interest here)
b) geographic north, i.e. the North Pole
c) map or crs north

depending on the crs b and c may be identical

the north arrow should point to c, but depending on the crs c may differ 
at different places in the map



If so I would opt for either some function to have an intelligent North
Arrow in layouts (which are aware of crs, so rotate with map), and which
can reuse the image dialogs?
Or add such intelligence to the already image props (besides a North
arrow I can think about images of a ground level which always have to be
horizontal or so)?

Sorry for popping up this questions...

Regards,

Richard Duivenvoorde




coming back to the original question: I would not mind to have an 
additional button for the north arrow, which would be a shortcut to 
create the image, choose a default north-arrow svg and connect it with 
the map.


Bernhard


__ Information from ESET Mail Security, version of virus signature 
database 18866 (20190213) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] [QGIS-Server] WFS-T

[Bernhard Ströbl]

Hi Jonathan,

thank you for looking into this. Basically I want to run a WFS-T Server 
(QGIS-Server), with any client, but to test the server I used QGIS desktop.
In QGIS desktop I specified the version to be 1.1, no idea why the 
transaction request is sent with version 1.0.0


extract from GetCapabilities:
WFS1.1.0
...

...

  projekt_pt
  projekt_pt
  EPSG:25832
  EPSG:3857
  
Query
Insert
  

So for me the question is: Does the client (QGIS desktop) generally work 
with a QGIS WFS-T Server? If yes why is it not working with my QGIS 
WFS-T Server?


Bernhard

Am 04.02.2019 um 18:36 schrieb Jonathan Moules:

Hi,

Well, taking the error at face value, it seems to be complaining that 
you have:

/REQUEST=Transaction/

in the URL. Which is odd because that's exactly what it should be 
(looking at the 1.0.0 spec).


But at the bottom of your error, it says:

10:15:17 WARNING [9148]: Service WFS 1.0.0 not found, returning default

So I'd suggest that QGIS Server doesn't support transactions for WFS 
1.0.0 (Transactions support is Optional). Except the QGIS docs say they 
do support Transaction: 
https://docs.qgis.org/2.8/en/docs/user_manual/working_with_ogc/ogc_server_support.html 
- and WFS 1.0.0 seems to be the only version supported by QGIS so... are 
the errors misleading? (I can't seem to readily find that page for QGIS 
3.4).


The GetCapabilities of the server will tell you if it supports Transaction.

Maybe someone who knows QGIS Server (I'm just basing this reply off the 
spec and your error) can comment.


Cheers,

Jonathan


On 2019-02-01 09:57, Bernhard Ströbl wrote:

Hi all,

I try to make an INSERT to QGIS-Server using WFS-T. But every insert 
fails with the server returning "Please check the value of the REQUEST 
parameter"


This is the QGIS-server log output (anonymised):

10:15:17 INFO Server[9148]:  New request 
***

10:15:17 INFO Server[9148]: SERVER_NAME***
10:15:17 INFO Server[9148]: REQUEST_URI/wms/pmt?SERVICE=WFS
10:15:17 INFO Server[9148]: REMOTE_ADDR10.***.***.**
10:15:17 INFO Server[9148]: CONTENT_TYPEtext/xml
10:15:17 INFO Server[9148]: HTTP_USER_AGENTMozilla/5.0 QGIS/3.4.3-Madeira
10:15:17 INFO Server[9148]: MAP:/var/www/wms/karten/pmt.qgs
10:15:17 INFO Server[9148]: REQUEST:Transaction
10:15:17 INFO Server[9148]: REQUEST_BODY:xmlns="http://www.opengis.net/wfs; version="1.0.0" service="WFS" 
xsi:schemaLocation="http://www.qgis.org/gml 
https://pmt-map.jena.de:443/wms/pmt?SERVICE=WFSREQUEST=DescribeFeatureTypeVERSION=1.0.0TYPENAME=projekt_pt; 
xmlns:gml="http://www.opengis.net/gml; 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance;>xmlns="http://www.opengis.net/wfs;>xmlns="http://www.qgis.org/gml;>xmlns="http://www.qgis.org/gml;>srsName="EPSG:25832">cs=",">681077.95823665894567966,5643649.1879350347151
10:15:17 INFO Server[9148]: SCHEMALOCATION:http://www.qgis.org/gml 
https://pmt-map.jena.de:443/wms/pmt?SERVICE=WFS=DescribeFeatureType=1.0.0=projekt_pt 


10:15:17 INFO Server[9148]: SERVICE:WFS
10:15:17 INFO Server[9148]: VERSION:1.0.0
10:15:17 WARNING [9148]: Service WFS 1.0.0 not found, returning default
10:15:17 INFO Server[9148]: Request finished in 1 ms

the apache error log says:
QNetworkDiskCache::prepare() unable to open temporary file

any help appreciated

System: QGIS-Server 3.4.4 on Ubuntu/Apache, WFS-Client QGIS Desktop 3.4.3

Bernhard


__ Information from ESET Mail Security, version of virus 
signature database 18802 (20190201) __


The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user




__ Information from ESET Mail Security, version of virus 
signature database 18819 (20190204) __


The message was checked by ESET Mail Security.
http://www.eset.com

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user




__ Information from ESET Mail Security, version of virus signature 
database 18822 (20190205) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] [QGIS-Server] WFS-T

[Bernhard Ströbl]

Hi all,

I try to make an INSERT to QGIS-Server using WFS-T. But every insert 
fails with the server returning "Please check the value of the REQUEST 
parameter"


This is the QGIS-server log output (anonymised):

10:15:17 INFO Server[9148]:  New request ***
10:15:17 INFO Server[9148]: SERVER_NAME***
10:15:17 INFO Server[9148]: REQUEST_URI/wms/pmt?SERVICE=WFS
10:15:17 INFO Server[9148]: REMOTE_ADDR10.***.***.**
10:15:17 INFO Server[9148]: CONTENT_TYPEtext/xml
10:15:17 INFO Server[9148]: HTTP_USER_AGENTMozilla/5.0 QGIS/3.4.3-Madeira
10:15:17 INFO Server[9148]: MAP:/var/www/wms/karten/pmt.qgs
10:15:17 INFO Server[9148]: REQUEST:Transaction
10:15:17 INFO Server[9148]: REQUEST_BODY:xmlns="http://www.opengis.net/wfs; version="1.0.0" service="WFS" 
xsi:schemaLocation="http://www.qgis.org/gml 
https://pmt-map.jena.de:443/wms/pmt?SERVICE=WFSREQUEST=DescribeFeatureTypeVERSION=1.0.0TYPENAME=projekt_pt; 
xmlns:gml="http://www.opengis.net/gml; 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance;>xmlns="http://www.opengis.net/wfs;>xmlns="http://www.qgis.org/gml;>xmlns="http://www.qgis.org/gml;>srsName="EPSG:25832">cs=",">681077.95823665894567966,5643649.1879350347151
10:15:17 INFO Server[9148]: SCHEMALOCATION:http://www.qgis.org/gml 
https://pmt-map.jena.de:443/wms/pmt?SERVICE=WFS=DescribeFeatureType=1.0.0=projekt_pt

10:15:17 INFO Server[9148]: SERVICE:WFS
10:15:17 INFO Server[9148]: VERSION:1.0.0
10:15:17 WARNING [9148]: Service WFS 1.0.0 not found, returning default
10:15:17 INFO Server[9148]: Request finished in 1 ms

the apache error log says:
QNetworkDiskCache::prepare() unable to open temporary file

any help appreciated

System: QGIS-Server 3.4.4 on Ubuntu/Apache, WFS-Client QGIS Desktop 3.4.3

Bernhard


__ Information from ESET Mail Security, version of virus signature 
database 18802 (20190201) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] After deleting points, attribute rows persist

[Bernhard Ströbl]

Hi Matthias

Am 08.01.2019 um 09:21 schrieb Matthias Kuhn:
On point layers, I was always thinking of points being composed of a 
single node. On multi point layers, I was thinking of each part being 
composed of a single node, so I wasn't thinking of "either a node or a 
point" but both. With this concept in mind, the whole set of available 
tools works fine and predictable for me.


Well, in GIS a vertex is normally defined as a point being part of a 
line [1], [2] therefore calling a tool "vertex tool" and making it 
working on points seems inconsistent to me (in the previous mail I 
called it "node tool", that was my mistake, I know saw it is in fact 
called "vertex tool"), although, as I said, I do not really care, just 
pointing out.




Moving parts is supported now via the node tool by selecting all nodes 
of a part. It's also possible to delete a part on a 
multiline/multipolygon layer with the node tool. So also with respect to 
this it doesn't do anything special for point layers.


Oh, I was not aware of this, although selecting only the nodes of one 
part can be impossible with the new vertex tool (see my related mail 
last month), so the use is limited.




I can see, that it may lead to confusion sometimes as described in the 
original email here. I am not able to say how often this happens in 
comparison to how often the node tool is used consciously.


The delete part tool can lead to confusion, too. I regularly have users 
that click delete part instead of delete feature and end up with 
geometryless datasets. Concerning the original question I think the 
behaviour to not delete the feature is definitely ok.




The node tool even gives a hint on the message bar, that "the geometry 
has been cleared, please use the add part tool to set the geometry for 
this feature". So it's trying to not be too obscure. Maybe the whole 
confusion can be ironed out by polishing this text a bit?


Considering the separate tool for moving parts of multi-geometries, I 
agree it sounds like a valid tool to have, but I am a bit concerned of 
the clutter to benefit ratio. Does anyone have an idea how often this 
would be useful in reality?


I did never have any need for it in the last couple years :-)

Bernhard

[1] https://gisgeography.com/gis-dictionary-definition-glossary/#V
[2] https://portal.opengeospatial.org/files/?artifact_id=25354 page 24


On 1/8/19 9:02 AM, Havard Tveite wrote:

I agree that disabling the vertex tool for point layers is a good
idea.  It will improve consistency and avoid confusion.
A separate tool for moving a part of a multi-geometry would be
useful.

Håvard

On 08. jan. 2019 07:53, Bernhard Ströbl wrote:

Hi Saber,

Delete a single point (part) in a multi-point layer with remove part 
tool (as you would with e.g. a multi-polygon layer).
Move single point in a multi-point layer: There is no option to move 
a part in a multi-line or multi-polygon layer either (or I am not 
aware of it). Why is it different for multi-point? If there is a need 
to move parts in a multi-* layer, a dedicated tool should be 
established IMHO covering all cases.


Do not misunderstand me, I really do not bother but I started 
thinking about the tool's behaviour for point layers during this 
thread and IMHO the behaviour is not consistent:

1) the tool is called _node_ but it works on _points_, too
2) It can be used to move/delete single point geometries or parts of 
multi-points, but it cannot be used to move parts when editing lines 
or polygons (neither single nor multi), furthermore for deleting 
parts there is another tool that does exactly the same.


Bernhard

Am 07.01.2019 um 16:59 schrieb Saber Razmjooei:

Hi Bernhard,

How about multi-point layer? All the features will move/delete with 
the other tools.


Regards
Saber

On Mon, 7 Jan 2019 at 15:55, Bernhard Ströbl 
mailto:bernhard.stro...@jena.de>> wrote:


    Maybe the node tool shouldn't be available when editing a point 
layer?

    Anything one may want to do with points can be done using the other
    tools (move, delete part). I was always wondering why it is there
    because AFAIU nodes are not individual features, they only exist as
    part
    of a line or polygon boundary, but points in a point layer are
    individual features themselves.

    Bernhard

    Am 07.01.2019 um 16:25 schrieb DelazJ:
 > Hi Micha,
 >
 > The Node Tool is not meant to remove features, but to 
edit/remove

    their
 > geometries. Your feature persists in your dataset through their
 > attributes and you can later use the "Add part" tool to 
create a new

 > geometry.
 >
https://docs.qgis.org/testing/en/docs/user_manual/working_with_vector/editing_geometry_attributes.html#vertex-tool 

 > For full deletion (data + geometry), you should use the the 
"Delele

 > selected" tool, with a red bin.
 >
 >

Re: [Qgis-user] After deleting points, attribute rows persist

[Bernhard Ströbl]

Hi Saber,

Delete a single point (part) in a multi-point layer with remove part 
tool (as you would with e.g. a multi-polygon layer).
Move single point in a multi-point layer: There is no option to move a 
part in a multi-line or multi-polygon layer either (or I am not aware of 
it). Why is it different for multi-point? If there is a need to move 
parts in a multi-* layer, a dedicated tool should be established IMHO 
covering all cases.


Do not misunderstand me, I really do not bother but I started thinking 
about the tool's behaviour for point layers during this thread and IMHO 
the behaviour is not consistent:

1) the tool is called _node_ but it works on _points_, too
2) It can be used to move/delete single point geometries or parts of 
multi-points, but it cannot be used to move parts when editing lines or 
polygons (neither single nor multi), furthermore for deleting parts 
there is another tool that does exactly the same.


Bernhard

Am 07.01.2019 um 16:59 schrieb Saber Razmjooei:

Hi Bernhard,

How about multi-point layer? All the features will move/delete with the 
other tools.


Regards
Saber

On Mon, 7 Jan 2019 at 15:55, Bernhard Ströbl <mailto:bernhard.stro...@jena.de>> wrote:


Maybe the node tool shouldn't be available when editing a point layer?
Anything one may want to do with points can be done using the other
tools (move, delete part). I was always wondering why it is there
because AFAIU nodes are not individual features, they only exist as
part
of a line or polygon boundary, but points in a point layer are
individual features themselves.

Bernhard

Am 07.01.2019 um 16:25 schrieb DelazJ:
 > Hi Micha,
 >
 > The Node Tool is not meant to remove features, but to edit/remove
their
 > geometries. Your feature persists in your dataset through their
 > attributes and you can later use the "Add part" tool to create a new
 > geometry.
 >

https://docs.qgis.org/testing/en/docs/user_manual/working_with_vector/editing_geometry_attributes.html#vertex-tool
 > For full deletion (data + geometry), you should use the the "Delele
 > selected" tool, with a red bin.
 >
 > Regards,
 > Harrissou
 >
 > Le lun. 7 janv. 2019 à 16:15, Micha Silver mailto:tsvi...@gmail.com>
 > <mailto:tsvi...@gmail.com <mailto:tsvi...@gmail.com>>> a écrit :
 >
 >     Hi Alex:
 >
 >     Linux Mint 19
 >
 >     gdal 2.2.3
 >
 >     QGIS 3.4.3
 >
 >
 >     Just out of curiosity, I did the same on a debian buster machine
 >     (QGIS 2.18) and found the same: deleting vertices (with the node
 >     tool) on a point vector layer does not delete the attribute rows.
 >
 >
 >     On 1/6/19 11:38 PM, Alexandre Neto wrote:
 >>     What's your platform?
 >>     What's the version of gdal?
 >>
 >>     Thanks,
 >>
 >>     Alex Neto
 >>
 >>     A dom, 6/01/2019, 12:55, Micha Silver mailto:tsvi...@gmail.com>
 >>     <mailto:tsvi...@gmail.com <mailto:tsvi...@gmail.com>>> escreveu:
 >>
 >>         I have found that after deleting some points in both a
 >>         shapefile and a geopackage layer, the attribute rows
remain in
 >>         the table (with null geometry). Is this expected? I'm using
 >>         3.4.3, and I don't remember that being so in earlier
versions.
 >>
 >>
 >>         I removed the "phantom" rows by selecting by expression:
 >>         '$geometry is null' and then deleting. Still the
behavior was
 >>         surprising. I hope this is not a resurrection of
 >> https://issues.qgis.org/issues/11007 ??
 >>
 >>
 >>         Thanks
 >>
 >>         --
 >>         Micha Silver
 >>         Ben Gurion Univ.
 >>         Sde Boker, Remote Sensing Lab
 >>         cell: +972-523-665918
 >>
 >>         ___
 >>         Qgis-user mailing list
 >> Qgis-user@lists.osgeo.org <mailto:Qgis-user@lists.osgeo.org>
<mailto:Qgis-user@lists.osgeo.org <mailto:Qgis-user@lists.osgeo.org>>
 >>         List info:
https://lists.osgeo.org/mailman/listinfo/qgis-user
 >>         Unsubscribe:
https://lists.osgeo.org/mailman/listinfo/qgis-user
 >>
 >>     --
 >>     Alexandre Neto
 >>     -
 >>     @AlexNetoGeo
 >> http://sigsemgrilhetas.wordpress.com
 >> http://gisunchained.wordpress.com
 >
 >    

Re: [Qgis-user] After deleting points, attribute rows persist

[Bernhard Ströbl]

Maybe the node tool shouldn't be available when editing a point layer? 
Anything one may want to do with points can be done using the other 
tools (move, delete part). I was always wondering why it is there 
because AFAIU nodes are not individual features, they only exist as part 
of a line or polygon boundary, but points in a point layer are 
individual features themselves.


Bernhard

Am 07.01.2019 um 16:25 schrieb DelazJ:

Hi Micha,

The Node Tool is not meant to remove features, but to edit/remove their 
geometries. Your feature persists in your dataset through their 
attributes and you can later use the "Add part" tool to create a new 
geometry.

https://docs.qgis.org/testing/en/docs/user_manual/working_with_vector/editing_geometry_attributes.html#vertex-tool
For full deletion (data + geometry), you should use the the "Delele 
selected" tool, with a red bin.


Regards,
Harrissou

Le lun. 7 janv. 2019 à 16:15, Micha Silver > a écrit :


Hi Alex:

Linux Mint 19

gdal 2.2.3

QGIS 3.4.3


Just out of curiosity, I did the same on a debian buster machine
(QGIS 2.18) and found the same: deleting vertices (with the node
tool) on a point vector layer does not delete the attribute rows.


On 1/6/19 11:38 PM, Alexandre Neto wrote:

What's your platform?
What's the version of gdal?

Thanks,

Alex Neto

A dom, 6/01/2019, 12:55, Micha Silver mailto:tsvi...@gmail.com>> escreveu:

I have found that after deleting some points in both a
shapefile and a geopackage layer, the attribute rows remain in
the table (with null geometry). Is this expected? I'm using
3.4.3, and I don't remember that being so in earlier versions.


I removed the "phantom" rows by selecting by expression:
'$geometry is null' and then deleting. Still the behavior was
surprising. I hope this is not a resurrection of
https://issues.qgis.org/issues/11007 ??


Thanks

-- 
Micha Silver

Ben Gurion Univ.
Sde Boker, Remote Sensing Lab
cell: +972-523-665918

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org 
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

-- 
Alexandre Neto

-
@AlexNetoGeo
http://sigsemgrilhetas.wordpress.com
http://gisunchained.wordpress.com


-- 
Micha Silver

Ben Gurion Univ.
Sde Boker, Remote Sensing Lab
cell: +972-523-665918

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org 
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user



___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user





__ Information from ESET Mail Security, version of virus signature 
database 18665 (20190107) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Node Tool - proposing improvements

[Bernhard Ströbl]

Hi Nyall,

the reason to post this issue to the users' list was to get feedback 
from users (and developers, too). I am totally aware that a QEP would be 
appropriate but I doubt that many users are taking part in the 
discussion there.
Anyways I am going to sum up the results and create a proposal later on, 
will that do?


Bernhard

Am 27.11.2018 um 01:23 schrieb Nyall Dawson:

On Mon, 26 Nov 2018 at 21:39, Bernhard Ströbl  wrote:


Dear all,

I want to apologize, this has become an extremely long mail...

A lot of discussion has been going on about the recent reimplementation
of the node tool in QGIS 3.


Hi Bernhard,

Thanks for the detailed proposal, and for taking the time to come up
with a constructive way forward here.

Can I encourage you to copy the contents of your proposal across to
the "QEP" repository:
https://github.com/qgis/QGIS-Enhancement-Proposals/issues ? I think
that's the correct channel to discuss these ideas so that the
conversation is kept central and recorded permanently for reference.

Nyall



I see two reasons for this:
1) The way the tool works is very different from the way it used to work
in QGIS 2:
a) in QGIS 2 it was choose feature - choose node(s) - do something
whereas in QGIS 3 it is choose node - do something
b) to move a node was click - (keep pressed) - move - release which was
changed to click - release - move - click - release
2) There have been several bugs (as could be expected with a new
implementation). These, however, were used to question the whole feature
(most of the bugs are fixed now).

Apart from bugs and people not being used to the new tool the critics
concentrate around:
1) Probably most annoying: Mouse movements for choosing an existing
vertex/adding a new vertex at the middle of the line are not well
defined (especially important if features and its vertices are very
close together). Imagine a polygon surrounded (or even worse:
overlapped) by others, now try to click a particular vertex. You will
fail if always the neighbouring polygon is highlighted. The workaround
is to select the vertex with a mouse window while its feature is
highlighted (or previously select the feature e.g. with the
Select-Feature tool). For overlapping features it is even harder.
2) Highlighting effect is disturbing.
3) Adding a new vertex puts the new vertex on the mouse ready to be
moved but user has no intention to move it but to leave it where it has
been added (e.g. for topological reasons).
4) Vertices are not visible all the time but only when the feature is
highlighted. This can make choosing a particular vertex difficult (see
also 1).
5) It is easy to accidentally add or move a vertex because the most
intuitive way of selecting something is to click it. But when you click
a vertex/segment/cross while being highlighted you are already on your
way to move it.
6) The behaviour is not consistent:
a) If you want to move _one_ vertex, try to grab it when it is
highlighted then move it; if you want to move several vertices, first
select them, then click them, then move them.
b) If you want to delete a vertex, try to grab it when it is
highlighted; if you want to delete a segment, do not try to grab it when
it is highlighted but select its two vertices and delete them.

The German user group thinks that the points raised above are valid,
even if all pending bugs are fixed. The node tool is still not perfect
(it wasn't in QGIS 2 either).

So we propose a change in the way the node tool works and would like to
hear other users' s opinions.
While the click - move - click change has valid reasons (use advance
digitizing panel, pan or zoom map while moving vertices) the dropping of
the first choose feature - then choose vertex workflow to immediately
move a vertex has no real reasoning (except that it is less clicks in
those cases where the node can be easily grabbed in the first place).
But this new workflow is the main cause for the problems listed above.

Therefore we would like to see the old workflow reimplemented with some
of the new ideas added plus some new ingredients. This is the draft for
how the tool might work in the future:

1) While the mouse is moved around features are highlighted to indicate
they can be edited. Furthermore eventual vertices, segments or crosses
are highlighted, too (as in QGIS 3).
2) While a feature is being highlighted, it can be chosen with a left
click (new).
3) If the user makes a right click instead, another (adjacent) feature
is highlighted and can be chosen with a subsequent left click and so on
(new).
4) As soon as a feature is chosen, the Vertex-Editor panel is opened (as
in QGIS 2).
5) A chosen feature is the only feature whose vertices can be edited at
that point* (as in QGIS 2). The chosen feature and all its vertices stay
visible until the end of this feature's editing session (as in QGIS 2).
If a vertex was highlighted it is immediately selected, if a segment was
highlighted, its two vertices are immediatel

Re: [Qgis-user] Node Tool - proposing improvements

[Bernhard Ströbl]

Hi Denis,
thanks for answering

Am 26.11.2018 um 14:00 schrieb Denis Rouzaud:

Hi all,

Thanks a lot for summarising this all.


Basically I was reviewing all related issues to see which need to be 
fixed, thus I really played a lot with the new node tool.




All these issues seem very valid to me, but the logic of bringing back the
selection of the feature has no valid reasoning to me.

I see a few things that could be improved to solve these issues:

1) choosing/adding vertex in a dense area:
We could introduce a feature-locking: whenever you have highlighted a
feature, pressing ALT would lock the feature. That would allow you to
safely add/choose/move a vertex on that feature.


Would do for any feature that highlights in the first place. Problem is 
that you might have to move around the mouse pointer a lot until your 
desired feature highlights and features totally overlapped by others 
might still be more cumbersome. That's where the proposal to switch 
through the features with right clicks brings improvement. Locking the 
feature with ALT would be the same as my choose-proposal but less 
intuitive than a left click.




2) Highlighting:
The fact that the highlighting is disturbing is a bit subjective to me.
Is it too aggressive? If so, default colour and width could be tuned a bit
I guess.


This was a point raised in one issue and I agree it is subjective. Maybe 
it is related to the above, that you have to move around the mouse 
pointer a lot and all the times some feature highlights?




3) Adding vertex should stay where it was pressed:
The solution you propose in 13 seems really good to me (double click adding
leaves new vertex in place).

4) vertices not alway highlighted:
solution proposed in 1) would also tackle this one I think.

5) accidental add/move
I think that this will only be achieved by training. It is indeed a bit
less intuitive than previous behaviour. 


IMHO the more intuitive a software behaves the better


But I don't see any way to change this. 


Could you explain why?


A right click very cancels very quickly anything anyway.

6) consistency
a) moving vertices
I don't see the inconsistency here. You can select a vertex and move it
later, similarly to moving several. Moving a single by simply clicking on
is just a shortcut to me.


agreed, I could live with that


b) deleting segments vs vertices
I think that this also comes with training. The reasoning is that you can
only select vertices and not segments, and you can delete only what has
been selected. 


If you can only select vertices then the two vertices should be selected 
when the segment has been clicked on.



You are never selecting a segment (it never comes blue),


Current behaviour is that you "select" the segment and are ready to move it.


clicking on it is only a shortcut to move it. Is there a need to be able to
delete segments faster?


We do not know what users do. I personally neither need a way to delete 
two-vertex segments nor to move them faster than the normal way. But the 
current behaviour is kinda "nervous" and if you click in the wrong 
moment you have to abolish your move with a right click and try again.




I think the vertex tool became very powerful at the cost of a steeper
learning curve. I would really be in favour of trying these ideas before
adding a click in all operations with the tool.



regards

Bernhard



Cheers,
Denis


Le lun. 26 nov. 2018 à 07:33, Bernhard Ströbl  a
écrit :


Dear all,

I want to apologize, this has become an extremely long mail...

A lot of discussion has been going on about the recent reimplementation
of the node tool in QGIS 3.

I see two reasons for this:
1) The way the tool works is very different from the way it used to work
in QGIS 2:
a) in QGIS 2 it was choose feature - choose node(s) - do something
whereas in QGIS 3 it is choose node - do something
b) to move a node was click - (keep pressed) - move - release which was
changed to click - release - move - click - release
2) There have been several bugs (as could be expected with a new
implementation). These, however, were used to question the whole feature
(most of the bugs are fixed now).

Apart from bugs and people not being used to the new tool the critics
concentrate around:
1) Probably most annoying: Mouse movements for choosing an existing
vertex/adding a new vertex at the middle of the line are not well
defined (especially important if features and its vertices are very
close together). Imagine a polygon surrounded (or even worse:
overlapped) by others, now try to click a particular vertex. You will
fail if always the neighbouring polygon is highlighted. The workaround
is to select the vertex with a mouse window while its feature is
highlighted (or previously select the feature e.g. with the
Select-Feature tool). For overlapping features it is even harder.
2) Highlighting effect is disturbing.
3) Adding a new vertex puts the new vertex on the mouse ready to be
moved but u

[Qgis-user] Node Tool - proposing improvements

[Bernhard Ströbl]

Dear all,

I want to apologize, this has become an extremely long mail...

A lot of discussion has been going on about the recent reimplementation 
of the node tool in QGIS 3.


I see two reasons for this:
1) The way the tool works is very different from the way it used to work 
in QGIS 2:
a) in QGIS 2 it was choose feature - choose node(s) - do something 
whereas in QGIS 3 it is choose node - do something
b) to move a node was click - (keep pressed) - move - release which was 
changed to click - release - move - click - release
2) There have been several bugs (as could be expected with a new 
implementation). These, however, were used to question the whole feature 
(most of the bugs are fixed now).


Apart from bugs and people not being used to the new tool the critics 
concentrate around:
1) Probably most annoying: Mouse movements for choosing an existing 
vertex/adding a new vertex at the middle of the line are not well 
defined (especially important if features and its vertices are very 
close together). Imagine a polygon surrounded (or even worse: 
overlapped) by others, now try to click a particular vertex. You will 
fail if always the neighbouring polygon is highlighted. The workaround 
is to select the vertex with a mouse window while its feature is 
highlighted (or previously select the feature e.g. with the 
Select-Feature tool). For overlapping features it is even harder.

2) Highlighting effect is disturbing.
3) Adding a new vertex puts the new vertex on the mouse ready to be 
moved but user has no intention to move it but to leave it where it has 
been added (e.g. for topological reasons).
4) Vertices are not visible all the time but only when the feature is 
highlighted. This can make choosing a particular vertex difficult (see 
also 1).
5) It is easy to accidentally add or move a vertex because the most 
intuitive way of selecting something is to click it. But when you click 
a vertex/segment/cross while being highlighted you are already on your 
way to move it.

6) The behaviour is not consistent:
a) If you want to move _one_ vertex, try to grab it when it is 
highlighted then move it; if you want to move several vertices, first 
select them, then click them, then move them.
b) If you want to delete a vertex, try to grab it when it is 
highlighted; if you want to delete a segment, do not try to grab it when 
it is highlighted but select its two vertices and delete them.


The German user group thinks that the points raised above are valid, 
even if all pending bugs are fixed. The node tool is still not perfect 
(it wasn't in QGIS 2 either).


So we propose a change in the way the node tool works and would like to 
hear other users' s opinions.
While the click - move - click change has valid reasons (use advance 
digitizing panel, pan or zoom map while moving vertices) the dropping of 
the first choose feature - then choose vertex workflow to immediately 
move a vertex has no real reasoning (except that it is less clicks in 
those cases where the node can be easily grabbed in the first place). 
But this new workflow is the main cause for the problems listed above.


Therefore we would like to see the old workflow reimplemented with some 
of the new ideas added plus some new ingredients. This is the draft for 
how the tool might work in the future:


1) While the mouse is moved around features are highlighted to indicate 
they can be edited. Furthermore eventual vertices, segments or crosses 
are highlighted, too (as in QGIS 3).
2) While a feature is being highlighted, it can be chosen with a left 
click (new).
3) If the user makes a right click instead, another (adjacent) feature 
is highlighted and can be chosen with a subsequent left click and so on 
(new).
4) As soon as a feature is chosen, the Vertex-Editor panel is opened (as 
in QGIS 2).
5) A chosen feature is the only feature whose vertices can be edited at 
that point* (as in QGIS 2). The chosen feature and all its vertices stay 
visible until the end of this feature's editing session (as in QGIS 2). 
If a vertex was highlighted it is immediately selected, if a segment was 
highlighted, its two vertices are immediately selected, if the middle of 
a segment was highlighted with a cross a new vertex is created there and 
immediately selected (new).

6) A vertex is selected by left clicking on it (as in QGIS 2).
7) Several vertices are selected by using a mouse window (as in QGIS 2 
and 3).

8) A click on a segment selects its two vertices (as in QGIS 2).
9) Vertices can be selected via the Vertex-Editor panel, too (as was in 
QGIS 2)
10) Every new vertex selection clears any previuos selection except if 
Crtl is pressed which adds the new selection to the current if vertices 
were not selected or subtracts them from the current selection if they 
were selected (as in QGIS 2).

11) Selected vertices can be deleted (as in QGIS 2 and 3).
12) Selected vertices can be moved by clicking either of them, thus the 
vertex (the vertices) are 

Re: [Qgis-user] trouble with WMS layer

[Bernhard Ströbl]

Hi,
all that comes to my mind is that the layer is named Mass.1to250k. If 
this stands for Massachusetts scale 1 to 25 I would not wonder to 
have nothing displayed when requesting the whole world. You get an empty 
map not an error, do you?
IMHO this is a configuration question of the server where you should 
provide a proper bounding box for your layer.
From QGIS side you could zoom in to Massachusetts and have the scale 
between 1:1 and 1:25 and see what happens then.

hope this helps
Bernhard

Am 16.10.2018 um 16:51 schrieb Burkhardt, Glenn BUTAS:

The Mapserver I've set up doesn't seem to have all the configuration needed for 
Qgis to add layers.  I'm hoping to get some pointers on what needs to change.  
The layers I've defined show up in the server query, but they simply don't 
display.  One of the problems is that the GetMap query includes lat/lon for the 
entire world, instead of the extent of the layer that's been configured.  But 
even when I adjust that and use Firefox to make the query, it doesn't display 
the map.  Other applications, e.g., TakukGIS and WorldWind work with this 
server.  I'm using QGIS 3.2.3.

The query my map server is receiving is:

127.0.0.1 - - [16/Oct/2018:10:09:41 -0400] "GET 
/cgi-bin/mapserv?SERVICE=WMS=1.3.0=GetMap=-90,-180,90,180=EPSG:4326=1408=705=MassJ250k==image/png=96_RESOLUTION=96_OPTIONS=dpi:96=FALSE
 HTTP/1.1" 200 4802 "-" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:62.0) Gecko/20100101 Firefox/62.0"

The layer information report includes:


Original Mass.1to250k
Name Mass.1to250k
Source 
contextualWMSLegend=0=EPSG:4326=7=10=image/png=MassJ250k==http://localhost/cgi-bin/mapserv
Provider wms
CRS
EPSG:4326 - WGS 84 - Geographic
Extent -180.,-90. : 
180.,90.
Unit degrees
Width n/a
Height n/a
Data type Could not determine raster data type.
WMS Info  Selected Layers Other Layers

Server Properties

Property Value
WMS Version 1.3.0
Title WMS server

GetCapabilitiesUrl http://localhost/cgi-bin/mapserv?
GetMapUrl http://10.116.65.50/cgi-bin/mapserv?
GetFeatureInfoUrl http://10.116.65.50/cgi-bin/mapserv?
GetLegendGraphic http://10.116.65.50/cgi-bin/mapserv?
Image Formats
image/png
image/jpeg
image/bil
application/bil16
image/png; mode=8bit
application/x-pdf
image/svg+xml
image/tiff
application/vnd.google-earth.kml+xml
application/vnd.google-earth.kmz
Identify Formats
text/plain
application/vnd.ogc.gml
Layer Count 7

Selected Layers

Property Value
Name MassJ250k
Visibility Visible
Title Mass.1to250k
Abstract  Raster Map - /Mass/TIF/1to250k [MassJ250k] Coverage - -74.4670051 
40.9012464 -69.6700508 43.4899329
Can Identify No
Can be Transparent No
Can Zoom In Yes
Cascade Count 0
Fixed Width 0
Fixed Height 0
Available in CRS EPSG:4326


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user





__ Information from ESET Mail Security, version of virus signature 
database 18227 (20181017) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] [Possible bug] Qgis treating uuid as text in db views

[Bernhard Ströbl]

Am 19.09.2018 um 11:26 schrieb Rémi Desgrange:

Hi,

I have some database view used in qgis. (from postgresql 10, postgis2.4). Since 
some time now (I posted a bug report 3 months ago here: 
https://issues.qgis.org/issues/19180) This was about errors in my DBs log about 
selection request that does not end well. But, at this time it was not a 
problem for the end user. Yesterday, we spotted a much more problematic error.  
Here is the story:

We wanted to cut a linestring, so we use the tool “Split Features”. And when we 
did that. It cut the linestring, so changing the geometry of the linestring 
(updating) and trying to create a new one with the other part. The problem is: 
it updated correctly the existing feature, but did _not_ save the other one (it 
created it in qgis though).


Was there any error message from the DB?


The reason behind this is qgis treating an uuid like a text field. So, when treating 
uuid as text, when it tries to create a new feature out of the old one split, it put 
the value _1 which cannot work obviously.


It is the user's obligation to fill meaningful values in fields. This is 
e.g. also true for integer primary key fields: if you fill in a value 
already present or no value at all the changes cannot be saved.
I would create an insert trigger on the DB that creates a uuid for any 
insert request.


Hope this hleps
Bernhard



This is not a problem with form or style, the field as the type uuid in qgis, I 
“mapped” uuid generator on it, and tried text editor too.


I don’t know if it’s us that don’t know how to properly configure Qgis or if 
it’s a bug…


Cordialement, Rémi Desgrange
  


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user





__ Information from ESET Mail Security, version of virus signature 
database 18077 (20180919) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] QGIS-Server GetPrint file extension

[Bernhard Ströbl]

Hi all,

when requesting a print layout from QGIS Server via GetPrint I can set 
the FORMAT parameter to e.g. pdf. If the requesting browser has a pdf 
plugin, the layout is opened and displayed, if not the file can be 
saved. The proposed file name is the QGIS project's name _without_ 
extension.
Is there any way I can configure the server to add the pdf extension to 
the proposed file name?


QGIS Server 3.2 on Ubuntu/Apache

regards
Bernhard


__ Information from ESET Mail Security, version of virus signature 
database 18071 (20180918) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] "Otherwise rule" in rendering

[Bernhard Ströbl]

That's what I normally do, not sure if it is a must.

Bernhard

Am 30.08.2018 um 08:52 schrieb Andrea Peri:

Hi.
thx for help.

An else rule is exactly what I need .
I try it .

The "else" rule should be the last in the list of rules ?

A.


Il giorno gio 30 ago 2018 alle ore 07:44 Bernhard Ströbl <
bernhard.stro...@jena.de> ha scritto:


Hi,
it's called "ELSE" in the rule-based renderer

Bernhard

Am 29.08.2018 um 21:37 schrieb Andrea Peri:

Hi,
In the rule-rendering or in the category rendering is available an option
like "otherwise" to rendering all value not listed in the usual rendering
list of value ?

Thx,



___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user





__ Information from ESET Mail Security, version of virus signature
database 17967 (20180830) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user








__ Information from ESET Mail Security, version of virus signature 
database 17967 (20180830) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] "Otherwise rule" in rendering

[Bernhard Ströbl]

Hi,
it's called "ELSE" in the rule-based renderer

Bernhard

Am 29.08.2018 um 21:37 schrieb Andrea Peri:

Hi,
In the rule-rendering or in the category rendering is available an option
like "otherwise" to rendering all value not listed in the usual rendering
list of value ?

Thx,



___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user





__ Information from ESET Mail Security, version of virus signature 
database 17967 (20180830) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] QGIS 2.18 freeze meanwhile editing

[Bernhard Ströbl]

I assume a plugin is causing your problem; try to deactivate all plugins 
and check if the problem persists. If not reactivate them one by one to 
identify the one that causes the problem.

Bernhard

Am 28.06.2018 um 08:32 schrieb Andrea Peri:

Hi,
I'm using qgis 2.18.
Every time I goin ediiting on a shapefile , after insert about 10 or 20
features it (the qgis) is freezing. Windows (I use win 7) report me qgis is
not responding and I need to kill it and restart.

I usually do not lost nothing because I know this and after every on insert
I save always the shapefile and the project.
But it is boring.
I like to know if this is a know issue of qgis or it could be a specific
issue of my qgis install.

I use qgis 2.18.18 (32 bit) but it happened also when I use 2.14 and
windows 7 64 bit.

Many thx.



___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user





__ Information from ESET Mail Security, version of virus signature 
database 17625 (20180628) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Delete key does not remove item in composer

[Bernhard Ströbl]

done:
https://issues.qgis.org/issues/19281

Am 27.06.2018 um 11:16 schrieb Richard Duivenvoorde:

I can reproduce:

in english both keys work, but if I start QGIS in German:

qgis3 --lang de

then only backspace works, del does not

(My OS is Debian english, US keyboard, LANGUAGE=en_US:en

Please create an issue for it (and preferably try some other languages
too :-) )

Regards,

Richard

On 06/27/2018 11:12 AM, Frank Broniewski wrote:

Just tried, but to no avail (QGIS 3.2, OSGeo4W64, Windows 10)

I renamed my profile, started QGIS, created an empty composer, drew a
rectangle and tried to delete it with DEL – does not work, BACKSPACE does

  


*Von:* Alexandre Neto 
*Gesendet:* Mittwoch, 27. Juni 2018 11:08
*An:* DelazJ 
*Cc:* Frank Broniewski ;
Qgis-user@lists.osgeo.org
*Betreff:* Re: [Qgis-user] Delete key does not remove item in composer

  

  


Hi,

  


On Linux, version 3.2 works as expected, both DELETE and Backspace
remove layout composer items

  


Can you try to use a clean settings profile and check again?

  


DelazJ mailto:del...@gmail.com>> escreveu no dia
quarta, 27/06/2018 às 10:02:

 Hi,

  


 Let's not be so categorical and please, indicate also the platform
 you are working on. I've reported a bug long time ago (QGIS 2.8)
 about macOS https://issues.qgis.org/issues/12874

 Checking right now, I can say that:

 - on macOS, QGIS 2.18.0, both buttons do delete composer items

 - on Windows 10, using QGIS 2.18.21 and 3.3, both buttons do the
 same thing.

  


 Maybe, there are some local settings that interfere but on my side,
 documentation looks right.

  


 Regards,

 Harrissou

  


 2018-06-27 10:30 GMT+02:00 Frank Broniewski
 mailto:ha...@frankbroniewski.com>>:

 Hi,

 I just want to confirm that DELETE never worked for me (can't
 recall it ever did), BACKSPACE does though.

 Frank

 Dipl. Geogr. Frank Broniewski
 Waldhölzbacher Str. 51
 66679 Losheim am See
 06872 509 068 4
 0176 611 26 9 2 6
 www.frankbroniewski.com <http://www.frankbroniewski.com>


 -Ursprüngliche Nachricht-
 Von: Qgis-user mailto:qgis-user-boun...@lists.osgeo.org>> Im Auftrag von
 Bernhard Ströbl
 Gesendet: Mittwoch, 27. Juni 2018 10:25
 An: Qgis-user@lists.osgeo.org <mailto:Qgis-user@lists.osgeo.org>
 Betreff: [Qgis-user] Delete key does not remove item in composer


 Hi all,
 the documentation [1] states that for removing an item in
 composer one can either use Backspace or Delete. However Delete
 does not work for me :-( Is there anything I am missing?
 Tried:
 QGIS 2.18.20 on Win7 and Ubuntu 16.04, QGIS 3.2 on Ubuntu 16.04

 [1]
 
https://docs.qgis.org/2.18/en/docs/user_manual/print_composer/overview_composer.html

 Bernhard


 __ Information from ESET Mail Security, version of virus
 signature database 17619 (20180627) __

 The message was checked by ESET Mail Security.
 http://www.eset.com


 ___
 Qgis-user mailing list
 Qgis-user@lists.osgeo.org <mailto:Qgis-user@lists.osgeo.org>
 List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
 Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user


 ___
 Qgis-user mailing list
 Qgis-user@lists.osgeo.org <mailto:Qgis-user@lists.osgeo.org>
 List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
 Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

  


 ___
 Qgis-user mailing list
 Qgis-user@lists.osgeo.org <mailto:Qgis-user@lists.osgeo.org>
 List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
 Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

--

Alexandre Neto

-

@AlexNetoGeo

http://sigsemgrilhetas.wordpress.com

http://gisunchained.wordpress.com



___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user



___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user







__ Information from ESET Mail Security, version of virus signature 
database 17619 (20180627) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osge

Re: [Qgis-user] Delete key does not remove item in composer

[Bernhard Ströbl]

Hi all,
thanks for your answers which gave me an idea: Everybody saying it is 
not working comes from a German-speaking country, everybody else is not. 
So I overwrote system locale (DE_de) with EN and - tada - it works! 
(confirmed for 2.18.20 on Win7 and 3.2 on Ubuntu)

anybody any idea on that?
Bernhard

Am 27.06.2018 um 11:10 schrieb Stefan Giese:

Hi all,

same with me: DELETE never worked (Win7, before XP) various QGIS 
versions (QGIS 2.x up to QGIS 3.x)


best regards

stefan

Mit freundlichen Grüßen
Stefan Giese
Projektleiter/Consultant
*
AGIT 2018
4.- 6. Juli 2018 in Salzburg
Treffen Sie die WhereGroup bei der AGIT EXPO
http://www.agit.at/
*
WhereGroup GmbH & Co. KG
Schwimmbadstr. 2
79100 Freiburg
Germany

Fon: +49 (0)761 / 519 102 - 61
Fax: +49 (0)761 / 519 102 - 11

stefan.gi...@wheregroup.com
www.wheregroup.com
Amtsgericht Bonn, HRA 6788
---
Komplementärin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Olaf Knopp, Peter Stamm
---

Am 27.06.2018 um 11:08 schrieb Frank Broniewski:


Ok,

Windows 10 (and AFAIR Win7 also) with QGIS 2.18 & 3.0 & 3.2 
OSGeo4W-Installation (32bit & 64bit). The DELETE key never worked …


Before reading this thread I never assumed it should work, although by 
habit I press it always before noticing that it doesn’t do anything. I 
always used the menu or backspace afterwards …


*Von:* DelazJ 
*Gesendet:* Mittwoch, 27. Juni 2018 11:02
*An:* Frank Broniewski 
*Cc:* Bernhard Ströbl ; 
Qgis-user@lists.osgeo.org

*Betreff:* Re: [Qgis-user] Delete key does not remove item in composer

Hi,

Let's not be so categorical and please, indicate also the platform you 
are working on. I've reported a bug long time ago (QGIS 2.8) about 
macOS https://issues.qgis.org/issues/12874


Checking right now, I can say that:

- on macOS, QGIS 2.18.0, both buttons do delete composer items

- on Windows 10, using QGIS 2.18.21 and 3.3, both buttons do the same 
thing.


Maybe, there are some local settings that interfere but on my side, 
documentation looks right.


Regards,

Harrissou

2018-06-27 10:30 GMT+02:00 Frank Broniewski <mailto:ha...@frankbroniewski.com>>:


    Hi,

    I just want to confirm that DELETE never worked for me (can't
    recall it ever did), BACKSPACE does though.

    Frank

    Dipl. Geogr. Frank Broniewski
    Waldhölzbacher Str. 51
    66679 Losheim am See
    06872 509 068 4
    0176 611 26 9 2 6
    www.frankbroniewski.com <http://www.frankbroniewski.com>


    -Ursprüngliche Nachricht-
    Von: Qgis-user mailto:qgis-user-boun...@lists.osgeo.org>> Im Auftrag von
    Bernhard Ströbl
    Gesendet: Mittwoch, 27. Juni 2018 10:25
    An: Qgis-user@lists.osgeo.org <mailto:Qgis-user@lists.osgeo.org>
    Betreff: [Qgis-user] Delete key does not remove item in composer


    Hi all,
    the documentation [1] states that for removing an item in composer
    one can either use Backspace or Delete. However Delete does not
    work for me :-( Is there anything I am missing?
    Tried:
    QGIS 2.18.20 on Win7 and Ubuntu 16.04, QGIS 3.2 on Ubuntu 16.04

    [1]

https://docs.qgis.org/2.18/en/docs/user_manual/print_composer/overview_composer.html 



    Bernhard


    __ Information from ESET Mail Security, version of virus
    signature database 17619 (20180627) __

    The message was checked by ESET Mail Security.
    http://www.eset.com


    ___
    Qgis-user mailing list
    Qgis-user@lists.osgeo.org <mailto:Qgis-user@lists.osgeo.org>
    List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
    Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user


    ___
    Qgis-user mailing list
    Qgis-user@lists.osgeo.org <mailto:Qgis-user@lists.osgeo.org>
    List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
    Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user



___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user





__ Information from ESET Mail Security, version of virus 
signature database 17619 (20180627) __


The message was checked by ESET Mail Security.
http://www.eset.com




___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user





__ Information from ESET Mail Security, version of virus signature 
database 17619 (20180627) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgi

[Qgis-user] Delete key does not remove item in composer

[Bernhard Ströbl]

Hi all,
the documentation [1] states that for removing an item in composer one 
can either use Backspace or Delete. However Delete does not work for me :-(

Is there anything I am missing?
Tried:
QGIS 2.18.20 on Win7 and Ubuntu 16.04, QGIS 3.2 on Ubuntu 16.04

[1] 
https://docs.qgis.org/2.18/en/docs/user_manual/print_composer/overview_composer.html


Bernhard


__ Information from ESET Mail Security, version of virus signature 
database 17619 (20180627) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] [QGIS-Server 3] Labels show as squares

[Bernhard Ströbl]

Hi,

I am facing the following issue with QGIS-Server 3: All my labels are 
shown as black squares (one square for each letter).
First the reason seemed to be the path the application was looking for 
fonts as lots of messages "QFontDatabase: Cannot find font directory 
/usr/lib/x86_64-linux-gnu/fonts" got thrown.
The fonts are installed in /usr/share/fonts so I added a symlink as a 
workaround, now the messages are gone but the labels are still squares.

Any hint what I am missing?

BTW: How can I convince Qt to simply use the system fonts and not look 
in /usr/lib/x86_64-linux-gnu/fonts?


System: QGIS-Server 3.0.3 on Debian Stretch (dockerized, Image: 
php:7-apache)


regards
Bernhard


__ Information from ESET Mail Security, version of virus signature 
database 17480 (20180601) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] hide vector under raster?

[Bernhard Ströbl]

Hi Tobias,
I did not really get what you want to achieve. Let me put it in my words 
(this is what I understand)

1) You have a vector layer with _many_ features
2) You do not want to have it rendered because it takes so long to render
3) You want to query this layer
4) When you zoom out QGIS crashes when using the no symbols renderer

Questions: What kind of layer is this: DataProvider? geometryType?
Which version of QGIS are you using?
Does QGIS crash when zooming out while you use a simple renderer?

Bernhard

Am 29.05.2018 um 14:25 schrieb Tobias Wendorff:

Hi there,

Am Di, 29.05.2018, 14:17 schrieb Karl Magnus Jönsson:


How about using the no symbols renderer in the style tab in Layer
properties? Wouldn't that do?


I just had the same idea, but no... when zooming out, QGIS crashes
after some minutes (even on a big machine).

I really miss "join table to raster" function from ArcGIS, but I
don't have enough money to donate the function to QGIS :(

Best regards,
Tobias

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user





__ Information from ESET Mail Security, version of virus signature 
database 17464 (20180529) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Labels visible for invisible features - Solved

[Bernhard Ströbl]

Hi everybody,
problem solved (credits go to Benjamin).
I had a problem in my style: being aware of the "no symbols" layer style 
I was looking for something like "no symbols" on the higher level rules 
used for sorting features. Not finding this I used an invisible symbol 
(as I did in QGIS 2.14 and before). Thus invisibly rendering my features 
and having them labeled. The solution is to untick the symbol in the rule.


Bernhard


Am 14.02.2018 um 11:07 schrieb fuenfer-koenigstein.benjam...@swm.de:

Hi Bernhard,

I can't reproduce this behavior (point layer, PostGIS data source, QGIS 2.18.14 
on Win 7). Are you sure that the layer isn't duplicated in the layer tree? 
Maybe you can try with only this layer in a new QGIS project. If the problems 
still occur feel free to send me your data.

Regards
Benjamin

-Ursprüngliche Nachricht-
Von: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] Im Auftrag von 
Bernhard Ströbl
Gesendet: Dienstag, 13. Februar 2018 15:33
An: Qgis-user@lists.osgeo.org
Betreff: [Qgis-user] Labels visible for invisible features

Hi all,

I have a point layer with a rule-based style based on some of the layer's 
attributes. The points are labelled using a label field.
Now, when unticking a rule in the layer panel (i.e. making the features falling 
under this rule invisible) their labels are still rendered.
Using a categorized renderer the labels are not rendered if the category is 
unticked.
Does anybody have a workaround for this?
I am using QGIS 2.18.16

Bernhard





__ Information from ESET Mail Security, version of virus signature 
database 16908 (20180215) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Labels visible for invisible features

[Bernhard Ströbl]

Hi all,

I have a point layer with a rule-based style based on some of the 
layer's attributes. The points are labelled using a label field.
Now, when unticking a rule in the layer panel (i.e. making the features 
falling under this rule invisible) their labels are still rendered.
Using a categorized renderer the labels are not rendered if the category 
is unticked.

Does anybody have a workaround for this?
I am using QGIS 2.18.16

Bernhard


__ Information from ESET Mail Security, version of virus signature 
database 16897 (20180213) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Labels visible for invisible features

[Bernhard Ströbl]

Hi again,
I forgot to mention I have rules and subrules (3 levels of rules), 
apparently when using only rules in the top level all is working as 
expected.


Bernhard

Am 13.02.2018 um 15:33 schrieb Bernhard Ströbl:

Hi all,

I have a point layer with a rule-based style based on some of the 
layer's attributes. The points are labelled using a label field.
Now, when unticking a rule in the layer panel (i.e. making the features 
falling under this rule invisible) their labels are still rendered.
Using a categorized renderer the labels are not rendered if the category 
is unticked.

Does anybody have a workaround for this?
I am using QGIS 2.18.16

Bernhard




__ Information from ESET Mail Security, version of virus signature 
database 16897 (20180213) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] splitting line at vertex

[Bernhard Ströbl]

I tried with a memory layer and it worked

Bernhard

Am 27.09.2017 um 09:42 schrieb Reginald:

Hi Bernard,

I think the problem is that it concerns a temporary drawing layer.
There is something about this temporary layer that is different from a
normal shape layer so that splitting at a vertex is not working.

Regards,






__ Information from ESET Mail Security, version of virus signature 
database 16147 (20170927) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] splitting line at vertex

[Bernhard Ströbl]

Hi,
it should work as you describe it (tried with 2.14.19 on Win 7)
Questions:
Is the line to be split a closed ring?
Are project and layer CRS identical?
Is there a selection in the layer and if yes is the line to be split 
contained in the selection?

You could also try to make an additional left click above the line.
Bernhard

Am 27.09.2017 um 08:50 schrieb Reginald:

hello,

I am trying to split a line at a vertex but somehow it always fails.
I have read several answers on stackexchange but none of them works.
Splitting a line is easy but I want the split to happen at the vertex. So I
enabled snapping and I left click under the line, then I left click on the
snapped point, than I right click above the line.
Notting happens.
How can I accomplish this splitting (eventualy using python)?

Regards,






__ Information from ESET Mail Security, version of virus signature 
database 16147 (20170927) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] QGIS Input Form for PostGIS

[Bernhard Ströbl]

Hi Jakob,

although a bit late: Have you tried the plugin DataDrivenInputMask [1]?
By using it there is no need to fiddle with QGIS relations, the drawback 
is that there is no undo.
You have to properly define foreign keys and not null columns for the 
plugin to work. And, as Andreas already pointed out, indices on foreign 
key columns are normally advisable.


Bernhard

[1] http://plugins.qgis.org/plugins/DataDrivenInputMask/

Am 04.08.2017 um 09:39 schrieb Andreas Neumann:

Hi Jakob,

I don't think there is much background information or documentation
available on relations.

The obvious questions to you are:

- What means "big" (how many records are you dealing with)?

- I know this sounds silly - but are your tables properly indexed (you
don't have to index primary keys, but other columns that are used in
relations need an index)

- What exact QGIS version are you using? 2.18.x - in the about dialogue
you can find this, including the exact github version string

- if we can't help you further, it may help to see your create table
statements (including all indexes)

Andreas


On 03.08.2017 11:47, Jakob Miksch wrote:


Hello,



I have a (rather big) Postgres/PostGIS database that basically looks
like this: https://ibb.co/bK7PKv



I want to use QGIS for editing and inserting data.



I already found these ressources:

https://docs.qgis.org/2.18/en/docs/user_manual/working_with_vector/vector_properties.html#fields-properties

https://docs.qgis.org/2.18/en/docs/user_manual/working_with_vector/attribute_table.html#creating-one-or-many-to-many-relations

https://docs.qgis.org/2.18/en/docs/training_manual/create_vector_data/forms.html



I tried it: I created the relations and built custom forms.



However, when I want to insert or edit something. QGIS becomes really
slow and crashes finally. But before I describe the problems in more
detail I want to read more about it. I find the documentation (linked
above) a bit too little.



So, my question:



Is there any documentation I have missed?

Is there any book (chapter) you can recommend?

Do you know of any example where QGIS is used for entering data into
many related tables in Postgres/PostGIS at once?



I am thankful for any hint or resource.



Jakob






__ Information from ESET Mail Security, version of virus signature 
database 15884 (20170809) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Selecting ticked-off features

[Bernhard Ströbl]

Hi all,
I experienced a strange behaviour of the selection tool: My point layer 
has a rule-based style. If I tick off certain rules to not display their 
members, the corresponding features get selected nonetheless if 
selection is done by a mouse rectangle. Even worse if the rule has a 
scale range set and the map canvas is out of this scale range, the 
features still get selected. If a scale range is applied to the whole 
layer and the map canvas is out of this scale range (= nothing is 
displayed) still all features in the rectangle get selected. On the 
other hand if the whole layer is unticked (= not visible) no selection 
is performed.


Is there any setting I am missing or is this a bug (or feature)? I would 
expect to only select features being visible on the canvas (even if not 
visible because other features are drawn on top).


Checked on both, QGIS 2.14.14 on Win7 and QGIS 2.18.10 on Ubuntu

Bernhard


__ Information from ESET Mail Security, version of virus signature 
database 15744 (20170714) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Generate Text Labels for USA National Map?

[Bernhard Ströbl]

Hi Jeshua,
I cannot advice you in how you can achieve your goal :-(
but would like to give some more answers and explanations

Am 05.07.2017 um 23:41 schrieb Jeshua Lacock:



On Jul 5, 2017, at 2:32 AM, Bernhard Ströbl <bernhard.stro...@jena.de> wrote:

- I assume you want to have QGIS create label texts for all your data in one go.


Hi Bernhard,

That would be ideal.


If that is the case this is a misunderstanding of what labels are (in QGIS): 
QGIS creates (and places) the labels at run-time for the map extract currently 
on display. Labels thus are no features of their own (GIS only knows 
points/lines/polygons) but a way to display GIS features (like e.g. color, 
outline etc.)


I was afraid that might be the case. :’(


- This means the labels are valid for this particular map extract in this 
particular scale. E.g. imagine a lake (= one polygon) that expands on two map 
extracts, it will be labeled in both => one feature, two labels


Understood. I was thinking of generating text at say 4 different scales.


- Thus the label text is only within QGIS, export may be possible with 
dxf-export


Is it possible to script or automate setting the view extents and exporting?


(I assume) you may of course use a script that automatically creates map 
extracts and exports the labels but you will face the problem of 
multiple labels for the same feature (lake example, steet that stretches 
over several extracts). If you want labels for an arbitray map extract 
IMHO you cannot produce the labels in advance but have to label at run time



- IMHO it doesn't make sense to try to use the labels outside of QGIS; what is 
your intended final result? Which software are you planning to use for creating 
your final result?


Initially it will be a custom iOS app (with planned android and possibly 
desktop computer versions). I might offer printed hard copies too at some point.


This sounds like arbitrary map extracts, so your app should label at run 
time; Andreas already commented on that more sophisticated than I could.



- There will be map extracts with "many" labels (city centres) and map extracts with 
"few" labels (boondocks).


Yes, that is why I was looking for something that already can deal with crowded 
text versus re-inventing the wheel.


- QGIS can prevent overlapping labels; in placement you can assign a priority 
to the labels of this layer (so e.g. rivers are always labeled whereas streets 
only if not in conflict with rivers)


Nice.


- The rule based labelling works _within_ a layer; a rule is a logical 
statement about the feature to be labeled. The logic can be based on the 
feature's attribute values or geometry (e.g. label only lakes larger than x)


So essentially, I would want all the text on one layer - so point text doesn’t 
overlap with say road or river text, correct?


No, the rule-based labelling sports rules that decide _if_ (and how) a 
feature within a layer should be labelled; think of a layer containing 
street lines:

Rule 1: Label all major streets at all scales with 10pt bold
Rule 2: Label minor streets only at larger scales with 8pt normal
Rule 3: Do not label residential streets at all

QGIS' labelling algorithm will then collect all labels from all layers 
delivering labels for the map extract to be rendered and decides if 
labels need to me moved or suppressed because of the settings (e.g. 
label priority) to prevent overlapping labels. At this point the rules 
have already been applied as the rules deliver a set of labels for a 
particular layer.


If you consider your river labels more important than your road labels 
simply give them a higher priority.


To be honest: In my experience the automatic labelling works really well 
and satisfactory for 99% of the cases, BUT in case you want a certain 
"perfect" print out you need to manually adjust or suppress certain 
labels because creating a map is a design work and there are always 
cases where your notion of the result differs from what the algorithm 
provides (e.g. have that highway labeled although the label can only be 
placed on the bridge and river labels have a higher priority).





- points are vector features, too, so there is no real difference between 
labelling points, lines or polygons.


Great.


- Be sure to have read the doc: 
http://docs.qgis.org/2.14/en/docs/user_manual/working_with_vector/vector_properties.html#labels-menu#


Thanks for the link and help!


Best,

Jeshua Lacock
Founder/Engineer
<3DTOPO.com>
GlassPrinted.com



regards
Bernhard


__ Information from ESET Mail Security, version of virus signature 
database 15700 (20170706) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Loading Postgis FDW tables

[Bernhard Ströbl]

Hi Andreas,

I have not used fdw for postgres, but use views based on dblink instead, 
which works perfectly in QGIS (2.14)
My fdw tables from MySql and ORACLE are not shown either in QGIS when 
trying to load a layer.


Bernhard

Am 05.07.2017 um 14:35 schrieb Neumann, Andreas:

Hi,

I have troubles loading FDW layers (in my case postgres_fdw linked from
another DB on the same server). I get an error message stating that the
layer is an "invalid layer". In pgAdmin the respective user can access
and display the data and it is correctly registered in the
public.geometry_columns view.

Do you have any idea why FDW tables shouldn't be loadable in QGIS?

Thanks,

Andreas



__ Information from ESET Mail Security, version of virus
signature database 15696 (20170705) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user





__ Information from ESET Mail Security, version of virus signature 
database 15696 (20170705) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Generate Text Labels for USA National Map?

[Bernhard Ströbl]

Hi,
just some thoughts:
- I assume you want to have QGIS create label texts for all your data in 
one go. If that is the case this is a misunderstanding of what labels 
are (in QGIS): QGIS creates (and places) the labels at run-time for the 
map extract currently on display. Labels thus are no features of their 
own (GIS only knows points/lines/polygons) but a way to display GIS 
features (like e.g. color, outline etc.)
- This means the labels are valid for this particular map extract in 
this particular scale. E.g. imagine a lake (= one polygon) that expands 
on two map extracts, it will be labeled in both => one feature, two labels
- Thus the label text is only within QGIS, export may be possible with 
dxf-export
- IMHO it doesn't make sense to try to use the labels outside of QGIS; 
what is your intended final result? Which software are you planning to 
use for creating your final result?
- There will be map extracts with "many" labels (city centres) and map 
extracts with "few" labels (boondocks).
- QGIS can prevent overlapping labels; in placement you can assign a 
priority to the labels of this layer (so e.g. rivers are always labeled 
whereas streets only if not in conflict with rivers)
- The rule based labelling works _within_ a layer; a rule is a logical 
statement about the feature to be labeled. The logic can be based on the 
feature's attribute values or geometry (e.g. label only lakes larger than x)
- points are vector features, too, so there is no real difference 
between labelling points, lines or polygons.
- Be sure to have read the doc: 
http://docs.qgis.org/2.14/en/docs/user_manual/working_with_vector/vector_properties.html#labels-menu#


hope this helps
Bernhard


Am 05.07.2017 um 09:11 schrieb Jeshua Lacock:


Greetings,

I currently have all the base layers for a 1:24k topographic national map of 
the US worked out. Many many terabytes of data currently all in GRASS.

The last hurdle I have is to figure out the best way for labeling vector 
features (hydro, roads, contours) and point text (mountain summit names, place 
names, etc.).

Based on my research so far, it seems that QGIS might be one, if not the most 
powerful open source software for GIS text labels.

A few questions, if I may. I am new to QGIS so please forgive me if I am asking 
something that is obvious.

1. Is text that is created with the Rule-based labeling feature exportable, or 
is it is only for display in QGIS? If it is exportable, what formats can it be 
exported to? Anything besides raster?

2. Would it be possible to generate labels for the entire nation (millions of 
labels) with the rule-based labels, or would I have to do it in many sections?

3. For point text, are there any algorithms that help prevent labels from 
overlapping each other? Such as those outlined at: 
https://en.wikipedia.org/wiki/Automatic_label_placement

4. Can point text be used with the rule-based labeling or is it only for vector 
data with attributes?

If anyone has undertaken a similar task as I am researching, I would certainly 
appreciate any and all feedback and advice.


Many thanks,

Jeshua Lacock
Founder/Engineer
<3DTOPO.com>
GlassPrinted.com

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user






__ Information from ESET Mail Security, version of virus signature 
database 15694 (20170705) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] relation_aggregate issue with virtual fields

[Bernhard Ströbl]

Hi Andreas,
just a wild guess: Could it be related with the Umlaut "ä"

Bernhard

Am 26.06.2017 um 16:26 schrieb Neumann, Andreas:

Hi,

I use a relation_aggregate expression with the following syntax:

relation_aggregate( relation:='Erdwärmesonden',
aggregate:='sum',expression:="anzahl_sonden")

In the output preview this works fine and I get an expected result,
however, if I use the same expression in a virtual field, I always get
NULL values.

Any idea why this happens?

Thanks,

Andreas




__ Information from ESET Mail Security, version of virus
signature database 15646 (20170626) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user





__ Information from ESET Mail Security, version of virus signature 
database 15646 (20170626) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Split features tool behavior

[Bernhard Ströbl]

Hi Andreas,
good it works, thanks for testing.
For the tracing function (I have no idea how much work that would be, 
either): You are welcome to file an enhancement ticket for this as I am 
planning to overhaul the plugin once QGIS 3.0 is released.

Bernhard

Am 20.06.2017 um 09:24 schrieb Andreas Wicht:

Hi Bernhard,

perfect! Both works for me.
A nice-to-have for the future would also be the utilization of the
tracing function in case tracing is enabled.
I can not assess how much work that would mean.

cheers


On 19 June 2017 at 18:05, Bernhard Ströbl <bernhard.stro...@jena.de> wrote:

Hi Andreas,
has been fixed; split feature now uses the highlight color, too
Please update your plugin
Bernhard


Am 19.06.2017 um 10:05 schrieb Andreas Wicht:


Hi Bernhard,

I can consistently  produce a python error when splitting a Multipart
Feature and then clicking "No to all":

UnboundLocalError: local variable 'newGeoms' referenced before assignment
Traceback (most recent call last):
  File
"C:\Users\Andreas.Wicht\.qgis2\python\plugins\DigitizingTools\tools\dtsplitfeature.py",
line 139, in digitizingFinished
newFeatures = dtutils.dtMakeFeaturesFromGeometries(self.editLayer,
 aFeat,  newGeoms)
UnboundLocalError: local variable 'newGeoms' referenced before assignment

Python version: 2.7.5 (default, May 15 2013, 22:44:16) [MSC v.1500 64
bit (AMD64)]
QGIS version: 2.18.9 Las Palmas, 3a16a4e

Is that case maybe not covered properly or should I search for causes on
my end?


On 19 June 2017 at 08:28, Bernhard Ströbl <bernhard.stro...@jena.de>
wrote:


Hi Andreas,

the color is currently defined in the code. I did not find any setting to
apply. AFAIK only selection color can be defined by the user, but it
might
be misleading if you have a selected feature and then have split parts
colored exactly the same. - Wait a minute I just found the "Highlight
color". That would probably work. Will check.



Okay. Thank you!



Am 17.06.2017 um 13:22 schrieb Andreas Wicht:



Hi Bernhard,

just got to test the new version. It works now as expected.
Thank you a lot for the good work there!

Is the highlight color of the currently "selected" part (when you
choose which part should form the new feature) defined in the code or
does it use a color, which is set in the QGIS settings?



__ Information from ESET Mail Security, version of virus signature 
database 15612 (20170620) __

The message was checked by ESET Mail Security.
http://www.eset.com






__ Information from ESET Mail Security, version of virus signature 
database 15612 (20170620) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Split features tool behavior

[Bernhard Ströbl]

Hi Andreas,
has been fixed; split feature now uses the highlight color, too
Please update your plugin
Bernhard

Am 19.06.2017 um 10:05 schrieb Andreas Wicht:

Hi Bernhard,

I can consistently  produce a python error when splitting a Multipart
Feature and then clicking "No to all":

UnboundLocalError: local variable 'newGeoms' referenced before assignment
Traceback (most recent call last):
  File 
"C:\Users\Andreas.Wicht\.qgis2\python\plugins\DigitizingTools\tools\dtsplitfeature.py",
line 139, in digitizingFinished
newFeatures = dtutils.dtMakeFeaturesFromGeometries(self.editLayer,
 aFeat,  newGeoms)
UnboundLocalError: local variable 'newGeoms' referenced before assignment

Python version: 2.7.5 (default, May 15 2013, 22:44:16) [MSC v.1500 64
bit (AMD64)]
QGIS version: 2.18.9 Las Palmas, 3a16a4e

Is that case maybe not covered properly or should I search for causes on my end?


On 19 June 2017 at 08:28, Bernhard Ströbl <bernhard.stro...@jena.de> wrote:

Hi Andreas,

the color is currently defined in the code. I did not find any setting to
apply. AFAIK only selection color can be defined by the user, but it might
be misleading if you have a selected feature and then have split parts
colored exactly the same. - Wait a minute I just found the "Highlight
color". That would probably work. Will check.


Okay. Thank you!



Am 17.06.2017 um 13:22 schrieb Andreas Wicht:


Hi Bernhard,

just got to test the new version. It works now as expected.
Thank you a lot for the good work there!

Is the highlight color of the currently "selected" part (when you
choose which part should form the new feature) defined in the code or
does it use a color, which is set in the QGIS settings?



__ Information from ESET Mail Security, version of virus signature 
database 15606 (20170619) __

The message was checked by ESET Mail Security.
http://www.eset.com






__ Information from ESET Mail Security, version of virus signature 
database 15609 (20170619) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Split features tool behavior

[Bernhard Ströbl]

Hi Andreas,

the color is currently defined in the code. I did not find any setting 
to apply. AFAIK only selection color can be defined by the user, but it 
might be misleading if you have a selected feature and then have split 
parts colored exactly the same. - Wait a minute I just found the 
"Highlight color". That would probably work. Will check.

Bernhard

Am 17.06.2017 um 13:22 schrieb Andreas Wicht:

Hi Bernhard,

just got to test the new version. It works now as expected.
Thank you a lot for the good work there!

Is the highlight color of the currently "selected" part (when you
choose which part should form the new feature) defined in the code or
does it use a color, which is set in the QGIS settings?

cheers
Andreas

On 15 June 2017 at 14:33, Bernhard Ströbl <bernhard.stro...@jena.de> wrote:

FYI
I implemented a new "Split features" tool in DigitizingTools [1].
It should replace "Split features" and "Split parts" in core, see [2]

Bernhard

[1] http://plugins.qgis.org/plugins/DigitizingTools/
[2] https://github.com/bstroebl/DigitizingTools/wiki/Usage



__ Information from ESET Mail Security, version of virus signature 
database 15598 (20170617) __

The message was checked by ESET Mail Security.
http://www.eset.com






__ Information from ESET Mail Security, version of virus signature 
database 15606 (20170619) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Split features tool behavior

[Bernhard Ströbl]

FYI
I implemented a new "Split features" tool in DigitizingTools [1].
It should replace "Split features" and "Split parts" in core, see [2]

Bernhard

[1] http://plugins.qgis.org/plugins/DigitizingTools/
[2] https://github.com/bstroebl/DigitizingTools/wiki/Usage

Am 02.06.2017 um 10:48 schrieb Bernhard Ströbl:

Hi Andreas,

--snip---




Chaining those 2 tools manually produces exactly the output I would
expect.
- I use "Split Parts" and receive the halves which form the invalid
geometry
- then I use "Split off one part and add it as a new feature" on the
part which I want to separate
- make sure the primary key is valid and
- done


this sounds like a straight workflow, although changing tools all the
time
seems a bit inconvenient :-)


Exactly. Therefore having this combined in one tool would be a nice
addition.
You could have following input flow:
- select "insert name here" tool
- digitise splitting geometry
- split
- click on split part
- further attribute editing

Or use e.g. the MapInfo logic to that.



I filed a ticket in DigitizingTools for that [1]. Feel free to comment
on this.
There is also a related ticket in core [2]

Bernhard

[1] https://github.com/bstroebl/DigitizingTools/issues/19
[2] https://issues.qgis.org/issues/12754




__ Information from ESET Mail Security, version of virus signature 
database 15588 (20170615) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Split features tool behavior

[Bernhard Ströbl]

Hi Andreas,

--snip---




Chaining those 2 tools manually produces exactly the output I would
expect.
- I use "Split Parts" and receive the halves which form the invalid
geometry
- then I use "Split off one part and add it as a new feature" on the
part which I want to separate
- make sure the primary key is valid and
- done


this sounds like a straight workflow, although changing tools all the time
seems a bit inconvenient :-)


Exactly. Therefore having this combined in one tool would be a nice addition.
You could have following input flow:
- select "insert name here" tool
- digitise splitting geometry
- split
- click on split part
- further attribute editing

Or use e.g. the MapInfo logic to that.



I filed a ticket in DigitizingTools for that [1]. Feel free to comment 
on this.

There is also a related ticket in core [2]

Bernhard

[1] https://github.com/bstroebl/DigitizingTools/issues/19
[2] https://issues.qgis.org/issues/12754


__ Information from ESET Mail Security, version of virus signature 
database 15517 (20170602) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Split features tool behavior

[Bernhard Ströbl]

Hi Andreas,

Am 31.05.2017 um 18:02 schrieb Andreas Wicht:

Hi Bernhard,


I dug deeper and it seems that I can always split the part once. Any
further
splitting of any part results in the invalid geometry error.
https://issues.qgis.org/issues/12799 describes why.



Exactly. So when you split the polygon and save the edits you will
have said self-intersection in your data. That's why the second split
will not work (correct behaviour).



Still you can save it and have thus an invalid geometry


The correct behaviour was aimed towards the fact, that you can not do
a second split due to the invalid geometry and not due to being able
to save the invalid geometry.


Back to what you try to achieve: you could use "Split feature" to create a
new feature, manipulate what you need, even split this feature again and
then use "merge feature" with those polygons that should form the
multipolygon. Your first mail indicates that you are puzzled because you
get three features if you apply "split features" to a part of a multipart
polygon (1 = split part1, 2 = split part2, 3 = all the

Split Features is not an option here, because in this example the
island would also be separated from the polygon which is not
necessarily wanted.

I do not get, what you mean, anyways you can merge several features into one
at anytime.


If you edit a real world dataset this becomes more clear maybe.
Let it be some kind of administrative structure with a lot of small
islands (literal islands) for example at the Norwegian coast.
Therefore one dataset (multipart-feature) contains the polygon on the
mainland and all the island (literal island) polygons attached to it.
If you want to split the mainland polygon (see my example data) and
use "Split Features" you would have to merge all islands again
afterwards. That is what I mean by "that is not an option here". It's
possible, but totally impractical.


In my tests only the halves of the part that was split became new 
features, the rest of the mulit-part feature stays multipart, so all the 
islands would stay in the feature and you would only have to merge one 
half with the island multi polygon.





Yes, I totally get that. But as I said before, other GIS handle it
more intuitively.
I don't know in detail how they technically do it (closed source).
- ArcGIS's "Cut Polygon" tool
- MapInfo's "Split" tool


I do not have access to these packages. Could you describe what they do
differently?


For ArcGIS I don't exactly know. It just produces the result which I expect.
The result is (using my sample data screenshots) 2 features. The right
features (which was cut off) and the left features (multipart polygon
of the other half + the part which is in this case a literal island).
How it exactly determines the correct relations of the parts, I can't
tell you.


Maybe it depends on the direction the splitting line is drawn? This 
approach, however, would only work if the polygons are following the 
right-hand rule which is not the case for all providers [1].


[1] http://postgis.net/docs/manual-2.3/ST_ForceRHR.html



MapInfo has a more obvious approach. When you split a
multipart-feature with a line (2 vertices), it will extend the line to
the boundingbox-boundary, and split the feature with a polygon which
is constructed by the intersection of the bounding box and the
(extended) digitized line. Therefore the new feature which is created
will always be the portion which was covered by that polygon. The
other half of the feature remains a multipart feature and keeps all
parts which lie outside that splitting polygon.
When splitting a multipart polygon by a polyline (more than 2
vertices) it will always close the polyline automatically and
therefore construct the splitting polygon.


If I have a bounding box and a splitting line there are two polygons 
possible: one to the left and one to the right of the splitting line. 
How does MapInfo decide which one to use? Or is this a user's choice? 
Maybe it's the same as I assumed for ArcInfo (right-hand rule).





I think logically one would have to chain splitting the part and
automatically converting the new part as a separate polygon in one
tool (given the robust automatic identification of the new part).



But that is exactly what split feature does if you apply it to a part: It
splits the part and adds both "halves" as new features. I would not expect
any of the halves becoming a new feature and the other staying a part of the
multipart feature arbitrarily. What should I do if the wrong half stays?
Therefore for me the workflow is clear: 1) Split features 2) merge the
feature that should stay with the multipart feature. 3) Done


The manually merging step is where the errors will be produced, once
you deal with a complicated layer of some sort.
That is what I mean as described above. Other GIS make sure the
correct half stays and I do not have to deal with the merging step.


BTW: We should agree on common terms; these are the terms QGIS uses 

Re: [Qgis-user] Split features tool behavior

[Bernhard Ströbl]

Hi Andreas,
my comments below

Am 31.05.2017 um 13:04 schrieb Andreas Wicht:

On 31 May 2017 at 12:23, Bernhard Ströbl <bernhard.stro...@jena.de> wrote:

Hi Andreas,
I dug deeper and it seems that I can always split the part once. Any further
splitting of any part results in the invalid geometry error.
https://issues.qgis.org/issues/12799 describes why.


Exactly. So when you split the polygon and save the edits you will
have said self-intersection in your data. That's why the second split
will not work (correct behaviour).


Still you can save it and have thus an invalid geometry



IMHO splitting a part once is OK because you might want to delete this newly
created part or edit its nodes in order to create a gap between the parts
(BTW if that is done you can split parts again).


Creating gaps contradicts topologically clean editing in my case.


Not necessarily because you could fill a new feature or part into the 
gap in the next step.



Deleting the new part is the only way to solve that problem here.


Which would create a gap, wouldn't it?



However it does not make sense to have a multipart polygon with adjacent
parts (they could be one part then), so QGIS correctly detects this as an
error (self-intersection).
Back to what you try to achieve: you could use "Split feature" to create a
new feature, manipulate what you need, even split this feature again and
then use "merge feature" with those polygons that should form the
multipolygon. Your first mail indicates that you are puzzled because you get
three features if you apply "split features" to a part of a multipart
polygon (1 = split part1, 2 = split part2, 3 = all the


Split Features is not an option here, because in this example the
island would also be separated from the polygon which is not
necessarily wanted.


I do not get, what you mean, anyways you can merge several features into 
one at anytime.





other parts). This seems a logical approach to me because how should QGIS
know which of the to halves is supposed to stay with the original multipart
polygon and which is to become a new feature? You can merge any of the new
halves with the original multipart feature in the next step.


Yes, I totally get that. But as I said before, other GIS handle it
more intuitively.
I don't know in detail how they technically do it (closed source).
- ArcGIS's "Cut Polygon" tool
- MapInfo's "Split" tool


I do not have access to these packages. Could you describe what they do 
differently?


I think logically one would have to chain splitting the part and
automatically converting the new part as a separate polygon in one
tool (given the robust automatic identification of the new part).


But that is exactly what split feature does if you apply it to a part: 
It splits the part and adds both "halves" as new features. I would not 
expect any of the halves becoming a new feature and the other staying a 
part of the multipart feature arbitrarily. What should I do if the wrong 
half stays?
Therefore for me the workflow is clear: 1) Split features 2) merge the 
feature that should stay with the multipart feature. 3) Done


BTW: We should agree on common terms; these are the terms QGIS uses 
AFAIK: a feature is a dataset, i.e. one row in the table; it can either 
have one geometry or several geometries as spatial representation (or 
none but that's of no interest here). If it has several geometries it is 
called a multi-part feature, each individual geometry is called a part 
then. A polygon is a type of geometry; if it is a multi-part polygon, 
each part is a polygon in itself (therefore I tried to avoid "polygon" 
altogether and used "feature" and "part" instead to be clear). An island 
is a hole in a single polygon, QGIS calls it "ring". In DigitizingTools 
I use "gap" for a space surrounded by polygon features but without being 
part of a polygon itself.




Probably it would have to be a separate tool which mixes "Split Parts"
and the "Split off one part and add it as a new feature" Tool in the
DigitizingTools plugin.


The idea behind "Split off one part and add it as a new feature" is that 
you cannot use "Split features" to extract a whole part (workaround 
would be to apply "Split features" to the part and merge the two 
resulting new features into one, but that's not intuitive :)


Bernhard


__ Information from ESET Mail Security, version of virus signature 
database 15506 (20170531) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Split features tool behavior

[Bernhard Ströbl]

Hi Andreas,
I dug deeper and it seems that I can always split the part once. Any 
further splitting of any part results in the invalid geometry error.

https://issues.qgis.org/issues/12799 describes why.
IMHO splitting a part once is ok because you might want to delete this 
newly created part or edit its nodes in order to create a gap between 
the parts (BTW if that is done you can split parts again).
However it does not make sense to have a multipart polygon with adjacent 
parts (they could be one part then), so QGIS correctly detects this as 
an error (self-intersection).
Back to what you try to achieve: you could use "Split feature" to create 
a new feature, manipulate what you need, even split this feature again 
and then use "merge feature" with those polygons that should form the 
multipolygon. Your first mail indicates that you are puzzled because you 
get three features if you apply "split features" to a part of a 
multipart polygon (1 = split part1, 2 = split part2, 3 = all the
other parts). This seems a logical approach to me because how should 
QGIS know which of the to halves is supposed to stay with the original 
multipart polygon and which is to become a new feature? You can merge 
any of the new halves with the original multipart feature in the next step.


I use QGIS 2.14.15 on Ubuntu

Bernhard

Am 31.05.2017 um 11:15 schrieb Andreas Wicht:

Hi Bernhard

On 31 May 2017 at 10:53, Bernhard Ströbl <bernhard.stro...@jena.de> wrote:

Andreas,
when loading your shape file into a new project the project is set to
EPSG:4326 because your data are in EPSG:4326
Your screenshots indicate that you are working in another projection.In


That was just for a better visualisation for the screenshots (OTF reprojecting).


EPSG:4326 split parts works flawlessly, when I use a projection I get the
invalid geometries error.


I can reproduce the same result as before working natively in EPSG:4326.


In my experience you should edit geometries in a project matching the
projection of the data, although editing projected geometries is not
prohibited by QGIS.


Which exact steps do you follow to cut off an area like that with the
split parts tool?
I can reproduce the invalid geometry no matter if topological editing
is enable or disabled.
So this setting can be excluded from the list of scapegoats.

Andreas


__ Information from ESET Mail Security, version of virus signature 
database 15505 (20170531) __

The message was checked by ESET Mail Security.
http://www.eset.com






__ Information from ESET Mail Security, version of virus signature 
database 15505 (20170531) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Split features tool behavior

[Bernhard Ströbl]

Andreas,
when loading your shape file into a new project the project is set to 
EPSG:4326 because your data are in EPSG:4326
Your screenshots indicate that you are working in another projection. In 
EPSG:4326 split parts works flawlessly, when I use a projection I get 
the invalid geometries error.
In my experience you should edit geometries in a project matching the 
projection of the data, although editing projected geometries is not 
prohibited by QGIS.


Bernhard

Am 31.05.2017 um 09:49 schrieb Andreas Wicht:

Hi James,
hi Bernhard,

attached you can find a small sample data set and three screenshots.
I used the Split Parts tool to cut off the lower part as shown in the
screenshots.

This is in a PostGIS layer
(POSTGIS="2.3.2 r15302" GEOS="3.5.0-CAPI-1.9.0 r4084" PROJ="Rel.
4.9.2, 08 September 2015" GDAL="GDAL 1.11.3, released 2015/09/16"
LIBXML="2.9.3" LIBJSON="0.11.99" TOPOLOGY RASTER)

geometrytype
--
MULTIPOLYGON

I tested with QGIS 2.18.9 in Windows 7 and Ubuntu 16.04 (ubuntugis deps).
ST_IsValidReason yields the following after editing (depicted in third
screenshot):

NOTICE:  Self-intersection at or near point -19.203503991278154
65.808265481598852
   st_isvalidreason
---
 Self-intersection[-19.2035039912782 65.8082654815989]

I can reproduce this behaviour with simple hand drawn polygons in a
memory layer as well.
My described workflow in the earlier email was aiming at the comment
(#16) of Jürgen Fischer in the mentioned issue
(https://issues.qgis.org/issues/12799#note-16). Here he describes that
further editing of the geometry is essential to use this function
(please correct me, if I understood that wrong).

By current status of development Bernhard's approach seems to be the
most efficient one.

Yet I think that the function should be designed in a way that it does
not require further validation/editing to get a clean geometry. That
is not obvious to a less experienced user.

cheers
Andreas


On 31 May 2017 at 02:47, James Wood  wrote:

Hey Andreas,
I haven't experienced the invalid geometry as you describe, but I did find that 
my QGIS install had some issues. I have upgraded to 2.18.9 on Win10. If you 
have a sample of your data available, I would be happy to try to corroborate.

James

On May 29, 2017, at 06:16, Andreas Wicht  wrote:


On 28 May 2017 at 14:43, James Wood  wrote:
On the digitizing toolbar, try "Split Parts" instead of "Split Features" on 
multipart polygons.


Thank you for the hint, James. Somehow I always thought that this
function is only suitable for separating an existing part from a
feature (never used it though).
Yet, if you cut a polygon with the "Split Parts" tool, the output will
be an invalid geometry (I observed self-intersections). This as well
can not be the intended behavior. I could observe those errors in
simple scratch layers as well as in PostGIS layers.

Has anybody else experienced this behavior?




__ Information from ESET Mail Security, version of virus signature 
database 15504 (20170531) __

The message was checked by ESET Mail Security.
http://www.eset.com





__ Information from ESET Mail Security, version of virus signature 
database 15505 (20170531) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Split features tool behavior

[Bernhard Ströbl]

Hi Andreas,

I have no problem with invalid geometries in my PostGIS test layers with 
split parts using QGIS 2.14.15 on Linux.

Without having your data I cannot tell why yours are invalid.

Anyway you might try DigitizingTools plugin which has a tool that 
deletes a part of a multi feature and inserts it as a new (single-part) 
feature which might be easier to handle. You can later merge it to any 
feature you like. There is also a tool to fill gaps between features 
with a new feature.


Bernhard

Am 30.05.2017 um 16:41 schrieb Andreas Wicht:

On 29 May 2017 at 13:16, Andreas Wicht  wrote:

On 28 May 2017 at 14:43, James Wood  wrote:

On the digitizing toolbar, try "Split Parts" instead of "Split Features" on 
multipart polygons.


Thank you for the hint, James. Somehow I always thought that this
function is only suitable for separating an existing part from a
feature (never used it though).
Yet, if you cut a polygon with the "Split Parts" tool, the output will
be an invalid geometry (I observed self-intersections). This as well
can not be the intended behavior. I could observe those errors in
simple scratch layers as well as in PostGIS layers.

Has anybody else experienced this behavior?


Is my assumption right, that according to this issue
(https://issues.qgis.org/issues/12799) the current workflow would have
to look somewhat like this:
- use split parts tool to split the multipart polygon
- delete the newly created part (-> invalid geometry) using the
"Delete Part" tool

either
- create a new feature/new part (depending on the use case) inside the
hole created by deleting the part
- optional: attribute merging with other features surrounding the new
feature (depends on the complexity of the attribute table)
- change desired attribute(s) (which led to the decision to separate the area)

or
- use the "Reshape Features" tool to enlarge a neighbouring polygon by
the cut off area

or
- create new feature inside the hole and merge it ("Merge Selected
Features" tool) to enlarge a neighbouring polygon by the cut off area

Isn't that a bit too much post-processing for that cause?

Any thoughts?
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user





__ Information from ESET Mail Security, version of virus signature 
database 15501 (20170530) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Join multiple Linestrings to single Linestring

[Bernhard Ströbl]

Hi,
just to clarify things (all info is AFAIK):

1) Processing:
a) processing always creates a new layer as output
b) Dissolve always creates multi features
c) running multi-to-single afterwards creates single features for any 
connecting parts

d) b) and c) can be put into a model to run them in one step
e) Depending on its settings processing processes either the selected or 
all features of the input layer


2) Digitising:
a) works within the current layer and manipulates certain features
b) "merge selected features" creates single features if the lines are 
connected (= endpoints are snapped) and the geometry column is defined 
as Linestring in PostGIS (just tested with QGIS 2.14.13); may behave 
differently for other data providers
c) "merge selected features" deletes all existing datasets and inserts a 
new one; if you want to keep an existing dataset (foreign keys!) use 
DigitizingTools plugin's "merge selected features" instead


Bernhard


Am 20.04.2017 um 08:40 schrieb fuenfer-koenigstein.benja...@swm.de:

Hi Richard,

thanks again for your reply! I’m really amazed about the active
community around QGIS, never experienced that with any other GIS-Software!

‘Merge Selected Features’ is exactly the tool that I initially wanted to
use and then realized that it creates multiline-features which causes
problems with my linestring db table. Meanwhile I will use QAD plugin
that creates linestring or I will work with a local copy as you suggested.

So for me it works quite OK with this workaround, but maybe it would be
helpful to have an option to choose between creating multilinestring or
linestring when using the ‘Merge’ tool. What do others think? Useful and
important enough to open an issue?



Regards

Benni



*Von:*Richard McDonnell [mailto:richard.mcdonn...@opw.ie]
*Gesendet:* Mittwoch, 19. April 2017 16:02
*An:* Fuenfer-Koenigstein.Benjamin G-PRA; qgis-user@lists.osgeo.org
*Betreff:* Re: AW: [Qgis-user] Join multiple Linestrings to single
Linestring



Another option, you could try is using the*Advanced Digitising Toolbar*
under *View, Toolbars
*Select the lines you want to merge/Join and click *Merge Selected
Features*.
This should also allow you to edit the DB directly from QGIS.
I have not tried it, so your issue with Multi-Lines instead of single
linestrings may still apply.
You could still use the above example on the locally saved version of
the table though and upload and overwrite the changed dataset.
Sorry I cant be of more help.
Reagrds,

Richard.

On 19/04/2017 14:07, fuenfer-koenigstein.benja...@swm.de
 wrote:

Hi Richard,



thanks for your suggestion! I think Dissolve won’t work for me as
it’s applied to the whole layer (hope I understood this right). I’m
looking for a way to easily merge certain linestrings when I, for
example, want to create one geometry by first creating a spline and
then a straight line feature. I will try out your workaround with
local files. But as the db-source is very large (> 500.000 rows) I’m
happy for any other suggestion to solve it directly in QGIS with
db-source.



Regards

Benjamin



*Von:*Richard McDonnell [mailto:richard.mcdonn...@opw.ie]
*Gesendet:* Mittwoch, 19. April 2017 10:10
*An:* David J. Bakeman; Fuenfer-Koenigstein.Benjamin G-PRA;
qgis-user@lists.osgeo.org 
*Betreff:* Re: [Qgis-user] Join multiple Linestrings to single
Linestring



Benjamin,
You could try Dissolve, under Geoprocessing Tools, alternatively you
could try saving the dataset locally as a shapefile, edit using
either of the methods you outlined below, In relation to saving the
edits back to the table as linestring, use the DB Manager tool,
select the table you wish to update, tick the options you want,
making sure both *Replace destination Table (if exists) *and*Create
single-part geometries instead of multi-part* This has worked for me
in the past, admittedly for polygons, but it should also work for
linestrings.

Hope this helps,

Richard.

On 18/04/2017 17:24, David J. Bakeman wrote:

On 04/18/2017 02:17 AM, fuenfer-koenigstein.benja...@swm.de
 wrote:

Hi there,



I want to merge multiple linestrings with same start/endpoint to a single linestring 
(all lines within one layer). As I use a PostGIS source with geometry type linestring, it is 
important that the new geometry is still linestring and not multilinestring type. "Merge 
selected features" tool and "JOIN" in QAD-Plugin both create multilinestrings. Has 
anyone an idea how to directly merge into linestring or how to change geometry type after merging? 
Thanks for your suggestions!

I'm not sure I completely understand what you want but you could run

multipart to singleparts from the Vector/Geometry Tools menu on the

   

Re: [Qgis-user] PostGIS Query - DB Manager Not Recognizing Geom Column

[Bernhard Ströbl]

Hi,
you need to explicitly state the geometry type and SRS in you view 
definition like this:

CREATE OR REPLACE VIEW test.testbuff as
SELECT gid, area_id,
st_buffer(testshape.geom, 100)::geometry(Polygon,your_srs_code)
as geom2 FROM test.testshape where testshape.area_id=100;

could be Polygon or Multipolygon depending on the input, your_srs_code 
should be the same as testshape's


QGIS can analyze geometry columns and detect the type (and probably 
SRS), however only relations with geometry fields defined in this way 
are listed in geometry_columns.


Bernhard

Am 27.03.2017 um 23:42 schrieb Michael Treglia:

Hi All,

I'm running a PostGIS query to create a view, buffering a polygon -
viewing the result in DB Manager, the associated icon, rather than being
polygons, is a question mark, and in the info tab for the layer, I see
the warning ' There is no entry in geometry_columns!'

That said, the layer actually displays fine in QGIS, and in the list of
fields, the appropriate column is labeled as Type 'geometry'.

Thus, is this really a problem? And if so, any easy fixes? A sample
query is below:

CREATE OR REPLACE VIEW test.testbuff as
SELECT gid, area_id, st_buffer(testshape.geom, 100)
as geom2 FROM test.testshape where testshape.area_id=100;


Thanks for any suggestions!
Mike


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user





__ Information from ESET Mail Security, version of virus signature 
database 15160 (20170328) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Value relations in QGIS

[Bernhard Ströbl]

Hi Randal,
copying projects is even simpler with the authentication. Just make sure 
that all users have the same id set for their PostgreSQL-connection.
Another way to achieve what (I assume) you intend is to use my Plugin 
DataDrivenInputMask [1] that automatically creates combos for relations, 
checks for default and not null values etc.


Bernhard

[1] http://plugins.qgis.org/plugins/DataDrivenInputMask/

Am 18.03.2017 um 16:52 schrieb didier peeters:

Hello Randy,

I haven’t been working with value relations very recently but what I
used to do to easily share it with other users was to save everything in
the project file, then duplicate this file and replace the login name
(or anything else that would need to be adapted) with a text editor.

HTH,

Didier




Le 17 mars 2017 à 16:42, Randal Hale > a écrit :

Question.

I'm working with a group and I'm attempting to "idiot proof" editing a
bit - well - at least the attribution. I've set up a database
(postgresql/postgis) and went so far as to set up foreign keys. I set
up value relations and we now have drop down lists for about everything.

I decided to save what I am doing. I saved the data layer as a qlr. I
saved the style as a qml. I re-added the data using the qlr and the
style using the qml. EXCEPT - it didn't restore the value relations.
They are in the qml file:

   



  

the Layer -> contractor_tbl20170317111848429 isn't quite the right
name but I'm assuming that's some internal QGIS layer naming. I even
changed it - it wouldn't restore.

I did more digging and discovered the value relation is also in the
qlr file - but it's not restoring the widgets either. Maybe it doesn't
matter that I saved a qml.

Question is - should it restore? Or are value relations (widgets) just
for that QGIS session - so I need to set this up 5 times for 5 people?
Which I don't mind doing - I was under the impression this
saved/restored with the qlr/qml.

QGIS: 2.18.4
OS: Ubuntu (mate) 16.04
QGIS repo/Ubuntu GIS repo.

Thanks

Randy




__ Information from ESET Mail Security, version of virus signature 
database 15116 (20170320) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] FW: Simple methodology for user / data / map interactivity?

[Bernhard Ströbl]

Hi Graeme,
as I wrote in my last mail you can set a filter for a layer. This does 
exacly what you describe. Changing the filter according to a changed 
selection in another layer and zooming to the new set sounds like a 
plugin, though.
An non-plugin approach would be to create a view on the db that joins 
zones and roads spatially (e.g. ST_Intersects). If you load this view 
into QGIS you can select the road network layer by attribute zone_id, 
then zoom to the selected road segements. Be aware that QGIS needs a 
unique key for any layer.


Bernhard

Am 24.02.2017 um 15:34 schrieb SEGGIE Graeme:



Brent / Bernhard,



Thanks both for the detailed responses. It does look like I am
re-inventing a process that can be done as an informed user, I suppose
the example I suggested might be too simple to be worth going to the
lengths I described, but I was thinking of some of the manual processes
I see on editing data and wanted to refine a process to be such that
repetitive steps could be minimised somehow.



I see some stuff from both your responses worth me looking into anyway
even if not pursuing my original approach, which is good.



I have played some more with this, but am struggling to see how I would
do the following, which seems like a logical thing to do with QGIS
acting as a front end to a database.  If I have a zone layer and a road
network layer, how do I link the two such that the selection in one
layer impacts the view of the other? For example, if I select a zone, I
would like that selected zone_id, to be passed to PostGIS, to identify
the roads which intersect the selected zone and only display them (or
display them as dominant) as selected in the network layer. Is there a
way of filtering one layer on the selection of another i.e. filter on
where zone_id in (selected zone_id in layer X)



Graeme.







Hi Graeme,



QGIS can do what you describe in your example out of the box.

Workflow:

0) copy layer

1) select polygon in layer

2) use the spatial query plugin

  - select source from layer_copy

  - Where the feature intersects

  - reference features of layer (tick 1 selected polygon)

- apply

3) zoom to selection of layer_copy



If you work with PostGIS you can use the layer's filter to enter any SQL
thus restricting the features to those that fit into the filter rule.

Then zoom to the layer and you are done.

You can load the result of a query against a PostGIS DB as layer into
QGIS, too, by using DB manager.

For automation Processing's graphical modeler might be worth looking at.



Of course you can do most things with a plugin that you e.g. connect to
a layer action. I am always reluctant to write a plugin for workflows
that can be performed using QGIS' standard tools, though.

I know users like to klick on a dedicated button and then something is
run just the way they (think they) need it, however IMHO the smarter
approach is to train the users to do these tasks themselves with the
standard tools.



Bernhard



…





Sort of in the area you are asking about:



See the Action tool



Under Windows this can invoke a batch file to display the result of an
sql for data about the (Postgis) feature clicked on. Even easier under
Linux with a bash script. If one of the fields is an image file, you can
create an action to display the image associates with the feature. A
useful bit of functionality...



But to do exactly what you are asking, I think the Attribute table does
this, so it is a matter of explaining the steps to your users, rather
than writing code...



If you select a set of features in a Postgis (or most type of layer)
layer rendered on the map, QGIS highlights the selected ones as defined
in the project properties. Open the Attribute table for the layer, you
will see the selected features, not only highlighted on the map, but
also in the attribute list. Click the "move selected features to top"
button, and the selected/highlighted features will always be at the top
of the list. The attribute table has buttons at the top to zoom & pan to
selected features...



Cheers,



Brent







*From:*SEGGIE Graeme >
*To:* "Qgis-user@lists.osgeo.org "
>
*Sent:* Friday, February 24, 2017 6:48 AM
*Subject:* [Qgis-user] Simple methodology for user / data / map
interactivity?



I would like to use QGIS as a visual / interactive front to some PostGIS
data and am not sure what the best route to doing so is. Happy to
explore further myself, but wanted to get some input on what needs to be
joined up to get started on building a little process.



Basically, if I wanted to present a map of features and have a button
(like the attribute information one) which a user would click then use
to select features, I want this to run a SQL query which to get related
features for 

Re: [Qgis-user] Simple methodology for user / data / map interactivity?

[Bernhard Ströbl]

Hi Graeme,

QGIS can do what you describe in your example out of the box.
Workflow:
0) copy layer
1) select polygon in layer
2) use the spatial query plugin
 - select source from layer_copy
 - Where the feature intersects
 - reference features of layer (tick 1 selected polygon)
 - apply
3) zoom to selection of layer_copy

If you work with PostGIS you can use the layer's filter to enter any SQL 
thus restricting the features to those that fit into the filter rule. 
Then zoom to the layer and you are done.
You can load the result of a query against a PostGIS DB as layer into 
QGIS, too, by using DB manager.

For automation Processing's graphical modeler might be worth looking at.

Of course you can do most things with a plugin that you e.g. connect to 
a layer action. I am always reluctant to write a plugin for workflows 
that can be performed using QGIS' standard tools, though.
I know users like to klick on a dedicated button and then something is 
run just the way they (think they) need it, however IMHO the smarter 
approach is to train the users to do these tasks themselves with the 
standard tools.


Bernhard

Am 23.02.2017 um 18:48 schrieb SEGGIE Graeme:

I would like to use QGIS as a visual / interactive front to some PostGIS
data and am not sure what the best route to doing so is. Happy to
explore further myself, but wanted to get some input on what needs to be
joined up to get started on building a little process.



Basically, if I wanted to present a map of features and have a button
(like the attribute information one) which a user would click then use
to select features, I want this to run a SQL query which to get related
features for example and highlight them on the map view, possibly pan to
the extent of the newly selected feature set.



Does this sound like a plugin – or would that be taking things too far?



Would the best way for the dynamic layer to be setup, to be a view –
empty except when populated by the query and styled to be dominant over
the full set of features?



As a simple example, say I had a district zone system of polygons and I
wanted a user to be able to click on any polygon, and have all the
neighbouring polygons highlighted, centred and fill the map view as
fully as possible. What would be the best / simplest approach to this?



Graeme






__ Information from ESET Mail Security, version of virus signature 
database 14988 (20170224) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] How to 'difference' in existing layer

[Bernhard Ströbl]

Hi Lene,

try the DigitizingTools plugin [1]. The function that does just what you 
want is "Cut with polygon from another layer".
Be aware that this tool is intended for use during digitizing: you can 
decide which features of layer A to cut and which features of layer B to 
use for cutting by making selections. It is possible to cut all features 
of layer A with all features of layer B, though.


Bernhard

[1] http://plugins.qgis.org/plugins/DigitizingTools/

Am 13.02.2017 um 08:45 schrieb Lene Fischer:

Hi



I have two layers of polygons

I want to make holes in the first layer using the second layer as mask.



I can do this by function ‘Difference’ – but the result is a third layer.

I would like the holes in the polygons to be in the first (existing) layer.



Any suggestions J



Regards





*Lene Fischer***

Associate Professor



*University of Copenhagen***

Department of Geoscience and Natural Resource Management

Forest and Landscape College

Nødebovej 77a

3480 Fredensborg

Denmark





DIR +45 35331579

MOB +45 40115084

l...@ign.ku.dk 

www.ign.ku.dk 





cid:image001.gif@01D2444C.0C2DB110







___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user




-


__ Information from ESET Mail Security, version of virus signature 
database 14933 (20170214) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] How to force exact/korrekt editing polygon layer, (topological)

[Bernhard Ströbl]

Hi Bernd,

QGIS can prevent gaps/intersections between polygons of the same layer, 
you only have to switch on the options. IMHO QGIS should not always 
prevent this because e.g. users may deliberately leave gaps.


So how can you solve your problem?
1) You could teach your users what the options mean and how to use them 
(I regularly teach my users).
2) You could further prepare a project for them where the snapping 
options are enabled for the layers in question. If you are in PostGIS 
create a new DB user that has full rights on these tables and load the 
layers with this user account, revoke all editing rights from all other 
DB users. Thus your QGIS users can only edit when they use your prepared 
project. Be aware that QGIS stores username and password in the project 
file, but I would not see a problem in this if your users are as dumb as 
you claim :-)
3) If on PostGIS you could enable triggers on insert/update that does 
not accept invalid polygons/overlaps between polygons. No way to prevent 
gaps during editing; gaps must be identified end eliminated afterwards.
(4) I have never tried PostGIS' new topology. Maybe it is worth checking 
it out.


Bernhard

Am 11.01.2017 um 09:24 schrieb Bernd Laskowski:

Hi Jürgen, what about dumbest assumable user  or lusers?

Thanks a lot Harrissou
but I know the standard options to use topological editing funktions.
I have problems with foolish users. They forget to activat topological
editing or snap-option and so on.
We need a solution to prevent saving intersections or/and holes/gaps
within qgis or postgis.

Regards
Bernd



___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user





__ Information from ESET Mail Security, version of virus signature 
database 14749 (20170111) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Joining polygons

[Bernhard Ströbl]

Hi,
try using "Multipart to singleparts" afterwards

Bernhard

Am 29.11.2016 um 12:31 schrieb Joris Hintjens:

Thanks for you input, but this does not work. It makes 1 multi polygon, not 
multiple polygons. It asks an attribute to separate the polygons, but I have no 
useful attributes that differ in the right way.

Joris

Op 29 nov. 2016, om 15:21 heeft Leknín Řepánek  het 
volgende geschreven:

vector -> geoprocessing tools -> dissolve

On Tue, Nov 29, 2016 at 12:11:24PM +0100, Joris Hintjens wrote:

Hello,
I have a shapefile with polygons that I want to join if they touch. They have
no useful property to group them. How can I do that?

My goal: group parcels within house blocks to 1 polygon. So that my layer of
parcels becomes a layer of house blocks.
see a sample at
https://dl.dropboxusercontent.com/u/23700421/
Schermafbeelding%202016-11-29%20om%2012.07.16.png

Joris



___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user




___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user





__ Information from ESET Mail Security, version of virus signature 
database 14522 (20161129) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Using non ascii characters in PostgreSQL passwords

[Bernhard Ströbl]

Hi,

I have some 150 users here connecting to PostGIS and did never have any 
such problems (Umlaute are allowed), I suspect an encoding problem 
(different encodings in QGIS and PostGIS)


Bernhard

Am 24.11.2016 um 08:44 schrieb timosiegward.alteme...@stadt.wolfsburg.de:

Hi all,



I getting an error message in QGIS 2.14 - 2.18 when I trying to login to
a PostgreSQL db with passwords containing german umlauts (ü, ä, ö,) or
special characters (e.g. €):



Connection to database failed

FATAL:  Passwort-Authentifizierung für Benutzer »timo« fehlgeschlagen



The Login into the webinterface phpPgAdmin works without any problems.
Is there a solution for my error message or are only ascii characters in
passwords supported in QGIS?



Regards

Timo





***



Stadt Wolfsburg

Geschäftsbereich IT - 15-3 GIS

Rathaus E, Zi. E 313, Porschestraße 47A, D-38440 Wolfsburg Tel +49 5361
28-1977 Fax +49 5361 28-1765

mailto:timosiegward.alteme...@stadt.wolfsburg.de



___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user





__ Information from ESET Mail Security, version of virus signature 
database 14495 (20161124) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Struggling with datum transformations and grid shift files

[Bernhard Ströbl]

Hi Andreas,

I always put a 0 (zero) as destination datum. I cannot explain it but it 
works when transforming with a grid. If I leave the destination datum 
empty the new record is not saved.


Bernhard

Am 04.10.2016 um 12:58 schrieb Neumann, Andreas:

Hi,

I am struggling in QGIS 2x with datum transformations.

The manual is not explicit how to handle this correctly.

Here are the steps I tried:

1. As far as I understand, I have to copy the gsb file to the directory
where proj stores the gsb files, in my case "C:\Program
Files\OSGeo4W64\share\proj". Alternatively, one could set another folder
and adjust the PROJ_LIB env variable accordingly.

2. In "Settings" --> "Options" --> "CRS" I can define default datum
transformations. I tried to enter 21781 (Source CRS), 2056 (Destination
CRS), +nadgrids=CHENYX06a.gsb (Source datum transfomation). Destionation
datum has been left empty.

3. I would expect that whenever this combination 21781 --> 2056 shows up
that QGIS would ask me to pick one the defaults specified in 2.

The problem is that 2. does not work. When I close the dialogue and
reopen it, my modifications are gone ... and I never have the chance to
select my datum transformation option.

Can you help me what I am doing things wrong?

Thank you,

Andreas




__ Information from ESET Mail Security, version of virus
signature database 14223 (20161004) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user





__ Information from ESET Mail Security, version of virus signature 
database 14223 (20161004) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Linear referencing in QGIS

[Bernhard Ströbl]

Hi Paolo,

I included the code in a small plugin for you to check it out. It's on 
github: https://github.com/bstroebl/Station


Could certainly be improved by snapping to the line (snap to segment 
must be turned on).


regards

Bernhard

Am 08.09.2016 um 08:39 schrieb Paolo Cavallini:

Hi Bernhard,

Il 08/09/2016 08:00, Bernhard Ströbl ha scritto:


however I have some Python code here in operation that returns a
"station" on a line by clicking on the line (or near it, as you won't
hit the line without snapping to segment). A "station" is a position on
the line, i.e. the start point of the line is station = 0, the end point
of the line is station = line.length().
Rational was to identify stations on street lines where certain
infrastructure like sewer covers are situated.
Will share if you are interested.


I am, please do.
Thanks.





__ Information from ESET Mail Security, version of virus signature 
database 14089 (20160908) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Linear referencing in QGIS

[Bernhard Ströbl]

Hi Régis,

I do not quite understand what you mean with the m or z picker tool, 
however I have some Python code here in operation that returns a 
"station" on a line by clicking on the line (or near it, as you won't 
hit the line without snapping to segment). A "station" is a position on 
the line, i.e. the start point of the line is station = 0, the end point 
of the line is station = line.length().
Rational was to identify stations on street lines where certain 
infrastructure like sewer covers are situated.

Will share if you are interested.

regards

Bernhard

Am 07.09.2016 um 21:22 schrieb Régis Haubourg:

Hi All,
I've been using linear referencing extensively here to produce european
reference datasets of water bodies. Postgis works just fine and fast.
What I have been missing, and average users probably miss that too, is:

  - A tool to "calibrate" a route from data, points, or lines:
Currently LRS can do that only with point data. Postgis misses also a
simplified function.
  That "route generation" tool should have tolerance options and do
something like a grass clean and auto arc orienting, and must be able to
generate route from points or lines, or multilines.


- A generic graphical "m" or "z" picker editor widget:
Use case: you need to create linear or point events against a route system,
just clicking on a route and getting X,Y, M,Y and storing it in attribute
table . I can imagine along the line edit widget, a small button (like a
color picker) , once pressed allow the user to click on the map. Question
is, how to confirm wich geometry event has been clicked in case of
proximity or superposition. One idea could be to have a dropdown list box
of values under the click, displaying event identifier and m / z value.

I'd be happy to discuss that with you all.


Cheers
Régis



2016-09-07 16:51 GMT+02:00 Neumann, Andreas :


Hi,

Yes, I know about LR expressions in the current master versions.

So one could visualize the events table through a virtual geometry column
- would that work?

I will forward all this information to my friend.

Greetings,

Andreas

On 2016-09-07 15:34, Matthias Kuhn wrote:

Hi Andreas,

In QGIS 2.18 / QGIS 3.0 this should be possible via expressions:

https://github.com/qgis/QGIS/commit/e110ba7d54b0ac7d3f63e8ed7eaebb
2845f9f38c

Best regards
Matthias

On 09/07/2016 02:24 PM, Neumann, Andreas wrote:

Hi,

A friend of mine asked me if QGIS can do linear referencing - e.g.
symbolizing road data speed limits along a road, lets say from km 0 to
0.76 there is a limit of 50 km/h, from 0.76 to 1.23 there is 80 km/h
limit, etc.

The idea is to symbolize these road segments without having to actually
split the data into bits. And hopefully without having to generate
derived tables that have no link to the original data.

Is QGIS able to do this, perhaps with a plugin?

Thanks for any hints,

Andreas







__ Information from ESET Mail Security, version of virus signature 
database 14088 (20160908) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] QGIS Server error when printing to PDF

[Bernhard Ströbl]

Hi Dimitri,

could you post the error that the server returns to the client?
What happens when you hit the print button in the WebClient? What 
happens if you paste the print-URL directly into your browser? Do you 
have a program connected with pdf on your client computer?


Bernhard

Am 25.08.2016 um 05:33 schrieb DimK:

Hello,

When using the print option from the QGIS Web Client to print pdf, an
internal server error is returned:

http://localhost/qgis/qgis_mapserv.fcgi.exe?map=c%3A%2FApach
e24%2Fhtdocs%2Fmygis%2Fprojects%2Fhelloworld.qgs=
WMS=1.3=GetPrint=pdf
=application%2Fvnd.ogc.se_inimage=true=
EPSG%3A3857=300=Composer%201%3Aextent=-
3586440.5%2C1909298.7%2C3938740.5%2C6179401.3%
3Arotation=0%3Ascale=3500%3Agrid_interval_
x=250%3Agrid_interval_y=250=
Country%2CHello=255%2C255

My log file error:

[Mon Aug 22 08:47:18.033625 2016] [cgi:error] [pid 3428:tid 1036] [client
::1:49864] End of script output before headers: qgis_mapserv.fcgi.exe
[Mon Aug 22 08:47:18.033625 2016] [cgi:error] [pid 3428:tid 1036] [client
::1:49864] AH01215: Warning 1: Unable to find driver ECW to unload from
GDAL_SKIP environment variable.\r: C:/QGIS/apps/qgis-ltr/bin/qgis
_mapserv.fcgi.exe
[Mon Aug 22 08:47:18.034626 2016] [cgi:error] [pid 3428:tid 1036] [client
::1:49864] AH01215: Warning 1: Unable to find driver ECW to unload from
GDAL_SKIP environment variable.\r: C:/QGIS/apps/qgis-ltr/bin/qgis
_mapserv.fcgi.exe
[Mon Aug 22 08:47:18.034626 2016] [cgi:error] [pid 3428:tid 1036] [client
::1:49864] AH01215: Warning 1: Unable to find driver JP2ECW to unload from
GDAL_SKIP environment variable.\r: C:/QGIS/apps/qgis-ltr/bin/qgis
_mapserv.fcgi.exe
[Mon Aug 22 08:47:18.034626 2016] [cgi:error] [pid 3428:tid 1036] [client
::1:49864] AH01215: Warning 1: Unable to find driver ECW to unload from
GDAL_SKIP environment variable.\r: C:/QGIS/apps/qgis-ltr/bin/qgis
_mapserv.fcgi.exe
[Mon Aug 22 08:47:18.034626 2016] [cgi:error] [pid 3428:tid 1036] [client
::1:49864] AH01215: Warning 1: Unable to find driver JP2ECW to unload from
GDAL_SKIP environment variable.\r: C:/QGIS/apps/qgis-ltr/bin/qgis
_mapserv.fcgi.exe
[Mon Aug 22 08:47:18.034626 2016] [cgi:error] [pid 3428:tid 1036] [client
::1:49864] AH01215: QFSFileEngine::open: No file name specified\r:
C:/QGIS/apps/qgis-ltr/bin/qgis_mapserv.fcgi.exe


But when I replace FORMAT output to PNG - it's all right!

I use QGIS 2.8 (long term) 64 bit version on Windows Server 2012 R2
Standard, Apache 2.4.20 (Win64). I tried using version 2.14 and 2.16 but
without success.

How to fix it? Any ideas?

Dmitry Konoplya



__ Information from ESET Mail Security, version of virus signature 
database 14014 (20160824) __

The message was checked by ESET Mail Security.
http://www.eset.com




___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user





__ Information from ESET Mail Security, version of virus signature 
database 14015 (20160825) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Digitizing Tools Symbols lost

[Bernhard Ströbl]

check http://hub.qgis.org/issues/14825
Bernhard

Am 28.06.2016 um 08:50 schrieb Juerg Lindauer:

Hi

After updating QGIS from 2.8.4 to 2.8.9 the symbols of Digitizing Tools
are lost in the tool bar. You can use the functions, but the symbols are
not showing.

To reinstall the Digitizing Tools have not solved the problem. Has
anybody an idea?

Thanks,
Jürg Lindauer

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user





__ Information from ESET Mail Security, version of virus signature 
database 13717 (20160628) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] PlanZV für QGIS

[Bernhard Ströbl]

http://qgis.de/doku.php?id=site:darstellung

Bernhard

Am 24.06.2016 um 10:19 schrieb Elstermann, Mike:

Hallo zusammen,

weil wohl eher in Deutschland von Bedeutung, diese Anfrage auch auf deutsch.
Kennt jemand eine Quelle für die Umsetzung der PlanZV im FNP-Bereich. Gesucht 
sind Linie-, Punkt- und Flächensignaturen gem. BauGB. am besten für alle 
Darstellungsarten (Farbe, Grau, S/W).


Danke und Beste Grüße
mikeE., Der geoObserver.

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user





__ Information from ESET Mail Security, version of virus signature 
database 13698 (20160624) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] (poor) performance loading postgis layers in qgis-server 2.8 ltr + postgis 2.1 + lizmap web-client

[Bernhard Ströbl]

I am just wondering: Why is the "big" table only twenty rows? Is this a 
multi(polygon?) table? If yes and the parts of each multipolygon are all 
over the place then this is your problem. QGIS has to load all parts 
although only a couple of them are visible at the moment. And if it 
happens that parts of all 20 features are visible QGIS has to load 
_everything_.


To make it a non-multi table:

CREATE newtable as(
gid SERIAL NOT NULL
other_fields,
pk_constraint);
SELECT addgeometrycolumn(newtable,); --Polygon
-- explode-code
INSERT INTO newtable(gid,the_geom,other_fields)
SELECT nextval('newtable_gid_seq') AS gid, the_geom, other_fields
FROM (SELECT ST_GeometryN(the_geom, generate_series(1, 
ST_NumGeometries(the_geom))) AS the_geom, other_fields

FROM your_multi_table
WHERE GeometryType(the_geom) = 'MULTIPOLYGON'
) AS foo;

(I do not remember where I once read this code, so I cannot give credits 
to the author here, I am afraid)


You could of course explode the multi features in QGIS and load the 
result into the db, too.

Create a spatial index on newtable and vacuum it afterwards.

Bernhard

Am 24.06.2016 um 05:40 schrieb Daniel Vicente Lühr Sierra:

Hi,

Indeed, 2.14.3 shows a better performance with respect to serving
database data, even without yet tuning the database server.

But, I still experience some performance issues. One, I detected when
using the print composer, which is very unresponsive if there is a map
object with a big database layer and redrawing is needed (without
drawing the map, the UI responds fine).

Second, the webclient layers load in decent time, even the "big-one".
But, trying to use lizmap's "tooltip" feature on the big layer, or
trying to access its attribute table is still not possible. I haven't
checked the code, but maybe the way the data is being requested in these
situations is suboptimal?

Regards

El 21/06/16 a las 11:08, Daniel Vicente Lühr Sierra escribió:


Hi Régis,


El 21/06/16 a las 10:37, Régis Haubourg escribió:

Hi,
please see that thread [0]

Thanks.

I suggest you first upgrade qgis server to last 2.14.3.

Ok, some weeks ago I decided to stay with 2.8 ltr, until 2.14 was more
tested, it looks like it is time for upgrading.

Then we still have issues with big relational views, not tables - for
first getcapabilities generation (ie first load for a session).
You can also check your postgres logs to look at what queries are
sent to PG and then tune your pg server based on those queries.

Ok. Although, I still need to learn how to do it ...

Please keep us informed of how it works, we have the very same concerns.

Sure, thanks again.

[0] 
http://osgeo-org.1560.x6.nabble.com/Server-performance-questions-td5252233i20.html#a5268188

2016-06-21 16:29 GMT+02:00 Daniel Vicente Lühr Sierra :

 Hi,

 It is my first time at setting up a postgres/PostGIS db for
 storing "serious" data (previously, I had only tested if it
 worked, with a couple of small data tables).

 When testing the web-client (lizmap) installation I noticed that
 the sample data loaded pretty fast, but when I tried a project
 containing 2 vector layers stored in the database, one very
 small, the second one was originally a ~30Mb shape file, the
 loading process for the 2 layers is noticeable, and reading the
 attribute table of the big vector layer (only 20 rows and 10
 fields) takes ages (actually, I wasn't able to wait for it to load).

 I did some "google" research and found out that there might be
 some performance issues on qgis-server when accessing postgresql
 layer, or it could be that the performance of the db is low (I
 haven't run the tuning utility, yet).

 Any ideas on how to hunt down this performance issue? May it be
 an issue with the web-client, also?

 Btw, everything is running locally on a VM for now, although the
 final deployment will be on "real" hardware.

 Thanks

 --
 Daniel Vicente Lühr Sierra
 IEEE Member
 IEEE Student Branch Counselor - Universidad Austral de Chile





__ Information from ESET Mail Security, version of virus signature 
database 13698 (20160624) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] FW: Cannot split feature in a multipolygon PostGIS feature type in QGIS

[Bernhard Ströbl]

Hi Chris,

I assume you use the interactive scissor tool? If I use this to split a 
part of a two-part multipolygon feature (one part has a hole in it) I 
end up with three data sets:

1) northern half of part 1,
2) southern half of part 1
3) part 2
This is QGIS 2.14.3, PostGIS 2.2

Be sure that the edit layer is in the same projection as the project, 
though.


Bernhard

Am 23.06.2016 um 12:01 schrieb Chris Buckmaster:

Sorry I should point out that my feature I am trying to edit has multiple donut 
type areas within it, as I just tried it on a 'normal' feature from the same 
layer and it worked - so perhaps my question is are there known issues when 
trying to split features that have donuts existing in them?!

From: Chris Buckmaster
Sent: 23 June 2016 10:58
To: qgis-user@lists.osgeo.org
Subject: Cannot split feature in a multipolygon PostGIS feature type in QGIS

Hi

I am trying to use the split features tool to split a feature but am having 
problems.

The layer is a PostGIS layer which has a multipolygon type, when I try to split 
it I do not receive any warnings / errors, but nothing is split. Can I ask are 
there any known issues when trying to use the split feature tool on PostGIS 
multipolygon feature types?

Thanks



__ Information from ESET Mail Security, version of virus signature 
database 13693 (20160623) __

The message was checked by ESET Mail Security.
http://www.eset.com




___



__ Information from ESET Mail Security, version of virus signature 
database 13693 (20160623) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Splitting Polygons

[Bernhard Ströbl]

Hi,

AFAIK processing output is always a new layer. If you want to split 
certain features within the layer check DigitizingTools plugin.


Bernhard

Am 22.06.2016 um 09:38 schrieb Springfield Harrison:

Hello List,

Is there a geo-processing tool to split polygon features in one layer using
lines or polygons in another layer?  It is important that the new features
remain in their original layer, just split into two.

This would be much like the fTools Plugin

called Split Feature except using lines already existing in another layer.  I
don't want the output in another layer which then has to be copied and pasted
back to the original.

I have hunted through the advanced toolbox with no luck yet, although maybe what
I need is hiding in there somewhere.

Thanks very much for any help, Cheers . . . . . . . . Springfield Harrison


__ Information from ESET Mail Security, version of virus signature
database 13686 (20160622) __

The message was checked by ESET Mail Security.
http://www.eset.com



___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user





__ Information from ESET Mail Security, version of virus signature 
database 13686 (20160622) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Very long sql in postgres layer definition

[Bernhard Ströbl]

Hi Samuel,

you could use the layer filter, couldn't you? It's the second last 
parameter in the setDataSource method.


Bernhard

Am 26.05.2016 um 12:23 schrieb Samuel Ingarfield:

Good idea, but I need to be able to vary a parameter in the sql expression
to filter the dataset differently as the user requires.
Filtering needs to happen on the sql server, the dataset is far too large
to filter directly within qgis (roughly 100mil rows).

Sam.

On Thu, May 26, 2016 at 4:20 PM, Bernhard Ströbl <bernhard.stro...@jena.de>
wrote:


Maybe it's easier to create a view on the DB and load that?

Bernhard


Am 26.05.2016 um 09:52 schrieb Samuel Ingarfield:


Hi Bernhard;

I can load the layer using an identical query in the DB manager sql
window.
Yes, r.id is a unique key.

Sam.

On Thu, May 26, 2016 at 3:37 PM, Bernhard Ströbl <
bernhard.stro...@jena.de>
wrote:

Can you load it via the "add PostGIS layer" button?

Is r.id a suitable key (unique)?

Bernhard


Am 26.05.2016 um 09:33 schrieb Samuel Ingarfield:

Hi All,


I'm trying to load a postigs layer via python which is defined by a very
long sql query. It seems that Qgis is truncating the query (which
obviously
causes it to fail). Has anyone come across this before and come up with
a
solution? Or am I loading the layer incorrectly?

There is an unanswered question on stackexchange regarding this:


http://gis.stackexchange.com/questions/162409/how-to-load-layers-from-postgres-using-select-statement

My python code is very simple:
sql = 'a very long query'
uri=QgsDataSourceURI()
uri.setConnection(host,"5432",dbname,user,passwd)
uri.setDataSource("",sql,"geom","","r.id")
vlayer = QgsVectorLayer(uri.uri(),"layer_name","postgres")
QgsMapLayerRegistry.instance().addMapLayer(vlayer)

The debug log shows the following:
qgsmessagelog.cpp(45) : (QgsMessageLog::logMessage) [1ms]
2016-05-26T15:16:14 PostGIS[1] NOTICE: NOTICE:  identifier "...long
query
here..." will be truncated to "...truncated query here..."
qgsmessagelog.cpp(45) : (QgsMessageLog::logMessage) [1ms]
2016-05-26T15:16:14 PostGIS[1] Erroneous query: ...etc

Any help would be great.
Sam.






__ Information from ESET Mail Security, version of virus signature
database 13547 (20160526) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user





__ Information from ESET Mail Security, version of virus signature 
database 13548 (20160526) __

The message was checked by ESET Mail Security.
http://www.eset.com




___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user





__ Information from ESET Mail Security, version of virus signature 
database 13548 (20160526) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Very long sql in postgres layer definition

[Bernhard Ströbl]

Maybe it's easier to create a view on the DB and load that?

Bernhard

Am 26.05.2016 um 09:52 schrieb Samuel Ingarfield:

Hi Bernhard;

I can load the layer using an identical query in the DB manager sql window.
Yes, r.id is a unique key.

Sam.

On Thu, May 26, 2016 at 3:37 PM, Bernhard Ströbl <bernhard.stro...@jena.de>
wrote:


Can you load it via the "add PostGIS layer" button?
Is r.id a suitable key (unique)?

Bernhard


Am 26.05.2016 um 09:33 schrieb Samuel Ingarfield:


Hi All,

I'm trying to load a postigs layer via python which is defined by a very
long sql query. It seems that Qgis is truncating the query (which
obviously
causes it to fail). Has anyone come across this before and come up with a
solution? Or am I loading the layer incorrectly?

There is an unanswered question on stackexchange regarding this:

http://gis.stackexchange.com/questions/162409/how-to-load-layers-from-postgres-using-select-statement

My python code is very simple:
sql = 'a very long query'
uri=QgsDataSourceURI()
uri.setConnection(host,"5432",dbname,user,passwd)
uri.setDataSource("",sql,"geom","","r.id")
vlayer = QgsVectorLayer(uri.uri(),"layer_name","postgres")
QgsMapLayerRegistry.instance().addMapLayer(vlayer)

The debug log shows the following:
qgsmessagelog.cpp(45) : (QgsMessageLog::logMessage) [1ms]
2016-05-26T15:16:14 PostGIS[1] NOTICE: NOTICE:  identifier "...long query
here..." will be truncated to "...truncated query here..."
qgsmessagelog.cpp(45) : (QgsMessageLog::logMessage) [1ms]
2016-05-26T15:16:14 PostGIS[1] Erroneous query: ...etc

Any help would be great.
Sam.






__ Information from ESET Mail Security, version of virus signature 
database 13547 (20160526) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Very long sql in postgres layer definition

[Bernhard Ströbl]

Can you load it via the "add PostGIS layer" button?
Is r.id a suitable key (unique)?

Bernhard

Am 26.05.2016 um 09:33 schrieb Samuel Ingarfield:

Hi All,

I'm trying to load a postigs layer via python which is defined by a very
long sql query. It seems that Qgis is truncating the query (which obviously
causes it to fail). Has anyone come across this before and come up with a
solution? Or am I loading the layer incorrectly?

There is an unanswered question on stackexchange regarding this:
http://gis.stackexchange.com/questions/162409/how-to-load-layers-from-postgres-using-select-statement

My python code is very simple:
sql = 'a very long query'
uri=QgsDataSourceURI()
uri.setConnection(host,"5432",dbname,user,passwd)
uri.setDataSource("",sql,"geom","","r.id")
vlayer = QgsVectorLayer(uri.uri(),"layer_name","postgres")
QgsMapLayerRegistry.instance().addMapLayer(vlayer)

The debug log shows the following:
qgsmessagelog.cpp(45) : (QgsMessageLog::logMessage) [1ms]
2016-05-26T15:16:14 PostGIS[1] NOTICE: NOTICE:  identifier "...long query
here..." will be truncated to "...truncated query here..."
qgsmessagelog.cpp(45) : (QgsMessageLog::logMessage) [1ms]
2016-05-26T15:16:14 PostGIS[1] Erroneous query: ...etc

Any help would be great.
Sam.



__ Information from ESET Mail Security, version of virus signature 
database 13547 (20160526) __

The message was checked by ESET Mail Security.
http://www.eset.com




___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user





__ Information from ESET Mail Security, version of virus signature 
database 13547 (20160526) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Performance rendering PostGIS-Data

[Bernhard Ströbl]

Hi Benjamin,

just a note about indices: if you index e.g. "road class" which only has 
5 classes the index may be counterproductive, because Postgres reads the 
index and then uses itx to decide which datasets to read and has to read 
most of them anyways. It might be faster to read all datasets and sort 
out which suit the condition. Check with EXPLAIN on the server.


Bernhard

Am 24.05.2016 um 15:32 schrieb fuenfer-koenigstein.benja...@swm.de:

Hi all,

I have a problem gaining better performance during rendering PostGIS Data in 
QIS. I hope the following example helps understanding the issue:

I use road-data (line-geometries) in a PostGIS database (localhost), the 
geometry-table has about 400,000 rows.
Roads have 6 different classes I want to style with different line-symbols. 
Depending on scale I only want to show some of the major road classes (scale up 
to 1:50,000) or all the roads (scale higher 1:50,000). I use a rule-based 
styling with road type attributes and min/max-scale, in some cases I use 
subclasses for bridges, tunnels and normal lanes.

If I refresh the view in QGIS and check pg_log, I see that QGIS sends a 
SQL-statement with a bounding-box created from the current canvas:
SELECT ... WHERE "the_geom" && st_makeenvelope(xmin,ymin,xmax,ymax)

As long as the bounding-box is small enough (scale is high enough), PostGIS 
uses a spatial index and the performance while rendering in QGIS is quite good.
 From a certain scale on (smaller than 1:250,000), spatial index isn't used 
anymore (seems that PostGIS decides that it's needles as nearly the whole 
data-extend is within bounding-box). From that point on, rendering  is very 
slow, even though only the major-roads are shown in QGIS (about 200 geometries 
of the total 400,000).

That's what I tried already with no success:

-   Trying different combinations of styling rules and min/max-scale

-   Rendering-options in QGIS, simplify geometry, simplify on provider side 
if possible

-   Generating indices on all the attributes I use for styling the 
road-data on the database

Only thing that helps is to duplicate the layer in QGIS for each scale-level 
(above/under 1:50,000) and setting provider feature filter to select only 
features that are actually shown on the scale-level under 50.000. Than the 
SQL-statement logged changes to:
SELECT ... WHERE ("the_geom" && st_makeenvelope(xmin,ymin,xmax,ymax) AND 
(((road_class IN ('major1','major2',
Performance is much better but I'm not really glad about that solution as it 
makes the QGIS project unhandy and confusing for others using it because of the 
extra layers.

Is there a way making QGIS passing SQL-statements generated from current canvas 
extend AND styling rules? Or another way gaining better rendering performance?
If anyone had similar issues or has any idea, what I can do to make QGIS 
passing styling-rule based data selection to provider side, I'm glad to hear!

Best wishes

Benjamin Fünfer-Königstein
S-IP-AN-TG Techn. Geschäftsfelder




__ Information from ESET Mail Security, version of virus signature 
database 13537 (20160524) __

The message was checked by ESET Mail Security.
http://www.eset.com




___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user





__ Information from ESET Mail Security, version of virus signature 
database 13537 (20160524) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] QGIS in production environment

[Bernhard Ströbl]

Hi,

we have been running QGIS together with PostGIS in a municipal GIS 
(city, some 10 inhabitants) since at least 7 years. We run QGIS 
server on the intranet and, together with QGIS WebClient, on the 
internet [1]. We use LTS QGIS 64bit on Win7, servers are on Ubuntu.


We started with some projects and now have about 30 of them (project = 
data model for a specific purpose), the number is increasing every year. 
We do not have commercial support but build what we need ourselves. I 
can highly recommend the PostGIS data source together with QGIS 
(versatility, speed). For ease of data input I created a plugin [2]. I 
do almost all spatial operations (there are not many unfortunately :) on 
PostGIS. We use PyJasper [3] (JasperReports for Python) for any pdf 
output (reports, data sheets, letters), which - admittedly - is a bit 
tricky.


Bottom line: The combinaton does everything we need (if it doesn't we 
can have it added), users are used to QGIS (did not show them any 
alternatives, though :) and - more important - convinced that it is the 
right tool for their purposes (which means the data models implemented 
can house their informational needs). There are not many large-scale 
plots currently. We lack an easy to use web client for non-GIS staff, as 
most people can not handle a full blown QGIS. QGIS WebClient II will 
hopefully close this gap.


Feel free to ask any sppecific questions.

Bernhard

[1] http://www.jena.de/kartenportal
[2] https://github.com/bstroebl/DataDrivenInputMask
[3] https://github.com/bstroebl/pyJasper

Am 20.05.2016 um 16:14 schrieb Tyler Veinot:

Through various product demos and meetings I am coming to realize that much
of what we want to do could be done using open source products like; QGIS,
PostgreSQL, Leaflet or Map Server, and a Web API. So I am wondering if
anyone is doing something similar. I know this isn't a specific QGIS
question so I hope you will forgive me, but if anyone one has any
suggestions on products and/or open source packages that leverage open
source GIS and Databases to provide a GIS centric platform to support
municipal operations asset management and maintenance.
Thanks for the thoughts;
Tyler






__ Information from ESET Mail Security, version of virus signature 
database 13529 (20160522) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] QGIS Server - Export to PDF graphics

[Bernhard Ströbl]

just an idea: Do not load the images from the file system but from a web 
server via URL (can be the same server QGIS server is running on)


Bernhard

Am 29.04.2016 um 09:49 schrieb burghardt.scho...@stadt.wolfsburg.de:

Hi all,

my System: Ubuntu 14.04, qgis-server 2.14.1

I've created a print template in my QGIS-Project. The legend contains several 
image files (logos etc.). An export to PDF from the Composer is working 
properly. But if I use the print function in QGIS Server using the QGIS 
WebClient or the OL3 Mobile Viewer, the image files are only sometimes exported 
to PDF. The other contents of the map / legend are shown reliably. I have 
already tried several graphic formats (png, jpg etc.). Am I doing something 
wrong? Perhaps someone can give me a hint. Thanks in advance

Regards
Burghardt

***

Stadt Wolfsburg
Geschäftsbereich IT - 15-3 GIS
Rathaus E, Zi. E403, Porschestraße 47A, D-38440 Wolfsburg
Tel +49 5361 28-2531
Fax +49 5361 28-1765
mailto:burghardt.scho...@stadt.wolfsburg.de



___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user





__ Information from ESET Mail Security, version of virus signature 
database 13410 (20160429) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Project file data loss

[Bernhard Ströbl]

Hi Pierre-Marie,

what do you mean by "update virtual layers"? On the other hand I 
definitely did not modify the data structure (e.g. add or rename fields) 
of the layers involved in the virtual layers.


Bernhard

Am 26.04.2016 um 22:48 schrieb Pierre-Marie Le Dantec:

Hi,
I encoutered the same issue (only groups, definition layers still visible
in text editor). I suspected virtual layers too.
It seems it occurs when I modified data structure in virtual layers data
sources, without updating the virtual layers before closing the project.

When I take care to update frequently virtual layers, the issue seems to
don't occur.

Pierma

2016-04-26 21:40 GMT+11:00 johnrobot :


I added a comment about virtual layers in the ticket, since we now have at
least two cases with this setup.





__ Information from ESET Mail Security, version of virus signature 
database 13398 (20160427) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Project file data loss

[Bernhard Ströbl]

I had the virtual layers in suspicion, that's why I pointed it out. I 
had a rule based style for them using joined fields from other layers 
(joined in the definition of the virtual layer not in QGIS via layer 
join). The project opened a couple of times all right, though.


Bernhard

Am 26.04.2016 um 11:44 schrieb johnrobot:

This seems very much like my case. The layers are still defined when opening
the file in a text editor, but QGIS only opens the layer group (in the layer
list, not the map). My project also contained virtual layers. Could that be
the problem?



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/Project-file-data-loss-tp5262903p5262927.html
Sent from the Quantum GIS - User mailing list archive at Nabble.com.
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user



--
Bernhard Ströbl
Anwendungsbetreuer GIS

Kommunale Immobilien Jena
Am Anger 26
07743 Jena

Tel.: 03641 49- 5190
E-Mail: bernhard.stro...@jena.de
Internet: www.kij.de


Kommunale Immobilien Jena
Eigenbetrieb der Stadt Jena
Werkleiter: Karl-Hermann Kliewe


__ Information from ESET Mail Security, version of virus signature 
database 13393 (20160426) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Project file data loss

[Bernhard Ströbl]

Strange thing,

I just lost some work because the project file still loads but does only 
contain the layer groups. All layers are "gone", however when checking 
the qgs file in the editor, the layers are still defined. I saved to a 
local file within less than a second.

QGIS 2.14.1 on Ubuntu 64 bit

I opened the project in QGIS 2.8.7 on Win7 (64 bit) and it opens fine 
except for the virtual layers (a feature introduced after 2.8)

Layers are WMS and PostGIS.

Bernhard

Am 26.04.2016 um 10:59 schrieb johnrobot:

OK. In my case, I do save to a network drive, but the saving is quick (a few
seconds). I did not kill the save process and no error is reported when
opening the project file.



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/Project-file-data-loss-tp5262903p5262921.html
Sent from the Quantum GIS - User mailing list archive at Nabble.com.
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user



--
Bernhard Ströbl
Anwendungsbetreuer GIS

Kommunale Immobilien Jena
Am Anger 26
07743 Jena

Tel.: 03641 49- 5190
E-Mail: bernhard.stro...@jena.de
Internet: www.kij.de


Kommunale Immobilien Jena
Eigenbetrieb der Stadt Jena
Werkleiter: Karl-Hermann Kliewe


__ Information from ESET Mail Security, version of virus signature 
database 13393 (20160426) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Preserving joined fields in Processing outputs

[Bernhard Ströbl]

Just my two cents:
+1 to leave it as it is
reasoning: I would always expect the current behaviour; a virtual field 
is - well - virtual, I can redo it after processing (BTW it would be 
good if it was savable in a qml file) and I can join to the result, too. 
No need to carry unnecessary fields from joined layers along.
Plus, as stated in the discussion, GRASS/SAGA/ogr won't keep these 
fields anyway, to implement it for QGIS algs only would result in 
inconsistent outputs


Bernhard

Am 11.04.2016 um 11:46 schrieb Alexander Bruy:

Hi all,

and sorry for cross-posting.

When cleaning Processing bug queue I found issue [0] about preserving
joined fields in Procesing outputs. Before implementing this I want to hear
opinions, does it makes sense at all or better to leave things as is: output
layer contains only provider (non-joined, not virtual) fields from input layer?

Thanks

[0] https://hub.qgis.org/issues/12893



--


__ Information from ESET Mail Security, version of virus signature 
database 13315 (20160411) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Reading CAD documents in QGIS

[Bernhard Ströbl]

Hi,

just for your information: Bentley and AutoCAD exchanged their libs a 
couple of years ago, so Bentley products read dwg/dxf with the native 
AutoCAD lib (all AFAIK). Therefore there should be no need for dgn (V8) 
support. AFAIK there exists only proprietary libs (Bentley) for 
reading/wirting dgn (V8).


Bernhard

Am 15.03.2016 um 09:13 schrieb Neumann, Andreas:

Hi John,

Whatever DXF/DWG version libdxfrw supports - I assume that
https://sourceforge.net/projects/libdxfrw/ is the more up-to-date
information.

It is important to note that

- currently we are not targetting DGN (as originally planned), since
libdxfrw only supports DXF/DWG and not DGN. Teigha supports both.

- It will be an open effort and not every feature/property of the DWG
format will be supported. If necessary and successfull in its first
iteration, there could be a second round of improvements, if there is
interest.

Andreas

On 2016-03-15 08:51, johnrobot wrote:


Ah, good to know. I will spread the word and see if any funds are available.

Do you know which DWG versions we will support?
https://sourceforge.net/projects/libdxfrw/ mentions up to 2015, but
https://sourceforge.net/p/libdxfrw/home/Home/ says up to 2003.

--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/Reading-CAD-documents-in-QGIS-tp5256360p5256367.html
Sent from the Quantum GIS - User mailing list archive at Nabble.com.
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user





__ Information from ESET Mail Security, version of virus signature 
database 13179 (20160315) __

The message was checked by ESET Mail Security.
http://www.eset.com



Hi John,

Whatever DXF/DWG version libdxfrw supports - I assume that
https://sourceforge.net/projects/libdxfrw/ is the more up-to-date
information.

It is important to note that

- currently we are not targetting DGN (as originally planned), since
libdxfrw only supports DXF/DWG and not DGN. Teigha supports both.

- It will be an open effort and not every feature/property of the DWG
format will be supported. If necessary and successfull in its first
iteration, there could be a second round of improvements, if there is
interest.

Andreas

On 2016-03-15 08:51, johnrobot wrote:


Ah, good to know. I will spread the word and see if any funds are
available.

Do you know which DWG versions we will support?
https://sourceforge.net/projects/libdxfrw/ mentions up to 2015, but
https://sourceforge.net/p/libdxfrw/home/Home/ says up to 2003.



--
View this message in context:
http://osgeo-org.1560.x6.nabble.com/Reading-CAD-documents-in-QGIS-tp5256360p5256367.html
Sent from the Quantum GIS - User mailing list archive at Nabble.com.
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org 
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user




__ Information from ESET Mail Security, version of virus
signature database 13179 (20160315) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user





__ Information from ESET Mail Security, version of virus signature 
database 13179 (20160315) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] An issue splitting a shape

[Bernhard Ströbl]

Hi Andrea,

I have seen that the geometry checker marks pseudo nodes (no idea why). 
anyways I can use the split _features_ tool (the left hand scissors tool 
in the advanced digitizing toolbar) on the layer.

This is QGIS 2.14.0 on Ubuntu 14.04 64 bit

Bernhard

Am 03.03.2016 um 19:12 schrieb Andrea Peri:

Hi,
I say there are duplicate node because say me the validate geometry of qgis.
I try to splite using the commando of qgis named "split" available in the
toolbar.
Thx,
A.
Il 03 mar 2016 1:24 PM, "Bernhard Ströbl" <bernhard.stro...@jena.de> ha
scritto:


Hi Andrea,

IMHO duplicate nodes are a geometry error and I would generally not expect
any tool to flawlessly work with such geometries. However I do not see any
duplicate nodes in the attached shape. Where are they supposed to be and
which split tool are you using, the scissors?

Bernhard

Am 03.03.2016 um 12:31 schrieb Andrea Peri:


Hi,
I have an issue when try to split a specific linear shape geometry
when it has some duplicate nodes.

I guess it should not be a problem tosplit a geometry when there is
some duplicate nodes.

Ad reference, I have success to try to split the same geometry using the
old
esri-arcview 3.x.

So perhaps this is an issue for QGIS ?

Before to issue a ticket I like to know any thought.

The impossibility to split a geometry when there is some duplicate
nodes is really an issue for qgis , or is confirmed that qggis should
only split geometry that are not any duplicate vertex ?

I attach the zip with the geometry sample.

Regards,



___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user





__ Information from ESET Mail Security, version of virus signature
database 13121 (20160303) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user




__ Information from ESET Mail Security, version of virus signature 
database 13122 (20160303) __

The message was checked by ESET Mail Security.
http://www.eset.com



Hi,
I say there are duplicate node because say me the validate geometry of qgis.
I try to splite using the commando of qgis named "split" available in
the toolbar.
Thx,
A.

Il 03 mar 2016 1:24 PM, "Bernhard Ströbl" <bernhard.stro...@jena.de
<mailto:bernhard.stro...@jena.de>> ha scritto:

Hi Andrea,

IMHO duplicate nodes are a geometry error and I would generally not
expect any tool to flawlessly work with such geometries. However I
do not see any duplicate nodes in the attached shape. Where are they
supposed to be and which split tool are you using, the scissors?

Bernhard

Am 03.03.2016 um 12:31 schrieb Andrea Peri:

Hi,
I have an issue when try to split a specific linear shape geometry
when it has some duplicate nodes.

I guess it should not be a problem tosplit a geometry when there is
some duplicate nodes.

Ad reference, I have success to try to split the same geometry
using the old
esri-arcview 3.x.

So perhaps this is an issue for QGIS ?

Before to issue a ticket I like to know any thought.

The impossibility to split a geometry when there is some duplicate
nodes is really an issue for qgis , or is confirmed that qggis
should
only split geometry that are not any duplicate vertex ?

I attach the zip with the geometry sample.

Regards,



___
Qgis-user mailing list
Qgis-user@lists.osgeo.org <mailto:Qgis-user@lists.osgeo.org>
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user




__ Information from ESET Mail Security, version of virus
signature database 13121 (20160303) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org <mailto:Qgis-user@lists.osgeo.org>
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user




__ Information from ESET Mail Security, version of virus signature 
database 13125 (20160304) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] An issue splitting a shape

[Bernhard Ströbl]

Hi Andrea,

IMHO duplicate nodes are a geometry error and I would generally not 
expect any tool to flawlessly work with such geometries. However I do 
not see any duplicate nodes in the attached shape. Where are they 
supposed to be and which split tool are you using, the scissors?


Bernhard

Am 03.03.2016 um 12:31 schrieb Andrea Peri:

Hi,
I have an issue when try to split a specific linear shape geometry
when it has some duplicate nodes.

I guess it should not be a problem tosplit a geometry when there is
some duplicate nodes.

Ad reference, I have success to try to split the same geometry using the old
esri-arcview 3.x.

So perhaps this is an issue for QGIS ?

Before to issue a ticket I like to know any thought.

The impossibility to split a geometry when there is some duplicate
nodes is really an issue for qgis , or is confirmed that qggis should
only split geometry that are not any duplicate vertex ?

I attach the zip with the geometry sample.

Regards,



___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user





__ Information from ESET Mail Security, version of virus signature 
database 13121 (20160303) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Relations capabilities

[Bernhard Ströbl]

Hi Brent,

not sure if I uttered that before, so (if I did) my apologies for 
repeating myself. If you are entirely on PostgreSQL you may try my 
Plugin DataDrivenInputMask [1]. If you have properly defined foreign 
keys you can

1) see the species caught in one station in a list [2]
2) search for (and thus select) stations where certain species have been 
caught

I assume
a) a station table with pk field station_pk
b) a species table with pk field species_pk
c) a relation table with a combined pk = station_pk + species_pk, where 
station_pk is a fk on station.station_pk and species_pk is a fk on 
species.species_pk


Regarding symbology you may filter your station layer like that:
station_pk IN (SELECT station_pk FROM relation_table where species_pk = 
some_value)
You would need to load your station layer several times and filter each 
of them on one (or several) species for symbolization.


Another way would be to use PostgreSQL's crosstab extension and create a 
view for symbolization only which would list all the species in one 
dataset like that

station_pk, geom, station_name, species_1, species_2,...,species_n
You could then classify on the combinations

Bernhard

[1] http://plugins.qgis.org/plugins/DataDrivenInputMask/
[2] 
https://github.com/bstroebl/DataDrivenInputMask/wiki/Widgets-for-n-2-m-Relations


Am 24.02.2016 um 02:16 schrieb Brent Wood:

Firstly, thanks to those who already helped me with this.
I have established a relation between non-spatial catch records in a postgis 
table and a table of station information (linked via foreign key).
If I click on a station with the info tool, I can see the various catch records 
from that station - so the relation is working.
But that seems to be it. If I filter on the species in the catch, that only 
applies to the catch data showing up when I select a station - it does NOT hide 
stations where that species was not caught. I cannot change symbology based on 
a relation, I cannot select features based on a relation - all I can do is view 
the records - and with 70 fields in the station layer, the catch records are 
just a small window at the bottom of the form.
It seems that to be useful I need to create the view or table in the database & 
access this with QGIS - whioch has issues for users without create access in the 
database - which is most of them.
Is work on this area (relations) of QGIS actively ongoing, or should I look for 
non-QGIS approaches?
Thanks,
   Brent Wood




__ Information from ESET Mail Security, version of virus signature 
database 13076 (20160223) __

The message was checked by ESET Mail Security.
http://www.eset.com



Firstly, thanks to those who already helped me with this.

I have established a relation between non-spatial catch records in a
postgis table and a table of station information (linked via foreign key).

If I click on a station with the info tool, I can see the various catch
records from that station - so the relation is working.

But that seems to be it. If I filter on the species in the catch, that
only applies to the catch data showing up when I select a station - it
does NOT hide stations where that species was not caught. I cannot
change symbology based on a relation, I cannot select features based on
a relation - all I can do is view the records - and with 70 fields in
the station layer, the catch records are just a small window at the
bottom of the form.

It seems that to be useful I need to create the view or table in the
database & access this with QGIS - whioch has issues for users without
create access in the database - which is most of them.

Is work on this area (relations) of QGIS actively ongoing, or should I
look for non-QGIS approaches?

Thanks,

   Brent Wood




__ Information from ESET Mail Security, version of virus
signature database 13076 (20160223) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user





__ Information from ESET Mail Security, version of virus signature 
database 13077 (20160224) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Repairing Topology Errors

[Bernhard Ströbl]

Hi,

when looking at topology errors I can imagine three types
1) borders are not identical, i.e. you missed one vertex during digitizing
2) overlaps
3) gaps

ad 1) in my experience it is easy to miss a vertex when digitizing along 
an existing edge, the auto-trace plugin may help in this respect and 
also "avoid intersections" (although you seem to have had problems with 
it). Snapping must be activated, of course. You cannot snap without it 
because you never hit the exact same point twice.
So for your edit layer you should snap to vertex with a reasonable 
snapping distance and "avoid intersections". Thus you should be set to 
not miss any vertices.

fix: only manually AFAIK
2) have "avoid intersections" active
fix: I use GRASS with its topological data model to identify all 
averlaps and use Processing's "eliminate sliver polygons" to get rid of them

3) no way to avoid them because IMHO they could be intended
fix: same as 2)

Bernhard


Am 08.02.2016 um 20:26 schrieb Springfield Harrison:

Hello Group,

I have been manually creating a few simple polygons, always intending to
have no gaps, slivers or overlaps.  To do this I use snapping and
occasionally the Autotrace feature.

However, when I run the topology checker, it often flags a variety of
errors although I am careful to create polygons by only snapping to
existing vertices of adjacent polygons.  It does a great job of finding
the errors, but I can find no instructions on methodology for repairing
them.

Any suggesting on repairing topology errors easily?

Thank you, Cheers . . . . . . . . Spring Harrison



At 03-02-2016 07:51 Wednesday, Carlos Cerdán wrote:

Hi Springfield:

I've had similar trouble some time ago, as a QGIS beginner user.
Previous given advices are for not too-beginner users, but I think my
experience can be useful for the list (or even for you?):

That time my error was my Snapping options: I had selected two or
three layers and it was selected the "avoid intersections" option,
then, when I added new digitized polygons, they were splitted or
deleted (as you tell) because new polygons were intersecting marked
layers in snapping options. It fixed when new digitizing shape was the
one marked (of course to avoid intersections between her elements) .

Yes it was something simple, my foul. Is it not same trouble?. If so,
Check it in "Configuration --> Snapping options --> Change the
Self-assembling mode to "advanced" and be sure that "avoid
intersections" is marked in your target layer only.

Cheers,

Carlos Cerdán

2016-02-02 20:57 GMT-05:00 Springfield Harrison  >:

Hello Group,

        Am using QGIS 2.10.1 and have done so without
significant problems for many months. I am attempting to create
simple polygons in a shapefile by direct vertex entry or copying
polygons from another shapefile layer and pasting them into the
active layer.

        In almost every case, these features disappear.Â
There is an entity entry in the attribute table but there are no
polygons created. In one case a polygon was created but it was
not the shape that I digitized; no more polygons could be created
although the process for doing so appears to be working. No error
messages were created. The CRS for the project and the shapefile
are the same.

        The shapefile can be opened in another GIS but has
no content.
       Â
        Here are some product details: QGIS versionÂ
2.10.1-Pisa QGIS code revision d20c5b7


        Thanks very much for any help you can render,
Cheers . . . . . . . . Springfield Harrison

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org 
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user


___ Qgis-user mailing list
Qgis-user@lists.osgeo.org List info:
http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe:
http://lists.osgeo.org/mailman/listinfo/qgis-user



__ Information from ESET Mail Security, version of virus
signature database 12996 (20160208) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user





__ Information from ESET Mail Security, version of virus signature 
database 12999 (20160209) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: 

Re: [Qgis-user] [QGis 2.10]Error while saving shape file

[Bernhard Ströbl]

hi Pierre,

if modifying a vertex takes that long I suggest you unload all(!) 
plugins, some are known to slow down QGIS. Try if that enhances speed. 
If yes reload you plugins one after another and see if you can identify 
the one causing the trouble.


Bernhard

Am 08.02.2016 um 14:34 schrieb Pierre Muckensturm:

Hi,

I use a QGis 2.10 version,  X64 on Windows installed with Osgeo4W.

I'll try to explain the bug.

I work on a map, with a shape file of polygons. They are not really
complex, nor numerous (25). I got   id,DOSSIER,NOM_OPERAT,
PRIORITE,COMMENTA,DATE_MAJ,SOURCE,LIBELLE_X, LIBELLE_Y
fields and SURF_HA which is a virtual field.

Friday, it took me 5 min to save the file each time I modify a vertex.

Today, I update my id field with the expression "$id". Then, my shape file
looks like a totally mess (look at the imgur album :
http://imgur.com/a/noSM2). The LIBELLE_X, LIBELLE_Y fields have disappeard,
the DOSSIER field which used to be null is now partially fulled, the
NOM_OPERAT are truncated, fulled in a completelly non-sense manner. As for
PRIORITE, DATE_MAJ.

Conclusion, 2 days of work in a trash. I'm quite pissed off, according with
the fact that I'm trying to convince my superior we shall use QGis.

So, what happened ? How could this happen ? Sorry but I don't have the
genuine files, and the data are quite sensitive.






__ Information from ESET Mail Security, version of virus signature 
database 12995 (20160208) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Including Images in Print Composer Templates

[Bernhard Ströbl]

Hi,

this is not an answer to your question but what I do is to load images 
with an URL pointing to one of our internal web servers. This works 
perfectly in templates being loaded on different machines with different 
OS, too.


Bernhard

Am 27.01.2016 um 00:25 schrieb David A. Riggs:

Hi all,

I'm trying to create a library of themed print composer templates for my
agency, and each needs to include an .SVG logo image. I would like for the
image file to A) either be included within the template file itself, or B)
referenced from a path relative to the template file.

It seems that when saving as a template (QGIS 2.8.3 on Win7), the .QPT file
references the image file as a relative path, but apparently relative to
the project rather than the template. Since I'm trying to distribute these
templates to other users, and I can't predict their filesystem layout, I'm
trying to figure out a way to reference the image relative to the template
itself.


I have tried editing the .QPT source in several ways to make this work:

1.  

Simply the image filename, with the image in the same directory as the
template. Fails to load with a red X.

2.  

Relative path style "current directory" with the image in the same
directory as template. Fails to load because QGIS resolves the path to the
PROJECT dir rather than the template dir.

3. Absolute path to the .SVG image. This works, but I don't know nor want
to dictate where a user places their templates.

4. Relative path to project. This works, and forcing users to store
templates in some fixed location relative to all their projects is a
solution, though not one I want to force on them.


Is there a way to refer to an image file relative to the template itself,
OR a way to include the contents of an .SVG image inside the .QPT template?


Thanks!

- DR



Hi all,

I'm trying to create a library of themed print composer templates for my
agency, and each needs to include an .SVG logo image. I would like for
the image file to A) either be included within the template file itself,
or B) referenced from a path relative to the template file.

It seems that when saving as a template (QGIS 2.8.3 on Win7), the .QPT
file references the image file as a relative path, but apparently
relative to the project rather than the template. Since I'm trying to
distribute these templates to other users, and I can't predict their
filesystem layout, I'm trying to figure out a way to reference the image
relative to the template itself.


I have tried editing the .QPT source in several ways to make this work:

1.  

Simply the image filename, with the image in the same directory as the
template. Fails to load with a red X.

2.  

Relative path style "current directory" with the image in the same
directory as template. Fails to load because QGIS resolves the path to
the PROJECT dir rather than the template dir.

3. Absolute path to the .SVG image. This works, but I don't know nor
want to dictate where a user places their templates.

4. Relative path to project. This works, and forcing users to store
templates in some fixed location relative to all their projects is a
solution, though not one I want to force on them.


Is there a way to refer to an image file relative to the template
itself, OR a way to include the contents of an .SVG image inside the
.QPT template?


Thanks!

- DR

--
David A. Riggs >



___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user





__ Information from ESET Mail Security, version of virus signature 
database 12938 (20160128) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Swap atributes

[Bernhard Ströbl]

Hi Christoph,

the latest version of the DigitizingTools extension [1] contains a 
function to exchange the geometry between two selected features in the 
active edit layer.


Bernhard

[1] http://plugins.qgis.org/plugins/DigitizingTools/

Am 14.01.2016 um 11:00 schrieb Christoph Schumacher Planungsbüro Schumacher:

Hello group!

Is there an easy way to swap attributes from two objects on one layer? I
didnt found a easy tool to do that.


Regards,

Christoph




___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user





__ Information from ESET Mail Security, version of virus signature 
database 12867 (20160114) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Styles and PostgreSQL

[Bernhard Ströbl]

Hi,

the relation is public.layer_styles. The problem is the xml fields. I 
once noted for myself to

SET XML OPTION DOCUMENT;
prior to importing the dump. Didn't do it for a while so I am not sure 
if it works.
Another option is to dump layer_styles as plain SQL and then import it 
into the other machine.


Bernhard

Am 14.01.2016 um 19:30 schrieb Roberto Jesús Dip:

Hi,

I use QGIS 2.12.2 and PostgreSQL 9.5 + PostGIS 2.1.8 (Windows x64).

I´ve saved styles using the option 'Save in database (postgres)'.

It works fine when I add a table to another project with 'Add to
canvas', it brings the style associated with the table.

But when I backup a schema and restore it in another machine I lose the
styles.

Where are stored the styles? Can I move a schema or a database to
another machine without losing the styles?

Thanks a lot for your answer!

Greetings,
Roberto.




___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user





__ Information from ESET Mail Security, version of virus signature 
database 12872 (20160115) __

The message was checked by ESET Mail Security.
http://www.eset.com


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user