new location_by_id query

[chrisbc]

field renaming for consistency:

• location_code -> location_id;
• code -> location_id;