Re: [Qgis-user] Geodesic Measure Tool With Bearing Information

[C Hamilton]

That's nice to see someone else with the same ideas and needs. Ultimately
what I would like to see happen is for QgsDistanceArea class to be expanded
to support these better geodesic algorithms, but also support great circle
transforms as well. The advantage of simpler algorithms is their speed and
for short distances are relatively accurate, but for real accuracy
geographiclib is the way to go. ArcGIS also supports Rhumb lines. I'm not
sure if that would be needed or not.

There are several missing methods to QgsDistanceArea

1. Return the shortest path line between two points. The input would be the
two points and the maximum distance of travel before a new line segment is
added to the path. It may be good to add an attribute that is the maximum
number of line segments that the line can have.

2. Given a starting point, bearing, and distance, return the destination
point.

3. Calculate the intersection of two paths given their starting points and
bearing.






On Wed, Jun 14, 2017 at 11:21 PM, Tobias Wendorff <
tobias.wendo...@tu-dortmund.de> wrote:

> Am Mi, 14.06.2017, 23:41 schrieb Nyall Dawson:
> >
> > This looks relevant:
> >
> > https://github.com/sourcepole/kadas-albireo/commit/
> df64318e5198f40f0e96d27fcf9e179fbbf682fd
>
> Thanks, nice find. After googling a bit: that seems to be the GIS
> of the Swiss army :)
>
>
___
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 + PostGIS in production environment

[Cap Diniz]

Thanks for the responses so far!

Adding a bit more information.

We are using Dell PowerEdge-R430 [1] for the PostGIS server with OS Debian
8.7 on a 1gigabit network. For each topographic sheet we use one database,
this means that we have hundreds of databases in production. We divide the
databases in different ports by project, just for organization, I don't
know if that impacts performance.

As for clients we usually use Debian 8.4, Windows 7 or Windows 10 with
latest LTR QGIS. The clients are i7, 8gb RAM, 1gb video card.

We didn't do any tuning in PostgreSQL, I will try out the suggestions. As
configuration goes, we just disabled the Auto Vacuum, and run it by a
script at night (when no one is connected) along with backup.



Then main problem that we are facing is slow saving time at peak hours
(when about 50 clients are digitizing in different databases). Sometimes
can take up to 1 minute to save all layers. We work with autosave in QGIS
that saves every 5 minutes, so slow saving time is not ideal.
The reason that we save so much is that sometimes we have errors while
saving, such as null geometries, that we cannot fix and we have to discard
the edits. (also we have other errors that usually we discard the edits).



[1] https://i.dell.com/sites/doccontent/shared-content/data-
sheets/en/Documents/Dell-PowerEdge-R430-Spec-Sheet.pdf



Thanks Mike, I sent an email there also.


Regards,
Felipe Diniz

On Thu, Jun 15, 2017 at 2:53 PM, Michael Treglia  wrote:

> The other thing I might suggest is writing the postgis-users list to get
> any input from there, especially on the database end of things:
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
> Hope that helps!
> Cheers,
> mike
>
> On Thu, Jun 15, 2017 at 1:49 PM, Árni Geirsson  wrote:
>
>> Hello Felipe
>> I use these systems but not at this large scale and can therefore
>> probably not help you, but I find the question interesting. Could you be
>> more specific about the performance and reliability bottlenecks that you
>> would like to address? Have you experienced problems as the number of users
>> grows?
>>
>> Árni
>>
>>
>> Árni Geirsson
>> *Alta ehf* // +354 582 5000 <+354%20582%205000> // +354 897 9549
>> <+354%20897%209549>
>>
>> On 15 June 2017 at 17:25, Cap Diniz  wrote:
>>
>>> Hello,
>>>
>>> I am from the Cartographic Production Department from the Brazilian
>>> Army, and we are trying to migrate from ArcGIS to QGIS+PostGIS.
>>>
>>> We are currently using QGIS 2.14.15, and we mostly do data digitizing
>>> over an orthoimage. We have about 50 simultaneous users in a single PostGIS
>>> server, but in different databases.
>>>
>>> I would like to know if there are any tips to improve performance and
>>> QGIS reliability, such as tuning PostgreSQL, operating systems, hardware
>>> recommendations, or QGIS specifics.
>>>
>>>
>>> Regards,
>>> Felipe Diniz
>>>
>>> ___
>>> 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

[Qgis-user] QGIS 2.18.7 crashes on launch

[Robert Mark]

Mac OS 10.12.5  QGIS has run on this Mac in the past. Reinstallation did 
not fix the problem.



--
--
Robert Mark, Ph.D. rm...@infomagic.net

___
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 + PostGIS in production environment

[Michael Treglia]

The other thing I might suggest is writing the postgis-users list to get
any input from there, especially on the database end of things:
https://lists.osgeo.org/mailman/listinfo/postgis-users

Hope that helps!
Cheers,
mike

On Thu, Jun 15, 2017 at 1:49 PM, Árni Geirsson  wrote:

> Hello Felipe
> I use these systems but not at this large scale and can therefore probably
> not help you, but I find the question interesting. Could you be more
> specific about the performance and reliability bottlenecks that you would
> like to address? Have you experienced problems as the number of users grows?
>
> Árni
>
>
> Árni Geirsson
> *Alta ehf* // +354 582 5000 <+354%20582%205000> // +354 897 9549
> <+354%20897%209549>
>
> On 15 June 2017 at 17:25, Cap Diniz  wrote:
>
>> Hello,
>>
>> I am from the Cartographic Production Department from the Brazilian Army,
>> and we are trying to migrate from ArcGIS to QGIS+PostGIS.
>>
>> We are currently using QGIS 2.14.15, and we mostly do data digitizing
>> over an orthoimage. We have about 50 simultaneous users in a single PostGIS
>> server, but in different databases.
>>
>> I would like to know if there are any tips to improve performance and
>> QGIS reliability, such as tuning PostgreSQL, operating systems, hardware
>> recommendations, or QGIS specifics.
>>
>>
>> Regards,
>> Felipe Diniz
>>
>> ___
>> 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] QGIS + PostGIS in production environment

