Topic: Update Location using Location name
I am revisiting this after a while so bear with me.
I increasingly have the need to report on defined Locations (LWS) in large quantities
I understand that Locations within R6 should be able to help me do this but we have never really used that part of the db for various reasons.
I would like to retrospectively update records with Locations using either the Location name (which is usually recognisable as the Location in some form or another, preferred) or GIS boundary (time consuming, not preferred!).
Charlie kindly suggested some SQL to help with this last time i asked (http://forums.nbn.org.uk/viewtopic.php?id=6218), but i was unable to get it to work against our db and don't have the experience to adapt it.