Re: [Qgis-user] Importing SVG files for symbols

2014-12-10 Thread Ludwig Gamsjäger
Alex,
 enclosed below is a sample of my svg file, (QGIS would not find it as it
has no .xml but the standard svg extension when created).
Yes, I've tried to export one of the standard symbols and such would import
and I've attached the code as well, I have to admit that I'm not an xml
expert, thanks for every input in advance,

Ludwig


Symbol code not loading:

?xml version=1.0?
svg width=640 height=480 xmlns=http://www.w3.org/2000/svg;
xmlns:xlink=http://www.w3.org/1999/xlink;
!-- Created with SVG-edit - http://svg-edit.googlecode.com/ --
 g
  titleLayer 1/title
  g transform=rotate(180, 80, 78) id=svg_3
   g id=svg_1
metadata id=svg_2/
path
d=m133.641602,36.926723l8.000961,8.000797l15.751205,31.59024l-31.590248,-15
.751202l-7.720001,-7.719677l-30.88192,31.997437l50.44368,48.733131c1.231842,
1.189911 1.308807,3.137115 0.174713,4.420471c-2.18367,2.471359
-4.521591,4.80928 -6.992798,6.992798c-1.283356,1.134094 -3.230553,1.057281
-4.420464,-0.174561l-48.567047,-50.271843l-48.519365,50.269768c-1.189758,1.2
32635 -3.137596,1.310074 -4.421438,0.175674c-2.47056,-2.183197
-4.808001,-4.520157 -6.990879,-6.990723c-1.134401,-1.283676
-1.057119,-3.231827
0.17568,-4.421585l50.436483,-48.680008l-33.406082,-34.580162c-6.023043,6.772
8 -11.116961,14.394402
-15.099041,22.665604l-17.408801,-15.146885c11.03968,-20.288639
27.7408,-36.975359 48.00928,-48.029279l15.139042,17.4064c-8.25312,3.974239
-15.853764,9.060001
-22.608482,15.071041l34.746559,33.5672l32.158081,-31.037281l-18.188316,-18.1
88641l15.839035,-15.83904l18.469276,18.4696l2.300156,-2.220318l7.392654,7.38
88l-2.221924,2.302242z fill=black/
   /g
  /g
  image xlink:href=images/logo.png id=svg_4 height=48 width=48
y=569 x=709/
 /g
/svg

Symbol code loading:

!DOCTYPE qgis_style
qgis_style version=1
  symbols
symbol alpha=1 type=marker name=airport
  layer pass=0 class=SvgMarker locked=0
prop k=angle v=0/
prop k=color v=#00/
prop k=horizontal_anchor_point v=1/
prop k=name v=gpsicons/plane.svg/
prop k=offset v=0,0/
prop k=offset_map_unit_scale v=0,0/
prop k=offset_unit v=MM/
prop k=outline_color v=#00/
prop k=outline_width v=1/
prop k=outline_width_map_unit_scale v=0,0/
prop k=outline_width_unit v=MM/
prop k=scale_method v=area/
prop k=size v=5/
prop k=size_map_unit_scale v=0,0/
prop k=size_unit v=MM/
prop k=vertical_anchor_point v=1/
  /layer
/symbol
  /symbols
  colorramps
/qgis_style

-Ursprüngliche Nachricht-
Von: Alex Mandel [mailto:tech_...@wildintellect.com] 
Gesendet: Mittwoch, 10. Dezember 2014 08:52
An: Ludwig Gamsjäger; qgis-user
Betreff: Re: AW: [Qgis-user] Importing SVG files for symbols

Can you post an example svg file online for other people to test?
Have you tried importing some known working svg icons?

Thanks,
Alex

On 12/09/2014 10:37 PM, Ludwig Gamsjäger wrote:
 Alex,
 
 thanks for your input, unfortunately this what I tried but it seems 
 not to work in 2.6. The location in options is now moved to 
 options/system, I inputted all my paths but it does not allow me to access
the symbols.
 Also trying to import in the Share function fails, it gives an error 
 like invalid svg tag in file or so.
 Maybe there is something I have overlooked in other tabs in options, 
 anyway, thanks,
 
 Ludwig
 
 
 
 -Ursprüngliche Nachricht-
 Von: Alex Mandel [mailto:tech_...@wildintellect.com]
 Gesendet: Dienstag, 09. Dezember 2014 18:37
 An: Ludwig Gamsjäger; qgis-user@lists.osgeo.org
 Betreff: Re: [Qgis-user] Importing SVG files for symbols
 
 This page shows the process:
 http://learninggis.com/gis-resources/qgis-oilandgas-symbol
 
 Thanks,
 Alex
 
 On 12/09/2014 08:03 AM, Ludwig Gamsjäger wrote:


 I would need some help to import svg symbols into QGIS Brighton. My 
 main problem is that there is no documentation (or I can’t find it) 
 how to proceed with this. Programs like Inkscape would read my files 
 but
 not QGIS.
 Maybe somebody is out there giving me hints or a reference 
 documentation; thanks in advance,

  

 Ludwig

  

 Ludwig Gamsjäger

 Bergengasse 4/1/8

 A-1220 Vienna, Austria

 phone: +43 (0) 681 2066-3138

 email: lu...@bergengasse.at

  

 This message is confidential and intended solely for the addressee. 
 If you received this message in error, please immediately inform the 
 sender and delete the message and any attachments. Thank you. To the 
 extent permitted by law, I shall in no way be liable for any damages, 
 whatever their nature, arising out of transmission failures, viruses, 
 external influences, delays and the like.

  




 ___
 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] Importing SVG files for symbols

