Re: [QGIS-it-user] Selezione tramite un'espressione - Distance

[Totò]

Ludovico wrote
> Il risultato è corretto, è  un numero ma in realtà la selezione avviene ma
> su
> i due punti piu6 distante, mentre il più  vicino non viene selezionato 

Ho appena fatto una prova su QGIS 3.4, a me seleziona tutti


 



-
https://pigrecoinfinito.wordpress.com/
--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-Italian-User-f5250612.html
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user

Re: [QGIS-it-user] Selezione tramite un'espressione - Distance

[Ludovico]

Con la versione 3.2 questo è il risultato... è un comportamento strano

 



-
Dott. For. Ludovico Frate, PhD

--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-Italian-User-f5250612.html
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user

Re: [Qgis-user] geopackage spatial query

[Mithoefer]

Dear all,

thanks a lot for all your replies. They were all very helpful to me!


Am 29.10.18 um 20:47 schrieb Bo Victor Thomsen:

Hi Klaus -

Even though the GeoPackage format is using a spatialite database as the 
foundation, the internal format of the geopackage geometry type differs 
from the spatialite type. So yon can't directly use spatialite geometry 
based function with geopackage geometries.


However you can "wrap" every use of GeoPackage geometries in a converter 
function: *CastAutomagic(geom)*, which converts a GeoPackage geometry to 
a Spatialite geometry.


So a call to: /st_area (geom)/ becomes /st_area(*CastAutomagic(*geom*)*)/

(No, It's not nice and it certainly not effective use of computer 
resources, however it works.)


There is a thread about the why's and why-not's for this subject in the 
QGIS-user list around september 13 , 2018


Regards

Bo Victor Thomsen
LIFA Landinspektører A/S,
Denmark




Den 29/10/2018 kl. 14.35 skrev Mithoefer:

Dear List,

I have a geopackage database and tried to use a spatial sql function 
(st_area) using the db manager in qgis 3.4  --> select st_area(geom) 
from polygon_filename. The function is available, but the result is 
Null. What is the problem?


Thanks a lot

Kind regards

Klaus
___
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-it-user] Selezione tramite un'espressione - Distance

[Totò]

Ludovico wrote
> Con la versione 3.2 questo è il risultato... è un comportamento strano
> 
> http://osgeo-org.1560.x6.nabble.com/file/t379770/2018-10-30_08-49-53.png;
>  

Ciao Ludovico,
potresti condividere i due shapefile??





-
https://pigrecoinfinito.wordpress.com/
--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-Italian-User-f5250612.html
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user

Re: [QGIS-it-user] Selezione tramite un'espressione - Distance

[Ludovico]

Ciao, erano layer temporanei (ho fatto due prove, stesso risultato)



-
Dott. For. Ludovico Frate, PhD

--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-Italian-User-f5250612.html
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user

[QGIS-it-user] gestione visualizzazione testi

[Roberta Ciccarelli]

 Buongiorno
ho il seguente problema: devo nascondere alcune parti di un disegno con una
maschera costituita da uno shp poligonale rettangolare bianco; il problema
consiste nel fatto che questo shp nonostante sia nella posizione più alta
nell'elenco layer non mi copre uno shp sottostante di testi nè tantomeno le
etichette di un altro shp poligonale del quale però copre le geometrie.
Qualcuno saprebbe indicarmi come fare affinchè lo shp poligonale riesca a
nascondere tutto, testi compresi? Grazie anticipatamente a chi vorrà
aiutarmi... ieri ho perso due ore di lavoro e stamattina altre due senza
arrivare a una soluzione
grazie mille
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user

Re: [QGIS-it-user] gestione visualizzazione testi

[Alessandro Sarretta]

Ciao,

con una ricerca veloce ho trovato questo argomento discusso e, sembra, 
risolto qui: 
https://gis.stackexchange.com/questions/128195/how-to-mask-labels-in-qgis-using-an-inverted-polygon


Ale

On 30/10/18 11:32, Roberta Ciccarelli wrote:

Buongiorno
ho il seguente problema: devo nascondere alcune parti di un disegno 
con una maschera costituita da uno shp poligonale rettangolare bianco; 
il problema consiste nel fatto che questo shp nonostante sia nella 
posizione più alta nell'elenco layer non mi copre uno shp sottostante 
di testi nè tantomeno le etichette di un altro shp poligonale del 
quale però copre le geometrie. Qualcuno saprebbe indicarmi come fare 
affinchè lo shp poligonale riesca a nascondere tutto, testi compresi? 
Grazie anticipatamente a chi vorrà aiutarmi... ieri ho perso due ore 
di lavoro e stamattina altre due senza arrivare a una soluzione

grazie mille

___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user

--
--

Alessandro Sarretta

skype/twitter: alesarrett
Web: ilsarrett.wordpress.com 

Research information:

 * Google scholar profile
   
 * ORCID 
 * Research Gate 
 * Impactstory 

___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user

[Qgis-user] Georeferencing for Avenza

[Gmail - Peter]

Dear List Subscribers

 

Are there any updates to the threads of 2015/2016 regarding QGIS producing
georeferenced tifs or pdfs for loading into Avenza?  I am a newbie to QGIS
(Madeira 3.4) and while I have succeeded in producing a correctly
georeferenced tif file via Raster>Conversion>translate, this only works on
one layer.  The three other methods I can see to export or print a pdf or
tif do not produce a correctly georeferenced file in Lats/Longs using
GDA94Z50.  The file according to Avenza is ~54deg and 89deg south and west
of where it should be.

 

I am starting with a non-georeferenced raster which I put through the
georeferencer with 6 GCPs and several experiments of transformation types,
settling on polynomial 1.  The process produces a tif, pdf, and loads back
into the main window.  The main window raster is georeferenced perfectly, so
wouldn't you think the other output would be too?

 

The correct method should be to use Print Layout, produce a map with all the
layers from the main window, and export as an image or pdf.  This might work
if the map units were real world and not mm.

The fall back should be Project>Import/Export>Export Map to Image or pdf
from the main window, but that doesn't work either.

 

I hope the solution is obvious and I have overlooked something simple.  Any
guidance appreciated, I like to take my maps out into the field.

 

Regards

Peter

___
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] Georeferencing for Avenza

[Kirk Schmidt]

Hi Peter:

Generate the map you require in the field using the print composer.  In 
the items window on the right hand side of the standard composer window, 
select the Composition Tab and check the save world file option in the 
export settings.


Save the pdf of the map and load into Avenza.


Kirk


On 10/30/2018 7:39 AM, Gmail - Peter wrote:


Dear List Subscribers

Are there any updates to the threads of 2015/2016 regarding QGIS 
producing georeferenced tifs or pdfs for loading into Avenza?  I am a 
newbie to QGIS (Madeira 3.4) and while I have succeeded in producing a 
correctly georeferenced tif file via Raster>Conversion>translate, this 
only works on one layer.  The three other methods I can see to export 
or print a pdf or tif do not produce a correctly georeferenced file in 
Lats/Longs using GDA94Z50.  The file according to Avenza is ~54deg and 
89deg south and west of where it should be.


