Czech Business Registry to STIRData specification
type: Pipeline
version: 5
created: 2021-04-22T08:06:35.958
last update: 2023-04-18T16:25:12.778979883
profile: default

Files to local
type: Component
configuration graph: configuration
template: http://etl.linkedpipes.com/resources/components/l-filesToLocal/0.0.0
x: 1597
y: -167

Text holder
type: Component
configuration graph: configuration
template: http://etl.linkedpipes.com/resources/components/e-textHolder/0.0.0
x: 281
y: -376
description: PostCode -> LAU mapping

Tabular
type: Component
configuration graph: configuration
template: http://etl.linkedpipes.com/resources/components/t-tabular/0.0.0
x: 302
y: -309
description: CSV -> RDF transform

SPARQL endpoint
type: Component
configuration graph: configuration
disabled: true
template: http://etl.linkedpipes.com/resources/components/e-sparqlEndpoint/0.0.0
x: -53
y: -251
description: Access source RDF data via SPARQL Endpoint

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

Files from local
type: Component
configuration graph: configuration
template: http://etl.linkedpipes.com/resources/components/e-filesFromLocal/0.0.0
x: -58
y: -133
description: Access source RDF TriG dump in local file system

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

HTTP get
type: Component
configuration graph: configuration
template: http://etl.linkedpipes.com/resources/components/e-httpGetFile/0.0.0
x: 1569
y: -39
description: Ping LDF to reload

SPARQL construct
type: Component
configuration graph: configuration
template: http://etl.linkedpipes.com/resources/components/t-sparqlConstruct/0.0.0
x: 660
y: -154
description: Link Districts to NUTS-3 (VÚSC/Kraje)

Text holder
type: Component
configuration graph: configuration
template: http://etl.linkedpipes.com/resources/components/e-textHolder/0.0.0
x: 517
y: 44
description: RDF Turtle/TriG Prefixes

RDF to file
type: Component
configuration graph: configuration
template: http://etl.linkedpipes.com/resources/components/t-rdfToFile/0.0.0
x: 1127
y: -317
description: Links TriG dump

RDF to HDT
type: Component
configuration graph: configuration
template: http://etl.linkedpipes.com/resources/components/t-rdfToHdt/0.0.0
x: 1288
y: -157
description: Produce HDT dump

SPARQL construct
type: Component
configuration graph: configuration
template: http://etl.linkedpipes.com/resources/components/t-sparqlConstruct/0.0.0
x: 676
y: -311
description: Link PostCode to LAU

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

SPARQL construct
type: Component
configuration graph: configuration
template: http://etl.linkedpipes.com/resources/components/t-sparqlConstruct/0.0.0
x: 274
y: -135
description: Transform from source RDF shape to STIRData specification

Files to RDF single graph
type: Component
configuration graph: configuration
template: http://etl.linkedpipes.com/resources/components/t-filesToRdfGraph/0.0.0
x: -57
y: -28
description: Load RDF into memory

SPARQL construct
type: Component
configuration graph: configuration
template: http://etl.linkedpipes.com/resources/components/t-sparqlConstruct/0.0.0
x: 333
y: -35
description: Now and the rest of metadata

RDF to file
type: Component
configuration graph: configuration
template: http://etl.linkedpipes.com/resources/components/t-rdfToFile/0.0.0
x: 1080
y: 45
description: STIRData compliant TriG dump

https://stirdata.opendata.cz/etl/resources/pipelines/1619071595958/connection/196f-91c8
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/1619071595958/connection/2e4d-8f13
type: Connection
source binding: OutputRdf
source component: SPARQL construct
target binding: InputRdf
target component: Union

https://stirdata.opendata.cz/etl/resources/pipelines/1619071595958/connection/32da-a9e7
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/1619071595958/connection/43c1-9006
type: Connection
source binding: OutputFile
source component: RDF to file
target binding: FilesInput
target component: Files to local

