Array
(
[sql] =>
SELECT t1.*,
ROUND((val_presence*0.5) + (val_upfreq*0.25) + (val_machine_readable*0.25), 2) as c_index
FROM (
SELECT t0.main_category, t0.subcategory, t0.country, t0.country_name, t0.id_main_category, t0.sub_sort_ord,
COALESCE(dr.n_indicators,0) n_indicators ,
COALESCE(dr.presence, 0) presence,
COALESCE(dr.val_presence, 0) val_presence,
COALESCE(dr.val_upfreq, 0) val_upfreq,
COALESCE(dr.val_machine_readable, 0) val_machine_readable
FROM (
SELECT dgm.main_category, dgm.subcategory, dgm.country, cn.country_name, id_main_category, dgm.sub_sort_ord
FROM dgm
INNER JOIN country cn ON cn.abbr = dgm.country
WHERE dgm.rev_last = 1
AND visible_subcategory = 1
GROUP BY id_main_category, main_category, subcategory, country
ORDER BY id_main_category, main_category, subcategory, country)
t0
LEFT JOIN data_rank dr
ON dr.main_category = t0.main_category
AND dr.subcategory = t0.subcategory
AND dr.country = t0.country
AND year=?
) t1
ORDER BY id_main_category, sub_sort_ord, main_category, subcategory, country_name
[params] => Array
(
[0] => 2020
)
[errno] => SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'dguptake.dgm.sub_sort_ord' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
)
Warning: foreach() argument must be of type array|object, null given in /var/www/vhosts/dgmonitor/classes/src/Data.php on line 115
Digital Government MetaMonitor
Digital Government
MetaMonitor (beta)
a project by
Are digital government services used? Which member states show high
adoption levels? And which ones provide ample data about it?
Today, the answers are often provided by survey-based data such as
DESI, but
several member states generate data in an automatic way through their digital services.
The Digital Government MetaMonitor (beta) provides a quick overview
of the availability of these data in nine European countries.
The data availability is summarised in a MetaIndex, which considers
the completeness, update frequency
and machine readability of uptake data on five key
digital service topics: eID, ePayment,
Messaging, Transparency and
General Digital Services by different stakeholder groups.
The uptake data can be browsed by topic and by country. For a
detailed description of the methodology and list of indicators,
please consult the About section.
You can help to improve the MetaMonitor by
providing your feedback and
suggesting additional data sources to be included.