I am starting with a non-georeferenced raster which I put through the 
georeferencer with 6 GCPs and several experiments of transformation 
types, settling on polynomial 1.  The process produces a tif, pdf, and 
loads back into the main window.  The main window raster is 
georeferenced perfectly, so wouldn’t you think the other output would 
be too?


The correct method should be to use Print Layout, produce a map with 
all the layers from the main window, and export as an image or pdf.  
This might work if the map units were real world and not mm.


The fall back should be Project>Import/Export>Export Map to Image or 
pdf from the main window, but that doesn’t work either.


I hope the solution is obvious and I have overlooked something 
simple.  Any guidance appreciated, I like to take my maps out into the 
field.


Regards

Peter



___
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


--
Kirk Schmidt, MScF, BScF, RPF
General Manager
Nortek Resource Solutions Inc.
RR # 1
Thorburn, NS
B0K 1W0
Tel (902) 922.3607
Email: k...@nortekresources.com
Web: www.nortekresources.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-it-user] QGIS - Esportazione file

[Studio Multiservice s.s.]

Amedeo e Martina,

grazie!!

Il grigio perimetrale (nominato "velina") che fa effetto vedo-non vedo
sulla CTR raster (che non è un ritaglio ma sono proprio le sezioni
ufficiali che giacciono sotto al catastale vettoriale comunale) è il layer
poligonale dei limiti amministrativi dei comuni contermini, senza
visualizzazione dei perimetri, colore grigio e con riempimento semplice
"compatto 4" di QGIS 2.18.18 su WIN7 64bit.
Di questo layer, il riempimento del comune che interessa è vuoto.
Lo stesso layer è "riciclato" sotto il catasto ma con riempimento pieno e
colore bianco per il solo comune di interesse. Ciò al fine di nascondere la
CTR in corrispondenza del catastale.

Pensavo, come suggerito da Amedeo, di proporre due A1 molto più
maneggevoli

Il difetto è che tutti gli altri elementi in legenda non saranno
"ingrigiti" ma dello stesso colore acceso che assumono quando sono interni
al confine comunale.

E la cosa NON PIACE...come non piace che il comune "galleggi" nell'A0
(cioè, tutto intorno il nulla).

Ma non vorrei neppure schiaffarli sotto la CTR ché mi scompaiono alcune
porzioni interessanti.

Vi dico se risolvo con gli A1, nel senso riesco a stamparli. E poi a farli
ingoiare...

Grazie ancora per l'interessamento.

Alberto



> -- Forwarded message --
> From: marti_ 
> To: qgis-it-user@lists.osgeo.org
> Date: Mon, 29 Oct 2018 12:39:34 -0700 (MST)
> Subject: Re: [QGIS-it-user] QGIS - Esportazione file
> Nelle due tavole che non ti si stampano c'è un effetto "pixelato" nella
> parte
> fuori perimetrazione retinate di grigio che invece non c'è nelle altre due.
> Provo a fare un'ipotesi: avendo zoomato molto l'immagine sembra tu abbia lì
> una ctr raster ritagliata (cioè da cui hai ritagliato le aree del piano)
> messa sopra e a cui hai dato la trasparenza, trasparenza che a quanto pare
> viene gestita bene se esporti in jpeg, ma che nella trasformazione in pdf
> crea problemi.
> Le soluzione che mi vengono in mente sono:
> 1) Rimetti la ctr sotto togliendole la trasparenza e prova a o usare la
> fusione moltiplica sul retino come dice Amedeo, o dare la trasparenza al
> colore del retino [1];
> 2) Oppure utilizza la stesso metodo usato nelle due tavole che ti si
> stampano :)
> Martina
> [1] 
> Sent from:
> http://osgeo-org.1560.x6.nabble.com/QGIS-Italian-User-f5250612.html
>
>
> -- Forwarded message --
> From: marti_ 
> To: qgis-it-user@lists.osgeo.org
> Date: Mon, 29 Oct 2018 13:19:02 -0700 (MST)
> Subject: Re: [QGIS-it-user] QGIS - Esportazione file
> Scusa ho scordato un altro possibile metodo per il grigio fuori perimetro,
> non sperimentato con QGIS a stampa  e che utilizzavo con Autocad per
> ottenere l'effetto di trasparenza:
> anziché un retino pieno, un righettato molto fitto e con pennino
> sottilissimo (con cad usavo uno 0,01), non so come renda al di sotto dei
> 200
> ppi, però esportato in pdf come vettoriale forse funziona
> Martina
> https://lists.osgeo.org/mailman/listinfo/qgis-it-user
>
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user

Re: [Qgis-user] Snapping points and lines in 3D

[Régis Haubourg]

Hi, It's not by chance, we have been working a lot to try to make the
digitizing maptools catch with the 3D API for geometries, because before
2.18, it was just destroying Z and M values for all operations.
I think some use cases are still missing probably, and some are not easy to
solve by one default behavior, because choosing if you want to snap Z value
or not should be a user choice.
We have been discussing a lot about going towards some interactive snapping
widget to be able to choose which feature to grab, which to snap to, use Z
or not, use a Z snapping tolerance or not. It's a big topic!
Best regards
Régis

Le mar. 30 oct. 2018 à 15:29, Saber Razmjooei <
saber.razmjo...@lutraconsulting.co.uk> a écrit :

> Hi Morten,
>
> This is probably by chance that the line works! Have you tried to move the
> point using the node tool?
>
> Proper 3D digitizing from within the 3D map is in our to-do list for
> future, but if you'd be interested in sponsoring the feature, feel free to
> contact us.
>
> Regards
> Saber
>
> On Tue, 30 Oct 2018 at 08:08, Morten Storm 
> wrote:
>
>> Hi,
>>
>>
>>
>> I have a 3D point layer from a GPS device (with x, y AND z coordinates).
>>
>>
>>
>> I want to digitize new features in 3D point and 3D line layers with
>> snapping in all 3 dimensions to these GPS points.
>>
>>
>>
>> This works great for line features - every node gets 3D coordinates when
>> snapped to my GPS points. However point features only get 2D coordinates
>> (zero for z)!? Do I do something wrong - or is this by design?
>>
>>
>>
>> I have tried this in QGIS 2.18.21 and QGIS 3.4.0.
>>
>>
>>
>>
>>
>> Best regards,
>>
>>
>> *Morten Storm*Chefkonsulent
>>
>> [image: logo] 
>>
>> [image: info]
>>
>>
>> ___
>> 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
>
>
>
> --
> Saber Razmjooei
> www.lutraconsulting.co.uk
> +44 (0)7568 129733
> ___
> 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-it-user] gestione visualizzazione testi

[Totò]

