package org.greenstone.atlas.server;

import java.awt.BorderLayout;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.DataOutputStream;
import java.io.FileReader;
import java.io.FileWriter;
import java.io.InputStreamReader;
import java.net.HttpURLConnection;
import java.net.URL;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.TreeMap;

import javax.swing.ButtonGroup;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JList;
import javax.swing.JPanel;
import javax.swing.JRadioButton;
import javax.swing.JScrollPane;
import javax.swing.ListModel;
import javax.swing.event.ListSelectionEvent;
import javax.swing.event.ListSelectionListener;

import org.greenstone.atlas.client.Place;

public class ServerSideTests
{
	String _currentLine = null;
	ArrayList<String> _words = new ArrayList<String>();

	/**
	 * @param args
	 */
	public static void main(String[] args)
	{
		// GazetteerTrie trie = new
		// GazetteerTrie("/home/sam/Desktop/Research/Greenstone3-gate-svn2/web/GPNMS/dataen.txt");
		// PlacesToPoints();

		ServerSideTests sst = new ServerSideTests();
		sst.go();
	}

	public void go()
	{
		DatabaseFix();
		//PlacesToPoints();
		// ExperimentSetUp();
		//PrecisionExperiment();
		//GazetteerExperiment();
		//GazetteerTest();
		//ModPlaceNames();
		//analyseResults();
	}
	
	public void analyseResults()
	{
		try
		{
			BufferedReader in = new BufferedReader(new FileReader("/home/sjm84/Desktop/deleteMe.txt"));
			
			TreeMap<Double, ArrayList<Double[]>> scores = new TreeMap<Double, ArrayList<Double[]>>();
			
			Double[] currentConfig = null;
			
			String line = null;
			boolean score = false;
			while((line = in.readLine()) != null)
			{
				if(score)
				{
					String[] scanScores = line.split(" ");
					Double averageScore = Double.parseDouble(scanScores[5]);
					
					if(scores.containsKey(averageScore))
					{
						scores.get(averageScore).add(currentConfig);
					}
					else
					{
						ArrayList<Double[]> newList = new ArrayList<Double[]>();
						newList.add(currentConfig);
						scores.put(averageScore, newList);
					}
				}
				else
				{
					String[] configValues = line.split(" ");
					currentConfig = new Double[configValues.length];
					
					for(int i = 0; i < configValues.length; i++)
					{
						currentConfig[i] = Double.parseDouble(configValues[i]);
					}
				}
				
				score = !score;
			}
			
			BufferedWriter out = new BufferedWriter(new FileWriter("/home/sjm84/Desktop/SortedScores.txt"));
			
			for(Double d : scores.keySet())
			{
				out.write(d + " -> ");
				ArrayList<Double[]> current = scores.get(d);
				
				for(Double[] da : current)
				{
					for(int i = 0; i < da.length; i++)
					{
						out.write(da[i] + " ");
					}
					
					out.write(" - ");
				}
				out.write("\n");
			}
			
			in.close();
			out.close();
		}
		catch(Exception ex)
		{
			ex.printStackTrace();
		}
	}
	
	public void ModPlaceNames()
	{
		try
		{
			BufferedReader in = new BufferedReader(new FileReader("/home/sjm84/Desktop/placenames.txt"));
			
			ArrayList<String> words = new ArrayList<String>();
			
			String line = null;
			while((line = in.readLine()) != null)
			{
				String[] w = line.split(" ");
				for(int i = 0; i < w.length; i++)
				{
					words.add(w[i]);
				}
			}
			
			BufferedWriter out = new BufferedWriter(new FileWriter("/home/sjm84/Desktop/placenames.txt"));
			
			for(int i = 0; i < words.size(); i++)
			{
				for(int j = 0; j < words.get(i).length(); j++)
				{
					if(words.get(i).charAt(j) > 127)
					{
						out.write(words.get(i) + "\n");
					}
				}
			}
		}
		catch (Exception e)
		{
			e.printStackTrace();
		}
	}

	public void GazetteerExperiment()
	{
		showMemoryUsage();
	}
	
	public interface ObjectFactory
	{
		public Object makeObject();
	}

	public long calculateMemoryUsage()
	{
		ObjectFactory factory = new ObjectFactory()
		{
			public Object makeObject()
			{
				return new GazetteerTrieType5("/home/sam/Desktop/Research/Greenstone3-gate-svn2/web/GPNMS/dataen.txt");
			}
		};
		
		Object handle = factory.makeObject();
		long mem0 = Runtime.getRuntime().totalMemory() - Runtime.getRuntime().freeMemory();
		long mem1 = Runtime.getRuntime().totalMemory() - Runtime.getRuntime().freeMemory();
		handle = null;
		System.gc();
		System.gc();
		System.gc();
		System.gc();
		System.gc();
		System.gc();
		System.gc();
		System.gc();
		System.gc();
		System.gc();
		System.gc();
		System.gc();
		System.gc();
		System.gc();
		System.gc();
		System.gc();
		mem0 = Runtime.getRuntime().totalMemory() - Runtime.getRuntime().freeMemory();
		handle = factory.makeObject();
		System.gc();
		System.gc();
		System.gc();
		System.gc();
		System.gc();
		System.gc();
		System.gc();
		System.gc();
		System.gc();
		System.gc();
		System.gc();
		System.gc();
		System.gc();
		System.gc();
		System.gc();
		System.gc();
		mem1 = Runtime.getRuntime().totalMemory() - Runtime.getRuntime().freeMemory();
		return mem1 - mem0;
	}

	public void showMemoryUsage()
	{
		
		long mem = 0;
		for(int i = 0;i < 10; i++)
		{
			mem += calculateMemoryUsage();
		}
		System.out.println("Object takes " + (int)(mem/10) + " bytes");
	}

