Jump to the following:

OS uses cookies to improve this website. Read about cookies

  • twitter
  • Google+
  • facebook

OS OpenData Forum

OpenData coordinate conversion

cpblackburn
    • 2 August 2017 11:58AM
    • 864 Views
    • Visits: 1
    • Discussions: 1
    • Responses: 1
    • Registered: 2 August 2017 11:50AM
    • Last active: 20 February 2018 03:10PM

    Does anyone know how to covert the OpenData X and Y coordinates into the equivalet latitude and longitude values ?

    X & Y values are provided in CSV files in the GEOMETRY_X (column I) and GEOMETRY_Y (column J) when viewed in Excel. The same coordinates are also used in the MBR_XMIN, MBR_YMIN, MBR_XMAX and MBR_YMAX columns for the bounding box.

    2 responses

    neilmcfadyen
      • 14 August 2017 03:59PM
      • 845 Views
      • Visits: 37
      • Discussions: 7
      • Responses: 26
      • Registered: 29 August 2013 11:54AM
      • Last active: 13 September 2018 07:40AM

      How you approach this depends on the level of precision you're looking for. Assuming the data you're converting is in OSGB1936, there are plenty online converters - this one allows you to submit a batches of coordinates:
      http://www.gridreferencefinder.com/batchConvert/batchConvert.php

      There's a more details OS guide and a spreadsheet for conversions here:
      https://www.ordnancesurvey.co.uk/business-and-government/help-and-support/navigation-technology/os-net/coordinate-spreadsheet.html

      cpblackburn
        • 17 August 2017 11:26AM
        • 819 Views
        • Visits: 1
        • Discussions: 1
        • Responses: 1
        • Registered: 2 August 2017 11:50AM
        • Last active: 20 February 2018 03:10PM

        Many thanks for responses.
        It would appear a coordinate conversion from OS X&Y to lat/long will need to be written to convert the OS data into something that can easiliy be drawn on our map.

        There may be responses for this discussion that are currently awaiting moderation and not visible yet.

        Please login or sign-up to respond to this discussion.

        © Ordnance Survey 2018