Users' diaries

Recent diary entries

Sulawesi - Indonesia

Posted by SebiTitzler on 5 October 2018 in German (Deutsch)

Please help mapping out west-central Sulawesi. Countryside still poorly mapped. Help urgently needed!

Integration von OSM-Daten in einer DB mit Historie (Vergangenheits Daten & Aktualisierungen)

Posted by benjagu85 on 5 October 2018 in German (Deutsch)

Hallo zusammen,

ich beschäftige mich erst seit ein paar Wochen mit OSM.

Bisher habe ich 2 verschiedene Importierungen (OSM2msSQL & OSM2PGSQL mit Osmosis) für OSM durchgeführt. Beim zweit genannten bin ich noch dabei. Ich möchte letztenendes eine DB aufbauen in der historische, und aktuelle Informationen vorliegen um darauf z.B. Analysen durchzuführen. Hat sich jemand von euch bereits mit einem ähnlichen Thema beschäftigt oder kennt Projekte die das gleiche Ziel verfolgen? Im Voraus vielen Dank für eure Hilfe und Gruß!

My edits in Bergen County, part 3

Posted by ComBlOp on 4 October 2018 in English (English)

I just finished mapping River Edge today! It was pretty quick compared to Paramus and Alpine, Alpine being 5x larger by area and Paramus 8x.

While mapping River Edge, I also decided to go finish mapping Teterboro, which was already practically done. A few buildings, areas, and airport grass were some of the things I added there.

Next up is Palisades Park. I really love Palisades Park. Super dense, it looks pretty good there. I have some eighth grade memories there, and I love those times. I wish I could go there a lot more often.

I will probably do Hackensack next. After that, I probably will start mapping in more countries than just the United States. I'm really looking forward to that!

I'm also pretty happy with my ranking on HDYC-currently 14 in the United States. Additionally, I hit 400 edits a few days ago! I'm making a lot of edits real quickly, and this will hopefully continue. Look at Bergen County now, and you can see the improvement on the map.

You can click below to see River Edge:

Location: Cherry Hill, Bergen County, New Jersey, 07661, USA


Posted by Tara Ghadimi on 4 October 2018 in Abkhazian (Аҧсуа)

dear diary,

i love mapping and rapping. geography is key to happiness N MY MENTALITY


Projeto Nomeia Cep Recife - Inclusão de CEP´S Nos Bairros do Recife Conforme o CNEFE

Posted by raphaelmirc on 4 October 2018 in Brazilian Portuguese (Português do Brasil)

Continuando com a Inclusão dos Cep´s conforme o CNEFE.

Hoje fiz a Inclusão de Cep´s nos Bairros do Porto da Madeira, Alto do Mandu, Alto José bonifacio, Prado, Apipucos, Arruda, Alto santa teresinha e Fundão.

Todos os Bairros na Cidade do Recife/PE.

Ate a proxíma inclusão

Raphael Assis.

Location: Santo Antônio, Recife, Microrregião de Recife, Região Metropolitana de Recife, Mesorregião Metropolitana de Recife, Pernambuco, Região Nordeste, Brasil

Atualização dos dados do Projeto Mapeia Cep OSM Recife 2018.

Posted by raphaelmirc on 4 October 2018 in Brazilian Portuguese (Português do Brasil)

Bom dia Mapeadores,

Hoje atualizei a lista dos bairros que estão sendo Mapeadas com a inserção dos Cep´s na Cidade do Recife.

Para acompanhar a lista dos bairros e como consultar e só acessar o link a seguir;

Pagina do Projeto Mapeia Cep Recife/OSMPagina do Wiki

Para contato e participar do projeto ou conhecer pessoas que são mapeadores e só entrar na nossa Sala no Telegram, no seguinte link.OSM_PE

Um forte abraço e ate mais.

Raphael de Assis Mapeador de Recife/PE.

Location: São José, Recife, Microrregião de Recife, Região Metropolitana de Recife, Mesorregião Metropolitana de Recife, Pernambuco, Região Nordeste, Brasil

Inclusão de CEP´S Na BR-101 Sul nas Cidades da Região metropolitana do Recife e Capital.

Posted by raphaelmirc on 4 October 2018 in Brazilian Portuguese (Português do Brasil)