Roberta Ciccarelli wrote
> Buongiorno
> ho il seguente problema: devo nascondere alcune parti di un disegno con
> una
> maschera costituita da uno shp poligonale rettangolare bianco; il problema
> consiste nel fatto che questo shp nonostante sia nella posizione più alta
> nell'elenco layer non mi copre uno shp sottostante di testi nè tantomeno
> le
> etichette di un altro shp poligonale del quale però copre le geometrie.
> Qualcuno saprebbe indicarmi come fare affinchè lo shp poligonale riesca a
> nascondere tutto, testi compresi? Grazie anticipatamente a chi vorrà
> aiutarmi... ieri ho perso due ore di lavoro e stamattina altre due senza
> arrivare a una soluzione
> grazie mille

Ciao Roberta. Personalmente evito sempre, quando possibile, di usare plugin.
Intanto ti dico che è possibile nascondere le etichette di layer che sono in
relazione spaziale con altri.
Io uso molto il calcolatore di campi e il costruttore di espressioni, ti
consiglio di guardare #HfcQGIS
http://hfcqgis.opendatasicilia.it/it/latest/
Come fare:
Supponiamo di avere – nell’ordine – due layer: regioni e province istat ed
etichetti le province;
anche se province è il layer che sta sotto, le etichette si vedranno.
Prova:
vai sulle proprietà del layer province, etichette, ultima scheda –
visulaizzazione – opzioni etichette –> mostra etichette: qui devi utilizzare
la sovrascrittura definita dai dati; vai su modifica e incolla questa
espressione:

not aggregate(‘regioni’, ‘count’, ‘pk_uid’, intersects ($geometry,
point_on_surface( geometry(@parent

questa espressione darà sempre 1 e quindi non mostrerà nessuna etichetta del
layer province;
ulteriore prove del nove:
fai un filtro sul layer regioni in modo da visualizzar solo la Sicilia
(“COD_REG” = 19); cosi facendo vedrai le etichetto il tutta italia tranne la
Sicilia.

Questa espressione deve utilizzarla per ogni layer che sta sotto il layer
regioni.

saluti



-
https://pigrecoinfinito.wordpress.com/
--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-Italian-User-f5250612.html
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user

Re: [Qgis-user] Snapping points and lines in 3D

[Saber Razmjooei]

As far as I remember, there was not a specific feature to allow that. For
the editing Z and M, user has to use the node tool to add the value.
I agree, digitizing and snapping to 3D features are not straightforward,
specially when you do it in a 2D plane.

Cheers
Saber

On Tue, 30 Oct 2018 at 15:09, Régis Haubourg 
wrote:

> Hi, It's not by chance, we have been working a lot to try to make the
> digitizing maptools catch with the 3D API for geometries, because before
> 2.18, it was just destroying Z and M values for all operations.
> I think some use cases are still missing probably, and some are not easy
> to solve by one default behavior, because choosing if you want to snap Z
> value or not should be a user choice.
> We have been discussing a lot about going towards some interactive
> snapping widget to be able to choose which feature to grab, which to snap
> to, use Z or not, use a Z snapping tolerance or not. It's a big topic!
> Best regards
> Régis
>
> Le mar. 30 oct. 2018 à 15:29, Saber Razmjooei <
> saber.razmjo...@lutraconsulting.co.uk> a écrit :
>
>> Hi Morten,
>>
>> This is probably by chance that the line works! Have you tried to move
>> the point using the node tool?
>>
>> Proper 3D digitizing from within the 3D map is in our to-do list for
>> future, but if you'd be interested in sponsoring the feature, feel free to
>> contact us.
>>
>> Regards
>> Saber
>>
>> On Tue, 30 Oct 2018 at 08:08, Morten Storm 
>> wrote:
>>
>>> Hi,
>>>
>>>
>>>
>>> I have a 3D point layer from a GPS device (with x, y AND z coordinates).
>>>
>>>
>>>
>>> I want to digitize new features in 3D point and 3D line layers with
>>> snapping in all 3 dimensions to these GPS points.
>>>
>>>
>>>
>>> This works great for line features - every node gets 3D coordinates when
>>> snapped to my GPS points. However point features only get 2D coordinates
>>> (zero for z)!? Do I do something wrong - or is this by design?
>>>
>>>
>>>
>>> I have tried this in QGIS 2.18.21 and QGIS 3.4.0.
>>>
>>>
>>>
>>>
>>>
>>> Best regards,
>>>
>>>
>>> *Morten Storm*Chefkonsulent
>>>
>>> [image: logo] 
>>>
>>> [image: info]
>>>
>>>
>>> ___
>>> 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
>>
>>
>>
>> --
>> Saber Razmjooei
>> www.lutraconsulting.co.uk
>> +44 (0)7568 129733
>> ___
>> 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
>
>

-- 
Saber Razmjooei
www.lutraconsulting.co.uk
+44 (0)7568 129733
___
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] Snapping points and lines in 3D

[Saber Razmjooei]

Hi Morten,

This is probably by chance that the line works! Have you tried to move the
point using the node tool?

Proper 3D digitizing from within the 3D map is in our to-do list for
future, but if you'd be interested in sponsoring the feature, feel free to
contact us.

Regards
Saber

On Tue, 30 Oct 2018 at 08:08, Morten Storm  wrote:

> Hi,
>
>
>
> I have a 3D point layer from a GPS device (with x, y AND z coordinates).
>
>
>
> I want to digitize new features in 3D point and 3D line layers with
> snapping in all 3 dimensions to these GPS points.
>
>
>
> This works great for line features - every node gets 3D coordinates when
> snapped to my GPS points. However point features only get 2D coordinates
> (zero for z)!? Do I do something wrong - or is this by design?
>
>
>
> I have tried this in QGIS 2.18.21 and QGIS 3.4.0.
>
>
>
>
>
> Best regards,
>
>
> *Morten Storm*Chefkonsulent
>
> [image: logo] 
>
> [image: info]
>
>
> ___
> 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



-- 
Saber Razmjooei
www.lutraconsulting.co.uk
+44 (0)7568 129733
___
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] Performance of MSSQL Server with QGIS 3.4

[Baker, Matthew]

Thanks for the reply, Nyall.

To clarify - this issue is just refreshing the database tree in the browser 
window - once refreshed (eventually), all tables behave normally (see below re. 
invalid geometries). 

2.18 and 3.2 used to refresh the tables just fine. Upon installing 3.4, things 
have slowed down for all versions.

Another thing to note - 2.18 and 3.2 show only a handful of schemas in the 
database (not sure how it decides which one) - but now 3.4 is showing ALL 
schemas, including those without any tables and that weren't shown in 2.18/3.2 
- that's weird!

Re. skipping invalid geometries - this setting doesn't seem to have any effect 
on the behavior we're experiencing. (our data is in pretty good shape and we 
haven't had issues with invalid geometries prior to 3.4 when the option to 
'skip' was not available.) 

Thanks again!

-m



-Original Message-
From: Nyall Dawson  
Sent: Monday, October 29, 2018 5:04 PM
To: Baker, Matthew ; Andreas Neumann 

Cc: qgis-user 
Subject: Re: [Qgis-user] Performance of MSSQL Server with QGIS 3.4

On Tue, 30 Oct 2018 at 05:18, Baker, Matthew  wrote:

> Everything was working fine even with version 3.2, and additionally, I tested 
> with version 2.18 (which used to work fine), and the same issue is happening.

Just to clarify -- you mean that 2.18 shows the same performance issue?

My suspicion here is that you're running into SQL Server's (very
annoying) invalid geometry handling. We've been fighting with this for a couple 
of releases, and it breaks down to two choices:

1. Don't have any code in place on QGIS' side to overcome invalid geometries on 
SQL server databases. Benefit: fastest performance.
Downside: if ANY features in your table have invalid geometries, SQL Server 
silently aborts the request and returns a truncated table. You may be missing 
features and never even know about them.

2. Handle invalid geometries by repairing all invalid geometries when fetching 
from SQL server. Benefit: no issues with randomly truncated tables. Downside: 
much slower retrieval of features due to all the extra processing (done on the 
SQL server itself)

Since later 2.18 releases and QGIS 3.4 we play it safe and take approach 2 by 
default. Because it's better to have a slower provider instead of silent data 
loss. BUT if you're 100% confident that your database has no invalid 
geometries, and never will have them, then you can take off the safeties and 
run at full performance by changing a setting in your SQL Server connection. 
Look for the "Skip invalid geometry handling" checkbox under the connection 
properties and turn it on. But you've been warned, turning this setting on 
pushes all responsibility back TO YOU to ensure that your database is safe.
You'll get 0 warnings if it isn't, and you'll have randomly missing features 
from your layers.

I wish there was another approach here, but as of current SQL Server versions 
there isn't*. Frankly, it's just a very poor decision made by SQL Server's 
engineers which makes SQL Server an inferior choice for an enterprise spatial 
database.

Nyall

* if there is something we've missed -- please let us know!

>
>
>
> This issue doesn’t seem to lie in the server itself, as our DB GUI’s (MSSQL 
> Server Management Studio, DBeaver, DataGrip) all seem to be behaving normally 
> – tables displaying with no issue, queries performing fine, etc.
>
>
>
> Any thoughts appreciated!
>
>
>
> Thank you!
>
>
>
> -Matthew Baker
>
> Denver Public Schools
>
> Denver, CO, USA
>
>
>
> ___
> 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] Performance of MSSQL Server with QGIS 3.4

