Number of business entities registered in given months by activity
type: Pipeline
tag: consumption demo
version: 5
created: 2022-09-20T08:16:42.508
last update: 2023-06-14T15:16:13.082014081
profile: default

Files to RDF single graph
type: Component
configuration graph: configuration
template: http://etl.linkedpipes.com/resources/components/t-filesToRdfGraph/0.0.0
x: -400
y: 1441
description: Transform registration months to graph

Union
type: Component
configuration graph: configuration
template: http://etl.linkedpipes.com/resources/components/t-singleGraphUnion/0.0.0
x: 1906
y: 1562
description: Create final RDF

RDF to file
type: Component
configuration graph: configuration
template: http://etl.linkedpipes.com/resources/components/t-rdfToFile/0.0.0
x: 2179
y: 1359
description: Store output RDF in file

Text holder
type: Component
configuration graph: configuration
template: http://etl.linkedpipes.com/resources/components/e-textHolder/0.0.0
x: 736
y: 1410
description: Prepare output data structure definition

SPARQL select
type: Component
configuration graph: configuration
template: http://etl.linkedpipes.com/resources/components/t-sparqlSelect/0.0.0
x: 2202
y: 1619
description: Create output CSV file

Files to RDF single graph
type: Component
configuration graph: configuration
template: http://etl.linkedpipes.com/resources/components/t-filesToRdfGraph/0.0.0
x: 1280
y: 1425
description: Transform output data structure definition to graph

SPARQL construct
type: Component
configuration graph: configuration
template: http://etl.linkedpipes.com/resources/components/t-sparqlConstruct/0.0.0
x: 1169
y: 1210
description: Prepare configuration of output RDF file

SPARQL construct
type: Component
configuration graph: configuration
template: http://etl.linkedpipes.com/resources/components/t-sparqlConstruct/0.0.0
x: 866
y: 1552
description: Prepare output dataset definition

Text holder
type: Component
configuration graph: configuration
template: http://etl.linkedpipes.com/resources/components/e-textHolder/0.0.0
x: -785
y: 1431
description: Set registration months

https://stirdata.opendata.cz/etl/resources/pipelines/1682095059683-0005/connection/6175-b915
type: Connection
source binding: OutputRdf
source component: Files to RDF single graph
target binding: InputRdf
target component: SPARQL construct

https://stirdata.opendata.cz/etl/resources/pipelines/1682095059683-0005/connection/6d35-90c6
type: Connection
source binding: OutputRdf
source component: Union
target binding: InputRdf
target component: RDF to file

https://stirdata.opendata.cz/etl/resources/pipelines/1682095059683-0005/connection/6dc4-8660
type: Connection
source binding: OutputRdf
source component: Union
target binding: InputRdf
target component: SPARQL select

https://stirdata.opendata.cz/etl/resources/pipelines/1682095059683-0005/connection/8bfb-b78c
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/1682095059683-0005/connection/9811-85ec
type: Connection
source binding: OutputRdf
source component: SPARQL construct
target binding: Configuration
target component: RDF to file

https://stirdata.opendata.cz/etl/resources/pipelines/1682095059683-0005/connection/9e08-9180
type: Connection
source binding: OutputRdf
target binding: InputRdf

https://stirdata.opendata.cz/etl/resources/pipelines/1682095059683-0005/connection/9f45-a946
type: Connection
source binding: OutputRdf
source component: Files to RDF single graph
target binding: InputRdf
target component: Union

https://stirdata.opendata.cz/etl/resources/pipelines/1682095059683-0005/connection/a5e7-9bfd
type: Connection
source binding: OutputRdf
target binding: InputRdf
target component: Union

https://stirdata.opendata.cz/etl/resources/pipelines/1682095059683-0005/connection/d949-8a01
type: Connection
source binding: OutputRdf
source component: SPARQL construct
target binding: InputRdf

https://stirdata.opendata.cz/etl/resources/pipelines/1682095059683-0005/connection/e50b-be70
type: Connection
source binding: OutputRdf
source component: Files to RDF single graph
target binding: InputRdf
target component: SPARQL construct

https://stirdata.opendata.cz/etl/resources/pipelines/1682095059683-0005/connection/e5b6-84ae
type: Connection
source binding: OutputRdf
source component: SPARQL construct
target binding: InputRdf
target component: Union

https://stirdata.opendata.cz/etl/resources/pipelines/1682095059683-0005/connection/ee29-804d
type: Connection
source binding: OutputRdf
source component: Files to RDF single graph
target binding: InputRdf

