<meta http-equiv="Content-Type" content="text/html; charset=utf-8"><div><div style="font-family: Calibri,sans-serif; font-size: 11pt;">Thank you,<br>I realized that I was in the right way when i seen new expression functions introduced by new 2.6 version. There will be a new getfeature that has the same goal of the one called dbvalue implemented by the plugin. <br>A Great improve will come also from the memory field new feature that allows to calculate in the fly new fields without having to modify table structure. And here a set of function to reference to other layers would be very useful.<br>As I want to extend the reference functions set I would be interested in suggestion and testing feedback.<br><br>Regards<br><br>Enrico ferreguti<br></div></div><div dir="ltr"><hr><span style="font-family: Calibri,sans-serif; font-size: 11pt; font-weight: bold;">Da: </span><span style="font-family: Calibri,sans-serif; font-size: 11pt;"><a href="/user/SendEmail.jtp?type=node&node=5170023&i=0" target="_top" rel="nofollow" link="external">[hidden email]</a></span><br><span style="font-family: Calibri,sans-serif; font-size: 11pt; font-weight: bold;">Inviato: </span><span style="font-family: Calibri,sans-serif; font-size: 11pt;">28/10/2014 15:03</span><br><span style="font-family: Calibri,sans-serif; font-size: 11pt; font-weight: bold;">A: </span><span style="font-family: Calibri,sans-serif; font-size: 11pt;"><a href="/user/SendEmail.jtp?type=node&node=5170023&i=1" target="_top" rel="nofollow" link="external">[hidden email]</a></span><br><span style="font-family: Calibri,sans-serif; font-size: 11pt; font-weight: bold;">Oggetto: </span><span style="font-family: Calibri,sans-serif; font-size: 11pt;">Re: using field calculator to do a spatial update for a table usingdata from an overlapping geometry.</span><br><br></div>Hi,
<br><br>Enrico: Nice work I have to say! I think this kind of functionality should be part of the QGIS core. Or atleast I'm missing a way to do "join attributes by location" kind of task in processing toolbox as well as in geographical modeler.
<br><br>Cheers,
<br>Jouko
<br><br>-----Alkuperäinen viesti-----
<br>Lähettäjä: <a href="/user/SendEmail.jtp?type=node&node=5169947&i=0" target="_top" rel="nofollow" link="external">[hidden email]</a> [mailto:<a href="/user/SendEmail.jtp?type=node&node=5169947&i=1" target="_top" rel="nofollow" link="external">[hidden email]</a>] Puolesta Damien Stephens
<br>Lähetetty: 24. lokakuuta 2014 8:50
<br>Vastaanottaja: enricofer; <a href="/user/SendEmail.jtp?type=node&node=5169947&i=2" target="_top" rel="nofollow" link="external">[hidden email]</a>
<br>Aihe: Re: [Qgis-user] using field calculator to do a spatial update for a table using data from an overlapping geometry.
<br><br>Enrico you have made my day ! - much appreciated.
<br>I will have a look at it and get back to you on how I progress.
<br>Thanks Again
<br>Damien
<br><br>-----Original Message-----
<br>From: <a href="/user/SendEmail.jtp?type=node&node=5169947&i=3" target="_top" rel="nofollow" link="external">[hidden email]</a> [mailto:<a href="/user/SendEmail.jtp?type=node&node=5169947&i=4" target="_top" rel="nofollow" link="external">[hidden email]</a>] On Behalf Of enricofer
<br>Sent: Thursday, 23 October 2014 6:14 PM
<br>To: <a href="/user/SendEmail.jtp?type=node&node=5169947&i=5" target="_top" rel="nofollow" link="external">[hidden email]</a>
<br>Subject: Re: [Qgis-user] using field calculator to do a spatial update for a table using data from an overlapping geometry.
<br><br>You are lucky.
<br>I was developing a plugin with reference functions that fits to solve similar problems.
<br>I see your question and I implemented a dbwithin function You can get a development version from github:
<br><a href="https://github.com/enricofer/refFunctions/archive/master.zip" target="_top" rel="nofollow" link="external">https://github.com/enricofer/refFunctions/archive/master.zip</a><br><br>put the inside directory refFunctions-master in your plugin directory (typical .qgis/python/plugins in your user profile directory if you work in
<br>windows)
<br>then restart qgis
<br><br>If everything ok you will find under field calculator dialog a new group of experimental functions called 'reference' with a function dbwithin:
<br><br><<a href="http://osgeo-org.1560.x6.nabble.com/file/n5169107/reffunc.png" target="_top" rel="nofollow" link="external">http://osgeo-org.1560.x6.nabble.com/file/n5169107/reffunc.png</a>>
<br><br>Syntax
<br>dbwithin(targetLayer,targetField)
<br><br>Arguments:
<br>targetLayer; the name of a currently loaded layer, for example 'myLayer'.
<br>targetField; a field in target layer we want as result when source feature is within target feature, for example 'myField'. If targetField is equal to '$geometry' The WKT geometry of targetFeature willbe retrieved
<br>
<br>Number of feature tested is limited to 100000 to avoid time wasting loops
<br>
<br>Example:
<br>dbwithin('targetLayer','TargetField')
<br>dbwithin('targetLayer','$geometry')
<br><br>Let me know if that resolvs
<br><br>PS: Qgis guys are releasing 2.6 version that contains some new expression funtions very very interesting for you......
<br><br>Bye.
<br><br>Enrico
<br><br><br><br><br><br>--
<br>View this message in context: <a href="http://osgeo-org.1560.x6.nabble.com/using-field-calculator-to-do-a-spatial-update-for-a-table-using-data-from-an-overlapping-geometry-tp5169056p5169107.html" target="_top" rel="nofollow" link="external">http://osgeo-org.1560.x6.nabble.com/using-field-calculator-to-do-a-spatial-update-for-a-table-using-data-from-an-overlapping-geometry-tp5169056p5169107.html</a><br>Sent from the Quantum GIS - User mailing list archive at Nabble.com.
<br>_______________________________________________
<br>Qgis-user mailing list
<br><a href="/user/SendEmail.jtp?type=node&node=5169947&i=6" target="_top" rel="nofollow" link="external">[hidden email]</a>
<br><a 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>Qgis-user mailing list
<br><a href="/user/SendEmail.jtp?type=node&node=5169947&i=7" target="_top" rel="nofollow" link="external">[hidden email]</a>
<br><a 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>Qgis-user mailing list
<br><a href="/user/SendEmail.jtp?type=node&node=5169947&i=8" target="_top" rel="nofollow" link="external">[hidden email]</a>
<br><a 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>
<br>
<hr size="1" color="#cccccc" noshade="noshade">
<div style="font: 12px/normal tahoma, geneva, helvetica, arial, sans-serif; color: rgb(68, 68, 68); font-size-adjust: none; font-stretch: normal;">
<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/using-field-calculator-to-do-a-spatial-update-for-a-table-using-data-from-an-overlapping-geometry-tp5169056p5169947.html" target="_top" rel="nofollow" link="external">http://osgeo-org.1560.x6.nabble.com/using-field-calculator-to-do-a-spatial-update-for-a-table-using-data-from-an-overlapping-geometry-tp5169056p5169947.html</a>
</div>
<div style="font: 11px/1.5em tahoma, geneva, helvetica, arial, sans-serif; color: rgb(102, 102, 102); margin-top: 0.4em; font-size-adjust: none; font-stretch: normal;">
To unsubscribe from using field calculator to do a spatial update for a table using data from an overlapping geometry., <a href="" target="_top" rel="nofollow" link="external">click here</a>.<br>
<a style="font: 9px/normal serif; font-size-adjust: none; font-stretch: normal;" 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" target="_top" link="external">NAML</a>
</div>
<br/><hr align="left" width="300" />
View this message in context: <a href="http://osgeo-org.1560.x6.nabble.com/R-using-field-calculator-to-do-a-spatial-update-for-a-table-usingdata-from-an-overlapping-geometry-tp5170023.html">R: using field calculator to do a spatial update for a table usingdata from an overlapping geometry.</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/>