Just fyi
This error was in the very short form of my issue
The actual issue of ‘no results’ was:
Having all the filters active resulted in zero items 😊
So instead of x=y we have to start constraining a bit more flex like |x-y| < X
(joining records that are close in location not exact)
In this case:
SELECT ?Specificatie ?Laag ?Meting ?bpsStartKilometrering
?bpsStartKilometrering_0
WHERE {
?Specificatie rdf:type lam:OntwerpSpecificatie .
?Specificatie lam:bpsWeg ?bpsWeg .
?Specificatie lam:mengselVoldoetAanDeEisenVoor ?mengselVoldoetAanDeEisenVoor .
?Laag rdf:type lam:MonsterLaag .
?Laag lam:bpsWeg_0 ?bpsWeg_0 .
?Laag lam:mengselType ?mengselType .
OPTIONAL { ?Laag lam:bpsStartKilometrering ?bpsStartKilometrering } .
?Meting rdf:type lam:MonitoringMeting .
?Meting lam:bpsWeg_1 ?bpsWeg_1 .
?Meting lam:surfaceOmschrijving ?surfaceOmschrijving .
OPTIONAL { ?Meting lam:bpsStartKilometrering_0 ?bpsStartKilometrering_0 } .
FILTER (?bpsWeg = ?bpsWeg_0) .
FILTER (?bpsWeg = ?bpsWeg_1) .
FILTER (?mengselVoldoetAanDeEisenVoor = ?mengselType) .
FILTER (?mengselVoldoetAanDeEisenVoor = ?surfaceOmschrijving) .
FILTER (abs(?bpsStartKilometrering - ?bpsStartKilometrering_0) < 50) .
}
This now works fine, we can choose between many less precise or less more
precise matches…
Gr Michel
From: [email protected] <[email protected]> On
Behalf Of Holger Knublauch
Sent: donderdag 6 april 2023 12:08
To: [email protected]
Subject: Re: [topbraid-users] unexpected query result
Try SELECT * - I think the variable names are spelled inconsistently.
Holger
On 6 Apr 2023, at 10:55 am, 'Bohms, H.M. (Michel)' via TopBraid Suite Users
<[email protected]<mailto:[email protected]>> wrote:
<image001.png>
What could be wrong here?
Empty bpsStartKilometring in query result….
The data is there (not always but I put ‘optional’).
Why is data like 1250 from row example being an integer not shown in query
result?
Thx for advice,
Michel
Ps
Data was imported from excel via standard tbc-import resulting in:
lam:bpsStartKilometrering
rdf:type owl:DatatypeProperty ;
tables:columnIndex "12"^^xsd:int ;
rdfs:domain lam:MonsterLaag ;
rdfs:label "bpsStartKilometrering" ;
rdfs:range xsd:integer ;
.
Michel Böhms
Data Scientist
Digital Built Environment (DBE)
Mobile +31 630381220
E-mail [email protected]<mailto:[email protected]>
Location<https://nextdelft.com/>
<image002.gif><http://www.tno.nl/>
This message may contain information that is not intended for you. If you are
not the addressee or if this message was sent to you by mistake, you are
requested to inform the sender and delete the message. TNO accepts no liability
for the content of this e-mail, for the manner in which you use it and for
damage of any kind resulting from the risks inherent to the electronic
transmission of messages.
--
The topics of this mailing list include TopBraid EDG and related technologies
such as SHACL.
To post to this group, send email to
[email protected]<mailto:[email protected]>
---
You received this message because you are subscribed to the Google Groups
"TopBraid Suite Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to
[email protected]<mailto:[email protected]>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/topbraid-users/1a28bab22eec4ef5a1d3fc6eefa03b1f%40tno.nl<https://groups.google.com/d/msgid/topbraid-users/1a28bab22eec4ef5a1d3fc6eefa03b1f%40tno.nl?utm_medium=email&utm_source=footer>.
--
The topics of this mailing list include TopBraid EDG and related technologies
such as SHACL.
To post to this group, send email to
[email protected]<mailto:[email protected]>
---
You received this message because you are subscribed to the Google Groups
"TopBraid Suite Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to
[email protected]<mailto:[email protected]>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/topbraid-users/A200C653-4E67-499B-B5E4-C79D4BA99408%40topquadrant.com<https://groups.google.com/d/msgid/topbraid-users/A200C653-4E67-499B-B5E4-C79D4BA99408%40topquadrant.com?utm_medium=email&utm_source=footer>.
--
The topics of this mailing list include TopBraid EDG and related technologies
such as SHACL.
To post to this group, send email to [email protected]
---
You received this message because you are subscribed to the Google Groups
"TopBraid Suite Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/topbraid-users/6b09d4d6b3dd4778a7d960397e2235b4%40tno.nl.