	public void ExperimentSetUp()
	{
		final JFrame frame = new JFrame("Experiment setup program");
		JList placeList = null;
		final ButtonGroup alts = new ButtonGroup();
		final ArrayList<JRadioButton> buttons = new ArrayList<JRadioButton>();
		final JPanel buttonPanel = new JPanel();
		buttonPanel.setLayout(new GridLayout(30, 3));
		final HashMap<String, Place> choices = new HashMap<String, Place>();
		final ArrayList<Place> possibleChoices = new ArrayList<Place>();
		JButton enter = new JButton("GO");
		String filename = "/research/sjm84/Msc/GNSDocs/ireland.html";// "/home/sam/Desktop/Research/GNSDocs/canada.html";//

		try
		{
			PageScanner ps = new PageScanner("/research/sjm84/Msc/Downloads/");// new
			// PageScanner("/home/sam/Desktop/Research/");//

			BufferedReader file = new BufferedReader(new FileReader(filename));

			ArrayList<ArrayList<String>> lines = new ArrayList<ArrayList<String>>();
			String line = null;
			while ((line = file.readLine()) != null)
			{
				lines.add(MarkupService.findWords(line));
			}

			ps.examineTextWithoutGate(lines);
			final ArrayList<Place> filePlaces = ps.getPlaces();
			ArrayList<Place> seenPlaces = new ArrayList<Place>();
			for (Place p : filePlaces)
			{
				if (p.isDirectlyReferenced())
				{
					boolean found = false;
					for (int i = 0; i < seenPlaces.size(); i++)
					{
						if (p.getName().equals(seenPlaces.get(i).getName()))
						{
							found = true;
							break;
						}
					}
					if (!found)
					{
						seenPlaces.add(p);
					}
				}
			}

			String[] items = new String[seenPlaces.size()];
			for (int i = 0; i < seenPlaces.size(); i++)
			{
				items[i] = seenPlaces.get(i).getName();
				choices.put(seenPlaces.get(i).getName(), null);
			}

			placeList = new JList(items);

			placeList.addListSelectionListener(new ListSelectionListener()
			{
				int prevIndex = -1;

				public void valueChanged(ListSelectionEvent e)
				{
					ListModel model = ((JList) (e.getSource())).getModel();
					int index = ((JList) (e.getSource())).getSelectedIndex();
					final String s = (String) (model.getElementAt(index));
					if (index != prevIndex)
					{
						System.out.println("Value Changed!");
						for (JRadioButton button : buttons)
						{
							buttonPanel.remove(button);
							alts.remove(button);
						}

						buttons.clear();
						possibleChoices.clear();

						System.out.println("*Adding Button!");
						JRadioButton noneButton = new JRadioButton("*None*");
						alts.add(noneButton);
						buttons.add(noneButton);
						buttonPanel.add(noneButton);
						noneButton.addActionListener(new ActionListener()
						{
							public void actionPerformed(ActionEvent e)
							{
								choices.put(s, null);
							}
						});

						int count = 0;
						for (Place p : filePlaces)
						{
							if (p.getName().equals(s))
							{
								System.out.println("Adding Button!");
								possibleChoices.add(p);

								JRadioButton button = new JRadioButton(p.getName() + ", " + p.getParentPlaceName());
								alts.add(button);
								buttons.add(button);
								buttonPanel.add(button);
								button.addActionListener(new RadioActionListener(count++, possibleChoices, choices));
							}
						}

						buttonPanel.setSize(600, 150);
						buttonPanel.validate();
						frame.pack();
						frame.validate();
					}
					prevIndex = ((JList) (e.getSource())).getSelectedIndex();
				}
			});

			enter.addActionListener(new ButtonActionListener(choices));
		}
		catch (Exception ex)
		{
			ex.printStackTrace();
		}

		JScrollPane sp = new JScrollPane(placeList);
		frame.setLayout(new BorderLayout());
		sp.setSize(600, 150);
		frame.add(sp, BorderLayout.WEST);
		buttonPanel.setSize(600, 150);
		frame.add(buttonPanel, BorderLayout.CENTER);
		enter.setSize(600, 100);
		frame.add(enter, BorderLayout.EAST);
		frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		frame.setSize(600, 400);
		frame.setVisible(true);
	}

	class RadioActionListener implements ActionListener
	{
		int _index = -1;
		ArrayList<Place> _possibleChoices = null;
		HashMap<String, Place> _choices = null;

		public RadioActionListener(int index, ArrayList<Place> possibleChoices, HashMap<String, Place> choices)
		{
			_index = index;
			_possibleChoices = possibleChoices;
			_choices = choices;
		}

		public void actionPerformed(ActionEvent e)
		{
			System.out.println("BUTTON CLICKED");
			_choices.put(_possibleChoices.get(_index).getName(), _possibleChoices.get(_index));
		}
	}

	class ButtonActionListener implements ActionListener
	{
		HashMap<String, Place> _choices = null;

		public ButtonActionListener(HashMap<String, Place> choices)
		{
			_choices = choices;
		}

		public void actionPerformed(ActionEvent e)
		{
			System.out.println("GO CLICKED");
			try
			{
				BufferedWriter out = new BufferedWriter(new FileWriter("/home/sjm84/Desktop/test.txt"));

				for (String s : _choices.keySet())
				{
					System.out.println(s + " == " + _choices.get(s));
					if (_choices.get(s) != null)
					{
						out.write("new Long(" + _choices.get(s).getId() + "), /* " + _choices.get(s).getName() + " */\n");
					}
				}
				out.close();
			}
			catch (Exception exception)
			{
				exception.printStackTrace();
			}
		}
	}

	public void PrecisionExperiment()
	{
		ArrayList<ScanConfiguration> configs = new ArrayList<ScanConfiguration>();
		HashMap<ScanConfiguration, ArrayList<int[]>> results = new HashMap<ScanConfiguration, ArrayList<int[]>>();

		for (int i = 0; i < 6; i++)
		{
			for (int j = 0; j < 6; j++)
			{
				for (int k = 0; k < 6; k++)
				{
					for(int l = 0; l < 6; l++)
					{		
						ScanConfiguration sc = new ScanConfiguration(0.2 * i, 0.2 * j, 0.2 * k, l);
						//ScanConfiguration sc = new ScanConfiguration(0, 0.8, 0.0, 1);
						configs.add(sc);
						results.put(sc, new ArrayList<int[]>());
						
						if(j == 0)
						{
							break;
						}
					}
				}
			}
		}

		try
		{
			PageScanner ps = new PageScanner("/research/sjm84/Msc/Downloads/");
			//PageScanner ps = new PageScanner("/home/sam/Desktop/Research/");

			String[] filenames = new String[] { "australia", "canada", "ireland", "southafrica", "washington" };
			for (int i = 0; i < filenames.length; i++)
			{
				BufferedReader file = new BufferedReader(new FileReader("/research/sjm84/Msc/GNSDocs/" + filenames[i] + ".html"));
				//BufferedReader file = new BufferedReader(new FileReader("/home/sam/Desktop/Research/GNSDocs/" + filenames[i] + ".html"));

				StringBuilder text = new StringBuilder();
				String line = null;
				while ((line = file.readLine()) != null)
				{
					text.append(line);
				}

				ScanResultSet correctResults = getCorrectScanResultSet(i);
				ArrayList<String> textPlaces = ps.getPlaceNames(text.toString());

				int count = 0;
				for (ScanConfiguration sc : configs)
				{
					count++;
					System.out.println(sc + " " + count);
					ps.setScoringParams(sc);
					ps.examineArrayOfStrings(textPlaces);
					ScanResultSet scanResult = new ScanResultSet(filenames[i], ps.getPlaces());
					//correctResults.updateScores(ps.getPlaces());
					int[] compareResults = correctResults.compareResults(scanResult);
					if(compareResults == null)
					{
						System.out.println("NULL?!?");
					}
					else
					{
						results.get(sc).add(compareResults);
					}
				}
			}

			BufferedWriter out = new BufferedWriter(new FileWriter("/home/sjm84/Desktop/deleteMe.txt"));
			//BufferedWriter out = new BufferedWriter(new FileWriter("/home/sam/Desktop/scanResults.txt"));

			for (ScanConfiguration sc : results.keySet())
			{
				out.write(sc.toString() + "\n");
				int correctCount = 0;
				int totalCount = 0;
				for (int[] i : results.get(sc))
				{
					out.write(((double)(i[0]))/((double)(i[1])) + " ");
					correctCount += i[0];
					totalCount += i[1];
				}

				out.write(((double)(correctCount)) / ((double)(totalCount)) + "\n");
			}
			out.close();
		}
		catch (Exception ex)
		{
			ex.printStackTrace();
		}
	}

	public static void ListPopulate()
	{
		Statement database = null;

		try
		{
			Class.forName("org.postgresql.Driver");
			Connection c = DriverManager.getConnection("jdbc:postgresql://localhost/GS3MapDB", "sam", "password");

			database = c.createStatement();

			ResultSet places = database.executeQuery("SELECT placename, placetype FROM places WHERE population > -1");

			BufferedWriter countryList = new BufferedWriter(new FileWriter("/research/sjm84/Msc/Downloads/CountryList.lst"));
			BufferedWriter cityList = new BufferedWriter(new FileWriter("/research/sjm84/Msc/Downloads/CityList.lst"));

			while (places.next())
			{
				String pn = places.getString("placename");
				String pt = places.getString("placetype");

				if (pt.equals("country"))
				{
					countryList.write(pn + "\n");
				}
				else
				{
					cityList.write(pn + "\n");
				}
			}
			places.close();
			ResultSet alternatePlaces = database.executeQuery("SELECT * FROM alternatenames WHERE alternatename is not null");

			while (alternatePlaces.next())
			{
				cityList.write(alternatePlaces.getString("alternatename") + "\n");
			}
			alternatePlaces.close();

			cityList.close();
			countryList.close();
		}
		catch (Exception ex)
		{
			ex.printStackTrace();
		}
	}

