Like most people, I am getting more forgetful as I get older. But my advancing senility seems to have taken an unusual 21st century twist: whereas my mum, for example, will go into a room and forget what she went there for, I found myself earlier today looking at the list of programs in my start menu, unable to remember what they did or why I installed them.
The list of installed programs on my computer is a bit of a blur. And scanning down my /Program Files directory just looks like I’m looking through a foreign phone directory: /JMicron – what’s that? /MikSoft – no idea. /Quest Solutions – errrm.
I find myself opening up different applications one after another until I get the one I wanted, only to find that I’ve forgotten what it was I was going to do with it… and it’s not helped by the fact that I’m also a bit of a hoarder. Programs that I no longer use, or which have been superseded still litter my C:\ drive. I have two versions of Visual Studio and two versions of SQL Server installed side-by-side, and at least three different versions of Python, for example. Meanwhile, other applications such as FWTools and Shape2SQL, which I would have once used on an almost daily basis, now lie gathering cobwebs in my Start Menu, envious of the applications in my “recently used” list that have replaced them.
I’m doing a lot of work creating custom tile layers for Bing Maps at the moment so, for my own benefit, I thought I’d make some quick notes as to those applications I do actually use at various stages of a tool chain for this task. Then, next time I need to do this, I won’t faff around for ages loading up the wrong programs…
MapTiler – for creating tilesets from one or more georeferenced image files (e.g. a set of GeoTIFFs). This is essentially just a GUI wrapper around the GDAL2tiles.py script, which requires GDAL and Python.
Mapnik – for rastering, labelling and creating tilesets from vector shapefiles. (Should in theory be able to rasterise and tile geometry/geography data direct from SQL Server, but still haven’t got it to work yet). It’s what Open Street Maps uses and it makes very pretty tiles. Requires Python.
GDAL/OGR – for conversion and projection between most vector and raster spatial data formats, including importing/exporting to SQL Server/Shapefiles/CSV and more. Provides the conversion functionality used by MapTiler and Mapnik above.
OSGeo4W – Package containing precompiled binaries for the above, and many other useful spatial apps such as QGIS. Provides a shell in which all the environment variables for the various command-line apps are already configured, which saves a lot of time.
Microsoft Mapcruncher – for creating tilesets from small, simple, ungeoreferenced image files (e.g. PDF floorplans)
Safe FME – The first, and only, commercial tool on this list. Since it’s commercial, it’s only for when I deal with clients who have got the appropriate licence to use it. FME licences aren’t cheap, but it does justify its cost by basically replacing the functionality of all of the preceding tools in one go.
Perhaps at some point I’ll get round to deleting the many other applications I have that do very similar things to these but which I never use…