Sorry, 2.16.2 over ubuntu 16.
Bonjour.
Sent from my T-Mobile 4G LTE Device
-------- Original message --------
From: qgis-user-requ...@lists.osgeo.org
Date:09/14/2016 10:43 (GMT-04:00)
To: qgis-user@lists.osgeo.org
Subject: Qgis-user Digest, Vol 127, Issue 38
Send Qgis-user mailing list submissions to
qgis-user@lists.osgeo.org
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.osgeo.org/mailman/listinfo/qgis-user
or, via email, send a message with subject or body 'help' to
qgis-user-requ...@lists.osgeo.org
You can reach the person managing the list at
qgis-user-ow...@lists.osgeo.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Qgis-user digest..."
Today's Topics:
1. Re: Precision parameter on Select By Location tool
(Nicolas Cadieux)
----------------------------------------------------------------------
Message: 1
Date: Wed, 14 Sep 2016 07:42:19 -0700 (PDT)
From: Nicolas Cadieux <nicolas.cadi...@archeotec.ca>
To: qgis-user@lists.osgeo.org
Subject: Re: [Qgis-user] Precision parameter on Select By Location
tool
Message-ID: <42048476-b5d3-4ff1-958c-ac0e116ef...@archeotec.ca>
Content-Type: text/plain; charset="utf-8"
Hi,
I am on 2.12 and 2.14 and I can't see it? What version are you using? If it's
on an older version, perhaps it used to double check the geometries in a second
pass, the first pass being done on a spatial index and not on the objects them
selves. This is a guess.
Nicolas
Envoyé de mon iPad
> Le 14 sept. 2016 à 10:20, Ivan Santiago-2 [via OSGeo.org]
> <ml-node+s1560n5285861...@n6.nabble.com> a écrit :
>
> Hello all:
>
>
> Is there anybody that can tell what is the purpose of having a "Precision"
> parameter on
> Vector | Research Tools | Select by Location?
>
>
> Where I can find/read about how this "Precision" parameter works?
>
> Iván Santiago
> GIS Specialist
> Information Technologies
> PR Office of Management and Budget
> 787.725.9420 x 2409
> http://gis.pr.gov/
>
>
> De : Qgis-user <[hidden email]> de la part de [hidden email] <[hidden email]>
> Envoyé : 14 septembre 2016 09:55
> À : [hidden email]
> Objet : Qgis-user Digest, Vol 127, Issue 36
>
> Send Qgis-user mailing list submissions to
> [hidden email]
>
> 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
> [hidden email]
>
> You can reach the person managing the list at
> [hidden email]
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Qgis-user digest..."
>
>
> Today's Topics:
>
> 1. Re: QField error data source is not valid (Matthias Kuhn)
> 2. Re: Map composer. Wrong map scale (Carlo Cormio)
> 3. Re: xml metadata in PostGIS table (Richard McDonnell)
> 4. Re: Ubuntu updating instructions (Bernd Vogelgesang)
> 5. Organizing considering Dates (Bia)
> 6. Re: Raster calculator script failing for multiple rasters
> (Nicolas Cadieux)
> 7. Re: Map composer. Wrong map scale (Nicolas Cadieux)
> 8. Re: Organizing considering Dates (Tyler Veinot)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Wed, 14 Sep 2016 10:02:33 +0200
> From: Matthias Kuhn <[hidden email]>
> To: [hidden email]
> Subject: Re: [Qgis-user] QField error data source is not valid
> Message-ID: <[hidden email]>
> Content-Type: text/plain; charset=utf-8
>
> Hi Reginald,
>
> It's most likely that your project is not portable (i.e. paths inside
> are not relative).
>
> The documentation can be found here:
> http://www.qfield.org/docs/
>
> And about the portable project in particular here:
> http://www.qfield.org/docs/project-management/index.html
>
> Best regards
> Matthias
>
> On 09/14/2016 09:41 AM, Reginald Carlier wrote:
> > Hi,
> >
> >
> >
> > I’m testing QField. On my desktop I made a project with a shape point
> > layer made to inventarise streetbenches.
> >
> > Then I put this project in the storage folder (DCIM) of my android phone.
> >
> > On my phone I open QField and I browse to the project and I open it.
> >
> > In stead of a map I see only a point marker in QField.
> >
> > The error message I see is: OGR Data source is invalid()
> >
> > What am I doing wrong?
> >
> > Also I could not find any documentation on QField. Any pointers in this
> > direction?
> >
> >
> >
> > Regards,
> >
> >
> >
> >
> >
> > _______________________________________________
> > Qgis-user mailing list
> > [hidden email]
> > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
> >
>
>
> ------------------------------
>
> Message: 2
> Date: Wed, 14 Sep 2016 10:20:27 +0200
> From: Carlo Cormio <[hidden email]>
> To: Nyall Dawson <[hidden email]>
> Cc: qgis-user <[hidden email]>
> Subject: Re: [Qgis-user] Map composer. Wrong map scale
> Message-ID: <[hidden email]>
> Content-Type: text/plain; charset=utf-8; format=flowed
>
> No, I'm using QuickMapServices plugin
>
>
> Il 14/09/2016 09:39, Nyall Dawson ha scritto:
> > On 14 September 2016 at 17:32, Carlo Cormio <[hidden email]> wrote:
> >> Dear all,
> >>
> >> I'm using QGIS 2.12.3 on Windows 10. After printing a map using QGIS map
> >> composer, I checked some distances and found that map scale was different
> >> from the expected one.
> >> I set ISO A3, portrait, as page size. QGIS project has EPSG:3857 (due to
> >> the
> >> use of a google satellite layer), but most of the other layers have
> >> EPSG:32633. I tell you this in case it could affect prints.
> >> Map scale in print composer was set to 1:5000, but when I measured
> >> distances
> >> (I also put a scale in the composition) I found it was more or less 1:3500.
> >> The strange thing is that the ratio between the two scales is 1,41, that is
> >> exactly ISO A3:A4 ratio.
> >> What did I do wrong? Is there a setting I missed?
> > Are you using the OpenLayers plugin?
> >
> > Nyall
> >
> >
> >> Hope I gave all the necessary information.
> >>
> >> Regards,
> >>
> >> Carlo
> >> _______________________________________________
> >> Qgis-user mailing list
> >> [hidden email]
> >> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> >> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
>
> ------------------------------
>
> Message: 3
> Date: Wed, 14 Sep 2016 09:43:09 +0100
> From: Richard McDonnell <[hidden email]>
> To: "Schweitzer, Peter" <[hidden email]>
> Cc: [hidden email]
> Subject: Re: [Qgis-user] xml metadata in PostGIS table
> Message-ID: <[hidden email]>
> Content-Type: text/plain; charset="utf-8"; Format="flowed"
>
> Peter,
> Yes this is almost what I am looking for, 80% there....... you appear to
> be copying and pasting the whole xml, as opposed to reading a file
> directly to postgres, which is what I need.
> What I relay need to do is create a batch file for windows, which I can
> drop into the folder with the xml's and batch insert. Unfortunately, my
> knowledge of batching is not as good as I would like. The other option,
> even more daunting, is to utilise Python to do the batching.
> Thanks anyway for your help, its a better start, than the rest of the
> web was offering!!
> Regards,
>
> Richard.
>
>
>
> On 13/09/2016 17:28, Schweitzer, Peter wrote:
> > Richard,
> >
> > In PostgreSQL, I store some whole documents as XML, using
> >
> > create table something (
> > rec_id integer,
> > record xml
> > );
> >
> > and then insert like this:
> >
> > insert into something (rec_id,record) values ( 1,XMLPARSE (DOCUMENT
> > '<?xml version="1.0 encoding="UTF-8"?><...'));
> > By defining the field "record" as xml, I can use XML functions within
> > PostgreSQL to look at the contents (though I rarely do this). But the
> > parsing step also catches improper XML and rejects the insert with an
> > error message, very helpful.
> >
> > Is this the sort of information you're after?
> >
> > Peter
> >
> > On Tue, Sep 13, 2016 at 11:08 AM, Richard McDonnell
> > <[hidden email]> wrote:
> >> Hello all,
> >> I apologise if this is the incorrect forum for this question, but...
> >> Im looking to create a table and I want to insert the xml as an attribute.
> >> Anyone who uses the database stored styling in QGIS will have an idea what
> >> Im on about.
> >> I have thousands of these xml files and I want to insert the contents of
> >> each file.
> >> I have looked, but cant find it anywhere about the whole document in one
> >> field.
> >> Any help appreciated.
> >> Regards,
> >>
> >> Richard.
> >>
> >> OPW - Ag féachaint don am atá le teacht - Ag caomhnú ón am atá thart
> >> OPW - Looking to the future - Caring for the past
> >>
> >> ***********************************************************
> >> Email Disclaimer: http://www.opw.ie/en/disclaimer/
> >>
> >> _______________________________________________
> >> Qgis-user mailing list
> >> [hidden email]
> >> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> >> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
> >
> >
>
> --
> *_Richard McDonnell_*
> *GIS Specialist PgD GIS AssocSCSI*
> *OPW FRM Data Management*
> *52 Stephens Green, Dublin 2.*
> TEL: 01 6476543
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160914/f57d0144/attachment-0001.html>
>
> ------------------------------
>
> Message: 4
> Date: Wed, 14 Sep 2016 12:02:56 +0200
> From: "Bernd Vogelgesang" <[hidden email]>
> To: [hidden email]
> Subject: Re: [Qgis-user] Ubuntu updating instructions
> Message-ID: <op.ynrx66uxl2i25i@bernd-terra-pc>
> Content-Type: text/plain; charset="utf-8"; Format="flowed";
> DelSp="yes"
>
> Am 13.09.2016, 16:51 Uhr, schrieb Blumentrath, Stefan
> <[hidden email]>:
>
> >
> > And if I may add:
> >
> > Even if the users are aware of the fact that ubuntugis-unstable contains
> > the current releases, it can be hard to impossible >to convince a
> > GIS-ignorant system administrator that it is OK to install “unstable”
> > packages.
> >
> >
> > But this issue is not a QGIS issue I guess...
> >
> >
> >
> Actually, this problem could be easily solved, if there was only a single
> line of explanation added next to each of the repositories in the install
> instructions, so the uneducated or doubtful can be told and convinced
> which package ships which flavour.
> And yes, I was told to change this myself and given privileges to do so a
> while ago, but I couldn't find the energy to fiddle myself into the
> system. And I am still confused myself, cause behaviour seems to change
> from release to release a bit.
>
> At the moment, I can hardly write cause my right hand is in plaster and
> writing and pushing a mouse is a nightmare. So could not some less
> handicapped and more literate guy add some explanations to the website?
>
> Cheers
> Bernd
>
>
>
>
> >
> > From: Qgis-user [[hidden email]] On Behalf Of
> > Randal Hale
> > Sent: 13. september 2016 16:45
> > To: [hidden email]
> > Subject: Re: [Qgis-user] Ubuntu updating instructions
> >
> >
> >
> >
> > On 09/13/2016 10:23 AM, Jürgen E. Fischer wrote:
> >> Hi Randal,
> >>On Tue, 13. Sep 2016 at 00:21:21 -0400, Randal Hale wrote:
> >>> It's a little bit confusing. There are like three repositories:
> >>> stable, unstable, and testing. Testing you don't want (unless you
> >>> want to test packages). Typically stable is a bit older. Unstable is
> >>> current. Which doesn't really make sense - but that's the way it is.
> >>Not like it matters much in this case.
> >>We have packages in qgis.org/debian/ against the plain versions of the
> >> distributions (debian and **ubuntu**) and in qgis/ubuntugis/ packages
> >> against
> >> newer dependencies from - and only from - ubuntugis-unstable.
> >>Looks like it's hard for people to accept that there are also ubuntu
> >> packages
> >> in a directory called debian and that probably makes them jump on the
> >> other
> >> because it has ubuntu in it's name.
> >
> > I was thinking about it last night (and I was up way to late) and it is
> > a bit confusing for the casual user. They've installed Ubuntu (or
> > mint/debian/>xubuntu/etc) and they may not understand ubuntu is based
> > off debian. So like you said - they see debian but want to use Ubuntu.
> > They go to >UbuntuGIS and they see the repositories for UbuntuGIS and
> > the choice is unstable (and no one likes unstable software) and stable
> > (which doesn't >contain the newest software). So you end up going "Use
> > Unstable because it's stable and current".
> >>
> >>> Under my /etc/apt/sources.list.d directory I made a qgis.list file
> >>> and put the following in there:
> >>>deb http://qgis.org/debian xenial main
> >>> deb http://ppa.launchpad.net/ubuntugis/ubuntugis-unstable/ubuntu
> >>> xenial main
> >>Why? That are the packages not based on ubuntugis with the
> >> dependencies from
> >> ubuntugis.
> >
> > Do I have this wrong? I thought I had the repositories for the install
> > correct based off the directions on qgis.org. Which I could completely
> > have it >wrong. With the above repos I'm getting QGIS 2.16.x and GDAL
> > 2.1.x.
> >>Jürgen
> >>
> >>
> >>
> >>
> >> _______________________________________________
> >> Qgis-user mailing list
> >> [hidden email]
> >> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> >> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
> >
> >
> >
> > -------------------
> > Randal Hale
> > North River Geographic Systems, Inc
> > http://www.northrivergeographic.com
> > 423.653.3611 [hidden email]
> > twitter:rjhale
>
>
>
> --
> Bernd Vogelgesang
> Siedlerstraße 2
> 91083 Baiersdorf/Igelsdorf
> Tel: 09133-825374
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160914/515b41d6/attachment-0001.html>
>
> ------------------------------
>
> Message: 5
> Date: Wed, 14 Sep 2016 07:38:46 -0300
> From: Bia <[hidden email]>
> To: [hidden email]
> Subject: [Qgis-user] Organizing considering Dates
> Message-ID:
> <[hidden email]>
> Content-Type: text/plain; charset="utf-8"
>
> Hi, how can I to organize my table considering the date? I tried a
> expression but did not work.
> And after I wanna compare other columns to have a precision table.
>
> Thank you!
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160914/db9dd6fa/attachment-0001.html>
>
> ------------------------------
>
> Message: 6
> Date: Wed, 14 Sep 2016 04:56:19 -0700 (PDT)
> From: Nicolas Cadieux <[hidden email]>
> To: [hidden email]
> Subject: Re: [Qgis-user] Raster calculator script failing for multiple
> rasters
> Message-ID: <[hidden email]>
> Content-Type: text/plain; charset="utf-8"
>
> Hi what kind of error are you getting? Is Qgis just crashing? Do you get an
> error message? Does the script work with smaller files?
>
> Nicolas
>
> Envoyé de mon iPad
>
> > Le 14 sept. 2016 à 02:05, R HG [via OSGeo.org] <ml-node+[hidden email]> a
> > écrit :
> >
> > Thanks Nicolas for your reply.
> >
> > It does seem to be a memory problem, although it doesnt show the typical
> > "Memory Error". Without the script I could do that operation with the same
> > rasters. It involves four files and it is basically (a-b)*(c-d).
> >
> > GDAL also failed to load all files at once, so I finally splited the
> > operation in 3. (a-b) then (c-d) and finaly the multiplication of the
> > outputs. Its much more time consuming but it works.
> >
> > I still dont understand why using the tool directly from the UI it wrks and
> > it doesnt from the script. Will write back if I find the correct way.
> >
> >>
> >>
> >> Hi,
> >>
> >> I have never use the Qgis raster calculator via Python so I can't help
> >> there. What is the problem? Does Qgis crash? If so, the rasters may be to
> >> big for the memory. You mentioned the rasters were very big and that may
> >> be the problem. I recommend you test the calculation with smaller
> >> rasters. I think they are working for a solution for the big raster math.
> >>
> >> Saga and gdal calculator may help. Saga will probably try to load
> >> everything in memory an may crash. Gdal is made to calculate very big
> >> rasters but layers must be in the same CRS and have the same pixel posting
> >> and extent. You can use it direction in the Osgeo command prompt or via
> >> processing.
> >>
> >> Nicolas
> >>
> >>
> >> Envoyé de mon iPad
> >>
> >> > Le 13 sept. 2016 à 05:42, ROMAN HG [via OSGeo.org] <<a
> >> > href="javascript:;" onclick="_e(event, 'cvml',
> >> > 'ml-node+[hidden email]')">ml-node+s1560n5285491h82@...> a écrit
> >> > :
> >> >
> >> > Hi,
> >> >
> >> > I'm trying to do raster calculations with big and multiple rasters. I am
> >> > new to python, but I managed to use the QgsRasterCalculator algorithm to
> >> > do the average of three rasters.
> >> >
> >> > The problem comes when I introduce a forth layer and try to do a more
> >> > complex equation:
> >> >
> >> > #calculating c4s ( [c1-c2]*[c0-c3] )
> >> >
> >> > #F1_30
> >> > A=processing.getObjectFromUri(path + "/F1_30c1.tif")
> >> > B=processing.getObjectFromUri(path + "/F1_c2.tif")
> >> > C=processing.getObjectFromUri(path + "/F1_30c0.tif")
> >> > D=processing.getObjectFromUri(path + "/F1_c3.tif")
> >> >
> >> > entries=[]
> >> > rasA=QgsRasterCalculatorEntry()
> >> > rasA.ref='A@1'
> >> > rasA.raster=A
> >> > rasA.bandNumber=1
> >> > entries.append(rasA)
> >> >
> >> > rasB=QgsRasterCalculatorEntry()
> >> > rasB.ref='B@1'
> >> > rasB.raster=B
> >> > rasB.bandNumber=1
> >> > entries.append(rasB)
> >> >
> >> > rasC=QgsRasterCalculatorEntry()
> >> > rasC.ref='C@1'
> >> > rasC.raster=C
> >> > rasC.bandNumber=1
> >> > entries.append(rasC)
> >> >
> >> > rasD=QgsRasterCalculatorEntry()
> >> > rasD.ref='D@1'
> >> > rasD.raster=D
> >> > rasD.bandNumber=1
> >> > entries.append(rasD)
> >> >
> >> > F1_30c4=QgsRasterCalculator('(( A@1 - B@1 ) * ( C@1 - D@1 ))', path +
> >> > '/F1_30c4.tif', 'GTiff', base.extent(), base.width(), base.height(),
> >> > entries).processCalculation()
> >> >
> >> > I think that the problem is recognising the formula. I have tried it on
> >> > the console doing several changes and it doesnt work.
> >> >
> >> > Is it possible to do this operation with QgsRasterCalculator?? Or how
> >> > can I use the gdal_calc algorithm or the saga raster calculator??
> >> >
> >> >
> >> > Thanks all
> >
> > _______________________________________________
> > Qgis-user mailing list
> > [hidden email]
> > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
> >
> > If you reply to this email, your message will be added to the discussion
> > below:
> > http://osgeo-org.1560.x6.nabble.com/Raster-calculator-script-failing-for-multiple-rasters-tp5285491p5285719.html
> > To start a new topic under Quantum GIS - User, email ml-node+[hidden email]
> > To unsubscribe from Quantum GIS - User, click here.
> > NAML
>
>
>
>
> --
> View this message in context:
> http://osgeo-org.1560.x6.nabble.com/Raster-calculator-script-failing-for-multiple-rasters-tp5285491p5285825.html
> Sent from the Quantum GIS - User mailing list archive at Nabble.com.
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160914/0fc13c97/attachment-0001.html>
>
> ------------------------------
>
> Message: 7
> Date: Wed, 14 Sep 2016 05:02:21 -0700 (PDT)
> From: Nicolas Cadieux <[hidden email]>
> To: [hidden email]
> Subject: Re: [Qgis-user] Map composer. Wrong map scale
> Message-ID: <[hidden email]>
> Content-Type: text/plain; charset="utf-8"
>
> Hi,
> Could the scale be tied to an different object or a hidden map window in your
> layout? If so, it could be giving you a scale for a different map window.
> Nicolas
>
> Envoyé de mon iPad
>
> > Le 14 sept. 2016 à 04:20, Carlo Cormio [via OSGeo.org] <ml-node+[hidden
> > email]> a écrit :
> >
> > No, I'm using QuickMapServices plugin
> >
> >
> > Il 14/09/2016 09:39, Nyall Dawson ha scritto:
> >
> > > On 14 September 2016 at 17:32, Carlo Cormio <[hidden email]> wrote:
> > >> Dear all,
> > >>
> > >> I'm using QGIS 2.12.3 on Windows 10. After printing a map using QGIS map
> > >> composer, I checked some distances and found that map scale was different
> > >> from the expected one.
> > >> I set ISO A3, portrait, as page size. QGIS project has EPSG:3857 (due to
> > >> the
> > >> use of a google satellite layer), but most of the other layers have
> > >> EPSG:32633. I tell you this in case it could affect prints.
> > >> Map scale in print composer was set to 1:5000, but when I measured
> > >> distances
> > >> (I also put a scale in the composition) I found it was more or less
> > >> 1:3500.
> > >> The strange thing is that the ratio between the two scales is 1,41, that
> > >> is
> > >> exactly ISO A3:A4 ratio.
> > >> What did I do wrong? Is there a setting I missed?
> > > Are you using the OpenLayers plugin?
> > >
> > > Nyall
> > >
> > >
> > >> Hope I gave all the necessary information.
> > >>
> > >> Regards,
> > >>
> > >> Carlo
> > >> _______________________________________________
> > >> Qgis-user mailing list
> > >> [hidden email]
> > >> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> > >> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
> >
> > _______________________________________________
> > Qgis-user mailing list
> > [hidden email]
> > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
> >
> > If you reply to this email, your message will be added to the discussion
> > below:
> > http://osgeo-org.1560.x6.nabble.com/Map-composer-Wrong-map-scale-tp5285744p5285755.html
> > To start a new topic under Quantum GIS - User, email ml-node+[hidden email]
> > To unsubscribe from Quantum GIS - User, click here.
> > NAML
>
>
>
>
> --
> View this message in context:
> http://osgeo-org.1560.x6.nabble.com/Map-composer-Wrong-map-scale-tp5285744p5285827.html
> Sent from the Quantum GIS - User mailing list archive at Nabble.com.
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160914/b261b9c9/attachment-0001.html>
>
> ------------------------------
>
> Message: 8
> Date: Wed, 14 Sep 2016 10:55:55 -0300
> From: Tyler Veinot <[hidden email]>
> To: Bia <[hidden email]>
> Cc: QGIS User List <[hidden email]>
> Subject: Re: [Qgis-user] Organizing considering Dates
> Message-ID:
> <[hidden email]>
> Content-Type: text/plain; charset="utf-8"
>
> Bia;
> In 2.16.2 you can right click the column header and choose sort, this will
> bring up an expression builder. In there just add the field you want to
> sort by "Field_Name" or you can get fancy and say you want to sort by a
> number and a string field. Then you would do something like
> this "String_Field"||right( ('00000000' || "Numeric_Field"), 8) Notice the
> "00000000" being added, that is because the expression treats the number
> like a string. Padding it with zeros sorts allows it to sort in order
> 1,2,3,4 if you do not pad you will end up with. 1,10,11,12,etc...
> Dual sorting with date is a bit tricky but you can store the data as a
> YYYY,MM,DD type and it should sort for you. If your date is stored in
> another way, i.e. DD/MM/YYYY then you will have to format it to YYYY,MM,DD
> for proper sorting, i.e. Year("Date")||Month("Date")||Day("Date") should
> work to that effect.
> As for sorting one column Ascending and another Descending I am at a loss,
> have not been able to figure that one out but someone here might add to my
> answer if you need to do that.
> Additionally if your using an older version of QGIS that does not have the
> "sort" function you could write the expression to a virtual field and then
> sort it by clicking the column header of the new virtual field.
> Hope that helps.
> Tyler
>
> On Wed, Sep 14, 2016 at 7:38 AM, Bia <[hidden email]> wrote:
>
> > Hi, how can I to organize my table considering the date? I tried a
> > expression but did not work.
> > And after I wanna compare other columns to have a precision table.
> >
> > Thank you!
> >
> > _______________________________________________
> > Qgis-user mailing list
> > [hidden email]
> > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160914/9be398a5/attachment.html>
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> Qgis-user mailing list
> [hidden email]
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
>
> ------------------------------
>
> End of Qgis-user Digest, Vol 127, Issue 36
> ******************************************
>
> _______________________________________________
> Qgis-user mailing list
> [hidden email]
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
>
> If you reply to this email, your message will be added to the discussion
> below:
> http://osgeo-org.1560.x6.nabble.com/Precision-parameter-on-Select-By-Location-tool-tp5285861.html
> To start a new topic under Quantum GIS - User, email
> ml-node+s1560n4125267...@n6.nabble.com
> To unsubscribe from Quantum GIS - User, click here.
> NAML
--
View this message in context:
http://osgeo-org.1560.x6.nabble.com/Precision-parameter-on-Select-By-Location-tool-tp5285861p5285864.html
Sent from the Quantum GIS - User mailing list archive at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.osgeo.org/pipermail/qgis-user/attachments/20160914/127967f2/attachment.html>
------------------------------
Subject: Digest Footer
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
------------------------------
End of Qgis-user Digest, Vol 127, Issue 38
******************************************
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