[Franklin, Chris - Perth.]

Hi All,

Just confirming I am seeing the same issue, I can see all schemas, more than I 
could with 3.2 and 2.18.

Kind Regards

Chris


From: Qgis-user  On Behalf Of Baker, Matthew
Sent: Tuesday, 30 October 2018 3:29 PM
To: Nyall Dawson ; Andreas Neumann 
Cc: qgis-user 
Subject: Re: [Qgis-user] Performance of MSSQL Server with QGIS 3.4

Thanks for the reply, Nyall.

To clarify - this issue is just refreshing the database tree in the browser 
window - once refreshed (eventually), all tables behave normally (see below re. 
invalid geometries).

2.18 and 3.2 used to refresh the tables just fine. Upon installing 3.4, things 
have slowed down for all versions.

Another thing to note - 2.18 and 3.2 show only a handful of schemas in the 
database (not sure how it decides which one) - but now 3.4 is showing ALL 
schemas, including those without any tables and that weren't shown in 2.18/3.2 
- that's weird!

Re. skipping invalid geometries - this setting doesn't seem to have any effect 
on the behavior we're experiencing. (our data is in pretty good shape and we 
haven't had issues with invalid geometries prior to 3.4 when the option to 
'skip' was not available.)

Thanks again!

-m



-Original Message-
From: Nyall Dawson mailto:nyall.daw...@gmail.com>>
Sent: Monday, October 29, 2018 5:04 PM
To: Baker, Matthew mailto:matthew_ba...@dpsk12.org>>; 
Andreas Neumann mailto:andr...@qgis.org>>
Cc: qgis-user mailto:qgis-user@lists.osgeo.org>>
Subject: Re: [Qgis-user] Performance of MSSQL Server with QGIS 3.4

On Tue, 30 Oct 2018 at 05:18, Baker, Matthew 
mailto:matthew_ba...@dpsk12.org>> wrote:

> Everything was working fine even with version 3.2, and additionally, I tested 
> with version 2.18 (which used to work fine), and the same issue is happening.

Just to clarify -- you mean that 2.18 shows the same performance issue?

My suspicion here is that you're running into SQL Server's (very
annoying) invalid geometry handling. We've been fighting with this for a couple 
of releases, and it breaks down to two choices:

1. Don't have any code in place on QGIS' side to overcome invalid geometries on 
SQL server databases. Benefit: fastest performance.
Downside: if ANY features in your table have invalid geometries, SQL Server 
silently aborts the request and returns a truncated table. You may be missing 
features and never even know about them.

2. Handle invalid geometries by repairing all invalid geometries when fetching 
from SQL server. Benefit: no issues with randomly truncated tables. Downside: 
much slower retrieval of features due to all the extra processing (done on the 
SQL server itself)

Since later 2.18 releases and QGIS 3.4 we play it safe and take approach 2 by 
default. Because it's better to have a slower provider instead of silent data 
loss. BUT if you're 100% confident that your database has no invalid 
geometries, and never will have them, then you can take off the safeties and 
run at full performance by changing a setting in your SQL Server connection. 
Look for the "Skip invalid geometry handling" checkbox under the connection 
properties and turn it on. But you've been warned, turning this setting on 
pushes all responsibility back TO YOU to ensure that your database is safe.
You'll get 0 warnings if it isn't, and you'll have randomly missing features 
from your layers.

I wish there was another approach here, but as of current SQL Server versions 
there isn't*. Frankly, it's just a very poor decision made by SQL Server's 
engineers which makes SQL Server an inferior choice for an enterprise spatial 
database.

Nyall

* if there is something we've missed -- please let us know!

>
>
>
> This issue doesn’t seem to lie in the server itself, as our DB GUI’s (MSSQL 
> Server Management Studio, DBeaver, DataGrip) all seem to be behaving normally 
> – tables displaying with no issue, queries performing fine, etc.
>
>
>
> Any thoughts appreciated!
>
>
>
> Thank you!
>
>
>
> -Matthew Baker
>
> Denver Public Schools
>
> Denver, CO, USA
>
>
>
> ___
> 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] Snapping points and lines in 3D

[Morten Storm]

Hi Saber and Régis,

 

Thanks for your prompt replies! I am not trying to digitize in 3D view - but 
was merely hoping to snap in all 3 dimensions when doing ordinary editing with 
snap to points containing this information. I understand that this may be a 
bigger issue, than I originally anticipated - but I also think that I (and the 
other users, I know) would prefer "unconditional" snapping to Z, if the 
information is there and until the whole topic had been resolved.

 

Do you by any chance have a work around for this?

 

 

Best regards,


Morten Storm



 

Fra: Régis Haubourg [mailto:regis.haubo...@gmail.com] 
Sendt: 30. oktober 2018 16:16
Til: Saber Razmjooei
Cc: Morten Storm; QGIS list
Emne: Re: [Qgis-user] Snapping points and lines in 3D

 

