date:20131022

Yes, I believe it is. At least the fact that only closing QGIS releases the
locks.
You can even create several locks on the same table if you keep removing
and adding the same table.

But, is it expected that a QGIS client can lock a postgis view in such way
that I can not even run a trigger on a related table? When I tried, QGIS
just hangs until I close the process in Postgresql. The opposite happens
when I try to delete a View via Pgadmin that is opened in QGIS, pgadmin
hangs until I close QGIS.

Thanks,

Alexandre




On Mon, Oct 21, 2013 at 8:56 PM, Nyall Dawson nyall.daw...@gmail.comwrote:


 Shared locks for select queries are ok (that's how postgres works) but
 they must be released once cursors are closed (or even deleted).

 Please, file a ticket on the QGIS trac [1].



 There's already a report with some details regarding this:
 http://hub.qgis.org/issues/7679

 I think it's related.

 Cheers,
 Nyall


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

[Qgis-user] Multiple lines label in QGIS 2.0 print composer using wrap on character?

Hello all,

Is there a way to create multiple lines label using a wrap on character in
QGIS 2.0 print composer? Or this must be done with html rendering?

I'm using atlas generation and the label source is attribute from my
coverage layer.

Thanks,

Alexandre Neto
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Problem with WMS 1.1.1 data providers in QGIS 2.0.1

2013-10-22 Thread Jonathan Moules

Looking at the specs briefly, it doesn't seem like the ability to set DPI
explicitly is specified in WMS 1.1.0 or 1.3.0.
I guess that MapServer can't handle stuff it's not expecting. Maybe a
config option as Richard suggests.

Jonathan



On 21 October 2013 19:32, Richard Duivenvoorde rdmaili...@duif.net wrote:

 On 21-10-13 20:07, Miguel Ángel Castro wrote:
  I am using QGIS 2.0.1 standalone installed in a  Windows 7 64 bits
 system.
 
  Example of WMS datasource: (datasource WMS 1.1.1) EPSG:32628
 
  http://idecan2.grafcan.es/ServicioWMS/EspNat
 
  In layer properties/metadata you can see the information from
  datasource, but no display the layer (not load data) in canvas.
 
  In log messages: Map request error (status: 200  getDouble(): Symbol
  definition error. Parsing error near (96): (line 1).
 
  Does anybody have an idea what is the problem?

 Hi Miguel,

 the error message that you see is a (Minnesota) Mapserver error message.
 Somewhere in the style definitions it expects a number (or not).

 This url I get from QGIS in debug mode, and gives you your error:


 http://idecan2.grafcan.es/ServicioWMS/EspNat?SERVICE=WMSVERSION=1.1.1REQUEST=GetMapBBOX=152208.544610834447667,2940195.98510535480454564,692329.70807293173857033,3376338.62686863588169217SRS=EPSG:32628WIDTH=670HEIGHT=541LAYERS=EENNSTYLES=FORMAT=image/pngDPI=96MAP_RESOLUTION=96TRANSPARENT=TRUE

 Bug if I remove the DPI=96MAP_RESOLUTION=96 part from it, I get a map:


 http://idecan2.grafcan.es/ServicioWMS/EspNat?SERVICE=WMSVERSION=1.1.1REQUEST=GetMapBBOX=152208.544610834447667,2940195.98510535480454564,692329.70807293173857033,3376338.62686863588169217SRS=EPSG:32628WIDTH=670HEIGHT=541LAYERS=EENNSTYLES=FORMAT=image/png

 I'm not familiar with the exact WMS-standard, but as most WMS servers I
 know (and use) can handle these two query parameters from QGIS, I think
 it is a Mapserver configuration problem/error. You cannot let QGIS
 remove those params I think.

 Regards,


 Richard Duivenvoorde
 ___
 Qgis-user mailing list
 Qgis-user@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/qgis-user


-- 
This transmission is intended for the named addressee(s) only and may 
contain sensitive or protectively marked material up to RESTRICTED and 
should be handled accordingly. Unless you are the named addressee (or 
authorised to receive it for the addressee) you may not copy or use it, or 
disclose it to anyone else. If you have received this transmission in error 
please notify the sender immediately. All email traffic sent to or from us, 
including without limitation all GCSX traffic, may be subject to recording 
and/or monitoring in accordance with relevant legislation.
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] problem reading csv file (numbers read as strings)

2013-10-22 Thread Matteo Ghetta

Hi all,
I work with a debian machine, QGIS 2 and libreoffice 3.
I wrote a table with some field (two of them are x and y coordinates),
saved as csv and then I tried to upload it in qgis with the add delimited
text option.

Problem: numeric filed are read as strings and not as numbers and so I
cannot convert the table in a point shape (in Libreoffice numbers are read
as numbers and I can do some calculation with them).
It seems that it doesn't matter if a numeric field has a decimal part or
not, qgis does not recognize them as numbers anyway.

Any help is appreciated

Cheers

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

[Qgis-user] db-manager (temporary tables)

Hi,

Is there a way to access temporary tables through db-manager?

From what I get, this is only possible through layer-add postgis layer
(also not available in the browser panel).

Thanks,
António
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] db-manager (temporary tables)

Hi,

You can load query results in db-manager.

Just create a query in db-manager, select the primary key column and the
geometry column and load it.

Works fine for me.

Andreas

Am 22.10.2013 13:42, schrieb António M. Rodrigues:
 Hi,
 
 Is there a way to access temporary tables through db-manager?
 
 From what I get, this is only possible through layer-add postgis layer
 (also not available in the browser panel).
 
 Thanks,
 António
 
 
 
 ___
 Qgis-user mailing list
 Qgis-user@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/qgis-user
 

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

Re: [Qgis-user] db-manager (temporary tables)

The thing is I have some custom functions which output temp tables. And it
would be useful to be able to explore these tables in db-manager.

I guess it shouldn't be too difficult to tweak dbmanager.
I was looking at the source code for but unfortunately my knowledge of
pyqgis is not quite there (maybe one day... :--) ).

António


2013/10/22 Andreas Neumann a.neum...@carto.net

 Hi,

 You can load query results in db-manager.

 Just create a query in db-manager, select the primary key column and the
 geometry column and load it.

 Works fine for me.

 Andreas

 Am 22.10.2013 13:42, schrieb António M. Rodrigues:
  Hi,
 
  Is there a way to access temporary tables through db-manager?
 
  From what I get, this is only possible through layer-add postgis layer
  (also not available in the browser panel).
 
  Thanks,
  António
 
 
 
  ___
  Qgis-user mailing list
  Qgis-user@lists.osgeo.org
  http://lists.osgeo.org/mailman/listinfo/qgis-user
 

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