	public static void RPCTest()
	{
		try
		{
			String payload = "5|0|4|http://localhost:9090/greenstone3/interfaces/default/js/mapScripts/|FC39F395243F4B8A4145D4DCB673D89A|org.greenstone.client.findPlaceService|isGazetteerLoaded|1|2|3|4|0|";

			URL url = new URL("http://localhost:9090/gpnms/simplemaps/findPlace");
			HttpURLConnection con = (HttpURLConnection) url.openConnection();

			con.setUseCaches(false);
			con.setDoOutput(true);
			con.setDoInput(true);
			DataOutputStream dataOut = new DataOutputStream(con.getOutputStream());
			dataOut.write(payload.getBytes());
			dataOut.flush();
			dataOut.close();
			// DataInputStream in = new DataInputStream(con.getInputStream());
			System.out.println("Content = " + con.getInputStream());
		}
		catch (Exception ex)
		{
			ex.printStackTrace();
			System.out.println("Message = " + ex.getMessage());
		}
	}

	public void GazetteerTest()
	{
		//GazetteerTrieType4 gaz = new GazetteerTrieType4("/home/sam/Desktop/Research/Greenstone3-gate-svn2/web/GPNMS/dataen.txt");
		GazetteerTrieType5 gaz = new GazetteerTrieType5("/research/sjm84/Msc/Downloads/dataen.txt");
		initWords();
		int totalTime = 0;
		for (int i = 0; i < 100; i++)
		{
			Long time = System.currentTimeMillis();
			try
			{
				int count = 0;
				boolean done = false;
				while (!done)
				{
					StringBuilder currentWords = new StringBuilder();

					int length = 0;
					while (gaz.checkPlaceName(currentWords.toString()) != -1)
					{		
						String word = null;
						if(count + length < _words.size())
						{
							word = _words.get(count + length);
						}
						if (word == null)
						{
							totalTime += System.currentTimeMillis() - time;
							// _in.close();
							//System.out.println("DONE");
							done = true;
						}
						if(currentWords.length() == 0)
						{
							currentWords.append(word);
						}
						else
						{
							currentWords.append(" " + word);
						}
						length++;
					}
					currentWords = new StringBuilder();
					count++;
				}
			}
			catch (Exception e)
			{
				e.printStackTrace();
			}
		}
		System.out.println("Total = " + totalTime / 100);
	}

	public void initWords()
	{
		try
		{
			BufferedReader in = new BufferedReader(new FileReader("/home/sjm84/Desktop/placenames.txt"));

			String line = null;
			while ((line = in.readLine()) != null)
			{	
				for (String word : line.split(" "))
				{
					_words.add(word);
					_words.add(word);
					_words.add(word);
				}
			}
		}
		catch (Exception ex)
		{
			ex.printStackTrace();
		}
		return;
	}


	public static void PlaceNameCheck()
	{
		GazetteerTrieType2 gazetteer = new GazetteerTrieType2("/research/sjm84/Msc/Downloads/dataen.txt");

		try
		{
			String inputLine = "";
			BufferedReader inputStream = new BufferedReader(new InputStreamReader(System.in));
			while ((inputLine = inputStream.readLine()) != "q")
			{
				if (gazetteer.checkPlaceName(inputLine) == 1)
				{
					System.out.println(inputLine + " is a place");
				}
				else
				{
					System.out.println(inputLine + " is not a place");
				}
			}
		}
		catch (Exception ex)
		{
			ex.printStackTrace();
		}
	}

	public static void PlacesToPoints()
	{
		ArrayList<Float> latitudes = new ArrayList<Float>();
		ArrayList<Float> longitudes = new ArrayList<Float>();
		ArrayList<Long> ids = new ArrayList<Long>();

		Statement database = null;

		try
		{
			Class.forName("org.postgresql.Driver");
			Connection c = DriverManager.getConnection("jdbc:postgresql://localhost/GS3MapDB", "postgres", "admin");

			database = c.createStatement();

			ResultSet places = database.executeQuery("SELECT id, latitude, longitude FROM places WHERE latitude is not null");

			while (places.next())
			{
				latitudes.add(places.getFloat("latitude"));
				longitudes.add(places.getFloat("longitude"));
				ids.add(places.getLong("id"));
			}

			for (int i = 0; i < latitudes.size(); i++)
			{
				System.out.println("INSERT INTO placepoints (id, point) VALUES (" + ids.get(i) + ", GeomFromText('POINT(" + latitudes.get(i) + " " + longitudes.get(i) + ")'));");
				database.execute("INSERT INTO placepoints (id, point) VALUES (" + ids.get(i) + ", GeomFromText('POINT(" + latitudes.get(i) + " " + longitudes.get(i) + ")'));");
			}

			System.out.println("lat size = " + latitudes.size());
			System.out.println("lng size = " + longitudes.size());
			System.out.println("id size = " + ids.size());
		}
		catch (Exception ex)
		{
			ex.printStackTrace();
		}
	}

	public static void PopulateDatabase()
	{
		Statement database = null;
		try
		{
			Class.forName("org.postgresql.Driver");
			Connection c = DriverManager.getConnection("jdbc:postgresql://localhost/GS3MapDB", "postgres", "admin");

			database = c.createStatement();

			BufferedReader gazetteerFile = new BufferedReader(new FileReader("C:\\Users\\sjm84\\Desktop\\EclipseWorkspace\\ATLAS\\war\\dataen.txt"));

			String line = "";
			while ((line = gazetteerFile.readLine()) != null)
			{
				// The file is tab seperated so split it by tabs
				String[] columns = line.split("\t");

				String placeName = GazetteerHelper.getMainPlaceName(columns);
				if (placeName != null)
				{
					placeName = placeName.replaceAll("\'", "\\\\\'");
				}
				String countryName = GazetteerHelper.getCountryName(columns);
				if (countryName != null)
				{
					countryName = countryName.replaceAll("\'", "\\\\\'");
				}
				String regionName = GazetteerHelper.getRegionName(columns);
				if (regionName != null)
				{
					regionName = regionName.replaceAll("\'", "\\\\\'");
				}
				String subRegionName = GazetteerHelper.getSubRegionName(columns);
				if (subRegionName != null)
				{
					subRegionName = subRegionName.replaceAll("\'", "\\\\\'");
				}
				String placeType = GazetteerHelper.getPlaceType(columns);
				if (placeType != null)
				{
					placeType = placeType.replaceAll("\'", "\\\\\'");
				}
				Float latitude = GazetteerHelper.getLatitude(columns);
				Float longitude = GazetteerHelper.getLongitude(columns);
				int population = GazetteerHelper.getPopulation(columns);
				Integer id = GazetteerHelper.getID(columns);

				ArrayList<String> alternatePlaceNames = GazetteerHelper.getAlternativePlaceNames(columns);

				// Because counties do not contain the region information they
				// are not helpful, so ignore them
				if (placeName == null || id == null || placeType == null || placeType.equals("county") || placeType.equals("agglomeration"))
				{
					continue;
				}

				try
				{
					/*
					 * System.out.println("Inserting ---> \n" +
					 * "INSERT INTO places (id, placename, placetype, subregion, region, country, population, latitude, longitude) VALUES("
					 * + id + ", " + "\'" + placeName + "\'" + ", " + "\'" +
					 * placeType + "\'" + ", " + (subRegionName == null ? "null"
					 * : ("\'" + subRegionName + "\'")) + ", " + (regionName ==
					 * null ? "null" : ("\'" + regionName + "\'")) + ", " +
					 * (countryName == null ? "null" : ("\'" + countryName +
					 * "\'")) + ", " + population + ", " + latitude + ", " +
					 * longitude + ");");
					 */
					database.execute("INSERT INTO places (id, placename, placetype, subregion, region, country, population, latitude, longitude) VALUES(" + id + ", " + "\'" + placeName + "\'" + ", " + "\'" + placeType + "\'" + ", " + (subRegionName == null ? "null" : ("\'" + subRegionName + "\'")) + ", " + (regionName == null ? "null" : ("\'" + regionName + "\'")) + ", " + (countryName == null ? "null" : ("\'" + countryName + "\'")) + ", " + population + ", " + latitude + ", " + longitude + ");");

					if (alternatePlaceNames != null)
					{
						for (String altName : alternatePlaceNames)
						{
							if (altName != null)
							{
								altName = altName.replaceAll("\'", "\\\\\'");
								/*
								 * System.out.println("INSERT INTO alternatenames (alternatename, placeindex) VALUES("
								 * + "\'" + altName + "\', " + id + ");");
								 */
								database.execute("INSERT INTO alternatenames (alternatename, placeindex) VALUES(" + "\'" + altName + "\', " + id + ");");
							}
						}
					}
				}
				catch (Exception ex)
				{
					ex.printStackTrace();
				}
			}
		}
		catch (Exception ex)
		{
			ex.printStackTrace();
		}
	}

