<html><head></head><body><div style="color:#000; background-color:#fff; font-family:verdana, helvetica, sans-serif;font-size:16px"><div id="yui_3_16_0_ym19_1_1487196580315_1702685"><span>Sort of in the area you are asking about:<br></span></div><div id="yui_3_16_0_ym19_1_1487196580315_1702983"><span><br></span></div><div id="yui_3_16_0_ym19_1_1487196580315_1702730"><span>See the Action tool</span></div><div id="yui_3_16_0_ym19_1_1487196580315_1702795"><span> </span><span id="yui_3_16_0_ym19_1_1487196580315_1702756"><br></span></div><div id="yui_3_16_0_ym19_1_1487196580315_1702984"><span id="yui_3_16_0_ym19_1_1487196580315_1702756">Under Windows this can invoke a batch file to display the result of an sql for data about the (Postgis) feature clicked on. Even easier under Linux with a bash script. If one of the fields is an image file, you can create an action to display the image associates with the feature. A useful bit of functionality...</span></div><div class="qtdSeparateBR" id="yui_3_16_0_ym19_1_1487196580315_1702726"><br><div id="yui_3_16_0_ym19_1_1487196580315_1702986">But to do exactly what you are asking, I think the Attribute table does this, so it is a matter of explaining the steps to your users, rather than writing code...<br></div><div id="yui_3_16_0_ym19_1_1487196580315_1703190"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1487196580315_1702987">If you select a set of features in a Postgis (or most type of layer) layer rendered on the map, QGIS highlights the selected ones as defined in the project properties. Open the Attribute table for the layer, you will see the selected features, not only highlighted on the map, but also in the attribute list. Click the "move selected features to top" button, and the selected/highlighted features will always be at the top of the list. The attribute table has buttons at the top to zoom & pan to selected features...</div><div dir="ltr" id="yui_3_16_0_ym19_1_1487196580315_1703191"><br></div><div dir="ltr">Cheers,</div><div dir="ltr"><br></div><div dir="ltr">Brent<br></div><div id="yui_3_16_0_ym19_1_1487196580315_1702988"><br></div><div id="yui_3_16_0_ym19_1_1487196580315_1703050"><br></div></div><div class="yahoo_quoted" id="yui_3_16_0_ym19_1_1487196580315_1702624" style="display: block;"> <div style="font-family: verdana, helvetica, sans-serif; font-size: 16px;" id="yui_3_16_0_ym19_1_1487196580315_1702623"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;" id="yui_3_16_0_ym19_1_1487196580315_1702622"> <div dir="ltr" id="yui_3_16_0_ym19_1_1487196580315_1702621"> <font id="yui_3_16_0_ym19_1_1487196580315_1702620" size="2" face="Arial"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> SEGGIE Graeme <gseggie@systra.com><br> <b><span style="font-weight: bold;">To:</span></b> "Qgis-user@lists.osgeo.org" <Qgis-user@lists.osgeo.org> <br> <b><span style="font-weight: bold;">Sent:</span></b> Friday, February 24, 2017 6:48 AM<br> <b><span style="font-weight: bold;">Subject:</span></b> [Qgis-user] Simple methodology for user / data / map interactivity?<br> </font> </div> <div class="y_msg_container"><br><div id="yiv2791882570">
<style><!--
#yiv2791882570
_filtered #yiv2791882570 {font-family:"Cambria Math";panose-1:2 4 5 3 5 4 6 3 2 4;}
_filtered #yiv2791882570 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}
#yiv2791882570
#yiv2791882570 p.yiv2791882570MsoNormal, #yiv2791882570 li.yiv2791882570MsoNormal, #yiv2791882570 div.yiv2791882570MsoNormal
{margin:0cm;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri", sans-serif;}
#yiv2791882570 a:link, #yiv2791882570 span.yiv2791882570MsoHyperlink
{color:#0563C1;text-decoration:underline;}
#yiv2791882570 a:visited, #yiv2791882570 span.yiv2791882570MsoHyperlinkFollowed
{color:#954F72;text-decoration:underline;}
#yiv2791882570 span.yiv2791882570EmailStyle17
{font-family:"Calibri", sans-serif;color:black;font-weight:normal;font-style:normal;text-decoration:none;text-decoration:none;}
#yiv2791882570 span.yiv2791882570SpellE
{}
#yiv2791882570 .yiv2791882570MsoChpDefault
{font-family:"Calibri", sans-serif;}
_filtered #yiv2791882570 {margin:72.0pt 72.0pt 72.0pt 72.0pt;}
#yiv2791882570 div.yiv2791882570WordSection1
{}
--></style>
<div>
<div class="yiv2791882570WordSection1">
<div class="yiv2791882570MsoNormal"><span style="font-size:12.0pt;color:black;">I would like to use QGIS as a visual / interactive front to some
<span class="yiv2791882570SpellE">PostGIS</span> data and am not sure what the best route to doing so is. Happy to explore further myself, but wanted to get some input on what needs to be joined up to get started on building a little process.</span></div>
<div class="yiv2791882570MsoNormal"><span style="font-size:12.0pt;color:black;"> </span></div>
<div class="yiv2791882570MsoNormal"><span style="font-size:12.0pt;color:black;">Basically, if I wanted to present a map of features and have a button (like the attribute information one) which a user would click then
use to select features, I want this to run a SQL query which to get related features for example and highlight them on the map view, possibly pan to the extent of the newly selected feature set.
</span></div>
<div class="yiv2791882570MsoNormal"><span style="font-size:12.0pt;color:black;"> </span></div>
<div class="yiv2791882570MsoNormal"><span style="font-size:12.0pt;color:black;">Does this sound like a plugin – or would that be taking things too far?
</span></div>
<div class="yiv2791882570MsoNormal"><span style="font-size:12.0pt;color:black;"> </span></div>
<div class="yiv2791882570MsoNormal"><span style="font-size:12.0pt;color:black;">Would the best way for the dynamic layer to be setup, to be a view – empty except when populated by the query and styled to be dominant
over the full set of features? </span></div>
<div class="yiv2791882570MsoNormal"><span style="font-size:12.0pt;color:black;"> </span></div>
<div class="yiv2791882570MsoNormal"><span style="font-size:12.0pt;color:black;">As a simple example, say I had a district zone system of polygons and I wanted a user to be able to click on any polygon, and have all
the neighbouring polygons highlighted, centred and fill the map view as fully as possible. What would be the best / simplest approach to this?</span></div>
<div class="yiv2791882570MsoNormal"><span style="font-size:12.0pt;color:black;"> </span></div>
<div class="yiv2791882570MsoNormal"><span style="font-size:12.0pt;color:black;">Graeme</span><span style="font-size:10.0pt;color:black;"></span></div>
<div class="yiv2791882570MsoNormal"> </div>
</div>
========================================================<br>
This message has been scanned for malware. This message and any attachments (the "message") are confidential, intended solely for the addressees, and may contain legally privileged information. Any unauthorised use or dissemination is prohibited. E-mails are
susceptible to alteration. Neither our company or any of its subsidiaries or affiliates shall be liable for the message if altered, changed or falsified.<br>
=========================================================<br>
Ce message a ete verifie et ne contient pas de programme malveillant. Ce message et toutes les pieces jointes (ci-apres le "message") sont confidentiels et susceptibles de contenir des informations couvertes par le secret professionnel. Ce message est etabli
a l'intention exclusive de ses destinataires. Toute utilisation ou diffusion non autorisee est interdite. Tout message electronique est susceptible d'alteration. Notre societe et ses filiales declinent toute responsabilite au titre de ce message s'il a ete
altere, deforme falsifie.<br>
=========================================================
</div>
</div><br>_______________________________________________<br>Qgis-user mailing list<br><a ymailto="mailto:Qgis-user@lists.osgeo.org" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br><br></div> </div> </div> </div></div></body></html>