
@prefix map: <http://www.opensourceprojects.eu/p/timbus/context-population/extractors/d2rq/ci/786382cb0ebe0c342d323178f0476125c8c44902/tree/mappings/gestBarragens2sensorDSO.ttl?format=raw#> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix d2rq: <http://www.wiwiss.fu-berlin.de/suhl/bizer/D2RQ/0.1#> .
@prefix d2r: <http://sites.wiwiss.fu-berlin.de/suhl/bizer/d2r-server/config.rdf#> .
@prefix meta: <http://www4.wiwiss.fu-berlin.de/bizer/d2r-server/metadata#> .
@prefix jdbc: <http://d2rq.org/terms/jdbc/> .

@prefix sensor: <http://timbus.teco.edu/ontologies/DSOs/sensors.owl#> .

<> a d2r:Server;
  d2r:baseURI <http://timbus.teco.edu/sensors>;
  rdfs:label "Gest Barragens SensorDSO Instance";

  d2r:port 2020;
  d2r:vocabularyIncludeInstances true;
  
  d2r:sparqlTimeout 0;
  d2r:pageTimeout 0;

  meta:datasetTitle "WP8 Use Case Instance - Internal Use Only!";
  meta:datasetDescription "SensorDSO instance of LNEC Damn Management System" ;
  meta:datasetSource "Gest Barragens Oracle DB" ;
  
...
  meta:operatorHomepage  "http://timbusproject.net/";
  .
 

map:database a d2rq:Database;
  d2rq:jdbcDriver "oracle.jdbc.driver.OracleDriver"; # database driver, e.g. jdbc for Oracle
  d2rq:jdbcDSN "jdbc:oracle:thin:@XXX/XXX"; # database host adress and service name
  d2rq:username "XXX"; # username
  d2rq:password "XXX"; # passwort
    jdbc:keepAlive "3600";          # sends noop-query every 3600 seconds
#   jdbc:keepAliveQuery "SELECT 1";     # optional custom noop-query
    .

 
 
# Table EXTRESISTENCIA
map:Sensor a d2rq:ClassMap;
    d2rq:dataStorage map:database;
    d2rq:uriPattern "Sensor/@@EXTRESISTENCIA.ID@@";
    d2rq:class sensor:Sensor;
    .
    
    
map:Sensor_ID a d2rq:PropertyBridge;
    d2rq:belongsToClassMap map:Sensor;
    d2rq:property sensor:hasIdentifier;
    d2rq:column "EXTRESISTENCIA.ID";
    .   
    
    
map:Sensor_AcquisitionRatePerYear a d2rq:PropertyBridge;
    d2rq:belongsToClassMap map:Sensor;
    d2rq:property sensor:hasAcquisitionRatePerYear;
    d2rq:column "EXTRESISTENCIA.FREQLEITURA";
    .

    
map:Sensor_Dam a d2rq:PropertyBridge;
    d2rq:belongsToClassMap map:Sensor;
    d2rq:property sensor:hasLocation;
    d2rq:refersToClassMap map:Dam;
    d2rq:join "EXTRESISTENCIA.GRUPOID => EXTRESISTENCIAGRUPO.ID";
    d2rq:join "OBRA.ID <= EXTRESISTENCIAGRUPO.OBRA";
    .   

    
map:Sensor_GeoLocation a d2rq:PropertyBridge;
    d2rq:belongsToClassMap map:Sensor;
    d2rq:property sensor:hasLocation;
    d2rq:refersToClassMap map:GeoLocation;
    d2rq:join "EXTRESISTENCIA.GRUPOID = EXTRESISTENCIAGRUPO.ID";
    .   


#map:Sensor_SensorType a d2rq:PropertyBridge;
#   d2rq:belongsToClassMap map:Sensor;
#   d2rq:property sensor:hasType;
#   d2rq:refersToClassMap map:SensorType;
#   d2rq:join "EXTRESISTENCIA => EXTRESISTENCIALEIT.INTRUMENTO";
#   d2rq:join "INSTRMETADATAEN.INTRUMENTO <= EXTRESISTENCIALEIT.INSTRFIXO";
#   .   


#todo: look for a way to create an inverse property for this
map:Sensor_Reading a d2rq:PropertyBridge;
    d2rq:belongsToClassMap map:Sensor;
    d2rq:property sensor:hasReading;
    d2rq:refersToClassMap map:Readings;
    d2rq:join "EXTRESISTENCIALEIT.INSTRFIXO = EXTRESISTENCIA.ID";
    .
    

map:GeoLocation a d2rq:ClassMap;
    d2rq:dataStorage map:database;
  d2rq:uriPattern "GeoLocation/@@EXTRESISTENCIAGRUPO.ID@@/";
    d2rq:class sensor:GeoLocation;
    .

map:GeoLocation_Z a d2rq:PropertyBridge;
  d2rq:belongsToClassMap map:GeoLocation;
  d2rq:property sensor:hasZCoordinate;
  d2rq:column "EXTRESISTENCIAGRUPO.Z";    
  .
  
map:GeoLocation_Y a d2rq:PropertyBridge;
  d2rq:belongsToClassMap map:GeoLocation;
  d2rq:property sensor:hasYCoordinate;
  d2rq:column "EXTRESISTENCIAGRUPO.Y";    
  .
  
map:GeoLocation_X a d2rq:PropertyBridge;
    d2rq:belongsToClassMap map:GeoLocation;
    d2rq:property sensor:hasXCoordinate;
    d2rq:column "EXTRESISTENCIAGRUPO.X";    












    .
    
    

#Table INSTRMETADATAEN
#map:SensorType a d2rq:ClassMap;
#   d2rq:dataStorage map:database;
#   d2rq:uriPattern "SensorType/@@INSTRMETADATAEN.ID@@";
#   d2rq:class sensor:SensorType;
#   .

#map:SensorType_Name a d2rq:PropertyBridge;
#   d2rq:belongsToClassMap map:SensorType;
#   d2rq:property sensor:hasName;
#   d2rq:column "INSTRMETADATAEN.INSTRUMENTO";
#   .   
    

# Table "Quantity" ???

