[Qgis-user] PostGIS raster access in QGIS using DBManager (or wktraster)

2014-03-07 Thread Guido Lemoine
Dear QGIS users,



[This was posted on QGIS developer as well, but maybe I should seek the
solution here]


I am using QGIS 2.2 .0 (Valmiera) and trying to load a raster query result
via DBManager, using the following query:

select 1 as rid, st_union(st_band(rast, '4,3,2') ) as rast
from o_8_lc81970232013202lgn00_all_rds_sub, municipalities
where municipalities.wkb_geometry  rast
and munname = 'Veendam' 

(in short: Band 4,3,2 of a raster2pgsql-loaded Landsat-8 image (overview 8
version) for a municipality polygon (administrative commune boundary).

Execute (F5) correctly returns a single row (and I can save the union result
with ST_AsTIFF() to file in a script)

When I try to Load as a new layer to visualise the result in QGIS, I get
the following error message:

Erroneous query: SELECT DISTINCT upper(geometrytype(rast)),st_srid(rast)
FROM (select 1 as rid, st_union(st_band(rast, '4,3,2') ) as rast
from o_8_lc81970232013202lgn00_all_rds_sub, gemeentegebieden
where gemeentegebieden.wkb_geometry  rast
and gemnaam = 'Veendam' 
) AS subQuery_0 returned 7 [ERROR:  function geometrytype(raster) does not
exist
LINE 1: SELECT DISTINCT upper(geometrytype(rast)),st_srid(rast) ...
  ^
HINT:  No function matches the given name and argument types. You might need
to add explicit type casts.
]

Apparently, my query get wrapped  in the SELECT DISTINCT outer query above
(which obviously does not work).

Is this a known issue, and, if so, can it be modified, for instance by
providing explicitly geometrytype and srid (and if so, how?).

I also checked out the wktraster plugin, but that does not work for 2.2. Is
an upgrade expected soon [or should I try writing it myself].

Thanks for all the wonderful stuff,

Guido Lemoine

 

 

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

Re: [Qgis-user] IntraMaps Roam first release - Windows QGIS Data Collection

2014-03-07 Thread Vincent Picavet
Hello,
Thanks a lot Nathan for this work !
Note that we at Oslandia are working on a new PostGIS / Spatialite versionning 
and offline system, intended to be used by Roam to edit data offline and merge 
it 
with online PostGIS database.
A prototype should be opensourced in the next weeks/month. We will keep you 
posted.
Vincent

Le vendredi 7 mars 2014 07:32:42, Nathan Woodrow a écrit :
 Hi everyone,
 
 Just dropping a quick email out to let everyone know about a project I have
 been working on the last couple of months.
 
 Digital Mapping Solutions, and myself, would like to announce the first
 version of IntraMaps Roam - a simple, but flexible, Windows based data
 collection application built using Python and QGIS.
 
 IntraMaps Roam (or Roam for short) is a standalone, fully bundled, Python
 application that was created to do data collection with a QGIS backend.
  For those of you who have seen my QMap project I started a year or so ago
 you can consider this a reincarnation of that project. Most of the code has
 been reworked and using the QGIS libs gave me full flexibility in layout.
 
 The release page can be found at
 https://github.com/DMS-Aus/Roam/releases/tag/v2.0 and the wiki with all the
 information to get started at: https://github.com/DMS-Aus/Roam/wiki You can
 also take a look at the FAQ for the common questions:
 https://github.com/DMS-Aus/Roam/wiki/FAQ
 
 Roam has been a great exercise in using and bundling QGIS libs with a
 Python application.
 
 As Roam is based on PyQt and QGIS it is under the GPL2 license. Pull
 requests are welcome.
 
 Links:
 - https://github.com/DMS-Aus/Roam/releases/tag/v2.0
 - https://github.com/DMS-Aus/Roam/wiki
 - https://github.com/DMS-Aus/Roam/wiki/FAQ
 
 Happy mapping!
 
 Regards,
 Nathan
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user


Re: [Qgis-user] PostGIS raster access in QGIS using DBManager (or wktraster)

2014-03-07 Thread José Pedro Santos
Ciao Guido,

DBManager is only for vector layers..In the version 1.8 existed a plugin for 
importing raster layers but wasn't update for this new version. 

Regards,
José Santos 

From: guido.lemo...@jrc.ec.europa.eu
To: qgis-user@lists.osgeo.org
Date: Fri, 7 Mar 2014 07:51:33 +0100
Subject: [Qgis-user] PostGIS raster access in QGIS using DBManager (or  
wktraster)

Dear QGIS users,

[This was posted on QGIS developer as well, but maybe I should seek the 
solution here]
I am using QGIS 2.2 .0 (Valmiera) and trying to load a raster query result via 
DBManager, using the following query:

select 1 as rid, st_union(st_band(rast, '4,3,2') ) as rast
from o_8_lc81970232013202lgn00_all_rds_sub, municipalities
where municipalities.wkb_geometry  rast
and munname = 'Veendam' 

(in short: Band 4,3,2 of a raster2pgsql-loaded Landsat-8 image (overview 8 
version) for a municipality polygon (administrative commune boundary).

Execute (F5) correctly returns a single row (and I can save the union result 
with ST_AsTIFF() to file in a script)

When I try to Load as a new layer to visualise the result in QGIS, I get the 
following error message:

Erroneous query: SELECT DISTINCT upper(geometrytype(rast)),st_srid(rast) 
FROM (select 1 as rid, st_union(st_band(rast, '4,3,2') ) as rast
from o_8_lc81970232013202lgn00_all_rds_sub, gemeentegebieden
where gemeentegebieden.wkb_geometry  rast
and gemnaam = 'Veendam' 
) AS subQuery_0 returned 7 [ERROR:  function geometrytype(raster) does not 
exist
LINE 1: SELECT DISTINCT upper(geometrytype(rast)),st_srid(rast) ...
  ^
HINT:  No function matches the given name and argument types. You might need to 
add explicit type casts.
]

Apparently, my query get wrapped  in the SELECT DISTINCT outer query above 
(which obviously does not work).

Is this a known issue, and, if so, can it be modified, for instance by 
providing explicitly geometrytype and srid (and if so, how?).

I also checked out the wktraster plugin, but that does not work for 2.2. Is an 
upgrade expected soon [or should I try writing it myself].

Thanks for all the wonderful stuff,

Guido Lemoine  
___
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] Viewing SPOT5 imagery as pseudo-RGB in QGIS

2014-03-07 Thread Zoltan Szecsei

Hi,
I've got some SPOT5 imagery that I want to convert to (close to) real 
colour, and am told that:

Band 1 is green
Band 2 is red
Band 3 is NIR
band 4 is shortwave IR

I found two different methods for creating pseudo-Blue. (or pseudo RGB)
Blue = 0.7*Green + 0.24*Red - 0.15*NIR
and the other was:
Blue = 0.85*Band 1 - 0.15*B3
Green = 0.65*Band 1 + 0.35*Band 3
Red = Band 2

so they are fairly similar (assuming the second one has the same band 
order as my image).


I use gdal_calc.py to create the 3 separate band-tif images and then 
gdal_merge.py to create my two variants of the RGB tiffs.


When I open these images in QGIS 2.0.1, they are brownish rather that 
pseudo RGB
I have set the 'style' to multiband colour, loaded the min/max values 
and then set contrast to Stretch to Min/Max.
I have also tried various combinations of the 3 bands in case 
gdal_merge.py doesn't honour file-order to band order.


Can anyone offer a solution to this issue?

Thanks and regards,
Zoltan.

FYI My script is as follows:

# 20140307 - Zls do bandmath to create create synthetic RGB
TIFin=3229AA
gdal_calc.py-A ${TIFin}.tif --A_band=1\
-B ${TIFin}.tif --B_band=2\
-C ${TIFin}.tif --C_band=3\
-D ${TIFin}.tif --D_band=4\
--outfile=${TIFin}r.tif\
--overwrite\
--calc=B
#
gdal_calc.py-A ${TIFin}.tif --A_band=1\
-B ${TIFin}.tif --B_band=2\
-C ${TIFin}.tif --C_band=3\
-D ${TIFin}.tif --D_band=4\
--outfile=${TIFin}g.tif\
--overwrite\
--calc=A
#   --calc=(A*0.65)+(C*0.35)
#
gdal_calc.py-A ${TIFin}.tif --A_band=1\
-B ${TIFin}.tif --B_band=2\
-C ${TIFin}.tif --C_band=3\
-D ${TIFin}.tif --D_band=4\
--outfile=${TIFin}b.tif\
--overwrite\
--calc=(A*0.7)+(B*0.24)-(C*0.14)
#   --calc=(A*0.85)-(C*0.15)
#
rm -f ${TIFin}rgb.tif  /dev/null 2 /dev/null
gdal_merge.py   -o ${TIFin}rgbx.tif\
-separate\
${TIFin}r.tif\
${TIFin}g.tif\
${TIFin}b.tif



--

===
Zoltan Szecsei PrGISc [PGP0031]
Geograph (Pty) Ltd.
GIS and Photogrammetric Service

P.O. Box 7, Muizenberg 7950, South Africa.

Mobile: +27-83-6004028
Fax:+27-86-6115323 www.geograph.co.za
===

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

Re: [Qgis-user] PostGIS raster access in QGIS using DBManager (or wktraster)

2014-03-07 Thread José Carlos Martínez Llario

Hi,
you just have to add the layer from db manager directly, it is working 
with raster too.
I already did few days ago with QGIS 2.2 with PostGIS Raster, it worked 
really well better than other previous versions of QGIS.

cheers,
Jose Carlos Martinez


On 07/03/2014 10:40, José Pedro Santos wrote:

Ciao Guido,

DBManager is only for vector layers..In the version 1.8 existed a 
plugin for importing raster layers but wasn't update for this new 
version.


Regards,
José Santos


From: guido.lemo...@jrc.ec.europa.eu
To: qgis-user@lists.osgeo.org
Date: Fri, 7 Mar 2014 07:51:33 +0100
Subject: [Qgis-user] PostGIS raster access in QGIS using DBManager (or 
wktraster)


Dear QGIS users,

[This was posted on QGIS developer as well, but maybe I should seek 
the solution here]



I am using QGIS 2.2 .0 (Valmiera) and trying to load a raster query 
result via DBManager, using the following query:


select 1 as rid, st_union(st_band(rast, '4,3,2') ) as rast
from o_8_lc81970232013202lgn00_all_rds_sub, municipalities
where municipalities.wkb_geometry  rast
and munname = 'Veendam'

(in short: Band 4,3,2 of a raster2pgsql-loaded Landsat-8 image 
(overview 8 version) for a municipality polygon (administrative 
commune boundary).


Execute (F5) correctly returns a single row (and I can save the union 
result with ST_AsTIFF() to file in a script)


When I try to Load as a new layer to visualise the result in QGIS, I 
get the following error message:


Erroneous query: SELECT DISTINCT 
upper(geometrytype(rast)),st_srid(rast) FROM (select 1 as rid, 
st_union(st_band(rast, '4,3,2') ) as rast

from o_8_lc81970232013202lgn00_all_rds_sub, gemeentegebieden
where gemeentegebieden.wkb_geometry  rast
and gemnaam = 'Veendam'
) AS subQuery_0 returned 7 [ERROR:  function geometrytype(raster) 
does not exist

LINE 1: SELECT DISTINCT upper(geometrytype(rast)),st_srid(rast) ...
  ^
HINT:  No function matches the given name and argument types. You 
might need to add explicit type casts.

]

Apparently, my query get wrapped  in the SELECT DISTINCT outer query 
above (which obviously does not work).


Is this a known issue, and, if so, can it be modified, for instance by 
providing explicitly geometrytype and srid (and if so, how?).


I also checked out the wktraster plugin, but that does not work for 
2.2. Is an upgrade expected soon [or should I try writing it myself].


Thanks for all the wonderful stuff,

Guido Lemoine


___ 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] PostGIS raster access in QGIS using DBManager (or wktraster)

2014-03-07 Thread Guido Lemoine
Jose Carlos,

 

Thanks for your answers. I know the option to “Add to Canvas” for a raster
layer that shows up in the DBManager interface.

Problem is that I connect over the network, and Landsat images are typically
150 Mb per band. 

This is why I prefer to select well-delineated areas that are reasonable in
size, for which the raster selection query seem to be just the right
solution.

 

Even better would be a “Add PostGIS raster layer” on the left menu, that
would logically go for the re-sampled pyramid layers, if available in the
database, or warn when really big images would be requested [over a network
connection]. 

 

As a start, I guess I will have to dig out the old version of DBManager and
restore the raster functionality…

 

Guido

 

From: qgis-user-boun...@lists.osgeo.org
[mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of José Carlos Martínez
Llario
Sent: 07 March 2014 10:45
To: qgis-user@lists.osgeo.org
Subject: Re: [Qgis-user] PostGIS raster access in QGIS using DBManager (or
wktraster)

 

Hi,
you just have to add the layer from db manager directly, it is working with
raster too.
I already did few days ago with QGIS 2.2 with PostGIS Raster, it worked
really well better than other previous versions of QGIS.
cheers,
Jose Carlos Martinez



On 07/03/2014 10:40, José Pedro Santos wrote:

Ciao Guido,

DBManager is only for vector layers..In the version 1.8 existed a plugin for
importing raster layers but wasn't update for this new version. 

Regards,
José Santos 

  _  

From: guido.lemo...@jrc.ec.europa.eu
To: qgis-user@lists.osgeo.org
Date: Fri, 7 Mar 2014 07:51:33 +0100
Subject: [Qgis-user] PostGIS raster access in QGIS using DBManager (or
wktraster)

Dear QGIS users,

[This was posted on QGIS developer as well, but maybe I should seek the
solution here]


I am using QGIS 2.2 .0 (Valmiera) and trying to load a raster query result
via DBManager, using the following query:

select 1 as rid, st_union(st_band(rast, '4,3,2') ) as rast
from o_8_lc81970232013202lgn00_all_rds_sub, municipalities
where municipalities.wkb_geometry  rast
and munname = 'Veendam' 

(in short: Band 4,3,2 of a raster2pgsql-loaded Landsat-8 image (overview 8
version) for a municipality polygon (administrative commune boundary).

Execute (F5) correctly returns a single row (and I can save the union result
with ST_AsTIFF() to file in a script)

When I try to Load as a new layer to visualise the result in QGIS, I get
the following error message:

Erroneous query: SELECT DISTINCT upper(geometrytype(rast)),st_srid(rast)
FROM (select 1 as rid, st_union(st_band(rast, '4,3,2') ) as rast
from o_8_lc81970232013202lgn00_all_rds_sub, gemeentegebieden
where gemeentegebieden.wkb_geometry  rast
and gemnaam = 'Veendam' 
) AS subQuery_0 returned 7 [ERROR:  function geometrytype(raster) does not
exist
LINE 1: SELECT DISTINCT upper(geometrytype(rast)),st_srid(rast) ...
  ^
HINT:  No function matches the given name and argument types. You might need
to add explicit type casts.
]

Apparently, my query get wrapped  in the SELECT DISTINCT outer query above
(which obviously does not work).

Is this a known issue, and, if so, can it be modified, for instance by
providing explicitly geometrytype and srid (and if so, how?).

I also checked out the wktraster plugin, but that does not work for 2.2. Is
an upgrade expected soon [or should I try writing it myself].

Thanks for all the wonderful stuff,

Guido Lemoine

 

 


___ 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

[Qgis-user] Beginner: How to find duplicate points with the Topology Checker plug-in

2014-03-07 Thread Robert Harris

Hello All,

I am a beginner using 2.0.1-Dufour on Ubuntu 12.04.

I digitized a poly line into a shapefile that represents a water 
feature. I used Vector/Extract Nodes to create a point shapefile. I 
added fields to the attribute table with longitude and latitude of each 
point with the Field Calculator. I imported the attribute table into an 
MS Access database and used the Find Duplicates query wizard to find 11 
pairs of duplicate points in 2052 total points. The points are needed 
for use with the Google Maps API.


I tried the Vector/Topology Checker plug-in with a must not have 
duplicates rule to find the duplicate points and received a 0 errors 
were found message.


What am I missing when using the Topology Checker plug-in?

Thank you.

Robert Harris, Volunteer
Georgia River Network
http://www.garivers.org/



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

[Qgis-user] Installerpackage QGIS 2.2 OSX 10.6?

2014-03-07 Thread Joris HINTJENS
Hi there,
Just upgraded my Imac to OS 10.6
Any chance to find someday an installerpackage QGIS2.2 for my OS?
For now, the computer says noo!



Joris  HINTJENS

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

[Qgis-user] Snap to Vertex

2014-03-07 Thread Chuck Young
Thanks in advance for the help!

I am making a layer of polygons and want to snap to the vertices of the
adjacent polygon when creating boundaries.  I have heard that it is a
function but haven't found it.  Probably looking in the wrong place.

Thanks again!

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

Re: [Qgis-user] Selecting rasters with vector layer

2014-03-07 Thread skampus
hi etienne, it seems that compression is also possible via GUI

http://i59.tinypic.com/2ueilg9.png



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/Selecting-rasters-with-vector-layer-tp5107230p5108192.html
Sent from the Quantum GIS - User mailing list archive at Nabble.com.
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user


Re: [Qgis-user] Installerpackage QGIS 2.2 OSX 10.6?

2014-03-07 Thread Richard Duivenvoorde
On 07-03-14 15:16, Joris HINTJENS wrote:
 Hi there,
 
 Just upgraded my Imac to OS 10.6
 
 Any chance to find someday an installerpackage QGIS2.2 for my OS?
 
 For now, “the computer says noo!”

Installers are provided by William. This is what he says about 10.6:

http://www.kyngchaos.com/blog/2014/20140223_snow_leopard_support_ending

Regards,

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


Re: [Qgis-user] Snap to Vertex

2014-03-07 Thread Alexandre Neto
Hello chuck,

Settings  Snapping Options...

Notice you can select both segments and vertex (default) or only one of
option. Also, you can set tolerance in map units or in screen units
(pixels). I normally prefer snap to vertex only and 5 to 10 pixel of
tolerance.

Don't forget to check the box to the left of the layers names to make the
snapping active.

Also notice the avoid intersection option that is quite useful while
creating adjacent polygons.


Alexandre Neto


On Fri, Mar 7, 2014 at 2:36 PM, Chuck Young wylie1...@gmail.com wrote:

 Thanks in advance for the help!

 I am making a layer of polygons and want to snap to the vertices of the
 adjacent polygon when creating boundaries.  I have heard that it is a
 function but haven't found it.  Probably looking in the wrong place.

 Thanks again!

 chuck

 ___
 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] Selecting rasters with vector layer

2014-03-07 Thread Etienne Tourigny
I know (I did part of it) - but it's not available for all tools... For
example, the Translate tool has it, but not the Warp tool.

Perhaps it would be easier to add to all the tools if it were part of the
default tool interface (which shows the command line etc.)


On Fri, Mar 7, 2014 at 11:38 AM, skampus skam...@gmail.com wrote:

 hi etienne, it seems that compression is also possible via GUI

 http://i59.tinypic.com/2ueilg9.png



 --
 View this message in context:
 http://osgeo-org.1560.x6.nabble.com/Selecting-rasters-with-vector-layer-tp5107230p5108192.html
 Sent from the Quantum GIS - User mailing list archive at Nabble.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] Snap to Vertex

2014-03-07 Thread M. LATTES
Hi Chuck,



I've recently discovered the AutoTrace extension (available in the official
QGIS repository).

