Re: [Qgis-user] geoprocessing tools - 2.14.3

[DelazJ]

Hi,
Did you activate the FTools plugin in the Plugin Manager?

2016-05-27 4:45 GMT+02:00 Laurence Béchet :

> Hi
>
> I must be blind, but could someone tell me where the buffer tool and the
> geoprocessing tools are gone? Nothing under Vector/
> I'm working with qgis 2.14.3 (code cf2ebb8) on windows7 pro 64bits
>
> Thanks!
> Laurence
> ___
> 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

[Qgis-user] geoprocessing tools - 2.14.3

[Laurence Béchet]

Hi

I must be blind, but could someone tell me where the buffer tool and the 
geoprocessing tools are gone? Nothing under Vector/

I'm working with qgis 2.14.3 (code cf2ebb8) on windows7 pro 64bits

Thanks!
Laurence
___
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

[Samuel Ingarfield]

Ah, perfect. Enclosing the query in brackets did the trick.
Thanks Jürgen!

Cheers;
Sam.

On Thu, May 26, 2016 at 8:48 PM, Jürgen E.  wrote:

> Hi Samuel,.
>
> On Thu, 26. May 2016 at 15:33:44 +0800, Samuel Ingarfield wrote:
> > 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?
>
> Did you enclose the query in ()?
>
> Jürgen
>
> --
> Jürgen E. Fischer   norBIT GmbH Tel.
> +49-4931-918175-31
> Dipl.-Inf. (FH) Rheinstraße 13  Fax.
> +49-4931-918175-50
> Software Engineer   D-26506 Norden
> http://www.norbit.de
> QGIS release manager (PSC)  GermanyIRC: jef on FreeNode
>
___
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] Is QGIS showing the records with geometry NULL

[Paul Paris]

Hi Andrea,

Might something like:

In the 'Select by Expression' dialog:

$geometry = null

work?






On Thu, May 26, 2016 at 10:53 AM, Andrea Peri  wrote:

> Hi jukka.
> I guess empty geometry is a not null geometry.
> Il 26 mag 2016 4:34 PM, "Rahkonen Jukka (MML)" <
> jukka.rahko...@maanmittauslaitos.fi> ha scritto:
>
>> Hi,
>>
>> We spent some time with empty geometries in OpenJUMP and I attach some
>> test data from those experiments. Feel free to use it in the QGIS feature
>> request. Zip contains point, line, and polygon shapefiles, each having 8
>> features but only one feature with geometry.  From the WKT files you can
>> see that there are actually different kind of empty geometries. I even did
>> not bother to think about Z, M, and ZM geometries.
>>
>> POINT EMPTY
>> MULTIPOINT EMPTY
>> LINESTRING EMPTY
>> MULTILINESTRING EMPTY
>> POLYGON EMPTY
>> MULTIPOLYGON EMPTY
>> GEOMETRYCOLLECTION EMPTY
>>
>> One may say that empty is always just empty but one needs also to think
>> what happens if user copies POLYGON EMPTY and tries to paste it into a
>> point layer. Should copy be denied or empty geometry converted into POINT
>> EMPTY? For OpenJUMP that does not matter because it can handle all kind of
>> geometries on the same layer. However, saving POINT EMPTY into polygon
>> shapefile may fail and therefore OpenJUMP can convert even empty geometries
>> like POINT EMPTY ->POLYGON EMPTY.
>>
>> -Jukka Rahkonen-
>>
>> Andrea Peri wrote:
>>
>> Hi Jukka,
>> yes is exactly this the question.
>>
>> The QGIS don't show any record with null geometry so is impossible for me
>> to add a geometry to it. Or delete it definitivelly.
>>
>> But the record with null geometry is however saved when I export the
>> shapefile from qgis.
>>
>> So the QGIS show me 14 records but export a shapefile with 16 records
>> (2 records has null geometry).
>>
>> So when load it in a spatialite or on a postgis environment or open it
>> using another GIS like arcview3 from esri.
>> I see this two more records with null geometry.
>>
>> AFAIK this is a chaotic situation for who work using qgis and produce a
>> shapefile to distribute to other users that has other gis softwares.
>>
>> A.
>>
>>
>> 2016-05-26 10:24 GMT+02:00 Jukka Rahkonen <
>> jukka.rahko...@maanmittauslaitos.fi>:
>> > Nicolas Cadieux  writes:
>> >
>> >>
>> >>
>> >> Hi,
>> >> Is it possible that the 2 missing records were deleted in another GIS?
>> > There is an issue with deleting records in shape file as there are
>> > many ways to do that.  If the record were deleted in another GIS, they
>> > may show up (or
>> > not) in another software. Could that be it...
>> >> Nicolas
>> >
>> > Hi,
>> >
>> > I suppose that Andrea means a valid situation with real existing
>> > features which just do not have geometry. They are valid in shapefiles
>> > but many GIS software have difficulties in dealing with them.
>> > Naturally they cannot be showed on the map and spatial queries can't
>> > find them but they should be found from attribute view and be editable
>> there.
>> >
>> > -Jukka Rahkonen-
>> > ___
>> > 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
>>
>>
>>
>> --
>> -
>> Andrea Peri
>> . . . . . . . . .
>> qwerty àèìòù
>> -
>>
>
> ___
> 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