https://stirdata.opendata.cz/etl/resources/pipelines/1682095059683-0005/connection/ee7e-b4c4
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/1682095059683-0005/connection/f1ce-8b48
type: Connection
source binding: OutputRdf
target binding: InputRdf

SPARQL construct
type: Component
configuration graph: configuration
template: http://etl.linkedpipes.com/resources/components/t-sparqlConstruct/0.0.0
x: 1326
y: 1761
description: Construct statistical observations

https://stirdata.opendata.cz/etl/resources/pipelines/1682095059683-00051682095059683-00051682090585905-00041682090585905-00041681989406323-00031681989406323-00031681989155073-00021681989155073-000204e…
type: Connection
source binding: FilesOutput
target binding: InputFiles

SPARQL endpoint - EDP
type: Component
configuration graph: configuration
disabled: true
template: http://etl.linkedpipes.com/resources/components/e-sparqlEndpoint/0.0.0
x: -410
y: 1611
description: Extract compliant endpoints from catalog

SPARQL endpoint - STIRData
type: Component
configuration graph: configuration
template: http://etl.linkedpipes.com/resources/components/e-sparqlEndpoint/0.0.0
x: -464
y: 1722
description: Extract compliant endpoints from catalog

Union
type: Component
configuration graph: configuration
template: http://etl.linkedpipes.com/resources/components/t-singleGraphUnion/0.0.0
x: -9
y: 1690

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

https://stirdata.opendata.cz/etl/resources/pipelines/1682095059683-00051682095059683-00051682090585905-00041682090585905-00041681989406323-00031681989406323-00031681989155073-00021681989155073-0002168…
type: Connection
source binding: OutputRdf
target binding: InputRdf

https://stirdata.opendata.cz/etl/resources/pipelines/1682095059683-00051682095059683-00051682090585905-00041682090585905-00041681989406323-00031681989406323-00031681989155073-00021681989155073-0002168…
type: Connection
source binding: OutputRdf
target binding: InputRdf

https://stirdata.opendata.cz/etl/resources/pipelines/1682095059683-00051682095059683-00051682090585905-00041682090585905-00041681989406323-00031681989406323-00031681989155073-00021681989155073-0002168…
type: Connection
source binding: OutputRdf
target binding: InputRdf

SPARQL endpoint list to single graph
type: Component
configuration graph: configuration
template: http://etl.linkedpipes.com/resources/components/e-sparqlEndpointList/0.0.0
x: 668
y: 1741
description: Execute query tasks to get number of registered business entities per activity

https://stirdata.opendata.cz/etl/resources/pipelines/1682095059683-00051682095059683-00051682090585905-00041682090585905-00041681989406323-00031681989406323-00031681989155073-00021681989155073-0002361…
type: Connection
source binding: OutputRdf
target binding: Tasks

SPARQL construct
type: Component
configuration graph: configuration
template: http://etl.linkedpipes.com/resources/components/t-sparqlConstruct/0.0.0
x: 151
y: 1670
description: Prepare query tasks to get number of registered business entities per activity

Text holder - only CZ
type: Component
configuration graph: configuration
disabled: true
template: http://etl.linkedpipes.com/resources/components/e-textHolder/0.0.0
x: -630
y: 1880

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

configuration
type: Configuration
file name: data.ttl
file name control: None
file type: text/turtle
file type control: None
graph uri control: None

configuration
type: Configuration
content: @prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> . @prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> . @prefix qb: <http://purl.org/linked-data/cube#> . @prefix sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#> . @prefix stirdata: <https://w3id.org/stirdata/vocabulary/statistical/> . <https://stirdata.opendata.cz/resource/dsd/number-of-business-entities-by-activity> a qb:DataStructureDefinition ; # The dimensions qb:component [ qb:dimension sdmx-dimension:refPeriod ; qb:order 1 ]; qb:component [ qb:dimension stirdata:activity ; qb:order 2 ]; qb:component [ qb:dimension stirdata:sourceBusinessEntitiesDataSet ; qb:order 3 ]; qb:component [ qb:measure stirdata:numberOfNewBusinessEntities ] . stirdata:activity a rdf:Property, qb:DimensionProperty ; rdfs:label "Activity"@en ; rdfs:comment "Activity of legal entities as a NACE code."@en . stirdata:sourceBusinessEntitiesDataSet a rdf:Property, qb:DimensionProperty ; rdfs:label "Source data set"@en ; rdfs:comment "The data set that is the source of the data about business entities used to compute the statistics."@en . stirdata:numberOfNewBusinessEntities a rdf:Property, qb:MeasureProperty ; rdfs:label "Number of new business entities"@en ; rdfs:comment "The number of newly registered business entities."@en .
content control: None
file name: dsd.ttl
file name control: None