I think it's what you need.



Mathieu.





De : qgis-user-boun...@lists.osgeo.org
[mailto:qgis-user-boun...@lists.osgeo.org] De la part de Chuck Young
Envoyé : vendredi 7 mars 2014 15:36
À : Qgis-user@lists.osgeo.org
Objet : [Qgis-user] Snap to Vertex



Thanks in advance for the help!

I am making a layer of polygons and want to snap to the vertices of the
adjacent polygon when creating boundaries.  I have heard that it is a
function but haven't found it.  Probably looking in the wrong place.

Thanks again!

chuck



---
Ce courrier électronique ne contient aucun virus ou logiciel malveillant parce 
que la protection avast! Antivirus est active.
http://www.avast.com
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] qgis 2.2 on ubuntugis-unstable for Raring?

2014-03-07 Thread Pedro Jorge de Sousa Ferreira
Alex Mandel-2 wrote
 What version did it give you?
 
 Thanks,
 Alex

Hi,
It installed QGIS 2.0.1-Dufor

Thanks
Pedro




--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/qgis-2-2-on-ubuntugis-unstable-for-Raring-tp5107636p5117290.html
Sent from the Quantum GIS - User mailing list archive at Nabble.com.
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user


[Qgis-user] Missing SVG's - now represented by a ? - ?

