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":"FR","country_name":"France","summary":"<p><strong>eID <\/strong><a href=\"https:\/\/franceconnect.gouv.fr\">FranceConnect<\/a> is the eID service for private individuals developed by the French government. It can be used for both public and a number of private services. <a href=\"https:\/\/www.numerique.gouv.fr\/uploads\/20200827_Plaquette_Techgouv_DINUM.pdf\">ProConnect<\/a> is the upcoming eID-system for businesses, which was foreseen to be piloted in Q4 of 2020 and then rolled-out progressively. The eID system doesn&rsquo;t yet include a digital proxy service, but it is <a href=\"https:\/\/beta.gouv.fr\/startups\/aidantsconnect.html\">under development<\/a>.<\/p>\n<p><strong>ePayment <\/strong>Since mid-October 2018, the General Directorate of Public Finance (DGFiP) has been providing public authorities and users with an enhanced, secure and modern online payment service called <a href=\"https:\/\/joinup.ec.europa.eu\/sites\/default\/files\/inline-files\/Digital_Public_Administration_Factsheets_France_vFINAL.pdf\">PayFiP<\/a>. PayFiP allows for the payment by bank deposit of invoices issued by local authorities and public bodies (the state, local authorities, hospitals, etc.).<\/p>\n<p><strong>Messaging <\/strong>France doesn&rsquo;t have a government messaging system.<\/p>\n<p><strong>Transparency <\/strong>A <a href=\"https:\/\/www.numerique.gouv.fr\/uploads\/20200827_Plaquette_Techgouv_DINUM.pdf\">digital citizen file<\/a> finds itself in the piloting phase and is planned to be implemented in 2021. This file will allow citizens 1) to see which data different public administrations hold about them 2) to follow data exchanges between public organisations to facilitate public service delivery 3) to follow the status of their ongoing affairs.<\/p>\n<p><strong>General Digital Services <\/strong>The <a href=\"https:\/\/www.data.gouv.fr\/fr\/datasets\/observatoire-de-la-qualite-des-demarches-en-ligne\/\">Online Services Observatory<\/a> monitors both digital form submission and user satisfaction of the 250 key government services.<\/p>\n<p>According to the <em>Digital Government MetaMonitor<\/em>, the quality of public data on the eID&rsquo;s uptake in France can be improved, especially with regards to machine readability and update frequency. The same applies for data related to ePayment. On the contrary, data on digital form submission and <a href=\"https:\/\/www.data.gouv.fr\/fr\/datasets\/observatoire-de-la-qualite-des-demarches-en-ligne\/\">user satisfaction<\/a> in France is publicly available, machine readable, and updated regularly.&nbsp;<\/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-01T07:40:25+00:00"}