These notes are for the FMS migration from OSGB36 to WGS84 coordinates. Reference: easting === longitude northing === latitude http://en.wikipedia.org/wiki/Ordnance_Survey_National_Grid http://en.wikipedia.org/wiki/World_Geodetic_System DB: * dump schema from live db and confirm it matches schema.sql (you never know...) DONE: use PledgeBank's 'nearby' logic in problem_find_nearby() SQL function DONE: in 'alerts' table convert parameter and parameter2 if alert is 'local_problems' or 'local_problems_state' CODE: DONE: update all calls to problem_find_nearby swapping parameter order. * find all occurences of 'easting', 'northing', $e, $n etc and migrate * email me link broken on http://herring/?lat=51.4545595517093;lon=-0.23100115932431 * Cobrand.pm * Cobrands/Barnet/Util.pm * Cobrands/Emptyhomes/Util.pm * CronFns.pm * CrossSell.pm * EastHantsWSDL.pm * FixMyStreet/Alert.pm * FixMyStreet/Geocode.pm * FixMyStreet/Map.pm * FixMyStreet/Map/Bing.pm * FixMyStreet/Map/BingOL.pm * FixMyStreet/Map/Google.pm * FixMyStreet/Map/OSM.pm * FixMyStreet/Map/OSM/CycleMap.pm * FixMyStreet/Map/OSM/StreetView.pm * FixMyStreet/Map/Tilma/OL/1_10k.pm * FixMyStreet/Map/Tilma/OL/StreetView.pm * FixMyStreet/Map/Tilma/Original.pm * FixMyStreet/Map/Tilma/Original/1_10k.pm * FixMyStreet/Map/Tilma/Original/StreetView.pm * Memcached.pm * Page.pm * PoChange.pm * Problems.pm * Standard.pm * Utils.pm * web/about.cgi * web/ajax.cgi * web/alert.cgi * web/confirm.cgi * web/contact.cgi * web/faq.cgi * web/flickr.cgi * web/fun.cgi * web/import.cgi * web/index.cgi * web/json.cgi * web/photo.cgi * web/questionnaire.cgi * web/reports.cgi * web/rss.cgi * web/test.cgi * web/tms-signup.cgi * web/upload.cgi DONE: all scripts checked UI maps: * Tilma js code will still need eastings and northings * All other maps should be able to switch to latlon