https://stirdata.opendata.cz/etl/resources/pipelines/1619071595958/connection/44c6-9e24
type: Connection
source binding: OutputRdf
source component: SPARQL construct
target binding: InputRdf
target component: RDF to file

https://stirdata.opendata.cz/etl/resources/pipelines/1619071595958/connection/4bb5-a915
type: Connection
source binding: OutputRdf
source component: SPARQL endpoint
target binding: InputRdf
target component: SPARQL construct

https://stirdata.opendata.cz/etl/resources/pipelines/1619071595958/connection/5749-b9f1
type: Connection
source binding: OutputRdf
source component: SPARQL construct
target binding: InputRdf
target component: Union

https://stirdata.opendata.cz/etl/resources/pipelines/1619071595958/connection/6202-af45
type: Connection
source binding: FilesOutput
source component: Files from local
target binding: InputFiles
target component: Files to RDF single graph

https://stirdata.opendata.cz/etl/resources/pipelines/1619071595958/connection/66ee-9228
type: Connection
source binding: OutputRdf
source component: SPARQL construct
target binding: InputRdf
target component: RDF to file

https://stirdata.opendata.cz/etl/resources/pipelines/1619071595958/connection/68c2-975c
type: Connection
source binding: OutputRdf
source component: SPARQL construct
target binding: InputRdf
target component: Union

https://stirdata.opendata.cz/etl/resources/pipelines/1619071595958/connection/69b9-8985
type: Connection
source binding: FilesOutput
source component: Text holder
target binding: InputFiles
target component: Tabular

https://stirdata.opendata.cz/etl/resources/pipelines/1619071595958/connection/6c30-8860
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/1619071595958/connection/a5f6-a4e4
type: Connection
source binding: OutputRdf
source component: SPARQL construct
target binding: InputRdf
target component: SPARQL construct

https://stirdata.opendata.cz/etl/resources/pipelines/1619071595958/connection/a661-9fae
type: Connection
source binding: OutputFile
source component: RDF to file
target binding: FilesInput
target component: Files to local

https://stirdata.opendata.cz/etl/resources/pipelines/1619071595958/connection/ad4e-b6af
type: Connection
source binding: OutputRdf
source component: Tabular
target binding: InputRdf
target component: SPARQL construct

https://stirdata.opendata.cz/etl/resources/pipelines/1619071595958/connection/b783-a8be
type: Connection
source binding: OutputFiles
source component: RDF to HDT
target binding: FilesInput
target component: Files to local

https://stirdata.opendata.cz/etl/resources/pipelines/1619071595958/connection/bbf9-85d6
type: Connection
source binding: OutputRdf
source component: Union
target binding: InputRdf
target component: RDF to file

https://stirdata.opendata.cz/etl/resources/pipelines/1619071595958/connection/c4d6-b54d
type: Connection
source binding: OutputRdf
source component: SPARQL construct
target binding: InputRdf
target component: Union

https://stirdata.opendata.cz/etl/resources/pipelines/1619071595958/connection/c622-a919
type: Connection
source binding: OutputRdf
source component: SPARQL construct
target binding: InputRdf
target component: Union

https://stirdata.opendata.cz/etl/resources/pipelines/1619071595958/connection/d948-8760
type: Connection
source binding: OutputRdf
source component: SPARQL construct
target binding: InputRdf
target component: SPARQL construct

https://stirdata.opendata.cz/etl/resources/pipelines/1619071595958/connection/f7fd-b19b
type: Connection
source binding: OutputRdf
source component: Union
target binding: InputRdf
target component: Union

https://stirdata.opendata.cz/etl/resources/pipelines/1619071595958/connection/f96f-b0a6
type: Connection
source binding: OutputRdf
source component: Union
target binding: InputRdf
target component: RDF to HDT

configuration
type: Configuration
path: /data/www/soubor
path control: None

