[Qgis-user] Add mssql non-geometric tables

Fri May 1 10:36:50 PDT 2015

‎Hi

I guess you want to add non-geometric data to a already existing qgis data. In that case you will need to Join Attributes. You can find this option in the Vector menu. The prerequisite for this is that you should have one column common to both data tables, such as the ID column. This will ensure that the attributes of corresponding IDs will get joined. 

Hope this helps.

Abhijit

  Original Message  
From: qgis-user-request at lists.osgeo.org
Sent: Friday 1 May 2015 19:00
To: qgis-user at lists.osgeo.org
Reply To: qgis-user at lists.osgeo.org
Subject: Qgis-user Digest, Vol 111, Issue 1

Send Qgis-user mailing list submissions to
qgis-user at 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-request at lists.osgeo.org

You can reach the person managing the list at
qgis-user-owner at 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. Add mssql non-geometric tables (Peter Sch?rch)
2. Re: [QGIS-UX] QGIS fonts in print composer (Anita Graser)
3. Field expression for file name? (nicolas.cadieux at archeotec.ca)
4. Problem with loading layers from a project (James Keener)
5. How to get a subset of polygons crossed by lines?
(Patrick Giraudoux)
6. Composite satellite images (Susan Iremonger)

----------------------------------------------------------------------

Message: 1
Date: Thu, 30 Apr 2015 18:55:43 +0000
From: Peter Sch?rch <p.schuerch at meierpartner.ch>
To: "qgis-user at lists.osgeo.org" <qgis-user at lists.osgeo.org>
Subject: [Qgis-user] Add mssql non-geometric tables
Message-ID: <08DFDFED-18E9-49F3-B359-A22C069C701D at meierpartner.ch>
Content-Type: text/plain; charset="utf-8"

Hi
Does anybody know how to add a non-geometric table from an mssql database to a qgis project?
Do I need to add it in the table "geometry_columns"? If yes what would be the appropriate attribute values there?

Thanks
Peter Sch?rch
--
Meier und Partner AG
Freiestrasse 26<x-apple-data-detectors://1/0>
8570 Weinfelden<x-apple-data-detectors://1/0>
www.meierpartner.ch<http://www.meierpartner.ch/>
T +41 71 626 5115<tel:+41%2071%20626%205115>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20150430/f0318f2f/attachment-0001.html>

------------------------------

Message: 2
Date: Thu, 30 Apr 2015 21:48:35 +0200
From: Anita Graser <anitagraser at gmx.at>
To: Sarah Van Vliet <sarahvvv at gmail.com>
Cc: "qgis-ux at lists.osgeo.org" <qgis-ux at lists.osgeo.org>,	qgis-user
<Qgis-user at lists.osgeo.org>
Subject: Re: [Qgis-user] [QGIS-UX] QGIS fonts in print composer
Message-ID:
<CAFFV8FjTsAwic7ptsfJ+W7J+JgCM3TdUSQVb6-5+TcM64u717w at mail.gmail.com>
Content-Type: text/plain; charset="utf-8"

Hi Sarah,
I'm afraid this does not seem like a question for the usability mailing
list. Please use the user mailing list for problems relating to the use of
certain QGIS features. Also, can you provide the font you mentioned for
debugging purposes?
Best wishes,
Anita

On Thu, Apr 30, 2015 at 8:25 PM, Sarah Van Vliet <sarahvvv at gmail.com> wrote:

> Hi qgis community,
>
> My team and I are having trouble with fonts in qgis print composer. we all
> have various versions as we all joined at different times. ( i use 2.4.0,
> while one other colleague uses 2.6.1, etc. ). We use a font set called Clan
> Pro, and only some of the fonts work at any given font size. What's more,
> which fonts work and don't seems to vary amongst all of us!
>
> does anybody know a solution? is there some version of qgis where fonts
> are better functioning?
>
> Thanks,
> Sarah
>
> _______________________________________________
> QGIS-UX mailing list
> QGIS-UX at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/qgis-ux
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20150430/31861af5/attachment-0001.html>

------------------------------

Message: 3
Date: Thu, 30 Apr 2015 16:28:08 -0400
From: "nicolas.cadieux at archeotec.ca" <nicolas.cadieux at archeotec.ca>
To: <qgis-user at lists.osgeo.org>
Subject: [Qgis-user] Field expression for file name?
Message-ID: <55429058.70708 at archeotec.ca>
Content-Type: text/plain; charset="utf-8"; format=flowed

