{"id":2883,"date":"2011-11-10T00:00:00","date_gmt":"2011-11-09T23:00:00","guid":{"rendered":"http:\/\/161.111.70.82\/open-refine\/"},"modified":"2018-02-21T13:30:57","modified_gmt":"2018-02-21T12:30:57","slug":"open-refine","status":"publish","type":"post","link":"https:\/\/gbif.es\/en\/open-refine\/","title":{"rendered":"Open Refine"},"content":{"rendered":"<p><strong>OPEN REFINE<\/strong><\/p>\n<p>This generic ETL (Extract, Transform and Load) tool is very useful for working with messy data, in general (transformation, analysis etc.). The three tutorial videos in their website provide a good overview of what is possible to do or be adapted to biodiversity data without too much trouble.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>OPEN REFINE This generic ETL (Extract, Transform and Load) tool is very useful for working with messy data, in general (transformation, analysis etc.). The three tutorial videos in their website provide a good overview of what is possible to do or be adapted to biodiversity data without too much trouble.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","inline_featured_image":false,"footnotes":""},"categories":[3],"tags":[106,105,104,107],"class_list":["post-2883","post","type-post","status-publish","format-standard","hentry","category-noticia","tag-clean","tag-messy-data","tag-tool","tag-transform","tematicapost-online-tool"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.0 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Open Refine - GBIF.ES<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/gbif.es\/open-refine\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Open Refine - GBIF.ES\" \/>\n<meta property=\"og:description\" content=\"OPEN REFINE This generic ETL (Extract, Transform and Load) tool is very useful for working with messy data, in general (transformation, analysis etc.). The three tutorial videos in their website provide a good overview of what is possible to do or be adapted to biodiversity data without too much trouble.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/gbif.es\/open-refine\/\" \/>\n<meta property=\"og:site_name\" content=\"GBIF.ES\" \/>\n<meta property=\"article:published_time\" content=\"2011-11-09T23:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-02-21T12:30:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/gbif.es\/wp-content\/uploads\/2024\/07\/logo-GBIF-RGB-01.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1064\" \/>\n\t<meta property=\"og:image:height\" content=\"554\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"gbif_us\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@GbifEs\" \/>\n<meta name=\"twitter:site\" content=\"@GbifEs\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"gbif_us\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/gbif.es\/open-refine\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/gbif.es\/open-refine\/\"},\"author\":{\"name\":\"gbif_us\",\"@id\":\"https:\/\/gbif.es\/#\/schema\/person\/95a358798448d8991fcabd16d01a4a19\"},\"headline\":\"Open Refine\",\"datePublished\":\"2011-11-09T23:00:00+00:00\",\"dateModified\":\"2018-02-21T12:30:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/gbif.es\/open-refine\/\"},\"wordCount\":52,\"publisher\":{\"@id\":\"https:\/\/gbif.es\/#organization\"},\"keywords\":[\"clean\",\"messy data\",\"tool\",\"transform\"],\"articleSection\":[\"Noticia\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/gbif.es\/open-refine\/\",\"url\":\"https:\/\/gbif.es\/open-refine\/\",\"name\":\"Open Refine - GBIF.ES\",\"isPartOf\":{\"@id\":\"https:\/\/gbif.es\/#website\"},\"datePublished\":\"2011-11-09T23:00:00+00:00\",\"dateModified\":\"2018-02-21T12:30:57+00:00\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/gbif.es\/open-refine\/\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/gbif.es\/#website\",\"url\":\"https:\/\/gbif.es\/\",\"name\":\"GBIF.ES - Nodo Nacional de Informaci\u00f3n en Biodiversidad\",\"description\":\"National Biodiversity Information Node\",\"publisher\":{\"@id\":\"https:\/\/gbif.es\/#organization\"},\"alternateName\":\"GBIF.ES\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/gbif.es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/gbif.es\/#organization\",\"name\":\"GBIF.ES - Nodo Nacional de Informaci\u00f3n en Biodiversidad\",\"url\":\"https:\/\/gbif.es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/gbif.es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/gbif.es\/wp-content\/uploads\/2024\/07\/logo-GBIF-RGB-01.png\",\"contentUrl\":\"https:\/\/gbif.es\/wp-content\/uploads\/2024\/07\/logo-GBIF-RGB-01.png\",\"width\":1064,\"height\":554,\"caption\":\"GBIF.ES - Nodo Nacional de Informaci\u00f3n en Biodiversidad\"},\"image\":{\"@id\":\"https:\/\/gbif.es\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/GbifEs\",\"https:\/\/www.linkedin.com\/company\/gbif-spain\/\",\"https:\/\/www.instagram.com\/gbifes\/\",\"https:\/\/www.threads.net\/@gbifes\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/gbif.es\/#\/schema\/person\/95a358798448d8991fcabd16d01a4a19\",\"name\":\"gbif_us\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/gbif.es\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d9ef1ea8efffbc20101c535444d843ec4abebb20664b66a4b66a674287f20e8c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d9ef1ea8efffbc20101c535444d843ec4abebb20664b66a4b66a674287f20e8c?s=96&d=mm&r=g\",\"caption\":\"gbif_us\"},\"url\":\"https:\/\/gbif.es\/en\/author\/gbif_us\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Open Refine - GBIF.ES","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/gbif.es\/open-refine\/","og_locale":"en_US","og_type":"article","og_title":"Open Refine - GBIF.ES","og_description":"OPEN REFINE This generic ETL (Extract, Transform and Load) tool is very useful for working with messy data, in general (transformation, analysis etc.). The three tutorial videos in their website provide a good overview of what is possible to do or be adapted to biodiversity data without too much trouble.","og_url":"https:\/\/gbif.es\/open-refine\/","og_site_name":"GBIF.ES","article_published_time":"2011-11-09T23:00:00+00:00","article_modified_time":"2018-02-21T12:30:57+00:00","og_image":[{"width":1064,"height":554,"url":"https:\/\/gbif.es\/wp-content\/uploads\/2024\/07\/logo-GBIF-RGB-01.png","type":"image\/png"}],"author":"gbif_us","twitter_card":"summary_large_image","twitter_creator":"@GbifEs","twitter_site":"@GbifEs","twitter_misc":{"Written by":"gbif_us"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/gbif.es\/open-refine\/#article","isPartOf":{"@id":"https:\/\/gbif.es\/open-refine\/"},"author":{"name":"gbif_us","@id":"https:\/\/gbif.es\/#\/schema\/person\/95a358798448d8991fcabd16d01a4a19"},"headline":"Open Refine","datePublished":"2011-11-09T23:00:00+00:00","dateModified":"2018-02-21T12:30:57+00:00","mainEntityOfPage":{"@id":"https:\/\/gbif.es\/open-refine\/"},"wordCount":52,"publisher":{"@id":"https:\/\/gbif.es\/#organization"},"keywords":["clean","messy data","tool","transform"],"articleSection":["Noticia"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/gbif.es\/open-refine\/","url":"https:\/\/gbif.es\/open-refine\/","name":"Open Refine - GBIF.ES","isPartOf":{"@id":"https:\/\/gbif.es\/#website"},"datePublished":"2011-11-09T23:00:00+00:00","dateModified":"2018-02-21T12:30:57+00:00","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/gbif.es\/open-refine\/"]}]},{"@type":"WebSite","@id":"https:\/\/gbif.es\/#website","url":"https:\/\/gbif.es\/","name":"GBIF.ES - Nodo Nacional de Informaci\u00f3n en Biodiversidad","description":"National Biodiversity Information Node","publisher":{"@id":"https:\/\/gbif.es\/#organization"},"alternateName":"GBIF.ES","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/gbif.es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/gbif.es\/#organization","name":"GBIF.ES - Nodo Nacional de Informaci\u00f3n en Biodiversidad","url":"https:\/\/gbif.es\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/gbif.es\/#\/schema\/logo\/image\/","url":"https:\/\/gbif.es\/wp-content\/uploads\/2024\/07\/logo-GBIF-RGB-01.png","contentUrl":"https:\/\/gbif.es\/wp-content\/uploads\/2024\/07\/logo-GBIF-RGB-01.png","width":1064,"height":554,"caption":"GBIF.ES - Nodo Nacional de Informaci\u00f3n en Biodiversidad"},"image":{"@id":"https:\/\/gbif.es\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/GbifEs","https:\/\/www.linkedin.com\/company\/gbif-spain\/","https:\/\/www.instagram.com\/gbifes\/","https:\/\/www.threads.net\/@gbifes"]},{"@type":"Person","@id":"https:\/\/gbif.es\/#\/schema\/person\/95a358798448d8991fcabd16d01a4a19","name":"gbif_us","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/gbif.es\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d9ef1ea8efffbc20101c535444d843ec4abebb20664b66a4b66a674287f20e8c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d9ef1ea8efffbc20101c535444d843ec4abebb20664b66a4b66a674287f20e8c?s=96&d=mm&r=g","caption":"gbif_us"},"url":"https:\/\/gbif.es\/en\/author\/gbif_us\/"}]}},"_links":{"self":[{"href":"https:\/\/gbif.es\/en\/wp-json\/wp\/v2\/posts\/2883","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gbif.es\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gbif.es\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gbif.es\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gbif.es\/en\/wp-json\/wp\/v2\/comments?post=2883"}],"version-history":[{"count":0,"href":"https:\/\/gbif.es\/en\/wp-json\/wp\/v2\/posts\/2883\/revisions"}],"wp:attachment":[{"href":"https:\/\/gbif.es\/en\/wp-json\/wp\/v2\/media?parent=2883"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gbif.es\/en\/wp-json\/wp\/v2\/categories?post=2883"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gbif.es\/en\/wp-json\/wp\/v2\/tags?post=2883"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}