Hi, It's not by chance, we have been working a lot to try to make the 
digitizing maptools catch with the 3D API for geometries, because before 2.18, 
it was just destroying Z and M values for all operations. 

I think some use cases are still missing probably, and some are not easy to 
solve by one default behavior, because choosing if you want to snap Z value or 
not should be a user choice. 

We have been discussing a lot about going towards some interactive snapping 
widget to be able to choose which feature to grab, which to snap to, use Z or 
not, use a Z snapping tolerance or not. It's a big topic! 

Best regards

Régis

 

Le mar. 30 oct. 2018 à 15:29, Saber Razmjooei 
 a écrit :

Hi Morten,

 

This is probably by chance that the line works! Have you tried to move 
the point using the node tool?

 

Proper 3D digitizing from within the 3D map is in our to-do list for 
future, but if you'd be interested in sponsoring the feature, feel free to 
contact us.

 

Regards

Saber

 

On Tue, 30 Oct 2018 at 08:08, Morten Storm  
wrote:

Hi,

 

I have a 3D point layer from a GPS device (with x, y AND z 
coordinates).

 

I want to digitize new features in 3D point and 3D line layers 
with snapping in all 3 dimensions to these GPS points.

 

This works great for line features - every node gets 3D 
coordinates when snapped to my GPS points. However point features only get 2D 
coordinates (zero for z)!? Do I do something wrong - or is this by design?

 

I have tried this in QGIS 2.18.21 and QGIS 3.4.0.

 

 

Best regards,

Morten Storm
Chefkonsulent 

Fejl! Filnavn er ikke anført.  

Fejl! Filnavn er ikke anført.

 

___
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




 

-- 

Saber Razmjooei

www.lutraconsulting.co.uk
+44 (0)7568 129733

___
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-it-user] QGIS - Esportazione file

[Amedeo Fadini]

Ciao,

Il 30/ott/2018 04:14 PM, "Studio Multiservice s.s." <
studio.multiservice.mant...@gmail.com> ha scritto:

Amedeo e Martina,

grazie!!

Il grigio perimetrale (nominato "velina") […] colore grigio e con
riempimento semplice "compatto 4" di QGIS 2.18.18 su WIN7 64bit.


Aaargh!
Il "riempimento semplice compatto" è un retino, un pattern molto fitto di
punti aggiunto agli altri retini dell'uso del suolo è un impresa
titanica per il software di stampa.
Prova a usare riempimento pieno e trasparenza (che non dovrebbe fare
dithering) o le modalità di fusione.

Giova ricordare come si lavorava nell'era analogica (io andavo al ginnasio
ma qualcosa ho visto):

per i retini: si prendeva il foglio adesivo del retino, si applicava con
attenzione sulla tavola, si ritagliava con il taglierino lungo i bordi e
poi si rimuoveva con molta molta attenzione  il retino in eccesso (qui [0]
il processo su un manga)

per la tinta unita: si prendeva una matita colorata e si colorava entro i
bordi (lavoro deferibile a uno stagista dagli 8 anni in su)

Ora immagina che dentro il tuo plotter ci siano una ventina di gnomi che si
preoccupano di stampare le tue tavole A0 con le tecniche di allora...
quando arriva il file sono tutti lì pronti con la borsa piena di penne,
matite, temperini, taglierino, retini adesivi ecc.. come pensi che
preferiscano disegnare il grigio? Tinta unita con un pastello leggero sopra
la ctr o n-mila fogli di retino da ritagliare? Non ti fanno pena tutti quei
piccoli esserini con le manine rovinate?

:-D

(si scherza ovviamente)


Amefad

[0] https://www.youtube.com/watch?v=LdbTcUi8jCE

;
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user

Re: [Qgis-user] Snapping points and lines in 3D

[Régis Haubourg]

Hi,
much more than that in fact. The idea xould be to have interactive
modifiers to list all available features at a possible snapping location. Z
snapping tolerance would only be only here to help in not snapping a 2D
point if the Z value is too far away from the existing one (for instance).
The default Z value has been added as an answer to the fact that most
providers can't handle Null Z values, so that you can set it to  if you
want and consider it is a no data information.
In the meantime, I realized that PostgGIS is totally able to store NaN
values for Z, M (even XY too). Shapefile definitely cannot.

Le mar. 30 oct. 2018 à 17:44, DelazJ  a écrit :

> Hi,
>
> Do you mean something like Settings --> Options --> Digitizing --> Default
> Z value?
> This is the Z-related option I can remember for digitizing (not really a
> snapping one though).
>
> Harrissou
>
> Le mar. 30 oct. 2018 à 16:27, Morten Storm  a
> écrit :
>
>> Hi Saber and Régis,
>>
>>
>>
>> Thanks for your prompt replies! I am not trying to digitize in 3D view -
>> but was merely hoping to snap in all 3 dimensions when doing ordinary
>> editing with snap to points containing this information. I understand that
>> this may be a bigger issue, than I originally anticipated - but I also
>> think that I (and the other users, I know) would prefer "unconditional"
>> snapping to Z, if the information is there and until the whole topic had
>> been resolved.
>>
>>
>>
>> Do you by any chance have a work around for this?
>>
>>
>>
>>
>>
>> Best regards,
>>
>>
>>
>>
>> *Morten Storm*
>>
>>
>>
>> *Fra:* Régis Haubourg [mailto:regis.haubo...@gmail.com]
>> *Sendt:* 30. oktober 2018 16:16
>> *Til:* Saber Razmjooei
>> *Cc:* Morten Storm; QGIS list
>> *Emne:* Re: [Qgis-user] Snapping points and lines in 3D
>>
>>
>>
>> Hi, It's not by chance, we have been working a lot to try to make the
>> digitizing maptools catch with the 3D API for geometries, because before
>> 2.18, it was just destroying Z and M values for all operations.
>>
>> I think some use cases are still missing probably, and some are not easy
>> to solve by one default behavior, because choosing if you want to snap Z
>> value or not should be a user choice.
>>
>> We have been discussing a lot about going towards some interactive
>> snapping widget to be able to choose which feature to grab, which to snap
>> to, use Z or not, use a Z snapping tolerance or not. It's a big topic!
>>
>> Best regards
>>
>> Régis
>>
>>
>>
>> Le mar. 30 oct. 2018 à 15:29, Saber Razmjooei <
>> saber.razmjo...@lutraconsulting.co.uk> a écrit :
>>
>> Hi Morten,
>>
>>
>>
>> This is probably by chance that the line works! Have you tried to move
>> the point using the node tool?
>>
>>
>>
>> Proper 3D digitizing from within the 3D map is in our to-do list for
>> future, but if you'd be interested in sponsoring the feature, feel free to
>> contact us.
>>
>>
>>
>> Regards
>>
>> Saber
>>
>>
>>
>> On Tue, 30 Oct 2018 at 08:08, Morten Storm 
>> wrote:
>>
>> Hi,
>>
>>
>>
>> I have a 3D point layer from a GPS device (with x, y AND z coordinates).
>>
>>
>>
>> I want to digitize new features in 3D point and 3D line layers with
>> snapping in all 3 dimensions to these GPS points.
>>
>>
>>
>> This works great for line features - every node gets 3D coordinates when
>> snapped to my GPS points. However point features only get 2D coordinates
>> (zero for z)!? Do I do something wrong - or is this by design?
>>
>>
>>
>> I have tried this in QGIS 2.18.21 and QGIS 3.4.0.
>>
>>
>>
>>
>>
>> Best regards,
>>
>>
>> *Morten Storm*Chefkonsulent
>>
>> *Fejl! Filnavn er ikke anført.* 
>>
>> *Fejl! Filnavn er ikke anført.*
>>
>>
>>
>> ___
>> 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
>>
>>
>>
>>
>> --
>>
>> Saber Razmjooei
>>
>> www.lutraconsulting.co.uk
>> +44 (0)7568 129733
>>
>> ___
>> 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] Snapping points and lines in 3D