Hi,
I am building an index of a LiDar project (using .las files). I can use 
lasboundary.exe to create .shp boundary polygon for each individual file 
(using the merge option will only create one big polygon). I can then 
use "vector/data management tools/merge the shapefile to one" to make 
one file.

The problem is I need a field (the file names) for each polygon. Is 
there an field expression for this?

This field is not created by lasboundary or my "merge the shapefile to 
one". Perhaps I can use the "Advanced Python field calculator" in batch 
mode in the processing plugin but I don't know how to return the files 
names. Can someone help or give my and idea of how to proceed?

Thanks in advance
Nicolas

------------------------------

Message: 4
Date: Fri, 01 May 2015 01:34:14 -0400
From: James Keener <jim at jimkeener.com>
To: qgis-user at lists.osgeo.org
Subject: [Qgis-user] Problem with loading layers from a project
Message-ID: <55431056.3070702 at jimkeener.com>
Content-Type: text/plain; charset="utf-8"

I'm trying to load a project via python (original project and the single
shp file (the extension should be .zip), along with the project after
saving, are attached). When I load the project, there are no layers,
and if I write the project out, it doesn't contain the original layer
either.

Python transcript:
> jim at lilith {+81% } Fri 2015-05-01 01:16:00 0 
> /home/jim/Desktop/test
> % export PYTHONPATH=/usr/share/qgis/python
> jim at lilith {+82% } Fri 2015-05-01 01:16:02 0 
> /home/jim/Desktop/test
> % python 
> Python 2.7.6 (default, Mar 22 2014, 22:59:56) 
> [GCC 4.8.2] on linux2
> Type "help", "copyright", "credits" or "license" for more information.
>>>> from qgis.core import QgsProject
>>>> from PyQt4.QtCore import QFileInfo
>>>> project = QgsProject.instance()
>>>> project.read(QFileInfo('test.qgs'))
> True
>>>> map(lambda i: i.name(), project.layerTreeRoot().children())
> []
>>>> project.write()
> True

Before and After sizes:
> jim at lilith {+81% } Fri 2015-05-01 01:15:14 0 
> /home/jim/Desktop/test
> % ls -l test.qgs
> -rw-rw-r-- 1 jim jim 14222 May 1 01:15 test.qgs
> jim at lilith {+82% } Fri 2015-05-01 01:16:20 0 
> /home/jim/Desktop/test
> % ls -l test.qgs
> -rw-rw-r-- 1 jim jim 1654 May 1 01:17 test.qgs

I'm sure (or at least hope!) that I'm just doing something little (and
non-obvious?) wrong.

As an aside: this is a condensed test. If you add a group into the
project, the group will show up in the layer list and will be written
back out, but no other layers will be found.

Thank you,
Jim

PS:

contents of PYTHONPATH, in case I'm not using the right location

> jim at lilith {+90% } Fri 2015-05-01 01:28:05 0 
> /home/jim/Desktop/test
> % ls -l $PYTHONPATH 
> total 20
> drwxr-xr-x 2 root root 4096 Feb 26 10:46 console/
> drwxr-xr-x 6 root root 4096 Feb 26 10:46 owslib/
> drwxr-xr-x 7 root root 4096 Aug 20 2014 plugins/
> drwxr-xr-x 2 root root 4096 Feb 26 10:46 pyplugin_installer/
> drwxr-xr-x 2 root root 4096 Feb 26 10:46 qsci_apis/

I had seen somewhere about doing QgsApplication.initQgis(), so I gave
that a shot:

> % python
> Python 2.7.6 (default, Mar 22 2014, 22:59:56) 
> [GCC 4.8.2] on linux2
> Type "help", "copyright", "credits" or "license" for more information.
>>>> from qgis.core import QgsApplication
>>>> from qgis.core import QgsProject
>>>> from PyQt4.QtCore import QFileInfo
>>>> QgsApplication.setPrefixPath('/usr/share/qgis', True)
>>>> QgsApplication.initQgis()
>>>> project = QgsProject.instance()
>>>> project.read(QFileInfo('test.qgs'))
> True
>>>> map(lambda i: i.name(), project.layerTreeRoot().children())
> []