	public static void DatabaseFix()
	{
		Statement database = null;

		try
		{
			Class.forName("org.postgresql.Driver");
			Connection c = DriverManager.getConnection("jdbc:postgresql://localhost/GS3MapDB", "postgres", "admin");

			database = c.createStatement();

			ResultSet results = database.executeQuery("SELECT * FROM places WHERE population >= 0;");

			ArrayList<String> placeNameList = new ArrayList<String>();
			ArrayList<String> subRegionList = new ArrayList<String>();
			ArrayList<String> regionList = new ArrayList<String>();
			ArrayList<String> countryList = new ArrayList<String>();

			while (results.next())
			{
				placeNameList.add(results.getString("placename"));
				subRegionList.add(results.getString("subregion"));
				regionList.add(results.getString("region"));
				countryList.add(results.getString("country"));
			}

			int counter = 0;
			while (counter < placeNameList.size())
			{
				String placeName = placeNameList.get(counter);
				String subRegionName = subRegionList.get(counter);
				String regionName = regionList.get(counter);
				String countryName = countryList.get(counter);

				System.out.println("* " + counter++ + " " + placeName);

				if (subRegionName != null)
				{
					ResultSet subRegionResults = database.executeQuery("SELECT * FROM places WHERE " + "placename = \'" + subRegionName.replaceAll("\'", "\\\\\'") + "\' AND " + "region = \'" + regionName.replaceAll("\'", "\\\\\'") + "\' AND " + "country = \'" + countryName.replaceAll("\'", "\\\\\'") + "\';");

					int count = 0;
					while (subRegionResults.next())
					{
						count++;
					}

					if (count == 0)
					{
						System.out.println("Adding " + subRegionName.replaceAll("\'", "\\\\\'"));

						database.execute("INSERT INTO places (placename, placetype, subregion, region, country, population, latitude, longitude) VALUES(" + "\'" + subRegionName.replaceAll("\'", "\\\\\'") + "\', " + "\'region\', " + "null, " + "\'" + regionName.replaceAll("\'", "\\\\\'") + "\', " + "\'" + countryName.replaceAll("\'", "\\\\\'") + "\', " + "0, " + "null, " + "null);");
					}
				}

				if (regionName != null)
				{
					ResultSet regionResults = database.executeQuery("SELECT * FROM places WHERE " + "placename = \'" + regionName.replaceAll("\'", "\\\\\'") + "\' AND " + "country = \'" + countryName.replaceAll("\'", "\\\\\'") + "\';");

					int count = 0;
					while (regionResults.next())
					{
						count++;
					}

					if (count == 0)
					{
						System.out.println("Adding " + regionName.replaceAll("\'", "\\\\\'"));

						database.execute("INSERT INTO places (placename, placetype, subregion, region, country, population, latitude, longitude) VALUES(" + "\'" + regionName.replaceAll("\'", "\\\\\'") + "\', " + "\'region\', " + "null, " + "null, " + "\'" + countryName.replaceAll("\'", "\\\\\'") + "\', " + "0, " + "null, " + "null);");
					}
				}

				if (countryName != null)
				{
					ResultSet countryResults = database.executeQuery("SELECT * FROM places WHERE " + "placename = \'" + countryName.replaceAll("\'", "\\\\\'") + "\';");

					int count = 0;
					while (countryResults.next())
					{
						count++;
					}

					if (count == 0)
					{
						System.out.println("Adding " + countryName.replaceAll("\'", "\\\\\'"));

						database.execute("INSERT INTO places (placename, placetype, subregion, region, country, population, latitude, longitude) VALUES(" + "\'" + countryName.replaceAll("\'", "\\\\\'") + "\', " + "\'country\', " + "null, " + "null, " + "null, " + "0, " + "null, " + "null);");
					}
				}
			}
		}
		catch (Exception ex)
		{
			ex.printStackTrace();
		}
	}