Re: [Qgis-user] Is QGIS showing the records with geometry NULL

[Andrea Peri]

Hi jukka.
I guess empty geometry is a not null geometry.
Il 26 mag 2016 4:34 PM, "Rahkonen Jukka (MML)" <
jukka.rahko...@maanmittauslaitos.fi> ha scritto:

> Hi,
>
> We spent some time with empty geometries in OpenJUMP and I attach some
> test data from those experiments. Feel free to use it in the QGIS feature
> request. Zip contains point, line, and polygon shapefiles, each having 8
> features but only one feature with geometry.  From the WKT files you can
> see that there are actually different kind of empty geometries. I even did
> not bother to think about Z, M, and ZM geometries.
>
> POINT EMPTY
> MULTIPOINT EMPTY
> LINESTRING EMPTY
> MULTILINESTRING EMPTY
> POLYGON EMPTY
> MULTIPOLYGON EMPTY
> GEOMETRYCOLLECTION EMPTY
>
> One may say that empty is always just empty but one needs also to think
> what happens if user copies POLYGON EMPTY and tries to paste it into a
> point layer. Should copy be denied or empty geometry converted into POINT
> EMPTY? For OpenJUMP that does not matter because it can handle all kind of
> geometries on the same layer. However, saving POINT EMPTY into polygon
> shapefile may fail and therefore OpenJUMP can convert even empty geometries
> like POINT EMPTY ->POLYGON EMPTY.
>
> -Jukka Rahkonen-
>
> Andrea Peri wrote:
>
> Hi Jukka,
> yes is exactly this the question.
>
> The QGIS don't show any record with null geometry so is impossible for me
> to add a geometry to it. Or delete it definitivelly.
>
> But the record with null geometry is however saved when I export the
> shapefile from qgis.
>
> So the QGIS show me 14 records but export a shapefile with 16 records
> (2 records has null geometry).
>
> So when load it in a spatialite or on a postgis environment or open it
> using another GIS like arcview3 from esri.
> I see this two more records with null geometry.
>
> AFAIK this is a chaotic situation for who work using qgis and produce a
> shapefile to distribute to other users that has other gis softwares.
>
> A.
>
>
> 2016-05-26 10:24 GMT+02:00 Jukka Rahkonen <
> jukka.rahko...@maanmittauslaitos.fi>:
> > Nicolas Cadieux  writes:
> >
> >>
> >>
> >> Hi,
> >> Is it possible that the 2 missing records were deleted in another GIS?
> > There is an issue with deleting records in shape file as there are
> > many ways to do that.  If the record were deleted in another GIS, they
> > may show up (or
> > not) in another software. Could that be it...
> >> Nicolas
> >
> > Hi,
> >
> > I suppose that Andrea means a valid situation with real existing
> > features which just do not have geometry. They are valid in shapefiles
> > but many GIS software have difficulties in dealing with them.
> > Naturally they cannot be showed on the map and spatial queries can't
> > find them but they should be found from attribute view and be editable
> there.
> >
> > -Jukka Rahkonen-
> > ___
> > 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
>
>
>
> --
> -
> Andrea Peri
> . . . . . . . . .
> qwerty àèìòù
> -
>
___
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] Is QGIS showing the records with geometry NULL

