EKGF Ontologies / Raw Data Ontology

EKGF Editor's Draft

Raw Data Ontology

EKGF Editor's Draft

1. Raw Data Ontology§

1.1 Overview§

Raw Data Ontology

IdentifierValue
Ontology IRI / Namespacehttps://ekgf.org/ontology/raw#
Prefixekg-raw

The Raw Data Ontology is used by a "capture step" in an EKG DataOps pipeline to capture any data from any data source as RDF triples without mapping it to higher level ontologies. It is assumed that subsequent steps in a given EKG DataOps pipeline will transform the raw data to match with target ontologies.

1.2 Classes§

1.2.1 Column§

A physical field position in exactly one captured raw-data view, linked through isColumnInView or inverse hasColumn. Its identity is independent of its mapped predicate; source metadata and optional statistics describe the column.

ekg-raw:Column
https://ekgf.org/ontology/raw#Column
RDF predicateValue
dc:creatorhttp://orcid.org/0000-0003-2309-5068
dc:date
rdf:typeowl:Class
rdfs:labelColumn
rdfs:subClassOf(rdf:type: owl:Restriction; owl:minCardinality: 1; owl:onProperty: ekg-raw:isColumnInView)
UML class diagram for Column. Diagram labels: «owl:Class»; Column; 25th percentile : xsd:double; Median : xsd:double; 75th percentile : xsd:double; Column number : xsd:integer; Conforming value count : xsd:integer; 25th percentile rdfs:domain Column. 25th percentile rdfs:range xsd:double. Median rdfs:domain Column. Median rdfs:range xsd:double. 75th percentile rdfs:domain Column. 75th percentile rdfs:range xsd:double. Column number rdfs:domain Column. Column number rdfs:range xsd:integer. Conforming value count rdfs:domain Column. Conforming value count rdfs:range xsd:integer.«owl:Class»Column25th percentile : xsd:doubleMedian : xsd:double75th percentile : xsd:doubleColumn number : xsd:integerConforming value count : xsd:integer
Class neighborhood: Column [1]

1.2.2 CSV file§

A raw-data file source in comma-separated values format (RFC 4180). Every field is captured as text; the capture step does not infer datatypes.

ekg-raw:CsvFile
https://ekgf.org/ontology/raw#CsvFile
RDF predicateValue
rdf:typeowl:Class
rdfs:labelCSV file
rdfs:subClassOfekg-raw:File
UML class diagram for CSV file. Diagram labels: «owl:Class»; CSV file; «owl:Class»; File; CSV file rdfs:subClassOf File.«owl:Class»CSV file«owl:Class»File
Class neighborhood: CSV file [1]

1.2.3 File§

A file used as a raw-data source during the capture step of a DataOps pipeline.

ekg-raw:File
https://ekgf.org/ontology/raw#File
RDF predicateValue
dc:creatorhttp://orcid.org/0000-0003-2309-5068
dc:date
rdf:typeowl:Class
rdfs:labelFile
rdfs:subClassOfekg-raw:Source
UML class diagram for File. Diagram labels: «owl:Class»; CSV file; «owl:Class»; File; «owl:Class»; Parquet file; «owl:Class»; Source; «owl:Class»; TSV file; «owl:Class»; XLSX file; CSV file rdfs:subClassOf File. Parquet file rdfs:subClassOf File. File rdfs:subClassOf Source. TSV file rdfs:subClassOf File. XLSX file rdfs:subClassOf File.«owl:Class»CSV file«owl:Class»File«owl:Class»Parquet file«owl:Class»Source«owl:Class»TSV file«owl:Class»XLSX file
Class neighborhood: File [1]

1.2.4 Null value§

A captured value occurrence whose source explicitly reports null. It has no literalValue. Missing content metadata and empty strings do not imply this classification; the source reader must identify the null according to the source format or an explicit capture policy.

ekg-raw:NullValue
https://ekgf.org/ontology/raw#NullValue
RDF predicateValue
rdf:typeowl:Class
rdfs:labelNull value
rdfs:subClassOfekg-raw:Value
rdfs:subClassOf(rdf:type: owl:Restriction; owl:maxCardinality: 0; owl:onProperty: ekg-raw:literalValue)
UML class diagram for Null value. Diagram labels: «Literal value»; 0; «OWL expression»; Anonymous OWL expression; 1; «owl:Class»; Column; «owl:Class»; Null value; «owl:Class»; Row; «owl:Class»; Value; Source text : xsd:string [0..1]; «Datatype property»; Literal value; For column; 1..1; Value of; 1..1; rdfs:; subClassOf; owl:; maxCardinality; owl:; onProperty; Null value rdfs:subClassOf Value. Null value rdfs:subClassOf Anonymous OWL expression 1. Anonymous OWL expression 1 owl:maxCardinality 0. Anonymous OWL expression 1 owl:onProperty Literal value.«Literal value»0«OWL expression»Anonymous OWL expression1«owl:Class»Column«owl:Class»Null value«owl:Class»Row«owl:Class»ValueSource text : xsd:string [0..1]«Datatype property»Literal valueFor column1..1Value of1..1rdfs:subClassOfowl:maxCardinalityowl:onProperty
Class neighborhood: Null value [1]

1.2.5 Parquet file§

A raw-data file source in the Apache Parquet columnar format. One file is one view whose columns are the schema's top-level fields; values keep the literal datatypes that the file's physical and logical types define.

ekg-raw:ParquetFile
https://ekgf.org/ontology/raw#ParquetFile
RDF predicateValue
rdf:typeowl:Class
rdfs:labelParquet file
rdfs:subClassOfekg-raw:File
UML class diagram for Parquet file. Diagram labels: «owl:Class»; File; «owl:Class»; Parquet file; Parquet file rdfs:subClassOf File.«owl:Class»File«owl:Class»Parquet file
Class neighborhood: Parquet file [1]

1.2.6 Row§

A record encountered in exactly one raw-data view, retaining its source identifier, sequence position, and captured value occurrences. Each occurrence identifies this row through valueOf and its physical source column through forColumn.