2014-12-10 Thread Ludwig Gamsjäger
By the way even the oil and gas symbols would not load either

Alex,
 enclosed below is a sample of my svg file, (QGIS would not find it as it
has no .xml but the standard svg extension when created).
Yes, I've tried to export one of the standard symbols and such would import
and I've attached the code as well, I have to admit that I'm not an xml
expert, thanks for every input in advance,

Ludwig


Symbol code not loading:

?xml version=1.0?
svg width=640 height=480 xmlns=http://www.w3.org/2000/svg;
xmlns:xlink=http://www.w3.org/1999/xlink;
!-- Created with SVG-edit - http://svg-edit.googlecode.com/ --
 g
  titleLayer 1/title
  g transform=rotate(180, 80, 78) id=svg_3
   g id=svg_1
metadata id=svg_2/
path
d=m133.641602,36.926723l8.000961,8.000797l15.751205,31.59024l-31.590248,-15
.751202l-7.720001,-7.719677l-30.88192,31.997437l50.44368,48.733131c1.231842,
1.189911 1.308807,3.137115 0.174713,4.420471c-2.18367,2.471359
-4.521591,4.80928 -6.992798,6.992798c-1.283356,1.134094 -3.230553,1.057281
-4.420464,-0.174561l-48.567047,-50.271843l-48.519365,50.269768c-1.189758,1.2
32635 -3.137596,1.310074 -4.421438,0.175674c-2.47056,-2.183197
-4.808001,-4.520157 -6.990879,-6.990723c-1.134401,-1.283676
-1.057119,-3.231827
0.17568,-4.421585l50.436483,-48.680008l-33.406082,-34.580162c-6.023043,6.772
8 -11.116961,14.394402
-15.099041,22.665604l-17.408801,-15.146885c11.03968,-20.288639
27.7408,-36.975359 48.00928,-48.029279l15.139042,17.4064c-8.25312,3.974239
-15.853764,9.060001
-22.608482,15.071041l34.746559,33.5672l32.158081,-31.037281l-18.188316,-18.1
88641l15.839035,-15.83904l18.469276,18.4696l2.300156,-2.220318l7.392654,7.38
88l-2.221924,2.302242z fill=black/
   /g
  /g
  image xlink:href=images/logo.png id=svg_4 height=48 width=48
y=569 x=709/
 /g
/svg

Symbol code loading:

!DOCTYPE qgis_style
qgis_style version=1
  symbols
symbol alpha=1 type=marker name=airport
  layer pass=0 class=SvgMarker locked=0
prop k=angle v=0/
prop k=color v=#00/
prop k=horizontal_anchor_point v=1/
prop k=name v=gpsicons/plane.svg/
prop k=offset v=0,0/
prop k=offset_map_unit_scale v=0,0/
prop k=offset_unit v=MM/
prop k=outline_color v=#00/
prop k=outline_width v=1/
prop k=outline_width_map_unit_scale v=0,0/
prop k=outline_width_unit v=MM/
prop k=scale_method v=area/
prop k=size v=5/
prop k=size_map_unit_scale v=0,0/
prop k=size_unit v=MM/
prop k=vertical_anchor_point v=1/
  /layer
/symbol
  /symbols
  colorramps
/qgis_style

-Ursprüngliche Nachricht-
Von: Alex Mandel [mailto:tech_...@wildintellect.com] 
Gesendet: Mittwoch, 10. Dezember 2014 08:52
An: Ludwig Gamsjäger; qgis-user
Betreff: Re: AW: [Qgis-user] Importing SVG files for symbols

Can you post an example svg file online for other people to test?
Have you tried importing some known working svg icons?

Thanks,
Alex

On 12/09/2014 10:37 PM, Ludwig Gamsjäger wrote:
 Alex,
 
 thanks for your input, unfortunately this what I tried but it seems 
 not to work in 2.6. The location in options is now moved to 
 options/system, I inputted all my paths but it does not allow me to access
the symbols.
 Also trying to import in the Share function fails, it gives an error 
 like invalid svg tag in file or so.
 Maybe there is something I have overlooked in other tabs in options, 
 anyway, thanks,
 
 Ludwig
 
 
 
 -Ursprüngliche Nachricht-
 Von: Alex Mandel [mailto:tech_...@wildintellect.com]
 Gesendet: Dienstag, 09. Dezember 2014 18:37
 An: Ludwig Gamsjäger; qgis-user@lists.osgeo.org
 Betreff: Re: [Qgis-user] Importing SVG files for symbols
 
 This page shows the process:
 http://learninggis.com/gis-resources/qgis-oilandgas-symbol
 
 Thanks,
 Alex
 
 On 12/09/2014 08:03 AM, Ludwig Gamsjäger wrote:


 I would need some help to import svg symbols into QGIS Brighton. My 
 main problem is that there is no documentation (or I can’t find it) 
 how to proceed with this. Programs like Inkscape would read my files 
 but
 not QGIS.
 Maybe somebody is out there giving me hints or a reference 
 documentation; thanks in advance,

  

 Ludwig

  

 Ludwig Gamsjäger

 Bergengasse 4/1/8

 A-1220 Vienna, Austria

 phone: +43 (0) 681 2066-3138

 email: lu...@bergengasse.at

  

 This message is confidential and intended solely for the addressee. 
 If you received this message in error, please immediately inform the 
 sender and delete the message and any attachments. Thank you. To the 
 extent permitted by law, I shall in no way be liable for any damages, 
 whatever their nature, arising out of transmission failures, viruses, 
 external influences, delays and the like.

  




 ___
 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

