linked open geodata for enel drive (w3c lod2014)
DESCRIPTION
Presenting Linked Open Data for Enel Electric Vehicle Charging Network. A solution developed for Enel Drive by Insideout10 using Redlink Linked Data publishing APIs. The triplification (transforming source legacy data in RDF triples) provides an information context around each stations and helps EV drivers locate a charging stations in various ways. The project wants to contribute to the development of electric mobility in ItalyTRANSCRIPT
L I N K E D O P E N D ATA F O R E N E L E L E C T R I F I E D V E H I C L E C H A R G I N G N E T W O R K
O P E N C O M PA N Y
D E S I G N E D B Y
!
• Read and Write Linked Data
• Triple Store with transactions, versioning and reasoning
• SPARQL and LDPath Query languages
• Transparent Linked Data caching
P O W E R E D B Y
R U N N I N G O N
E L E C T R I F I E D V E H I C L E ( E V ) P R O D U C T I O N 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
Q U I C K FA C T
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)
D ATA . E N E L . C O M
E N E L D R I V E
• 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
M A K I N G I N F O R M AT I O N A C C E S S I B L E T O C O N S U M E R S , I N D U S T R Y PA R T N E R S A N D G E N E R A L P U B L I C
P R O J E C T G O A L P H A S E 1
on the w
eb
mac
hine read
able
non pro
prieta
ry fo
rmat
O U T R E A C H A N D
C O M M U N I T Y
● P R O M O T I N G E N E L O N O P E N S T R E E T M A P W I K I ( 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 )
● S H A R I N G S O F T W A R E M O D U L E S A S O P E N S O U R C E O N G I T H U B
● 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 & PE R _ PA G E = 1 0 0 0 )
!
P U B L I S H I N G
● O P E N D ATA P U B L I S H I N G ( ) O N 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 /5 0 7 1 )
• C O N T R I B U T I N G T O O P E N S T R E E T M A P
P R O C E S S I N G● P R O D U C I N G A C S V F I L E O F A L L C H A R G I N G
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
W H AT W E H AV E D O N E - P H . 1
E N E L D R I V E O N O S M
E N E L D R I V E O N C H A R G E M A P
E N E L D R I V E O N C I T Y S D K P R O V I N C I A D I R O M A
A D D I N G A C O N T E X T B Y U S I N G T I M B E R N E R S -L 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 S O C I A L N E T W O R K S
P R O J E C T G O A L P H A S E 2
on the w
eb
mac
hine read
able
non pro
prieta
ry fo
rmat
use U
RI to d
enote th
ings
link o
ther d
ata
O U T R E A C H A N D
C O M M U N I T Y
• 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 ( 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 )
• E N G A G I N G W I T H T H E G R I D P E D I A C O M M U N I T Y F O R T H E O N T O L O G Y D E S I G N ( H T T P : / / G R I D P E D I A . O R G 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 / )
P U B L I S H I N G
● O P E N D ATA P U B L I S H I N G ( ) O N 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 /E N E L _ 0 0 0 0 0 5 7 6 )
• 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
E N A B L I N G C H E C K - I N S T O C O N S U M E R S
P R O C E S S I N G
● P R O D U C I N G A R D F D ATA E X P O R T ● A D D I N T E R L I N K I N G W I T H G E O N A M E S ● 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 • W O R K I N G O N T H E F I R S T M A S H U P S A N D
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 Q U E R I E S
!
W H AT W E H AV E D O N E - P H . 2
E N E L D R I V E O N D ATA H U B . I O
U S E U R I T O D E N O T E E A C H S TAT I O N
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 6U R I :
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 A N D L I N K I T T O G E O N A M E S
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 6U R I :
H T T P : / / S W S . G E O N A M E S . O R G / 6 5 4 1 8 6 3 /U R I : 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
C R E AT E A V E N U E I N F O U R S Q U A R 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 / E N E L _ 0 0 0 0 0 5 7 6U R I :
H T T P : / / S W S . G E O N A M E S . O R G / 6 5 4 1 8 6 3 /U R I :
H T T P : / / 4 S Q . C O M / 1 G Y Y B P EU R L :
• 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
… W H Y ?
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 )
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 6U R I :
H T T P : / / S W S . G E O N A M E S . O R G / 6 5 4 1 8 6 3 /U R I :
H T T P : / / 4 S Q . C O M / 1 G Y Y B P EU R L :
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"
A S K M E A N I N G F U L Q U E S T I O N S U S I N G S PA R Q L # 1 / 3
SELECT (COUNT(?s) as ?count) WHERE { ?s <http://www.geonames.org/ontology#parentADM2> <http://sws.geonames.org/3169069/> . }
How many are the EV Charging Stations in Provincia di Roma?
?count
142
N AT U R A L L A N G U A G E Q U E R Y
S PA R Q L Q U E R Y
A N S W E R / R E S U LT S
A S K M E A N I N G F U L Q U E S T I O N S U S I N G S PA R Q L # 2 / 3
SELECT * WHERE { ?s <http://www.geonames.org/ontology#parentADM1> <http://sws.geonames.org/2523119/> } LIMIT 100
List all the EV Charging Stations in Sicily?
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
….
N AT U R A L L A N G U A G E Q U E R Y
S PA R Q L Q U E R Y
A N S W E R / R E S U LT S
A S K M E A N I N G F U L Q U E S T I O N S U S I N G S PA R Q L # 3 / 3
List all EV Charging Station, in a radius of 5KM from Archivio Centrale di Stato and for each station provide show me the status?
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
A S K M E A N I N G F U L Q U E S T I O N S U S I N G 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.475665-xsd:float(?lon))*(0.639152916802137-(0.00802451*xsd:float(?lat))) < 0.002021949346180605736 ) . } ORDER BY ?distance LIMIT 20
A S K M E A N I N G F U L Q U E S T I O N S U S I N G 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
P U B L I S H I N G W O R K F L O W
LMF(Triple Store RDF)
Charging Stations CSV(data.enel.com)
OpenStreetMap
csv
Manual Curation(Bulk Claim)
csv
Parse WebService Response
Parse WebService Response
Charging Stations
(Web Service Siemens)
Charging StationsWS to CSV/XML
(enel-charging-stations)
RDFimport
API
Open Data(enel-opendata)
data.enel.com
OpenStreetMapImporter
(osm-importer)
Google Places
foursquare
RDF(4sq)
csv
Legacy Processing Publishing
Thank You