KNN calculation

• Login to Postgis node

ssh $node

screen

• Replace the name of state which you want to calculate in the script

vi /n/holyscratch01/enos_lab/dkakkar/partisan/knn.sql

%s/$oldstate/newstate/g

• Run the knn script

time psql -h localhost -p $port -d $database -f /n/holyscratch01/enos_lab/dkakkar/partisan/knn.sql

• The above script will create the result table in the database
• Now run the export script to export the tables