...
    
    
# Table LEITURA
map:Readings a d2rq:ClassMap;
    d2rq:dataStorage map:database;
    d2rq:uriPattern "Readings/@@EXTRESISTENCIALEIT.ID@@";
    d2rq:class sensor:Reading;
    .
    
map:Readings_ID a d2rq:PropertyBridge;
    d2rq:belongsToClassMap map:Readings;
    d2rq:property sensor:hasIdentifier;
    d2rq:column "EXTRESISTENCIALEIT.ID";
    .
    
#map:Readings_Sensor a d2rq:PropertyBridge;
#   d2rq:belongsToClassMap map:Readings;
#   d2rq:property sensor:isReadingOf;
#   d2rq:refersToClassMap map:Sensor;
#   d2rq:join "EXTRESISTENCIALEIT.INSTRFIXO = EXTRESISTENCIA.ID";
#   .
    
map:Readings_Campaign a d2rq:PropertyBridge;
    d2rq:belongsToClassMap map:Readings;
    d2rq:property sensor:hasCampaign;
    d2rq:refersToClassMap map:Campaign;
    d2rq:join "EXTRESISTENCIALEIT.CAMPANHA = CAMPANHAOBSERVACOES.ID";
    .
    
    
map:Readings_Date a d2rq:PropertyBridge;
    d2rq:belongsToClassMap map:Readings;
    d2rq:property sensor:hasDate;
    d2rq:column "EXTRESISTENCIALEIT.DATALEIT";
  .

  
# RawReading  
map:RawReading a d2rq:ClassMap;
  d2rq:dataStorage map:database;
  d2rq:uriPattern "Readings/@@EXTRESISTENCIALEIT.ID@@/RawReading/";
  d2rq:class sensor:Quantity;
    . 


map:Reading_RawReading a d2rq:PropertyBridge;
    d2rq:belongsToClassMap map:Readings;
    d2rq:property sensor:hasRawReading;
    d2rq:refersToClassMap map:RawReading;
    . 


















# TotalResistance
map:TotalResistance a d2rq:ClassMap;
    d2rq:dataStorage map:database;
    d2rq:uriPattern "Readings/@@EXTRESISTENCIALEIT.ID@@/RawReading/TotalResistance";
    d2rq:class sensor:Quantity;
    .

map:RawReading_TotalResistance a d2rq:PropertyBridge;
    d2rq:belongsToClassMap map:RawReading;
    d2rq:property sensor:hasQuantity;
    d2rq:refersToClassMap map:TotalResistance;
    .   

  #assign a value to the TotalResistance
map:TotalResistance_Value a d2rq:PropertyBridge;
    d2rq:belongsToClassMap map:TotalResistance;
    d2rq:property sensor:hasValue;
    d2rq:column "EXTRESISTENCIALEIT.RESTOTAL";
    .

  #assign a QuantityType to the TotalResistance
map:TotalResistance_QuantityType a d2rq:PropertyBridge;
    d2rq:belongsToClassMap map:TotalResistance;
    d2rq:property sensor:hasQuantityType;
    d2rq:refersToClassMap map:QuantityType;
    .
    
    
# RelativeResistence
map:RelativeResistence a d2rq:ClassMap;
    d2rq:dataStorage map:database;
    d2rq:uriPattern "Readings/@@EXTRESISTENCIALEIT.ID@@/RawReading/RelativeResistence";
    d2rq:class sensor:Quantity;
    .

map:RawReading_RelativeResistence a d2rq:PropertyBridge;
    d2rq:belongsToClassMap map:RawReading;
    d2rq:property sensor:hasQuantity;
    d2rq:refersToClassMap map:RelativeResistence;
    .   

  #assign a value to the RelativeResistence
map:RelativeResistence_Value a d2rq:PropertyBridge;
    d2rq:belongsToClassMap map:RelativeResistence;
    d2rq:property sensor:hasValue;
    d2rq:column "EXTRESISTENCIALEIT.RELRES";
    .

  #assign a QuantityType to the RelativeResistence
map:RelativeResistance_QuantityType a d2rq:PropertyBridge;
    d2rq:belongsToClassMap map:RelativeResistence;
    d2rq:property sensor:hasQuantityType;
    d2rq:refersToClassMap map:QuantityType;
    .
    

#Result 
map:Result a d2rq:ClassMap;
    d2rq:dataStorage map:database;
    d2rq:uriPattern "Readings/@@EXTRESISTENCIALEIT.ID@@/Result/";
    d2rq:class sensor:Quantity;
  .   

map:Readings_Result a d2rq:PropertyBridge;
  d2rq:belongsToClassMap map:Readings;
  d2rq:property sensor:hasResult;
  d2rq:refersToClassMap map:Result;
  d2rq:join "EXTRESISTENCIALEIT.ID = EXTRESISTENCIARES.LEITURA";
    .


# Temperature
map:Temperature a d2rq:ClassMap;
    d2rq:dataStorage map:database;
    d2rq:uriPattern "Readings/@@EXTRESISTENCIALEIT.ID@@/Result/Temperature";
    d2rq:class sensor:Quantity;
    .

map:Result_Temperature a d2rq:PropertyBridge;
    d2rq:belongsToClassMap map:Result;
    d2rq:property sensor:hasQuantity;
    d2rq:refersToClassMap map:Temperature;
    .   

  #assign a value to the Temperature
map:Temperature_Value a d2rq:PropertyBridge;
    d2rq:belongsToClassMap map:Temperature;
    d2rq:property sensor:hasValue;
    d2rq:column "EXTRESISTENCIARES.TEMPERATURA";
  .
  
map:Temperature_Value a d2rq:PropertyBridge;
  d2rq:belongsToClassMap map:Temperature;
  d2rq:property sensor:hasValue;
  d2rq:join "EXTRESISTENCIALEIT.ID = EXTRESISTENCIARES.LEITURA";
  d2rq:column "EXTRESISTENCIARES.TEMPERATURA";    
    . 
  

  #assign a QuantityType to the Temperature
