update queries to include APs with a NULL location value