Re: [Qgis-user] db-manager (temporary tables)

What do you mean by temp tables?

There are no temp tables in a database. Either it is a table, a view
or a table. All of these can already be opened with DB manager.

Andreas

Am 22.10.2013 13:57, schrieb António M. Rodrigues:
 The thing is I have some custom functions which output temp tables. And it
 would be useful to be able to explore these tables in db-manager.
 
 I guess it shouldn't be too difficult to tweak dbmanager.
 I was looking at the source code for but unfortunately my knowledge of
 pyqgis is not quite there (maybe one day... :--) ).
 
 António
 
 
 2013/10/22 Andreas Neumann a.neum...@carto.net
 
 Hi,

 You can load query results in db-manager.

 Just create a query in db-manager, select the primary key column and the
 geometry column and load it.

 Works fine for me.

 Andreas

 Am 22.10.2013 13:42, schrieb António M. Rodrigues:
 Hi,

 Is there a way to access temporary tables through db-manager?

 From what I get, this is only possible through layer-add postgis layer
 (also not available in the browser panel).

 Thanks,
 António



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


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

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

Re: [Qgis-user] problem reading csv file (numbers read as strings)


Hard to comment without example.

Best regards,
Karlis

Matteo Ghetta wrote:

..
I wrote a table with some field (two of them are x and y coordinates),
saved as csv and then I tried to upload it in qgis with the add
delimited text option.

Problem: numeric filed are read as strings and not as numbers ..

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

Re: [Qgis-user] db-manager (temporary tables)

In postgres I can use 'create temporary table...' which will create a new
object which only exists in the present session. It can only be stored in
special schemas (which can be accessed from layer-- add postgis layer),
called pg_tmp_'some integer'.

I was just saying it would be nice to be able to browse these objects in
db_manager. Of course I can do this in the command line with psql.

António


2013/10/22 Andreas Neumann a.neum...@carto.net

 What do you mean by temp tables?

 There are no temp tables in a database. Either it is a table, a view
 or a table. All of these can already be opened with DB manager.

 Andreas

 Am 22.10.2013 13:57, schrieb António M. Rodrigues:
  The thing is I have some custom functions which output temp tables. And
 it
  would be useful to be able to explore these tables in db-manager.
 
  I guess it shouldn't be too difficult to tweak dbmanager.
  I was looking at the source code for but unfortunately my knowledge of
  pyqgis is not quite there (maybe one day... :--) ).
 
  António
 
 
  2013/10/22 Andreas Neumann a.neum...@carto.net
 
  Hi,
 
  You can load query results in db-manager.
 
  Just create a query in db-manager, select the primary key column and the
  geometry column and load it.
 
  Works fine for me.
 
  Andreas
 
  Am 22.10.2013 13:42, schrieb António M. Rodrigues:
  Hi,
 
  Is there a way to access temporary tables through db-manager?
 
  From what I get, this is only possible through layer-add postgis layer
  (also not available in the browser panel).
 
  Thanks,
  António
 
 
 
  ___
  Qgis-user mailing list
  Qgis-user@lists.osgeo.org
  http://lists.osgeo.org/mailman/listinfo/qgis-user
 
 
  ___
  Qgis-user mailing list
  Qgis-user@lists.osgeo.org
  http://lists.osgeo.org/mailman/listinfo/qgis-user
 


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

Re: [Qgis-user] db-manager (temporary tables)

ok - wasn't aware of that.

What is the advantage of using these temp tables? That you do not have
to deal with deleting the table?

I am not too familiar with the internals of db-manager. Does it
establish a session? Probably Giuseppe Sucameli can help.

Andreas

Am 22.10.2013 14:10, schrieb António M. Rodrigues:
 In postgres I can use 'create temporary table...' which will create a new
 object which only exists in the present session. It can only be stored in
 special schemas (which can be accessed from layer-- add postgis layer),
 called pg_tmp_'some integer'.
 
 I was just saying it would be nice to be able to browse these objects in
 db_manager. Of course I can do this in the command line with psql.
 
 António
 
 
 2013/10/22 Andreas Neumann a.neum...@carto.net
 
 What do you mean by temp tables?

 There are no temp tables in a database. Either it is a table, a view
 or a table. All of these can already be opened with DB manager.

 Andreas

 Am 22.10.2013 13:57, schrieb António M. Rodrigues:
 The thing is I have some custom functions which output temp tables. And
 it
 would be useful to be able to explore these tables in db-manager.

 I guess it shouldn't be too difficult to tweak dbmanager.
 I was looking at the source code for but unfortunately my knowledge of
 pyqgis is not quite there (maybe one day... :--) ).

 António


 2013/10/22 Andreas Neumann a.neum...@carto.net

 Hi,

 You can load query results in db-manager.

 Just create a query in db-manager, select the primary key column and the
 geometry column and load it.

 Works fine for me.

 Andreas

 Am 22.10.2013 13:42, schrieb António M. Rodrigues:
 Hi,

 Is there a way to access temporary tables through db-manager?

 From what I get, this is only possible through layer-add postgis layer
 (also not available in the browser panel).

 Thanks,
 António



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


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



 

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

Re: [Qgis-user] db-manager (temporary tables)

For me the advantage is simple: I have a few plpgsql functions which create
tables with variables computed from some quite large tables. I then use
these tables as input to create other result tables (with geometry).

And yes, the advantage is not to deal with multiple deleting in the end of
each session.

As you say, perhaps the best is to contact Giuseppe Sucameli to see whether
this could be improved (if of course is an useful feature for other users).

Thanks,
António



2013/10/22 Andreas Neumann a.neum...@carto.net

 ok - wasn't aware of that.

 What is the advantage of using these temp tables? That you do not have
 to deal with deleting the table?

 I am not too familiar with the internals of db-manager. Does it
 establish a session? Probably Giuseppe Sucameli can help.

 Andreas

 Am 22.10.2013 14:10, schrieb António M. Rodrigues:
  In postgres I can use 'create temporary table...' which will create a new
  object which only exists in the present session. It can only be stored in
  special schemas (which can be accessed from layer-- add postgis layer),
  called pg_tmp_'some integer'.
 
  I was just saying it would be nice to be able to browse these objects in
  db_manager. Of course I can do this in the command line with psql.
 
  António
 
 
  2013/10/22 Andreas Neumann a.neum...@carto.net
 
  What do you mean by temp tables?
 
  There are no temp tables in a database. Either it is a table, a view
  or a table. All of these can already be opened with DB manager.
 
  Andreas
 
  Am 22.10.2013 13:57, schrieb António M. Rodrigues:
  The thing is I have some custom functions which output temp tables. And
  it
  would be useful to be able to explore these tables in db-manager.
 
  I guess it shouldn't be too difficult to tweak dbmanager.
  I was looking at the source code for but unfortunately my knowledge of
  pyqgis is not quite there (maybe one day... :--) ).
 
  António
 
 
  2013/10/22 Andreas Neumann a.neum...@carto.net
 
  Hi,
 
  You can load query results in db-manager.
 
  Just create a query in db-manager, select the primary key column and
 the
  geometry column and load it.
 
  Works fine for me.
 
  Andreas
 
  Am 22.10.2013 13:42, schrieb António M. Rodrigues:
  Hi,
 
  Is there a way to access temporary tables through db-manager?
 
  From what I get, this is only possible through layer-add postgis
 layer
  (also not available in the browser panel).
 
  Thanks,
  António
 
 
 
  ___
  Qgis-user mailing list
  Qgis-user@lists.osgeo.org
  http://lists.osgeo.org/mailman/listinfo/qgis-user
 
 
  ___
  Qgis-user mailing list
  Qgis-user@lists.osgeo.org
  http://lists.osgeo.org/mailman/listinfo/qgis-user
 
 
 
 


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

