[Qgis-user] Project relation - sci. notation

[Chris Berens]

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 <nicolas.cadieux at archeotec.ca>
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
> +27 (0)82 567 9322
>
> _______________________________________________
> Qgis-user mailing list
> [hidden email] <http:///user/SendEmail.jtp?type=node&node=5270096&i=0>
> 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 [hidden email]
> <http:///user/SendEmail.jtp?type=node&node=5270145&i=0>
> To unsubscribe from Quantum GIS - User, click here.
> NAML
> <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>
>
>
>
> ------------------------------
> 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
> 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/de011057/attachment.html>