configuration
type: Configuration
file name: table.csv
file name control: None
query: PREFIX qb: <http://purl.org/linked-data/cube#> PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/statistical/> SELECT ?sourceBusinessEntitiesDataSet ?refPeriod ?activity ?numberOfNewBusinessEntities WHERE { ?observation a qb:Observation ; qb:dataSet ?qbDataSet ; sdmx-dimension:refPeriod ?refPeriodFull ; stirdata:activity ?activity ; stirdata:sourceBusinessEntitiesDataSet ?sourceBusinessEntitiesDataSet ; stirdata:numberOfNewBusinessEntities ?numberOfNewBusinessEntities . BIND(SUBSTR(STR(?refPeriodFull), 1, 7) AS ?refPeriod) } ORDER BY ?activity ?refPeriod
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 rtf: <http://plugins.linkedpipes.com/ontology/t-rdfToFile#> PREFIX : <urn:stirdata:> CONSTRUCT { :config a rtf:Configuration ; rtf:fileName ?fileName ; rtf:fileNameControl <http://plugins.linkedpipes.com/resource/configuration/None> ; rtf:fileType "text/turtle" ; rtf:fileTypeControl <http://plugins.linkedpipes.com/resource/configuration/None> ; rtf:graphUriControl <http://plugins.linkedpipes.com/resource/configuration/None> . } WHERE { { SELECT (GROUP_CONCAT(STR(?registrationMonth); SEPARATOR="-") AS ?registrationMonths) WHERE { ?config :registrationMonth ?registrationMonthWithDay . BIND(SUBSTR(STR(?registrationMonthWithDay), 1, 7) AS ?registrationMonth) } GROUP BY ?config } BIND(CONCAT("number-of-business-entities-registered-in-", STR(?registrationMonths), "-by-activity.ttl") AS ?fileName) }
query control: None

configuration
type: Configuration
query: PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX qb: <http://purl.org/linked-data/cube#> PREFIX esl: <http://plugins.linkedpipes.com/ontology/e-sparqlEndpointList#> PREFIX : <urn:stirdata:> CONSTRUCT { ?dataSet a qb:DataSet ; rdfs:label ?label ; qb:structure <https://stirdata.opendata.cz/resource/dsd/number-of-business-entities-by-activity> . } WHERE { { SELECT (GROUP_CONCAT(STR(?registrationMonth); SEPARATOR="-") AS ?registrationMonths) (GROUP_CONCAT(STR(?registrationMonth); SEPARATOR=", ") AS ?registrationMonthsLabel) WHERE { ?config :registrationMonth ?registrationMonthWithDay . BIND(SUBSTR(STR(?registrationMonthWithDay), 1, 7) AS ?registrationMonth) } GROUP BY ?config } BIND(IRI(CONCAT("https://stirdata.opendata.cz/resource/dataset/number-of-business-entities-registered-in-", STR(?registrationMonths), "-by-activity")) AS ?dataSet) BIND(CONCAT("Number of business entities registered in ", STR(?registrationMonthsLabel), " by activity") AS ?label) }
query control: None

configuration
type: Configuration
content: @prefix xsd: <http://www.w3.org/2001/XMLSchema#> . [] <urn:stirdata:registrationMonth> "2023-04-01"^^xsd:date, "2023-05-01"^^xsd:date .
content control: None
file name: registrationMonths.ttl
file name control: None

configuration
type: Configuration
query: PREFIX qb: <http://purl.org/linked-data/cube#> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/statistical/> PREFIX : <urn:stirdata:> CONSTRUCT { ?observation a qb:Observation ; qb:dataSet ?qbDataSet ; sdmx-dimension:refPeriod ?refPeriod ; stirdata:activity ?activity ; stirdata:numberOfNewBusinessEntities ?numberOfBusinessEntities ; stirdata:sourceBusinessEntitiesDataSet ?sourceDataSet ; } WHERE { [] :activity ?activity ; :numberOfBusinessEntities ?numberOfBusinessEntities ; :refPeriod ?refPeriod ; :dataset ?sourceDataSet . ?qbDataSet a qb:DataSet . BIND(IRI(CONCAT("https://stirdata.opendata.cz/resource/observation/", STRUUID())) AS ?observation) }
query control: None