ekg-raw:Row
https://ekgf.org/ontology/raw#Row
RDF predicateValue
dc:creatorhttp://orcid.org/0000-0003-2309-5068
dc:date
rdf:typeowl:Class
rdfs:labelRow
rdfs:subClassOf(rdf:type: owl:Restriction; owl:minCardinality: 1; owl:onProperty: ekg-raw:isRowInView)
UML class diagram for Row. Diagram labels: «Literal value»; 1; «OWL expression»; Anonymous OWL expression; 1; «owl:Class»; Column; «owl:Class»; Row; Legacy ID : xsd:string; View Row Number : xsd:integer; «owl:Class»; Value; Source text : xsd:string [0..1]; «owl:Class»; View; «Object property»; Is Row In View; Value of; 1..1; Is Row In View; 1..1; For column; 1..1; rdfs:; domain; rdfs:; range; rdfs:; subClassOf; owl:; minCardinality; owl:; onProperty; Is Row In View rdfs:domain Row. Is Row In View rdfs:range View. Legacy ID rdfs:domain Row. Legacy ID rdfs:range xsd:string. Value of rdfs:domain Value. Value of rdfs:range Row. View Row Number rdfs:domain Row. View Row Number rdfs:range xsd:integer. Row rdfs:subClassOf Anonymous OWL expression 1. Anonymous OWL expression 1 owl:minCardinality 1. Anonymous OWL expression 1 owl:onProperty Is Row In View.«Literal value»1«OWL expression»Anonymous OWL expression1«owl:Class»Column«owl:Class»RowLegacy ID : xsd:stringView Row Number : xsd:integer«owl:Class»ValueSource text : xsd:string [0..1]«owl:Class»View«Object property»Is Row In ViewValue of1..1Is Row In View1..1For column1..1rdfs:domainrdfs:rangerdfs:subClassOfowl:minCardinalityowl:onProperty
Class neighborhood: Row [1]

1.2.7 Source§

An input data source captured as RDF before transformation into higher-level domain ontologies. A source may expose several views.

ekg-raw:Source
https://ekgf.org/ontology/raw#Source
RDF predicateValue
dc:creatorhttp://orcid.org/0000-0003-2309-5068
dc:date
rdf:typeowl:Class
rdfs:labelSource
UML class diagram for Source. Diagram labels: «owl:Class»; File; «owl:Class»; Source; «owl:Class»; View; Has View; Is View In; File rdfs:subClassOf Source. Has View rdfs:domain Source. Has View rdfs:range View. Is View In rdfs:domain View. Is View In rdfs:range Source.«owl:Class»File«owl:Class»Source«owl:Class»ViewHas ViewIs View In
Class neighborhood: Source [1]

1.2.8 TSV file§

A raw-data file source in tab-separated values format. Every field is captured as text; the capture step does not infer datatypes.

ekg-raw:TsvFile
https://ekgf.org/ontology/raw#TsvFile
RDF predicateValue
rdf:typeowl:Class
rdfs:labelTSV file
rdfs:subClassOfekg-raw:File
UML class diagram for TSV file. Diagram labels: «owl:Class»; File; «owl:Class»; TSV file; TSV file rdfs:subClassOf File.«owl:Class»File«owl:Class»TSV file
Class neighborhood: TSV file [1]

1.2.9 Value§

Value identifies an occurrence of source data. Its literalValue contains the source-supplied content as an RDF literal, retaining the available datatype or language. Text stays text when the source supplies no type; the capture step must not guess that a string such as "00123" denotes a number. Domain-specific interpretation belongs to later transformation steps.

Use sourceText when the reader exposes an original textual representation. For example, literal content 7 and source text "0007" preserve both the source-supplied numeric value and its textual spelling. Do not fabricate source text by formatting a parsed value. This field records reader-exposed text, not the source file's bytes, quoting, or complete spreadsheet formatting.

An empty string, whitespace, zero, and false are values. Explicit source nulls use NullValue and have no literalValue. A null may retain its source marker in sourceText. Missing payload metadata is invalid, not an implicit null. No string, including "NULL", becomes null without the source format or an explicit capture policy establishing that interpretation. An omitted source field is not automatically an explicit null occurrence.

ValueContentShape, in this ontology's shapes graph, checks this contract. OWL models the alternatives and cardinalities; it does not supply missing content or classify an incomplete occurrence as null.

Migration and scope

Existing Value resources need their captured content or an explicit NullValue classification. Preserve their identities and references. Recover content from the original source or the capture application's documented representation; do not infer content from resource IRIs or reinterpret a mapped row property as an occurrence without establishing the correspondence.

Each occurrence also requires one valueOf row and one forColumn column. Rows identify their one view through isRowInView; columns identify theirs through isColumnInView or inverse hasColumn. The two views must match. ValueLocationShape, RowLocationShape, and ColumnLocationShape validate these relationships and belong to the same shapes graph.

Recover column links from the source's physical structure or documented capture metadata. Do not join occurrences to columns by mapped predicate alone: different columns can share a mapping, including columns in different views. Validate the supplied capture context before OWL identity reasoning; functional relationships can equate conflicting owner IRIs rather than rejecting them.

Original headers and view names, view-to-source ownership validation, coordinate constraints, mapping-property semantics, and source-key identity remain separate modeling work.

See the raw-data guide for executable examples, validation, and the remaining work.

ekg-raw:Value
https://ekgf.org/ontology/raw#Value
RDF predicateValue
dc:creatorhttp://orcid.org/0000-0003-2309-5068
dc:date
rdf:typeowl:Class
rdfs:labelValue
rdfs:subClassOf(rdf:type: owl:Class; owl:unionOf: (ekg-raw:NullValue, (rdf:type: owl:Restriction; owl:minCardinality: 1; owl:onProperty: ekg-raw:literalValue)))
rdfs:subClassOf(rdf:type: owl:Restriction; owl:minCardinality: 1; owl:onProperty: ekg-raw:forColumn)
rdfs:subClassOf(rdf:type: owl:Restriction; owl:minCardinality: 1; owl:onProperty: ekg-raw:valueOf)
UML class diagram for Value. Diagram labels: «owl:Class»; Column; «owl:Class»; Null value; «owl:Class»; Row; «owl:Class»; Value; For Predicate; Formula : xsd:string; Literal value : rdfs:Literal; Source text : xsd:string [0..1]; For column; 1..1; Value of; 1..1; Null value rdfs:subClassOf Value. For column rdfs:domain Value. For column rdfs:range Column. For Predicate rdfs:domain Value. Formula rdfs:domain Value. Formula rdfs:range xsd:string. Literal value rdfs:domain Value. Literal value rdfs:range rdfs:Literal.«owl:Class»Column«owl:Class»Null value«owl:Class»Row«owl:Class»ValueFor PredicateFormula : xsd:stringLiteral value : rdfs:LiteralSource text : xsd:string [0..1]For column1..1Value of1..1
Class neighborhood: Value [1]

