API to convert east north to lat long
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?
Actually, I have just tried it.
Totally useless.
Filterxml always comes up #VALUE? as webpage is badly designed
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.
Hi @alistairfitchie,
For an online converter, you may want to look at http://www.nearby.org.uk/coord-entry.html.
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.
Why does it have to be an API? Can't you use a regular transformer that does the calculations on your local machine?
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.
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."