[DelazJ]

Hi,

Do you mean something like Settings --> Options --> Digitizing --> Default
Z value?
This is the Z-related option I can remember for digitizing (not really a
snapping one though).

Harrissou

Le mar. 30 oct. 2018 à 16:27, Morten Storm  a
écrit :

> Hi Saber and Régis,
>
>
>
> Thanks for your prompt replies! I am not trying to digitize in 3D view -
> but was merely hoping to snap in all 3 dimensions when doing ordinary
> editing with snap to points containing this information. I understand that
> this may be a bigger issue, than I originally anticipated - but I also
> think that I (and the other users, I know) would prefer "unconditional"
> snapping to Z, if the information is there and until the whole topic had
> been resolved.
>
>
>
> Do you by any chance have a work around for this?
>
>
>
>
>
> Best regards,
>
>
>
>
> *Morten Storm*
>
>
>
> *Fra:* Régis Haubourg [mailto:regis.haubo...@gmail.com]
> *Sendt:* 30. oktober 2018 16:16
> *Til:* Saber Razmjooei
> *Cc:* Morten Storm; QGIS list
> *Emne:* Re: [Qgis-user] Snapping points and lines in 3D
>
>
>
> Hi, It's not by chance, we have been working a lot to try to make the
> digitizing maptools catch with the 3D API for geometries, because before
> 2.18, it was just destroying Z and M values for all operations.
>
> I think some use cases are still missing probably, and some are not easy
> to solve by one default behavior, because choosing if you want to snap Z
> value or not should be a user choice.
>
> We have been discussing a lot about going towards some interactive
> snapping widget to be able to choose which feature to grab, which to snap
> to, use Z or not, use a Z snapping tolerance or not. It's a big topic!
>
> Best regards
>
> Régis
>
>
>
> Le mar. 30 oct. 2018 à 15:29, Saber Razmjooei <
> saber.razmjo...@lutraconsulting.co.uk> a écrit :
>
> Hi Morten,
>
>
>
> This is probably by chance that the line works! Have you tried to move the
> point using the node tool?
>
>
>
> Proper 3D digitizing from within the 3D map is in our to-do list for
> future, but if you'd be interested in sponsoring the feature, feel free to
> contact us.
>
>
>
> Regards
>
> Saber
>
>
>
> On Tue, 30 Oct 2018 at 08:08, Morten Storm 
> wrote:
>
> Hi,
>
>
>
> I have a 3D point layer from a GPS device (with x, y AND z coordinates).
>
>
>
> I want to digitize new features in 3D point and 3D line layers with
> snapping in all 3 dimensions to these GPS points.
>
>
>
> This works great for line features - every node gets 3D coordinates when
> snapped to my GPS points. However point features only get 2D coordinates
> (zero for z)!? Do I do something wrong - or is this by design?
>
>
>
> I have tried this in QGIS 2.18.21 and QGIS 3.4.0.
>
>
>
>
>
> Best regards,
>
>
> *Morten Storm*Chefkonsulent
>
> *Fejl! Filnavn er ikke anført.* 
>
> *Fejl! Filnavn er ikke anført.*
>
>
>
> ___
> 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
>
>
>
>
> --
>
> Saber Razmjooei
>
> www.lutraconsulting.co.uk
> +44 (0)7568 129733
>
> ___
> 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] Very Important Question on vertex selection mode in QGIS 3.4

[Rick Rupp]

Hi,

I find the new vertex editor in 3.4 intuitive and easy to use. I turn on 
editing, select- vertex editing, hover over the feature of interest to 
highlight the vertices, click on the vertex to select it, and click again in 
the new location. It works in topological and non-topological sessions.

Regards, Rick






From: Qgis-user  on behalf of Antongeo76 

Sent: Tuesday, October 30, 2018 1:51:58 AM
To: qgis-user@lists.osgeo.org
Subject: [Qgis-user] Very Important Question on vertex selection mode in QGIS 
3.4

Hi all,
I need to know the opinions of other users on vertex selection by new vertex
editor in QGIS 3.4.

Using the new "vertex editor" (since Qgis 3.4) it often happens that user is
not  able to select vertex of a polygon when hovering over the polygon...
Then a user need to previously select the polygon (by select tool) in order
to be able to do this selection.

Well, in my opinion, this selection mode is very cumbersome when I compare
It whit the qgis 2.x mode,
 where the user could simply click on the polygon to automatically select
vertex, without having to select it in advance (by selection tool).

I think QGIS 2.x mode was more functional and intuitive and especially and
above all much faster

Based on your feedback, we could ask the developers to reintroduce the old
selection mode by open a feature request ticket

Greetings

Antonio



-
Antonio
--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
___
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] Very Important Question on vertex selection mode in QGIS 3.4

[Antongeo76]

Rick Rupp wrote
> Hi,
> 
> I find the new vertex editor in 3.4 intuitive and easy to use. I turn on
> editing, select- vertex editing, hover over the feature of interest to
> highlight the vertices, click on the vertex to select it, and click again
> in the new location. It works in topological and non-topological sessions.
> 
> Regards, Rick
> 
> 
> 
> 
> 
> 
> From: Qgis-user 

> qgis-user-bounces@.osgeo

>  on behalf of Antongeo76 

> antoviscomi@

> 
> Sent: Tuesday, October 30, 2018 1:51:58 AM
> To: 

> qgis-user@.osgeo

> Subject: [Qgis-user] Very Important Question on vertex selection mode in
> QGIS 3.4
> 
> Hi all,
> I need to know the opinions of other users on vertex selection by new
> vertex
> editor in QGIS 3.4.
> 
> Using the new "vertex editor" (since Qgis 3.4) it often happens that user
> is
> not  able to select vertex of a polygon when hovering over the polygon...
> Then a user need to previously select the polygon (by select tool) in
> order
> to be able to do this selection.
> 
> Well, in my opinion, this selection mode is very cumbersome when I compare
> It whit the qgis 2.x mode,
>  where the user could simply click on the polygon to automatically select
> vertex, without having to select it in advance (by selection tool).
> 
> I think QGIS 2.x mode was more functional and intuitive and especially and
> above all much faster
> 
> Based on your feedback, we could ask the developers to reintroduce the old
> selection mode by open a feature request ticket
> 
> Greetings
> 
> Antonio
> 
> 
> 
> -
> Antonio
> --
> Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
> ___
> Qgis-user mailing list