1.2.10 View§

A tabular or record-oriented view within a captured source, organizing the rows and columns exposed by that source.

ekg-raw:View
https://ekgf.org/ontology/raw#View
RDF predicateValue
dc:creatorhttp://orcid.org/0000-0003-2309-5068
dc:date
rdf:typeowl:Class
rdfs:labelView
UML class diagram for View. Diagram labels: «owl:Class»; Column; «owl:Class»; Row; «owl:Class»; Source; «owl:Class»; View; Has column; Has View; Is column in view; Is Row In View; 1..1; Is View In; Has column rdfs:domain View. Has column rdfs:range Column. Has View rdfs:domain Source. Has View rdfs:range View. Is column in view rdfs:domain Column. Is column in view rdfs:range View. Is Row In View rdfs:domain Row. Is Row In View rdfs:range View. Is View In rdfs:domain View. Is View In rdfs:range Source.«owl:Class»Column«owl:Class»Row«owl:Class»Source«owl:Class»ViewHas columnHas ViewIs column in viewIs Row In View1..1Is View In
Class neighborhood: View [1]

1.2.11 XLSX file§

A raw-data file source in the Excel XLSX workbook format.

ekg-raw:XlsxFile
https://ekgf.org/ontology/raw#XlsxFile
RDF predicateValue
dc:creatorhttp://orcid.org/0000-0003-2309-5068
dc:date
rdf:typeowl:Class
rdfs:labelXLSX file
rdfs:subClassOfekg-raw:File
UML class diagram for XLSX file. Diagram labels: «owl:Class»; File; «owl:Class»; XLSX file; XLSX file rdfs:subClassOf File.«owl:Class»File«owl:Class»XLSX file
Class neighborhood: XLSX file [1]

1.3 Properties§

1.3.1 25th percentile§

The 25th percentile of the numeric values of occurrences conforming to a numeric inferred datatype, interpolating linearly between the closest ranks (Hyndman and Fan type 7).

ekg-raw:25pct
https://ekgf.org/ontology/raw#25pct
RDF predicateValue
rdf:typeowl:DatatypeProperty
rdf:typeowl:FunctionalProperty
rdfs:domainekg-raw:Column
rdfs:label25th percentile
rdfs:rangexsd:double

1.3.2 Median§

The 50th percentile (median) of the numeric values of occurrences conforming to a numeric inferred datatype, interpolating linearly between the closest ranks (Hyndman and Fan type 7).

ekg-raw:50pct
https://ekgf.org/ontology/raw#50pct
RDF predicateValue
rdf:typeowl:DatatypeProperty
rdf:typeowl:FunctionalProperty
rdfs:domainekg-raw:Column
rdfs:labelMedian
rdfs:rangexsd:double

1.3.3 75th percentile§

The 75th percentile of the numeric values of occurrences conforming to a numeric inferred datatype, interpolating linearly between the closest ranks (Hyndman and Fan type 7).

ekg-raw:75pct
https://ekgf.org/ontology/raw#75pct
RDF predicateValue
rdf:typeowl:DatatypeProperty
rdf:typeowl:FunctionalProperty
rdfs:domainekg-raw:Column
rdfs:label75th percentile
rdfs:rangexsd:double

1.3.4 Column number§

1-based column index

ekg-raw:columnNumber
https://ekgf.org/ontology/raw#columnNumber
RDF predicateValue
dc:creatorhttp://orcid.org/0000-0003-2309-5068
dc:date
rdf:typeowl:DatatypeProperty
rdf:typeowl:FunctionalProperty
rdfs:domainekg-raw:Column
rdfs:labelColumn number
rdfs:rangexsd:integer

1.3.5 Conforming value count§

The number of counted occurrences of this column conforming to its inferred datatype. Together with count it gives the share of the column that a later step can cast to that datatype, and identifies how many occurrences need attention.

ekg-raw:conformingCount
https://ekgf.org/ontology/raw#conformingCount
RDF predicateValue
rdf:typeowl:DatatypeProperty
rdf:typeowl:FunctionalProperty
rdfs:domainekg-raw:Column
rdfs:labelConforming value count
rdfs:rangexsd:integer

1.3.6 Value count§

The number of captured value occurrences for this column (raw:forColumn) that are not NullValue. Header cells are not occurrences and are not counted.

ekg-raw:count
https://ekgf.org/ontology/raw#count
RDF predicateValue
rdf:typeowl:DatatypeProperty
rdf:typeowl:FunctionalProperty
rdfs:domainekg-raw:Column
rdfs:labelValue count
rdfs:rangexsd:integer

1.3.7 File name§

The name of the file as it was passed to the capture step

ekg-raw:fileName
https://ekgf.org/ontology/raw#fileName
RDF predicateValue
dc:creatorhttp://orcid.org/0000-0003-2309-5068
dc:date
rdf:typeowl:DatatypeProperty
rdf:typeowl:FunctionalProperty
rdfs:domainekg-raw:File
rdfs:labelFile name
rdfs:rangexsd:string

1.3.8 For column§

Identifies the physical source column of a captured value occurrence. Each occurrence has exactly one column, belonging to the same view as its row. A shared predicate mapping does not establish column identity.

ekg-raw:forColumn
https://ekgf.org/ontology/raw#forColumn
RDF predicateValue
rdf:typeowl:FunctionalProperty
rdf:typeowl:ObjectProperty
rdfs:domainekg-raw:Value
rdfs:labelFor column
rdfs:rangeekg-raw:Column

1.3.9 For Predicate§

The predicate for which the given value was encountered

