Visualizing EV Charger data in Hong Kong

Hi data geeks, I have been look at the electric vehicle charging stations in Hong Kong, and find out that the government kindly offer an .xls file for all the stations at the moment, seems we can do better than that.

Any ideas on how to visualizing it?

The data is at: https://www.epd.gov.hk/epd/sites/default/files/epd/english/environmentinhk/air/prob_solutions/files/EV_Charger_Locations_eng_01.xls

This is cool, where did you find this?

It’s not the most open data, because it’s not directly machine-readable, but better than nothing.

Do you know what the columns mean?

How similar is the data to that here: https://data.gov.hk/en/geospatial-data? (Look under the Transport category).

It only provides 12 entry of EV stations somehow…thou they have a csv format and even have the api builder

Which one has 12 entries? data.gov.hk? They do seem to have available Details and Locations and so on for each language :man_shrugging:

Just quickly looked it up… and I think it’s seems to be inconsistent with the epd excel too

I see what’s going on… You’re choosing “Details of HK Electric EV charging stations” from Hong Kong Electric, which does indeed only have 12 stations from Hong Kong Island. How about when you select “Electric vehicle charging station locations” from CLP?

1 Like

Of course the URL to opendata.clp.com.hk doesn’t work, at all.

CLP data doesn’t include other chargers like Tesla Superchargers, and vice versa…hence I am looking into EPD data which in theory should have catch all chargers in HK

Edit: Actually the CLP data included Tesla Charging stations too…but there is a bigger problem, seems like the CLP and even EPD data is not matching with the ones on Tesla official website (e.g. missing some locations, inconsistent number of charging stations, etc.)

Where’s the Tesla data?

And can you access CLP data from their own site?

I just look up on Tesla website one by one and seems its not matching with the EPD data.

CLP data is only avalialbe on their website, just that not in a programming friendly way https://services.clp.com.hk/ev/en/charginglocations.html

1 Like

Well done for finding the CLP data, I didn’t succeed even with my Google skillz.

It would be instructive and also fun to compare and contrast the data from the different sources…

Hi
For your information I asked the HK gov about this in June. They answered that they will be working to make it available on geodata.gov.hk

The conversation is here: https://accessinfo.hk/en/request/access_to_mapgovhk_datasets_thro

1 Like

Thanks @alexvb, maybe this is related? (unfortunately accessinfo.hk is down right now, I’ll go kick the maintainer to reboot the server…)

Also find this site: https://www.hkev.com.hk/echargemain_20200305/charger?group=all&lang=en_HK

They listed their charing network.

@morriswong @gfreeman
Try this api I extracted from the CLP website:
https://services.clp.com.hk/api/CLPEVCharger/GetLevel3List?latitudeCenter=22.297969&longitudeCenter=114.180264&distance=200&lang=en&_=1584516907875

Better use this cURL command

curl --location --request GET 'https://services.clp.com.hk/api/CLPEVCharger/GetLevel3List?latitudeCenter=22.297969&longitudeCenter=114.180264&distance=200&lang=en&_=1584516907875' \
--header 'Connection: keep-alive' \
--header 'Accept: application/json, text/javascript, */*; q=0.01' \
--header 'Sec-Fetch-Dest: empty' \
--header 'X-Requested-With: XMLHttpRequest' \
--header 'User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.132 Safari/537.36' \
--header 'Sec-Fetch-Site: same-origin' \
--header 'Sec-Fetch-Mode: cors' \
--header 'Referer: https://services.clp.com.hk/ev/en/charginglocations.html' \
--header 'Accept-Language: en-GB,en-US;q=0.9,en;q=0.8' \
--header 'Cookie: __cfduid=d5ae7f1693c9cfaaa48838c635ea301e11584516035; ARRAffinity=c316b79358718a752538ffa6621972c5a36ea186e4a6a689553da2060203a405; _gcl_au=1.1.1350299740.1584516041; _ga=GA1.4.41536587.1584516041; _gid=GA1.4.1748160213.1584516041; clp_charginglocationpage=charginglocation; website#lang=en; _fbp=fb.2.1584516044225.502831705; ASP.NET_SessionId=fehbrw1yqqghkvguukzaxtln; mapview=map; _gat_UA-68003422-2=1'

It shows 176 locations.

I have used their list view to verify whether it is really 176 locations. Doing document.getElementsByClassName('thread') in the console shows 176 elements. So, I guess it is all the stations/

Within each location, there are multiple charging stations.

Here you can find (EPD)[https://www.epd.gov.hk/epd/english/environmentinhk/air/prob_solutions/promotion_ev.html) data.