configuration
type: Configuration
content: X,Y,OBJECTID,POSTCODE,CNTR_ID,PC_CNTR,NUTS3_2021,CODE,GISCO_ID_2,NSI_CODE_2,LAT_NAT,LAU_LATIN,COASTAL,CITY_ID,GREATER_CI,FUA_ID,DGURBA 15.831384298999978,49.42037417099999,32595,588 25,CZ,CZ_588 25,'CZ063','588 25',CZ_587265,587265,Jersin,,NO,,,CZ014L2,3 15.779748760000018,49.367128072000014,32596,588 23,CZ,CZ_588 23,'CZ063','588 23',CZ_587346,587346,Kamenice,,NO,,,CZ014L2,3 16.542874083000015,49.16024788499999,32597,664 49,CZ,CZ_664 49,'CZ064','664 49',CZ_583596,583596,Ostopovice,,NO,,,CZ002L2,2 16.723125440999979,49.190094710999972,32598,664 03,CZ,CZ_664 03,'CZ064','664 03',CZ_583634,583634,Podoli,,NO,,,CZ002L2,2 15.562253462,49.139443672000027,32599,588 65,CZ,CZ_588 65,'CZ063','588 65',CZ_587591,587591,Nova Rise,,NO,,,,3 16.550597412,49.071928556999978,32600,664 67,CZ,CZ_664 67,'CZ064','664 67',CZ_583936,583936,Syrovice,,NO,,,CZ002L2,3 16.493560181000021,49.169986096,32601,664 41,CZ,CZ_664 41,'CZ064','664 41',CZ_584029,584029,Troubsko,,NO,,,CZ002L2,2 16.750643453,49.100641413,32602,664 53,CZ,CZ_664 53,'CZ064','664 53',CZ_584045,584045,Ujezd u Brna,,NO,,,CZ002L2,3 15.400822138000024,49.351148793999982,32603,588 44,CZ,CZ_588 44,'CZ063','588 44',CZ_587796,587796,Rohozna,,NO,,,CZ014L2,3 16.605308001000026,49.009962769000026,32604,664 63,CZ,CZ_664 63,'CZ064','664 63',CZ_584231,584231,Zabcice,,NO,,,CZ002L2,2 15.592959881000013,49.1824911,32605,588 67,CZ,CZ_588 67,'CZ063','588 67',CZ_587923,587923,Stara Rise,,NO,,,,3 16.723896368,49.57926731399999,32606,679 38,CZ,CZ_679 38,'CZ064','679 38',CZ_581470,581470,Cetkovice,,NO,,,,3 16.417420452999977,49.489849928000012,32607,679 75,CZ,CZ_679 75,'CZ064','679 75',CZ_581500,581500,Cernovice,,NO,,,,3 16.07325118599999,49.056896785999982,32608,675 57,CZ,CZ_675 57,'CZ063','675 57',CZ_591441,591441,Presovice,,NO,,,,3 16.261795398,49.524793896,32609,593 01,CZ,CZ_593 01,'CZ063','593 01',CZ_595411,595411,Bystrice nad Pernstejnem,,NO,,,,2 16.00131076299999,49.069544984,32610,675 59,CZ,CZ_675 59,'CZ063','675 59',CZ_591548,591548,Radkovice…
content control: None
file name: psc2csv.csv
file name control: None

http://etl.linkedpipes.com/resources/components/t-tabular/0.0.0/new/1
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: dialect
table schema: schema

dialect
type: Dialect
delimeter: ,
encoding: UTF-8
header: true
quote char: "
trim: false

configuration
type: Configuration
default graph: obchodní-rejstřík
default graph control: None
encode rdf: false
encode rdf control: None
endpoint: http://localhost:3030/cz-br/query
endpoint control: None
handle invalid data: false
handle invalid data control: None
header accept control: None
password control: None
query: CONSTRUCT WHERE { ?s ?p ?o }
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
path: /data/www/soubor/or.trig
path control: None