Re: [Qgis-user] Problem with WMS 1.1.1 data providers in QGIS 2.0.1

Hi all,

I think the dpi parameter is a useful extension and should be added by
the QGIS client (given that the dpi are really correctly detected).

If a WMS server chokes on additional paramters it is not very well
designed. They can just ignore these extra parameters if they do not
know how to deal with it.

Just my opinion.

Andreas

Am 22.10.2013 10:30, schrieb Bernhard Ströbl:
 Hi all,
 
 I have a similar issue with geoserver.
 QGIS2 request is:
 http://my_internal_server/geoserver/ows?SERVICE=WMSVERSION=1.3.0REQUEST=GetMapBBOX=my_bboxCRS=my_crsWIDTH=242HEIGHT=278LAYERS=my_layerSTYLES=FORMAT=image/pngDPI=96MAP_RESOLUTION=96FORMAT_OPTIONS=dpi:96TRANSPARENT=TRUE
 
 entering this URL in the browser results in a geoserver error message.
 However if I leave out FORMAT_OPTIONS=dpi:96 (which, according to the
 geoserver docs [1] should be supported) the map image is returned.
 Two more remarks
 1) not all layers fail with this request
 2) QGIS 1.8 did not add this dpi-96 stuff, so all my layers worked in 1.8
 
 What was the reason to intoduce the dpi96 stuff and could we probably
 change that to a configurable option (yes/no) of the WMS connection?
 
 Bernhard
 
 [1] http://docs.geoserver.org/latest/en/user/services/wms/vendor.html
 
 Am 22.10.2013 10:12, schrieb Miguel Ángel Castro:
 Hi Richard,

 I can see what you show to me.

 But, this problem not takes place in QGIS 1.8.0 with this WMS data
 source (
 http://idecan2.grafcan.es/ServicioWMS/EspNat) and similar others.

 Something in wmsprovider.dll of QGIS 2.0.1?

 Thanks in advance
 Miguel Ángel Castro



 __ Information from ESET Mail Security, version of virus
 signature database 8948 (20131022) __

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

 
 
 __ Information from ESET Mail Security, version of virus
 signature database 8948 (20131022) __
 
 The message was checked by ESET Mail Security.
 http://www.eset.com
 
 
 ___
 Qgis-user mailing list
 Qgis-user@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/qgis-user

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

Re: [Qgis-user] Problem with WMS 1.1.1 data providers in QGIS 2.0.1

2013-10-22 Thread Andrea Peri

I agree.

Often is not known the kind of wms server so I apply always the
map_resolution and the dpi parameters.

2013/10/22 Andreas Neumann a.neum...@carto.net

Hi all,

I think the dpi parameter is a useful extension and should be added by
the QGIS client (given that the dpi are really correctly detected).

If a WMS server chokes on additional paramters it is not very well
designed. They can just ignore these extra parameters if they do not
know how to deal with it.

Just my opinion.

Andreas

Am 22.10.2013 10:30, schrieb Bernhard Ströbl:
Hi all,

I have a similar issue with geoserver.
QGIS2 request is:

http://my_internal_server/geoserver/ows?SERVICE=WMSVERSION=1.3.0REQUEST=GetMapBBOX=my_bboxCRS=my_crsWIDTH=242HEIGHT=278LAYERS=my_layerSTYLES=FORMAT=image/pngDPI=96MAP_RESOLUTION=96FORMAT_OPTIONS=dpi:96TRANSPARENT=TRUE

entering this URL in the browser results in a geoserver error message.
However if I leave out FORMAT_OPTIONS=dpi:96 (which, according to the
geoserver docs [1] should be supported) the map image is returned.
Two more remarks
1) not all layers fail with this request
2) QGIS 1.8 did not add this dpi-96 stuff, so all my layers worked in 1.8

What was the reason to intoduce the dpi96 stuff and could we probably
change that to a configurable option (yes/no) of the WMS connection?

Bernhard

[1] http://docs.geoserver.org/latest/en/user/services/wms/vendor.html

Am 22.10.2013 10:12, schrieb Miguel Ángel Castro:
Hi Richard,

I can see what you show to me.

But, this problem not takes place in QGIS 1.8.0 with this WMS data
source (
http://idecan2.grafcan.es/ServicioWMS/EspNat) and similar others.

Something in wmsprovider.dll of QGIS 2.0.1?

Thanks in advance
Miguel Ángel Castro

__ Information from ESET Mail Security, version of virus
signature database 8948 (20131022) __

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

__ Information from ESET Mail Security, version of virus
signature database 8948 (20131022) __

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

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

--
-
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] problem reading csv file (numbers read as strings)

Hello Matteo,

I was able to open without problems a csv file produced in libbreoffice.

The coordinates fields were considered doubles. my file was like this:

Ponto 1;12,4;0,7
Ponto 2;10;0,9
Ponto 3;11;10

If if it's not a decimal separator issue.

Hope this helps.

Alexandre


On Tue, Oct 22, 2013 at 12:58 PM, Matteo Ghetta matteo.ghe...@gmail.comwrote:

 So are the old practical way: write the coordinates in libreoffice, save
 the table as csv and import it with the csv option in qgis doesn't work
 anymore in qgis 2?

 I have to teach how to import in a simple way gps coordinate tables.. Do
 you have any suggestions?

 Thanks

 Matteo

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

Re: [Qgis-user] problem reading csv file (numbers read as strings)

2013-10-22 Thread Ramon Andiñach

True. A couple if lines would be helpful. Generally QGIS 2.0 is fairly good at 
guessing, so it would be interesting to see what's confusing it. 

