Sardegna/Import/Address import for Sardinia 2
About
This page talks about importing addresses using the data provided by the Autonomous Region of Sardinia (Italy).
The import has been announced in the Talk-IT ad Talk-IT-Sardinia ML.
Import Plan Outline
Goals
The goal is to use the high-quality dataset provided by the Sardinia Region in order to steadily improve the addresses available in OSM, covering 278 cities/towns/areas that didn't have available data when the previous import was done.
Schedule
TBD.
Import Data
Background
Address format in Sardinia database
House numbering in Sardinia follows the European scheme.
An address in Sardinia is composed by housenumber, street name, city name and postcode.
Tagging Plans
The data is presented as a shapefile.
The shapefile will be converted to OSM XML using QGIS and then Josm. The projection is correctly detected automatically as EPSG:4326 (WGS84 latitude-longitude).
The tags that will be used in the final upload are addr:housenumber, addr:street, addr:postcode and addr:city.
Legal
Data source site: https://webgis2.regione.sardegna.it/geonetwork/srv/ita/catalog.search#/metadata/R_SARDEG:72d1e3b0-c5e4-4a8d-9c35-3223720248c5
Openstreetmap Foundation was explicitely authorized by the copyright owner to use and import all the data of Sardegna Geoportale:
https://wiki.openstreetmap.org/w/images/7/77/Autorizzazione_sardegna_openstreetmap.pdf
Import Type
The dataset will be imported in 278 changesets.
The datasets will be loaded in JOSM and they will be merged with existing OpenStreetMap data manually and prior to the upload.
Data Preparation
Tagging Plans
The data is presented as a shapefile. This shapefile consists in a collection of punctual elements, one for each housenumber.
The shapefile will be converted to EPSG:4326 (WGS84 latitude-longitude).
The tags that will be used in the final upload are addr:housenumber, addr:street, addr:postcode and addr:city.
Dedicated upload account
The account l2212_Import will be used to upload the imported data.
Changeset Tags
Changeset will be tagged with source=Regione Autonoma della Sardegna.
Data Transformation
The street and city/town names will be normalized using QGIS and the following keys will be renamed to follow OSM's tags:
COMUNE -> addr:city
NOME -> addr:street
NUMERO-> addr:housenumber
The other ones will be deleted.
The generated file will be manually edited to correct errors (i.e.: normalization failures, apostrophes instead of accents, person spelled with surname + name instead of name + surname, misspelled names, etc), then transformed into a series of files (following the DBGT_CU3 list of the data missing until 2013) that will be imported in Josm, where the addr:postcode tag will also be manually added.
Data Merge Workflow
Addresses already in OSM will be extracted using the following Overpass query wizard:
"addr:housenumber" = * in CITY NAME
Addresses already present will be merged manually.
In case of import problem the changeset will be reverted using the JOSM Reverter Plugin
QA Assurance
It will be used the Coloured Street Plugin for JOSM and OSM Inspector for correcting/adding the missing streets name and checking existing data against the imported one.
Sample data
Here is sample data of the final product of conversion.
Table of addresses to import
| Name | Changeset |
|---|---|
| Abbasanta | |
| Aggius | |
| Aidomaggiore | |
| Alà dei Sardi | |
| Albagiara | |
| Ales | |
| Alghero EXTRAURBANO | |
| Allai | |
| Anela | |
| Arborea CENTRO IL SASSU | |
| Arbus INGURTOSU | |
| Ardara | |
| Aritzo | |
| Armungia | |
| Arzana | |
| Assolo | |
| Asuni | |
| Atzara | |
| Austis | |
| Ballao | |
| Banari | |
| Baradili | |
| Baratili San Pietro | |
| Baressa | |
| Barrali | |
| Barumini | |
| Bauladu | |
| Belvì | |
| Benetutti | |
| Berchidda | |
| Bessude | |
| Bidonì | |
| Birori | |
| Bitti | |
| Bolotana | |
| Bonarcado | |
| Bonnanaro | |
| Bono | |
| Bonorva | |
| Borore | |
| Bortigali | |
| Bortigiadas | |
| Borutta | |
| Bottidda | |
| Buddusò | |
| Bultei | |
| Bulzi | |
| Burgos | |
| Busachi | |
| Calangianus | |
| Carbonia INTEGRAZIONI | |
| Cargeghe | |
| Castiadas INTEGRAZIONI | |
| Cheremule | |
| Chiaramonti | |
| Codrongianos | |
| Collinas | |
| Cossoine | |
| Cuglieri INTEGRAZIONI | |
| Curcuris | |
| Desulo | |
| Domusnovas | |
| Donori | |
| Dualchi | |
| Elini | |
| Erula | |
| Escalaplano | |
| Escolca | |
| Esporlatu | |
| Esterzili | |
| Florinas | |
| Fluminimaggiore INTEGRAZIONI | |
| Fonni | |
| Fordongianus | |
| Gadoni | |
| Gairo INTEGRAZIONI | |
| Gavoi | |
| Genoni | |
| Genuri | |
| Gergei | |
| Gesico | |
| Gesturi | |
| Ghilarza | |
| Giave | |
| Goni | |
| Gonnoscodina | |
| Gonnosfanadiga | |
| Gonnosnò | |
| Gonnostramatza | |
| Guamaggiore | |
| Guasila | |
| Guspini | |
| Iglesias SAN BENEDETTO | |
| Ilbono | |
| Illorai | |
| Isili | |
| Ittireddu | |
| Ittiri | |
| Jerzu | |
| Laconi | |
| Laerru | |
| Las Plassas | |
| Lei | |
| Loceri | |
| Lodè | |
| Loiri Porto San Paolo INTEGRAZIONI | |
| Lula | |
| Lunamatrona | |
| Luogosanto | |
| Luras | |
| Macomer | |
| Mamoiada | |
| Mandas | |
| Mara | |
| Marrubiu EXTRA URBANO | |
| Martis | |
| Masullas | |
| Meana Sardo | |
| Milis | |
| Mogorella | |
| Mogoro | |
| Monteleone Rocca Doria | |
| Monti | |
| Montresta | |
| Mores | |
| Musei | |
| Narbolia INTEGRAZIONI | |
| Narcao | |
| Neoneli | |
| Noragugume | |
| Norbello | |
| Nughedu San Nicolò | |
| Nughedu Santa Vittoria | |
| Nule | |
| Nulvi | |
| Nuoro EXTRA URBANO | |
| Nuragus | |
| Nurallao | |
| Nuraminis | |
| Nureci | |
| Nurri | |
| Nuxis | |
| Olbia EXTRA URBANO | |
| Ollastra | |
| Ollolai | |
| Olmedo | |
| Olzai | |
| Onanì | |
| Oniferi | |
| Orani | |
| Orgosolo | |
| Orosei SAS MANCAS | |
| Orroli | |
| Ortacesus | |
| Ortueri | |
| Orune | |
| Oschiri | |
| Osidda | |
| Osilo | |
| Osini | |
| Ossi | |
| Ovodda | |
| Ozieri | |
| Pabillonis | |
| Padria | |
| Padru | |
| Palmas Arborea Tiria | |
| Pattada | |
| Pau | |
| Pauli Arbarei | |
| Paulilatino | |
| Perdasdefogu | |
| Perfugas | |
| Pimentel | |
| Piscinas | |
| Ploaghe | |
| Pozzomaggiore | |
| Putifigari | |
| Riola Sardo | |
| Romana | |
| Ruinas | |
| Sadali | |
| Sagama | |
| Samassi | |
| Samatzai | |
| Samugheo | |
| San Basilio | |
| San Gavino Monreale | |
| Sanluri SAN MICHELE | |
| San Nicolò D'Arcidano | |
| San Nicolò Gerrei | |
| Santadi | |
| Santa Maria Coghinas BURONI | |
| Sant'Andrea Frius | |
| Sant'Antonio di Gallura | |
| Santa Teresa di Gallura CAPITZA DI VACCA | |
| San Teodoro Sitagliacciu | |
| Santu Lussurgiu | |
| San Vero Milis | |
| Sardara | |
| Sarule | |
| Sassari EXTRA URBANO | |
| Scano di Montiferro | |
| Sedilo | |
| Sedini | |
| Segariu | |
| Selegas | |
| Semestene | |
| Seneghe | |
| Senis | |
| Sennariolo | |
| Senorbì | |
| Serramanna INTEGRAZIONI | |
| Serrenti | |
| Serri | |
| Setzu | |
| Seui | |
| Seulo | |
| Siamaggiore | |
| Siamanna | |
| Siapiccia | |
| Siddi | |
| Silanus | |
| Siligo | |
| Siliqua | |
| Silius | |
| Simala | |
| Simaxis | |
| Sindia | |
| Sini | |
| Siniscola INTEGRAZIONI | |
| Sinnai SAN GREGORIO | |
| Siris | |
| Siurgus Donigala | |
| Solarussa | |
| Sorgono | |
| Sorradile | |
| Suelli | |
| Tadasuni | |
| Talana | |
| Telti | |
| Tempio Pausania EXTRA URBANO | |
| Tertenia INTEGRAZIONI | |
| Teti | |
| Tiana | |
| Tissi | |
| Tonara | |
| Torralba | |
| Tratalias Vecchia | |
| Triei INTEGRAZIONI | |
| Tuili | |
| Tula | |
| Turri | |
| Ulassai | |
| Ula Tirso | |
| Uras | |
| Uri | |
| Urzulei | |
| Usellus | |
| Usini | |
| Ussaramanna | |
| Ussassai | |
| Vallermosa | |
| Viddalba EXTRA URBANO | |
| Villacidro | |
| Villagrande Strisaili | |
| Villamar | |
| Villamassargia | |
| Villanovaforru | |
| Villanovafranca | |
| Villanova Truschedu | |
| Villanova Tulo | |
| Villaperuccio | |
| Villasalto | |
| Villa Sant'Antonio | |
| Villaurbana | |
| Villa Verde | |
| Zeddiani | |
| Zerfaliu |