Re: [Qgis-user] How load Postgis layer from command line?

2014-12-10 Thread Richard Duivenvoorde
On 10-12-14 10:11, Uggla Henrik wrote:
 In Linux it is very easy to setup a ramdisk for fast temporal file storage.
 
 --help really gives the impression that loading Qgis with PostGIS layers 
 using the FILE parameter is a breeze. Also, I still doesn't get what this 
 PostGIS extension mentioned in --help is.

cc'ing to dev list, original thread here:

http://lists.osgeo.org/pipermail/qgis-user/2014-December/030180.html


Me neither, best to bring this to the dev list then, to ask which this
extension is.

And IF we want a FILE parameter work for postgis we could come up with a
design for that file param and do a feature request to get this implemented?

For example, as this works:

l = iface.addVectorLayer('dbname=bag host=localhost port=5432 user=geo
password=xxx sslmode=disable key=gid estimatedmetadata=true srid=28992
type=MULTIPOLYGON table=bag8mrt2014.provincie (geovlak) sql=',
test, postgres)

this is the actual uri:

'dbname=bag host=localhost port=5432 user=geo
password=xxx sslmode=disable key=gid estimatedmetadata=true srid=28992
type=MULTIPOLYGON table=bag8mrt2014.provincie (geovlak) sql='

so maybe prepend that with the provider part:

postgres:'dbname=bag host=localhost port=5432 user=geo
password=xxx sslmode=disable key=gid estimatedmetadata=true srid=28992
type=MULTIPOLYGON table=bag8mrt2014.provincie (geovlak) sql='

and add a --uri option to QGIS?

qgis --uri postgres:'dbname=bag host=localhost port=5432 user=geo
password=xxx sslmode=disable key=gid estimatedmetadata=true srid=28992
type=MULTIPOLYGON table=bag8mrt2014.provincie (geovlak) sql='

or something like that?

Regards,

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


Re: [Qgis-user] Re : Atlas data defined rotation and zoom problem

2014-12-10 Thread matteo

Hi Alexandre,
I think email is better if you don't mind..

some idea on how we can begin?

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


[Qgis-user] [QGIS-Server] Filter not working

2014-12-10 Thread Bernhard Ströbl

Dear all,

a FILTER parameter in the WMS request is not working (used to work 
before, though)

This is QGIS server 2.6.1.1 on Ubuntu 14.04 64bit

Please could anybody running QGIS Server 2.6.1.1 check if FILTER works 
for them?


this is the request: 
http:/servername/cgi-bin/qgis_mapserv.fcgi?map=path_to_map.qgsLAYERS=flaechenaggregatFILTER=flaechenaggregat:gid 
= 13...


I would expect to see only _one_ feature, instead _all_ features are 
shown in the map.


I am afraid, the server is not accessible from the internet.

Bernhard


__ Information from ESET Mail Security, version of virus signature 
database 10854 (20141210) __

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] [QGIS-Server] Filter not working

2014-12-10 Thread Andreas Neumann

Hi Bernhard,

The FILTER does not work for me either. I have a relatively new master 
version (after the release of QGIS 2.6).


To me this seems like a good candidate for a unit test. Should be easy 
to test.


Andreas

On 10.12.2014 12:21, Bernhard Ströbl wrote:

Dear all,

a FILTER parameter in the WMS request is not working (used to work 
before, though)

This is QGIS server 2.6.1.1 on Ubuntu 14.04 64bit

Please could anybody running QGIS Server 2.6.1.1 check if FILTER works 
for them?


this is the request: 
http:/servername/cgi-bin/qgis_mapserv.fcgi?map=path_to_map.qgsLAYERS=flaechenaggregatFILTER=flaechenaggregat:gid 
= 13...


I would expect to see only _one_ feature, instead _all_ features are 
shown in the map.


I am afraid, the server is not accessible from the internet.

Bernhard


__ Information from ESET Mail Security, version of virus 
signature database 10854 (20141210) __


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] [QGIS-Server] Filter not working

2014-12-10 Thread Bernhard Ströbl

Hi Andreas,

thanks for checking. I will file a ticket then but I have no idea about 
unit tests...


Bernhard

Am 10.12.2014 13:39, schrieb Andreas Neumann:

Hi Bernhard,

The FILTER does not work for me either. I have a relatively new master
version (after the release of QGIS 2.6).

To me this seems like a good candidate for a unit test. Should be easy
to test.

Andreas

On 10.12.2014 12:21, Bernhard Ströbl wrote:

Dear all,

a FILTER parameter in the WMS request is not working (used to work
before, though)
This is QGIS server 2.6.1.1 on Ubuntu 14.04 64bit

Please could anybody running QGIS Server 2.6.1.1 check if FILTER works
for them?

this is the request:
http:/servername/cgi-bin/qgis_mapserv.fcgi?map=path_to_map.qgsLAYERS=flaechenaggregatFILTER=flaechenaggregat:gid
= 13...

I would expect to see only _one_ feature, instead _all_ features are
shown in the map.

I am afraid, the server is not accessible from the internet.

Bernhard


__ Information from ESET Mail Security, version of virus
signature database 10854 (20141210) __

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


__ Information from ESET Mail Security, version of virus
signature database 10855 (20141210) __

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






__ Information from ESET Mail Security, version of virus signature 
database 10855 (20141210) __

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] Qgis connect with Access

2014-12-10 Thread thomas reinfelder
Dear list,



