[Qgis-user] Project relation - sci. notation

Tue Jun 7 06:13:38 PDT 2016

Yes Nicolas, that works fine. The error appears to lie within the *Identify
Features* tool.  If I knew how I'd write a ticket for it.

Thank you for your consideration.  If I knew how I'd write a ticket for it.

On 7 June 2016 at 14:34, Nicolas Cadieux <nicolas.cadieux at archeotec.ca>
wrote:

> Hi,
> You could trouble shoot by changing the E to another letter to see if that
> changes anything...
> Nicolas
> On Jun 7, 2016 5:46 AM, "Chris Berens [via OSGeo.org]" <[hidden email]
> <http:///user/SendEmail.jtp?type=node&node=5270380&i=0>> wrote:
>
> Hi Nicolas,
>
> The fields are both TEXT.
>
> Regards,
> Chris
>
> Chris Berens, GISc
> www.mapland.co.za
> +27 (0)82 567 9322
>
> On 6 June 2016 at 16:17, Nicolas Cadieux <<a
> href="/user/SendEmail.jtp?type=node&node=5270344&i=0">[hidden
> email]> wrote:
>
> Hi,
> My guess is that the value where imported from a csv with no field type
> value.  Therefore, text values could have been imported as float values in
> the shape file.  What is the field type for both your files?
> Nicolas
>
>
> https://anitagraser.com/2011/03/07/how-to-specify-data-types-of-csv-columns-for-use-in-qgis/
>
>
> Le 2016-06-06 06:13, Chris Berens [via OSGeo.org] a écrit :
>
> 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.
>
> Thank you for your attention,
> Chris
>
> Chris Berens, GISc
> www.mapland.co.za
> <a href="tel:%2B27%20%280%2982%20567%209322" value="+27825679322"
> target="_blank">+27 (0)82 567 9322
>
> _______________________________________________
> Qgis-user mailing list
> <a href="http:///user/SendEmail.jtp?type=node&node=5270096&i=0">[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/Project-relation-sci-notation-tp5270096.html
> To start a new topic under Quantum GIS - User, email <a href="http:///user/SendEmail.jtp?type=node&node=5270145&i=0">[hidden
> email]
> To unsubscribe from Quantum GIS - User, click here.
> <a href="
> http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml
> <http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id&%2361;instant_html%21nabble%3Aemail.naml&base&%2361;nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs&%2361;notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>"
> style="font:9px serif">NAML
>
>
>
> ------------------------------
> View this message in context: Re: Project relation - sci. notation
> <http://osgeo-org.1560.x6.nabble.com/Project-relation-sci-notation-tp5270096p5270145.html>
> Sent from the Quantum GIS - User mailing list archive
> <http://osgeo-org.1560.x6.nabble.com/Quantum-GIS-User-f4125267.html> at
> Nabble.com.
>
> _______________________________________________
> Qgis-user mailing list
> <a
> href="/user/SendEmail.jtp?type=node&node=5270344&i=1">[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
> <a
> href="/user/SendEmail.jtp?type=node&node=5270344&i=2">[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/Project-relation-sci-notation-tp5270096p5270344.html
> To start a new topic under Quantum GIS - User, email
> ml-node+s1560n4125267h38 at n6.nabble.com
> To unsubscribe from Quantum GIS - User, <a href="
> http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4125267&code=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYXw0MTI1MjY3fDYzNDQ4MjQxNg==">click
> here.
> <a href="
> http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml
> <http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id&%2361;instant_html%21nabble%3Aemail.naml&base&%2361;nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs&%2361;notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>"
> style="font:9px serif">NAML
>
>
> ------------------------------
> View this message in context: Re: Project relation - sci. notation
> <http://osgeo-org.1560.x6.nabble.com/Project-relation-sci-notation-tp5270096p5270380.html>
> Sent from the Quantum GIS - User mailing list archive
> <http://osgeo-org.1560.x6.nabble.com/Quantum-GIS-User-f4125267.html> at
> Nabble.com.
>
> _______________________________________________
> 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/20160607/ded05f87/attachment.html>