Boa Noite Mapeadores.

Hoje inseri Cep´s na BR-101 Sul nas cidades de Recife, Cabo de santo agostinho, Ipojuca, Escada, Ribeirão, Joaquim Nabuco, Palmares e Xexéu.

Continuarei a Inserir Cep´s na Cidade do Recife, pois o Foco hoje e a Inclusão dos Cep´s na Capitão Pernambucana e em 2019 Começaremos um novo projeto que sera a inclusão de Cep´s nas cidades da Região metropolitana do Recife.

Quem quiser participar do nosso projeto e só entrar no telegram na Sala PE. @OSM_PE O Link da Sala e Esse: ]Sala no Telegram](

Pagina do wiki do Projeto Mapeia Cep 2018:

Location: Santo Antônio, Recife, Microrregião de Recife, Região Metropolitana de Recife, Mesorregião Metropolitana de Recife, Pernambuco, Região Nordeste, Brasil

#UniqueMappersTeam Active Contributed more than 15000 edits during the Global FGM Global Mapathon

Posted by vicksun on 3 October 2018 in English (English)

Thanks to Ambrose,Dubem,Precious and Ify for you amazing contributions to FGM Mapathon last weekend.Thank you UniquemappersTeam


Posted by Inneh Precious on 3 October 2018 in English (English)

Female genital mutilation (FGM), also known as female genital cutting and female circumcision, is the ritual cutting or removal of some or all of the external female genitalia. The practice is found in Africa, Asia and the Middle East, and within communities from countries in which FGM is common. This year 2018, maps were created in OSM to help fight against FGM and took great part in it and believed to have made a significant impact. Although I emerged 5th in the rank on the map2endfgm leader board I was appreciated for my huge effort and contribution. “Thank you so much for participating in our global mapathon, Mappers in over 60 countries added over 49,000 buildings and almost 7000 km of roads to help protect girls at risk of FGM in Tanzania, Somalia, Kenya, Mali, Guinea, Uganda and Niger” (A Message from Crowd2Map, UNFPA, YouthMappers).

Updating of Pueblo streets and addresses

Posted by brackeen on 2 October 2018 in English (English)

I'm currently working on updating the streets and addresses locating within and immediately surrounding the Pueblo of Pojoaque. The streets that were seemingly added from tiger data do not necessarily match what is the reality here. There is also very little address data because this is a rural area in New Mexico. I've noticed that a larger number of businesses are using OpenStreetMap. I tend to think of this updating as literally putting Pojoaque on the map.


Posted by OLODIA AMBROSE on 1 October 2018 in Abkhazian (Аҧсуа)

Hello!!! happy independence to all Nigerians, well, as a good citizen of this great country i have contributed my own quoter by mapping over 1,000 buildings in Isoko South L.G.A. of Delta state, ThankGod i am a member of UniqueMappersTeam my aim is to be in first position in UniqueMappers board, i believe i will get there soon... !!!

カスタム地図 φ( ̄ー ̄ )メモメモ

Posted by KleinAttitude on 1 October 2018 in Japanese (日本語)

電子国土基本図(オルソ画像) (最大ズーム設定) 17 (TMS URL設定){zoom}/{x}/{y}.jpg (原典、ソース表記) source=GSImaps/ort

Whitebikes update of OSM data from CSV export

Posted by MiroJanosik on 1 October 2018 in English (English)

So I did update of the OSM data that we get as CSV export from WhiteBikes database. I had to take care of few troubles - export is not exactly CSV, data order differs, but at least they are consistent. I think it can't be automated and changes should be reviewed, I did it by hand as I want to see which data modified. There are around 50 bike stands in the city.

So, lets see what did I have to do:

Prepare list of stands from database, in a format similar to previously retrieved data

  • download new data from whitebikes at * censored *. In case that website is saved as HTML and not as pure text try to use view source + select all - copy - paste into file.
  • It is in format of CSV (spreadsheet) that can be loaded into office if needed.

    • But it is in incorrect format, so it has to be adapted beforehand.
    • Replace all commas by dot. Replace all semicolons by comma.
    • After this change it will be CSV (Comma-separated-values) and it can be used in excel.
    • Though, there may be still some issues - semicolons are sometimes used also in text, not only as separators.
  • import into office spreadsheet editor (excel, calc) and make it nice and aligned by station number:

    • add new first column, fill it with numbers 1-100
    • set other columns for sorting, sort them by number (they may be reordered from database export)
    • align them with the numbers in first column, fill in empty lines for numbers that are not present
    • export into CSV again (see sample file export-2018-09-26-ordered-with-gaps.csv)
  • now, you can compare old and new csv with your favourite compare tool (Meld, WinDiff) and see it nicely aligned, see the differences that happened.

You may have to modify files to match some general differences (for example http to image changed to https, and such), (as example see sql-2017-03-26.csv and sql-2017-03-26-ordered-with-gaps-look-like-new.csv)

note - CSV column names are: "standId,standName,standDescription,standPhoto,serviceTag,placeName,longitude,latitude". Important column is 'serviceTag', if that is 1 then it is not a public sharing stand, it is a service one, and it should be either not imported, or marked as disabled:amenity.

Prepare these data into OSM file to see the data in JOSM

Install python to run for conversion of csv file into OSM file. If it won't work for you, then you can use your favourite editor which can do search-and-replace with regexp (Notepad++ on windows, Kate on linux)

  1. Take file (see export-2018-09-26-ordered-with-gaps.csv) and remove empty lines, and those with coords ",0,0" (see export-2018-09-26-ordered-with-gaps-to-osm-cleaned-0-0.csv)

  2. Do a replace of:



<node id='-\1' action='modify' lat='\9' lon='\8'><tag k='name' v='\3' /><tag k='description' v='\4' /><tag k='number' v='\2' /><tag k='amenity' v='bar' /></node>

This will convert CSV lines into nodes with lat, lon, description, name. It is made into bar to have big visible icon.

Add these two lines before first line:

<?xml version='1.0' encoding='UTF-8'?> <osm version='0.6' generator='JOSM'>

Add this line after last line:


Then save it with extension .osm (see export-2018-09-26-ordered-with-gaps-to-osm.osm) and you can load it into JOSM.

Prepare existnig stands in JOSM

Run JOSM, open the dialog for data download, and switch to tab "Download from overpass API" (in my JOSM 13756)

Fill in this query to get WhiteBike stands:

node [operator=WhiteBikes] ({{bbox}}); out;

Now lets do the change

You have:

  • layer with existing stands data
  • you open layer with stands as they are in whitebike database (export-2018-09-26-ordered-with-gaps-to-osm.osm)
  • you have open a comparison of old data (export-2018-09-26-ordered-with-gaps-to-osm.osm and sql-2017-03-26-ordered-with-gaps-look-like-new.csv)
  • additional data: satelite imagery (from bing), mapillary data

You do:

  • go along the list in comparison tool, see if there is any difference
  • if there is then either delete the stand (ZRUSENY means deleted), or modify it.
  • do not insert stands with 6th column value '1', that means it is service stand and it won't show on WhiteBike maps. Only '0' is ok.
  • If stands are not at the same place in existing data and in database, then look into export-stands-20170613-popisky.csv where is described that many stands are incorrectly placed in WhiteBikes map (sometimes up to 50 meters away from position in description or on photo).
  • mark stand types according rules on wiki
  • if stand is temporarily disabled, then mark it as disused:amenity=bicycle_rental and keep other properties, for easy update back to working state

Notes - helper, for copying attributes:

Parking stands:

  • amenity=bicycle_parking
  • bicycle_parking=stands
  • ref:cyklokoalicia=108 NOVEMESTO

Changeset is 62997154.

Location: Starý Ružinov, Ružinov, District of Bratislava II, Bratislava, Region of Bratislava, 821 08, Slovakia

Inclusão de CEP´S Nas Cidades que corta a BR-101 Sul e Norte em Pernambuco.

Posted by raphaelmirc on 1 October 2018 in Brazilian Portuguese (Português do Brasil)
Boa Tarde mapeadores, hoje comecei a incluir Cep na BR-101 Sul e Norte no Estado de Pernambuco, adcionei Cep´s em varios municipios, as Cidades inseridas foram, Jaboatão dos Guararapes, Paulista, Abreu e Lima, Igarassu e Goiana.

No Proximo passo irei revisar as cidades que já tem os Cep´s e inserir os Ce´p´s nessas cidades; Recife, Ipojuca, Cabo de santo agostinho, Escada, Ribeirão, Joaquim Nabuco, Palmares e Xexeu.

e por ventura alguma cidade que não esteja nessa lista..

bom mapeamento a todos;


Location: Muribeca, Jaboatão dos Guararapes, Microrregião de Recife, Região Metropolitana de Recife, Mesorregião Metropolitana de Recife, Pernambuco, Região Nordeste, 54360-160, Brasil

A "switch2osm" guide for Docker on Centos 7

Posted by SomeoneElse on 1 October 2018 in English (English)

I've been wanting to write an explainer for this for a while (even before this diary comment). The problem was that I wasn't aware of a Docker example that (a) was reasonably up to date and (b) was designed around tile serving (rather than style design for example).

However, this docker example was recently mentioned by its author on IRC. It's based on the building a tile server for 18.04 instructions and also handles importing data and running the tile server afterwards.

First things first, I installed Centos 7 on a virtual machine. I got a "minimal" iso image for that from here. I installed it (which involved turning the network on inside the installer and selecting the disk to install on). I also set a root password and added a non-root user (I'll use the example "renderaccount" below), and noted the IP address that it obtained. I did a "yum update" to install any available software updates.

There are a few sets of instructions for "installing Docker on Centos" - DigitalOcean have one, and there's one here which also contains lots of other useful information. Following the instructions there:

su -
yum install yum-utils device-mapper-persistent-data lvm2 wget
yum-config-manager --add-repo
yum install docker-ce
systemctl start docker

If you then do this:

systemctl status docker

In the output you should see "active (running)". Do this:

systemctl enable docker

in order to have docker start every time and then exit from root and do this from you're non-root user:

sudo usermod -aG docker $USER

So that you can control docker from that non-root user. Log out and back in and do this:

docker container run hello-world

It should say "Hello from Docker!" to show that everything is working OK. If instead you see "permission denied" it probably means you haven't logged out and back in again.

Next, we'll follow the openstreetmap-tile-server Docker instructions here. In this example run-through I'll download data for Zambia and import it, but any OSM .pbf file should work.

When logged in as our non-root user, download the data for Zambia into the root directory of the non-root user:


Create a docker volume for the data:

docker volume create openstreetmap-data

And install it and import the data:

time docker run -v /home/renderaccount/zambia-latest.osm.pbf:/data.osm.pbf -v openstreetmap-data:/var/lib/postgresql/10/main overv/openstreetmap-tile-server import

Obviously "renderaccount" will need to be changed to the name of your non-root user.

How long this takes depends very much on the local network speed. The largest part of the download will probably be actually the land polygons that OSM's standard style uses to differentiate land from sea; that file is a fixed size regardless of how large or how small the OSM data file you choose to import is (Zambia, used in this example, is relatively small).

One important thing to note - the path to the .osm.pbf must be the absolute path to the file; it can't be a relative path. Also note that if something goes wrong the error messages may be somewhat cryptic - you might get "... is a directory" if the data file isn't found. The "time" at the start of the command isn't necessary for the installation and import; it just tells you how long it took for future reference.

For more details about what it's actually doing, have a look at this file. You'll see that it closely matches the "manually building a tile server" instructions, with some minor changes such as the tile URL and the internal account used. Internally you can see that it's using Ubuntu 18.04, though you don't need to interact with that directly.

When the import is complete you should see something like this:

Osm2pgsql took 500s overall

real    157m54.159s
user    0m2.098s
sys     0m0.722s

That tells you how long things took in total (in this case 2.5 hours), and how much of that was spent import data (6 minutes). The second of these numbers is the rough time that it will take to import data again, since the big data files used by the OSM Carto style have already been downloaded.

To start the tile server running:

docker run -p 80:80 -v openstreetmap-data:/var/lib/postgresql/10/main -d overv/openstreetmap-tile-server run

and to check that it's working, browse to:


You should see a map of the world in your browser.

Viewing tiles

For a simple "slippy map" we can use an html file “sample_leaflet.html” which is here in mod_tile’s “extra” folder. Just open that file in a web browser on the machine where you installed the docker. If that isn’t possible because you’re installing on a server without a local web browser, you can edit it to replace “” with the IP address of the server and copy it to below “/var/www/html” on that server.

If you want to load a different area, just repeat the process from "wget" above. It'll be quicker the next time because the static data needed by the map style won't be needed.

If you're not using Centos

Centos was chosen above mainly because the "mod_tile" software isn't adapted to run there natively. If using Ubuntu 18.04, you can follow some instructions from DigitalOcean here, or you can install it using "apt". From a non-root account that has access to "sudo" do this:

sudo add-apt-repository universe
sudo apt update
sudo apt install
sudo usermod -aG docker $USER

then logout and back in again and:

docker run hello-world

and continue from that stage above.


Thanks to the authors of all the guides linked to above, especially the Alexander Overvoorde's "openstreetmap-tile-server" repository Dockerfile in it, and the (many) original authors of the "building a tile server" instructions.

Уточнение карты

Posted by AlexSushilov on 1 October 2018 in Russian (Русский)

Часто приходится наблюдать автомобилистов, пытающихся проехать там, где проезд невозможен, хотя на карте и по навигатору он должен быть. Или туристов, заблудившихся из-за того, что тропа, указанная на карте непроходима. Решил сам скорректировать данные карты в местности, которую хорошо изучил.

Location: поляна Малиновая, Мезмайское сельское поселение, Апшеронский район, Краснодарский край, Южный федеральный округ, 352666, РФ

#DigitizeRacine begins!

Posted by jdcarls2 on 1 October 2018 in English (English)

A lot of the counties around here provide publicly available building footprints. Mine doesn't. Inspired by some of the more rigorous OSM efforts that exist in the broader community, I am committing myself to my home community of Racine.

Beginning with the City around me and broadening out, I'm going to work on getting all our buildings added to OSM, and fix some of the validation errors lurking in the data. Seems our local editors like to combine landuse ways with highways, but the common convention is that this is incorrect. Lots of ungluing to do. Other things, too.

An effort like this needs its own hashtag, I think. So: #DigitizeRacine

We'll start with rough building footprints, just to get everything on the map. Later, house numbers, porches, more specific tags, all that. But for now, I'm just going to churn out some rectangles.

Edit: also seems that the landuse areas will, at their corners, follow the curb. But why follow one curb and say "landuse doesn't include the street", and then completely cover whole swathes of other streets? I'm going to break them up into block-sized areas. I'm of the opinion that this is more information, too, as it gives the actual curb locations.

Location: Racine, Racine County, Wisconsin, USA

Att göra just nu med vår öppna data

Posted by pangoSE on 30 September 2018 in Swedish (Svenska)

Följande skrevs i ett privat meddelande och jag delar det här FYI.

Dem öppna data från både Trafikverket och Lanmäteriet används flitigt just nu.

Både i iD och JOSM finns NVDB med tonsvis av vägar som vi inte har ritat in än från Trafikverket och äldre ortofoto från LM där många ortsnamn och namn på berg, m.m. finns.

Även topografiska kartan från LM är användbar ibland, tex har jag ritat in militära övningsområden (se

Även Naturreservaten behöver uppdateras utifrån den öppna datan från Metria/Länsstyrelserna, se


Posted by OLODIA AMBROSE on 30 September 2018 in Abkhazian (Аҧсуа)

Hello! well for the past 3days we are engaged in mapping. by the special grace of God i have been able to contribute over 2,800 buildings on map2endfgm. I am so excited, because i am the highest in map2endfgm.... The first time i checked the leadersboard on map2endfgm, i was 3rd position with just 500 buildings, but i told myself i must overtake and occupied the first position, as at then, the person in first position has mapped over 2,500 buildings, thankGod i made it. i am at the top.


My advise to others is when mapping take it as fun, as if u are playing computer game (PS4). with that mind set you can achieve your mapping target or benchmark. thank you!!!

UNFPA Global Mapathon To Help End Female Genital Mutilation .

Posted by SSEKITOLEKO on 30 September 2018 in English (English)

As part of global mapathon i have trained my friends to map with OpenStreet Map so that they can also participate in the struggle to bring an end to female genital mutilation in tanzania and the whole world as well.#map2endFGM. Crowd2map tanzania.

Location: Wakiso, Central Region, Uganda