map:Temperature_QuantityType a d2rq:PropertyBridge;
    d2rq:belongsToClassMap map:Temperature;
    d2rq:property sensor:hasQuantityType;
    d2rq:refersToClassMap map:QuantityType;
    .
    
    
    
# Extension
map:Extension a d2rq:ClassMap;
    d2rq:dataStorage map:database;
    d2rq:uriPattern "Readings/@@EXTRESISTENCIALEIT.ID@@/Result/Extension";
    d2rq:class sensor:Quantity;
    .

map:Result_Extension a d2rq:PropertyBridge;
    d2rq:belongsToClassMap map:Result;
    d2rq:property sensor:hasQuantity;
    d2rq:refersToClassMap map:Extension;
    .   

  #assign a value to the Extension
map:Extension_Value a d2rq:PropertyBridge;
    d2rq:belongsToClassMap map:Extension;
    d2rq:property sensor:hasValue;
  d2rq:join "EXTRESISTENCIALEIT.ID = EXTRESISTENCIARES.LEITURA";
    d2rq:column "EXTRESISTENCIARES.EXTREAL";
    .

  #assign a QuantityType to the Extension
map:Extension_QuantityType a d2rq:PropertyBridge;
    d2rq:belongsToClassMap map:Extension;
    d2rq:property sensor:hasQuantityType;
    d2rq:refersToClassMap map:QuantityType;
    .



# Table OBRA
map:Dam a d2rq:ClassMap;
    d2rq:dataStorage map:database;
    d2rq:uriPattern "Dam/@@OBRA.ID@@";
    d2rq:class sensor:StructuralLocation;
    .

map:Dam_ID a d2rq:PropertyBridge;
    d2rq:belongsToClassMap map:Dam;
    d2rq:property sensor:hasIdentifier;
    d2rq:column "OBRA.ID";
    .

map:Dam_Name a d2rq:PropertyBridge;
    d2rq:belongsToClassMap map:Dam;
    d2rq:property sensor:hasName;
    d2rq:column "OBRA.NOME";
    .

    
    
# Table CAMPANHA
map:Campaign a d2rq:ClassMap;
    d2rq:dataStorage map:database;
    d2rq:uriPattern "Campaign/@@CAMPANHAOBSERVACOES.ID@@";
    d2rq:class sensor:Campaign;
    .
    
map:Campaign_ID a d2rq:PropertyBridge;
    d2rq:belongsToClassMap map:Campaign;
    d2rq:property sensor:hasIdentifier;
    d2rq:column "CAMPANHAOBSERVACOES.ID";
    .
    
#map:Campaign_Dam a d2rq:PropertyBridge;
#   d2rq:belongsToClassMap map:Campaign;
#   d2rq:property sensor:isPartOfStructure;
#   d2rq:refersToClassMap map:Dam;
#   d2rq:join "CAMPANHAOBSERVACOES.IDOBRA = OBRA.ID";
#   .
    
#map:Campaign_StartDate a d2rq:PropertyBridge;
#   d2rq:belongsToClassMap map:Campaign;
#   d2rq:property sensor:hasDate;
#   d2rq:column "CAMPANHAOBSERVACOES.DATAINICIO";
#   .
    
#map:Campaign_EndDate a d2rq:PropertyBridge;
#   d2rq:belongsToClassMap map:Campaign;
#   d2rq:property sensor:hasDate;
#   d2rq:column "CAMPANHAOBSERVACOES.DATAFIM";
#   .

	a/mappings/gestBarragens2sensorDSO.ttl		b/mappings/gestBarragens2sensorDSO.ttl
1	@prefix map: <http://www.opensourceprojects.eu/p/timbus/context-population/extractors/d2rq/ci/786382cb0ebe0c342d323178f0476125c8c44902/tree/mappings/gestBarragens2sensorDSO.ttl?format=raw#> .	1	@prefix map: <http://www.opensourceprojects.eu/p/timbus/context-population/extractors/d2rq/ci/786382cb0ebe0c342d323178f0476125c8c44902/tree/mappings/gestBarragens2sensorDSO.ttl?format=raw#> .
2	@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .	2	@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
3	@prefix d2rq: <http://www.wiwiss.fu-berlin.de/suhl/bizer/D2RQ/0.1#> .	3	@prefix d2rq: <http://www.wiwiss.fu-berlin.de/suhl/bizer/D2RQ/0.1#> .
4	@prefix d2r: <http://sites.wiwiss.fu-berlin.de/suhl/bizer/d2r-server/config.rdf#> .	4	@prefix d2r: <http://sites.wiwiss.fu-berlin.de/suhl/bizer/d2r-server/config.rdf#> .
5	@prefix meta: <http://www4.wiwiss.fu-berlin.de/bizer/d2r-server/metadata#> .	5	@prefix meta: <http://www4.wiwiss.fu-berlin.de/bizer/d2r-server/metadata#> .
6		6	@prefix jdbc: <http://d2rq.org/terms/jdbc/> .
7		7
8	@prefix sensor: <http://timbus.teco.edu/ontologies/DSOs/sensors.owl#> .	8	@prefix sensor: <http://timbus.teco.edu/ontologies/DSOs/sensors.owl#> .
9		9
10	<> a d2r:Server;	10	<> a d2r:Server;
		11	d2r:baseURI <http://timbus.teco.edu/sensors>;
11	rdfs:label "Gest Barragens SensorDSO Instance";	12	rdfs:label "Gest Barragens SensorDSO Instance";
12	d2r:baseURI <http://timbus.teco.edu/sensors/>;
13	d2r:port 2020;	13	d2r:port 2020;
14	d2r:vocabularyIncludeInstances true;	14	d2r:vocabularyIncludeInstances true;
15		15
16	d2r:sparqlTimeout 300;	16	d2r:sparqlTimeout 0;
17	d2r:pageTimeout 5;	17	d2r:pageTimeout 0;
18		18
19	meta:datasetTitle "WP8 Use Case Instance - Internal Use Only!";	19	meta:datasetTitle "WP8 Use Case Instance - Internal Use Only!";
20	meta:datasetDescription "SensorDSO instance of LNEC Damn Management System" ;	20	meta:datasetDescription "SensorDSO instance of LNEC Damn Management System" ;
21	meta:datasetSource "Gest Barragens Oracle DB" ;	21	meta:datasetSource "Gest Barragens Oracle DB" ;
22		22
	...		...
