SMS Platform & Linked Geo Data Ali Khalili, Antonis Loizou, - PowerPoint PPT Presentation

SMS Platform & Linked Geo Data Ali Khalili, Antonis Loizou, Peter van den Besselaar Day 1 Vienna, 10-11 September 2015

Agenda ● SMS Platform Architecture ● Geo data available in RISIS datasets ● Exchanging [Linked] Geo data ● Geo-Services provided by the SMS platform ○ Basic Geo Services ○ Innovative Geo Services based on the new notion of distance

SMS Architecture Application Service Data

http://sms.risis.eu

http://datasets.risis.eu

Geo data available in RISIS datasets

Entity Types

Geographical attributes available per entity type in each dataset Country Name Address Postal Code NUTS Lat/Long CIB Firm Person, Firm ETER Institution Institution Institution Institution Institution EUPRO Person, Organisation JOREP Beneficiary, Funding Funding Body Programme LeidenRank University MORE1 Person Nano Person, Institution Person, Institution Person, Institution Profile Person SIPER VICO Patent Firm Firm

Exchanging [Linked] Geo data

D IVERSE L ANDSCAPE OF S TANDARDS O pen G eospatial C onsortium Collaboration effort between more than 400 commercial, non-profit, governmental, and research organizations worldwide

G EO D ATA AS A S PINE Geodata may play a vital role in connecting and aggregating data from multiple (possibly external) sources based on geospatial references that they have in common. Semantic Web enables the use of implicit geodata on top of explicit geodata : ➢ Explicit Geodata; Direct geospatial references [ e.g. coordinates, surfaces, and distances ] ➢ Implicit Geodata; Indirect geospatial references requiring lookup [ e.g. place name -> (lookup) -> coordinates ]

Basic (RDF) Geo Vocabulary WGS84 – Latitude, Longitude & Altitude W3 Recommendation <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:geo="http://www.w3.org/2003/01/geo/wgs84_pos#"> <geo:Point> <geo:lat>55.701</geo:lat> <geo:long>12.552</geo:long> </geo:Point> </rdf:RDF>

GeoNames [ Bounding box ] • <country> • <countryCode>NL</countryCode> • <countryName>Netherlands</countryName> • <isoNumeric>528</isoNumeric> • <isoAlpha3>NLD</isoAlpha3> • <fipsCode>NL</fipsCode> • <continent>EU</continent> • <continentName>Europe</continentName> • … . • <west>3.362556</west> • <north>53.512196</north> • <east>7.227944</east> • <south>50.753918</south> • <postalCodeFormat>#### @@</postalCodeFormat> • </country> cont.

Flickr [ ESRI Shapefile ] • <place place_id="4hLQygSaBJ92" woeid="3534" • latitude="45.512" longitude="-73.554" • place_url="/The_Netherlands" place_type="locality" • name="The Netherlands" • has_shapedata="1"> • <!-- all the usual places hierarchy elements --> • <shapedata created="1223513357" alpha="0.012359619140625" • count_points="34778" count_edges="52"> • <polylines> • <polyline> 40.702243804932,19.945163726807 40.70276260376,19.940700531006 ,... </polyline> • </polylines> • </shapedata> • </place>

Virtuoso [ data type virtrdf:Geometry ] <http://sws.geonames.org/3186084/> skos:exactMatch <http://www.flicker.com/place/.AkiwWpVVLNcL1o> ; geo:geometry "POLYGON(( 19.945163726807 40.702243804932, 19.940700531006 40.70276260376, etc... )) " ^^ virtrdf:Geometry .

Geo vocab @prefix geo: <http://www.w3.org/2003/01/geo/wgs84_pos#> . @prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> . @prefix ex: <http://example.org/> . @prefix ngeo: <http://geovocab.org/geometry#> . _:polygon rdf:type ngeo:Polygon ; ngeo:exterior [ rdf:type ngeo:LinearRing ; ngeo:posList ( [ geo:lat "-29"; geo:long "16" ] [ geo:lat "-28"; geo:long "33" ] [ geo:lat "-34"; geo:long "27" ] [ geo:lat "-35"; geo:long "19" ] [ geo:lat "-29"; geo:long "16" ] ) ] ; ngeo:interior [ rdf:type ngeo:LinearRing ; ngeo:posList ( [ geo:lat "-29.5"; geo:long "27" ] [ geo:lat "-28.5"; geo:long "28.5" ] [ geo:lat "-29.5"; geo:long "29.5" ] [ geo:lat "-31"; geo:long "28" ] [ geo:lat "-29.5"; geo:long "27" ] ) ] .