2014-03-07 Thread Jonathan Moules
Hi List,
I have a QML file I created some time ago. When I open it in QGIS now it
can't find the SVG files - that's fine, it's because they're not there.

My problem is that rather than not rendering the icons, what QGIS now
appears to be doing is instead rendering little ? icons. I can't figure
out how this is desirable (well, unless you're the Riddler I guess).

Previously in this circumstance QGIS simply didn't render the missing
SVG's, which was fine. But now I have a very unprofessional looking map
style.

I am aware I can update my QML to remove the SVG's, however it's quite
large and I'd rather not have to.

So my question for the list - am I the only person who preferred the old
behaviour?

Cheers,
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.
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Relationships and SQL Spatial as Child

2014-03-07 Thread Alex Mandel
Sounds like a bug, I suspect that your db combo is more rare and not
many people have tried it yet.
Ask on the developer list or file a ticket on hub.qgis.org

thanks,
Alex

On 03/07/2014 07:24 AM, James Wood wrote:
 Just wanted to float this one again to see if anyone had any feedback.
 
 Thanks,
 
 -- Forwarded message --
 From: James Wood jwood...@gmail.com
 Date: Sun, Mar 2, 2014 at 10:43 AM
 Subject: Relationships and SQL Spatial as Child
 To: QGIS-User Mailing List qgis-user@lists.osgeo.org
 
 
 Hello QGIS Users,
 Just wanted to know if anyone else has run into this...
 I'm running QGIS 2.2 x64 (OSGeo4W installer) on Windows 7 SP1.
 
 When trying to utilize the new Relations piece (which is a GREAT addition),
 I can establish relationships and have them work perfectly except when the
 child (or referencing layer) is in my SQL Express 2012 database. I set up a
 test project with identical address points and parcel layers in PostGIS,
 SpatiaLite and SQL. I can get any combination to work, but when the child
 layer is in the SQL db it will not.
 
 A picture is worth a thousand words, so I took some screenshots:
 
 
 
 
 
 
 I've double-checked the linking ID field for the parcels and it is always a
 1:1 with the address point I have identified. However, just to be sure it
 wasn't something funky with the parcel base, I established a link between
 the address points and an aed (defibrillator) point layer that I had with
 the same result. I also tried establishing a relationship with a
 non-geometry table in another db in the same instance without any luck.
 
 
 I'll be interested in your feedback...
 
 Thanks,
 James
 
 
 
 ___
 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] Installerpackage QGIS 2.2 OSX 10.6?