24	meta:operatorHomepage "http://timbusproject.net/";	24	meta:operatorHomepage "http://timbusproject.net/";
25	.	25	.
26		26
27		27
28	map:database a d2rq:Database;	28	map:database a d2rq:Database;
29	d2rq:jdbcDriver "oracle.jdbc.driver.OracleDriver";	29	d2rq:jdbcDriver "oracle.jdbc.driver.OracleDriver"; # database driver, e.g. jdbc for Oracle
30	d2rq:jdbcDSN "jdbc:oracle:thin:@teco32pc.teco.edu:49153/xe";	30	d2rq:jdbcDSN "jdbc:oracle:thin:@XXX/XXX"; # database host adress and service name
31	d2rq:username "teco";	31	d2rq:username "XXX"; # username
32	d2rq:password "pervasive";	32	d2rq:password "XXX"; # passwort
33	jdbc:keepAlive "3600"; # sends noop-query every 3600 seconds	33	jdbc:keepAlive "3600"; # sends noop-query every 3600 seconds
34	# jdbc:keepAliveQuery "SELECT 1"; # optional custom noop-query	34	# jdbc:keepAliveQuery "SELECT 1"; # optional custom noop-query
35	.	35	.
36
37		36
38		37
39	# Table EXTRESISTENCIA	38	# Table EXTRESISTENCIA
40	map:Sensor a d2rq:ClassMap;	39	map:Sensor a d2rq:ClassMap;
41	d2rq:dataStorage map:database;	40	d2rq:dataStorage map:database;
42	d2rq:uriPattern "Sensor/@@TECO.EXTRESISTENCIA.ID@@";	41	d2rq:uriPattern "Sensor/@@EXTRESISTENCIA.ID@@";
43	d2rq:class sensor:Sensor;	42	d2rq:class sensor:Sensor;
44	.	43	.
45		44
46		45
47	map:Sensor_ID a d2rq:PropertyBridge;	46	map:Sensor_ID a d2rq:PropertyBridge;
48	d2rq:belongsToClassMap map:Sensor;	47	d2rq:belongsToClassMap map:Sensor;
49	d2rq:property sensor:hasIdentifier;	48	d2rq:property sensor:hasIdentifier;
50	d2rq:column "TECO.EXTRESISTENCIA.ID";	49	d2rq:column "EXTRESISTENCIA.ID";
51	.	50	.
52		51
53		52
54	map:Sensor_AcquisitionRatePerYear a d2rq:PropertyBridge;	53	map:Sensor_AcquisitionRatePerYear a d2rq:PropertyBridge;
55	d2rq:belongsToClassMap map:Sensor;	54	d2rq:belongsToClassMap map:Sensor;
56	d2rq:property sensor:hasAcquisitionRatePerYear;	55	d2rq:property sensor:hasAcquisitionRatePerYear;
57	d2rq:column "TECO.EXTRESISTENCIA.FREQLEITURA";	56	d2rq:column "EXTRESISTENCIA.FREQLEITURA";
58	.	57	.
59		58
60		59
61	map:Sensor_Dam a d2rq:PropertyBridge;	60	map:Sensor_Dam a d2rq:PropertyBridge;
62	d2rq:belongsToClassMap map:Sensor;	61	d2rq:belongsToClassMap map:Sensor;
63	d2rq:property sensor:hasLocation;	62	d2rq:property sensor:hasLocation;
64	d2rq:refersToClassMap map:Dam;	63	d2rq:refersToClassMap map:Dam;
65	d2rq:join "TECO.EXTRESISTENCIA.GRUPOID => TECO.EXTRESISTENCIAGRUPO.ID";	64	d2rq:join "EXTRESISTENCIA.GRUPOID => EXTRESISTENCIAGRUPO.ID";
66	d2rq:join "TECO.OBRA.ID <= TECO.EXTRESISTENCIAGRUPO.OBRA";	65	d2rq:join "OBRA.ID <= EXTRESISTENCIAGRUPO.OBRA";
67	.	66	.
68		67
69		68
70	map:Sensor_GeoLocation a d2rq:PropertyBridge;	69	map:Sensor_GeoLocation a d2rq:PropertyBridge;
71	d2rq:belongsToClassMap map:Sensor;	70	d2rq:belongsToClassMap map:Sensor;
72	d2rq:property sensor:hasLocation;	71	d2rq:property sensor:hasLocation;
73	d2rq:refersToClassMap map:GeoLocation;	72	d2rq:refersToClassMap map:GeoLocation;
74	d2rq:join "TECO.EXTRESISTENCIA.GRUPOID = TECO.EXTRESISTENCIAGRUPO.ID";	73	d2rq:join "EXTRESISTENCIA.GRUPOID = EXTRESISTENCIAGRUPO.ID";
75	.	74	.
76		75
77		76
78	#map:Sensor_SensorType a d2rq:PropertyBridge;	77	#map:Sensor_SensorType a d2rq:PropertyBridge;
79	# d2rq:belongsToClassMap map:Sensor;	78	# d2rq:belongsToClassMap map:Sensor;
80	# d2rq:property sensor:hasType;	79	# d2rq:property sensor:hasType;
81	# d2rq:refersToClassMap map:SensorType;	80	# d2rq:refersToClassMap map:SensorType;
82	# d2rq:join "TECO.EXTRESISTENCIA => TECO.EXTRESISTENCIALEIT.INTRUMENTO";	81	# d2rq:join "EXTRESISTENCIA => EXTRESISTENCIALEIT.INTRUMENTO";
83	# d2rq:join "TECO.INSTRMETADATAEN.INTRUMENTO <= TECO.EXTRESISTENCIALEIT.INSTRFIXO";	82	# d2rq:join "INSTRMETADATAEN.INTRUMENTO <= EXTRESISTENCIALEIT.INSTRFIXO";
84	# .	83	# .
85		84
86		85
87	#todo: look for a way to create an inverse property for this	86	#todo: look for a way to create an inverse property for this
88	map:Sensor_Reading a d2rq:PropertyBridge;	87	map:Sensor_Reading a d2rq:PropertyBridge;
89	d2rq:belongsToClassMap map:Sensor;	88	d2rq:belongsToClassMap map:Sensor;
90	d2rq:property sensor:hasReading;	89	d2rq:property sensor:hasReading;
91	d2rq:refersToClassMap map:Readings;	90	d2rq:refersToClassMap map:Readings;
92	d2rq:join "TECO.EXTRESISTENCIALEIT.INSTRFIXO = TECO.EXTRESISTENCIA.ID";	91	d2rq:join "EXTRESISTENCIALEIT.INSTRFIXO = EXTRESISTENCIA.ID";
93	.	92	.
94		93
95		94
96	map:GeoLocation a d2rq:ClassMap;	95	map:GeoLocation a d2rq:ClassMap;
97	d2rq:dataStorage map:database;	96	d2rq:dataStorage map:database;
98	d2rq:uriPattern "Sensor/@@TECO.EXTRESISTENCIA.ID@@/GeoLocation";	97	d2rq:uriPattern "GeoLocation/@@EXTRESISTENCIAGRUPO.ID@@/";
99	d2rq:class sensor:GeoLocation;	98	d2rq:class sensor:GeoLocation;
100	.	99	.
101		100
		101	map:GeoLocation_Z a d2rq:PropertyBridge;
		102	d2rq:belongsToClassMap map:GeoLocation;
		103	d2rq:property sensor:hasZCoordinate;
		104	d2rq:column "EXTRESISTENCIAGRUPO.Z";
		105	.
		106
		107	map:GeoLocation_Y a d2rq:PropertyBridge;
		108	d2rq:belongsToClassMap map:GeoLocation;
		109	d2rq:property sensor:hasYCoordinate;
		110	d2rq:column "EXTRESISTENCIAGRUPO.Y";
		111	.
		112
