search

cga-harvard / Data_Science_Big_Data_Projects

Repository for FASRC projects
MIT License
8 stars 3 forks source link

knn output contains latitude and longitude #9

Open jakerbrown opened 4 years ago

jakerbrown commented 4 years ago

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 commented 4 years ago

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"