2014-03-07 Thread Paulo Gali Macedo
Hi Joris,

Just to tell you , and the rest of the mailing list,..., that I have the same 
problem as you.


KingKaos has already told us he will no longer be compiling the new QGIS 
versions for Snow Leopard... 

I invited him to reconsider,...

Maybe we are not alone,... 

Let Our Voice Be Heard...!!!




All The Best

Paulo Gali Macedo



(Prof. Paulo Gali Macedo)

Departamento de Física e Astronomia
Faculdade de Ciencias da Universidade do Porto
R. do Campo Alegre,  687
4169-007 Porto
PORTUGAL
_
Tel . (+351)-220402854


HOME ADRESS:

 R. Hernani Torres, 39 - 7 Esq.
4200-320  Porto
PORTUGAL

Home Tel .  (+351)-225021945
TM.(+351)-965871512

e-mail:

pgmac...@fc.up.pt




On 7 de Mar de 2014, at 14:16, Joris HINTJENS wrote:

 Hi there,
 Just upgraded my Imac to OS 10.6
 Any chance to find someday an installerpackage QGIS2.2 for my OS?
 For now, “the computer says noo!”
  
  
  
 Joris  HINTJENS
  
 ___
 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] Installerpackage QGIS 2.2 OSX 10.6?

2014-03-07 Thread Etienne Tourigny
Maybe it's time to find sponsors for hosted environments to build qgis on
osx...