Have you got the put apostrophes around text turned on?

If all else fails you can force QGIS to do what you want. 
http://anitagraser.com/2011/03/07/how-to-specify-data-types-of-csv-columns-for-use-in-qgis/

-ramon.

 On 22 Oct 2013, at 20:06, Zirneklitis e...@lanet.lv wrote:
 
 Hard to comment without example.
 
 Best regards,
 Karlis
 
 Matteo Ghetta wrote:
 ..
 I wrote a table with some field (two of them are x and y coordinates),
 saved as csv and then I tried to upload it in qgis with the add
 delimited text option.
 
 Problem: numeric filed are read as strings and not as numbers ..
 ___
 Qgis-user mailing list
 Qgis-user@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Problem with WMS 1.1.1 data providers in QGIS 2.0.1

2013-10-22 Thread Bernhard Ströbl

Hi Andreas,

Am 22.10.2013 14:44, schrieb Andreas Neumann:

Hi all,

I think the dpi parameter is a useful extension and should be added by
the QGIS client (given that the dpi are really correctly detected).

Correct, therefore QGIS adds this parameter in different flavours for
the most common WMS servers (I assume because this parameter is not
defined in the WMS standard as has already been pointed out in this thread).

If a WMS server chokes on additional paramters it is not very well
designed. They can just ignore these extra parameters if they do not
know how to deal with it.

My problem is not that geoserver chokes on the additional parameters but
that for _some_ layers the geoserver-specific parameter
format_options=dpi:96 makes it throw an error.
I know that these layers are poorly configured but cannot do anything
against it (because other software depends on them). My users currently
cannot access these layers. Miguel Ángel Castro (who started this
thread) described that he cannot access layers from
http://idecan2.grafcan.es/ServicioWMS/EspNat

Therefore I opt for a configuration option to switch off the dpi
parameter because public servers may be misconfigured and still people
want to display their layers in QGIS.

Bernhard

Just my opinion.

Andreas

Am 22.10.2013 10:30, schrieb Bernhard Ströbl:

Hi all,

I have a similar issue with geoserver.
QGIS2 request is:
http://my_internal_server/geoserver/ows?SERVICE=WMSVERSION=1.3.0REQUEST=GetMapBBOX=my_bboxCRS=my_crsWIDTH=242HEIGHT=278LAYERS=my_layerSTYLES=FORMAT=image/pngDPI=96MAP_RESOLUTION=96FORMAT_OPTIONS=dpi:96TRANSPARENT=TRUE

What was the reason to intoduce the dpi96 stuff and could we probably
change that to a configurable option (yes/no) of the WMS connection?

Bernhard

[1] http://docs.geoserver.org/latest/en/user/services/wms/vendor.html

Am 22.10.2013 10:12, schrieb Miguel Ángel Castro:

Hi Richard,

I can see what you show to me.