102	map:GeoLocation_X a d2rq:PropertyBridge;	113	map:GeoLocation_X a d2rq:PropertyBridge;
103	d2rq:belongsToClassMap map:GeoLocation;	114	d2rq:belongsToClassMap map:GeoLocation;
104	d2rq:property sensor:hasXCoordinate;	115	d2rq:property sensor:hasXCoordinate;
105	d2rq:column "TECO.EXTRESISTENCIAGRUPO.X";	116	d2rq:column "EXTRESISTENCIAGRUPO.X";
106	.
107
108	map:GeoLocation_Y a d2rq:PropertyBridge;
109	d2rq:belongsToClassMap map:GeoLocation;
110	d2rq:property sensor:hasYCoordinate;
111	d2rq:column "TECO.EXTRESISTENCIAGRUPO.Y";
112	.
113
114	map:GeoLocation_Z a d2rq:PropertyBridge;
115	d2rq:belongsToClassMap map:GeoLocation;
116	d2rq:property sensor:hasZCoordinate;
117	d2rq:column "TECO.EXTRESISTENCIAGRUPO.Z";
118	.	117	.
119		118
120		119
121		120
122	#Table INSTRMETADATAEN	121	#Table INSTRMETADATAEN
123	#map:SensorType a d2rq:ClassMap;	122	#map:SensorType a d2rq:ClassMap;
124	# d2rq:dataStorage map:database;	123	# d2rq:dataStorage map:database;
125	# d2rq:uriPattern "SensorType/@@TECO.INSTRMETADATAEN.ID@@";	124	# d2rq:uriPattern "SensorType/@@INSTRMETADATAEN.ID@@";
126	# d2rq:class sensor:SensorType;	125	# d2rq:class sensor:SensorType;
127	# .	126	# .
128		127
129	#map:SensorType_Name a d2rq:PropertyBridge;	128	#map:SensorType_Name a d2rq:PropertyBridge;
130	# d2rq:belongsToClassMap map:SensorType;	129	# d2rq:belongsToClassMap map:SensorType;
131	# d2rq:property sensor:hasName;	130	# d2rq:property sensor:hasName;
132	# d2rq:column "TECO.INSTRMETADATAEN.INSTRUMENTO";	131	# d2rq:column "INSTRMETADATAEN.INSTRUMENTO";
133	# .	132	# .
134		133
135		134
136	# Table "Quantity" ???	135	# Table "Quantity" ???
137		136
	...		...
151		150
152		151
153	# Table LEITURA	152	# Table LEITURA
154	map:Readings a d2rq:ClassMap;	153	map:Readings a d2rq:ClassMap;
155	d2rq:dataStorage map:database;	154	d2rq:dataStorage map:database;
156	d2rq:uriPattern "Readings/@@TECO.EXTRESISTENCIALEIT.ID@@";	155	d2rq:uriPattern "Readings/@@EXTRESISTENCIALEIT.ID@@";
157	d2rq:class sensor:Reading;	156	d2rq:class sensor:Reading;
158	.	157	.
159		158
160	map:Readings_ID a d2rq:PropertyBridge;	159	map:Readings_ID a d2rq:PropertyBridge;
161	d2rq:belongsToClassMap map:Readings;	160	d2rq:belongsToClassMap map:Readings;
162	d2rq:property sensor:hasIdentifier;	161	d2rq:property sensor:hasIdentifier;
163	d2rq:column "TECO.EXTRESISTENCIALEIT.ID";	162	d2rq:column "EXTRESISTENCIALEIT.ID";
164	.	163	.
165		164
166	#map:Readings_Sensor a d2rq:PropertyBridge;	165	#map:Readings_Sensor a d2rq:PropertyBridge;
167	# d2rq:belongsToClassMap map:Readings;	166	# d2rq:belongsToClassMap map:Readings;
168	# d2rq:property sensor:isReadingOf;	167	# d2rq:property sensor:isReadingOf;
169	# d2rq:refersToClassMap map:Sensor;	168	# d2rq:refersToClassMap map:Sensor;
170	# d2rq:join "TECO.EXTRESISTENCIALEIT.INSTRFIXO = TECO.EXTRESISTENCIA.ID";	169	# d2rq:join "EXTRESISTENCIALEIT.INSTRFIXO = EXTRESISTENCIA.ID";
171	# .	170	# .
172		171
173	map:Readings_Campaign a d2rq:PropertyBridge;	172	map:Readings_Campaign a d2rq:PropertyBridge;
174	d2rq:belongsToClassMap map:Readings;	173	d2rq:belongsToClassMap map:Readings;
175	d2rq:property sensor:hasCampaign;	174	d2rq:property sensor:hasCampaign;
176	d2rq:refersToClassMap map:Campaign;	175	d2rq:refersToClassMap map:Campaign;
177	d2rq:join "TECO.EXTRESISTENCIALEIT.CAMPANHA = TECO.CAMPANHA.ID";	176	d2rq:join "EXTRESISTENCIALEIT.CAMPANHA = CAMPANHAOBSERVACOES.ID";
178	.	177	.
179		178
180		179
181	map:Readings_Date a d2rq:PropertyBridge;	180	map:Readings_Date a d2rq:PropertyBridge;
182	d2rq:belongsToClassMap map:Readings;	181	d2rq:belongsToClassMap map:Readings;
183	d2rq:property sensor:hasDate;	182	d2rq:property sensor:hasDate;
184	d2rq:column "TECO.EXTRESISTENCIALEIT.DATALEIT";	183	d2rq:column "EXTRESISTENCIALEIT.DATALEIT";
		184	.
		185
		186
		187	# RawReading
		188	map:RawReading a d2rq:ClassMap;
		189	d2rq:dataStorage map:database;
		190	d2rq:uriPattern "Readings/@@EXTRESISTENCIALEIT.ID@@/RawReading/";
		191	d2rq:class sensor:Quantity;
