[Qgis-user] web based spatial MIS/Dashboard

[rsantell]

> I guess what clients might be asking for is the equivalent of ArcGIS
> dashboards... I have not worked with it, but from the docs it seems to
> be the type of functionality clients have on their wish list, where no
> coding is required to publish a map with some corresponding indicators.

There is *always* coding required in one form or another, whether it is a transferable skill such as JavaScript or a non-transferable one such as ArcGIS dashboards.

Come to think of it, what about GeoPDF? Given that the consuming user will be presented with a pre-made template ("dashboard" as managers like to call it), this can be produced directly in QGIS as "print layouts". Of course, the data would be embedded in the PDF rather than retrieved from the database, with all its advantages and disadvantages.




Sent with Proton Mail secure email.

On Monday, 22 April 2024 at 16:01, Janneke van Dijk <janneke.qgis at gmail.com> wrote:

> Thanks for your response!
> 
> I think the most common case would be:
> 
> 1. data in postgres database
> 2. editing done in qgis
> 3. viewing map and some selected graphs/tables in the web browser with
> the ability to (for example) click on a feature and use that to filter
> the data to only include data for that feature in the
> graphs/tables/other dashboard items, or be able to select from a drop
> down list and use that as a filter.
> 
> Which indeed corresponds to your Scenario 2. If I understand this
> correctly, you will always need to program the HTML frontend to
> communicate with the backend, and there are no tools that let you
> automagically configure the html front end with dragging and dropping a
> map widget and a graph widget with some settings for data sources?
> 
> I guess what clients might be asking for is the equivalent of ArcGIS
> dashboards... I have not worked with it, but from the docs it seems to
> be the type of functionality clients have on their wish list, where no
> coding is required to publish a map with some corresponding indicators.
> (https://www.arcgis.com/apps/dashboards/7edefc1970d44b839ebbfd7b45e51e2d
> for example).
> 
> So maybe my questions are on two levels:
> 
> - what would someone need to do to create something with a similar
> result (any recommended tools/libraries/languages - Rosa just
> recommended some)
> - is it desirable to have an Open Source tool that allows for creating
> something with that functionality without the need for coding? And if
> so, what would be the way to go about it? Which would maybe be more of
> a discussion rather than a technical question.
> 
> cheers!
> Janneke
> 
> 
> 
> 
> 
> On 22/04/2024 15:30, rsantell wrote:
> 
> > > and where selecting a feature on the map
> > > will update the graphs and charts in the dashboard
> > > Selecting a feature on which map? The QGIS map view? The HTML frontend?
> > 
> > > From your description, I guess you're after a system with two frontends, one for editors (users that create and manage the data) and one for consumers (users who view the data, and perhaps performs very limited editing such as updating attributes).
> > 
> > In that case, depending on your budget and available skillset, etc.:
> > 
> > ## Scenario 1:
> > 
> > * Editors use QGIS as normal
> > * Consumers:
> > - use an HTML visualisation exported via qgis2web (https://github.com/qgis2web/qgis2web), or
> > - use a stripped down version of QGIS consisting of a map canvas plus whatever controls may be necessary (requires Python skills)
> > 
> > ## Scenario 2:
> > 
> > * PostGIS (or Spatialite) are used as the backend
> > * Editors use QGIS as normal
> > * Consumers use an OpenLayers-powered HTML frontend communicating with a backend (NodeJS, Python, Go, etc., etc.) that communicates with the RDBMS backend.
> > 
> > If no consumer editing is required at all, qgis2web is the cheapest and quickest solution.