Montréal/Imports/Bornes de recharge publiques pour voitures électriques

From OpenStreetMap Wiki
Jump to navigation Jump to search

Montreal Circuit électrique chargers is an import of the City of Montreal's Bornes de recharge publiques pour voitures électriques dataset.

Goals

The goal is to import nodes for the above feature in cases where they are missing in the existing OSM data for the territory of the Urban agglomeration of Montreal. This import will also conflate the tag information for existing chargers with the data that will be obtained via the process described below. This amounts to 767 charger additions or modifications.

Import Data

Background

Data source sites: Bornes de recharge publiques pour voitures électriques
Data license: Licence d’utilisation des données ouvertes de la Ville de Montréal (note the section "Utilisation des données par OpenStreetMap").
Type of license: CC-BY-4.0.
Link to permission: Montréal/Imports/Ville de Montréal.
OSM attribution: Contributors (see "Montréal").
ODbL Compliance verified: yes.

Import Type

This is a one-time import that will be added to the OSM database via JOSM.

Data Preparation

Tagging Plans

The chargers have the following tags: access=yes, amenity=charging_station, brand=Circuit électrique, capacity=*, socket:<type>=* and socket:<type>:output=*.

Changeset Tags

Key Value
comment Import of public Circuit électrique chargers from the City of Montreal's dataset, with additional transformations and conflations.
import yes
source Ville de Montréal;Circuit électrique
source:url https://donnees.montreal.ca/dataset/bornes-recharge-publiques;https://lecircuitelectrique.com/fr/
source:date 2024
import:page https://wiki.openstreetmap.org/wiki/Montréal/Imports/Bornes_de_recharge_publiques_pour_voitures_électriques
source:license CC-BY-4.0

Data Transformation

Step by step instructions

  1. Import the Bornes de recharge publiques GEOJSON file.
  2. Save as GeoPackage in MTM 8.
  3. For chargers whose “NIVEAU_RECHARGE” field is “BRCC," find their exact wattage from the https://lecircuitelectrique.com/fr/ website. The others (“Niveau 2”) are 7.2.
  4. Run the Aggregate tool on the above layer. Aggregate based on “"LATITUDE" ||  "LONGITUDE.” In the aggregates field, leave only "ADDRESS," "NOM_PARC" and the power rating field (the string field created in step 3). Address will use "count" and the other two will use the "concatenate_unique" as their aggregate functions. The delimiter will be a semicolon. Change the name of these fields to “capacity,” “name” and “socket:type1:output” respectively.
  5. Create string fields for the following tags: amenity=charging_station, brand=Circuit électrique, access=public.
  6. Create a string field “socket:type1” and fill in its values such that they are identical to the “capacity” field (using the field calculator).
  7. Select the entries whose “socket:type1:output” does not contain 7.2 and export this selection.
  8. Change the name of the fields containing “type1” to instead contain “type1_combo” in place of the former.
  9. Duplicate these 2 newly-created fields, replacing “type1_combo” with “chademo.”
  10. In the file created in step 4, export the single entry containing 7.2 and another value in the “type1_combo” field.
  11. Correct the file exported just above manually, based on the information on the brand’s website.
  12. Export the entries containing only a 7.2 charger.
  13. Export the 3 most recent files created as geojson files in WGS 84. Do not export the FID and name fields. (The latter was dropped as it may cause confusion; many stations are named after addresses and the brand's naming conventions are not consistent).

Data Merge Workflow

Workflow

Step by step instructions

  1. Open the 3 files from step 13 in JOSM and delete all relations.
  2. Create a new layer and merge the 3 others into it. Save as an osm xml.
  3. Using overpass, import all charging_station amenities for the relevant extent.
  4. Using the conflation plugin, freeze all points of the layer created in step 2 as the reference. As the subject, freeze all points from step 3. Method: one-to one. Centroid: < 55. Merge all tags, overwriting without confirmation.
  5. Conflate matches.
  6. Select nodes in reference only and conflate those too.

Changeset size policy

In JOSM, upload objects in chunks of size: 9000.

Revert plans

If ever something goes wrong, the JOSM/Plugins/Reverter plugin will be used.

Conflation

Please see the step by step instructions above.

See also

A related post, about a more complex import from the same source, was sent to the community forum on 2024-01-29 and can be found here.

Retrieved from "https://wiki.openstreetmap.org/w/index.php?title=Montréal/Imports/Bornes_de_recharge_publiques_pour_voitures_électriques&oldid=2671183"