> Qgis-user@.osgeo

> 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@.osgeo

> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Hi Rick, 
My question is only in case of not selection of vertex... 
I've noticed that when I need to edit a polygon that fill a hole of another
polygon the selection of vertex even fail...

Regards, Antonio



-
Antonio
--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
___
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-it-user] QGIS - Esportazione file

[Martina Savarese]

Il giorno mar 30 ott 2018 alle ore 20:44 Martina Savarese <
martina.savar...@gmail.com> ha scritto:

> A rigor di logica (ma non sperimentata) esportando direttamente in QGIS
> come vettoriale quel retino dovrebbe rimanere un vettoriale, il che non ti
> alleggerisce il file se la base è cmq una ctr, ma dovrebbe venire meglio
>
>
Cioè, che viene meglio l'ho sperimentato, ora non ricordo se avessi
spuntato l'opzione "Esporta sempre come vettore"

Martina
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user

Re: [QGIS-it-user] Qgis3 - Sql Server

[Leonardo Donnini]

IL PROBLEMA SEGNALATO E' STATO RISOLTO CON L'AGGIORNAMENTO ALLA VERSIONE 
3.4.0-Madeira.




Il 17/10/2018 14:49, Leonardo Donnini ha scritto:

Buongiorno,
segnalo un problema che ho trovato a seguito dell'aggiornamento che ho 
eseguito ieri alla versione 3.2.3-Bonn.


non sono più in grado di collegare le tabelle dal server MS SQL , o 
meglio la connessione la fa ma ma poi non riconosce le tabelle con 
dati geografici e non è possibile collegarle al progetto .


se la tabella è già collegata al progetto viene mostrata e gestita 
regolarmente


se apro il progetto con una versione precedente e collego una tabella 
poi salvo e riapro il progetto con Qgis 3.2.3 la tabella collegata 
viene mostrata e gestita regolarmente .


E possibile una soluzione , qualcuno può provare e confermare il bug ?

Grazie

Leonardo




---
Questa e-mail è stata controllata per individuare virus con Avast antivirus.
https://www.avast.com/antivirus

___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user

Re: [QGIS-it-user] QGIS - Esportazione file

[Studio Multiservice s.s.]

>
> Amedeo
>

anche oggi ho imparato qualcosa.

Domani trasformo il retino in un pieno parzialmente trasparente.
Vediamo che succede.
Per info: altre stampe eseguite da terzi hanno reso al meglio proprio la
carta incriminata. Mi informo su hw utilizzato.

Grazie ancora

Alberto

PS: lo scherzo è sempre ben accetto!!

>
> :-D
>
> (si scherza ovviamente)
>
>
> Amefad
>
> [0] https://www.youtube.com/watch?v=LdbTcUi8jCE
>
> ;
> ___
> QGIS-it-user mailing list
> QGIS-it-user@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/qgis-it-user
>
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user

Re: [Qgis-user] Performance of MSSQL Server with QGIS 3.4

[Nyall Dawson]

On Wed, 31 Oct 2018 at 01:28, Baker, Matthew  wrote:
>
> Thanks for the reply, Nyall.
>
> To clarify - this issue is just refreshing the database tree in the browser 
> window - once refreshed (eventually), all tables behave normally (see below 
> re. invalid geometries).
>
> 2.18 and 3.2 used to refresh the tables just fine. Upon installing 3.4, 
> things have slowed down for all versions.

Thanks for the clarification. Can you confirm whether you have the
setting "only look in the geometry_columns metadata table" switched on
or off for your connection?

If you're not using this setting, then it's possibly related to this
fix https://github.com/qgis/QGIS/commit/e813fe880. Pre 3.4 QGIS was
only looking in the geometry columns table for the browser, and not
respecting this setting.

> Another thing to note - 2.18 and 3.2 show only a handful of schemas in the 
> database (not sure how it decides which one) - but now 3.4 is showing ALL 
> schemas, including those without any tables and that weren't shown in 
> 2.18/3.2 - that's weird!

That's intended -- for db connections we should be showing empty
schemas in the browser, as this allows users to drag and drop tables
into these schemas to initially populate them.

Nyall
___
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] Georeferencing for Avenza

[Stephane Goldstein]

Hi Peter.

I have been exporting georeferenced TIFs and using them in Avenza without
any issues so far, in both in GDA94 (lat/lon) and GDA MGA zones.
I always go trough the layout/composer and create a map covering the whole
page.
Then I export it as a TIF. The downside is you have to set a much higher
DPI then what you raster data is actually in, and the files get very big.
About 150mb for an A4 layout at 600dpi, which is what I usually use.
Of course this can vary depending on the extent of your map. The larger the
area you wanna load in Avenza, the higher your DPI setting needs to be.
I work with areas about 150x80km in one A4 layout.
Hope this helps.
Cheers.

On Tue, Oct 30, 2018 at 8:31 PM Kirk Schmidt 
wrote:

> Hi Peter:
>
> Generate the map you require in the field using the print composer.  In
> the items window on the right hand side of the standard composer window,
> select the Composition Tab and check the save world file option in the
> export settings.
>
> Save the pdf of the map and load into Avenza.
>
>
> Kirk
>
> On 10/30/2018 7:39 AM, Gmail - Peter wrote:
>
> Dear List Subscribers
>
>
>
> Are there any updates to the threads of 2015/2016 regarding QGIS producing
> georeferenced tifs or pdfs for loading into Avenza?  I am a newbie to QGIS
> (Madeira 3.4) and while I have succeeded in producing a correctly
> georeferenced tif file via Raster>Conversion>translate, this only works on
> one layer.  The three other methods I can see to export or print a pdf or
> tif do not produce a correctly georeferenced file in Lats/Longs using
> GDA94Z50.  The file according to Avenza is ~54deg and 89deg south and west
> of where it should be.
>
>
>
> I am starting with a non-georeferenced raster which I put through the
> georeferencer with 6 GCPs and several experiments of transformation types,
> settling on polynomial 1.  The process produces a tif, pdf, and loads back
> into the main window.  The main window raster is georeferenced perfectly,
> so wouldn’t you think the other output would be too?
>
>
>
> The correct method should be to use Print Layout, produce a map with all
> the layers from the main window, and export as an image or pdf.  This might
> work if the map units were real world and not mm.
>
> The fall back should be Project>Import/Export>Export Map to Image or pdf
> from the main window, but that doesn’t work either.
>
>
>
> I hope the solution is obvious and I have overlooked something simple.
> Any guidance appreciated, I like to take my maps out into the field.
>
>
>
> Regards
>
> Peter
>
>
> ___
> Qgis-user mailing listqgis-u...@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
> --
> Kirk Schmidt, MScF, BScF, RPF
> General Manager
> Nortek Resource Solutions Inc.
> RR # 1
> Thorburn, NS
> B0K 1W0
> Tel (902) 922.3607
> Email: k...@nortekresources.com
> Web: www.nortekresources.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

