[Qgis-user] Project relation - sci. notation

[Chris Berens]

Hi Nyall,

I have posted a zipped project with sqlite database here:

http://www.mapland.co.za/home/qgis_idfeaturetool_issue

Hoping I am missing something obvious.

Regards,
Chris

Chris Berens, GISc
www.mapland.co.za
+27 (0)82 567 9322

On 8 June 2016 at 00:47, Nyall Dawson <nyall.dawson at gmail.com> wrote:

> On 6 June 2016 at 20:28, Chris Berens <chris at mapland.co.za> wrote:
> > Hi there,
> >
> > I have a layer of homes (roofs) and a list of residents who are linked
> to a
> > home by the roof number.  The homes are attributed via a re-blocking
> > exercise running 1-31 and A-J, eg. 18G is a block. Within each block
> there
> > may be up to 100 homes, eg. 18G-47.
> >
> > So under Project Properties I set up a relation called 'households' and
> > using the Identify Features tool I can view the members of a household by
> > clicking on the roof. Works great, most of the time.
> >
> > When I click on an E block roof (eg 18E-23) it returns all 291 XXE-XX
> > residents on the list.  It appears to me as if the relation is reading
> the
> > values as scientific notation numeric values instead of the declared text
> > status in both files.
> >
> > I have an Attribute table in the a Composer window in the same project
> that
> > references the same relation perfectly, ie it only returns the residents
> > particular to eg 18E23.  So is the Identify Features tool using a
> different
> > select rule set or parameters?
> >
> > I have tried to search for a previous thread on this topic without
> success.
> > The pain would appear to be for me alone, but can anyone suggest a way of
> > defining a relation to avoid this?
> >
> > FWIW I'm using 2.14.3-64bit on Win7, this behaviour is true for sqlite
> and
> > shp formats.
>
> I've tried to reproduce this locally but cannot. Can you share a
> sample project + test data which demonstrates this issue?
>
> Thanks!
> Nyall
>
> >
> > Thank you for your attention,
> > Chris
> >
> > Chris Berens, GISc
> > www.mapland.co.za
> > +27 (0)82 567 9322
> >
> > _______________________________________________
> > 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160608/10932bf5/attachment.html>