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] => eid
            [1] => 1020
        )

    [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] => eid
            [1] => 1030
        )

    [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] => eid
            [1] => 1010
        )

    [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] => eid
            [1] => 1050
        )

    [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":1000,"main_category":"eID","visible":1,"sort_order":1,"summary":"Indicators for this topic focus on mapping the use of the national system for electronic identification and authentication of citizens and businesses, in order to access public and private services and perform transactions. \n\neID is measured by assessing the yearly numbers of cumulative registered users, digital proxy activations, realised transactions, downloaded and installed mobile applications, cumulative adhered public and private organisations and services, and eID providers."},"country":{"abbr":"ES","country_name":"Spain","summary":"<p><strong>eID <\/strong>Since 2014, Spain has used <a href=\"https:\/\/clave.gob.es\/clave_Home\/en\/clave\/queEs.html\">Cl@ve<\/a>, a platform for identification, authentication and electronic signature in the public sector. It serves as a horizontal and interoperable system that avoids public administrations having to implement and manage their own systems for authentication and signature, and citizens having to use different methods of identification when interacting with the administration electronically. A digital proxy service is made available through the Electronic Power of Attorney Register (<a href=\"https:\/\/dataobsae.administracionelectronica.gob.es\/cmobsae3\/dashboard\/Dashboard.action#REA_002REA-summary\">Registro Electr&oacute;nico de Apoderamientos<\/a>).<\/p>\n<p><strong>ePayment <\/strong>The <a href=\"https:\/\/administracionelectronica.gob.es\/ctt\/pagos#.YG7JVOgzZjW\">Pasarela de Pagos<\/a> platform allows public administrations to implement telematic payment in the applications that manage procedures involving the payment of fees.<\/p>\n<p><strong>Messaging <\/strong>The service <a href=\"https:\/\/administracionelectronica.gob.es\/ctt\/notifica\/abstract#.YG7EcugzZjU\">Notifica <\/a>allows citizens and businesses to receive online administrative notifications and correspondence, contributing to the elimination of official paper-based notifications.<\/p>\n<p><strong>Transparency <\/strong>The Citizen Folder (<a href=\"https:\/\/sede.administracion.gob.es\/carpeta\/clave.htm\">Carpeta Ciudadana<\/a>) offers citizens the possibility to access information on the status of ongoing services as well as the personal data available to the public administration.<\/p>\n<p><strong>General Digital Services<\/strong> Citizens can <a href=\"https:\/\/administracion.gob.es\/pag_Home\/Tramites\/Realizar_un_Tramite-nuevo.html#.YG7NbegzZjV\">access digital services and realise transactions<\/a> using the portals of the relevant public administrations. No systematic measurement of user satisfaction has been found.<\/p>\n<p><br \/>The <em>Digital Government MetaMonitor<\/em> shows high data completeness, uptake frequency and machine readability regarding the uptake of the eID. This is thanks to <a href=\"https:\/\/dataobsae.administracionelectronica.gob.es\/cmobsae3\/dashboard\/Dashboard.action\">DATAOBSAE<\/a>, a public dashboard of electronic administration metrics based on data from horizontal services or external sources. It also provides data on indicators measured in the categories ePayment and Messaging. For the categories Transparency and General Digital services, no data is currently available.<\/p>"},"subc":[{"id_subcategory":1020,"subcategory":"Overall uptake"},{"id_subcategory":1030,"subcategory":"Personal uptake"},{"id_subcategory":1010,"subcategory":"Business uptake"},{"id_subcategory":1050,"subcategory":"Public sector uptake"},{"id_subcategory":1040,"subcategory":"Private sector support"}],"timestamp":"2025-07-01T09:31:19+00:00"}