Originally published by Raffaele Cirullo (http://www.slideshare.net/cirullo/enel-drive-linked-open-geo-data) - the presentation describes the triplication (RDF publishing) of real-time data provided by Enel Drive: Italy's largest EV Charging network.
Using Redlink the information is shared in real-time as Linked Open Data. The data is also published to OpenStreetMap and foursquare.
Linked Open GeoData for Electric Vehicle Charging Stations by ENEL
1. O P E N C O M PA N Y
L I N K E D O P E N D ATA F O R
ENEL ELECTRIFIED VEHICLE
CHARGING NETWORK
2. DESIGNED BY
RUNNING ON
!
• Read and Write Linked Data
• Triple Store with transactions, versioning and
reasoning
• SPARQL and LDPath Query languages
• Transparent Linked Data caching
POWERED BY
3. Q U I C K FA C T
ELECTRIFIED VEHICLE (EV) PRODUCTION
F O R E C A S T T O J U M P 6 7 % G L O B A L LY I N 2 0 1 4
4. A B O U T E N E L O P E N D ATA
• Launched in 2011 among the first business
organisations investing in Open Data worldwide
“ S O M E L E A D I N G B U S I N E S S E S , L I K E E N E L , I TA LY ’ S
L A R G E S T P O W E R C O M PA N Y, A N D N I K E , A R E M O R E
P R O A C T I V E , P U B L I S H I N G T H E I R D A TA T O D E M O N S T R A T E
A C O M M I T M E N T T O T R A N S PA R E N C Y A N D
S U S TA I N A B I L I T Y ” D E L O I T T E O N O P E N D A TA I N 2 0 1 2
• 725 datasets (424 IT, 301 EN), 5 main categories
(FINANCE World, Finance Italy, SUSTAINABILITY,
ENVIRONMENT, TERRITORY)
6. ENEL DRIVE
• One of the largest EV
charging networks in
Europe
• 356 charging stations
installed in major italian
cities
• Multiple payment options
from single payment (credit
cards or pre-paid) to
monthly subscription
7. PROJECT GOAL PHASE 1
fo
rm
ta
ry
pr
op
rie
n
no
ne
hi
ac
m
on
th
e
we
b
re
a
da
bl
e
at
M A K I N G I N F O R M AT I O N
ACCESSIBLE TO
CONSUMERS,
I N D U S T R Y PA R T N E R S
AND GENERAL PUBLIC
8. W H AT W E H A V E D O N E - P H . 1
OUTREACH
AND
COMMUNITY
● PROMOTING ENEL ON OPENSTREETMAP WIKI
( H T T P : / / W I K I . O P E N S T R E E T M A P. O R G / W I K I /
E N E L _ O P E N _ D ATA )
● SHARING SOFTWARE MODULES AS OPEN SOURCE
ON GITHUB
● P R O M O T I N G T H E D ATA S E T O N C H A R G E M A P. C O M
( H T T P : / / C H A R G E M A P. C O M / N E T W O R K S / E N E L )
• P R O M O T I N G T H E D ATA S E T O N C I T Y S D K W I T H
P R O V I N C I A D I R O M A ( H T T P : / / D E V. C I T Y S D K M O B I L I T Y. P R O V I N C I A . R O M A . I T / M A P # N O D E S ?
L AY E R = E L E C T R I C . V E H I C L E . C H A R G I N G . S TAT I O N S & P
E R _ PA G E = 1 0 0 0 )
!
PUBLISHING
PROCESSING
● O P E N D ATA P U B L I S H I N G (
) ON
D ATA . E N E L . C O M ( H T T P : / / D ATA . E N E L . C O M / N O D E /
5071)
• CONTRIBUTING TO OPENSTREETMAP
● PRODUCING A CSV FILE OF ALL CHARGING
S TAT I O N S B Y PA R S I N G T H E W E B S E R V I C E R E S P O N S E
12. PROJECT GOAL PHASE 2
in
th
te
he
ot
k
lin
UR
It
o
rd
de
at
a
no
fo
rm
ta
ry
us
e
pr
op
rie
n
no
ne
hi
ac
m
on
th
e
we
b
re
a
da
bl
e
at
gs
ADDING A CONTEXT BY
USING TIM BERNERSL E E ’ S F I V E S TA R S L I N K E D
O P E N D ATA M O D E L A N D
L O C AT I O N B A S E D
SOCIAL NETWORKS
13. W H AT W E H A V E D O N E - P H . 2
• P R O M O T I N G T H E D ATA S E T O N O P E N D ATA H U B . I O
OUTREACH
AND
COMMUNITY
PUBLISHING
PROCESSING
( H T T P : / / D ATA H U B . I O / D ATA S E T / C H A R G I N G S TAT I O N S )
• ENGAGING WITH THE GRIDPEDIA COMMUNITY FOR
THE ONTOLOGY DESIGN (HTTP://GRIDPEDIA.ORG
H T T P : / / W W W. I Z E U S . K I T. E D U / E N G L I S H / )
● O P E N D ATA P U B L I S H I N G (
) ON
D ATA . E N E L . C O M ( I . E . H T T P : / / D ATA . E N E L . C O M / L M F /
M E TA / T E X T / H T M L / C H A R G I N G - S TAT I O N /
ENEL_00000576)
• P R O V I D I N G A S PA R Q L E N D P O I N T
• P U B L I S H I N G T H E D ATA O N F O U R S Q U A R E A N D
ENABLING CHECK-INS TO CONSUMERS
● P R O D U C I N G A R D F D ATA E X P O R T
● ADD INTERLINKING WITH GEONAMES
● E X P E R I M E N T I N G W I T H R E A L T I M E U P D AT E S O N T H E
O C C U PA N C Y O F T H E S TAT I O N
• WORKING ON THE FIRST MASHUPS AND
E X P E R I M E N T I N G W I T H F E D E R AT E D S PA R Q L
QUERIES
!
15. U S E U R I T O D E N O T E E A C H S TAT I O N
U R I : H T T P : / / D ATA . E N E L . C O M / L M F / M E TA / T E X T / H T M L / C H A R G I N G - S TAT I O N / E N E L _ 0 0 0 0 0 5 7 6
16. M A P E A C H S TAT I O N T O I T S T E R R I T O R Y
AND LINK IT TO GEONAMES
U R I : H T T P : / / D ATA . E N E L . C O M / L M F / M E TA / T E X T / H T M L / C H A R G I N G - S TAT I O N / E N E L _ 0 0 0 0 0 5 7 6
URI: HTTP://SWS.GEONAMES.ORG/6541863/
http://www.geonames.org/
ontology#alternateName
"リミニ"@ja
"리미니"@ko
"Ariminum"@la
"Lungsod ng Rimini"@tl
"Rímini"@ca
"Rímini"@es
"Riminis"@lt
"@"ریمینیfa
"@"ريمينيar
"@"רימיניiw
"Ρίμινι"@el
"Горад Рыміні"@be
"Римини"@bg
"Римини"@cv
"Римини"@kk
"Римини"@mk
"Римини"@os
"Римини"@ru
"Римини"@sr
"Ріміні"@uk
"!"#"$""@ka
"里米尼"@zh
17. C R E AT E A V E N U E I N F O U R S Q U A R E
U R I : H T T P : / / D ATA . E N E L . C O M / L M F / M E TA / T E X T / H T M L / C H A R G I N G - S TAT I O N / E N E L _ 0 0 0 0 0 5 7 6
URI: HTTP://SWS.GEONAMES.ORG/6541863/
URL: HTTP://4SQ.COM/1GYYBPE
18. …WHY
?
• Having Consumers GeoTag and Recommend their favorite
charging stations (like the City of Paris did for its bike sharing
Vélib’)
• Having Consumers Share where they go charging using their
EV
• Providing suggestions on charging locations based on
friends’ check-ins (converting foursquare data in RDF)
• Engaging with Consumers to encourage the adoption of
eMobility
19. A D D R E A L - T I M E D ATA O N S TAT I O N
O C C U PA N C Y A S L I N K E D D ATA ( E X P E R I M E N TA L )
U R I : H T T P : / / D ATA . E N E L . C O M / L M F / M E TA / T E X T / H T M L / C H A R G I N G - S TAT I O N / E N E L _ 0 0 0 0 0 5 7 6
URI: HTTP://SWS.GEONAMES.ORG/6541863/
URL: HTTP://4SQ.COM/1GYYBPE
ex:chargingstation01 gridpedia:dataFlow
_:infoRelation01
_:infoRelation01 gridpedia:data ex:chargingStatus01
ex:chargingStatus01 rdf:type
gridpedia:ChargingStationStatus
ex:chargingStatus01 gridpedia:status "empty"
ex:chargingStatus01 gridpedia:error "false"
20. ASK MEANINGFUL QUESTIONS USING
S PA R Q L # 1 / 3
N AT U R A L L A N G U A G E Q U E R Y
How many are the EV Charging Stations in Provincia di Roma?
S PA R Q L Q U E R Y
SELECT (COUNT(?s) as ?count) WHERE { ?s
<http://www.geonames.org/
ontology#parentADM2>
<http://sws.geonames.org/3169069/> . }
A N S W E R / R E S U LT S
?count
142
21. ASK MEANINGFUL QUESTIONS USING
S PA R Q L # 2 / 3
N AT U R A L L A N G U A G E Q U E R Y
List all the EV Charging Stations in Sicily?
S PA R Q L Q U E R Y
SELECT * WHERE {
?s <http://www.geonames.org/
ontology#parentADM1>
<http://sws.geonames.org/2523119/> }
LIMIT 100
A N S W E R / R E S U LT S
http://data.enel.com/LMF/resource/punto-enel/Punto_indiretto_Sicilia_990
http://data.enel.com/LMF/resource/punto-enel/Punto_indiretto_Sicilia_906
http://data.enel.com/LMF/resource/punto-enel/Punto_indiretto_Sicilia_907
http://data.enel.com/LMF/resource/punto-enel/Punto_indiretto_Sicilia_992
http://data.enel.com/LMF/resource/punto-enel/Punto_indiretto_Sicilia_908
http://data.enel.com/LMF/resource/punto-enel/Punto_indiretto_Sicilia_991
http://data.enel.com/LMF/resource/punto-enel/Punto_indiretto_Sicilia_909
http://data.enel.com/LMF/resource/punto-enel/Punto_indiretto_Sicilia_994
http://data.enel.com/LMF/resource/punto-enel/Punto_indiretto_Sicilia_993
….
22. ASK MEANINGFUL QUESTIONS USING
S PA R Q L # 3 / 3
N AT U R A L L A N G U A G E Q U E R Y
lat = 41.828045, lon = 12.475665
List all EV Charging Station,
in a radius of 5KM from Archivio Centrale di Stato and
for each station provide show me the status?
23. ASK MEANINGFUL QUESTIONS USING
S PA R Q L # 3 / 3
S PA R Q L Q U E R Y
PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX gp: <http://gridpedia.org/id/>
PREFIX vcard: <http://www.w3.org/2006/vcard/ns#>
SELECT ?status ?address ( ( (41.828045-xsd:float(?lat))*(41.828045-xsd:float(?lat)) + (12.475665-xsd:float(?
lon))*(12.475665-xsd:float(?lon))*(0.639152916802137-(0.00802451*xsd:float(?lat))) ) AS ?distance) ?s
WHERE {
?s geo:lat ?lat ;
geo:long ?lon ;
rdfs:label ?label ;
gp:dataFlow [
gp:data [
a gp:ChargingStationStatus ;
gp:status ?status
]
];
vcard:hasAddress [
a vcard:Work ;
vcard:street-address ?address
].
FILTER( (41.828045-xsd:float(?lat))*(41.828045-xsd:float(?lat)) + (12.475665-xsd:float(?lon))*(12.475665xsd:float(?lon))*(0.639152916802137-(0.00802451*xsd:float(?lat))) < 0.002021949346180605736 ) .
}
ORDER BY ?distance
LIMIT 20
24. ASK MEANINGFUL QUESTIONS USING
S PA R Q L # 3 / 3
A N S W E R / R E S U LT S
unavailable,Viale Europa incrocio Via dell’Arte,3.2291443E-6,http://data.redlink.io/353/charging-station/EnEnergia_00000051
available,Viale Europa incrocio Via dell'Arte,3.2949167E-6,http://data.redlink.io/353/charging-station/EnEnergia_00000049
available,Viale dell'Aeronautica,4.6743426E-6,http://data.redlink.io/353/charging-station/ENEL_00000524
available,Viale dell'Aeronautica 106-126,5.626282E-6,http://data.redlink.io/353/charging-station/ENEL_00000107
available,Piazza dell'Umanesimo 10,4.100938E-5,http://data.redlink.io/353/charging-station/EnEnergia_00000007
available,Viale Europa incrocio Largo Apollinare,6.833275E-5,http://data.redlink.io/353/charging-station/ENEL_00000473
available,Viale Europa incrocio Largo Apollinare,7.2549956E-5,http://data.redlink.io/353/charging-station/ENEL_00000489
available,Viale Egeo,1.2500337E-4,http://data.redlink.io/353/charging-station/ENEL_00000122
available,Viale Egeo,1.2808524E-4,http://data.redlink.io/353/charging-station/ENEL_00000123
available,Via Marco e Marcelliano 2-32,0.0010066022,http://data.redlink.io/353/charging-station/ENEL_00000294
available,Via Marco e Marcelliano 4,0.0010115263,http://data.redlink.io/353/charging-station/ENEL_00000390
available,Piazzale Cina,0.0010116658,http://data.redlink.io/353/charging-station/ENEL_00000058
available,Via Giovanni Genocchi 10,0.0011051926,http://data.redlink.io/353/charging-station/ENEL_00000316
available,Via Giovanni Genocchi 10,0.0011055052,http://data.redlink.io/353/charging-station/ENEL_00000374
available,"Via Salvatore Rebecchini, 5",0.0013722803,http://data.redlink.io/353/charging-station/ENEL_00000306
available,"Via Salvatore Rebecchini, 5",0.0013728689,http://data.redlink.io/353/charging-station/ENEL_00000546
available,Via Ostiense 129,0.001399242,http://data.redlink.io/353/charging-station/ENEL_00000311
occupied,via Ostiense 129,0.0014883887,http://data.redlink.io/353/charging-station/EnEnergia_00000014
available,Via Usodimare Antoniotto 14,0.0016726367,http://data.redlink.io/353/charging-station/ENEL_00000475
available,Via Capitan Bavastro 94,0.0017357481,http://data.redlink.io/353/charging-station/ENEL_00000666
available,Via di Capitan Bavastro 94,0.0017357481,http://data.redlink.io/353/charging-station/ENEL_00000304
available,Via Cristoforo Colombo 44,0.0018101211,http://data.redlink.io/353/charging-station/ENEL_00000482
available,Via Cristoforo Colombo 44,0.0018101211,http://data.redlink.io/353/charging-station/ENEL_00000476
25. PUBLISHING WORKFLOW
Legacy
Processing
Publishing
data.enel.com
Charging
Stations
(Web Service Siemens)
Parse Web
Service Response
Charging Stations
WS to CSV/XML
csv
(enel-charging-stations)
Parse Web
Service Response
csv
csv
Charging
Stations CSV
Open Data
(enel-opendata)
(data.enel.com)
RDF
(4sq)
RDF
import
OpenStreetMap
Importer
API
(osm-importer)
Manual
Curation
(Bulk Claim)
email
email
LMF
(Triple Store RDF)
OpenStreetMap
Google Places
foursquare