185	.	192	.
186		193
187
188	map:Reading_RawReading a d2rq:PropertyBridge;	194	map:Reading_RawReading a d2rq:PropertyBridge;
189	d2rq:belongsToClassMap map:Readings;	195	d2rq:belongsToClassMap map:Readings;
190	d2rq:property sensor:hasRawReading;	196	d2rq:property sensor:hasRawReading;
191	d2rq:refersToClassMap map:RawReading;	197	d2rq:refersToClassMap map:RawReading;
192	.	198	.
193		199
194
195	map:Readings_Result a d2rq:PropertyBridge;
196	d2rq:belongsToClassMap map:Readings;
197	d2rq:property sensor:hasResult;
198	d2rq:refersToClassMap map:Result;
199	d2rq:join "TECO.EXTRESISTENCIALEIT.ID = TECO.EXTRESISTENCIARES.LEITURA";
200	.
201
202
203	# RawReading
204	map:RawReading a d2rq:ClassMap;
205	d2rq:dataStorage map:database;
206	d2rq:uriPattern "Readings/@@TECO.EXTRESISTENCIALEIT.ID@@/RawReading/";
207	d2rq:class sensor:Quantity;
208	.
209
210		200
211	# TotalResistance	201	# TotalResistance
212	map:TotalResistance a d2rq:ClassMap;	202	map:TotalResistance a d2rq:ClassMap;
213	d2rq:dataStorage map:database;	203	d2rq:dataStorage map:database;
214	d2rq:uriPattern "Readings/@@TECO.EXTRESISTENCIALEIT.ID@@/RawReading/TotalResistance";	204	d2rq:uriPattern "Readings/@@EXTRESISTENCIALEIT.ID@@/RawReading/TotalResistance";
215	d2rq:class sensor:Value;	205	d2rq:class sensor:Quantity;
216	.	206	.
217		207
218	map:RawReading_TotalResistance a d2rq:PropertyBridge;	208	map:RawReading_TotalResistance a d2rq:PropertyBridge;
219	d2rq:belongsToClassMap map:RawReadings;	209	d2rq:belongsToClassMap map:RawReading;
220	d2rq:property sensor:hasValue;	210	d2rq:property sensor:hasQuantity;
221	d2rq:refersToClassMap map:TotalResistance;	211	d2rq:refersToClassMap map:TotalResistance;
222	.	212	.
223		213
224	#assign a value to the TotalResistance	214	#assign a value to the TotalResistance
225	map:TotalResistance_Value a d2rq:PropertyBridge;	215	map:TotalResistance_Value a d2rq:PropertyBridge;
226	d2rq:belongsToClassMap map:TotalResistance;	216	d2rq:belongsToClassMap map:TotalResistance;
227	d2rq:property sensor:hasValue;	217	d2rq:property sensor:hasValue;
228	d2rq:column "TECO.EXTRESISTENCIALEIT.RESTOTAL";	218	d2rq:column "EXTRESISTENCIALEIT.RESTOTAL";
229	.	219	.
230		220
231	#assign a QuantityType to the TotalResistance	221	#assign a QuantityType to the TotalResistance
232	map:TotalResistance_QuantityType a d2rq:PropertyBridge;	222	map:TotalResistance_QuantityType a d2rq:PropertyBridge;
233	d2rq:belongsToClassMap map:TotalResistance;	223	d2rq:belongsToClassMap map:TotalResistance;
234	d2rq:property sensor:hasQuantityType;	224	d2rq:property sensor:hasQuantityType;
235	d2rq:refersToClassMap sensor:QuantityType;	225	d2rq:refersToClassMap map:QuantityType;
236	.	226	.
237		227
238		228
239	# RelativeResistence	229	# RelativeResistence
240	map:RelativeResistence a d2rq:ClassMap;	230	map:RelativeResistence a d2rq:ClassMap;
241	d2rq:dataStorage map:database;	231	d2rq:dataStorage map:database;
242	d2rq:uriPattern "Readings/@@TECO.EXTRESISTENCIALEIT.ID@@/RawReading/RelativeResistence";	232	d2rq:uriPattern "Readings/@@EXTRESISTENCIALEIT.ID@@/RawReading/RelativeResistence";
243	d2rq:class sensor:Value;	233	d2rq:class sensor:Quantity;
244	.	234	.
245		235
246	map:RawReading_RelativeResistence a d2rq:PropertyBridge;	236	map:RawReading_RelativeResistence a d2rq:PropertyBridge;
247	d2rq:belongsToClassMap map:RawReadings;	237	d2rq:belongsToClassMap map:RawReading;
248	d2rq:property sensor:hasValue;	238	d2rq:property sensor:hasQuantity;
249	d2rq:refersToClassMap map:RelativeResistence;	239	d2rq:refersToClassMap map:RelativeResistence;
250	.	240	.
251		241
252	#assign a value to the RelativeResistence	242	#assign a value to the RelativeResistence
253	map:RelativeResistence_Value a d2rq:PropertyBridge;	243	map:RelativeResistence_Value a d2rq:PropertyBridge;
254	d2rq:belongsToClassMap map:RelativeResistence;	244	d2rq:belongsToClassMap map:RelativeResistence;
255	d2rq:property sensor:hasValue;	245	d2rq:property sensor:hasValue;
256	d2rq:column "TECO.EXTRESISTENCIALEIT.RELRES";	246	d2rq:column "EXTRESISTENCIALEIT.RELRES";
257	.	247	.
258		248
259	#assign a QuantityType to the RelativeResistence	249	#assign a QuantityType to the RelativeResistence
260	map:RelativeResistance_QuantityType a d2rq:PropertyBridge;	250	map:RelativeResistance_QuantityType a d2rq:PropertyBridge;
261	d2rq:belongsToClassMap map:RelativeResistence;	251	d2rq:belongsToClassMap map:RelativeResistence;
262	d2rq:property sensor:hasQuantityType;	252	d2rq:property sensor:hasQuantityType;
263	d2rq:refersToClassMap sensor:QuantityType;	253	d2rq:refersToClassMap map:QuantityType;
264	.	254	.
265		255
266		256
267	#Result	257	#Result
268	map:Result a d2rq:ClassMap;	258	map:Result a d2rq:ClassMap;
269	d2rq:dataStorage map:database;	259	d2rq:dataStorage map:database;
270	d2rq:uriPattern "Readings/@@TECO.EXTRESISTENCIALEIT.ID@@/Result/";	260	d2rq:uriPattern "Readings/@@EXTRESISTENCIALEIT.ID@@/Result/";
271	d2rq:class sensor:Quantity;	261	d2rq:class sensor:Quantity;
		262	.
		263
		264	map:Readings_Result a d2rq:PropertyBridge;
		265	d2rq:belongsToClassMap map:Readings;
		266	d2rq:property sensor:hasResult;
		267	d2rq:refersToClassMap map:Result;
		268	d2rq:join "EXTRESISTENCIALEIT.ID = EXTRESISTENCIARES.LEITURA";
