Wiki Questions

Posted by dono87 on 22 April 2015 in French (Français)

Hi All,

I'm not sure where to post these questions as I wasn't even aware these diaries existed for quite some time.

I have made progress in mapping Ataraxia, admittedly with a first focus on socio-economic, political and cultural context before street-level mapping.

All 98 provinces are mapped and a new census has been completed revealing a population of 63.25 million - with 8.1 million in Ataraxia City metro provinces (10.3 million with satellite provinces incl. Baudoinville, Combault, Marbella).

1st Question: How can I efficiently post data from excel files to tables on the wiki without retyping character by character?

2nd Question: How can I export data from the map to an easily editable image file (eg. GIMP or Inkscape)? Ideally with just provincial and/or national boundaries that could then be filled in? This would be to make themed maps by province like population density or average income or election results.
So far I have only been able to manage screenshots.

Thanks and always open to any suggestions!

Comment from Luciano on 22 April 2015 at 12:55

I won't say anything about you 2nd question - I have so much difficulty with image editors that I would rather program extractions and leaflet pages, which is the way I handle all my map visualizations in the wiki.

But for your 1st question, I can say that I have never manually data-entered a table in the wiki. I have some tools and hacks I use to get data out of my spreadsheets, including some macros, a mail merge program, and some perl scripts.

Rather than overwhelm you with trying to explain that, I will note there are some free-to-use downloadable tools. I just found, downloaded, and successfully used a tool called csvConverter (downloadable here: You have to save your spreadsheet as a CSV file first - all spreadsheet editors have this ability (Excel, OpenOffice, Google Docs). The boom, it pops out a wiki-formatted table in a text file, which you can copy and paste into your wiki page.

Having said that, I'm moving in the direction of not putting info in spreadsheets at all, but instead directly downloading info from the OGF database and making my wiki tables using some scripts off the OSM data directly. All my "Communities in..." pages (see here: are mostly automated extracts of "place=x" nodes in the map.

Hope that helps.

Hide this comment

Comment from isleño on 22 April 2015 at 23:01

For the 2nd question, the way I made Khaiwoon's themed maps was just tracing over a screenshot of the OGF map. It's not very precise, but themed maps like this don't really need to be.

That said, if someone knows how to easily export, I hope they post about it here. It would be good to know.

Hide this comment

Comment from Luciano on 23 April 2015 at 02:30

Perhaps the best solution for the 2nd question would be to develop skills using a tool like Maperitive, which uses OGF data combined with custom rendering specifications to make various styles of maps. I have experimented with Maperitive in a limited way, but I'm not anywhere close to comfortable with it. I think the only example I've posted of maperative work is the "sketch" of Zhebeyem, a city I have been mapping using JOSM but which is currently "offline" (just a giant OSM file on my computer) - the city currently has no location or home in OGF.

Hide this comment

Comment from Voytek on 23 April 2015 at 07:43

I was trying to use Maperitive but I have no idea how to use it :/ So, for my map of Kingdoms I just made a screenshot, then Photoshop was able to select every kingdom and colour it. Anyway, it took a lot of time - not the best way obviously and a bit limited...

Hide this comment

Comment from dono87 on 23 April 2015 at 09:00

Thanks for your answers.

I saw your clickable maps Luciano (which are great!), but I think that is more than I was looking to do at the moment.

I was thinking of maps like these, that seem to be extracts from OGF, which I can then color code by province or region. If no one answers here maybe I will reach out to users directly: (screenshot ok, but how to fill in other territories)

I guess tracing a screenshot is an option but I was hoping there were more options – did I mention I have 98 provinces? :)

Maperitive also seems a bit complicated but maybe I will have a try this weekend.

I just want to load selected relations in a given area (eg. boundaries/admin_level 2, 3, 4) to make an image. Is that possible?

Hide this comment

Comment from dono87 on 23 April 2015 at 09:09

