Prepare the Data
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.