Skip to main content
  • EN

Hi all.

As it says in the title, all I need is to find an API (XML, not JSON) that will convert 1 easting and northing (OSGB) to latitude and longitude. I must not use macros.

That's it.

I can find API's that convert postcodes to Lat Lon, but nothing so far for East North.

My spreadsheet (LibreOffice) has a chart with all the points displayed using using Eastings for X, and Northings for Y.

It finds the max & min co-ords, adds them together and divides by 2 to give the centre of all the co-ords in the form 280827,716553 (centering, in this case, roughly east of Edinburgh).

It would use the "central" East North to point the user to an Openstreetmap, which unfortunately wants Lat & Long in the format :

https://www.openstreetmap.org/#map=9/56.335159/-3.9475065

 

Nothing fancy, just one East North to one Lat Long. Doesn't even have to be that accurate.

I don't suppose there's a formula that would do it...

Anyone?

Could it be that you're looking for the GridInQuestIIReprojector transformer?

"[...] GridInQuestIIReprojector to transform coordinates between ETRS89 (WGS84) and the national coordinate systems of Great Britain, Northern Ireland and the Republic of Ireland."

Don't think so. It's not an API as far as I can see. If there is a link to an API in there, it is well hidden.

Why does it have to be an API? Can't you use a regular transformer that does the calculations on your local machine?

Because it a spreadsheet that asks the API for the answer using =FILTERXML(WEBSERVICE()

For instance: in 2 separate cells, there are the formulae:

=FILTERXML(WEBSERVICE("http://www.geopostcode.org.uk/api/"&A1;&""),"//osgb36/east"))

=FILTERXML(WEBSERVICE("http://www.geopostcode.org.uk/api/"&A1;&""),"//osgb36/North"))

They look up Goepostcode's API to return East & North for whatever postcode has been entered into cell A1.

My spreadsheet needs one to convert East/North to Lat/Long.

I am designing this spreadsheet for about 20 other groups as well as myself to process members, and their position on a map to one another.

P.S. GridInQuestIIReprojector costs money.

Hi @alistairfitchie,

For an online converter, you may want to look at http://www.nearby.org.uk/coord-entry.html.

Been there many times.

Unless it's an API, it's no good.

It does mention API on the top right, but is totally useless as far as giving one. It requires a key, and that usually involves money.

Actually, I have just tried it.

Totally useless.

Filterxml always comes up #VALUE? as webpage is badly designed

I was looking for the same, and ended up building my own, which you are free to access.

It meets all of @alistairfitchie's requirements:

  • API
  • XML
  • Takes OSGB36 easting and northing (British National Grid)
  • Outputs WGS84 latitude and longitude

Syntax:

https://api.getthedata.com/bng2latlong//easting]/hnorthing]/xml

Example:

https://api.getthedata.com/bng2latlong/529090/179645/xml

Full documentation:

https://www.getthedata.com/bng2latlong

I was looking for the same, and ended up building my own, which you are free to access.

It meets all of @alistairfitchie's requirements:

  • API
  • XML
  • Takes OSGB36 easting and northing (British National Grid)
  • Outputs WGS84 latitude and longitude

Syntax:

https://api.getthedata.com/bng2latlong//easting]/hnorthing]/xml

Example:

https://api.getthedata.com/bng2latlong/529090/179645/xml

Full documentation:

https://www.getthedata.com/bng2latlong

Thank you.  I will definitely try that...

Reply


Community Stats

30,351
Posts
115,342
Replies
38,083
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.