In addition, a flexible folder structure was implemented to allow porting to other machines and effective load balancing/caching. Porting means cleaning up 9 years of organically grown programmes and simply rewriting them, leaving out my beloved PERL for pure administration jobs. This is impossible to do manually, so far Excel-VBA programmes in combination with PERL scripts have done most of the hard work.įor about 10 days now, I have been sitting in front of the computer every free minute and porting VBA to Starbasic. Last but not least, the web pages must be regenerated after each update. Corresponding start-up programmes for each individual production step such as conversion of file formats, creation of boundary polys, elevation data, sea areas, inheritance of bike/MTB/hike routes etc,etc. This means that different tag mappings have to be created and assigned to individual maps.īut also such trivial things as map centres, languages, fineness of elevation data, allocation to render queues (load balancing) have to be managed. Well, with OAM there is a stock of around 270 maps to manage with the most diverse settings.įor example, map symbols for petrol stations and drinking water sources in urban areas appear only at much higher zoom levels than in Scandinavia – for this, there is also the ELEMENTS theme by Tobias, which takes this into account. Many people might ask themselves: “Why Excel for an OSM map project?

Excel libreoffice calc