<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.E-mailStijl18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=NL link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span lang=EN-GB style='mso-fareast-language:EN-US'>I have not organized the data yet, that will depend on the pro’s and con’s of idea’s how to use it.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-GB style='mso-fareast-language:EN-US'>For now, I am thinking along the following line:<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB style='mso-fareast-language:EN-US'>All municipalities as fields with attributes being whether or not they have a proposal and specific information about the proposal such as budget needed, type of project, etc.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB style='mso-fareast-language:EN-US'>That would mean 1 layer with all the proposals. That way it seems easier to show the entire map (all municipalities white, just borders, and all municipalities with proposal coloured), so to easily see the spread.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-GB style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><b>Van:</b> Alexandre Neto <senhor.neto@gmail.com> <br><b>Verzonden:</b> maandag 18 juni 2018 12:03<br><b>Aan:</b> Jeroen Hovens <mail@groenebij.nl><br><b>CC:</b> qgis-user@lists.osgeo.org<br><b>Onderwerp:</b> Re: [Qgis-user] Using qgis as realtime decision support tool<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>Hi,<o:p></o:p></p></div><div><p class=MsoNormal>It's not clear how your data is organized, making it dificult to help in such a specific request. All the porposals are in the same layer, or in diferent layers?<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Still, if you put all the proposal layers in mutually exclusive group, it will be easy to swap between proposals.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>If they are all in the same layer, you can categorize and in the legend you can select which proposal to show.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><a href="https://docs.qgis.org/testing/en/docs/user_manual/introduction/general_tools.html?highlight=mutually#interact-with-groups-and-layers">https://docs.qgis.org/testing/en/docs/user_manual/introduction/general_tools.html?highlight=mutually#interact-with-groups-and-layers</a><o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>You can also create an atlas with the necessary visualizations for each proposal and the calculus of the values you wish to show. But again, it all depends on how you have you data organized.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>Jeroen Hovens <<a href="mailto:mail@groenebij.nl">mail@groenebij.nl</a>> escreveu no dia segunda, 18/06/2018 às 10:19:<o:p></o:p></p></div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm'><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Hello,<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-GB>I am thinking about using qgis as a real-time decision support tool and I am looking for some good ideas to ease the process.</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-GB> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-GB>The case is the following:</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-GB>I have proposals from 60 municipalities (out of a possible few hundred), each has 1 proposal. There is only room for 20 proposals to be accepted. One of the criteria will be the geographical spread of the proposals: it is preferred to have 20 proposals sort of evenly spread over the entire country, instead of having the majority of them coming from one region.</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-GB> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-GB>My idea is to show these proposals on a map by colouring the municipalities. As a decision support tool I need the ability to adjust the selection in real-time (during the discussion). The easy way is to just edit the attribute table or to select or deselect specific municipalities. This however requires myself to be present and make changes in qgis as the discussion goes (given that nobody else in the decision group knows how to work with qgis).</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-GB>An alternative is to produce a webmap and have each municipality with a proposal have it’s own specific attribute value (but all using the same colour in categorized style), so they all show up in the map-legend, and any group member can easily select or deselect a specific municipality from the legend.</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-GB> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-GB>Do you have other ideas how to use a map as a real-time decision support tool?</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-GB> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-GB>Quality of the proposal is the main criterium, but in addition to the geographical spread there are others as well, such as variety in projects and the cumulative budget for the selected proposals (the cumulative budget is capped). Since I am not well known with database and calculation options in qgis and how to automatically show the results, I am building an easy to use excel file that will show all this information using precoded calculations, much like a dashboard. Simply selecting and deselecting proposals in an excel interface show you the changes in variety of projects and cumulative budget. This is much easier for the decision team to do themselves, since MS Excel is a well known environment. </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-GB>Ideally I get the two connected somehow, so selecting and deselecting proposals will alter the results in both the map as in the excel dashboard. However, altering data in excel doesn’t automatically change the results in a qgis map, because they are not connected in real-time.</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-GB> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-GB>Do you have any ideas how to make a real-time connection between MS Excel and a qgis map? Or information on how to use qgis internal capabilities to calculate certain values based on the selection of proposals? However, the last option will probably still need myself to be present to somehow select or deselect the proposals in qgis.</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-GB> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-GB>Greetings,</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-GB>Jeroen</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-GB> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-GB> </span><o:p></o:p></p></div></div><p class=MsoNormal>_______________________________________________<br>Qgis-user mailing list<br><a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">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><o:p></o:p></p></blockquote></div><p class=MsoNormal>-- <o:p></o:p></p><div><div><div><p class=MsoNormal>Alexandre Neto<o:p></o:p></p></div><div><p class=MsoNormal>---------------------<o:p></o:p></p></div><div><p class=MsoNormal>@AlexNetoGeo<o:p></o:p></p></div><div><p class=MsoNormal><a href="http://sigsemgrilhetas.wordpress.com">http://sigsemgrilhetas.wordpress.com</a><o:p></o:p></p></div><p class=MsoNormal><a href="http://gisunchained.wordpress.com">http://gisunchained.wordpress.com</a><o:p></o:p></p></div></div></div></body></html>