<div dir="ltr"><div><div><div>Hi Nicolas,<br><br></div>The fields are both TEXT.<br><br></div>Regards,<br></div>Chris<br></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div>Chris Berens, GISc<br></div><div><a href="http://www.mapland.co.za" target="_blank">www.mapland.co.za</a><br></div><div>+27 (0)82 567 9322<br></div></div></div></div></div></div></div></div></div></div>
<br><div class="gmail_quote">On 6 June 2016 at 16:17, Nicolas Cadieux <span dir="ltr"><<a href="mailto:nicolas.cadieux@archeotec.ca" target="_blank">nicolas.cadieux@archeotec.ca</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi,<br>
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?<br>
Nicolas<br>
<br>
<a href="https://anitagraser.com/2011/03/07/how-to-specify-data-types-of-csv-columns-for-use-in-qgis/" rel="nofollow" link="external" target="_blank">https://anitagraser.com/2011/03/07/how-to-specify-data-types-of-csv-columns-for-use-in-qgis/</a><div><div class="h5"><br>
<br>
<div>Le 2016-06-06 06:13, Chris Berens [via
OSGeo.org] a écrit :<br>
</div>
</div></div><blockquote style="border-left:2px solid #cccccc;padding:0 1em" type="cite"><div><div class="h5">
<div dir="ltr">
<div>Hi there,</div>
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>I have an <i>Attribute table</i> in the a <i>Composer</i>
window in the same <i>project</i> that references the same
relation perfectly, ie it only returns the residents
particular to eg 18E23. So is the <i>Identify Features</i>
tool using a different select rule set or parameters?</div>
<div><br>
</div>
<div>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?</div>
<div><br>
</div>
<div>FWIW I'm using 2.14.3-64bit on Win7, this behaviour is true
for sqlite and shp formats.</div>
<div><br>
</div>
<div>Thank you for your attention,</div>
<div>Chris</div>
<br>
Chris Berens, GISc<br>
<a href="http://www.mapland.co.za" rel="nofollow" link="external" target="_blank">www.mapland.co.za</a><br>
<a href="tel:%2B27%20%280%2982%20567%209322" value="+27825679322" target="_blank">+27 (0)82 567 9322</a></div>
<br></div></div>
_______________________________________________
<br>
Qgis-user mailing list
<br>
<a href="http:///user/SendEmail.jtp?type=node&node=5270096&i=0" rel="nofollow" link="external" target="_blank">[hidden email]</a>
<br>
List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="nofollow" link="external" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="nofollow" link="external" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
<br>
<br>
<hr color="#cccccc" noshade size="1">
<div style="color:#444;font:12px tahoma,geneva,helvetica,arial,sans-serif">
<div style="font-weight:bold">If you reply to this email, your
message will be added to the discussion below:</div>
<a href="http://osgeo-org.1560.x6.nabble.com/Project-relation-sci-notation-tp5270096.html" rel="nofollow" link="external" target="_blank">http://osgeo-org.1560.x6.nabble.com/Project-relation-sci-notation-tp5270096.html</a>
</div>
<div style="color:#666;font:11px tahoma,geneva,helvetica,arial,sans-serif;margin-top:.4em;line-height:1.5em">
To start a new topic under Quantum GIS - User, email
<a href="http:///user/SendEmail.jtp?type=node&node=5270145&i=0" rel="nofollow" link="external" target="_blank">[hidden email]</a> <br>
To unsubscribe from Quantum GIS - User, <a rel="nofollow" link="external">click
here</a>.<br>
<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" rel="nofollow" style="font:9px serif" link="external" target="_blank">NAML</a> </div>
</blockquote>
<br>
<br><hr align="left" width="300">
View this message in context: <a href="http://osgeo-org.1560.x6.nabble.com/Project-relation-sci-notation-tp5270096p5270145.html" target="_blank">Re: Project relation - sci. notation</a><br>
Sent from the <a href="http://osgeo-org.1560.x6.nabble.com/Quantum-GIS-User-f4125267.html" target="_blank">Quantum GIS - User mailing list archive</a> at Nabble.com.<br><br>_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>
List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br></blockquote></div><br></div>