[Qgis-user] Project relation - sci. notation

[Nicolas Cadieux]

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 <http://www.mapland.co.za>
> +27 (0)82 567 9322
>
> _______________________________________________
> Qgis-user mailing list
> [hidden email] </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 
> ml-node+s1560n4125267h38 at n6.nabble.com
> To unsubscribe from Quantum GIS - User, click here 
> <http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4125267&code=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYXw0MTI1MjY3fDYzNDQ4MjQxNg==>.
> 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: http://osgeo-org.1560.x6.nabble.com/Project-relation-sci-notation-tp5270096p5270145.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/20160606/b325e737/attachment.html>