ekg-raw:forPredicate
https://ekgf.org/ontology/raw#forPredicate
RDF predicateValue
dc:creatorhttp://orcid.org/0000-0003-2309-5068
dc:date
rdf:typeowl:ObjectProperty
rdfs:domainekg-raw:Value
rdfs:labelFor Predicate

1.3.10 Formula§

The spreadsheet formula that computes a captured value occurrence, verbatim in the source's A1 notation and without the leading '='. The value's literalValue is the result the source cached; an occurrence without a cached result is a NullValue that still records its formula.

ekg-raw:formula
https://ekgf.org/ontology/raw#formula
RDF predicateValue
rdf:typeowl:DatatypeProperty
rdf:typeowl:FunctionalProperty
rdfs:domainekg-raw:Value
rdfs:labelFormula
rdfs:rangexsd:string

1.3.11 Formula (R1C1)§

A spreadsheet formula in R1C1 notation, with references relative to the cell holding it. On a Value it is that occurrence's formula. On a Column it is the single relative formula shared by every formula occurrence in the column, a derivation rule for the column that later steps can translate into SPARQL or SHACL rules.

ekg-raw:formulaR1C1
https://ekgf.org/ontology/raw#formulaR1C1
RDF predicateValue
rdf:typeowl:DatatypeProperty
rdfs:domain(rdf:type: owl:Class; owl:unionOf: (ekg-raw:Value, ekg-raw:Column))
rdfs:labelFormula (R1C1)
rdfs:rangexsd:string

1.3.12 Most frequent value count§

The number of counted occurrences whose literalValue is the column's top value.

ekg-raw:freq
https://ekgf.org/ontology/raw#freq
RDF predicateValue
rdf:typeowl:DatatypeProperty
rdf:typeowl:FunctionalProperty
rdfs:domainekg-raw:Column
rdfs:labelMost frequent value count
rdfs:rangexsd:integer

1.3.13 Git blob§

The git blob object id, as lowercase hexadecimal, of the captured bytes. It is computed from the content alone, so it is present whether or not the file is in a repository, and equals the id git would assign to the same bytes.

ekg-raw:gitBlob
https://ekgf.org/ontology/raw#gitBlob
RDF predicateValue
rdf:typeowl:DatatypeProperty
rdf:typeowl:FunctionalProperty
rdfs:domainekg-raw:File
rdfs:labelGit blob
rdfs:rangexsd:string

1.3.14 Git commit§

The object id, as lowercase hexadecimal, of the HEAD commit of the repository whose work tree contained the file at capture time. Together with gitPath it locates the file in history; gitModified states whether the captured bytes are the bytes of that commit.

ekg-raw:gitCommit
https://ekgf.org/ontology/raw#gitCommit
RDF predicateValue
rdf:typeowl:DatatypeProperty
rdf:typeowl:FunctionalProperty
rdfs:domainekg-raw:File
rdfs:labelGit commit
rdfs:rangexsd:string

1.3.15 Git modified§

Whether the captured bytes differ from the file at gitPath in gitCommit. True also when the file is untracked in that commit. False means the capture is reproducible from the repository history.

ekg-raw:gitModified
https://ekgf.org/ontology/raw#gitModified
RDF predicateValue
rdf:typeowl:DatatypeProperty
rdf:typeowl:FunctionalProperty
rdfs:domainekg-raw:File
rdfs:labelGit modified
rdfs:rangexsd:boolean

1.3.16 Git path§

The path of the file relative to the root of the repository work tree, using '/' as separator, as git records it.

ekg-raw:gitPath
https://ekgf.org/ontology/raw#gitPath
RDF predicateValue
rdf:typeowl:DatatypeProperty
rdf:typeowl:FunctionalProperty
rdfs:domainekg-raw:File
rdfs:labelGit path
rdfs:rangexsd:string

1.3.17 Git repository§

The fetch URL of the default remote of the git repository whose work tree contained the file at capture time, recorded verbatim. Scp-style remotes such as git@host:org/repo.git are not IRIs, so the URL is a string.

ekg-raw:gitRepository
https://ekgf.org/ontology/raw#gitRepository
RDF predicateValue
rdf:typeowl:DatatypeProperty
rdf:typeowl:FunctionalProperty
rdfs:domainekg-raw:File
rdfs:labelGit repository
rdfs:rangexsd:string

1.3.18 Has column§

Lists a view's physical source columns. A view can contain multiple columns; each column belongs to exactly one view. Columns sharing a mapped predicate retain separate identities.

ekg-raw:hasColumn
https://ekgf.org/ontology/raw#hasColumn
RDF predicateValue
rdf:typeowl:InverseFunctionalProperty
rdf:typeowl:ObjectProperty
rdfs:domainekg-raw:View
rdfs:labelHas column
rdfs:rangeekg-raw:Column
owl:inverseOfekg-raw:isColumnInView

1.3.19 Has View§

One Source can have multiple Views

ekg-raw:hasView
https://ekgf.org/ontology/raw#hasView
RDF predicateValue
dc:creatorhttp://orcid.org/0000-0003-2309-5068
dc:date
rdf:typeowl:InverseFunctionalProperty
rdf:typeowl:ObjectProperty
rdfs:domainekg-raw:Source
rdfs:labelHas View
rdfs:rangeekg-raw:View
owl:inverseOfekg-raw:isViewIn

1.3.20 Inferred datatype§

A datatype to which conformingCount of the column's counted occurrences conform: their literalValue has this datatype, or its lexical form is valid for it. Which datatypes are considered and what share of conforming occurrences is required are capture policy; conformingCount records the evidence. Captured values keep their source literals.

ekg-raw:inferredDatatype
https://ekgf.org/ontology/raw#inferredDatatype
RDF predicateValue
rdf:typeowl:FunctionalProperty
rdf:typeowl:ObjectProperty
rdfs:domainekg-raw:Column
rdfs:labelInferred datatype
rdfs:rangerdfs:Datatype

1.3.21 Is column in view§

Identifies the one view containing a physical source column; inverse of hasColumn. Assert either direction or both consistently. Reusing a mapped property does not reuse the column across views.

ekg-raw:isColumnInView
https://ekgf.org/ontology/raw#isColumnInView
RDF predicateValue
rdf:typeowl:FunctionalProperty
rdf:typeowl:ObjectProperty
rdfs:domainekg-raw:Column
rdfs:labelIs column in view
rdfs:rangeekg-raw:View

