CZ-NACE
type: Pipeline
version: 5
created: 2021-06-24T15:41:33.927
last update: 2023-04-18T16:19:56.898962737
profile: default

https://stirdata.opendata.cz/etl/resources/pipelines/1624542093927/10
type: Connection
source binding: FilesOutput
source component: HTTP get
target binding: InputFiles
target component: Tabular

https://stirdata.opendata.cz/etl/resources/pipelines/1624542093927/11
type: Connection
source binding: OutputRdf
source component: Tabular
target binding: InputRdf
target component: SPARQL construct

SPARQL construct
type: Component
configuration graph: https://stirdata.opendata.cz/etl/resources/pipelines/1624542093927/12
template: http://etl.linkedpipes.com/resources/components/t-sparqlConstruct/0.0.0
x: 496
y: 103
description: SKOSify

HTTP get
type: Component
configuration graph: https://stirdata.opendata.cz/etl/resources/pipelines/1624542093927/18
template: http://etl.linkedpipes.com/resources/components/e-httpGetFile/0.0.0
x: 39
y: 115
description: CZ-NACE codelist from Czech Statistical Office

Files to SCP
type: Component
configuration graph: https://stirdata.opendata.cz/etl/resources/pipelines/1624542093927/19
template: http://etl.linkedpipes.com/resources/components/l-filesToScp/0.0.0
x: 1308
y: 109

Tabular
type: Component
configuration graph: https://stirdata.opendata.cz/etl/resources/pipelines/1624542093927/graph/15
template: http://etl.linkedpipes.com/resources/components/t-tabular/0.0.0
x: 340
y: 112

RDF to file
type: Component
configuration graph: https://stirdata.opendata.cz/etl/resources/pipelines/1624542093927/13
template: http://etl.linkedpipes.com/resources/components/t-rdfToFile/0.0.0
x: 1148
y: 107

https://stirdata.opendata.cz/etl/resources/pipelines/1624542093927/8
type: Connection
source binding: OutputFile
source component: RDF to file
target binding: FilesInput
target component: Files to SCP

Text holder
type: Component
configuration graph: configuration
template: http://etl.linkedpipes.com/resources/components/e-textHolder/0.0.0
x: 549
y: 240

SPARQL update
type: Component
configuration graph: configuration
template: http://etl.linkedpipes.com/resources/components/t-sparqlUpdate/0.0.0
x: 756
y: 158
description: Delete levels

Files to RDF single graph
type: Component
configuration graph: configuration
template: http://etl.linkedpipes.com/resources/components/t-filesToRdfGraph/0.0.0
x: 508
y: 295

SPARQL update
type: Component
configuration graph: configuration
template: http://etl.linkedpipes.com/resources/components/t-sparqlUpdate/0.0.0
x: 756
y: 64
description: Add top concept

https://stirdata.opendata.cz/etl/resources/pipelines/1624542093927/connection/23a4-a9f8
type: Connection
source binding: OutputRdf
source component: SPARQL update
target binding: InputRdf
target component: SPARQL update

https://stirdata.opendata.cz/etl/resources/pipelines/1624542093927/connection/25c8-b211
type: Connection
source binding: OutputRdf
source component: SPARQL construct
target binding: InputRdf
target component: SPARQL update

https://stirdata.opendata.cz/etl/resources/pipelines/1624542093927/connection/872a-949f
type: Connection
source binding: OutputRdf
source component: SPARQL update
target binding: InputRdf
target component: RDF to file

https://stirdata.opendata.cz/etl/resources/pipelines/1624542093927/connection/89d8-9ee6
type: Connection
source binding: FilesOutput
source component: Text holder
target binding: InputFiles
target component: Files to RDF single graph

https://stirdata.opendata.cz/etl/resources/pipelines/1624542093927/connection/f281-9625
type: Connection
source binding: OutputRdf
source component: Files to RDF single graph
target binding: InputRdf
target component: RDF to file