	public ScanResultSet getCorrectScanResultSet(int index)
	{
		ScanResultSet correctResultSet = null;

		if (index == 0)
		{
			correctResultSet = new ScanResultSet("australia", new Long[] { new Long(-24), /* Australia */
			new Long(196916913), /* Canberra */
			new Long(202101121), /* Sydney */
			new Long(-81), /* UK */
			new Long(-435), /* Tasmania */
			new Long(-101), /* Indonesia */
			new Long(-214), /* East_Timor */
			new Long(-170), /* PNG */
			new Long(-186), /* Solomon_Islands */
			new Long(-232), /* Vanuatu */
			new Long(-155), /* New_Caledonia */
			new Long(-165), /* New_Zealand */
			new Long(187916496), /* Melbourne */
			new Long(225177302), /* Brisbane */
			new Long(208973584), /* Perth */
			new Long(198283860), /* Adelaide */
			new Long(279283085), /* Darwin */
			new Long(-431), /* NSW */
			new Long(-430), /* ACT */
			new Long(301780683), /* Jakarta */
			new Long(-160), /* Netherlands */
			new Long(-1495), /* England */
			new Long(-434), /* South_Australia */
			new Long(-436), /* Victoria */
			new Long(-433), /* Queensland */
			new Long(-432), /* Northern_Territory */
			new Long(-437), /* WA */
			new Long(469532668), /* Gelibolu(Gallipoli) */
			new Long(-223), /* Christmas_Island */
			new Long(-3902), /* Cocos_Islands */
			new Long(-3900), /* Ashmore_and_Cartier */
			new Long(-3903), /* Coral_Sea_Islands */
			new Long(-157), /* Norfolk_Island */
			new Long(263120575), /* Cairns */
			new Long(-111), /* Japan */
			new Long(-152), /* Malaysia */
			new Long(-190), /* Singapore */
			new Long(-45), /* Canada */
			new Long(-188), /* Sudan */
			new Long(-105), /* Iraq */
			new Long(-161), /* Norway */
			new Long(-155), /* Kiribati */
			new Long(-163), /* Nauru */
			new Long(-217), /* Tuvalu */
			new Long(-54), /* China */
			new Long(-108), /* Italy */
			new Long(-231), /* Vietnam */
			new Long(222981344), /* Gold_Coast */
			new Long(205521175), /* Newcastle */
			new Long(196772922), /* Queanbeyan */
			new Long(200121087), /* Wollongong */
			new Long(230865256), /* Sunshine_Coast */
			new Long(169772729), /* Hobart */
			new Long(186728432), /* Geelong */
			new Long(254696678), /* Townsville */
			new Long(224817196), /* Toowoomba */
			new Long(174812713), /* Launceston */
			new Long(194216692), /* Albury */
			new Long(193964688), /* Wodonga */
			new Long(188816384), /* Ballarat */
			new Long(191696428), /* Bendigo */
			new Long(-126), /* Liechtenstein */
			new Long(-63), /* Denmark */
			new Long(-972), /* Aomen */
			new Long(-32), /* Bulgaria */
			new Long(-79), /* France */
			new Long(-140), /* Mali */
			new Long(-189), /* Sweden */
			new Long(-131), /* Luxembourg */
			new Long(510353874), /* Oxford */
			new Long(511974013), /* Cambridge */
			// new Long(509489990), /* London */
			new Long(-75), /* Fiji */
			new Long(-77), /* Micronesia */
			new Long(-138), /* Marshall Islands */
			new Long(-178), /* Palau */
			new Long(-234), /* Samoa */
			new Long(-213), /* Tonga */
			new Long(-232), /* Vanuatu */
			new Long(-169), /* French Polynesia */
			new Long(-155), /* New Caledonia */
			new Long(-233), /* Wallis and Futuna */
			new Long(-51), /* Cook Islands */
			new Long(-164), /* Niue */
			new Long(-210), /* Tokelau */
			new Long(-3912), /* Pitcairn */
			new Long(-22), /* American Samoa */
			new Long(-94), /* Guam */
			new Long(-3767), /* Hawaii */
			new Long(-143), /* Chile */
			new Long(-3907), /* Easter Island */
			new Long(-102), /* Ireland */
			new Long(-239), /* Isle of Man */
			new Long(-238), /* Jersey */
			new Long(-147), /* Malta */
			new Long(-14), /* Antigua and Barbuda */
			new Long(-40), /* Bahamas */
			new Long(-28), /* Barbados */
			new Long(-64), /* Dominica */
			new Long(-96), /* Guyana */
			new Long(-109), /* Jamaica */
			new Long(-117), /* Saint Kitts and Nevis */
			new Long(-227), /* Saint Vincent and The Grenadines */
			new Long(-216), /* Trinidad and Tobago */
			new Long(-44), /* Belize */
			new Long(-82), /* Grenada */
			new Long(-125), /* Saint Lucia */
			new Long(-37), /* Brunei */
			new Long(-185), /* Saudi Arabia */
			new Long(-203), /* Swaziland */
			new Long(-226), /* Vatican City */
			new Long(-11), /* Andorra */
			new Long(-33), /* Bahrain */
			new Long(-30), /* Belgium */
			new Long(-41), /* Bhutan */
			new Long(-114), /* Cambodia */
			new Long(-110), /* Jordan */
			new Long(-120), /* Kuwait */
			new Long(-129), /* Lesothol */
			new Long(-152), /* Malaysia */
			new Long(-135), /* Monaco */
			new Long(-134), /* Morocco */
			new Long(-166), /* Oman */
			new Long(-180), /* Qatar */
			new Long(-72), /* Spain */
			new Long(-208), /* Thailand */
			new Long(-12), /* United Arab Emirates */
			new Long(-85), /* Ghana */
			new Long(-1520), /* Ashanti */
			new Long(-2608), /* Johor */
			new Long(-2609), /* Kedah */
			new Long(-2610), /* Kelantan */
			new Long(-2614), /* Negeri Sembilan */
			new Long(-2615), /* Pahang */
			new Long(-2616), /* Perak */
			new Long(-2617), /* Perlis */
			new Long(-2621), /* Selangor */
			new Long(-2622), /* Terengganu */
			new Long(-158), /* Nigeria */
			new Long(350586393), /* Ibadan */
			new Long(-2677), /* Kano */
			new Long(-2691), /* Sokoto */
			new Long(-2682), /* Lagos */
			new Long(-221), /* Uganda */
			new Long(-265), /* Abu Dhabi */
			new Long(-267), /* Dubai */
			new Long(-270), /* Sharjah */
			new Long(-3891), /* Wallis and Futuna */
			new Long(-3895), /* Sigave */
			new Long(-246), /* Zambia */
			new Long(-245), /* South Africa */
			new Long(-29), /* Bangladesh */
			new Long(-42), /* Botswana */
			new Long(-53), /* Cameroon */
			new Long(-59), /* Cyprus */
			new Long(-88), /* Gambia */
			new Long(-104), /* India */
			new Long(-112), /* Kenya */
			new Long(-150), /* Malawi */
			new Long(-149), /* Maldives */
			new Long(-148), /* Mauritius */
			new Long(-153), /* Mozambique */
			new Long(-154), /* Namibia */
			new Long(-172), /* Pakistan */
			new Long(-187), /* Seychelles */
			new Long(-195), /* Sierra Leone */
			new Long(-127), /* Sri Lanka */
			new Long(-219), /* Tanzania */
			});
		}
		else if (index == 1)
		{
			correctResultSet = new ScanResultSet("canada", new Long[] { new Long(-3795), /*
																						 * Rhode
																						 * Island
																						 */
			new Long(-433), /* Queensland */
			new Long(-159), /* Nicaragua */
			new Long(-13), /* Afghanistan */
			new Long(-3785), /* New Hampshire */
			new Long(-3774), /* Louisiana */
			new Long(-121), /* Cayman Islands */
			new Long(498353663), /* Victoria */
			new Long(-3780), /* Mississippi */
			new Long(-96), /* Guyana */
			new Long(-115), /* Kiribati */
			new Long(-123), /* Laos */
			new Long(-90), /* Guadeloupe */
			new Long(-201), /* El Salvador */
			new Long(-126), /* Liechtenstein */
			new Long(474823250), /* Rome */
			new Long(-174), /* Saint Pierre and Miquelon */
			new Long(-47), /* Central African Republic */
			new Long(-838), /* British Columbia */
			new Long(490475686), /* Charlottetown */
			new Long(487450810), /* Sherbrooke */
			new Long(511747334), /* Saskatoon */
			new Long(-218), /* Taiwan */
			new Long(-149), /* Maldives */
			new Long(-220), /* Ukraine */
			new Long(503576283), /* Winnipeg */
			new Long(-3765), /* Florida */
			new Long(-837), /* Alberta */
			new Long(-108), /* Italy */
			new Long(-136), /* Moldova */
			new Long(-3901), /* Christmas Island */
			new Long(-59), /* Cyprus */
			new Long(-233), /* Wallis and Futuna */
			new Long(480465950), /* Kitchener */
			new Long(-51), /* Cook Islands */
			new Long(-849), /* Yukon */
			new Long(-91), /* Equatorial Guinea */
			new Long(-6751), /* Paris */
			new Long(-98), /* Croatia */
			new Long(-848), /* Saskatchewan */
			new Long(476289697), /* Windsor */
			new Long(-435), /* Tasmania */
			new Long(-189), /* Sweden */
			new Long(-144), /* Martinique */
			new Long(-204), /* Turks and Caicos Islands */
			new Long(-2614), /* Negeri Sembilan */
			new Long(-844), /* Nunavut */
			new Long(-168), /* Peru */
			new Long(-88), /* Gambia */
			new Long(-3767), /* Hawaii */
			new Long(-187), /* Seychelles */
			new Long(-221), /* Uganda */
			new Long(-207), /* Togo */
			new Long(-188), /* Sudan */
			new Long(-40), /* Bahamas */
			new Long(-216), /* Trinidad and Tobago */
			new Long(-246), /* Zambia */
			new Long(-65), /* Dominican Republic */
			new Long(-48), /* Congo */
			new Long(-177), /* Portugal */
			new Long(-999), /* Hong Kong */
			new Long(484823639), /* Halifax */
			new Long(-75), /* Fiji Islands */
			new Long(-164), /* Niue */
			new Long(520998673), /* Athabasca */
			new Long(-234), /* Samoa */
			new Long(-215), /* Turkey */
			new Long(-3900), /* Ashmore and Cartier */
			new Long(472726708), /* New Haven */
			new Long(505627539), /* Regina */
			new Long(-205), /* Chad */
			new Long(-182), /* Romania */
			new Long(-84), /* French Guiana */
			new Long(-137), /* Madagascar */
			new Long(-116), /* Comoros */
			new Long(-185), /* Saudi Arabia */
			new Long(-102), /* Ireland */
			new Long(-1495), /* England */
			new Long(481150062), /* Toronto */
			new Long(-152), /* Malaysia */
			new Long(-25), /* Aruba */
			new Long(-245), /* South Africa */
			new Long(489826804), /* Victoriaville */
			new Long(-135), /* Monaco */
			new Long(-145), /* Mauritania */
			new Long(-3762), /* Connecticut */
			new Long(-2620), /* Sarawak */
			new Long(-840), /* New Brunswick */
			new Long(-20), /* Antarctica */
			new Long(-173), /* Poland */
			new Long(-3757), /* Alaska */
			new Long(-32), /* Bulgaria */
			new Long(-83), /* Georgia */
			new Long(-61), /* Germany */
			new Long(-161), /* Norway */
			new Long(-57), /* Cuba */
			new Long(-56), /* Costa Rica */
			new Long(-104), /* India */
			new Long(-594), /* Luxemburg */
			new Long(-197), /* Senegal */
			new Long(-3777), /* Massachusetts */
			new Long(-2621), /* Selangor */
			new Long(-3776), /* Maryland */
			new Long(-154), /* Namibia */
			new Long(-846), /* Prince Edward Island */
			new Long(-845), /* Ontario */
			new Long(-125), /* Saint Lucia */
			new Long(-3788), /* New York */
			new Long(477873552), /* East Lansing */
			new Long(-3794), /* Pennsylvania */
			new Long(-3840), /* Grenadines */
			new Long(-217), /* Tuvalu */
			new Long(-72), /* Spain */
			new Long(-437), /* Western Australia */
			new Long(523014522), /* Slave Lake */
			new Long(-97), /* Honduras */
			new Long(-2612), /* Labuan */
			new Long(-76), /* Falkland Islands */
			new Long(-109), /* Jamaica */
			new Long(-2622), /* Terengganu */
			new Long(-42), /* Botswana */
			new Long(-171), /* Philippines */
			new Long(-134), /* Morocco */
			new Long(-99), /* Haiti */
			new Long(-79), /* France */
			new Long(-175), /* Puerto Rico */
			new Long(-2615), /* Pahang */
			new Long(-58), /* Cape Verde */
			new Long(-132), /* Latvia */
			new Long(-167), /* Panama */
			new Long(-34), /* Burundi */
			new Long(-2609), /* Kedah */
			new Long(504473703), /* Whistler */
			new Long(-227), /* Saint Vincent and The Grenadines */
			new Long(-151), /* Mexico */
			new Long(479746015), /* Hamilton */
			new Long(-138), /* Marshall Islands */
			new Long(-107), /* Iceland */
			new Long(-124), /* Lebanon */
			new Long(-129), /* Lesotho */
			new Long(-157), /* Norfolk Island */
			new Long(479134098), /* Niagara Falls */
			new Long(-229), /* British Virgin Islands */
			new Long(-192), /* Slovenia */
			new Long(-9192), /* Washington */
			new Long(-146), /* Montserrat */
			new Long(-31), /* Burkina Faso */
			new Long(-69), /* Egypt */
			new Long(501413687), /* Vancouver */
			new Long(-183), /* Russia */
			new Long(-165), /* New Zealand */
			new Long(-194), /* Slovakia */
			new Long(477765545), /* Lansing */
			new Long(-92), /* Greece */
			new Long(-208), /* Thailand */
			new Long(-213), /* Tonga */
			new Long(485470468), /* Iroquois */
			new Long(-77), /* Micronesia */
			new Long(-63), /* Denmark */
			new Long(-120), /* Kuwait */
			new Long(-226), /* Vatican City */
			new Long(-172), /* Pakistan */
			new Long(-3802), /* Virginia */
			new Long(-2616), /* Perak */
			new Long(-842), /* Northwest Territories */
			new Long(482014114), /* Oshawa */
			new Long(-53), /* Cameroon */
			new Long(-3778), /* Michigan */
			new Long(-3786), /* New Jersey */
			new Long(-247), /* Zimbabwe */
			new Long(-244), /* Serbia */
			new Long(-68), /* Estonia */
			new Long(488639613), /* Oxford */
			new Long(-186), /* Solomon Islands */
			new Long(-112), /* Kenya */
			new Long(-150), /* Malawi */
			new Long(-212), /* Tunisia */
			new Long(-54), /* China */
			new Long(-1520), /* Ashanti */
			new Long(523157692), /* Mackenzie */
			new Long(-3875), /* Saint Croix */
			new Long(-114), /* Cambodia */
			new Long(487882643), /* Montreal */
			new Long(-3789), /* North Carolina */
			new Long(-101), /* Indonesia */
			new Long(-2610), /* Kelantan */
			new Long(-52), /* Chile */
			new Long(-33), /* Bahrain */
			new Long(483490166), /* Peterborough */
			new Long(-176), /* Palestine */
			new Long(-166), /* Oman */
			new Long(-839), /* Manitoba */
			new Long(492022827), /* Donnacona */
			new Long(-156), /* Niger */
			new Long(-18), /* Netherlands Antilles */
			new Long(-3903), /* Coral Sea Islands */
			new Long(-60), /* Czech Republic */
			new Long(-843), /* Nova Scotia */
			new Long(-3753), /* Navassa Island */
			new Long(-847), /* Quebec */
			new Long(-841), /* Newfoundland and Labrador */
			new Long(-49), /* Switzerland */
			new Long(478701876), /* London */
			new Long(-3793), /* Oregon */
			new Long(516858646), /* Edmonton */
			new Long(-23), /* Austria */
			new Long(-1376), /* South Sandwich Islands */
			new Long(-100), /* Hungary */
			new Long(-36), /* Bermuda */
			new Long(-148), /* Mauritius */
			new Long(-21), /* Argentina */
			new Long(-210), /* Tokelau */
			new Long(511567873), /* Swan River */
			new Long(-111), /* Japan */
			new Long(-12), /* United Arab Emirates */
			new Long(-431), /* New South Wales */
			new Long(-3796), /* South Carolina */
			new Long(-127), /* Sri Lanka */
			new Long(-3902), /* Cocos Islands */
			new Long(-87), /* Greenland */
			new Long(-139), /* Macedonia */
			new Long(-110), /* Jordan */
			new Long(-3791), /* Ohio */
			new Long(507786594), /* Calgary */
			new Long(-117), /* Saint Kitts and Nevis */
			new Long(-184), /* Rwanda */
			new Long(-203), /* Swaziland */
			new Long(-238), /* Jersey */
			new Long(487522429), /* Ottawa */
			new Long(-434), /* South Australia */
			new Long(-180), /* Qatar */
			new Long(458717784), /* Stanford */
			new Long(-178), /* Palau */
			new Long(-41), /* Bhutan */
			new Long(-231), /* Vietnam */
			new Long(-24), /* Australia */
			new Long(-160), /* Netherlands */
			new Long(-86), /* Gibraltar */
			new Long(-3763), /* Delaware */
			new Long(-239), /* Isle of Man */
			new Long(-130), /* Lithuania */
			new Long(-199), /* Suriname */
			new Long(514267762), /* Hudson Bay */
			new Long(-82), /* Grenada */
			new Long(-190), /* Singapore */
			new Long(-95), /* Guinea-Bissau */
			});
		}
		else if (index == 2)
		{
			correctResultSet = new ScanResultSet("ireland", new Long[] { new Long(-1395), /* Asturias */
			new Long(512693027), /* Causeway */
			new Long(510137147), /* Kinsale */
			new Long(516005375), /* Dublin */
			new Long(515609332), /* Naas */
			new Long(-1496), /* Northern Ireland */
			new Long(518489358), /* Dundalk */
			new Long(474823250), /* Rome */
			new Long(512441352), /* Wexford */
			new Long(513737108), /* Shannon */
			// new Long(521009377), /* Antrim */
			new Long(514925071), /* Lisdoonvarna */
			new Long(-108), /* Italy */
			new Long(517121180), /* Roscommon */
			new Long(514097385), /* Arklow */
			new Long(519065365), /* Newry */
			new Long(-1497), /* Scotland */
			new Long(518561381), /* Carlingford */
			// new Long(519677333), /* Armagh */
			new Long(-1298), /* Galicia */
			new Long(514781395), /* Wicklow */
			new Long(522809335), /* Portrush */
			new Long(512477258), /* Carrick-on-Suir */
			new Long(-999), /* Hong Kong */
			new Long(517445219), /* Longford */
			new Long(-234), /* Samoa */
			new Long(514853389), /* Ashford */
			new Long(-102), /* Ireland */
			new Long(517625108), /* Knock */
			new Long(-1399), /* Barcelona */
			new Long(-1495), /* England */
			new Long(515825094), /* Galway */
			new Long(202101121), /* Sydney */
			new Long(512153287), /* Waterford */
			new Long(515393301), /* Kildare */
			new Long(-104), /* India */
			new Long(516725266), /* Mullingar */
			new Long(512981183), /* Tipperary */
			new Long(514745251), /* Castletown */
			new Long(510713170), /* Cobh */
			new Long(-1498), /* Wales */
			new Long(-3788), /* New York */
			new Long(519389141), /* Strandhill */
			new Long(517193331), /* Navan */
			new Long(-72), /* Spain */
			new Long(514241308), /* Carlow */
			new Long(520145171), /* Bundoran */
			new Long(513593274), /* Kilkenny */
			new Long(520793188), /* Donegal */
			new Long(519317303), /* Monaghan */
			new Long(478665434), /* Grand Rapids */
			new Long(519425152), /* Sligo */
			new Long(-81), /* United Kingdom */
			new Long(512045133), /* Buttevant */
			new Long(514601065), /* Lahinch */
			new Long(-79), /* France */
			new Long(-45), /* Canada */
			new Long(512513229), /* Clonmel */
			// new Long(520577407), /* Belfast */
			new Long(522017267), /* Londonderry */
			new Long(517409364), /* Drogheda */
			new Long(513017343), /* Enniscorthy */
			new Long(511037215), /* Youghal */
			new Long(-165), /* New Zealand */
			new Long(518237346), /* Louth */
			new Long(-3802), /* Virginia */
			new Long(527417729), /* Carnoustie */
			new Long(-3786), /* New Jersey */
			new Long(-247), /* Zimbabwe */
			new Long(516545775), /* Manchester */
			new Long(515897124), /* Athenry */
			new Long(510353874), /* Oxford */
			new Long(514061177), /* Silvermines */
			new Long(470674597), /* Hoboken */
			new Long(513089211), /* Cashel */
			new Long(520793432), /* Bangor */
			new Long(512657305), /* New Ross */
			new Long(509993050), /* Bantry */
			new Long(-101), /* Indonesia */
			new Long(513701217), /* Thurles */
			// new Long(520289394), /* Lisburn */
			new Long(511001143), /* Blarney */
			new Long(511684975), /* Dingle */
			new Long(-3139), /* Moscow */
			new Long(516797320), /* Trim */
			new Long(-6055), /* London */
			new Long(-6030), /* Cornwall */
			new Long(-111), /* Japan */
			// new Long(521477418), /* Larne */
			new Long(-87), /* Greenland */
			new Long(510929183), /* Midleton */
			new Long(510857153), /* Cork */
			new Long(-228), /* Venezuela */
			new Long(518417263), /* Cavan */
			new Long(513629137), /* Limerick */
			new Long(514349180), /* Nenagh */
			new Long(-24), /* Australia */
			new Long(-256907), /* Killarney */
			new Long(-239), /* Isle of Man */
			new Long(497323158), /* Munich */
			// new Long(522485331), /* Coleraine */
			});
		}
		else if (index == 3)
		{
			correctResultSet = new ScanResultSet("southafrica", new Long[] { new Long(-245), /*
																							 * South
																							 * Africa
																							 */
			new Long(231392822), /* Pretoria */
			new Long(219080623), /* Bloemfontein */
			new Long(201871846), /* Cape Town */
			new Long(229736804), /* Johannesburg */
			new Long(-81), /* United Kingdom */
			new Long(-154), /* Namibia */
			new Long(-42), /* Botswana */
			new Long(-153), /* Mozambique */
			new Long(-203), /* Swaziland */
			new Long(-129), /* Lesotho */
			new Long(-3991), /* KwaZulu Natal */
			new Long(-3988), /* Eastern Cape */
			new Long(-101), /* Indonesia */
			new Long(-137), /* Madagascar */
			new Long(-24), /* Australia */
			new Long(-101), /* Indonesia */
			new Long(-104), /* India */
			new Long(-3990), /* Gauteng */
			new Long(-3992), /* Limpopo */
			new Long(-3993), /* Mpumalanga */
			new Long(-3995), /* North West */
			new Long(-34), /* Burundi */
			new Long(-116), /* Comoros */
			new Long(-247), /* Zimbabwe */
			new Long(-3994), /* Northern Cape */
			new Long(-3989), /* Free State */
			new Long(-3996), /* Western Cape */
			new Long(205688739), /* Bhisho */
			new Long(217425039), /* Pietermaritzburg */
			new Long(238016945), /* Polokwane */
			new Long(232329098), /* Nelspruit */
			new Long(220520477), /* Kimberley */
			new Long(238016945), /* Polokwane */
			new Long(231032561), /* Mmabatho */
			new Long(-55), /* Colombia */
			new Long(-78614), /* Sutherland */
			new Long(221564123), /* Upington */
			new Long(203132219), /* Oudtshoorn */
			new Long(-39), /* Brazil */
			new Long(-54), /* China */
			new Long(-151), /* Mexico */
			new Long(201764559), /* Port Elizabeth */
			new Long(-133), /* Libya */
			new Long(216489099), /* Durban */
			new Long(-148), /* Mauritius */
			new Long(-150), /* Malawi */
			new Long(-61), /* Germany */
			new Long(-111), /* Japan */
			new Long(-72), /* Spain */
			new Long(201907886), /* Stellenbosch */
			new Long(202699896), /* Paarl */
			new Long(-79), /* France */
			new Long(445545558), /* Atlanta */
			new Long(-14), /* Antigua and Barbuda */
			new Long(-40), /* Bahamas */
			new Long(-28), /* Barbados */
			new Long(-64), /* Dominica */
			new Long(-96), /* Guyana */
			new Long(-109), /* Jamaica */
			new Long(-117), /* Saint Kitts and Nevis */
			new Long(-227), /* Saint Vincent and The Grenadines */
			new Long(-216), /* Trinidad and Tobago */
			new Long(-44), /* Belize */
			new Long(-82), /* Grenada */
			new Long(-125), /* Saint Lucia */
			new Long(-37), /* Brunei */
			new Long(-185), /* Saudi Arabia */
			new Long(-203), /* Swaziland */
			new Long(-33), /* Bahrain */
			new Long(-30), /* Belgium */
			new Long(-120), /* Kuwait */
			new Long(-129), /* Lesothol */
			new Long(-152), /* Malaysia */
			new Long(-134), /* Morocco */
			new Long(-166), /* Oman */
			new Long(-180), /* Qatar */
			new Long(-72), /* Spain */
			new Long(-208), /* Thailand */
			new Long(-12), /* United Arab Emirates */
			new Long(-85), /* Ghana */
			new Long(-158), /* Nigeria */
			new Long(-221), /* Uganda */
			new Long(-246), /* Zambia */
			});
		}
		else if (index == 4)
		{
			correctResultSet = new ScanResultSet("washington", new Long[] { new Long(-3795), /*
																							 * Rhode
																							 * Island
																							 */
			new Long(498317769), /* Mount Vernon */
			new Long(-3750), /* Johnston Atoll */
			new Long(-3785), /* New Hampshire */
			new Long(-3774), /* Louisiana */
			new Long(-3780), /* Mississippi */
			new Long(496193763), /* Edmonds */
			new Long(498605777), /* Sedro-Woolley */
			new Long(493781747), /* Lakewood */
			new Long(491729947), /* Yakima */
			new Long(492197704), /* Centralia */
			new Long(-838), /* British Columbia */
			new Long(495113796), /* Issaquah */
			new Long(493349711), /* Olympia */
			new Long(493205945), /* Ellensburg */
			new Long(-3797), /* South Dakota */
			new Long(494970242), /* Cheney */
			new Long(493961689), /* Shelton */
			new Long(-3765), /* Florida */
			new Long(-3756), /* Alabama */
			new Long(494321766), /* Federal Way */
			new Long(496661780), /* Everett */
			new Long(-3768), /* Idaho */
			new Long(-3748), /* Howland Island */
			new Long(495618259), /* Spokane */
			new Long(496049769), /* Mountlake Terrace */
			new Long(-849), /* Yukon */
			new Long(495257777), /* Mercer Island */
			new Long(489858166), /* Walla Walla */
			new Long(-3747), /* Baker Island */
			new Long(-3771), /* Iowa */
			new Long(-3790), /* North Dakota */
			new Long(-3770), /* Indiana */
			new Long(-3779), /* Minnesota */
			new Long(490362023), /* Prosser */
			new Long(-3767), /* Hawaii */
			new Long(-3782), /* Montana */
			new Long(495581748), /* Bainbridge Island */
			new Long(495618276), /* Spokane Valley */
			new Long(496229998), /* Chelan */
			new Long(490830295), /* Asotin */
			new Long(-3787), /* New Mexico */
			new Long(488957885), /* Klickitat */
			new Long(494717971), /* East Wenatchee */
			new Long(-3760), /* California */
			new Long(493205708), /* Tumwater */
			new Long(496949759), /* Langley */
			new Long(490326083), /* Kennewick */
			new Long(492809731), /* Rainier */
			new Long(497849738), /* Oak Harbor */
			new Long(-3755), /* Wake */
			new Long(494645769), /* Des Moines */
			new Long(496698102), /* Coulee Dam */
			new Long(495365784), /* Bellevue */
			new Long(498569737), /* Anacortes */
			new Long(496590100), /* Grand Coulee */
			new Long(490865595), /* Long Beach */
			new Long(490757999), /* Sunnyside */
			new Long(-3762), /* Connecticut */
			new Long(494537790), /* Covington */
			new Long(-3758), /* Arizona */
			new Long(-3757), /* Alaska */
			new Long(-3783), /* Nebraska */
			new Long(495653781), /* Kirkland */
			new Long(-3777), /* Massachusetts */
			new Long(494933780), /* Renton */
			new Long(-3776), /* Maryland */
			new Long(496193770), /* Lynnwood */
			new Long(-3801), /* Vermont */
			new Long(496553769), /* Mukilteo */
			new Long(-3788), /* New York */
			new Long(495185730), /* Bremerton */
			new Long(490650065), /* West Richland */
			new Long(494285779), /* Auburn */
			new Long(-3761), /* Colorado */
			new Long(-3794), /* Pennsylvania */
			new Long(491045974), /* Zillah */
			new Long(488813747), /* Battle Ground */
			new Long(-3784), /* Nevada */
			new Long(490506087), /* Pasco */
			new Long(494537796), /* Maple Valley */
			new Long(495905764), /* Shoreline */
			new Long(498786210), /* Colville */
			new Long(495941776), /* Kenmore */
			new Long(453969645), /* New Market */
			new Long(493853772), /* Puyallup */
			new Long(494933773), /* Tukwila */
			new Long(493133958), /* Kittitas */
			new Long(-3798), /* Tennessee */
			new Long(487949734), /* Portland */
			new Long(-151), /* Mexico */
			new Long(-45), /* Canada */
			new Long(-3775), /* Maine */
			new Long(494789770), /* SeaTac */
			new Long(495005821), /* North Bend */
			new Long(495293790), /* Sammamish */
			new Long(-3805), /* Wisconsin */
			new Long(-9192), /* Washington */
			new Long(496301780), /* Mill Creek */
			new Long(493925801), /* Enumclaw */
			new Long(490073711), /* Kelso */
			new Long(488273736), /* Vancouver */
			new Long(-183), /* Russia */
			new Long(495941780), /* Bothell */
			new Long(499469753), /* Bellingham */
			new Long(-3802), /* Virginia */
			new Long(497021785), /* Marysville */
			new Long(-3799), /* Texas */
			new Long(494105754), /* Tacoma */
			new Long(-3778), /* Michigan */
			new Long(-3786), /* New Jersey */
			new Long(-3759), /* Arkansas */
			new Long(493925906), /* Cle Elum */
			new Long(495149736), /* Port Orchard */
			new Long(493601742), /* Fort Lewis */
			new Long(494861765), /* Burien */
			new Long(493638071), /* Moses Lake */
			new Long(497525788), /* Arlington */
			new Long(496517791), /* Snohomish */
			new Long(493242286), /* Garfield */
			new Long(-8340), /* District of Columbia */
			new Long(-3749), /* Jarvis Island */
			new Long(-3789), /* North Carolina */
			new Long(497489654), /* Port Angeles */
			new Long(-101), /* Indonesia */
			new Long(490650071), /* Richland */
			new Long(495617789), /* Redmond */
			new Long(-3806), /* Wyoming */
			new Long(-3772), /* Kansas */
			new Long(498102042), /* Okanogan */
			new Long(-3753), /* Navassa Island */
			new Long(493133619), /* Aberdeen */
			new Long(-3781), /* Missouri */
			new Long(495905789), /* Woodinville */
			new Long(493997746), /* University Place */
			new Long(-3793), /* Oregon */
			new Long(-3769), /* Illinois */
			new Long(495365934), /* Leavenworth */
			new Long(494753968), /* Wenatchee */
			new Long(-3773), /* Kentucky */
			new Long(-3800), /* Utah */
			new Long(-3796), /* South Carolina */
			new Long(488093765), /* Washougal */
			new Long(494609776), /* Kent */
			new Long(495437765), /* Seattle */
			new Long(496301801), /* Monroe */
			new Long(-3791), /* Ohio */
			new Long(-3804), /* West Virginia */
			new Long(-3751), /* Kingman Reef */
			new Long(490145705), /* Longview */
			new Long(490506009), /* Grandview */
			new Long(492234284), /* Pullman */
			new Long(500225754), /* Lynden */
			new Long(493889783), /* Bonney Lake */
			new Long(495941771), /* Lake Forest Park */
			new Long(-3763), /* Delaware */
			new Long(488129758), /* Camas */
			new Long(493313719), /* Lacey */
			new Long(-3792), /* Oklahoma */
			});
		}
		return correctResultSet;
	}
}