1.3.22 Is Row In View§

The current row occurs in the given view.

ekg-raw:isRowInView
https://ekgf.org/ontology/raw#isRowInView
RDF predicateValue
dc:creatorhttp://orcid.org/0000-0003-2309-5068
dc:date
rdf:typeowl:FunctionalProperty
rdf:typeowl:ObjectProperty
rdfs:domainekg-raw:Row
rdfs:labelIs Row In View
rdfs:rangeekg-raw:View

1.3.23 Is View In§

This View occurs in the given Source

ekg-raw:isViewIn
https://ekgf.org/ontology/raw#isViewIn
RDF predicateValue
dc:creatorhttp://orcid.org/0000-0003-2309-5068
dc:date
rdf:typeowl:FunctionalProperty
rdf:typeowl:ObjectProperty
rdfs:domainekg-raw:View
rdfs:labelIs View In
rdfs:rangeekg-raw:Source

1.3.24 Legacy ID§

The values in the key-column in the given view will always be mapped to raw:legacyId

ekg-raw:legacyId
https://ekgf.org/ontology/raw#legacyId
RDF predicateValue
dc:creatorhttp://orcid.org/0000-0003-2309-5068
dc:date
rdf:typeowl:DatatypeProperty
rdf:typeowl:FunctionalProperty
rdfs:domainekg-raw:Row
rdfs:labelLegacy ID
rdfs:rangexsd:string

1.3.25 Legacy Id In Iri§

The value of legacyId translated to an IRI-compliant lower kebab-case value

ekg-raw:legacyIdInIri
https://ekgf.org/ontology/raw#legacyIdInIri
RDF predicateValue
dc:creatorhttp://orcid.org/0000-0003-2309-5068
dc:date
rdf:typeowl:DatatypeProperty
rdf:typeowl:FunctionalProperty
rdfs:labelLegacy Id In Iri

1.3.26 Literal value§

The source-supplied content of a captured value occurrence, represented as one RDF literal with its datatype or language retained. An empty string is content; a source null is represented by NullValue without this property.

ekg-raw:literalValue
https://ekgf.org/ontology/raw#literalValue
RDF predicateValue
rdf:typeowl:DatatypeProperty
rdf:typeowl:FunctionalProperty
rdfs:domainekg-raw:Value
rdfs:labelLiteral value
rdfs:rangerdfs:Literal

1.3.27 Local name§

The local name of the property that this Column is mapped to

ekg-raw:localName
https://ekgf.org/ontology/raw#localName
RDF predicateValue
dc:creatorhttp://orcid.org/0000-0003-2309-5068
dc:date
rdf:typeowl:DatatypeProperty
rdf:typeowl:FunctionalProperty
rdfs:domainekg-raw:Column
rdfs:labelLocal name
rdfs:rangexsd:string

1.3.28 Maximum§

The greatest value, in the value space of the inferred datatype, among occurrences conforming to it, written as a literal of that datatype.

ekg-raw:max
https://ekgf.org/ontology/raw#max
RDF predicateValue
rdf:typeowl:DatatypeProperty
rdf:typeowl:FunctionalProperty
rdfs:domainekg-raw:Column
rdfs:labelMaximum
rdfs:rangerdfs:Literal

1.3.29 Mean§

The arithmetic mean of the numeric values of occurrences conforming to a numeric inferred datatype.

ekg-raw:mean
https://ekgf.org/ontology/raw#mean
RDF predicateValue
rdf:typeowl:DatatypeProperty
rdf:typeowl:FunctionalProperty
rdfs:domainekg-raw:Column
rdfs:labelMean
rdfs:rangexsd:double

1.3.30 Minimum§

The least value, in the value space of the inferred datatype, among occurrences conforming to it, written as a literal of that datatype.

ekg-raw:min
https://ekgf.org/ontology/raw#min
RDF predicateValue
rdf:typeowl:DatatypeProperty
rdf:typeowl:FunctionalProperty
rdfs:domainekg-raw:Column
rdfs:labelMinimum
rdfs:rangerdfs:Literal

1.3.31 Null count§

The number of captured value occurrences for this column that are NullValue.

ekg-raw:nullCount
https://ekgf.org/ontology/raw#nullCount
RDF predicateValue
rdf:typeowl:DatatypeProperty
rdf:typeowl:FunctionalProperty
rdfs:domainekg-raw:Column
rdfs:labelNull count
rdfs:rangexsd:integer

1.3.32 Predicate§

The property that this Column is mapped to. A column is mapped to one property. It is an annotation property because its values are properties, which are not individuals.

ekg-raw:predicate
https://ekgf.org/ontology/raw#predicate
RDF predicateValue
dc:creatorhttp://orcid.org/0000-0003-2309-5068
dc:date
rdf:typeowl:AnnotationProperty
rdfs:domainekg-raw:Column
rdfs:labelPredicate
rdfs:rangerdf:Property

1.3.33 Source text§

The original text of a captured value as exposed by the source reader before value normalization, when such text is available. This optional string preserves lexical details independently of literalValue and may record a source's explicit null marker.

ekg-raw:sourceText
https://ekgf.org/ontology/raw#sourceText
RDF predicateValue
rdf:typeowl:DatatypeProperty
rdf:typeowl:FunctionalProperty
rdfs:domainekg-raw:Value
rdfs:labelSource text
rdfs:rangexsd:string

1.3.34 Standard deviation§

The sample standard deviation (divisor n - 1) of the numeric values of occurrences conforming to a numeric inferred datatype.

ekg-raw:std
https://ekgf.org/ontology/raw#std
RDF predicateValue
rdf:typeowl:DatatypeProperty
rdf:typeowl:FunctionalProperty
rdfs:domainekg-raw:Column
rdfs:labelStandard deviation
rdfs:rangexsd:double

1.3.35 Most frequent value§

A literalValue occurring most often among the counted occurrences. When several occur equally often, the one whose N-Triples form sorts first by code point.

ekg-raw:top
https://ekgf.org/ontology/raw#top
RDF predicateValue
rdf:typeowl:DatatypeProperty
rdf:typeowl:FunctionalProperty
rdfs:domainekg-raw:Column
rdfs:labelMost frequent value
rdfs:rangerdfs:Literal