[Saber Razmjooei]

Could this be a regression, see this:
http://hub.qgis.org/issues/11007

Cheers,
Saber


-Original Message-
From: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of 
Rahkonen Jukka (MML)
Sent: 26 May 2016 15:35
To: Andrea Peri
Cc: qgis-user
Subject: Re: [Qgis-user] Is QGIS showing the records with geometry NULL

Hi,

We spent some time with empty geometries in OpenJUMP and I attach some test 
data from those experiments. Feel free to use it in the QGIS feature request. 
Zip contains point, line, and polygon shapefiles, each having 8 features but 
only one feature with geometry.  From the WKT files you can see that there are 
actually different kind of empty geometries. I even did not bother to think 
about Z, M, and ZM geometries.

POINT EMPTY
MULTIPOINT EMPTY
LINESTRING EMPTY
MULTILINESTRING EMPTY
POLYGON EMPTY
MULTIPOLYGON EMPTY
GEOMETRYCOLLECTION EMPTY

One may say that empty is always just empty but one needs also to think what 
happens if user copies POLYGON EMPTY and tries to paste it into a point layer. 
Should copy be denied or empty geometry converted into POINT EMPTY? For 
OpenJUMP that does not matter because it can handle all kind of geometries on 
the same layer. However, saving POINT EMPTY into polygon shapefile may fail and 
therefore OpenJUMP can convert even empty geometries like POINT EMPTY ->POLYGON 
EMPTY.

-Jukka Rahkonen-

Andrea Peri wrote:

Hi Jukka,
yes is exactly this the question.

The QGIS don't show any record with null geometry so is impossible for me to 
add a geometry to it. Or delete it definitivelly.

But the record with null geometry is however saved when I export the shapefile 
from qgis.

So the QGIS show me 14 records but export a shapefile with 16 records
(2 records has null geometry).

So when load it in a spatialite or on a postgis environment or open it using 
another GIS like arcview3 from esri.
I see this two more records with null geometry.

AFAIK this is a chaotic situation for who work using qgis and produce a 
shapefile to distribute to other users that has other gis softwares.

A.


2016-05-26 10:24 GMT+02:00 Jukka Rahkonen :
> Nicolas Cadieux  writes:
>
>>
>>
>> Hi,
>> Is it possible that the 2 missing records were deleted in another GIS?
> There is an issue with deleting records in shape file as there are 
> many ways to do that.  If the record were deleted in another GIS, they 
> may show up (or
> not) in another software. Could that be it...
>> Nicolas
>
> Hi,
>
> I suppose that Andrea means a valid situation with real existing 
> features which just do not have geometry. They are valid in shapefiles 
> but many GIS software have difficulties in dealing with them.
> Naturally they cannot be showed on the map and spatial queries can't 
> find them but they should be found from attribute view and be editable there.
>
> -Jukka Rahkonen-
> ___
> 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



--
-
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-


--
This email and any files transmitted with it are confidential and intended 
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager. This 
message contains confidential information and is intended only for the
individual named. If you are not the named addressee you should not 
disseminate, distribute or copy this e-mail. Please notify the sender 
immediately
by e-mail if you have received this e-mail by mistake and delete this e-mail 
from your system. If you are not the intended recipient you are notified
that disclosing, copying, distributing or taking any action in reliance on the 
contents of this information is strictly prohibited.

