Intro

I bumped into an interesting overpass query by OSM mappers Musuruane and Albani which underline missing townhalls. How could I use this stuff? Coincidence (and considering that the italian opendata scenario is not particulary exciting) I was surprised to find the national Public Administration addresses dataset released in CC0 :-)

Preparing a manual import

Required:
* Public Administration (PA) offices dataset
* Openrefine tool

• Create Openrefine project from PA offices dataset. Filter as needed (ie: titolo_resp=”Sindaco” and Regione=Abruzzo)

• Generate Abruzzo municipalities without townhall with overpass-turbo query;
• find the link of “Exporting raw data directly from Overpass API”;
• copy&paste link in Openrefine Create project Web Addresses (URLs);
• apply cross table funtions as needed (ie: cell.cross(“Indice PA”, “Comune”)[0].cells[“Cap”].value
• Openrefine custom tabular export the file somewhere online;
• feed above file to umap remote data with useful tags displyed in popup (layer interaction)

Umap

Here you can find the resulting umap that is being used for add and detail missing municipality townhalls.
Blue layers are from PA (input) dataset. Red layers are on-the-fly OSM queries with missing townhalls.
You can clone it and expolre layers and its remote data used.

Importing

• In umap select useful layers and zoom in to display markers;
• find a missing townhall (red ball marker)
• click matching blue marker (candidate townhall) and copy tags;
• activate iD editor and paste tags accordingly;
• toggle blue layer to spot others and repeat.

Notes

Blue marker alone means townhall already in OSM, red marker alone, means no PA data available.

Remember to allow OSM and Overpass-turbo servers to update red layers (generally it takes less than a minute).

Use proprietary imagery just a generic guidance.