272	.	269	.
273
274		270
275	# Temperature	271	# Temperature
276	map:Temperature a d2rq:ClassMap;	272	map:Temperature a d2rq:ClassMap;
277	d2rq:dataStorage map:database;	273	d2rq:dataStorage map:database;
278	d2rq:uriPattern "Readings/@@TECO.EXTRESISTENCIALEIT.ID@@/Result/Temperature";	274	d2rq:uriPattern "Readings/@@EXTRESISTENCIALEIT.ID@@/Result/Temperature";
279	d2rq:class sensor:Value;	275	d2rq:class sensor:Quantity;
280	.	276	.
281		277
282	map:Result_Temperature a d2rq:PropertyBridge;	278	map:Result_Temperature a d2rq:PropertyBridge;
283	d2rq:belongsToClassMap map:Result;	279	d2rq:belongsToClassMap map:Result;
284	d2rq:property sensor:hasValue;	280	d2rq:property sensor:hasQuantity;
285	d2rq:refersToClassMap map:Temperature;	281	d2rq:refersToClassMap map:Temperature;
286	.	282	.
287		283
288	#assign a value to the Temperature	284	#assign a value to the Temperature
289	map:Temperature_Value a d2rq:PropertyBridge;	285	map:Temperature_Value a d2rq:PropertyBridge;
290	d2rq:belongsToClassMap map:Temperature;	286	d2rq:belongsToClassMap map:Temperature;
291	d2rq:property sensor:hasValue;	287	d2rq:property sensor:hasValue;
292	d2rq:column "TECO.EXTRESISTENCIARES.TEMPERATURA";	288	d2rq:column "EXTRESISTENCIARES.TEMPERATURA";
		289	.
		290
		291	map:Temperature_Value a d2rq:PropertyBridge;
		292	d2rq:belongsToClassMap map:Temperature;
		293	d2rq:property sensor:hasValue;
		294	d2rq:join "EXTRESISTENCIALEIT.ID = EXTRESISTENCIARES.LEITURA";
		295	d2rq:column "EXTRESISTENCIARES.TEMPERATURA";
293	.	296	.
		297
294		298
295	#assign a QuantityType to the Temperature	299	#assign a QuantityType to the Temperature
296	map:Temperature_QuantityType a d2rq:PropertyBridge;	300	map:Temperature_QuantityType a d2rq:PropertyBridge;
297	d2rq:belongsToClassMap map:Temperature;	301	d2rq:belongsToClassMap map:Temperature;
298	d2rq:property sensor:hasQuantityType;	302	d2rq:property sensor:hasQuantityType;
299	d2rq:refersToClassMap sensor:QuantityType;	303	d2rq:refersToClassMap map:QuantityType;
300	.	304	.
301		305
302		306
303		307
304	# Extension	308	# Extension
305	map:Extension a d2rq:ClassMap;	309	map:Extension a d2rq:ClassMap;
306	d2rq:dataStorage map:database;	310	d2rq:dataStorage map:database;
307	d2rq:uriPattern "Readings/@@TECO.EXTRESISTENCIALEIT.ID@@/Result/Extension";	311	d2rq:uriPattern "Readings/@@EXTRESISTENCIALEIT.ID@@/Result/Extension";
308	d2rq:class sensor:Value;	312	d2rq:class sensor:Quantity;
309	.	313	.
310		314
311	map:Result_Extension a d2rq:PropertyBridge;	315	map:Result_Extension a d2rq:PropertyBridge;
312	d2rq:belongsToClassMap map:Result;	316	d2rq:belongsToClassMap map:Result;
313	d2rq:property sensor:hasValue;	317	d2rq:property sensor:hasQuantity;
314	d2rq:refersToClassMap map:Extension;	318	d2rq:refersToClassMap map:Extension;
315	.	319	.
316		320
317	#assign a value to the Extension	321	#assign a value to the Extension
318	map:Extension_Value a d2rq:PropertyBridge;	322	map:Extension_Value a d2rq:PropertyBridge;
319	d2rq:belongsToClassMap map:Extension;	323	d2rq:belongsToClassMap map:Extension;
320	d2rq:property sensor:hasValue;	324	d2rq:property sensor:hasValue;
		325	d2rq:join "EXTRESISTENCIALEIT.ID = EXTRESISTENCIARES.LEITURA";
