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 - - PowerPoint PPT Presentation

▶
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
SMART_READER_LITE
LIVE PREVIEW

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 - - PowerPoint PPT Presentation

Jan 24, 2023 337 likes •604 views

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 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 D E S I G N E D B Y R U N N I N G O N Read and Write Linked Data Triple Store with

slide-1
SLIDE 1

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

slide-2
SLIDE 2

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

slide-3
SLIDE 3

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

slide-4
SLIDE 4

A B O U T E N E L O P E N D ATA

  • Launched in 2011 among the first business
  • rganisations 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)

slide-5
SLIDE 5

D ATA . E N E L . C O M

slide-6
SLIDE 6

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

slide-7
SLIDE 7

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 RY 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

  • n

t h e w e b m a c h i n e r e a d a b l e n

  • n

p r

  • p

r i e t a r y f

  • r

m a t

slide-8
SLIDE 8

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 WA 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 & P E 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

slide-9
SLIDE 9

E N E L D R I V E O N O S M

slide-10
SLIDE 10

E N E L D R I V E O N C H A R G E M A P

slide-11
SLIDE 11

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

slide-12
SLIDE 12

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

  • n

t h e w e b m a c h i n e r e a d a b l e n

  • n

p r

  • p

r i e t a r y f

  • r

m a t u s e U R I t

  • d

e n

  • t

e t h i n g s l i n k

  • t

h e r d a t a

slide-13
SLIDE 13

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
slide-14
SLIDE 14

E N E L D R I V E O N D ATA H U B . I O

slide-15
SLIDE 15

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 6

U R I :

slide-16
SLIDE 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 RY 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 6

U 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/

  • ntology#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

slide-17
SLIDE 17

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 6

U 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 E

U R L :

slide-18
SLIDE 18
  • 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 ?

slide-19
SLIDE 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 )

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

U 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 E

U 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"

slide-20
SLIDE 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 # 1 / 3

SELECT (COUNT(?s) as ?count) WHERE { ?s <http://www.geonames.org/

  • ntology#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 RY S PA R Q L Q U E RY A N S W E R / R E S U LT S

slide-21
SLIDE 21

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/

  • ntology#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 RY S PA R Q L Q U E RY A N S W E R / R E S U LT S

slide-22
SLIDE 22

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 RY

lat = 41.828045, lon = 12.475665

slide-23
SLIDE 23

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 RY

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

slide-24
SLIDE 24

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

  • ccupied,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

slide-25
SLIDE 25

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 Web Service Response Parse Web Service Response

Charging Stations

(Web Service Siemens)

Charging Stations WS to CSV/XML

(enel-charging-stations) email RDF import API

Open Data

(enel-opendata)

data.enel.com OpenStreetMap Importer

(osm-importer)

Google Places foursquare RDF

(4sq) email csv

Legacy Processing Publishing

slide-26
SLIDE 26

@ R C I R U L L O

Thank You