Whilst reasonable care has been taken to avoid virus transmission, no 
responsibility for viruses is taken and it is your responsibility to carry out
such checks as you feel appropriate.

If this email contains a quote or offer to sell products, carry out work or 
perform services then our standard terms and conditions (which can be found at 
http://www.lutraconsulting.co.uk/downloads/Lutra%20Consulting%20Standard%20Terms%20and%20Conditions.pdf
 shall apply unless explicitly stated otherwise.

Saber Razmjooei and Peter Wells trading as Lutra Consulting.
___
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] Is QGIS showing the records with geometry NULL

[Andrea Peri]

Hi Jukka,
yes is exactly this the question.

The QGIS don't show any record with null geometry so is impossible for
me to add a geometry to it. Or delete it definitivelly.

But the record with null geometry is however saved when I export the
shapefile from qgis.

So the QGIS show me 14 records but export a shapefile with 16 records
(2 records has null geometry).

So when load it in a spatialite or on a postgis environment or open it
using another GIS like arcview3 from esri.
I see this two more records with null geometry.

AFAIK this is a chaotic situation for who work using qgis and produce
a shapefile to distribute to other users that has other gis softwares.

A.


2016-05-26 10:24 GMT+02:00 Jukka Rahkonen :
> Nicolas Cadieux  writes:
>
>>
>>
>> Hi,
>> Is it possible that the 2 missing records were deleted in another GIS?
> There is an issue with deleting records in shape file as there are many ways
> to do that.  If the record were deleted in another GIS, they may show up (or
> not) in another software. Could that be it...
>> Nicolas
>
> Hi,
>
> I suppose that Andrea means a valid situation with real existing features
> which just do not have geometry. They are valid in shapefiles but many GIS
> software have difficulties in dealing with them. Naturally they cannot be
> showed on the map and spatial queries can't find them but they should be
> found from attribute view and be editable there.
>
> -Jukka Rahkonen-
> ___
> 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



-- 
-
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-
___
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

[Jürgen E . Fischer]

Hi Samuel,.

On Thu, 26. May 2016 at 15:33:44 +0800, Samuel Ingarfield wrote:
> 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?

Did you enclose the query in ()?

Jürgen

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Norden http://www.norbit.de
QGIS release manager (PSC)  GermanyIRC: jef on FreeNode 



pgpLKL56St3uI.pgp
Description: PGP signature
___
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] SQL display expression

[Christoph Lauber]

Hi Andreas

 

Even my answer comes late…

Thanks for your reply and propositions.

I tried all 3 possibilities and the attribute(getFeature(…)) solution works 
perfectly for my needs.

 

With “not related” I meant, that the main table and the domain table (list 
lookup) only have a relation by an intermediate table. I think you understood 
right :)

 

 

 

Freundliche Grüsse

Christoph Lauber

 

Von: Neumann, Andreas [mailto:a.neum...@carto.net] 
Gesendet: Dienstag, 10. Mai 2016 15:31
An: Christoph Lauber 
Cc: qgis-user@lists.osgeo.org
Betreff: Re: [Qgis-user] SQL display expression

 

Hi Christoph,

Are you talking about the left column in the forms view?

What do you mean by "not related"? Do you mean related, but not contained in 
the same table?

Is this for a value list lookup?

For a 1:1 relation?

QGIS expressions don't know "SELECT". The expression always works on a single 
feature. It can't return records. 

There could be several ways to do what you want:

1. use joins (layer properties --> joins)

2. use the attribute(getFeature()) expression

3. Create a virtual layer (starting from version 2.14) --> see 
https://docs.qgis.org/testing/en/docs/user_manual/working_with_vector/virtual_layers.html

I hope that one of the above ways help you solve your problem.

Greetings,

Andreas

On 2016-05-10 14:23, Christoph Lauber wrote:

Hi

 

I have a question about the display expression for forms.  The aim is to show 
data of a table that is not related by QGIS.

 