On Fri, Mar 7, 2014 at 11:46 AM, Richard Duivenvoorde
rdmaili...@duif.netwrote:

 On 07-03-14 15:16, Joris HINTJENS wrote:
  Hi there,
 
  Just upgraded my Imac to OS 10.6
 
  Any chance to find someday an installerpackage QGIS2.2 for my OS?
 
  For now, the computer says noo!

 Installers are provided by William. This is what he says about 10.6:

 http://www.kyngchaos.com/blog/2014/20140223_snow_leopard_support_ending

 Regards,

 Richard Duivenvoorde
 ___
 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] Installerpackage QGIS 2.2 OSX 10.6?

2014-03-07 Thread Alex Mandel
It's a tricky problem, somewhat related to number of users
http://www.netmarketshare.com/operating-system-market-share.aspx?qprid=10qpcustomd=0qptimeframe=Y
10.6 share has been declining 20% over the last year (relative to itself).

At what point do we cut off? I expect at some point not all the
dependencies will even be buildable on the system. The only way I can
see supporting a lot of versions is if it's fairly automated process.
Right now there seems to be quite a bit of work by hand to keep things
all in step. Or do we drop it off once the number of worldwide users is
below a certain limit?

Linux is the same way, Ubuntu 10.04 is about to get dropped out of new
releases(if it isn't already when 14.04 comes out) and it is newer than
OS X 10.6

Of course Mac users have another issue, because of hardware OS X 10.6
might be the highest they can ever go with OS X. Which only leaves one
option (faced by many people with computers), do I buy new hardware or
switch to recent linux and get another 5 years+ out of the machine with
security patches and software upgrades. I guess technically there should
be people with 3 year old machines that came with 10.6, so at least
another 2-4 years of security patches from Apple.

Maybe someone has a spare 10.6 machine and wants to learn from William
how to make the builds on it?

Thanks,
Alex

On 03/07/2014 03:54 PM, Etienne Tourigny wrote:
 Maybe it's time to find sponsors for hosted environments to build qgis on
 osx...
 
 
 On Fri, Mar 7, 2014 at 11:46 AM, Richard Duivenvoorde
 rdmaili...@duif.netwrote:
 
 On 07-03-14 15:16, Joris HINTJENS wrote:
 Hi there,

 Just upgraded my Imac to OS 10.6

 Any chance to find someday an installerpackage QGIS2.2 for my OS?

 For now, the computer says noo!

 Installers are provided by William. This is what he says about 10.6:

 http://www.kyngchaos.com/blog/2014/20140223_snow_leopard_support_ending

 Regards,

 Richard Duivenvoorde
 ___
 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] Installerpackage QGIS 2.2 OSX 10.6?