1.3.36 Distinct value count§

The number of distinct RDF terms among the literalValue of the counted occurrences; literals with different datatypes or language tags are distinct. Absence means the measure was not computed, not that there are no values.

ekg-raw:unique
https://ekgf.org/ontology/raw#unique
RDF predicateValue
rdf:typeowl:DatatypeProperty
rdf:typeowl:FunctionalProperty
rdfs:domainekg-raw:Column
rdfs:labelDistinct value count
rdfs:rangexsd:integer

1.3.37 Value of§

Identifies the one source row at which a value occurrence was captured. The row and the occurrence's forColumn must belong to the same view.

ekg-raw:valueOf
https://ekgf.org/ontology/raw#valueOf
RDF predicateValue
dc:creatorhttp://orcid.org/0000-0003-2309-5068
dc:date
rdf:typeowl:FunctionalProperty
rdf:typeowl:ObjectProperty
rdfs:domainekg-raw:Value
rdfs:labelValue of
rdfs:rangeekg-raw:Row

1.3.38 View number§

The 1-based position of a view within its source in the order the source exposes its views, such as the worksheet order of a workbook. A view name is not a stable substitute: names can repeat across sources and change between captures.

ekg-raw:viewNumber
https://ekgf.org/ontology/raw#viewNumber
RDF predicateValue
rdf:typeowl:DatatypeProperty
rdf:typeowl:FunctionalProperty
rdfs:domainekg-raw:View
rdfs:labelView number
rdfs:rangexsd:integer

1.3.39 View Row Number§

The 0-based sequence number of the Row in the given View as it was encountered in the Source

ekg-raw:viewRowNumber
https://ekgf.org/ontology/raw#viewRowNumber
RDF predicateValue
dc:creatorhttp://orcid.org/0000-0003-2309-5068
dc:date
rdf:typeowl:DatatypeProperty
rdf:typeowl:FunctionalProperty
rdfs:domainekg-raw:Row
rdfs:labelView Row Number
rdfs:rangexsd:integer

1.4 Shapes§

1.4.1 Column Location Shape§

Requires each physical source column to belong to one resource view. Counts both membership directions without requiring OWL inverse inference, and covers subclasses and untyped link endpoints.

ekg-raw:ColumnLocationShape
https://ekgf.org/ontology/raw#ColumnLocationShape
RDF predicateValue
rdf:typesh:NodeShape
rdfs:labelColumn Location Shape
sh:nodeKindsh:BlankNodeOrIRI
sh:property(sh:class: ekg-raw:View; sh:maxCount: 1; sh:message: A physical source column must belong to exactly one view, counting isColumnInView and inverse hasColumn together.; sh:minCount: 1; sh:nodeKind: sh:BlankNodeOrIRI; sh:path: (sh:alternativePath: (ekg-raw:isColumnInView, (sh:inversePath: ekg-raw:hasColumn))))
sh:targetClassekg-raw:Column
sh:targetObjectsOfekg-raw:forColumn
sh:targetObjectsOfekg-raw:hasColumn
sh:targetSubjectsOfekg-raw:isColumnInView

1.4.2 Column Profile Shape§

Validates a column profile: single-valued measures with precise datatypes, counts bounded by the value count, an inferred datatype together with its evidence, statistics only with an inferred datatype, and ordered extremes and percentiles.

ekg-raw:ColumnProfileShape
https://ekgf.org/ontology/raw#ColumnProfileShape
RDF predicateValue
rdf:typesh:NodeShape
rdfs:labelColumn Profile Shape
sh:classekg-raw:Column
sh:property(sh:datatype: xsd:integer; sh:maxCount: 1; sh:minInclusive: 0; sh:path: ekg-raw:freq)
sh:property(sh:maxCount: 1; sh:nodeKind: sh:IRI; sh:path: ekg-raw:inferredDatatype)
sh:property(sh:datatype: xsd:integer; sh:maxCount: 1; sh:minInclusive: 0; sh:path: ekg-raw:unique)
sh:property(sh:maxCount: 1; sh:nodeKind: sh:Literal; sh:path: ekg-raw:max)
sh:property(sh:maxCount: 1; sh:nodeKind: sh:Literal; sh:path: ekg-raw:min)
sh:property(sh:datatype: xsd:double; sh:maxCount: 1; sh:path: ekg-raw:75pct)
sh:property(sh:datatype: xsd:double; sh:maxCount: 1; sh:path: ekg-raw:std)
sh:property(sh:datatype: xsd:double; sh:maxCount: 1; sh:path: ekg-raw:mean)
sh:property(sh:datatype: xsd:integer; sh:maxCount: 1; sh:minInclusive: 0; sh:path: ekg-raw:conformingCount)
sh:property(sh:maxCount: 1; sh:nodeKind: sh:Literal; sh:path: ekg-raw:top)
sh:property(sh:datatype: xsd:double; sh:maxCount: 1; sh:path: ekg-raw:25pct)
sh:property(sh:datatype: xsd:integer; sh:maxCount: 1; sh:minInclusive: 0; sh:path: ekg-raw:nullCount)
sh:property(sh:datatype: xsd:integer; sh:maxCount: 1; sh:minInclusive: 0; sh:path: ekg-raw:count)
sh:property(sh:datatype: xsd:double; sh:maxCount: 1; sh:path: ekg-raw:50pct)
sh:sparql(sh:message: inferredDatatype and conformingCount are stated together.; sh:select: SPARQL SELECT query 1)
sh:sparql(sh:message: min, 25pct, 50pct, 75pct and max must be in non-decreasing order.; sh:select: SPARQL SELECT query 2)
sh:sparql(sh:message: min, max, mean, std and percentiles describe conforming values and require an inferredDatatype.; sh:select: SPARQL SELECT query 3)
sh:sparql(sh:message: top and freq are stated together.; sh:select: SPARQL SELECT query 4)
sh:sparql(sh:message: unique, freq and conformingCount cannot exceed count.; sh:select: SPARQL SELECT query 5)
sh:targetSubjectsOfekg-raw:25pct
sh:targetSubjectsOfekg-raw:50pct
sh:targetSubjectsOfekg-raw:75pct
sh:targetSubjectsOfekg-raw:conformingCount
sh:targetSubjectsOfekg-raw:count
sh:targetSubjectsOfekg-raw:freq
sh:targetSubjectsOfekg-raw:inferredDatatype
sh:targetSubjectsOfekg-raw:max
sh:targetSubjectsOfekg-raw:mean
sh:targetSubjectsOfekg-raw:min
sh:targetSubjectsOfekg-raw:nullCount
sh:targetSubjectsOfekg-raw:std
sh:targetSubjectsOfekg-raw:top
sh:targetSubjectsOfekg-raw:unique
1.4.2.1 SPARQL query 1§