What I would like to do is to write a SQL to my SpatiaLite database to fetch 
some data. I suppose, that the display expression is restricted to the “select 
column” clause like: “"pkuid"   ||  ' '  || CASE WHEN art = 1 THEN 'this' ELSE 
'that' END”. When I put a select clause in it like “CASE WHEN "art" THEN 
(SELECT value FROM WI_D_Inventar_Art WHERE id = "art") ELSE 'Undefined' END” I 
get an expression is invalid error (the expression works in spatialite_gui). It 
seems that the SELECT keyword is not accepted.

 

Is there any possibility to write “free” SQL-Syntax for the display expression?

 

I wrote already a function that connects to the database, fetchs the data and 
closes the database. It works, but it is slow.

 

Thanks for your help.

 

Freundliche Grüsse

Christoph Lauber

 

*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*
GeoplanTeam AG dipl. Ing. ETH/SIA Hutzli+Kluser
Vermessung | Geoinformatik | Umwelttechnik
Egliweg 6, CH - 2560 Nidau
Phone:(+41) - 032 332 78 00
Fax:(+41) - 032 332 78 01
Web:   www.geoplanteam.ch
E-Mail:   
christoph.lau...@geoplanteam.ch
*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*

 

 

___
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

Re: [Qgis-user] Very slow getCapabilities with materialized view

[Régis Haubourg]

-- I post this again since I had trouble posting from nabble ---

Hi Nicolas, 
we faced the very same issue here. 
A lot of improvements have been done in qgis server 2.14.2, those queries
are now not reevaluated at each tile, but only on project load. 

I didn't dig too much on materialized views since we use  mostly views, that
should be fast, except for estimated extent. 

Reading extent from project properties and not data has been discussed on
dev list here  [0] and is an acceptable solution. 

If you are available for sharing costs of such a new feature, we already
wanted to have it done. Mail me in private about it. 

[0]
http://osgeo-org.1560.x6.nabble.com/Server-performance-questions-tp5252233.html

Cheers 
Régis



-
--
Régis Haubourg
GIS administrator and project manager
Administrateur de données géographiques et chef de projet SIG
Agence de l'eau Adour-Garonne 

--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/Very-slow-getCapabilities-with-materialized-view-tp5268175p5268338.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

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

[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
>
___
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] Print composer fails on print or export

[Carlo Cormio]

Thanks again Alexandre, but there's a problem with Quickmapservices 
plugin (Error message: No module named requests), on QGIS 2.14.3.



Il 26/05/2016 10:08, Alexandre Neto ha scritto:


Use quickwebservices plugin instead of openlayers plugin. It works 
better. You may have luck with it.



A qui, 26/05/2016, 08:29, Carlo Cormio > escreveu:


Thank you Alexandre, it works without Bing map. Is it due to a bug
o to some copyright restrictions?

Bye,

Carlo


Il 26/05/2016 08:09, Alexandre Neto ha scritto:


Please try removing bing maps. Also, try exporting the PDF directly.


A qua, 25/05/2016, 20:46, CARLO CORMIO > escreveu:

Dear All,

I'm trying to print a couple of maps (with rasters, vectors
and bing maps) in a canvas through QGIS map composer. Setting
the composition (adding map, text, scale, etc) works fine, as
always, but when I try to print or export it in any file
format the canvas disappear, no error message pops up, no
hardware runs (no lights blinking on my PC).

Page setup is custom (170 x 100 mm) and the maps reach page
border, I don't know if this could be a problem.

I had the same problem with different QGIS versione (2.12 and
2.14), so maybe it is a local problem. Any idea? I'm working
on Windows 10 64 bit, and use PDFCreator as pdf printer.

Thanks in advance,

Carlo

___
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

-- 
Alexandre Neto

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


--
Alexandre Neto
-
@AlexNetoGeo
http://sigsemgrilhetas.wordpress.com
http://gisunchained.wordpress.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] Is QGIS showing the records with geometry NULL

