diff options
| author | Edmund von der Burg <evdb@mysociety.org> | 2011-02-07 18:57:27 +0000 |
|---|---|---|
| committer | Edmund von der Burg <evdb@mysociety.org> | 2011-02-07 18:57:27 +0000 |
| commit | 6ddd88aad0c8e530b85f28d1917782dadedee10e (patch) | |
| tree | 497621b5aecd74da1adf3b713388d06f67c44dcd /notes | |
| parent | 6f749c7108dd3d8c961faaec5fe4012c92c68cd3 (diff) | |
Notes on the steps needed to migrate
Diffstat (limited to 'notes')
| -rw-r--r-- | notes/osgb36_to_wgs84_notes.txt | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/notes/osgb36_to_wgs84_notes.txt b/notes/osgb36_to_wgs84_notes.txt index eeadbe887..71d36e2fd 100644 --- a/notes/osgb36_to_wgs84_notes.txt +++ b/notes/osgb36_to_wgs84_notes.txt @@ -2,12 +2,21 @@ 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...) * use PledgeBank's 'nearby' logic in problem_find_nearby() SQL function + * in 'alerts' table convert parameter and parameter2 if alert is 'local_problems' or 'local_problems_state' + +CODE: + + * update all calls to problem_find_nearby swapping parameter order. UI maps: |