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
)
<br />
<b>Deprecated</b>:  Creation of dynamic property DataCountryTopic::$vmsql is deprecated in <b>/var/www/vhosts/dgmonitor/classes/src/DataCountryTopic.php</b> on line <b>35</b><br />
Array
(
    [sql] => SELECT DISTINCT id_indicator 
                FROM dgm 
                WHERE main_category=?
                 AND id_subcategory = ?
                ORDER BY id_subcategory, id_indicator
                
    [params] => Array
        (
            [0] => messaging
            [1] => 3020
        )

    [errno] => SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'dguptake.dgm.id_subcategory' which is not in SELECT list; this is incompatible with DISTINCT
)
Array
(
    [sql] => SELECT DISTINCT id_indicator 
                FROM dgm 
                WHERE main_category=?
                 AND id_subcategory = ?
                ORDER BY id_subcategory, id_indicator
                
    [params] => Array
        (
            [0] => messaging
            [1] => 3030
        )

    [errno] => SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'dguptake.dgm.id_subcategory' which is not in SELECT list; this is incompatible with DISTINCT
)
Array
(
    [sql] => SELECT DISTINCT id_indicator 
                FROM dgm 
                WHERE main_category=?
                 AND id_subcategory = ?
                ORDER BY id_subcategory, id_indicator
                
    [params] => Array
        (
            [0] => messaging
            [1] => 3010
        )

    [errno] => SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'dguptake.dgm.id_subcategory' which is not in SELECT list; this is incompatible with DISTINCT
)
Array
(
    [sql] => SELECT DISTINCT id_indicator 
                FROM dgm 
                WHERE main_category=?
                 AND id_subcategory = ?
                ORDER BY id_subcategory, id_indicator
                
    [params] => Array
        (
            [0] => messaging
            [1] => 3040
        )

    [errno] => SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'dguptake.dgm.id_subcategory' which is not in SELECT list; this is incompatible with DISTINCT
)
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /var/www/vhosts/dgmonitor/classes/src/DbException.php:28) in <b>/var/www/vhosts/dgmonitor/classes/src/Rpc.php</b> on line <b>18</b><br />
{"main_category":{"id_main_category":3000,"main_category":"Messaging","visible":1,"sort_order":3,"summary":"Indicators for this topic focus on mapping the use of the national system for sending digital messages from government organisations to citizens and businesses.\nMessaging is measured by assessing the yearly numbers of cumulative registered users for both digital mail and SMS, downloaded and installed mobile applications, cumulative adhered public organisations and digital mails sent to both citizens and businesses."},"country":{"abbr":"NL","country_name":"Netherlands","summary":"<p><strong>eID<\/strong> The Netherlands distinguishes between an eID solution for citizens, <a href=\"https:\/\/www.digid.nl\">DigiD<\/a>, and one for businesses, <a href=\"https:\/\/www.eherkenning.nl\/en\">eHerkenning<\/a>. DigiD can be used to access public services, while eHerkenning can also be used for private services. DigiD has set up a dedicated service to assign or become a <a href=\"https:\/\/machtigen.digid.nl\/\">digital proxy<\/a>. eHerkenning also includes a <a href=\"https:\/\/www.eherkenning.nl\/en\/authorization\/chain-legal-authorization\">digital proxy system<\/a>.<\/p>\n<p><strong>ePayment <\/strong>While a <a href=\"https:\/\/www.digitaleoverheid.nl\/overzicht-van-alle-onderwerpen\/dienstverlening-aan-burgers-en-ondernemers\/efactureren\/\">national e-invoicing service<\/a> is in place, the Dutch government doesn't have a dedicated system for receiving e-payments from citizens and businesses.&nbsp;<\/p>\n<p><strong>Messaging <\/strong>Business users can make use of <a href=\"https:\/\/www.digitaleoverheid.nl\/overzicht-van-alle-onderwerpen\/standaardisatie\/digipoort\/\">Digipoort<\/a>, a business-oriented electronic post office, where government organisations and businesses can quickly and efficiently exchange structured digital information. Citizens on the other hand use <a href=\"https:\/\/mijn.overheid.nl\">Mijnoverheid.nl<\/a>, a portal for personal services on which citizens can access personalised information and digital messages from the government. There is no government SMS service in place.<\/p>\n<p><strong>Transparency <\/strong>After logging on to the citizen portal MijnOverheid, citizens can see a large number of the <a href=\"https:\/\/mijn.overheid.nl\/persoonlijke-gegevens-inzien\/\">data concerning them<\/a> that the government has registered. The MijnOverheid portal also provided citizens with an overview of their ongoing affairs (<a href=\"https:\/\/www.digitaleoverheid.nl\/overzicht-van-alle-onderwerpen\/dienstverlening-aan-burgers-en-ondernemers\/mijnoverheid\/\">lopende zaken<\/a>).<\/p>\n<p><strong>General Digital Services<\/strong> Digital service user satisfaction is measured as part of the citizen survey for municipalities (<a href=\"https:\/\/www.vngrealisatie.nl\/producten\/burgerpeiling\">Burgerpeiling<\/a>). The percentage of digital form submissions is monitored for five key municipal services.<\/p>\n<p><br \/>The <em>Digital Government MetaMonitor<\/em> indicates a high level of data quality in the categories eID and Messaging. However, improvements can be made with regards to machine readability. The same applies to data in the category Transparency. On the contrary, the <em>Digital Government MetaMonitor <\/em>records 100% data quality on <a href=\"https:\/\/www.waarstaatjegemeente.nl\/jive?workspace_guid=88282e77-99a7-4c95-a58e-dbf99bb7ce7f\">digital form submission<\/a> and <a href=\"https:\/\/www.waarstaatjegemeente.nl\/dashboard\/dienstverlening-en-digitalisering\">user satisfaction<\/a>.<\/p>"},"subc":[{"id_subcategory":3020,"subcategory":"Overall uptake"},{"id_subcategory":3030,"subcategory":"Personal uptake"},{"id_subcategory":3010,"subcategory":"Business uptake"},{"id_subcategory":3040,"subcategory":"Public sector uptake"}],"timestamp":"2025-06-01T17:43:59+00:00"}