knn output contains latitude and longitude

[jakerbrown]

The output from knn.sql includes the latitude and longitude of (I assume) each neighbor? This does not seem necessary and greatly increases the size of the files.

[dkakkar]

It is the lat/lon of each voter (source_id). You can edit the script to delete that. I included it thinking it will be useful if you would like to visualize the results. Please remove the following from the SELECT statement to delete it, rest remains the same:

"a.lat as source_lat, a.lon as source_lon"