[Qgis-user] Qgis-user Digest, Vol 127, Issue 38
Ivan Santiago
isantiago at ogp.pr.gov
Wed Sep 14 07:55:46 PDT 2016
Sorry, 2.16.2 over ubuntu 16.
Bonjour.
Sent from my T-Mobile 4G LTE Device
-------- Original message --------
From: qgis-user-request at lists.osgeo.org
Date:09/14/2016 10:43 (GMT-04:00)
To: qgis-user at lists.osgeo.org
Subject: Qgis-user Digest, Vol 127, Issue 38
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. 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.cadieux at archeotec.ca>
To: qgis-user at lists.osgeo.org
Subject: Re: [Qgis-user] Precision parameter on Select By Location
tool
Message-ID: <42048476-B5D3-4FF1-958C-AC0E116EF2C7 at 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+s1560n5285861h52 at 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 at 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 at ...> 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 at 1'
> >> > rasA.raster=A
> >> > rasA.bandNumber=1
> >> > entries.append(rasA)
> >> >
> >> > rasB=QgsRasterCalculatorEntry()
> >> > rasB.ref='B at 1'
> >> > rasB.raster=B
> >> > rasB.bandNumber=1
> >> > entries.append(rasB)
> >> >
> >> > rasC=QgsRasterCalculatorEntry()
> >> > rasC.ref='C at 1'
> >> > rasC.raster=C
> >> > rasC.bandNumber=1
> >> > entries.append(rasC)
> >> >
> >> > rasD=QgsRasterCalculatorEntry()
> >> > rasD.ref='D at 1'
> >> > rasD.raster=D
> >> > rasD.bandNumber=1
> >> > entries.append(rasD)
> >> >
> >> > F1_30c4=QgsRasterCalculator('(( A at 1 - B at 1 ) * ( C at 1 - D at 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+s1560n4125267h38 at 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 at 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
******************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160914/cf99bf66/attachment.html>
More information about the Qgis-user
mailing list