In addition to those examples, it could be interesting to make thematic maps for waterways or railways/highspeed rail or autoroutes, etc.

Tracing is an option, but using data and relations that are already in OGF would be better

Hide this comment

Comment from Luciano on 23 April 2015 at 09:41

Definitely it seems like, from what you describe, that maperitive should be the route you take. Meanwhile, if you want to set the correct data in your provinces relations, I would be happy to make a clickable map as I did for Gobrassanya. Just look at that country or Ardisphere and study the relation tags to see what is required for it to work. You could do for a few provinces and I could do a trial run and you can then decide if it would be worth the effort.

Hide this comment

Comment from waa on 23 April 2015 at 09:56

I have some experience with Maperitive (I used to render maps before I heard about OpenGeofiction), so I can write short tutorial how to render own maps with some examples (maybe this weekend). Example (an overview map of administrative division): map I used also TileMill which is able to render better maps - for example default OSM (and OGF) style (CartoCSS), but it's much more difficult to configure (it doesn't support .osm files directly, I set up Postgres server and load data from .osm files to database before getting any effects, though it's possible to load .shp files).

Hide this comment

Comment from histor on 23 April 2015 at 19:37 (screenshot ok, but how to fill in other territories)

very simply = with "irfanview" changed in a bitmap-file (windows-bitmap) and coloured the other countries with the oldold "Paintbrush" (now Microsoft-paint), set the other signatures and changed back with "irfanview" to a *.png-file. Free after Ockham: "the most simply soloution is the best".

Hide this comment

Comment from Voytek on 23 April 2015 at 22:40

waa, this looks awesome man! :) Can't wait to see your tutorial and try it myself. Maperitive, Tilemill, Mapbox - I can't make them work as I expect :/

Hide this comment

Comment from antoon on 24 April 2015 at 18:45

Maperative seems a nice tool to load and use .osm files, but it doesn't seem able to open the .xml.gz files from the backup-directory. I'm still looking for an easy / user-friendly tool to extract a .osm file for a whole country. Downloading all parts in JOSM takes quite a while and is very tiring. Does anyone know how?

Hide this comment

Comment from thilo on 24 April 2015 at 20:40

The .xml.gz files are exports from the wiki. The map data are in the .pbf files. Those are probably too large to be opened directly with Maperitive, so you'll probably have to extract a smaller subset first, by choosing a smaller area and/or filtering by tags. For this step, you can use the "osmosis" tool:

Hide this comment

Comment from Luciano on 24 April 2015 at 20:58

The osmconvert utility is very simple and easy to learn, it even has a primitive cmd window interface if you don't want to figure out the cmd line. That is what I still use if I want to grab a box with my whole country in it, from the .pbf file. It is quite fast too. I'm still trying to figure out osmosis.

Hide this comment

Comment from antoon on 25 April 2015 at 17:29

Thanks Thilo and Luciano for your reactions. I've just been trying osmconvert and after some tries i managed to first clip the pbf-file to the area of Neberly and convert that pbf-file to an osm-file. I didn't find it very intuitive and the command lines didn't seem to work for me. Almost everything i write only resulted in a immediate close of the program. Only with " a " i got a step-to-step guide that did the trick. The clipping and converting itself only took seconds indeed.

Hide this comment

Comment from Luciano on 26 April 2015 at 00:09

I agree that osmconvert definitely could use better documentation, but once you get used to it, it's extremely useful. I am also a big fan of a related utility called osmfilter. I can use to pull ALL THE COASTLINES IN THE WORLD, for example, ignoring everything else, and open that filtered OSM in JOSM, which is handy for coastline maintenance. Like wise with world borders or other types of large scale maintenance.

Hide this comment

Leave a comment

Parsed with Markdown

  • Headings

    # Heading
    ## Subheading

  • Unordered list

    * First item
    * Second item

  • Ordered list

    1. First item
    2. Second item

  • Link

  • Image

    ![Alt text](URL)

Login to leave a comment