[Jukka Rahkonen]

Nicolas Cadieux  writes:

> 
> 
> Hi,
> Is it possible that the 2 missing records were deleted in another GIS?
There is an issue with deleting records in shape file as there are many ways
to do that.  If the record were deleted in another GIS, they may show up (or
not) in another software. Could that be it... 
> Nicolas

Hi,

I suppose that Andrea means a valid situation with real existing features
which just do not have geometry. They are valid in shapefiles but many GIS
software have difficulties in dealing with them. Naturally they cannot be
showed on the map and spatial queries can't find them but they should be
found from attribute view and be editable there.

-Jukka Rahkonen-
___
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

[QGIS-it-user] plugin QuickMapServices

[falcerisim...@inwind.it]

Salve,
il plugin QuickMapServices
a voi funziona? permette di vedere anche OSM a scale bassissime


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

Re: [Qgis-user] Print composer fails on print or export

[Alexandre Neto]

Use quickwebservices plugin instead of openlayers plugin. It works better.
You may have luck with it.

A qui, 26/05/2016, 08:29, Carlo Cormio  escreveu:

> Thank you Alexandre, it works without Bing map. Is it due to a bug o to
> some copyright restrictions?
>
> Bye,
>
> Carlo
>
> Il 26/05/2016 08:09, Alexandre Neto ha scritto:
>
> Please try removing bing maps. Also, try exporting the PDF directly.
>
> A qua, 25/05/2016, 20:46, CARLO CORMIO  escreveu:
>
>> Dear All,
>>
>> I'm trying to print a couple of maps (with rasters, vectors and bing
>> maps) in a canvas through QGIS map composer. Setting the composition
>> (adding map, text, scale, etc) works fine, as always, but when I try to
>> print or export it in any file format the canvas disappear, no error
>> message pops up, no hardware runs (no lights blinking on my PC).
>>
>> Page setup is custom (170 x 100 mm) and the maps reach page border, I
>> don't know if this could be a problem.
>>
>> I had the same problem with different QGIS versione (2.12 and 2.14), so
>> maybe it is a local problem. Any idea? I'm working on Windows 10 64 bit,
>> and use PDFCreator as pdf printer.
>>
>> Thanks in advance,
>>
>> Carlo
>> ___
>> 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
>
> --
> Alexandre Neto
> -
> @AlexNetoGeo
> http://sigsemgrilhetas.wordpress.com
> http://gisunchained.wordpress.com
>
>
> --
Alexandre Neto
-
@AlexNetoGeo
http://sigsemgrilhetas.wordpress.com
http://gisunchained.wordpress.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

[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 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
___
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

[Qgis-user] Very long sql in postgres layer definition

[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.
___
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] Print composer fails on print or export

[Carlo Cormio]

Thank you Alexandre, it works without Bing map. Is it due to a bug o to 
some copyright restrictions?


Bye,

Carlo


Il 26/05/2016 08:09, Alexandre Neto ha scritto:


Please try removing bing maps. Also, try exporting the PDF directly.


A qua, 25/05/2016, 20:46, CARLO CORMIO > escreveu:


Dear All,

I'm trying to print a couple of maps (with rasters, vectors and
bing maps) in a canvas through QGIS map composer. Setting the
composition (adding map, text, scale, etc) works fine, as always,
but when I try to print or export it in any file format the canvas
disappear, no error message pops up, no hardware runs (no lights
blinking on my PC).

Page setup is custom (170 x 100 mm) and the maps reach page
border, I don't know if this could be a problem.

I had the same problem with different QGIS versione (2.12 and
2.14), so maybe it is a local problem. Any idea? I'm working on
Windows 10 64 bit, and use PDFCreator as pdf printer.

Thanks in advance,

Carlo

___
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

--
Alexandre Neto
-
@AlexNetoGeo
http://sigsemgrilhetas.wordpress.com
http://gisunchained.wordpress.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