The next task was to turn these quotes into a form of GIS data by assigning spatial coordinates to them.  This was done by using a PostGIS database to link each quote to the metadata of the original letter.  Both the main letters table and the quotations tables contained a primary key that referred to which letter they came from.  This started with the letter “k” and was followed by the letter’s number (k01 - k68).  

The main letters table was converted into a spatial data format by importing the CSV file into Quantum GIS using the easting and northing fields as the x and y coordinates.  This  data was then exported as a shapefile with the Google Maps Global Mercator projection.