Re: [Qgis-user] Georeferencing for Avenza

[Gmail - Peter]

Hi Kirk

 

Some of the earlier posts from a few years back also pointed out the need
for the World File also, so I have been enabling that wherever I see that as
an option.  When exporting as a pdf it is not produced, even though ticked,
although when exporting as a tiff rather than a pdf, it is produced, and
looks to be produced correctly.  An export Option box pops up where you can
set the resolution, crop to extent, tick a box to generate a world file and
enable antialiasing. 

The tif file produced is referenced, but weirdly. When the map (a Perth
local one as a trial) is imported into Avenza, it states that the image is
on map, but when the locate icon is engaged, you are not on the map.  When
you use the Measure tools in Acrobat reader, the geospatial Lats and Longs
are completely random.

 

I can't see it as being anything other than a bug at this point.

 

Regards

Peter

 

From: Kirk Schmidt [mailto:k...@nortekresources.com] 
Sent: Tuesday, 30 October 2018 8:32 PM
To: qgis-user@lists.osgeo.org
Subject: Re: [Qgis-user] Georeferencing for Avenza

 

Hi Peter:

Generate the map you require in the field using the print composer.  In the
items window on the right hand side of the standard composer window, select
the Composition Tab and check the save world file option in the export
settings.   

Save the pdf of the map and load into Avenza.  

 

Kirk

 

On 10/30/2018 7:39 AM, Gmail - Peter wrote:

Dear List Subscribers

 

Are there any updates to the threads of 2015/2016 regarding QGIS producing
georeferenced tifs or pdfs for loading into Avenza?  I am a newbie to QGIS
(Madeira 3.4) and while I have succeeded in producing a correctly
georeferenced tif file via Raster>Conversion>translate, this only works on
one layer.  The three other methods I can see to export or print a pdf or
tif do not produce a correctly georeferenced file in Lats/Longs using
GDA94Z50.  The file according to Avenza is ~54deg and 89deg south and west
of where it should be.

 

I am starting with a non-georeferenced raster which I put through the
georeferencer with 6 GCPs and several experiments of transformation types,
settling on polynomial 1.  The process produces a tif, pdf, and loads back
into the main window.  The main window raster is georeferenced perfectly, so
wouldn't you think the other output would be too?

 

The correct method should be to use Print Layout, produce a map with all the
layers from the main window, and export as an image or pdf.  This might work
if the map units were real world and not mm.

The fall back should be Project>Import/Export>Export Map to Image or pdf
from the main window, but that doesn't work either.

 

I hope the solution is obvious and I have overlooked something simple.  Any
guidance appreciated, I like to take my maps out into the field.

 

Regards

Peter






___
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





-- 
Kirk Schmidt, MScF, BScF, RPF
General Manager
Nortek Resource Solutions Inc.
RR # 1
Thorburn, NS
B0K 1W0
Tel (902) 922.3607
Email: k...@nortekresources.com
Web: www.nortekresources.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] GEarthView3 -qgis 3.x

[Eddison Araya]

Hello, the GEarthView3 tool is not available in QGIS 3.x, is there any
other similar one?

Thank you

Eddison
___
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] OSGEO4W64 installs after failed download

[Reginald]

Hi,

Today I noticed that there was a new version of QGIS.
I decided to update.
During the update process the installer informed me that the download was
incomplete. I choosed to try again but again it ended up incomplete so I
choosed no the second time.
I expected the installation to STOP because the download was INCOMPLETE.
But no: immediately the installer began uninstalling the existing and
working QGIS installation :-(
I ended up with a QGIS 3.4 installation without python support which I need
a lot.
This is the failure:
Problemen bij het laden van de SIP module.
Python-ondersteuning wordt uitgeschakeld.

Traceback (most recent call last):
  File "", line 1, in 
  File "C:/OSGEO4~1/apps/qgis/./python\qgis\__init__.py", line 72, in 
from qgis.PyQt import QtCore
  File "C:/OSGEO4~1/apps/qgis/./python\qgis\PyQt\QtCore.py", line 26, in 
from PyQt5.QtCore import *
ModuleNotFoundError: No module named 'PyQt5.QtCore'

So I hope the devs that make the installer read this and when the download
is incomplete they show a message that says: Downloading all the needed
files failed. Try again installing later.

Regards,




--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
___
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] Snapping points and lines in 3D

[Morten Storm]

Hi,

 

I have a 3D point layer from a GPS device (with x, y AND z coordinates).

 

I want to digitize new features in 3D point and 3D line layers with
snapping in all 3 dimensions to these GPS points.

 

This works great for line features - every node gets 3D coordinates when
snapped to my GPS points. However point features only get 2D coordinates
(zero for z)!? Do I do something wrong - or is this by design?

 

I have tried this in QGIS 2.18.21 and QGIS 3.4.0.

 

 

Best regards,

Morten Storm
Chefkonsulent 

   

 

 

___
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] getFeatures() and fields()

[Roberto Herrero]

You are right, Nyall. The problem was the path of the vector layer.

Thank you,
Roberto

El lun., 29 oct. 2018 a las 23:54, Nyall Dawson ()
escribió:

> On Tue, 30 Oct 2018 at 06:39, Roberto Herrero 
> wrote:
> >
> > getFeatures() and fields() do not seem to work in Qgis3.2
>
> They 100% work -- if they didn't, QGIS wouldn't be good for anything
> except wasting some space on your computer ;)
>
> > # Open vector layer
> > LayerName = u'Vector_layer.shp'
> > VectorLayer = qgis.core.QgsVectorLayer(LayerName, 'mylayer', 'ogr')
>
> I suspect this is where the issue sits -- try checking
>
> assert VectorLayer.isValid()
>
> here. My suspicion is that your relative path 'Vector_layer.shp' is
> not working, and will need to be an absolute path.
>
> Nyall
>
___
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] Very Important Question on vertex selection mode in QGIS 3.4

[Antongeo76]

Hi all, 
I need to know the opinions of other users on vertex selection by new vertex
editor in QGIS 3.4.
 
Using the new "vertex editor" (since Qgis 3.4) it often happens that user is
not  able to select vertex of a polygon when hovering over the polygon... 
Then a user need to previously select the polygon (by select tool) in order
to be able to do this selection.

Well, in my opinion, this selection mode is very cumbersome when I compare
It whit the qgis 2.x mode,
 where the user could simply click on the polygon to automatically select
vertex, without having to select it in advance (by selection tool). 

I think QGIS 2.x mode was more functional and intuitive and especially and
above all much faster

Based on your feedback, we could ask the developers to reintroduce the old
selection mode by open a feature request ticket

Greetings

Antonio



-
Antonio
--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
___
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