configuration
type: Configuration
default graph control: None
encode rdf: false
encode rdf control: None
endpoint: https://data.europa.eu/sparql
endpoint control: None
handle invalid data: false
handle invalid data control: None
header accept control: None
password control: None
query: PREFIX dcterms: <http://purl.org/dc/terms/> PREFIX dcat: <http://www.w3.org/ns/dcat#> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> CONSTRUCT { ?endpoint <urn:stirdata:endpoint> ?endpointString ; <urn:stirdata:dataset> ?dataset . } WHERE { ?dataset a dcat:Dataset ; dcterms:title ?title ; dcterms:conformsTo <https://stirdata.github.io/data-specification/> ; dcat:distribution/dcat:accessService ?service . ?service a dcat:DataService ; dcterms:conformsTo <https://www.w3.org/TR/sparql11-protocol/> ; dcat:endpointURL ?endpoint . FILTER(langMatches(LANG(?title), "en")) BIND(STR(?endpoint) AS ?endpointString) }
query control: None
use authentication: false
use authentication control: None
use tolerant repository: false
use tolerant repository control: None
user name control: None

configuration
type: Configuration
default graph control: None
encode rdf: false
encode rdf control: None
endpoint: https://stirdata.opendata.cz/sparql
endpoint control: None
handle invalid data: false
handle invalid data control: None
header accept control: None
password control: None
query: PREFIX dcterms: <http://purl.org/dc/terms/> PREFIX dcat: <http://www.w3.org/ns/dcat#> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> CONSTRUCT { ?endpoint <urn:stirdata:endpoint> ?endpointString ; <urn:stirdata:dataset> ?dataset . } WHERE { ?dataset a dcat:Dataset ; dcterms:title ?title ; dcterms:conformsTo <https://stirdata.github.io/data-specification/> ; dcat:distribution/dcat:accessService ?service . ?service a dcat:DataService ; dcterms:conformsTo <https://www.w3.org/TR/sparql11-protocol/> ; dcat:endpointURL ?endpoint . FILTER(langMatches(LANG(?title), "en")) BIND(STR(?endpoint) AS ?endpointString) }
query control: None
use authentication: false
use authentication control: None
use tolerant repository: false
use tolerant repository control: None
user name control: None

https://stirdata.opendata.cz/etl/resources/pipelines/1682095059683-00051682095059683-00051682090585905-00041682090585905-00041681989406323-00031681989406323-00031681989155073-00021681989155073-0002168…
type: Configuration
commit size: 50000
commit size control: None
mime type control: None
soft fail: false
soft fail control: None

configuration
type: Configuration
commit size: 0
commit size control: None
encode rdf: false
encode rdf control: None
password control: None
task per group limit: 1
task per group limit control: None
threads: 8
threads control: None
time limit: 600
time limit control: None
use authentication: false
use authentication control: None
use tolerant repository: true
use tolerant repository control: None
user name control: None

configuration
type: Configuration
query: PREFIX esl: <http://plugins.linkedpipes.com/ontology/e-sparqlEndpointList#> PREFIX : <urn:stirdata:> CONSTRUCT { ?task a esl:Task ; esl:query ?query ; esl:group ?uritext ; esl:endpoint ?uritext . } WHERE { ?s :endpoint ?uritext ; :dataset ?dataset . [] :registrationMonth ?registrationMonth . BIND(UUID() AS ?task) BIND(IRI(?uritext) as ?uri) BIND(CONCAT("""PREFIX : <urn:stirdata:> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX legal: <http://www.w3.org/ns/legal#> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> CONSTRUCT { [] :activity ?activity ; :numberOfBusinessEntities ?numberOfBusinessEntities ; :refPeriod \"""", STR(?registrationMonth), """\"^^xsd:date ; :dataset <""", STR(?dataset) ,"""> . } WHERE { { SELECT ?activity (COUNT(DISTINCT ?resource) AS ?numberOfBusinessEntities) WHERE { ?resource a legal:LegalEntity ; m8g:registrationDate ?registrationDate ; legal:companyActivity ?activity . FILTER(CONTAINS(STR(?registrationDate), \"""", SUBSTR(STR(?registrationMonth), 1, 7), """\")) } GROUP BY ?activity } }""") as ?query) }
query control: None

configuration
type: Configuration
content: <https://obchodní-rejstřík.stirdata.opendata.cz/sparql> <urn:stirdata:endpoint> "https://obchodní-rejstřík.stirdata.opendata.cz/sparql" ; <urn:stirdata:dataset> <https://stirdata.opendata.cz/resource/dataset/czechia/obchodní-rejstřík/ebg> .
content control: None
file name: file.ttl
file name control: None