configuration
type: Configuration
encode url: false
encode url control: None
file name: ldf.php
file name control: None
file uri: http://localhost/deploy/ldf.php
file uri control: None
hard redirect: false
hard redirect control: None
user agent control: None
utf8 redirect: false
utf8 redirect control: None

configuration
type: Configuration
query: PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX schema: <http://schema.org/> PREFIX ebg: <http://data.businessgraph.io/ontology#> PREFIX ruian: <https://linked.cuzk.cz/ontology/ruian/> PREFIX ruianTP: <https://linked.cuzk.cz/ontology/ruian/TypPrvku/> PREFIX locn: <http://www.w3.org/ns/locn#> PREFIX ruianSPARQL: <https://linked.cuzk.cz.opendata.cz/sparql> CONSTRUCT { ?a ebg:adminUnitL4 ?newnuts ; m8g:adminUnit ?newnuts . ?newnuts a m8g:AdminUnit ; m8g:code ?newnuts ; m8g:level <https://w3id.org/stirdata/resource/adminUnitLevel/NUTS-3> . } WHERE { { ?a a locn:Address; locn:adminUnitL2 ?okres . SERVICE ruianSPARQL: { ?b a ruianTP:OK ; schema:name ?okres ; ruian:vúsc/ruian:nuts ?nuts . } } UNION { ?a a locn:Address; locn:postName ?mp . SERVICE ruianSPARQL: { ?x a ruianTP:MP ; schema:name ?mp . } BIND( <http://nuts.geovocab.org/id/CZ010> as ?nuts ) } UNION { ?a a locn:Address; locn:postName ?mp . SERVICE ruianSPARQL: { ?x a ruianTP:MC ; schema:name ?mp ; ruian:obec/ruian:okres/ruian:vúsc/ruian:nuts ?nuts } } BIND(IRI(CONCAT("http://data.europa.eu/nuts/code/",STRAFTER(STR(?nuts), "http://nuts.geovocab.org/id/"))) as ?newnuts) }
query control: None

configuration
type: Configuration
content: @prefix regorg: <http://www.w3.org/ns/regorg#> . @prefix adms: <http://www.w3.org/ns/adms#> . @prefix locn: <http://www.w3.org/ns/locn#> . @prefix org: <http://www.w3.org/ns/org#> . @prefix dbo: <http://dbpedia.org/ontology/> . @prefix schema: <http://schema.org/> . @prefix schema-s: <https://schema.org/> .
content control: None
file name: prefixes.ttl
file name control: None

configuration
type: Configuration
file name: or-ebg-nuts.trig
file name control: None
file type: application/trig
file type control: None
graph uri: https://obchodní-rejstřík.stirdata.opendata.cz/ebg/nuts
graph uri control: None

configuration
type: Configuration
base iri: http://localhost/base
base iri control: None
file name: or.hdt
file name control: None

configuration
type: Configuration
query: PREFIX locn: <http://www.w3.org/ns/locn#> PREFIX schema: <http://schema.org/> PREFIX ebg: <http://data.businessgraph.io/ontology#> PREFIX m8g: <http://data.europa.eu/m8g/> CONSTRUCT { ?a <https://w3id.org/stirdata/vocabulary/lau> ?lau ; m8g:adminUnit ?lau . ?lau a m8g:AdminUnit ; m8g:code ?lau ; m8g:level <https://w3id.org/stirdata/resource/adminUnitLevel/LAU> . } WHERE { [] <urn:POSTCODE> ?pc ; <urn:NSI_CODE_2> ?lauCode . BIND(REPLACE(?pc, " ","") AS ?normalizedPostCode) ?a a locn:Address; locn:postCode ?normalizedPostCode . BIND(IRI(CONCAT("https://w3id.org/stirdata/resource/lau/item/CZ_",?lauCode)) AS ?lau) }
query control: None

