mapOSM (WIP)


I have found a new subject to scratch my head: i’m trying to work with OSM XML files (geographic data used to draw map). I made a program to convert the file into an sqlite database (nodes, ways, relations). The latitude-longitude values are converted in planar coordinates (to draw on screen) with a Lambert azimuthal projection.

MVD is very efficient for this. A lot of SQL statements are required which consume a lot of time. I choose to  put the sql file on a RAMdisk. Even if the RAMDisk is 200X more faster than my hard drive, the import of the XML file (a big one) take near 10 minutes. Fortunately, the import is only required one time.

Now, I’m able to draw streets and houses. It was a very interesting thing to explore. I have a lot to optimize and maybe some bugs to catch. I’m not sure I will release an application, more surely some tricks how to process.

Now, I would like to implement some aspect of the graph theory but that is another story 😉

See below…

Lambert azimuthal equal-area projectionmapOSM-2

Show a part of an export

EAN13 barcode generator



EAN13 is a barcode generator. Enter a valid EAN13 code in the text box, click Generate. The barcode is displayed in the image. Then you can Save the picture. In the install folder (right click on the icon, show properties, access the application folder), the file <EAN13>_EAN13.png is created.

If you have a lot of barcodes to create, edit a text file (example EAN13.TXT) with a barcode per line. Sample:


Put the text file in the application install folder (%APPDATA%\..\Local\EAN13 by default), launch a shell, then type :

C:\…> CD %APPDATA%\..\Local\EAN13
C:\…> EAN13 EAN13.TXT

A picture with the EAN13 barcode is generated for each valid EAN13 code in the EAN13.TXT file.

Note: If you don’t know the value of the check digit (13th), you can enter  twelve digits and let the program compute the last.

You can download the install program of EAN13 in english.

The application has been done with MyVisualDatabase (a cheap and well done environment similar to Delphi).