to no avail :(
-------------- next part --------------
A non-text attachment was scrubbed...
Name: test.qgs
Type: application/x-qgis-project
Size: 14221 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20150501/d69e405b/attachment-0001.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Hospitals.really-a-zip
Type: application/zip
Size: 8405 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20150501/d69e405b/attachment-0001.zip>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20150501/d69e405b/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 836 bytes
Desc: OpenPGP digital signature
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20150501/d69e405b/attachment-0001.pgp>

------------------------------

Message: 5
Date: Fri, 01 May 2015 09:10:47 +0200
From: Patrick Giraudoux <patrick.giraudoux at univ-fcomte.fr>
To: qgis-user at lists.osgeo.org
Subject: [Qgis-user] How to get a subset of polygons crossed by lines?
Message-ID: <554326F7.90909 at univ-fcomte.fr>
Content-Type: text/plain; charset=windows-1252; format=flowed

Hello,

I have a question related to how the function "intersect" works. I have 
two shapefiles, one of lines the others of polygons. I would like to get 
into a shapefile the polygons that are intersected by the lines. I tried 
unsuccessfully using Vector > Geoprocessing tools > intersect. In this 
case, if the input is the lines and the intersect the polygon, I can 
split the lines according to the border of each polygon, and each 
segment is identified by the polygon name in the attribute, but this is 
not what I want to. If I do the reverse, I get an empty polygon vector 
file.

What I want is the shapefile of the subset of polygons that intersect 
the lines...

Any idea about how to proceed ?

Patrick

PS: for info, the expected result can be easily obtained in R, package 
'rgeos', function 'gIntersection'

------------------------------

Message: 6
Date: Fri, 1 May 2015 14:29:37 +0100
From: Susan Iremonger <s.iremonger at gmail.com>
To: qgis-user <qgis-user at lists.osgeo.org>
Subject: [Qgis-user] Composite satellite images
Message-ID:
<CAJ22J7C+Kz+w4r7k_t9rePRQEJaauq76gaBdVCBbk82LywhMOQ at mail.gmail.com>
Content-Type: text/plain; charset="utf-8"

re: item initally sent on 17 April.
Hi All, and in particular Raul Nanclares,
Many thanks to Raul for his input on my question about how to make a
multiband raster file for a Landsat image (his method attached below). I
tried this out and have got to the end of the first step, where I used
Merge(with "Stack" checked) to combine the single band files into one file.
I am doing landcover work so I am principally interested n Bands 3,4 and 5,
but hope also to sharpen the image with Band 8. The merge seemed to
succeed, and I now have bands 1-5 in the multiband raster file, and am
using bands BGR 234 and 345 in my Displays.

I tried to superimpose and pansharpen but kept getting this message:[image:
Inline image 1]
Perhaps "Superimpose sensor" is not the right Tool, but I couldn't see
another in the Orfeo Toolbox (?There doesn't seem to be a "search" for this
toolset?).
I got a similar message when I tried the Pansharpening Tool directly,
without doing the superimpose first, but I admit i am not sure what files I
am supposed to put in each field in these tools - I was using Ban 8 on its
own, and the multiband stack file I made.
Is there a Help for Orfeo, does anyone know? Or perhaps someone can see
where I am going wrong and what tool I should really be using?
Many thanks for any help.
--Susan.
_____________________________________
Raul Nanclares' inital reply (and thanks to Raul) to my first posting on
this subject was:
Date: Fri, 17 Apr 2015 09:26:53 -0700 (PDT)
From: RNanclares
To: qgis-user at lists.osgeo.org
Subject: Re: [Qgis-user] Composite satellite images
Message-ID: <1429288013030-5201867.post at n6.nabble.com>
Content-Type: text/plain; charset=us-ascii

Hi Susan,

first you need to use the merge/combine (i don't remember the exact name of
the tool in English) located in the Raster > Miscellaneous menu. You have to
check the option 'stack layers'.

To pansharpen the image, first you have to see if you have Orfeo Toolbox
installed and configured (in the Processing menu). If it is installed you
can continue by using the sumperimpose tool (in the processing toolbox).
After the superimpose has finished you can do the pansharpening using the
pansharpening (rcs) algorithm found in the processing toolbox.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20150501/97247e62/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 8360 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20150501/97247e62/attachment.png>

------------------------------

_______________________________________________
Qgis-user mailing list
Qgis-user at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

End of Qgis-user Digest, Vol 111, Issue 1
*****************************************