But, this problem not takes place in QGIS 1.8.0 with this WMS data
source (
http://idecan2.grafcan.es/ServicioWMS/EspNat) and similar others.

Something in wmsprovider.dll of QGIS 2.0.1?

Thanks in advance
Miguel Ángel Castro

__ Information from ESET Mail Security, version of virus
signature database 8948 (20131022) __

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

__ Information from ESET Mail Security, version of virus
signature database 8948 (20131022) __

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

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

__ Information from ESET Mail Security, version of virus signature
database 8949 (20131022) __

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

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

Re: [Qgis-user] Problem with WMS 1.1.1 data providers in QGIS 2.0.1

fair enough - if users are prevented to access these WMS layers, there
should be an option that would allow them to access the layers.

Yet another option to the WMS loading dialogue - sigh ...

Andreas

Am 22.10.2013 15:19, schrieb Bernhard Ströbl:
 Hi Andreas,
 
 Am 22.10.2013 14:44, schrieb Andreas Neumann:
 Hi all,

 I think the dpi parameter is a useful extension and should be added by
 the QGIS client (given that the dpi are really correctly detected).
 
 Correct, therefore QGIS adds this parameter in different flavours for
 the most common WMS servers (I assume because this parameter is not
 defined in the WMS standard as has already been pointed out in this
 thread).
 

 If a WMS server chokes on additional paramters it is not very well
 designed. They can just ignore these extra parameters if they do not
 know how to deal with it.
 
 My problem is not that geoserver chokes on the additional parameters but
 that for _some_ layers the geoserver-specific parameter
 format_options=dpi:96 makes it throw an error.
 I know that these layers are poorly configured but cannot do anything
 against it (because other software depends on them). My users currently
 cannot access these layers. Miguel Ángel Castro (who started this
 thread) described that he cannot access layers from
 http://idecan2.grafcan.es/ServicioWMS/EspNat
 
 Therefore I opt for a configuration option to switch off the dpi
 parameter because public servers may be misconfigured and still people
 want to display their layers in QGIS.
 
 Bernhard

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

Re: [Qgis-user] Can't Add Oracle Spatial Vector Layer with QGIS 2.0 on Mac OSx

2013-10-22 Thread chris marx

In case anyone wants to earn a bounty over at stackexchange, I've gotten no
responses, so I've offered one-

http://gis.stackexchange.com/questions/74842/add-oracle-spatial-vector-layer-with-qgis-2-0-on-mac-osx


On Fri, Oct 18, 2013 at 5:15 PM, chris marx chrism...@gmail.com wrote:

 I installed version 2.0 using the recommended mac installer (
 http://www.kyngchaos.com/software/qgis), and the installation went fine,
 but there is no option to add an oracle spatial layer(not in the layer
 dropdown, or the sidebar buttons). I assume this has to do with gdal
 configuration, but I'm not sure how to fix that. I have the oracle instant
 client installed, and I can connect to oracle with sqlplus. Has anyone been
 able to get the new support for oracle to work on a Mac (Lion)?
 Thanks,
 Chris-


 PS - stackexchange link -
 http://gis.stackexchange.com/questions/74842/add-oracle-spatial-vector-layer-with-qgis-2-0-on-mac-osx

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

Re: [Qgis-user] db-manager (temporary tables)

2013-10-22 Thread Jürgen E . Fischer

Hi António,

On Tue, 22. Oct 2013 at 13:29:57 +0100, António M. Rodrigues wrote:
 As you say, perhaps the best is to contact Giuseppe Sucameli to see
 whether this could be improved (if of course is an useful feature for
 other users).

QGIS and the db_manager use separate sessions.  I didn't try, but I doubt that
you can load temporary layers created by db_manager into qgis.


Jürgen

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


-- 
norBIT Gesellschaft fuer Unternehmensberatung und Informationssysteme mbH
Rheinstrasse 13, 26506 Norden
GF: Jelto Buurman, HR: Amtsgericht Emden, HRB 5502

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

Re: [Qgis-user] Problem with WMS 1.1.1 data providers in QGIS 2.0.1

2013-10-22 Thread Bernhard Ströbl




Am 22.10.2013 15:35, schrieb Andreas Neumann:

fair enough - if users are prevented to access these WMS layers, there
should be an option that would allow them to access the layers.

Yet another option to the WMS loading dialogue - sigh ...


I know it is already crowded, default should be off (= add dpi parameter)

I created a ticket [1]

Bernhard

[1] http://hub.qgis.org/issues/8929



Andreas

Am 22.10.2013 15:19, schrieb Bernhard Ströbl:

Hi Andreas,

Am 22.10.2013 14:44, schrieb Andreas Neumann:

Hi all,

I think the dpi parameter is a useful extension and should be added by
the QGIS client (given that the dpi are really correctly detected).


Correct, therefore QGIS adds this parameter in different flavours for
the most common WMS servers (I assume because this parameter is not
defined in the WMS standard as has already been pointed out in this
thread).



If a WMS server chokes on additional paramters it is not very well
designed. They can just ignore these extra parameters if they do not
know how to deal with it.


My problem is not that geoserver chokes on the additional parameters but
that for _some_ layers the geoserver-specific parameter
format_options=dpi:96 makes it throw an error.
I know that these layers are poorly configured but cannot do anything
against it (because other software depends on them). My users currently
cannot access these layers. Miguel Ángel Castro (who started this
thread) described that he cannot access layers from
http://idecan2.grafcan.es/ServicioWMS/EspNat

Therefore I opt for a configuration option to switch off the dpi
parameter because public servers may be misconfigured and still people
want to display their layers in QGIS.

Bernhard


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


--
Bernhard Ströbl
Anwendungsbetreuer GIS

Kommunale Immobilien Jena
Am Anger 26
07743 Jena

Tel.: 03641 49- 5190
E-Mail: bernhard.stro...@jena.de
Internet: www.kij.de


Kommunale Immobilien Jena
Eigenbetrieb der Stadt Jena
Werkleiter: Dr. Götz Blankenburg


__ Information from ESET Mail Security, version of virus signature 
database 8949 (20131022) __

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


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

Re: [Qgis-user] Problem with WMS 1.1.1 data providers in QGIS 2.0.1

2013-10-22 Thread Jukka Rahkonen

Richard Duivenvoorde rdmailings@... writes:

 
 On 21-10-13 20:07, Miguel Ángel Castro wrote:
  I am using QGIS 2.0.1 standalone installed in a  Windows 7 64 bits system.
  
  Example of WMS datasource: (datasource WMS 1.1.1) EPSG:32628 
  
  http://idecan2.grafcan.es/ServicioWMS/EspNat   
  
  In layer properties/metadata you can see the information from
  datasource, but no display the layer (not load data) in canvas.
  
  In log messages: Map request error (status: 200  getDouble(): Symbol
  definition error. Parsing error near (96): (line 1).
  
  Does anybody have an idea what is the problem?
 
 Hi Miguel,
 
 the error message that you see is a (Minnesota) Mapserver error message.
 Somewhere in the style definitions it expects a number (or not).
 
 This url I get from QGIS in debug mode, and gives you your error:
 

http://idecan2.grafcan.es/ServicioWMS/EspNat?SERVICE=WMSVERSION=1.1.1REQUEST=GetMapBBOX=152208.544610834447667,2940195.98510535480454564,692329.70807293173857033,3376338.62686863588169217SRS=EPSG:32628WIDTH=670HEIGHT=541LAYERS=EENNSTYLES=FORMAT=image/pngDPI=96MAP_RESOLUTION=96TRANSPARENT=TRUE
 
 Bug if I remove the DPI=96MAP_RESOLUTION=96 part from it, I get a map:
 

http://idecan2.grafcan.es/ServicioWMS/EspNat?SERVICE=WMSVERSION=1.1.1REQUEST=GetMapBBOX=152208.544610834447667,2940195.98510535480454564,692329.70807293173857033,3376338.62686863588169217SRS=EPSG:32628WIDTH=670HEIGHT=541LAYERS=EENNSTYLES=FORMAT=image/png
 
 I'm not familiar with the exact WMS-standard, but as most WMS servers I
 know (and use) can handle these two query parameters from QGIS, I think
 it is a Mapserver configuration problem/error. You cannot let QGIS
 remove those params I think.

Hi,

That certain server is a pretty old Mapserver v. 5.0 and it does not like
the non-standard vendor parameter MAP_RESOLUTION=96. Fresh Mapservers do
not fail because of that and actually since version 6.0 Mapserver supports
vendor option MAP_RESOLUTION.

According to WMS standard servers should quietly skip extra parameters so
principally there is a bug in Mapserver 5.0.  However, I do not like that
QGIS is adding always its own vendor parameters and users do not have a way
to turn off the non-standard parameters. I have two reasoning for this:

1) MAP_RESOLUTION is not defined in the standard and for server A it can
mean something different than for server B while QGIS may be awaiting still
something else.
2) Even vendor options should be skipped, we have here an example that some
servers may fail in skipping them. Nobody will fix Mapserver 5.0 and even it
is wrong, it is the QGIS user who suffers now. User can only ask server
admin to update (it may take a while) or switch off QGIS and use another WMS
client like OpenJUMP.

For my mind it should be possible to configure QGIS WMS to run in a safe
mode and use only those parameters which belong to WMS standard.

-Jukka Rahkonen-




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

Re: [Qgis-user] problem reading csv file (numbers read as strings)

2013-10-22 Thread Matteo Ghetta

Thanks for all the replies.
I'm sure that with qgis 1.8 I had no problem in importing a csv file.
Anyway, that's my current file:

ID X Y 2818/22/0834 3480240 5887204 2818/22/0851 3480183 5887073
2818/22/0853 3480060 5886803 2818/22/0886 3481095 5886981 B0F 3479888
5885731 B12T 3479805 5886002

As you can see there are no decimal numbers. You can find the csv file also
in attach.
Another problem: if I import a table (without coordinates and still as csv
file made in libreoffice) in the map canvas (just drag and drop it), qgis
still reads the numbers as strings (making the join option with another
shape file useless).

Cheers

Matteo

2013/10/22 Ramon Andiñach cust...@westnet.com.au

True. A couple if lines would be helpful. Generally QGIS 2.0 is fairly
good at guessing, so it would be interesting to see what's confusing it.

Have you got the put apostrophes around text turned on?

If all else fails you can force QGIS to do what you want.
http://anitagraser.com/2011/03/07/how-to-specify-data-types-of-csv-columns-for-use-in-qgis/

-ramon.

On 22 Oct 2013, at 20:06, Zirneklitis e...@lanet.lv wrote:

Hard to comment without example.

Best regards,
Karlis

Matteo Ghetta wrote:
..
I wrote a table with some field (two of them are x and y coordinates),
saved as csv and then I tried to upload it in qgis with the add
delimited text option.

Problem: numeric filed are read as strings and not as numbers ..
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

ID,X,Y
2818/22/0834,3480240,5887204
2818/22/0851,3480183,5887073
2818/22/0853,3480060,5886803
2818/22/0886,3481095,5886981
B0F,3479888,5885731
B12T,3479805,5886002
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Problem with WMS 1.1.1 data providers in QGIS 2.0.1

2013-10-22 Thread Jonathan Moules


 For my mind it should be possible to configure QGIS WMS to run in a safe
 mode and use only those parameters which belong to WMS standard.


+1

Thinking about it, what about a dialog where it's possible to configure
what a standard WMS request contains?

Ignore the fact it looks suspiciously like Excel, but imagine a QGIS dialog
that let you put pieces together like this:

[image: Inline images 2]

Where % are predefined QGIS variables. Use a + and - button to
add/remove rows (and thus parameters) to the table.

Could work for WFS and WCS too.

Create various different profiles and distribute those as standard. Easy
to use for both lay-users (pre-configured profiles that are specification
compliant), and technical users.

Jonathan

-- 
This transmission is intended for the named addressee(s) only and may 
contain sensitive or protectively marked material up to RESTRICTED and 
should be handled accordingly. Unless you are the named addressee (or 
authorised to receive it for the addressee) you may not copy or use it, or 
disclose it to anyone else. If you have received this transmission in error 
please notify the sender immediately. All email traffic sent to or from us, 
including without limitation all GCSX traffic, may be subject to recording 
and/or monitoring in accordance with relevant legislation.
image.png___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Can't Add Oracle Spatial Vector Layer with QGIS 2.0 on Mac OSx

2013-10-22 Thread William Kyngesburye

I figured someone else would have a good answer. I wasn't aware of the new
Oracle driver, and when you mentioned it I thought it was self-contained or
used GDAL.

But now that I look at it closer, I did not build QGIS with Oracle support
(it's direct support, not thru GDAL). I gave up on the OCI libraries for OSX a
long time ago, but maybe they've caught up recently. I'll look into it.
There's nothing you can do to get the existing build to work.

On Oct 22, 2013, at 8:47 AM, chris marx wrote:

In case anyone wants to earn a bounty over at stackexchange, I've gotten no
responses, so I've offered one-

http://gis.stackexchange.com/questions/74842/add-oracle-spatial-vector-layer-with-qgis-2-0-on-mac-osx

On Fri, Oct 18, 2013 at 5:15 PM, chris marx chrism...@gmail.com wrote:
I installed version 2.0 using the recommended mac installer
(http://www.kyngchaos.com/software/qgis), and the installation went fine, but
there is no option to add an oracle spatial layer(not in the layer dropdown,
or the sidebar buttons). I assume this has to do with gdal configuration, but
I'm not sure how to fix that. I have the oracle instant client installed, and
I can connect to oracle with sqlplus. Has anyone been able to get the new
support for oracle to work on a Mac (Lion)?
Thanks,
Chris-

PS - stackexchange link -
http://gis.stackexchange.com/questions/74842/add-oracle-spatial-vector-layer-with-qgis-2-0-on-mac-osx

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

-
William Kyngesburye kyngchaos*at*kyngchaos*dot*com
http://www.kyngchaos.com/

Theory of the Universe

There is a theory which states that if ever anyone discovers exactly what the
universe is for and why it is here, it will instantly disappear and be replaced
by something even more bizarrely inexplicable. There is another theory which
states that this has already happened.

-Hitchhiker's Guide to the Galaxy 2nd season intro

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

Re: [Qgis-user] Can't Add Oracle Spatial Vector Layer with QGIS 2.0 on Mac OSx

2013-10-22 Thread chris marx

Ok, Thanks for the heads up. I've been using the Oracle instant client as
well as Oracle Sql Developer with no problems on my mac. I think the OCI
libraries come with the instant client?

http://www.oracle.com/technetwork/topics/intel-macsoft-096467.html

On Tue, Oct 22, 2013 at 10:18 AM, William Kyngesburye wokl...@kyngchaos.com
wrote:

I figured someone else would have a good answer. I wasn't aware of the
new Oracle driver, and when you mentioned it I thought it was
self-contained or used GDAL.

But now that I look at it closer, I did not build QGIS with Oracle support
(it's direct support, not thru GDAL). I gave up on the OCI libraries for
OSX a long time ago, but maybe they've caught up recently. I'll look into
it. There's nothing you can do to get the existing build to work.

On Oct 22, 2013, at 8:47 AM, chris marx wrote:

In case anyone wants to earn a bounty over at stackexchange, I've gotten
no responses, so I've offered one-

http://gis.stackexchange.com/questions/74842/add-oracle-spatial-vector-layer-with-qgis-2-0-on-mac-osx

On Fri, Oct 18, 2013 at 5:15 PM, chris marx chrism...@gmail.com wrote:
I installed version 2.0 using the recommended mac installer (
http://www.kyngchaos.com/software/qgis), and the installation went fine,
but there is no option to add an oracle spatial layer(not in the layer
dropdown, or the sidebar buttons). I assume this has to do with gdal
configuration, but I'm not sure how to fix that. I have the oracle instant
client installed, and I can connect to oracle with sqlplus. Has anyone been
able to get the new support for oracle to work on a Mac (Lion)?
Thanks,
Chris-

PS - stackexchange link -
http://gis.stackexchange.com/questions/74842/add-oracle-spatial-vector-layer-with-qgis-2-0-on-mac-osx

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

-
William Kyngesburye kyngchaos*at*kyngchaos*dot*com
http://www.kyngchaos.com/

Theory of the Universe

There is a theory which states that if ever anyone discovers exactly what
the universe is for and why it is here, it will instantly disappear and be
replaced by something even more bizarrely inexplicable. There is another
theory which states that this has already happened.

-Hitchhiker's Guide to the Galaxy 2nd season intro

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

Re: [Qgis-user] problem reading csv file (numbers read as strings)

Well, let's mess things a bit more...

I have opened your csv using this
settingshttps://dl.dropboxusercontent.com/u/110618644/Capturar.JPG
[1].

And both coordinates fields were read as integer (because they have no
decimal part), not texts

Cheers,

Alexandre

[1] https://dl.dropboxusercontent.com/u/110618644/Capturar.JPG

On Tue, Oct 22, 2013 at 2:59 PM, Matteo Ghetta matteo.ghe...@gmail.comwrote:

Thanks for all the replies.
I'm sure that with qgis 1.8 I had no problem in importing a csv file.
Anyway, that's my current file:

ID X Y 2818/22/0834 3480240 5887204 2818/22/0851 3480183 5887073
2818/22/0853 3480060 5886803 2818/22/0886 3481095 5886981 B0F 3479888
5885731 B12T 3479805 5886002

As you can see there are no decimal numbers. You can find the csv file
also in attach.
Another problem: if I import a table (without coordinates and still as csv
file made in libreoffice) in the map canvas (just drag and drop it), qgis
still reads the numbers as strings (making the join option with another
shape file useless).

Cheers

Matteo

2013/10/22 Ramon Andiñach cust...@westnet.com.au

True. A couple if lines would be helpful. Generally QGIS 2.0 is fairly
good at guessing, so it would be interesting to see what's confusing it.

Have you got the put apostrophes around text turned on?

If all else fails you can force QGIS to do what you want.
http://anitagraser.com/2011/03/07/how-to-specify-data-types-of-csv-columns-for-use-in-qgis/

-ramon.

On 22 Oct 2013, at 20:06, Zirneklitis e...@lanet.lv wrote:

Hard to comment without example.

Best regards,
Karlis

Matteo Ghetta wrote:
..
I wrote a table with some field (two of them are x and y coordinates),
saved as csv and then I tried to upload it in qgis with the add
delimited text option.

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

[Qgis-user] reprojection troubles

Hi,

I was trying to convert natural earth 110m layers from EPSG 4326 to EPSG
3857.

Two of the layers (ocean and land) fail to convert with the following error:

Error 6
Feature write errors:
Failed to transform a point while drawing a feature with ID '8'. Writing
stopped. (Exception: forward transform of
(3.141593, -1.570796)
PROJ.4: +proj=longlat +datum=WGS84 +no_defs +to +proj=merc +a=6378137
+b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m
+nadgrids=@null +wktext  +no_defs
Error: tolerance condition error)

Is there anything I can do about this tolerance condition error?

Thanks for any hint,
Andreas
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] problem reading csv file (numbers read as strings)

Just checked with QGIS 2.0.1 (Linux Mint Debian) - no problems with CSV 
as a layer. Sorry for that. Dropping to canvas creates text fields indeed.


Karlis


Matteo Ghetta wrote:

..
I'm sure that with qgis 1.8 I had no problem in importing a csv file.
Anyway, that's my current file:
..
As you can see there are no decimal numbers. You can find the csv file
also in attach.
Another problem: if I import a table (without coordinates and still as
csv file made in libreoffice) in the map canvas (just drag and drop it),
qgis still reads the numbers as strings (making the join option with
another shape file useless).
..

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

Re: [Qgis-user] problem reading csv file (numbers read as strings)

2013-10-22 Thread matteo


On 22/10/2013 16:50, Alexandre Neto wrote:

Well, let's mess things a bit more...

I have opened your csv using this settings 
https://dl.dropboxusercontent.com/u/110618644/Capturar.JPG[1].


And both coordinates fields were read as integer (because they have no 
decimal part), not texts



Thanks Alexandre..
Till 1.9 release QGIS asked immediately for the CRS. Now you have to 
specify it in the properties of the layer you have added. This problem 
is solved! :)


But could you try to add a table (csv file) in the map canvas and see if 
qgis recognize the numbers as numbers (real or integer, it doesn't matter)?


Thanks

Matteo

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

Re: [Qgis-user] problem reading csv file (numbers read as strings)


QGIS 2.0.1 on Linux Mint Debian

matteo wrote:

..
But could you try to add a table (csv file) in the map canvas and see if
qgis recognize the numbers as numbers (real or integer, it doesn't matter)?
..
attachment: fields.png___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Qgis-user Digest, Vol 92, Issue 51 Topic 1

2013-10-22 Thread Ian kirk-ellis

Alexandro,

When inputting a csv file, you need to create within the same folder a csvt 
file, which sets the data type for each field and the number of characters. 
Once you have created this file, then reqad in the csv and the data should come 
in the correct format. You can have integer, real or text data types. Hope that 
helps.

Ian

-Original Message-
From: qgis-user-boun...@lists.osgeo.org 
[mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of 
qgis-user-requ...@lists.osgeo.org
Sent: 22 October 2013 16:04
To: qgis-user@lists.osgeo.org
Subject: Qgis-user Digest, Vol 92, Issue 51

Send Qgis-user mailing list submissions to
qgis-user@lists.osgeo.org

To subscribe or unsubscribe via the World Wide Web, visit
http://lists.osgeo.org/mailman/listinfo/qgis-user
or, via email, send a message with subject or body 'help' to
qgis-user-requ...@lists.osgeo.org

You can reach the person managing the list at
qgis-user-ow...@lists.osgeo.org

When replying, please edit your Subject line so it is more specific than Re: 
Contents of Qgis-user digest...


Today's Topics:

   1. Re: problem reading csv file (numbers read as strings)
  (Alexandre Neto)
   2. reprojection troubles (Andreas Neumann)
   3. Re: problem reading csv file (numbers read as strings)
  (Zirneklitis)


--

Message: 1
Date: Tue, 22 Oct 2013 15:50:48 +0100
From: Alexandre Neto senhor.n...@gmail.com
To: Matteo Ghetta matteo.ghe...@gmail.com
Cc: QGIS Mailing List qgis-user@lists.osgeo.org
Subject: Re: [Qgis-user] problem reading csv file (numbers read as
strings)
Message-ID:
ca+h0g_eyusp-hbxswvn73t9du4yk-r8r08pumytjafzelhz...@mail.gmail.com
Content-Type: text/plain; charset=iso-8859-1

Well, let's mess things a bit more...

I have opened your csv using this
settingshttps://dl.dropboxusercontent.com/u/110618644/Capturar.JPG
[1].

And both coordinates fields were read as integer (because they have no decimal 
part), not texts

Cheers,

Alexandre

[1] https://dl.dropboxusercontent.com/u/110618644/Capturar.JPG


On Tue, Oct 22, 2013 at 2:59 PM, Matteo Ghetta matteo.ghe...@gmail.comwrote:

 Thanks for all the replies.
 I'm sure that with qgis 1.8 I had no problem in importing a csv file.
 Anyway, that's my current file:

   ID X Y  2818/22/0834 3480240 5887204  2818/22/0851 3480183 5887073
 2818/22/0853 3480060 5886803  2818/22/0886 3481095 5886981  B0F 
 3479888
 5885731  B12T 3479805 5886002

 As you can see there are no decimal numbers. You can find the csv file 
 also in attach.
 Another problem: if I import a table (without coordinates and still as 
 csv file made in libreoffice) in the map canvas (just drag and drop 
 it), qgis still reads the numbers as strings (making the join option 
 with another shape file useless).

 Cheers

 Matteo




 2013/10/22 Ramon Andi?ach cust...@westnet.com.au

 True. A couple if lines would be helpful. Generally QGIS 2.0 is 
 fairly good at guessing, so it would be interesting to see what's confusing 
 it.

 Have you got the put apostrophes around text turned on?

 If all else fails you can force QGIS to do what you want.
 http://anitagraser.com/2011/03/07/how-to-specify-data-types-of-csv-co
 lumns-for-use-in-qgis/

 -ramon.

  On 22 Oct 2013, at 20:06, Zirneklitis e...@lanet.lv wrote:
 
  Hard to comment without example.
 
  Best regards,
  Karlis
 
  Matteo Ghetta wrote:
  ..
  I wrote a table with some field (two of them are x and y 
  coordinates), saved as csv and then I tried to upload it in qgis 
  with the add delimited text option.
 
  Problem: numeric filed are read as strings and not as numbers ..
  ___
  Qgis-user mailing list
  Qgis-user@lists.osgeo.org
  http://lists.osgeo.org/mailman/listinfo/qgis-user
 ___
 Qgis-user mailing list
 Qgis-user@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/qgis-user



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

-- next part --
An HTML attachment was scrubbed...
URL: 
http://lists.osgeo.org/pipermail/qgis-user/attachments/20131022/96aea294/attachment-0001.html

--

Message: 2
Date: Tue, 22 Oct 2013 17:01:24 +0200
From: Andreas Neumann a.neum...@carto.net
To: qgis-user International qgis-user@lists.osgeo.org
Subject: [Qgis-user] reprojection troubles
Message-ID: 52669344.8070...@carto.net
Content-Type: text/plain; charset=UTF-8

Hi,

I was trying to convert natural earth 110m layers from EPSG 4326 to EPSG 3857.

Two of the layers (ocean and land) fail to convert with the following error:

Error 6
Feature write errors:
Failed to transform a point while drawing a feature with ID '8'. Writing 
stopped. (Exception: forward transform of (3.141593, -1.570796)
PROJ.4: +proj=longlat +datum=WGS84

Re: [Qgis-user] problem reading csv file (numbers read as strings)

2013-10-22 Thread matteo


You just drag and drop the csv in the map canvas and this is the result??
Because if I want to have the same, I have to save the file as dbf in 
Libreoffice (no big deal, but unfortunately not everyone has 
Libreoffice, and Excel is not able to save dbf files..).


BTW: I resolved the import of the coordinates. It was my fault: I 
installed qgis on my new debian and I forgot to enable the prompt for 
CRS setting.

Sorry guys
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Error loading SIP module.

2013-10-22 Thread Nicholas L. Klein-Baer

Thanks for your help, got it working. Just to follow up, i removed anything
pertaining to sip in /usr/local/lib/python2.7/site-packages and
re-installed python-sip using apt-get:

rm -i  /usr/local/lib/python2.7/site-packages/sip*
apt-get remove python-sip
apt-get install python-sip

Thanks!




On Mon, Oct 21, 2013 at 9:27 AM, Goyo goyod...@gmail.com wrote:

 2013/10/21 Nicholas L. Klein-Baer nklein-b...@humboldt.edu:
  Hi all,
 
  I'm having a problem with QGIS 2.0.1 on Ubuntu 13.04 very similar to the
 one
  described bug 8832. The resolution, however, isn't helping me very much.
 
 If you want to use a different python/sip/pyqt4 than what is in your
  ubuntu by default, you need to build QGIS yourself against it.
 
  I'm a little confused by this because I don't think sip was install by
  default: Before I manually installed it I was getting an error saying no
  module named sip
  Any ideas on what I should do?

 Default here means the version provided by Ubuntu in the standard
 repositories, as opposed to the EPD version provided by Entough or the
 upstream version of sip provided by Riverbank.

 Goyo

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

Re: [Qgis-user] problem reading csv file (numbers read as strings)


CSVT fole solves the issue.

Thank You, Ian.kirk-ellis

Best Regards,
Karlis

matteo wrote:

You just drag and drop the csv in the map canvas and this is the result??
..
String(12),Integer(7),Integer(7)
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] PyQGIS: 1.8 to 2.0 upgrades?

2013-10-22 Thread Etienne Tourigny

http://hub.qgis.org/wiki/quantum-gis/API_changes_for_version_20

also see this which is Python specific
http://hub.qgis.org/wiki/quantum-gis/Python_plugin_API_changes_from_18_to_20




On Fri, Oct 18, 2013 at 3:50 AM, Derek Hohls dho...@csir.co.za wrote:

 Hi

 We have a third-party Python app (not a plugin) that we would like to
 upgrade for compatibility with 2.0.  I came across this page -
 http://hub.qgis.org/projects/quantum-gis/wiki/API_changes_for_version_20- 
 which details some of the changes.  However, just a quick check reveals
 that, where we have this import,:

 from qgis.core import QgsSingleSymbolRenderer
 from qgis.core import QgsSymbol

 both of these imports fails; but neither is mentioned on that page.  Is
 there a more comprehensive guide to upgrading available?

 Thanks
 Derek


 --
 This message is subject to the CSIR's copyright terms and conditions,
 e-mail legal notice, and implemented Open Document Format (ODF) standard.
 The full disclaimer details can be found at
 http://www.csir.co.za/disclaimer.html.


 This message has been scanned for viruses and dangerous content by *
 MailScanner* http://www.mailscanner.info/,
 and is believed to be clean.


 Please consider the environment before printing this email.


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

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

Re: [Qgis-user] Multiple lines label in QGIS 2.0 print composer using wrap on character?

2013-10-22 Thread Lene Fischer

Hi
The trick is:
expression/field|| '\n'  || expression/field

 || is the seperator between fields.

Regards
Lene Fischer

Fra: qgis-user-boun...@lists.osgeo.org [qgis-user-boun...@lists.osgeo.org] på 
vegne af Alexandre Neto [senhor.n...@gmail.com]
Sendt: 22. oktober 2013 11:09
Til: QGIS User
Emne: [Qgis-user] Multiple lines label in QGIS 2.0 print composer using wrap on 
character?

Hello all,

Is there a way to create multiple lines label using a wrap on character in QGIS 
2.0 print composer? Or this must be done with html rendering?

I'm using atlas generation and the label source is attribute from my coverage 
layer.

Thanks,

Alexandre Neto

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

Re: [Qgis-user] db-manager (temporary tables)