La elevada capacidad que nos brinda la tecnología de recoger, cruzar y computar, y finalmente interpretar enormes cantidades de datos de fuentes diversas, está suponiendo una verdadera revolución en los ámbitos del gobierno, la gestión y las políticas públicas. Lejos de ser un mero instrumento, o una mejora cuantitativa, está transformando la realidad de un modo tan palpable que los profesionales y teóricos de las ciencias políticas y la gestión pública, no podemos dejar pasar de largo su estudio. La experiencia como consultores en proyectos donde este incipiente campo se está abriendo, nos señala que la tecnología no es el mayor reto, sino que se encuentra en los campos en los que los politólogos y juristas debemos manifestar nuestra destreza: Los marcos de relación entre quien proporciona los sensores y la infraestructura, quien explota los datos, y los beneficiados. Los consorcios, el papel del ciudadano informado, nuevas formas de democracia, oportunidades de negocio, los límites al uso de la información, etc., por indicar unas cuantas.
Las implicaciones además, tocan varios ámbitos, con lo que se convierte en un nexo, en un referente nuclear donde confluyen muchos nuevos paradigmas y prácticas académicas y profesionales, por lo que este Grupo de Trabajo, puede encuadrarse en las tres áreas: Por un lado, supone un entorno de colaboración entre el gobierno, los ciudadanos y el mercado; por otro, es un instrumento valioso para el gobierno abierto, y finalmente, es una inequívoca oportunidad para la construcción colectiva de políticas y servicios públicos eficientes e inmediatamente evaluados. En este Grupo de Trabajo se incluyen ponencias que abordan estos conceptos:
• Inmediatez: en dispositivos móviles, realidad aumentada, votaciones y democracia directa, creación de conciencia y valoraciones de modo inmediato. • Transparencia y participación: Puesto que se puede optar por conformar una realidad, un discurso propio con el tratamiento de los datos en bruto, o trabajar sobre algo ya procesado. La participación además, alcanza niveles de micro gestión. • Modelo de negocio: Como el establecimiento de los marcos de explotación económica y política de la información. • SmartCities: Como uno de los ejemplos que condensan estas iniciativas, un reflejo en un microcosmos urbano, pero que puede dar el salto a otros niveles. • Toma de decisiones: tanto las estratégicas (efectos de una política pública o logro de objetivos de una legislatura) como de bajo nivel (por ejemplo, los baches de una calle) • Ciudadanos inteligentes, informados. Participación activa, responsable y respaldada. • Desarrollo económico: Anticipación, inversiones estratégicas. Fomento de la colaboración empresarial, emprendedores y start-ups gracias a la reducción de la incertidumbre. • Big Data, Business Intelligence, como instrumentos del análisis capacitado por la tecnología. Su aplicación al gobierno y administración. • Técnicas predictivas, para la mejora de los servicios públicos: tráfico, delincuencia, emergencias, espectáculos, desarrollo. En definitiva, puede ser la última pieza para completar el paradigma de la administración relacional, como superación de la administración burocrática, y la administración gerencial.
{ "__default": { "session": { "counter": 1, "timer": { "start": 1575856655, "last": 1575856655, "now": 1575856655 }, "token": "4zdZwNTRoqOxyR1N19oCGFuavSFZWAUl" }, "registry": {}, "user": { "id": 0, "name": null, "username": null, "email": null, "password": null, "password_clear": "", "block": null, "sendEmail": 0, "registerDate": null, "lastvisitDate": null, "activation": null, "params": null, "groups": [], "guest": 1, "lastResetTime": null, "resetCount": null, "requireReset": null, "aid": 0 } }, "__jresearch": { "citedRecords": [] }, "__com_jresearch": { "project": { "10": { "visited": true } } } }
SELECT `data` FROM `jos_session` WHERE `session_id` = '75ahivoee9ni432h5k3ptlkke3'
SELECT `session_id` FROM `jos_session` WHERE `session_id` = '75ahivoee9ni432h5k3ptlkke3' LIMIT 1
INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('75ahivoee9ni432h5k3ptlkke3', 1, 1575856655, 0, '', 0)
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `jos_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
SELECT id, rules FROM `jos_viewlevels`
SELECT b.id FROM jos_usergroups AS a LEFT JOIN jos_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 9
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM jos_extensions WHERE enabled = 1 AND type = 'plugin' AND state IN (0,1) AND access IN (1,1,5) ORDER BY ordering
UPDATE jos_extensions SET enabled=1 WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM jos_menu AS m LEFT JOIN jos_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft
SELECT id, home, template, s.params FROM jos_template_styles as s LEFT JOIN jos_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id WHERE s.client_id = 0 AND e.enabled = 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `jos_extensions` WHERE `type` = 'library' AND `element` = 'joomla'
UPDATE `jos_extensions` SET `params` = '{\"mediaversion\":\"5f0e476e2bf0bd846f31312671e989b0\"}' WHERE `type` = 'library' AND `element` = 'joomla'
SELECT * FROM jos_languages WHERE published=1 ORDER BY ordering ASC
SHOW FULL COLUMNS FROM `jos_jresearch_project`
SELECT * FROM jos_jresearch_project WHERE `id` = '10'
UPDATE jos_jresearch_project SET `hits` = (`hits` + 1) WHERE `id` = '10'
SELECT p.* FROM `jos_jresearch_publication` p JOIN `jos_jresearch_project_publication` pp WHERE p.id = pp.id_publication AND p.published = 1 AND p.internal = 1 AND pp.id_project = '10' ORDER BY p.year DESC, p.created DESC LIMIT 0, 15
SHOW FULL COLUMNS FROM `jos_jresearch_publication`
SELECT count(pp.id_publication) FROM `jos_jresearch_publication` p JOIN `jos_jresearch_project_publication` pp WHERE p.id = pp.id_publication AND p.published = 1 AND p.internal = 1 AND pp.id_project = '10'
SELECT id, name, published FROM jos_jresearch_research_area WHERE id IN (3) AND id > 1
SHOW FULL COLUMNS FROM `jos_jresearch_member`
SELECT * FROM jos_jresearch_member WHERE `id` = '248'
SELECT * FROM jos_jresearch_member WHERE `id` = '249'
SELECT * FROM jos_jresearch_member WHERE `id` = '371'
SELECT * FROM jos_jresearch_member WHERE `id` = '439'
SELECT * FROM jos_jresearch_member WHERE `id` = '330'
SELECT `element` FROM `jos_extensions` WHERE folder = 'jresearch-pubtypes' AND `enabled` = 1
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN jos_extensions AS e ON e.element = m.module AND e.client_id = m.client_id WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2019-12-09 01:57:35') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-12-09 01:57:35') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 112 OR mm.menuid <= 0) ORDER BY m.position, m.ordering
SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name FROM jos_fields_values fv LEFT JOIN jos_fields f ON fv.field_id = f.id LEFT JOIN jos_fields_groups fg ON fg.id = f.group_id WHERE fv.item_id = 13 AND f.context = "com_content.categories" AND f.language IN ("*", "es-ES") AND f.access = 1
SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name FROM jos_fields_values fv LEFT JOIN jos_fields f ON fv.field_id = f.id LEFT JOIN jos_fields_groups fg ON fg.id = f.group_id WHERE fv.item_id = 22 AND f.context = "com_content.categories" AND f.language IN ("*", "es-ES") AND f.access = 1
SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name FROM jos_fields_values fv LEFT JOIN jos_fields f ON fv.field_id = f.id LEFT JOIN jos_fields_groups fg ON fg.id = f.group_id WHERE fv.item_id = 16 AND f.context = "com_content.categories" AND f.language IN ("*", "es-ES") AND f.access = 1
SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name FROM jos_fields_values fv LEFT JOIN jos_fields f ON fv.field_id = f.id LEFT JOIN jos_fields_groups fg ON fg.id = f.group_id WHERE fv.item_id = 25 AND f.context = "com_content.categories" AND f.language IN ("*", "es-ES") AND f.access = 1
SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name FROM jos_fields_values fv LEFT JOIN jos_fields f ON fv.field_id = f.id LEFT JOIN jos_fields_groups fg ON fg.id = f.group_id WHERE fv.item_id = 26 AND f.context = "com_content.categories" AND f.language IN ("*", "es-ES") AND f.access = 1
SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name FROM jos_fields_values fv LEFT JOIN jos_fields f ON fv.field_id = f.id LEFT JOIN jos_fields_groups fg ON fg.id = f.group_id WHERE fv.item_id = 45 AND f.context = "com_content.categories" AND f.language IN ("*", "es-ES") AND f.access = 1
SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name FROM jos_fields_values fv LEFT JOIN jos_fields f ON fv.field_id = f.id LEFT JOIN jos_fields_groups fg ON fg.id = f.group_id WHERE fv.item_id = 40 AND f.context = "com_content.categories" AND f.language IN ("*", "es-ES") AND f.access = 1
SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name FROM jos_fields_values fv LEFT JOIN jos_fields f ON fv.field_id = f.id LEFT JOIN jos_fields_groups fg ON fg.id = f.group_id WHERE fv.item_id = 30 AND f.context = "com_content.categories" AND f.language IN ("*", "es-ES") AND f.access = 1
SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name FROM jos_fields_values fv LEFT JOIN jos_fields f ON fv.field_id = f.id LEFT JOIN jos_fields_groups fg ON fg.id = f.group_id WHERE fv.item_id = 46 AND f.context = "com_content.categories" AND f.language IN ("*", "es-ES") AND f.access = 1
SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name FROM jos_fields_values fv LEFT JOIN jos_fields f ON fv.field_id = f.id LEFT JOIN jos_fields_groups fg ON fg.id = f.group_id WHERE fv.item_id = 18 AND f.context = "com_content.categories" AND f.language IN ("*", "es-ES") AND f.access = 1
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params FROM jos_modules AS m WHERE m.id = 135 AND m.published = 1 AND m.access IN (1,1,5)
SELECT `id`,`name`,`rules`,`parent_id` FROM `jos_assets` WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djcatalog2','com_djimageslider','com_finder','com_installer','com_j2xml','com_jaextmanager','com_jce','com_joomailermailchimpintegration','com_joomlaupdate','com_jresearch','com_jsocialfeed','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_rsform','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN c.published = 2 AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name, CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft, CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count FROM jos_content AS a LEFT JOIN jos_categories AS c ON c.id = a.catid LEFT JOIN jos_users AS ua ON ua.id = a.created_by LEFT JOIN jos_users AS uam ON uam.id = a.modified_by LEFT JOIN jos_categories as parent ON parent.id = c.parent_id LEFT JOIN jos_content_rating AS v ON a.id = v.content_id WHERE c.published = 1 AND a.state = 1 AND a.featured = 0 AND a.catid IN (46) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-12-09 01:57:35') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-12-09 01:57:35') ORDER BY a.publish_up DESC LIMIT 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (s.lft <= c.lft AND c.lft < s.rgt) OR (c.lft < s.lft AND s.rgt < c.rgt) WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,5) AND c.published = 1 AND s.id = 46 ORDER BY c.lft
10 × SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name FROM jos_fields_values fv LEFT JOIN jos_fields f ON fv.field_id = f.id LEFT JOIN jos_fields_groups fg ON fg.id = f.group_id
9 × SELECT * FROM jos_jresearch_member
5 × SELECT `element` FROM `jos_extensions`
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `jos_extensions`
2 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN c.published = 2 AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name, CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft, CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count FROM jos_content AS a LEFT JOIN jos_categories AS c ON c.id = a.catid LEFT JOIN jos_users AS ua ON ua.id = a.created_by LEFT JOIN jos_users AS uam ON uam.id = a.modified_by LEFT JOIN jos_categories as parent ON parent.id = c.parent_id LEFT JOIN jos_content_rating AS v ON a.id = v.content_id
2 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params FROM jos_modules AS m
1 × SELECT `data` FROM `jos_session`
1 × SELECT id, name, published FROM jos_jresearch_research_area
1 × SELECT `id`,`name`,`rules`,`parent_id` FROM `jos_assets`
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN jos_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
1 × SELECT p.* FROM `jos_jresearch_publication` p JOIN `jos_jresearch_project_publication` pp
1 × SELECT count(pp.id_publication) FROM `jos_jresearch_publication` p JOIN `jos_jresearch_project_publication` pp
1 × SELECT `session_id` FROM `jos_session`
1 × SELECT * FROM jos_jresearch_project
1 × SELECT * FROM jos_languages
1 × SELECT id, home, template, s.params FROM jos_template_styles as s LEFT JOIN jos_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM jos_menu AS m LEFT JOIN jos_extensions AS e ON m.component_id = e.extension_id
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM jos_extensions
1 × SELECT b.id FROM jos_usergroups AS a LEFT JOIN jos_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT id, rules FROM `jos_viewlevels
1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (s.lft <= c.lft AND c.lft < s.rgt) OR (c.lft < s.lft AND s.rgt < c.rgt)
1 × INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('75ahivoee9ni432h5k3ptlkke3', 1, 1575856655, 0, '', 0
1 × UPDATE jos_extensions SET enabled=1
1 × UPDATE `jos_extensions` SET `params` = '{\"mediaversion\":\"5f0e476e2bf0bd846f31312671e989b0\"}'
1 × SHOW FULL COLUMNS FROM `jos_jresearch_project
1 × UPDATE jos_jresearch_project SET `hits` = (`hits` + 1)
1 × SHOW FULL COLUMNS FROM `jos_jresearch_publication
1 × SHOW FULL COLUMNS FROM `jos_jresearch_member