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
    • 280 Views
    • Visits: 0
    • Discussions: 1
    • Responses: 0
    • Registered: 2 August 2017 11:50AM
    • Last active: 2 August 2017 11:50AM

    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.

    3 responses

    neilmcfadyen
      • 14 August 2017 03:59PM
      • 260 Views
      • Visits: 34
      • Discussions: 7
      • Responses: 23
      • Registered: 29 August 2013 11:54AM
      • Last active: 20 October 2017 10:53AM

      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

      jeffback
        • 14 August 2017 04:23PM
        • 258 Views
        • Visits: 1
        • Discussions: 0
        • Responses: 1
        • Registered: 14 August 2017 04:04PM
        • Last active: 19 August 2017 08:38AM

        Perhaps this tutorial is not quite on the topic, but it still explains some common points:
        http://support.esri.com/en/technical-article/000012745

        To understand the values and coordinates, you can read more about this blog, where examples of the group frequency distribution table are given.

        cpblackburn
          • 17 August 2017 11:26AM
          • 235 Views
          • Visits: 0
          • Discussions: 1
          • Responses: 0
          • Registered: 2 August 2017 11:50AM
          • Last active: 2 August 2017 11:50AM

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

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

          © Ordnance Survey 2016