how do I connect Qgis with an Access DB?



I tried to use evis.



DBtyp -- odbc

DBHost -- localhost

DBname -- the path to the Access File ???



Thank you for your support.



thomas



Thomas Reinfelder
Frutolfstr. 27
96049 Bamberg
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Mosaicking aerial images

2014-12-10 Thread Andreas Neumann

Hi,

I georeferenced four overlapping aerial images - with QGIS/GDAL and the 
thin plate spline method. Now I want to mosaick/blend the overlapping 
images. Are there any good FOSSGIS tools available that support 
mosaicking with blending? Perhaps with SAGA/GRASS/OTB? Any recommendations?


Thanks for any pointers/tutorials.

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


Re: [Qgis-user] How load Postgis layer from command line?

2014-12-10 Thread Germán Carrillo
Exactly Richard, that would be the expected behaviour.

Regards,

Germán

2014-12-10 4:37 GMT-05:00 Richard Duivenvoorde rdmaili...@duif.net:

 On 10-12-14 10:11, Uggla Henrik wrote:
  In Linux it is very easy to setup a ramdisk for fast temporal file
 storage.
 
  --help really gives the impression that loading Qgis with PostGIS layers
 using the FILE parameter is a breeze. Also, I still doesn't get what this
 PostGIS extension mentioned in --help is.

 cc'ing to dev list, original thread here:

 http://lists.osgeo.org/pipermail/qgis-user/2014-December/030180.html


 Me neither, best to bring this to the dev list then, to ask which this
 extension is.

 And IF we want a FILE parameter work for postgis we could come up with a
 design for that file param and do a feature request to get this
 implemented?

 For example, as this works:

 l = iface.addVectorLayer('dbname=bag host=localhost port=5432 user=geo
 password=xxx sslmode=disable key=gid estimatedmetadata=true srid=28992
 type=MULTIPOLYGON table=bag8mrt2014.provincie (geovlak) sql=',
 test, postgres)

 this is the actual uri:

 'dbname=bag host=localhost port=5432 user=geo
 password=xxx sslmode=disable key=gid estimatedmetadata=true srid=28992
 type=MULTIPOLYGON table=bag8mrt2014.provincie (geovlak) sql='

 so maybe prepend that with the provider part:

 postgres:'dbname=bag host=localhost port=5432 user=geo
 password=xxx sslmode=disable key=gid estimatedmetadata=true srid=28992
 type=MULTIPOLYGON table=bag8mrt2014.provincie (geovlak) sql='

 and add a --uri option to QGIS?

 qgis --uri postgres:'dbname=bag host=localhost port=5432 user=geo
 password=xxx sslmode=disable key=gid estimatedmetadata=true srid=28992
 type=MULTIPOLYGON table=bag8mrt2014.provincie (geovlak) sql='

 or something like that?

 Regards,

 Richard Duivenvoorde




-- 
---
   |\__
(:__)(
   |/

Soluciones Geoinformáticas Libres
http://geotux.tuxfamily.org/
http://twitter.com/GeoTux2
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] py2exe for windows, import qgis.core anf qgis.gui

2014-12-10 Thread kissa hiri
dear community!



Im a newbie in mailinglists and qgis. I have progammed a standalone application in python and it works so far. Now Im trying to make from that an executable file (*.exe) with py2exe (for windows) but Im not able to include die qgis.core and agis.gui libraries. In the qgis directory I only found the qgis_core.dll and the qgis_gui.dll. Is qgis_core and qgis_gui the same like qgis.core and qgis.gui?



please, help me.

thanks in advance



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

[Qgis-user] Trouble parsing the getcapability response.

2014-12-10 Thread Andrea Peri
Hi,

I'm try to parsing with an xslt transform the WMS GetCapability
response of qgis-server.

I try this simple xsl parse:

xsl:value-of select=/WMS_Capabilities/Service/Name
xmlns=http://www.opengis.net/wms;
xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance;
xsi:schemaLocation=http://www.opengis.net/wms
http://qgis.org/wms_1_3_0.xsd; /

to retrieve the name of service,

The xml I try to parse is this:

?xml version=1.0 encoding=utf-8?
WMS_Capabilities
xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; version=1.3.0
xmlns=http://www.opengis.net/wms;
xsi:schemaLocation=http://www.opengis.net/wms
http://qgis.org/wms_1_3_0.xsd;
 Service
  NameWMS/Name



I guess the xpath
/WMS_Capabilities/Service/Name
is correct,
but it don't work.

Any helo is welcome.

Thx,

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

Re: [Qgis-user] Spatialite queries return text instead of numeric values

2014-12-10 Thread Goyo
2014-12-10 1:50 GMT+01:00 Alexandre Neto senhor.n...@gmail.com:
 Hello,

 When querying a spatialite database in the database manager, if you create
 some calculations (say add two columns values) the resulting column returns
 as TEXT instead of the expected numeric field.

 Is this intended or a bug?

 Trying to cast it as real, double or float did not work either.

Calculated columns in SQLite do not have a data type, the actual
values in the column do. If you execute this query:

SELECT col1 + col2 AS thevalue, typeof(col1 + col2) as
thetype FROM table

You should have thetype='real' in every row (provided col1 and
col2 always contain real values) but the column thevalue does not
have a data type assigned.

I guess QGIS needs to assign a data type to each column and chooses
the more general type when the column does not have one without
looking at the actual values (which could be expensive and also
misleading if the data change).

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


Re: [Qgis-user] Spatialite queries return text instead of numeric values