http://etl.linkedpipes.com/resources/components/t-filesToRdfGraph/0.0.0/new/1
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 m8g: <http://data.europa.eu/m8g/> PREFIX locn: <http://www.w3.org/ns/locn#> PREFIX legal: <http://www.w3.org/ns/legal#> PREFIX adms: <http://www.w3.org/ns/adms#> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX org: <http://www.w3.org/ns/org#> PREFIX schema: <https://schema.org/> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX vr: <https://slovník.gov.cz/legislativní/sbírka/304/2013/pojem/> PREFIX ok: <https://slovník.gov.cz/legislativní/sbírka/90/2012/pojem/> PREFIX oz: <https://slovník.gov.cz/legislativní/sbírka/89/2012/pojem/> PREFIX zr: <https://slovník.gov.cz/legislativní/sbírka/111/2009/pojem/> PREFIX or: <https://slovník.gov.cz/datový/obchodní-rejstřík/pojem/> CONSTRUCT { ?osoba a legal:LegalEntity ; legal:legalName ?název ; legal:legalIdentifier ?reg ; legal:companyType ?forma_mezinárodní ; schema:foundingDate ?datum_zapsání ; schema:dissolutionDate ?výmaz ; org:hasSite ?sídlo ; # agreed upon redundancy org:hasRegisteredSite ?sídlo ; m8g:registeredAddress ?adresa_sídla . ?sídlo a org:Site ; org:siteAddress ?adresa_sídla . ?adresa_sídla a locn:Address ; locn:addressArea ?část_obce ; locn:postCode ?psč ; locn:thoroughfare ?název_ulice ; locn:locatorDesignator ?číslo_popisné, ?číslo_orientační ; locn:postName ?název_obce ; locn:adminUnitL1 ?název_státu ; locn:adminUnitL2 ?název_okresu ; m8g:adminUnit ?country . ?country a m8g:AdminUnit ; m8g:code ?country ; m8g:level <https://w3id.org/stirdata/resource/adminLevel/Country> . ?reg a adms:Identifier ; skos:notation ?ičo . } WHERE { ?osoba vr:má-právní-formu-právnické-osoby ?forma_or ; vr:identifikační-číslo-osoby ?ičo ; ok:firma-obchodní-korporace ?název ; vr:má-sídlo-zapsané-osoby ?sídlo ; schema:validFrom ?datum_zapsání . ?sídlo oz:má-adresu ?adresa_sídla . OPTIONAL { ?osoba schema:validThrough ?výmaz . } OPTIONAL { ?adresa_sídla zr:má-název-části-obce ?část_obce . } OPTIONAL { ?adresa_sídla zr:má-název-ulice ?název_ulice . } OPTIONAL { ?adresa_sídla or:má-poštovní-směrovací-číslo ?psč . …
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 dcterms: <http://purl.org/dc/terms/> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/> CONSTRUCT { <https://obchodní-rejstřík.stirdata.opendata.cz/stirdata> dcterms:modified ?update ; dcterms:spatial <http://publications.europa.eu/resource/authority/country/CZE> ; stirdata:naceDataset <http://data.europa.eu/88u/dataset/https-lkod-mff-cuni-cz-zdroj-datove-sady-stirdata-cz-nace-stirdata> ; #stirdata:naceDataset <https://data.gov.cz/zdroj/datové-sady/00216208/03c70bed41ee7397c72b6daeba9257a4> ; dcterms:source <https://dataor.justice.cz> . <https://dataor.justice.cz> dcterms:license <https://dataor.justice.cz/files/ISVR_OpenData_Podminky_uziti.pdf> . } WHERE { BIND(STRDT(STR(NOW()),xsd:dateTimeStamp) AS ?update) }
query control: None

configuration
type: Configuration
file name: or-ebg.trig
file name control: None
file type: application/trig
file type control: None
graph uri: https://obchodní-rejstřík.stirdata.opendata.cz/stirdata
graph uri control: None