Solved

eastings and northings conversion

Posted on 2011-02-23
8
1,469 Views
Last Modified: 2012-06-22

Hi All,

i am looking to convert a long list of Milton Keynes postcodes from eastings and northings to longtitude and latitude.

Due to the number of items to convert (14,700) i would like to do this via a script or free software program but the ones I have tried have failed.

Can anyone shed some light on what I could try to achieve this?

Many Thanks in advance.

Steve.




0
Comment
Question by:steve_york
8 Comments
 
LVL 16

Expert Comment

by:dhsindy
Comment Utility
eastings and northings are for grid zones that are assigned around the world.  You would have to know which grid to know where the origin is located.  I used them years ago but I will have to go back and research it.
0
 
LVL 17
Comment Utility
I remember seeing a test on softwares that did this for some mapping application, it was a few years ago, but I'll see if I can find it.
0
 
LVL 17
Comment Utility
Here's a converting tool, but I can't tell with my mobile if it's downloadable.

http://www.nearby.org.uk/conversions.cgi
0
 
LVL 17
Comment Utility
There is some downloadable code from that page.
This is for a java download to convert  WGS84 to OSGB or the reverse:

http://www.nearby.org.uk/tests/GeoTools.html

eg. WGS84 Decimal latitude 51.59762 and longitude  -2.39794

OSGB Grid Ref  ST 72533 88828

There must be a northing-easting conversion somewhere.
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 17
Comment Utility
getting closer, and this one offers a spreadsheet for bulk conversions:

http://www.dmap.co.uk/ll2tm.htm
0
 

Author Comment

by:steve_york
Comment Utility
Wow,

Thanks for your  help so far on this experts, really appreciate it.

I have found this but can anyone tell me what options I would need to select to convert the attached mk.csv file:

http://gps.ordnancesurvey.co.uk/convertbatch.asp?location=0

Thanks in advance for your help.

Steve


 mk.csv
0
 
LVL 62

Accepted Solution

by:
☠ MASQ ☠ earned 500 total points
Comment Utility
Your OS CodePoint Open file is in OSGB36 - there's nothing on the OS site that will convert that (possibly to encourage you to use the paid-for version of CodePoint)
If this is a one off conversion try the 7 day trial of Franson's CoordTransPro which has a batch import mode.
If it's longer term a single license is about £40.
That should help you sort your Westcrofts from your Wolvertons :)
0
 

Author Closing Comment

by:steve_york
Comment Utility
This why EE membership is 110% worth it.

It was only the one off conversion I needed and this software allowed me to do just that.

A friend shortly after me converting this found this site:

http://www.doogal.co.uk/UKPostcodes.php?Search=MK

- I really wish I had seen this a few days ago but at least thats done now and thanks for your help experts.

Regards

Steve.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

Learn more about the importance of email disclaimers with our top 10 email disclaimer DOs and DON’Ts.
This story has been written with permission from the scammed victim, a valued client of mine – identity protected by request.
Articles on a wide range of technology and professional topics are available on Experts Exchange. These resources are written by members, for members, and can be written about any topic you feel passionate about. Learn how to best write an article t…
Where to go on the main page to find the job listings. How to apply to a job that you are interested in from the list that is featured on our Careers page.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now