2014-12-10 Thread Alex Mandel
On 12/10/2014 09:55 AM, Goyo wrote:
 2014-12-10 1:50 GMT+01:00 Alexandre Neto senhor.n...@gmail.com:
 Hello,

 When querying a spatialite database in the database manager, if you create
 some calculations (say add two columns values) the resulting column returns
 as TEXT instead of the expected numeric field.

 Is this intended or a bug?

 Trying to cast it as real, double or float did not work either.
 
 Calculated columns in SQLite do not have a data type, the actual
 values in the column do. If you execute this query:
 
 SELECT col1 + col2 AS thevalue, typeof(col1 + col2) as
 thetype FROM table
 
 You should have thetype='real' in every row (provided col1 and
 col2 always contain real values) but the column thevalue does not
 have a data type assigned.
 
 I guess QGIS needs to assign a data type to each column and chooses
 the more general type when the column does not have one without
 looking at the actual values (which could be expensive and also
 misleading if the data change).
 
 Goyo
 ___
 Qgis-user mailing list
 Qgis-user@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/qgis-user
 

There are two ways in SQLITE to get the numeric type you want, you can
do a CAST() or you can force it with a multiplication (*1 or *1.0). It's
really critical if you do a division to *1.0 somewhere in the statement
otherwise you'll only get an integer.

Note this is not a QGIS specific thing, it applies to general use of SQLITE.

You said you tried a CAST, can you paste what you tried?

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


Re: [Qgis-user] Mosaicking aerial images

2014-12-10 Thread Michael Treglia
Hi Andreas,

I'm Bringing this back to the list, as others here probably have some
better thoughts than I do.  Googling around, I found this tool which might
be useful (?), though I can't tell how it handles overlaps [haven't even
downloaded it...]: https://trac.osgeo.org/gdal/wiki/Correlator

