<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
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 class="moz-txt-link-freetext" href="https://anitagraser.com/2011/03/07/how-to-specify-data-types-of-csv-columns-for-use-in-qgis/" target="_top" rel="nofollow" link="external">https://anitagraser.com/2011/03/07/how-to-specify-data-types-of-csv-columns-for-use-in-qgis/</a><br>
<br>
<div class="moz-cite-prefix">Le 2016-06-06 06:13, Chris Berens [via
OSGeo.org] a écrit :<br>
</div>
<blockquote style='border-left:2px solid #CCCCCC;padding:0 1em'
cite="mid:CAM__GR2nn9QkDUg69gNNUGWgiyU-racbbFZ1=3v2hJeMMx8KGg@mail.gmail.com"
type="cite">
<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 moz-do-not-send="true" href="http://www.mapland.co.za"
target="_top" rel="nofollow" link="external">www.mapland.co.za</a><br>
+27 (0)82 567 9322</div>
<br>
_______________________________________________
<br>
Qgis-user mailing list
<br>
<a moz-do-not-send="true"
href="/user/SendEmail.jtp?type=node&node=5270096&i=0"
target="_top" rel="nofollow" link="external">[hidden email]</a>
<br>
List info: <a moz-do-not-send="true"
href="http://lists.osgeo.org/mailman/listinfo/qgis-user"
target="_top" rel="nofollow" link="external">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a moz-do-not-send="true"
href="http://lists.osgeo.org/mailman/listinfo/qgis-user"
target="_top" rel="nofollow" link="external">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
<br>
<br>
<hr noshade="noshade" size="1" color="#cccccc">
<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 moz-do-not-send="true"
href="http://osgeo-org.1560.x6.nabble.com/Project-relation-sci-notation-tp5270096.html" target="_top" rel="nofollow" link="external">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="/user/SendEmail.jtp?type=node&node=5270145&i=0" target="_top" rel="nofollow" link="external">[hidden email]</a> <br>
To unsubscribe from Quantum GIS - User, <a
moz-do-not-send="true"
href="" target="_top" rel="nofollow" link="external">click
here</a>.<br>
<a moz-do-not-send="true"
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" target="_top" link="external">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">Re: Project relation - sci. notation</a><br/>
Sent from the <a href="http://osgeo-org.1560.x6.nabble.com/Quantum-GIS-User-f4125267.html">Quantum GIS - User mailing list archive</a> at Nabble.com.<br/>