inferredDatatype and conformingCount are stated together.

SELECT $this WHERE {
    { $this <https://ekgf.org/ontology/raw#inferredDatatype> ?t FILTER NOT EXISTS { $this <https://ekgf.org/ontology/raw#conformingCount> ?c } }
    UNION
    { $this <https://ekgf.org/ontology/raw#conformingCount> ?c FILTER NOT EXISTS { $this <https://ekgf.org/ontology/raw#inferredDatatype> ?t } }
}
1.4.2.2 SPARQL query 2§

min, 25pct, 50pct, 75pct and max must be in non-decreasing order.

SELECT $this WHERE {
    { $this <https://ekgf.org/ontology/raw#min> ?a ; <https://ekgf.org/ontology/raw#25pct> ?b }
    UNION
    { $this <https://ekgf.org/ontology/raw#25pct> ?a ; <https://ekgf.org/ontology/raw#50pct> ?b }
    UNION
    { $this <https://ekgf.org/ontology/raw#50pct> ?a ; <https://ekgf.org/ontology/raw#75pct> ?b }
    UNION
    { $this <https://ekgf.org/ontology/raw#75pct> ?a ; <https://ekgf.org/ontology/raw#max> ?b }
    UNION
    { $this <https://ekgf.org/ontology/raw#min> ?a ; <https://ekgf.org/ontology/raw#max> ?b }
    FILTER (?b < ?a)
}
1.4.2.3 SPARQL query 3§

min, max, mean, std and percentiles describe conforming values and require an inferredDatatype.

SELECT $this WHERE {
    $this <https://ekgf.org/ontology/raw#min>|<https://ekgf.org/ontology/raw#max>|<https://ekgf.org/ontology/raw#mean>|<https://ekgf.org/ontology/raw#std>|<https://ekgf.org/ontology/raw#25pct>|<https://ekgf.org/ontology/raw#50pct>|<https://ekgf.org/ontology/raw#75pct> ?stat .
    FILTER NOT EXISTS { $this <https://ekgf.org/ontology/raw#inferredDatatype> ?t }
}
1.4.2.4 SPARQL query 4§

top and freq are stated together.

SELECT $this WHERE {
    { $this <https://ekgf.org/ontology/raw#top> ?t FILTER NOT EXISTS { $this <https://ekgf.org/ontology/raw#freq> ?f } }
    UNION
    { $this <https://ekgf.org/ontology/raw#freq> ?f FILTER NOT EXISTS { $this <https://ekgf.org/ontology/raw#top> ?t } }
}
1.4.2.5 SPARQL query 5§

unique, freq and conformingCount cannot exceed count.

SELECT $this WHERE {
    $this <https://ekgf.org/ontology/raw#count> ?count .
    $this <https://ekgf.org/ontology/raw#unique>|<https://ekgf.org/ontology/raw#freq>|<https://ekgf.org/ontology/raw#conformingCount> ?part .
    FILTER (?part > ?count)
}

1.4.3 Formula R1C1 Shape§

Validates relative R1C1 formulas on value occurrences and the single shared derivation rule of a column.

ekg-raw:FormulaR1C1Shape
https://ekgf.org/ontology/raw#FormulaR1C1Shape
RDF predicateValue
rdf:typesh:NodeShape
rdfs:labelFormula R1C1 Shape
sh:messageformulaR1C1 belongs to a captured value occurrence or to a column whose formulas share one relative form.
sh:or((sh:class: ekg-raw:Value), (sh:class: ekg-raw:Column))
sh:property(sh:datatype: xsd:string; sh:maxCount: 1; sh:message: A value or column has at most one relative R1C1 formula, a string.; sh:path: ekg-raw:formulaR1C1)
sh:targetSubjectsOfekg-raw:formulaR1C1

1.4.4 Formula Shape§

Validates verbatim spreadsheet formulas on captured value occurrences.

ekg-raw:FormulaShape
https://ekgf.org/ontology/raw#FormulaShape
RDF predicateValue
rdf:typesh:NodeShape
rdfs:labelFormula Shape
sh:classekg-raw:Value
sh:property(sh:datatype: xsd:string; sh:maxCount: 1; sh:message: A value has at most one formula: a non-empty string in A1 notation without the leading '='.; sh:path: ekg-raw:formula; sh:pattern: ^[^=])
sh:targetSubjectsOfekg-raw:formula

1.4.5 Git Origin Shape§

Validates the git provenance of a captured file: object id syntax, a relative path, and that a commit is always accompanied by the path and modification state needed to reproduce the capture.

ekg-raw:GitOriginShape
https://ekgf.org/ontology/raw#GitOriginShape
RDF predicateValue
rdf:typesh:NodeShape
rdfs:labelGit Origin Shape
sh:messageA file in a repository records gitCommit, gitPath and gitModified together; gitRepository requires them. gitBlob alone is valid outside a repository.
sh:or((sh:property: (sh:maxCount: 0; sh:path: ekg-raw:gitRepository); sh:property: (sh:maxCount: 0; sh:path: ekg-raw:gitPath); sh:property: (sh:maxCount: 0; sh:path: ekg-raw:gitModified); sh:property: (sh:maxCount: 0; sh:path: ekg-raw:gitCommit)), (sh:property: (sh:minCount: 1; sh:path: ekg-raw:gitPath); sh:property: (sh:minCount: 1; sh:path: ekg-raw:gitCommit); sh:property: (sh:minCount: 1; sh:path: ekg-raw:gitModified)))
sh:property(sh:datatype: xsd:string; sh:maxCount: 1; sh:message: gitBlob is one lowercase hexadecimal SHA-1 or SHA-256 object id.; sh:path: ekg-raw:gitBlob; sh:pattern: ^([0-9a-f]{40}|[0-9a-f]{64})$)
sh:property(sh:datatype: xsd:string; sh:maxCount: 1; sh:message: gitCommit is one lowercase hexadecimal SHA-1 or SHA-256 object id.; sh:path: ekg-raw:gitCommit; sh:pattern: ^([0-9a-f]{40}|[0-9a-f]{64})$)
sh:property(sh:datatype: xsd:string; sh:maxCount: 1; sh:message: gitPath is one work-tree-relative path using '/' separators.; sh:path: ekg-raw:gitPath; sh:pattern: ^[^/\\][^\\]*$)
sh:property(sh:datatype: xsd:string; sh:maxCount: 1; sh:path: ekg-raw:gitRepository)
sh:property(sh:datatype: xsd:boolean; sh:maxCount: 1; sh:path: ekg-raw:gitModified)
sh:targetSubjectsOfekg-raw:gitBlob
sh:targetSubjectsOfekg-raw:gitCommit
sh:targetSubjectsOfekg-raw:gitModified
sh:targetSubjectsOfekg-raw:gitPath
sh:targetSubjectsOfekg-raw:gitRepository

1.4.6 Row Location Shape§

Requires each supplied source row to identify one resource view, including subclasses and untyped row-link endpoints. Coordinate bounds and view-to-source ownership are separate constraints.

ekg-raw:RowLocationShape
https://ekgf.org/ontology/raw#RowLocationShape
RDF predicateValue
rdf:typesh:NodeShape
rdfs:labelRow Location Shape
sh:nodeKindsh:BlankNodeOrIRI
sh:property(sh:class: ekg-raw:View; sh:maxCount: 1; sh:message: A source row must belong to exactly one view through isRowInView.; sh:minCount: 1; sh:nodeKind: sh:BlankNodeOrIRI; sh:path: ekg-raw:isRowInView)
sh:targetClassekg-raw:Row
sh:targetObjectsOfekg-raw:valueOf
sh:targetSubjectsOfekg-raw:isRowInView

1.4.7 Value Content Shape§

Validates the content of raw value occurrences, including subclasses and untyped resources using capture properties. Accepts typed and language-tagged literals and empty strings, distinguishes explicit source nulls, and checks optional original source text. Location constraints are enforced separately by ValueLocationShape, RowLocationShape, and ColumnLocationShape.

ekg-raw:ValueContentShape
https://ekgf.org/ontology/raw#ValueContentShape
RDF predicateValue
rdf:typesh:NodeShape
rdfs:labelValue Content Shape
sh:messageA captured value must have exactly one literalValue or be explicitly typed NullValue without a literalValue. Source text alone does not supply the content.
sh:nodeKindsh:BlankNodeOrIRI
sh:property(sh:datatype: xsd:string; sh:maxCount: 1; sh:path: ekg-raw:sourceText)
sh:targetClassekg-raw:Value
sh:targetSubjectsOfekg-raw:forColumn
sh:targetSubjectsOfekg-raw:forPredicate
sh:targetSubjectsOfekg-raw:literalValue
sh:targetSubjectsOfekg-raw:sourceText
sh:targetSubjectsOfekg-raw:valueOf
sh:xone((sh:class: ekg-raw:NullValue; sh:property: (sh:maxCount: 0; sh:path: ekg-raw:literalValue)), (sh:not: (sh:class: ekg-raw:NullValue); sh:property: (sh:maxCount: 1; sh:minCount: 1; sh:nodeKind: sh:Literal; sh:path: ekg-raw:literalValue)))

1.4.8 Value Location Shape§

Requires one resource row and one resource column for each captured value, including nulls, and rejects row/column view mismatches. Predicate mappings cannot substitute for physical column links.

ekg-raw:ValueLocationShape
https://ekgf.org/ontology/raw#ValueLocationShape
RDF predicateValue
rdf:typesh:NodeShape
rdfs:labelValue Location Shape
sh:nodeKindsh:BlankNodeOrIRI
sh:property(sh:class: ekg-raw:Column; sh:maxCount: 1; sh:message: A captured value must identify exactly one physical source column through forColumn.; sh:minCount: 1; sh:nodeKind: sh:BlankNodeOrIRI; sh:path: ekg-raw:forColumn)
sh:property(sh:class: ekg-raw:Row; sh:maxCount: 1; sh:message: A captured value must identify exactly one source row through valueOf.; sh:minCount: 1; sh:nodeKind: sh:BlankNodeOrIRI; sh:path: ekg-raw:valueOf)
sh:sparql(sh:message: A captured value's row and column must belong to the same view.; sh:select: SPARQL SELECT query 1)
sh:targetClassekg-raw:Value
sh:targetSubjectsOfekg-raw:forColumn
sh:targetSubjectsOfekg-raw:forPredicate
sh:targetSubjectsOfekg-raw:literalValue
sh:targetSubjectsOfekg-raw:sourceText
sh:targetSubjectsOfekg-raw:valueOf
1.4.8.1 SPARQL query 1§

A captured value's row and column must belong to the same view.

SELECT $this WHERE {
    $this <https://ekgf.org/ontology/raw#valueOf>/<https://ekgf.org/ontology/raw#isRowInView> ?rowView .
    $this <https://ekgf.org/ontology/raw#forColumn>/(<https://ekgf.org/ontology/raw#isColumnInView>|^<https://ekgf.org/ontology/raw#hasColumn>) ?columnView .
    FILTER (?rowView != ?columnView)
}

1.4.9 View Number Shape§

Validates the 1-based position of a view within its source.

ekg-raw:ViewNumberShape
https://ekgf.org/ontology/raw#ViewNumberShape
RDF predicateValue
rdf:typesh:NodeShape
rdfs:labelView Number Shape
sh:property(sh:datatype: xsd:integer; sh:maxCount: 1; sh:message: A view has at most one viewNumber, a positive xsd:integer.; sh:minInclusive: 1; sh:path: ekg-raw:viewNumber)
sh:targetSubjectsOfekg-raw:viewNumber

Document provenance

Search this specification