Stored in relational database tables within CDMS is a subset of information that could usefully be shared with the general building, civil engineering and construction industry to help promote a higher, uniform standard of quality.
This subset is described in more detail in the article Constructing an Ontology – Common Inspection and Test Plans.
The central concept is an Inspection and Test Plan (ITP) that identifies the points in a construction project when work of a specific type will be inspected and verified that it meets acceptance criteria.
An elegant way to share the Inspection and Test Plans is to publish them on the Semantic Web as an OWL ontology. The preferred way to doing this is to publish the Inspection and Test Plans as Linked Data, following the patterns outlined in the tutorial on How to publish Linked Data on the Web.
Once published as Linked Data the Inspection Test and Plans can be used by other building applications.
The process for doing this is to create an owl:ObjectProperty such as the following appliesInspectionTestPlan and add it to the OWL definition of a building project.
building:appliesInspectionTestPlan
a owl:ObjectProperty ;
rdfs:domain building:BuildingProject ;
rdfs:label “applies inspection test plan”^^xsd:string .
The example building project http://3kbo.com/examples/building4.rdf contains appliesInspectionTestPlan and applies it to the Breaker Bay building project as shown in the image below.

In the example the Inspection and Test Plan referenced is contained in a data extract published at http://3kbo.com/examples/common_itps.rdf.
The D2R Server provides an easy way to publish the actual relational database tables containing the Common Inspection and Test Plans to the Semantic Web using the patterns outlined in the tutorial on How to publish Linked Data on the Web.
The Common Inspection and Test Plans are held in a MySQL database which was created by running the command:
mysql> create database common_itps character set utf8 ;
The D2R Server is installed by following the Quick Start instructions and adding the MySQL driver JAR file to the D2R Server installation /lib directory.
The mapping file was created by running the command
./generate-mapping -o mapping_common_itps.n3 -u db-user -p db-password jdbc:mysql://localhost/common_itps
and customized by removing some unnecessary database columns from the mapping file.
Also the following was added to the mapping file to explicitly define the server host and port.
@prefix d2r: <http://sites.wiwiss.fu-berlin.de/suhl/bizer/d2r-server/config.rdf#> .
<> a d2r:Server;
rdfs:label “D2R Server”;
d2r:baseURI <http://abeserver.isa.net.au:2020/>;
d2r:port 2020;
d2r:documentMetadata [
rdfs:comment "The Common Inspection and Test Plans are currently published as an experimental version. The data needs to be rationalized and the model confirmed before progressing to a draft status.";
];
.
Once the mapping file has been generated and customized the server is started with the command:
nohup ./d2r-server mapping_common_itps.n3 &
An experimental verison of the “Common Inspection and Test Plans” can now be browsed online at http://abeserver.isa.net.au:2020/ in a web browser, ideally using Firefox with the Tabulator extension install.
Individual Inspection Test Plans can be opened directly in the browser using URLs such as http://abeserver.isa.net.au:2020/resource/inspection_test_plan/1.
Via content negotiation this request is redirected to the browser friendly page
http://abeserver.isa.net.au:2020/page/inspection_test_plan/1
The acutal RDF can be viewed directly at http://abeserver.isa.net.au:2020/data/inspection_test_plan/1.
SPARQL queries can be run using the AJAX-based SPARQL explorer http://abeserver.isa.net.au:2020/snorql/.