2014-03-07 Thread William Kyngesburye
Building on OS X isn't hard, just tedious.  The build instructions are very 
detailed, so anyone should be able to roll their own if needed on an older 
system.  The last Qt 4.8.5 installer works on 10.6, and dependencies should be 
buildable on 10.6 for a long time.

There are also OS X package managers to simplify the process.  I think MacPorts 
is still alive, and Homebrew has become very popular. (Though they can cause 
trouble if you also compile software from scratch outside their environments.)

Note: if you read my blog about it, in my interpretation of the hardware 
maintenance it's the hardware that Apple supports, and it's the latest version 
of the system software that the hardware supports that is maintained, not the 
original version of the system.  So 10.6 is dead now.  Which has been verified 
in the latest security update that was for 10.7+.

I've mentioned my policy in the past and have been following it for years.  
It's just hitting a little hard this time because of the long life Snow Leopard 
had.

On Mar 7, 2014, at 10:23 PM, Alex Mandel wrote:

 It's a tricky problem, somewhat related to number of users
 http://www.netmarketshare.com/operating-system-market-share.aspx?qprid=10qpcustomd=0qptimeframe=Y
 10.6 share has been declining 20% over the last year (relative to itself).
 
 At what point do we cut off? I expect at some point not all the
 dependencies will even be buildable on the system. The only way I can
 see supporting a lot of versions is if it's fairly automated process.
 Right now there seems to be quite a bit of work by hand to keep things
 all in step. Or do we drop it off once the number of worldwide users is
 below a certain limit?
 
 Linux is the same way, Ubuntu 10.04 is about to get dropped out of new
 releases(if it isn't already when 14.04 comes out) and it is newer than
 OS X 10.6
 
 Of course Mac users have another issue, because of hardware OS X 10.6
 might be the highest they can ever go with OS X. Which only leaves one
 option (faced by many people with computers), do I buy new hardware or
 switch to recent linux and get another 5 years+ out of the machine with
 security patches and software upgrades. I guess technically there should
 be people with 3 year old machines that came with 10.6, so at least
 another 2-4 years of security patches from Apple.
 
 Maybe someone has a spare 10.6 machine and wants to learn from William
 how to make the builds on it?
 
 Thanks,
 Alex
 
 On 03/07/2014 03:54 PM, Etienne Tourigny wrote:
 Maybe it's time to find sponsors for hosted environments to build qgis on
 osx...
 
 
 On Fri, Mar 7, 2014 at 11:46 AM, Richard Duivenvoorde
 rdmaili...@duif.netwrote:
 
 On 07-03-14 15:16, Joris HINTJENS wrote:
 Hi there,
 
 Just upgraded my Imac to OS 10.6
 
 Any chance to find someday an installerpackage QGIS2.2 for my OS?
 
 For now, the computer says noo!
 
 Installers are provided by William. This is what he says about 10.6:
 
 http://www.kyngchaos.com/blog/2014/20140223_snow_leopard_support_ending
 
 Regards,
 
 Richard Duivenvoorde
 ___
 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

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

The equator is so long, it could encircle the earth completely once.

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


Re: [Qgis-user] Installerpackage QGIS 2.2 OSX 10.6?

2014-03-07 Thread Nathan Woodrow
On Sat, Mar 8, 2014 at 4:02 PM, William Kyngesburye
wokl...@kyngchaos.comwrote:

  It's just hitting a little hard this time because of the long life Snow
 Leopard had.


I would just like to welcome OS X users to a life us Windows users have
been dealing with for a long time :) Yay Windows XP...

:)

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

Re: [Qgis-user] Installerpackage QGIS 2.2 OSX 10.6?

2014-03-07 Thread gene
You can still use the masters versions of Larry Shaffer,  
http://qgis.dakotacarto.com/ http://qgis.dakotacarto.com/  : every day a 
new Snow Leopard version



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/Installerpackage-QGIS-2-2-OSX-10-6-tp5108184p5127856.html
Sent from the Quantum GIS - User mailing list archive at Nabble.com.
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user