geometry2rdf

Victor Saquicela, Boris Villazón-Terrazas, Alexander de León, Luis M. Vilches, and Oscar Corcho

Facultad de Informática, Universidad Politécnica de Madrid

Campus de Montegancedo sn, 28660 Boadilla del Monte, Madrid

http://www.oeg-upm.net

Phone: 34.91.3366605, Fax: 34.91.3524819

ToC

• Motivation

• Brief description

• How it works

• Future Work

2

Motivation

• Holidays to visit Mora Municipality in Spain.• Want to know places to practice water-related sports

close to the area

3

?

Motivation

In the geospatial context, the transformation and publication of the

• OpenStreetMap• Ordnance Survey• GeoLinkedData

data according to the Linked Data principles have added a new dimension to the Web of Data. In this way spatial data can be retrieved and interlinked.

4

Motivation

• So, let’s convert the geospatial information into RDF

• But, how?

5

geometry2rdf

http://www.oeg-upm.net/index.php/en/downloads/151-geometry2rdf

http://mccarthy.dia.fi.upm.es/geometry2rdf/

geometry2rdf

• Tool for generating RDF from geometrical information

• The geometry could be available in GML or WKT

• The RDF generated follows our Geometry Model

• How it works?

6

In a nutshell

7

Extracting the GML from the Oracle GeoSpatial Databases

Oracle STO UTIL package

SELECT TO_CHAR(SDO_UTIL.TO_GML311GEOMETRY(geometry)) AS Gml311Geometry

FROM "BCN200"."BCN200_0301L_RIO" cWHERE c.Etiqueta='Arroyo'

8

Generation of the RDF resources

9

Generation of the RDF resources

10

Java geo objects

Geometry Model

11

geoes:ontology/Polígono

geoes: http://geo.linkeddata.es/geo: http://www.w3.org/2003/01/geo/wgs84_pos#

geoes:ontology/Geometría

geoes:ontology/Curvageo:Point

rdfs:subClassOf

rdfs:subClassOf

rdfs:subClassOf

3939geo:lat geo:long Collection of 2 or more geo:Points

Collection of 3 or more geo:Points

formadoPor formadoPor

RDF generated according to our Geometry Model

0

0

1 2

12

• Now, we can express our queryPREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>

SELECT ?subject ?latitude2 ?longitude2 (bif:st_distance(bif:st_point(?longitude,?latitude),

bif:st_point(?longitude2,?latitude2)) ) as ?distancia ?latitude ?longitude

WHERE {

<http://geo.linkeddata.es/resource/Municipio/Mora> geo:geometry ?g .

?g geo:lat ?latitude. ?g geo:long ?longitude.

?subject geo:geometry ?g2.

?g2 geo:lat ?latitude2. ?g2 geo:long ?longitude2.

} limit 20

13

Visualize it on the map, and …

14

Future work

• Include the generation • from shape files• from other DBMS

• Improve our Geometry Model

15

16

geometry2rdf

Victor Saquicela, Boris Villazón-Terrazas, Alexander de León, Luis M. Vilches, and Oscar Corcho

Facultad de Informática, Universidad Politécnica de Madrid

Campus de Montegancedo sn, 28660 Boadilla del Monte, Madrid

http://www.oeg-upm.net

Phone: 34.91.3366605, Fax: 34.91.3524819