GeoSPARQL Prefix rdfs: <http://www.w3.org/ 2000 / 01 /rdf-schema#> Prefix ogc: <http://www.opengis.net/ont/geosparql#> Prefix geom: <http://geovocab.org/geometry#> Prefix lgdo: <http://linkedgeodata.org/ontology/> Offers Select ?school ?schoolLabel ?coffeeShop ?coffeeShopLabel From <http://linkedgeodata.org> { ➢ A small ontology ?school ➢ An extension to SPARQL a lgdo: School ; rdfs:label ?schoolLabel ; geom:geometry [ ogc:asWKT ?schoolGeo ] . ? coffeeShop a lgdo:CoffeeShop ; Example rdfs:label ?coffeeShopLabel ; geom:geometry [ ogc:asWKT ?coffeeShopGeo Find all schools within a 5km ] . radius around a specific location, and for each school find Filter ( coffeeshops that are closer than bif:st_intersects (?schoolGeo, bif: 1km. st_point ( 4 . 892222 , 52 . 373056 ), 5 ) && bif:st_intersects (?coffeeShopGeo, ?schoolGeo, 1 ) ) . }

SMS Platform & Linked Geo Data Ali Khalili, Antonis Loizou, Peter van den Besselaar Day 2 Vienna, 10-11 September 2015

Agenda ● Geo-Services provided by the SMS platform ○ Basic Geo Services ■ Geocoding ■ Conversion between various Geodata classifications ■ Geographical boundary-related services ○ Innovative Geo Services based on the new notion of distance

Geo data representation on the SMS Platform ● Uses Virtuoso representation internally ○ performance ○ convenience ● Provides a service that can ingest multiple formats into Virtuoso. ● Provides an export service from Virtuoso to user-specified formats.

Basic Geo Services Geocoding

Geo-coding Lat/Long ● Converts an address (or place name) CIB to geo coordinates ○ can be a point or a polygon ETER Institution EUPRO JOREP ● Most RISIS datasets do not store geo coordinates LeidenRank ○ augments RISIS datasets with useful MORE1 information ○ enables calculating distance between RISIS Nano Firm entities Profile ○ enables validation of NUTS regions (i.e. does the point lie inside the polygon) SIPER VICO

Geo-coding Lat/Long SMS services CIB ● Input: List of (partial) addresses ETER Institution ● Output: [Address, lat/long, Postal EUPRO code, Country, NUTS, ...] JOREP LeidenRank ● Implemented by wrapping 3rd party MORE1 services Nano Firm ○ e.g. Google Geocoding API, Bing, Profile MapQuest, Yahoo! Place Finder, SIPER etc. VICO

Geo-coding http://lda-apps.risis.ops.few.vu.nl/geocode/{address} For example: http://lda-apps.risis.ops.few.vu.nl/geocode/VU%20University%20Amsterdam

Reverse Geo-coding ● Converts geo coordinates to an address ○ can be a point or a polygon ● Provides additional validation opportunities. SMS services ● Input: List of geo-coordinates ● Output: [Address, Postal code, Country, NUTS, …]

Basic Geo Services Conversions between various Geo representations and classifications

NUTS Regions ● Hierarchy of NUTS regions ○ Available for download ○ Facilitates aggregation ■ e.g. Return all entities in a specified NUTS region, including all sub- regions ● Polygons ○ generated by EnAKTing project in 2011 ○ e.g. Netherlands ○ Facilitates integration ■ Return all entities whose geo coordinates fall inside a NUTS region ■ Return the NUTS region for a list of coordinates/addresses.

ISO 3166-2 ● 2 letter country codes ● Can be mapped to NUTS easily ○ First 2 NUTS characters are the ISO 3166-2 ○ UK is the exception (NUTS: UK , ISO: GB) ● Polygons for ISO 3162-2 are also available online ○ http://www.gadm.org/

LAU Regions - Local Administrative Unit - LAU-1 and LAU-2, previously called NUTS-4 and NUTS- 5 - low level administrative division of a country, ranked below a province, region, or state. - Important when analyzing OECD FUAs. - LAU-2, consists of municipalities or equivalent units in the 28 EU Member States - We are still negotiating to acquire shapefiles for LAU-1 and LAU-2

OECD Urban Functional Areas ● OECD.stat provides comprehensive statistics for each area ● ETL required to obtain geo polygons for these areas ○ (to the best of our knowledge)

Country Names ● Named Entity Recognition ○ e.g. DBPedia Spotlight ● DBPedia provides the ISO 3166-2 code for each country

Point to NUTS - For a given point, returns the associated NUTS region(s) - Example: http://api.risis.ops.few.vu.nl/PointToNUTS?long=4.865720&lat=52.333757

Point to NUTS http://lda-apps.risis.ops.few.vu.nl/PointToNUTS/4.8650/52.3339

Basic Geo Services Geographical boundary- related services