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":"EE","country_name":"Estonia","summary":"<p><strong>eID <\/strong>The function for electronic identification is integrated into the <a href=\"https:\/\/e-estonia.com\/solutions\/e-identity\/\">mandatory national legal photo ID<\/a>, complemented by the Mobile-ID and Smart-ID solutions. The Estonian eID is used in both public and private services and is always a personal account. It can be used to <a href=\"https:\/\/e-estonia.com\/solutions\/business-and-finance\/e-business-register\">register a business<\/a> electronically and authorises eID users to act on behalf of a company. The eID system doesn&rsquo;t include a digital proxy service.<\/p>\n<p><strong>ePayment <\/strong>Since November 2018, commercial banks operating in Estonia have been able to join the <a href=\"https:\/\/joinup.ec.europa.eu\/sites\/default\/files\/inline-files\/Digital_Public_Administration_Factsheets_Estonia_vFINAL.pdf\">TARGET Instant Payment Settlement (TIPS)<\/a> through Eesti Pank (Bank of Estonia). TIPS allows citizens to settle payments in real time, night or day and throughout the year.<\/p>\n<p><strong>Messaging <\/strong>eID users have the possibility to activate the <a href=\"https:\/\/joinup.ec.europa.eu\/sites\/default\/files\/inline-files\/Digital_Government_Factsheets_Estonia_2019.pdf\">email or SMS notification service<\/a> of the State Portal eesti.ee, thereby allowing public authorities to send documents and notifications.<\/p>\n<p><strong>Transparency <\/strong>Citizens can consult their data and ongoing affairs on their personal page on the national citizen portal <a href=\"https:\/\/www.eesti.ee\">https:\/\/www.eesti.ee<\/a>.<\/p>\n<p><strong>General Digital Services <\/strong>The state portal&rsquo;s environment allows users to authenticate with their national eID card to perform transactions with municipal and government bodies, complete and send online forms and applications and sign documents digitally. No systematic measurement of user satisfaction has been found.<\/p>\n<p><br \/>The <em>Digital Government MetaMonitor<\/em> indicates a high level of data completeness on the uptake of the eID and electronic messaging by citizens and businesses in Estonia. Improvements can be made with regards to machine readability of public data and update frequency. Currently, there is no public data available on ePayment, transparency, and general digital services in Estonia.<\/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-06-01T17:33:18+00:00"}