Palma Street Map
This project consists of carrying out a street map of the city of Palma. In other words, all the house numbers and ways of the Majorcan capital will be added.
Goal
The goal of this project is to add all addresses to the length of the city of Palma. We have found a cartography in Open Street maps, which in appearance was hardly developed. In this way, through our data, plus the few that already existed within the program, it has been possible to import a more complete cartography towards the house numbers. Further on, routes will also be added to finish the street map. In addition, it will be updated and correcting the mistakes that occur throughout the development process.
Schedule
Firstly, data was loaded into OSM from Son Ferriol neighborhood, in the Levante district of Palma, including 1,765 nodes.Subsequently, a massive load of data from Palma will be carried out, which will have to be uploaded in parts, due to the load limit of Open Street Maps. In this way, they will look at distributing through an ID or through neighborhoods.
Methodology
The methodology that has been carried out in this project has started from the layer of portals and neighborhoods that we have in the database. From this moment we have started working with these two layers, creating a model in the QGIS sig tool. The first step was to make a cut, dividing the upload into neighborhoods since there are many portals and not all of them could be exported in Open Street Maps, since it only allows us to upload a maximum of 8,000 portals in each upload. This includes that in some districts of Palma, loads have been uploaded in three times.
Once this is done we proceed to create columns with the labels that structure our portals, between them unions will be created through the properties of the layer that interest us, this will allow us to complete the different labels. Right after this, you have to make some name changes to the columns, and convert the geometry from lines to points, with the layer format in GeoJSON, so that it is compatible when exporting to Javade OSM, so that you can then be treated. Once we have the attribute tables made, we pass it to Java, and there we will eliminate duplicate portals and addresses that do not have streets assigned. In this way, this tool acts as a filter before uploading everything within Open Street Maps, thus completely reducing the number of errors that can be made.
The next step is that within Java we can upload the elements we want as long as we do not exceed the established limit, and with a clear organization to know which neighborhoods have been uploaded in each upload. Firstly, a reversal has been carried out with the portals that we uploaded as a test in the Son Ferriol neighborhood, subsequently the different uploads of the portals have been carried out within Open Street Maps. Finally, we went to observe and see if the upload that was made was correct, and if everything was in order within the program.
One detail to keep in mind is that of course small edits and updates can be made from the same editor that OSM offers us. Only in cases that involve a very high number of portals, it would be necessary to resort to the use of the Java program with its tools for reversing, validating and uploading data.
Import Data
Source: Institut Municipal d'Innovació (2023).
Data Description
Number of houses that come from the cartography section of the municipal innovation institute of the city council of Palma.
OSM Data Files
In the case of Palma, very few portals were located within Open Street Maps. Even so, they were not labeled as they appear in the tags that appear in our nodes.
House numbers
The house number data set consists of a layer with 62,182 nodes that covers both the urban, peri-urban and rural areas of the municipality. All this, in an area of 208.6 km².
Import Type
JOSM is the software programmed in Java for editing data in the OpenStreetMap project.
Data Preparation
Tagging Plans
Below, you can see the tags that follow each house number as nodes in the map:
- addr:city = Palma
- addr:country = ES
- addr:district = In the case of Palma, there are five districts: Nord, Ponent, Llevant, Centre and Platja de Palma
- addr:housenumber = Will contain the house number
- addr:province = Illes Balears
- addr:street = Must have the name of the streets
- addr:street_codeINE = INE road code
- addr:subdistrict = It has 89 neighborhoods divided among the five districts
- source = Institut Municipal d'Innovació (2023)