Ferry terminals with few fast chargers nearby

Ferry terminals with the fewest fast chargers nearby, every month.

MediumMonthly

Ports, shipping & maritimeMaritimeEnergy

Use this template

What it does

Every month: the ferry terminals in your region, each with the public fast chargers within 2 km from Open Charge Map, the ones with the fewest first, so the terminal team knows where drivers of electric cars cannot charge before or after the crossing, added to a sheet and mapped.

In one sentence: Monthly on the 1st at 08:00, in Oslo, Bergen and Stavanger, find ferry terminals in the area, count the EV charging stations within 2 km of each place, sort them by ev_stations and keep the top 20, then add row in Google Sheets, show them on a map and email the list to you.

Why it is useful

More passengers drive electric cars onto ferries each year. Terminals with no fast charger close by are where a charging partner is needed first.

Who it is for

Ports, shipping & maritime. Port operators, ship agents, marine suppliers, terminals and marinas following vessels, weather and the business around the water. Every use case for ports & shipping

Best use cases

  • A ferry operator
  • A port authority
  • A charging network looking for sites

What each run gives you

  • A Google Sheet
  • A map

The time it saves

Monthly on the 1st at 08:00. Doing the same work by hand takes about 40 minutes each time; it runs about 1 time a month, so it saves about 1 hours a month (an estimate). It is medium: 8 blocks.

The flow, block by block

  1. On the 1st of every monthTrigger · ScheduleStarts the flow on a timetable.
  2. Our regionWhere · Area of interestSets where the flow looks: countries, cities or specific places, or areas you draw on a map.
  3. Ferry terminalsxMap data · Nearby placesPlaces around a point from xMap’s own places database (300M+ places, refreshed every month): pick the types of place (more than 5,000, such as Restaurant, Cafe, Pharmacy, Hospital or Gas station, or a whole group of them) and how far to look.
  4. Fast chargers within 2 kmxMap data · EV chargingPublic charging stations for electric vehicles from Open Charge Map, the open, worldwide register: around each incoming place with counts (stations, charge points, fast stations, the highest power, the nearest and the main operators), or the stations themselves around places, in the Area of interest or around a point, each with its operator, connectors, power, status and address.
  5. The fewest fast chargers firstLogic · Sort and limitPuts the items in order, and can keep only the first ones: the 10 best rated, the 20 nearest, the highest fit scores.
  6. Update the terminal charging sheetApp · Google SheetsCreate, edit, and collaborate on spreadsheets online
  7. Show them on a mapAction · Show on a mapShows the results as points on a map, with the area of interest.
  8. Email me the resultsAction · EmailSends one email per run with all the items, or one email per item.

Every block can be changed after you use the template: the city, the type of place, the score, where the results go.

Use it now

Answer a few questions, enter your work email, and it runs in your own account, kept running until you pause it. Use this template.

How to set it up

More for Ports, shipping & maritime