Barcelona Fountains Import

Goals

The goal is to import and update the fountains (drinking and ornamental) from the Barcelona City Council database. In Barcelona there were 748 drinking fountains and 64 ornamental fountains already in OSM. As the nodes to import have no useful information other than the coordinates, it made no sense to merge them. So we did not import those.

Import Data

Data description

The original dataset is csv format. It includes a total of 1,988 spots, which includes 1,676 water drinking fountains and 312 ornamental fountains. We'll use the csv file for processing. You can download the data here. We verified the data quality using our city knowledge, Mapilliary and orthophotos (PNOA and Bing).

Background

ODbL Compliance verified: YES The license can be consulted here. It requires attribution of the source, so all nodes and the changeset will include source=Ajuntament de Barcelona. The Barcelona City Council (Ajuntament de Barcelona) is already on the contributors list.

The autorisation for the use of all the data in the Portal Open Data BCN (open data portal) can be consulted here.

Import Type

The import will be done manually, using the Tasks Manager, so it can be assigned to different volunteers.

First import data preparation

Data Reduction & Simplification

As mentioned before, the data file we have chosen is in csv format. Some corrections are part of the data conversion script. Some of the fields aren't relevant and will be ignored.

Tagging plans

Here are the original fields, their meaning and how they will be converted to the resulting OSM file:

Original Fields	Meaning	OSM tag	Comments
INVENTARI_CODI	Internal reference number
INVENTARI_NOM	Internal reference name
INVENTARI_TIPUS	Amenity
INVENTARI_CARRER	Street
INVENTARI_NUMERO_CARRER	House number
INVENTARI_COORDENADA_X	X coordinates (EPSG:25830 and EPSG:23030)	X
INVENTARI_COORDENADA_Y	Y coordinates (EPSG:25830 and EPSG:23030)	Y

To all the nodes, we will add the following tags:

• amenity=drinking_water

• source:date=2018-11-13

• source=Ajuntament de Barcelona(link)

• operator= Ajuntament de Barcelona(link)

Changeset tags

We will use the following changeset tags:

·        comment=#Barcelona_drinking_water_import and any notes that the mapper may add.

·        source= Ajuntament de Barcelona(link)

·        source:date=2018-11-13

·        import=yes

·        url=Barcelona Fountains Import (this page)

·        created_by=JOSM/version (This tag is created automatically by JOSM)

Data Transformation

Data is in csv format. We already:

1.   Downloaded the data