configuration
type: Configuration
query: PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX : <urn:> PREFIX stir: <https://w3id.org/stirdata/vocabulary/> CONSTRUCT { ?cs a skos:ConceptScheme ; skos:prefLabel "CZ-NACE_KL"@cs . ?s a skos:Concept, stir:BusinessActivity ; skos:prefLabel ?label_cs ; skos:altLabel ?label_zkr_cs ; skos:notation ?kod ; skos:inScheme ?cs ; stir:level ?length ; skos:broader ?broader ; skos:exactMatch ?eunace . ?broader skos:narrower ?s . } WHERE { ?s :CHODNOTA ?kod ; :TEXT ?label ; :ZKRTEXT ?label_zkr . OPTIONAL { ?s :NADVAZ ?nad } BIND(STRLANG(?label,"cs") AS ?label_cs) BIND(STRLANG(?label_zkr,"cs") AS ?label_zkr_cs) BIND(STRLEN(?kod) AS ?length) OPTIONAL { #BIND(IF(STRLEN(?kod) < 3, ?kod, CONCAT(SUBSTR(?kod, 1, 2), ".", SUBSTR(?kod, 3, STRLEN(?kod)))) AS ?eukod) BIND(IRI(CONCAT("http://data.europa.eu/ux2/nace2/", ?kod)) AS ?eunace) FILTER(?length < 5) } BIND(IRI("https://obchodní-rejstřík.stirdata.opendata.cz/zdroj/číselníky/nace-cz") as ?cs) BIND(IRI(CONCAT(STR(?cs), "/položky/", ?nad)) AS ?broader) }
query control: None

https://stirdata.opendata.cz/etl/resources/pipelines/1624542093927/13
type: Configuration
file name: nace-cz.trig
file name control: None
file type: application/trig
file type control: None
graph uri: https://obchodní-rejstřík.stirdata.opendata.cz/nace
graph uri control: None

configuration
type: Configuration
encode url: false
encode url control: None
file name: nace.csv
file name control: None
file uri: https://apl.czso.cz/iSMS/cisexp.jsp
file uri control: None
hard redirect: false
hard redirect control: None
user agent control: None
utf8 redirect: false
utf8 redirect control: None

https://stirdata.opendata.cz/etl/resources/pipelines/1624542093927/19
type: Configuration
clear directory: false
clear directory control: None
connection time out control: None
create directory: true
create directory control: None
directory: /data/www/soubor
directory control: None
host: stirdata.opendata.cz
host control: None
password: nejlepsipaper
password control: None
port: 22
port control: None
user name: uploader
user name control: None

configuration
type: Configuration
content: @prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> . @prefix xsd: <http://www.w3.org/2001/XMLSchema#> . @prefix skos: <http://www.w3.org/2004/02/skos/core#> . @prefix schema: <https://schema.org> . @prefix adms: <http://www.w3.org/ns/adms#> . @prefix dcterms: <http://purl.org/dc/terms/> . @prefix owl: <http://www.w3.org/2002/07/owl#> . @prefix org: <http://www.w3.org/ns/org#> . @prefix rov: <http://www.w3.org/ns/regorg#> . @prefix locn: <http://www.w3.org/ns/locn#> . @prefix legal: <http://www.w3.org/ns/legal#> . @prefix m8g: <http://data.europa.eu/m8g/> . @prefix stirdata: <https://w3id.org/stirdata/vocabulary/> .
content control: None
file name: prefixes.ttl
file name control: None

configuration
type: Configuration
query: PREFIX stir: <https://w3id.org/stirdata/vocabulary/> DELETE WHERE { ?s stir:level ?o }
query control: None

configuration
type: Configuration
commit size: 50000
commit size control: None
mime type control: None
soft fail: false
soft fail control: None

configuration
type: Configuration
query: PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX stir: <https://w3id.org/stirdata/vocabulary/> PREFIX cs: <https://obchodní-rejstřík.stirdata.opendata.cz/zdroj/číselníky/nace-cz> INSERT { ?s skos:topConceptOf cs: . cs: skos:hasTopConcept ?s . } WHERE { ?s stir:level 1 . }
query control: None

https://stirdata.opendata.cz/etl/resources/pipelines/1624542093927/14
type: Table
base uri: urn:
base uri control: None
dialect control: None
encode type: default
encode type control: None
full mapping: true
full mapping control: None
generate null header names control: None
normal output: false
normal output control: None
row limit control: None
skip lines: 0
skip lines control: None
skip on error control: None
table schema control: None
use base uri: true
use base uri control: None
dialect: https://stirdata.opendata.cz/etl/resources/pipelines/1624542093927/16
table schema: https://stirdata.opendata.cz/etl/resources/pipelines/1624542093927/17

https://stirdata.opendata.cz/etl/resources/pipelines/1624542093927/16
type: Dialect
delimeter: ,
encoding: Windows-1250
header: true
quote char: "
trim: false