321	d2rq:column "TECO.EXTRESISTENCIARES.EXTREAL";	326	d2rq:column "EXTRESISTENCIARES.EXTREAL";
322	.	327	.
323		328
324	#assign a QuantityType to the Extension	329	#assign a QuantityType to the Extension
325	map:Extension_QuantityType a d2rq:PropertyBridge;	330	map:Extension_QuantityType a d2rq:PropertyBridge;
326	d2rq:belongsToClassMap map:Extension;	331	d2rq:belongsToClassMap map:Extension;
327	d2rq:property sensor:hasQuantityType;	332	d2rq:property sensor:hasQuantityType;
328	d2rq:refersToClassMap sensor:QuantityType;	333	d2rq:refersToClassMap map:QuantityType;
329	.	334	.
330		335
331		336
332		337
333	# Table OBRA	338	# Table OBRA
334	map:Dam a d2rq:ClassMap;	339	map:Dam a d2rq:ClassMap;
335	d2rq:dataStorage map:database;	340	d2rq:dataStorage map:database;
336	d2rq:uriPattern "Dam/@@TECO.OBRA.ID@@";	341	d2rq:uriPattern "Dam/@@OBRA.ID@@";
337	d2rq:class sensor:StructuralLocation;	342	d2rq:class sensor:StructuralLocation;
338	.	343	.
339		344
340	map:Dam_ID a d2rq:PropertyBridge;	345	map:Dam_ID a d2rq:PropertyBridge;
341	d2rq:belongsToClassMap map:Dam;	346	d2rq:belongsToClassMap map:Dam;
342	d2rq:property sensor:hasIdentifier;	347	d2rq:property sensor:hasIdentifier;
343	d2rq:column "TECO.OBRA.ID";	348	d2rq:column "OBRA.ID";
344	.	349	.
345		350
346	map:Dam_Name a d2rq:PropertyBridge;	351	map:Dam_Name a d2rq:PropertyBridge;
347	d2rq:belongsToClassMap map:Dam;	352	d2rq:belongsToClassMap map:Dam;
348	d2rq:property sensor:hasName;	353	d2rq:property sensor:hasName;
349	d2rq:column "TECO.OBRA.NOME";	354	d2rq:column "OBRA.NOME";
350	.	355	.
351		356
352		357
353		358
354	# Table CAMPANHA	359	# Table CAMPANHA
355	map:Campaign a d2rq:ClassMap;	360	map:Campaign a d2rq:ClassMap;
356	d2rq:dataStorage map:database;	361	d2rq:dataStorage map:database;
357	d2rq:uriPattern "Campaign/@@TECO.CAMPANHAOBSERVACOES.ID@@";	362	d2rq:uriPattern "Campaign/@@CAMPANHAOBSERVACOES.ID@@";
358	d2rq:class sensor:Campaign;	363	d2rq:class sensor:Campaign;
359	.	364	.
360		365
361	map:Campaign_ID a d2rq:PropertyBridge;	366	map:Campaign_ID a d2rq:PropertyBridge;
362	d2rq:belongsToClassMap map:Campaign;	367	d2rq:belongsToClassMap map:Campaign;
363	d2rq:property sensor:hasIdentifier;	368	d2rq:property sensor:hasIdentifier;
364	d2rq:column "TECO.CAMPANHAOBSERVACOES.ID";	369	d2rq:column "CAMPANHAOBSERVACOES.ID";
365	.	370	.
366		371
367	#map:Campaign_Dam a d2rq:PropertyBridge;	372	#map:Campaign_Dam a d2rq:PropertyBridge;
368	# d2rq:belongsToClassMap map:Campaign;	373	# d2rq:belongsToClassMap map:Campaign;
369	# d2rq:property sensor:isPartOfStructure;	374	# d2rq:property sensor:isPartOfStructure;
370	# d2rq:refersToClassMap map:Dam;	375	# d2rq:refersToClassMap map:Dam;
371	# d2rq:join "TECO.CAMPANHAOBSERVACOES.IDOBRA = TECO.OBRA.ID";	376	# d2rq:join "CAMPANHAOBSERVACOES.IDOBRA = OBRA.ID";
372	# .	377	# .
373		378
374	#map:Campaign_StartDate a d2rq:PropertyBridge;	379	#map:Campaign_StartDate a d2rq:PropertyBridge;
375	# d2rq:belongsToClassMap map:Campaign;	380	# d2rq:belongsToClassMap map:Campaign;
376	# d2rq:property sensor:hasDate;	381	# d2rq:property sensor:hasDate;
377	# d2rq:column "TECO.CAMPANHAOBSERVACOES.DATAINICIO";	382	# d2rq:column "CAMPANHAOBSERVACOES.DATAINICIO";
378	# .	383	# .
379		384
380	#map:Campaign_EndDate a d2rq:PropertyBridge;	385	#map:Campaign_EndDate a d2rq:PropertyBridge;
381	# d2rq:belongsToClassMap map:Campaign;	386	# d2rq:belongsToClassMap map:Campaign;
382	# d2rq:property sensor:hasDate;	387	# d2rq:property sensor:hasDate;
383	# d2rq:column "TECO.CAMPANHAOBSERVACOES.DATAFIM";	388	# d2rq:column "CAMPANHAOBSERVACOES.DATAFIM";
384	# .	389	# .