[Árni Geirsson]

Hello Felipe
I use these systems but not at this large scale and can therefore probably
not help you, but I find the question interesting. Could you be more
specific about the performance and reliability bottlenecks that you would
like to address? Have you experienced problems as the number of users grows?

Árni


Árni Geirsson
*Alta ehf* // +354 582 5000 // +354 897 9549

On 15 June 2017 at 17:25, Cap Diniz  wrote:

> Hello,
>
> I am from the Cartographic Production Department from the Brazilian Army,
> and we are trying to migrate from ArcGIS to QGIS+PostGIS.
>
> We are currently using QGIS 2.14.15, and we mostly do data digitizing over
> an orthoimage. We have about 50 simultaneous users in a single PostGIS
> server, but in different databases.
>
> I would like to know if there are any tips to improve performance and QGIS
> reliability, such as tuning PostgreSQL, operating systems, hardware
> recommendations, or QGIS specifics.
>
>
> Regards,
> Felipe Diniz
>
> ___
> 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] Trasformazione shape punti in linea

[roberto facoetti]

ciao Giuseppe,

è un problema di linear reference system.

Dai un'occhiata al plugin LRS: dopo aver calibrato le linee con i punti 
(dove devi avere una colonna con i dati del chilometro), crea una 
tabella degli eventi con l'inizio / fine ad ogni chilometro.


ciao

roberto


Il 14/06/2017 18:31, Giuseppe Puddu ha scritto:

ciao a tutti.
ho bisogno di un suggerimento (se si può fare)!
Ho un file di punti (km di una strada) che vorrei trasformare in una 
linea. Facile.

Nella trasformazione il kilometraggio (es. km 15)
che oggi è assegnato al cartello stradale di inizio
dovrebbe essere assegnato all'intero tratto che va dal km 15 al 16,
perchè vorrei assegnare una caratteristica del bordo stradale
(ambiente circostante) all'intero tratto.

grazie in anticipo per i suggerimenti
giuseppe puddu



Con Mobile Open 7 GB a 9 euro/4 sett navighi veloce con 7 GB di 
Internet e hai 200 minuti ed SMS a 15 cent. Passa a Tiscali Mobile! 
http://tisca.li/Open7GB0617




___
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

[Qgis-user] QGIS + PostGIS in production environment

[Cap Diniz]

Hello,

I am from the Cartographic Production Department from the Brazilian Army,
and we are trying to migrate from ArcGIS to QGIS+PostGIS.

We are currently using QGIS 2.14.15, and we mostly do data digitizing over
an orthoimage. We have about 50 simultaneous users in a single PostGIS
server, but in different databases.

I would like to know if there are any tips to improve performance and QGIS
reliability, such as tuning PostgreSQL, operating systems, hardware
recommendations, or QGIS specifics.


Regards,
Felipe Diniz
___
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 - virtual layers

[David_James]

Jozef Riha wrote
> hello list,
> 
> not sure if this is a known problem but during virtual layers feature
> testing i discovered that this tool has issues when source used in query
> contains characters such as space, forward slash, dash and possibly others
> in column names. it would be nice if user would be presented with a
> meaningful error message rather than a cryptic message about syntax error.
> 
> to reproduce:
> - import test.geojson to qgis
> - add virtual layer - run select * from test
> - you'll get:
> 
> Query execution error on DROP TABLE IF EXISTS "test"; CREATE VIRTUAL TABLE
> "test" USING QgsVLayer(test20160305235656402);: 1 - near "1": syntax error
> 
> br, j

Replying to a message that is over a year old ...

Virtual layer creation also errors with a cryptic error message if a column
name is "Update" - I suspect it will fail if column names are any SQL
reserved words. 

This is probably obvious, but it has taken me a couple of hours to realise
what the problem was and I would probably have never realised if Google had
not found Jozef Riha's posting for me.

(QGIS 2.18.2 on Windows)





--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/qgis-virtual-layers-tp5254623p5324368.html
Sent from the QGIS - User mailing list archive at Nabble.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] Training in QGIS

[Tudorache, Marian]

Hi everyone,

I am interested in finding an official instructor in QGIS to provide training 
in Ottawa/Gatineau region, Canada.

Thank you,
Marian



This electronic message, as well as any transmitted files included in the 
electronic message, may contain privileged or confidential information and is 
intended solely for the use of the individual(s) or entity to which it is 
addressed. If you have received this electronic message in error please notify 
the sender immediately and delete the electronic message. Any unauthorized 
copying, disclosure or distribution of the electronic message is strictly 
forbidden. NAV CANADA accepts no liability for any damage caused by any virus 
and/or other malicious code transmitted by this electronic communication.

Le présent message électronique et tout fichier qui peut y être joint peuvent 
contenir des renseignements privilégiés ou confidentiels destinés à l’usage 
exclusif des personnes ou des organismes à qui ils s’adressent. Si vous avez 
reçu ce message électronique par erreur, veuillez en informer l’expéditeur 
immédiatement et supprimez le. Toute reproduction, divulgation ou distribution 
du présent message électronique est strictement interdite. NAV CANADA n’assume 
aucune responsabilité en cas de dommage causé par tout virus ou autre programme 
malveillant transmis par ce message électronique.
___
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