[Qgis-user] Using qgis as realtime decision support tool

[Jeroen Hovens]

Hello,

 

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.

 

The case is the following:

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.

 

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).

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.

 

Do you have other ideas how to use a map as a real-time decision support
tool?

 

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. 

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.

 

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.

 

Greetings,

Jeroen

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20180618/498e1a77/attachment.html>