#OpenRefine datasets [ { "op": "core/text-transform", "description": "Text transform on cells in column private using expression value.toLowercase()", "engineConfig": { "mode": "row-based", "facets": [] }, "columnName": "private", "expression": "value.toLowercase()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column featured using expression value.toLowercase()", "engineConfig": { "mode": "row-based", "facets": [] }, "columnName": "featured", "expression": "value.toLowercase()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "rdf-extension/save-rdf-schema", "description": "Save RDF schema skeleton", "schema": { "baseUri": "http://data.gouv.fr/fr/datasets/", "prefixes": [ { "name": "dgfr", "uri": "http://colin.maudry.com/ontologies/dgfr#" }, { "name": "dct", "uri": "http://purl.org/dc/terms/" }, { "name": "rdf", "uri": "http://www.w3.org/1999/02/22-rdf-syntax-ns#" }, { "name": "owl", "uri": "http://www.w3.org/2002/07/owl#" }, { "name": "org", "uri": "http://www.w3.org/ns/org#" }, { "name": "xsd", "uri": "http://www.w3.org/2001/XMLSchema#" }, { "name": "rdfs", "uri": "http://www.w3.org/2000/01/rdf-schema#" }, { "name": "dcat", "uri": "http://www.w3.org/ns/dcat#" }, { "name": "foaf", "uri": "http://xmlns.com/foaf/0.1/" } ], "rootNodes": [ { "nodeType": "cell-as-resource", "expression": "value + \"#this\"", "isRowNumberCell": false, "columnName": "id", "rdfTypes": [ { "uri": "http://www.w3.org/ns/dcat#Dataset", "curie": "dcat:Dataset" } ], "links": [ { "uri": "http://purl.org/dc/terms/identifier", "curie": "dct:identifier", "target": { "nodeType": "cell-as-literal", "expression": "value", "isRowNumberCell": false, "columnName": "id" } }, { "uri": "http://purl.org/dc/terms/title", "curie": "dct:title", "target": { "nodeType": "cell-as-literal", "expression": "value", "isRowNumberCell": false, "columnName": "title" } }, { "uri": "http://www.w3.org/ns/dcat#landingPage", "curie": "dcat:landingPage", "target": { "nodeType": "cell-as-resource", "expression": "value", "isRowNumberCell": false, "columnName": "url", "rdfTypes": [], "links": [] } }, { "uri": "http://purl.org/dc/terms/rightsHolder", "curie": "dct:rightsHolder", "target": { "nodeType": "cell-as-literal", "expression": "value", "isRowNumberCell": false, "columnName": "organization" } }, { "uri": "http://purl.org/dc/terms/publisher", "curie": "dct:publisher", "target": { "nodeType": "cell-as-literal", "expression": "value", "isRowNumberCell": false, "columnName": "supplier" } }, { "uri": "http://purl.org/dc/terms/description", "curie": "dct:description", "target": { "nodeType": "cell-as-literal", "expression": "value", "isRowNumberCell": false, "columnName": "description" } }, { "uri": "http://purl.org/dc/terms/accrualPeriodicity", "curie": "dct:accrualPeriodicity", "target": { "nodeType": "cell-as-resource", "expression": "\"http://purl.org/cld/freq/\" + value", "isRowNumberCell": false, "columnName": "frequency", "rdfTypes": [], "links": [] } }, { "uri": "http://purl.org/dc/terms/license", "curie": "dct:license", "target": { "nodeType": "cell-as-literal", "expression": "value", "isRowNumberCell": false, "columnName": "license" } }, { "uri": "http://colin.maudry.com/ontologies/dgfr#private", "curie": "dgfr:private", "target": { "nodeType": "cell-as-literal", "expression": "value", "isRowNumberCell": false, "valueType": "http://www.w3.org/2001/XMLSchema#boolean", "columnName": "private" } }, { "uri": "http://colin.maudry.com/ontologies/dgfr#featured", "curie": "dgfr:featured", "target": { "nodeType": "cell-as-literal", "expression": "value", "isRowNumberCell": false, "valueType": "http://www.w3.org/2001/XMLSchema#boolean", "columnName": "featured" } }, { "uri": "http://purl.org/dc/terms/created", "curie": "dct:created", "target": { "nodeType": "cell-as-literal", "expression": "value", "isRowNumberCell": false, "valueType": "http://www.w3.org/2001/XMLSchema#dateTime", "columnName": "created_at" } }, { "uri": "http://purl.org/dc/terms/modified", "curie": "dct:modified", "target": { "nodeType": "cell-as-literal", "expression": "value", "isRowNumberCell": false, "valueType": "http://www.w3.org/2001/XMLSchema#dateTime", "columnName": "last_modified" } }, { "uri": "http://www.w3.org/ns/dcat#keyword", "curie": "dcat:keyword", "target": { "nodeType": "cell-as-literal", "expression": "split(value, \",\")", "isRowNumberCell": false, "columnName": "tags" } }, { "uri": "http://colin.maudry.com/ontologies/dgfr#visitors", "curie": "dgfr:visitors", "target": { "nodeType": "cell-as-literal", "expression": "value", "isRowNumberCell": false, "valueType": "http://www.w3.org/2001/XMLSchema#int", "columnName": "metric.nb_uniq_visitors" } }, { "uri": "http://colin.maudry.com/ontologies/dgfr#views", "curie": "dgfr:views", "target": { "nodeType": "cell-as-literal", "expression": "value", "isRowNumberCell": false, "valueType": "http://www.w3.org/2001/XMLSchema#int", "columnName": "metric.views" } }, { "uri": "http://colin.maudry.com/ontologies/dgfr#followers", "curie": "dgfr:followers", "target": { "nodeType": "cell-as-literal", "expression": "value", "isRowNumberCell": false, "valueType": "http://www.w3.org/2001/XMLSchema#int", "columnName": "metric.followers" } }, { "uri": "http://colin.maudry.com/ontologies/dgfr#reuses", "curie": "dgfr:reuses", "target": { "nodeType": "cell-as-literal", "expression": "value", "isRowNumberCell": false, "valueType": "http://www.w3.org/2001/XMLSchema#int", "columnName": "metric.reuses" } }, { "uri": "http://colin.maudry.com/ontologies/dgfr#visits", "curie": "dgfr:visits", "target": { "nodeType": "cell-as-literal", "expression": "value", "isRowNumberCell": false, "valueType": "http://www.w3.org/2001/XMLSchema#int", "columnName": "metric.nb_visits" } }, { "uri": "http://colin.maudry.com/ontologies/dgfr#hits", "curie": "dgfr:hits", "target": { "nodeType": "cell-as-literal", "expression": "value", "isRowNumberCell": false, "valueType": "http://www.w3.org/2001/XMLSchema#int", "columnName": "metric.nb_hits" } }, { "uri": "http://colin.maudry.com/ontologies/dgfr#issues", "curie": "dgfr:issues", "target": { "nodeType": "cell-as-literal", "expression": "value", "isRowNumberCell": false, "valueType": "http://www.w3.org/2001/XMLSchema#int", "columnName": "metric.issues" } } ] } ] } } ] #OpenRefine resources [ { "op": "core/text-transform", "description": "Text transform on cells in column dataset.private using expression grel:toLowercase(value)", "engineConfig": { "mode": "row-based", "facets": [] }, "columnName": "dataset.private", "expression": "grel:toLowercase(value)", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column format using expression grel:toLowercase(value)", "engineConfig": { "mode": "row-based", "facets": [] }, "columnName": "format", "expression": "grel:toLowercase(value)", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "rdf-extension/save-rdf-schema", "description": "Save RDF schema skeleton", "schema": { "baseUri": "http://data.gouv.fr/fr/resources/", "prefixes": [ { "name": "dgfr", "uri": "http://colin.maudry.com/ontologies/dgfr#" }, { "name": "dct", "uri": "http://purl.org/dc/terms/" }, { "name": "rdf", "uri": "http://www.w3.org/1999/02/22-rdf-syntax-ns#" }, { "name": "owl", "uri": "http://www.w3.org/2002/07/owl#" }, { "name": "xsd", "uri": "http://www.w3.org/2001/XMLSchema#" }, { "name": "rdfs", "uri": "http://www.w3.org/2000/01/rdf-schema#" }, { "name": "dcat", "uri": "http://www.w3.org/ns/dcat#" }, { "name": "foaf", "uri": "http://xmlns.com/foaf/0.1/" } ], "rootNodes": [ { "nodeType": "cell-as-resource", "expression": "value + \"#this\"", "isRowNumberCell": false, "columnName": "id", "rdfTypes": [ { "uri": "http://www.w3.org/ns/dcat#Distribution", "curie": "dcat:Distribution" } ], "links": [ { "uri": "http://purl.org/dc/terms/identifier", "curie": "dct:identifier", "target": { "nodeType": "cell-as-literal", "expression": "value", "isRowNumberCell": false, "columnName": "id" } }, { "uri": "http://www.w3.org/ns/dcat#downloadURL", "curie": "dcat:downloadURL", "target": { "nodeType": "cell-as-resource", "expression": "value", "isRowNumberCell": false, "columnName": "url", "rdfTypes": [], "links": [] } }, { "uri": "http://purl.org/dc/terms/title", "curie": "dct:title", "target": { "nodeType": "cell-as-literal", "expression": "value", "isRowNumberCell": false, "columnName": "title" } }, { "uri": "http://purl.org/dc/terms/description", "curie": "dct:description", "target": { "nodeType": "cell-as-literal", "expression": "value", "isRowNumberCell": false, "columnName": "description" } }, { "uri": "http://colin.maudry.com/ontologies/dgfr#type", "curie": "dgfr:type", "target": { "nodeType": "cell-as-literal", "expression": "value", "isRowNumberCell": false, "columnName": "type" } }, { "uri": "http://colin.maudry.com/ontologies/dgfr#format", "curie": "dgfr:format", "target": { "nodeType": "cell-as-literal", "expression": "split(value,\",\")", "isRowNumberCell": false, "columnName": "format" } }, { "uri": "http://www.w3.org/ns/dcat#mediaType", "curie": "dcat:mediaType", "target": { "nodeType": "cell-as-literal", "expression": "value", "isRowNumberCell": false, "columnName": "mime" } }, { "uri": "http://www.w3.org/ns/dcat#byteSize", "curie": "dcat:byteSize", "target": { "nodeType": "cell-as-literal", "expression": "value", "isRowNumberCell": false, "valueType": "http://www.w3.org/2001/XMLSchema#int", "columnName": "size" } }, { "uri": "http://colin.maudry.com/ontologies/dgfr#checksumType", "curie": "dgfr:checksumType", "target": { "nodeType": "cell-as-literal", "expression": "value", "isRowNumberCell": false, "columnName": "checksum.type" } }, { "uri": "http://colin.maudry.com/ontologies/dgfr#checksumValue", "curie": "dgfr:checksumValue", "target": { "nodeType": "cell-as-literal", "expression": "value", "isRowNumberCell": false, "columnName": "checksum.value" } }, { "uri": "http://purl.org/dc/terms/issued", "curie": "dct:issued", "target": { "nodeType": "cell-as-literal", "expression": "value", "isRowNumberCell": false, "valueType": "http://www.w3.org/2001/XMLSchema#dateTime", "columnName": "created_at" } }, { "uri": "http://purl.org/dc/terms/modified", "curie": "dct:modified", "target": { "nodeType": "cell-as-literal", "expression": "value", "isRowNumberCell": false, "valueType": "http://www.w3.org/2001/XMLSchema#dateTime", "columnName": "modified" } }, { "uri": "http://colin.maudry.com/ontologies/dgfr#downloads", "curie": "dgfr:downloads", "target": { "nodeType": "cell-as-literal", "expression": "value", "isRowNumberCell": false, "valueType": "http://www.w3.org/2001/XMLSchema#int", "columnName": "downloads" } } ] }, { "nodeType": "cell-as-resource", "expression": "\"http://data.gouv.fr/fr/datasets/\" + value + \"#this\"", "isRowNumberCell": false, "columnName": "dataset.id", "rdfTypes": [], "links": [ { "uri": "http://www.w3.org/ns/dcat#distribution", "curie": "dcat:distribution", "target": { "nodeType": "cell-as-resource", "expression": "value + \"#this\"", "isRowNumberCell": false, "columnName": "id", "rdfTypes": [], "links": [] } } ] } ] } } ]