Not sure about enblend (can't access the site right now)

Depending on how different the images are, you could just try mosaicing and
see what it looks like (gdal_merge takes the values of last image added for
overlaps).  If there's a way to standardize color values based on
brightness, or by RGB bands, that might help, either before or after
mosaicing. (might depend on if you're dealing with multi-band image, or
single band? - it would be fairly easy on multi-band like Landsat)

Hope that helps,
mike



On Wed, Dec 10, 2014 at 9:28 AM, Andreas Neumann a.neum...@carto.net
wrote:

  Hi Michael,

 I have 4 images with approx 30% overlap in each axis (north/east). I would
 like to mosaic the images to get a single big images covering the full area.

 I hope that the images are nicely blended into each other so I don't see
 the the seam/border of the original images - I was hoping to get something
 similar to enblend/enfuse (http://enblend.sourceforge.net). I don't
 think that enblend/enfuse keeps my georefencing - or does it?

 Andreas


 On 10.12.2014 16:10, Michael Treglia wrote:

  Hi Andreas,

 Do you mean that you want to effectively create a stack of rasters (i.e.,
 multi-band raster)? If not, we might need some more details.

  If so, the Raster Merge operation (using gdal_warp) should work - go to
 Raster - Miscellaneous - Merge, and check the box for Layer Stack (
 http://www.gdal.org/gdal_merge.html).

  You can also do that in SAGA via Import/Export - GDAL/OGR - GDAL:
 Export Raster, and add multiple grids, though this is a bit more
 constrained and I think needs to have all layers in the same Resolution.

  This is also do-able in R using the Raster package, look into brick,
 stack, and writeRaster

  hope that helps,
 Mike



 On Wed, Dec 10, 2014 at 8:00 AM, Andreas Neumann a.neum...@carto.net
 wrote:

 Hi,

 I georeferenced four overlapping aerial images - with QGIS/GDAL and the
 thin plate spline method. Now I want to mosaick/blend the overlapping
 images. Are there any good FOSSGIS tools available that support mosaicking
 with blending? Perhaps with SAGA/GRASS/OTB? Any recommendations?

 Thanks for any pointers/tutorials.

 Andreas
 ___
 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] Mosaicking aerial images

2014-12-10 Thread Andreas Neumann

Hi,

The correlator project sort of does what I need, however, probably 
without blending/fusing. On the other hand my images are already very 
well georeferenced (with thin-plate spline and around 1000 points per 
image) - so not really a need to correlate.


So I am actually more looking for a blending/fusing app that keeps 
georeferencing.


I will probably ask at the gdal list as well to see if someone has an 
idea.


For my panoramic photography I use either hugin or autopano giga. Both 
do an excellent job with blending, but I fear they would delete my 
georeferencing data and I don't know if they can handle the big files I 
have.


Andreas

Am 2014-12-10 19:21, schrieb Michael Treglia:

Hi Andreas,

I'm Bringing this back to the list, as others here probably have some
better thoughts than I do.  Googling around, I found this tool which
might be useful (?), though I can't tell how it handles overlaps
[haven't even downloaded it...]:
https://trac.osgeo.org/gdal/wiki/Correlator [4]

Not sure about enblend (can't access the site right now)

Depending on how different the images are, you could just try
mosaicing and see what it looks like (gdal_merge takes the values of
last image added for overlaps).  If there's a way to standardize
color values based on brightness, or by RGB bands, that might help,
either before or after mosaicing. (might depend on if you're dealing
with multi-band image, or single band? - it would be fairly easy on
multi-band like Landsat)

Hope that helps,
mike

On Wed, Dec 10, 2014 at 9:28 AM, Andreas Neumann a.neum...@carto.net
wrote:


Hi Michael,

I have 4 images with approx 30% overlap in each axis (north/east).
I would like to mosaic the images to get a single big images
covering the full area.

I hope that the images are nicely blended into each other so I
don't see the the seam/border of the original images - I was hoping
to get something similar to enblend/enfuse
(http://enblend.sourceforge.net [1]). I don't think that
enblend/enfuse keeps my georefencing - or does it?

Andreas

On 10.12.2014 16:10, Michael Treglia wrote:

Hi Andreas,

Do you mean that you want to effectively create a stack of rasters
(i.e., multi-band raster)? If not, we might need some more details.

 If so, the Raster Merge operation (using gdal_warp) should work -
go to Raster - Miscellaneous - Merge, and check the box for Layer
Stack (http://www.gdal.org/gdal_merge.html [2]).

You can also do that in SAGA via Import/Export - GDAL/OGR - GDAL:
Export Raster, and add multiple grids, though this is a bit more
constrained and I think needs to have all layers in the same
Resolution.

This is also do-able in R using the Raster package, look into
brick, stack, and writeRaster

hope that helps,
Mike

On Wed, Dec 10, 2014 at 8:00 AM, Andreas Neumann
a.neum...@carto.net wrote:
Hi,

I georeferenced four overlapping aerial images - with QGIS/GDAL and
the thin plate spline method. Now I want to mosaick/blend the
overlapping images. Are there any good FOSSGIS tools available that
support mosaicking with blending? Perhaps with SAGA/GRASS/OTB? Any
recommendations?

Thanks for any pointers/tutorials.

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




Links:
--
[1] http://enblend.sourceforge.net
[2] http://www.gdal.org/gdal_merge.html
[3] http://lists.osgeo.org/mailman/listinfo/qgis-user
[4] https://trac.osgeo.org/gdal/wiki/Correlator

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

Re: [Qgis-user] Spatialite queries return text instead of numeric values

2014-12-10 Thread Alexandre Neto
Hello all,

To make some tests I have the folllowing table:

General info


  Relation type:

Table

Rows:

3

SpatiaLite


  Column:

geometry

Geometry:

MULTIPOLYGON

Dimension:

XY

Spatial ref:

WGS 84 (4326)

Extent:

(unknown) (find out action:extent/get)

Fields


  #

Name

Type

Null

Default

0

pkuid

integer

Y



1

coluna1

text

Y



2

coluna2

real

Y



3

coluna3

integer

Y



4

geometry

MULTIPOLYGON

Y




If I do this:

SELECT
   *,
coluna2/1.0 AS test_field
FROM
testes

when I open it with DBmanager the test_field return a QSTRING with type
name TEXT

http://imgur.com/GHeMyiW

Using cast:

 SELECT
   *,
cast((coluna2/1.0) as real) AS test_field
FROM
testes

I get the same.

Thanks for the help.

Alexandre Neto


On Wed, Dec 10, 2014 at 6:16 PM, Alex Mandel tech_...@wildintellect.com
wrote:

 On 12/10/2014 09:55 AM, Goyo wrote:
  2014-12-10 1:50 GMT+01:00 Alexandre Neto senhor.n...@gmail.com:
  Hello,
 
  When querying a spatialite database in the database manager, if you
 create
  some calculations (say add two columns values) the resulting column
 returns
  as TEXT instead of the expected numeric field.
 
  Is this intended or a bug?
 
  Trying to cast it as real, double or float did not work either.
 
  Calculated columns in SQLite do not have a data type, the actual
  values in the column do. If you execute this query:
 
  SELECT col1 + col2 AS thevalue, typeof(col1 + col2) as
  thetype FROM table
 
  You should have thetype='real' in every row (provided col1 and
  col2 always contain real values) but the column thevalue does not
  have a data type assigned.
 
  I guess QGIS needs to assign a data type to each column and chooses
  the more general type when the column does not have one without
  looking at the actual values (which could be expensive and also
  misleading if the data change).
 
  Goyo
  ___
  Qgis-user mailing list
  Qgis-user@lists.osgeo.org
  http://lists.osgeo.org/mailman/listinfo/qgis-user
 

 There are two ways in SQLITE to get the numeric type you want, you can
 do a CAST() or you can force it with a multiplication (*1 or *1.0). It's
 really critical if you do a division to *1.0 somewhere in the statement
 otherwise you'll only get an integer.

 Note this is not a QGIS specific thing, it applies to general use of
 SQLITE.

 You said you tried a CAST, can you paste what you tried?

 Thanks,
 Alex
 ___
 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] Spatialite queries return text instead of numeric values

2014-12-10 Thread Alex Mandel
What happens if you CREATE VIEW with those tests?
Does QGIS read the VIEW differently?

Thanks,
Alex

On 12/10/2014 10:57 AM, Alexandre Neto wrote:
 Hello all,
 
 To make some tests I have the folllowing table:
 
 General info
 
 
   Relation type:
 
 Table
 
 Rows:
 
 3
 
 SpatiaLite
 
 
   Column:
 
 geometry
 
 Geometry:
 
 MULTIPOLYGON
 
 Dimension:
 
 XY
 
 Spatial ref:
 
 WGS 84 (4326)
 
 Extent:
 
 (unknown) (find out action:extent/get)
 
 Fields
 
 
   #
 
 Name
 
 Type
 
 Null
 
 Default
 
 0
 
 pkuid
 
 integer
 
 Y
 
 
 
 1
 
 coluna1
 
 text
 
 Y
 
 
 
 2
 
 coluna2
 
 real
 
 Y
 
 
 
 3
 
 coluna3
 
 integer
 
 Y
 
 
 
 4
 
 geometry
 
 MULTIPOLYGON
 
 Y
 
 
 
 
 If I do this:
 
 SELECT
*,
 coluna2/1.0 AS test_field
 FROM
 testes
 
 when I open it with DBmanager the test_field return a QSTRING with type
 name TEXT
 
 http://imgur.com/GHeMyiW
 
 Using cast:
 
  SELECT
*,
 cast((coluna2/1.0) as real) AS test_field
 FROM
 testes
 
 I get the same.
 
 Thanks for the help.
 
 Alexandre Neto
 
 
 On Wed, Dec 10, 2014 at 6:16 PM, Alex Mandel tech_...@wildintellect.com
 wrote:
 
 On 12/10/2014 09:55 AM, Goyo wrote:
 2014-12-10 1:50 GMT+01:00 Alexandre Neto senhor.n...@gmail.com:
 Hello,

 When querying a spatialite database in the database manager, if you
 create
 some calculations (say add two columns values) the resulting column
 returns
 as TEXT instead of the expected numeric field.

 Is this intended or a bug?

 Trying to cast it as real, double or float did not work either.

 Calculated columns in SQLite do not have a data type, the actual
 values in the column do. If you execute this query:

 SELECT col1 + col2 AS thevalue, typeof(col1 + col2) as
 thetype FROM table

 You should have thetype='real' in every row (provided col1 and
 col2 always contain real values) but the column thevalue does not
 have a data type assigned.

 I guess QGIS needs to assign a data type to each column and chooses
 the more general type when the column does not have one without
 looking at the actual values (which could be expensive and also
 misleading if the data change).

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


 There are two ways in SQLITE to get the numeric type you want, you can
 do a CAST() or you can force it with a multiplication (*1 or *1.0). It's
 really critical if you do a division to *1.0 somewhere in the statement
 otherwise you'll only get an integer.

 Note this is not a QGIS specific thing, it applies to general use of
 SQLITE.

 You said you tried a CAST, can you paste what you tried?

 Thanks,
 Alex
 ___
 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] Trouble parsing the getcapability response.

2014-12-10 Thread Andrea Peri
Richard, really thx to you.
Your sample help me to find the solution.

Just for other user I share my experience:

Starting from the ample of Richard the solution was
to pass from version=1.3.0 to version=1.1.1.

Infact:
Using the version=1.1.1 the root tag is
WMT_MS_Capabilities version=1.1.1

And the xpath
/WMT_MS_Capabilites/Service/Name

work perfectly.

Instead firstly I try using the version=1.3.0.
That mean a root tag like this:
WMS_Capabilities version=1.3.0
xsi:schemaLocation=http://www.opengis.net/wms
http://qgis.org/wms_1_3_0.xsd;

I dont knw why, but with this root tag the
xpath
/WMS_MS_Capabilites/Service/Name

dont work.

Thx again,

Andrea


2014-12-10 17:31 GMT+01:00 Richard Duivenvoorde rdmaili...@duif.net:
 On 10-12-14 17:04, Andrea Peri wrote:

 Any helo is welcome.

 attached, you find the working example of:

 http://geographika.co.uk/automated-wms-reports

 with capabilities from

 https://map.geo.gl.ch/wms/Public?service=WMSrequest=getcapabilitiesVERSION=1.1.1

 both xml and xsl attached.
 unzip in dir, open in browser and see xml go to html :-)

 Hope this helps.

 Regards,

 Richard Duivenvoorde



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

Re: [Qgis-user] Mosaicking aerial images

2014-12-10 Thread Bruce, Bob (CWS)
Hi Andreas,

I wrote a QGIS python plugin a number of years ago for merging overlapping 
imagery, it can be found at: http://www.mappinggeek.ca/QGISPythonPlugins/ under 
the title Image Clipper. I developed it for my day job where our map/photo 
sales people wanted to georeferenced and merge aerial photography for map photo 
bases. Our staff continue to use this plugin to merge georeferenced 
photography. This plugin has never been upgraded to QGIS version 2, at some 
point I would like to tackle that but I haven't done any python development in 
QGIS for a couple of years so I'm leery of that.

You might want to investigate OSSIM as I believe that it has tools for merging 
and colour balancing of overlapping images.

Bob Bruce

-Original Message-
From: qgis-user-boun...@lists.osgeo.org 
[mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Andreas Neumann
Sent: December-10-14 12:38 PM
To: Michael Treglia
Cc: qgis-user@lists.osgeo.org
Subject: Re: [Qgis-user] Mosaicking aerial images

Hi,

The correlator project sort of does what I need, however, probably without 
blending/fusing. On the other hand my images are already very well 
georeferenced (with thin-plate spline and around 1000 points per
image) - so not really a need to correlate.

So I am actually more looking for a blending/fusing app that keeps 
georeferencing.

I will probably ask at the gdal list as well to see if someone has an idea.

For my panoramic photography I use either hugin or autopano giga. Both do an 
excellent job with blending, but I fear they would delete my georeferencing 
data and I don't know if they can handle the big files I have.

Andreas

Am 2014-12-10 19:21, schrieb Michael Treglia:
 Hi Andreas,
 
 I'm Bringing this back to the list, as others here probably have some 
 better thoughts than I do.  Googling around, I found this tool which 
 might be useful (?), though I can't tell how it handles overlaps 
 [haven't even downloaded it...]:
 https://trac.osgeo.org/gdal/wiki/Correlator [4]
 
 Not sure about enblend (can't access the site right now)
 
 Depending on how different the images are, you could just try 
 mosaicing and see what it looks like (gdal_merge takes the values of 
 last image added for overlaps).  If there's a way to standardize color 
 values based on brightness, or by RGB bands, that might help, either 
 before or after mosaicing. (might depend on if you're dealing with 
 multi-band image, or single band? - it would be fairly easy on 
 multi-band like Landsat)
 
 Hope that helps,
 mike
 
 On Wed, Dec 10, 2014 at 9:28 AM, Andreas Neumann a.neum...@carto.net
 wrote:
 
 Hi Michael,
 
 I have 4 images with approx 30% overlap in each axis (north/east).
 I would like to mosaic the images to get a single big images covering 
 the full area.
 
 I hope that the images are nicely blended into each other so I don't 
 see the the seam/border of the original images - I was hoping to get 
 something similar to enblend/enfuse
 (http://enblend.sourceforge.net [1]). I don't think that 
 enblend/enfuse keeps my georefencing - or does it?
 
 Andreas
 
 On 10.12.2014 16:10, Michael Treglia wrote:
 
 Hi Andreas,
 
 Do you mean that you want to effectively create a stack of rasters 
 (i.e., multi-band raster)? If not, we might need some more details.
 
  If so, the Raster Merge operation (using gdal_warp) should work - go 
 to Raster - Miscellaneous - Merge, and check the box for Layer 
 Stack (http://www.gdal.org/gdal_merge.html [2]).
 
 You can also do that in SAGA via Import/Export - GDAL/OGR - GDAL:
 Export Raster, and add multiple grids, though this is a bit more 
 constrained and I think needs to have all layers in the same 
 Resolution.
 
 This is also do-able in R using the Raster package, look into 
 brick, stack, and writeRaster
 
 hope that helps,
 Mike
 
 On Wed, Dec 10, 2014 at 8:00 AM, Andreas Neumann 
 a.neum...@carto.net wrote:
 Hi,
 
 I georeferenced four overlapping aerial images - with QGIS/GDAL and 
 the thin plate spline method. Now I want to mosaick/blend the 
 overlapping images. Are there any good FOSSGIS tools available that 
 support mosaicking with blending? Perhaps with SAGA/GRASS/OTB? Any 
 recommendations?
 
 Thanks for any pointers/tutorials.
 
 Andreas
 ___
 Qgis-user mailing list
 Qgis-user@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/qgis-user [3]
 
 
 
 Links:
 --
 [1] http://enblend.sourceforge.net
 [2] http://www.gdal.org/gdal_merge.html
 [3] http://lists.osgeo.org/mailman/listinfo/qgis-user
 [4] https://trac.osgeo.org/gdal/wiki/Correlator
___
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] SHP de vías a GPX de forma masiva

2014-12-10 Thread Corredera_Estudio de Ingeniería GEOCOBET CARTOGRAFÍA Y SIG
Necesito pasar los ejes de un SHP  de vías a GPX individuales de cada vía,
pero de forma masiva, automática, y no una por una, pues el número de vías
contenidas en el SHP de partida es muy alto y guardar una por una a GPX
desde QGIS consumiría muchísimo tiempo.
¿Conoce alguien un modo de hacer esa transformación de forma masiva?
Gracias y un saludo


*Francisco Corredera Quesada*
*GEOCOBET CARTOGRAFIA Y SIG*
*www.geocobet.com http://www.geocobet.comcorred...@geocobet.com
corred...@geocobet.com   (+34) 928 80 87 42*








*Este correo electrónico y la información contenida en el mismo es
decarácter confidencial. Se dirige  exclusivamente al
destinatariomencionado en el encabezamiento. Si  el receptor de la
comunicación nofuera el destinatario, le rogamos nos lo comunique de
inmediato y procedaa destruir el mensaje recibido. Cualquier divulgación,
copia,distribución o utilización no autorizada de la información contenida
en lamismo está prohibida por la legislación vigente. *
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] py2exe for windows, import qgis.core anf qgis.gui

2014-12-10 Thread Nathan Woodrow
Hey Robert,

It can be done.  I have done it with my Roam project, you can find the
setup.py logic here https://github.com/DMS-Aus/Roam/blob/master/setup.py

The three main things are:
   1) Make sure you have a batch file that does path setup and call it
before running: python setup.py py2exe. You can see an example at
https://github.com/DMS-Aus/Roam/blob/master/scripts/setenv.bat  I run this
is all my sub scripts when building, etc.  Basically call setenv.bat call
python setup.py py2exe

   2) You need to copy things like qgis provider plugins and resources into
the package, you can see that being done here:
https://github.com/DMS-Aus/Roam/blob/master/setup.py#L82 (ignore the mess
there)

   3) You will need to do some path setup before you call QgsApplication or
else things will not load correctly:
https://github.com/DMS-Aus/Roam/blob/master/src/roam/environ.py#L107

The Roam code might not be a good example as there is a lot of other things
in there but you should be able to make your way though it to work it out.

- Nathan

On Thu Dec 11 2014 at 12:34:47 AM kissa hiri kissa.h...@gmx.at wrote:

 dear community!

 I'm a newbie in mailinglists and qgis. I have progammed a standalone
 application in python and it works so far. Now I'm trying to make from that
 an executable file (*.exe) with py2exe (for windows) but I'm not able to
 include die qgis.core and agis.gui libraries. In the qgis directory I only
 found the qgis_core.dll and the qgis_gui.dll. Is qgis_core and qgis_gui the
 same like qgis.core and qgis.gui?

 please, help me.
 thanks in advance

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