Looking to plot 90 locations onto a UK map. I have Eastings/Northings data.
Any ideas for someone who is not a mathematician or computing expert (but happy working with excel and basic stats programs)
Cheers for any help.
Chat Forum
Mapping easting/northings onto a UK map
-
Posted 10 months ago #
-
I did it (a long time ago) like this...
http://scotroutes.com/Routes/Baggers%20Ticklist%20v2%20-%20CC.xls
Posted 10 months ago # -
That looks ideal, now for the numpty questions, how did you insert the map and need one for northwest of England.
Is it too late to admit this actually for my wife now?
Posted 10 months ago # -
I'm not sure what your actually asking but if you want to convert grid positions into Lat/Long use this:-
You could then plot them on Google Earth.
You can plot the grid positions with autocad and then geo reference the result, needs a bit of knowledge though.Posted 10 months ago # -
What sort of map are you hoping to end up with, a static map that could be used in say a presentation or something more interactive?
You should be able to get something to use as background mapping through OS Opendata.
http://www.ordnancesurvey.co.uk/oswebsite/opendata/
If it was me I'd use a GIS program to plot the locations straight from the excel spreadsheet if I was after a static map. QGIS is opensource and free.
Posted 10 months ago # -
There are free Excel sheets online to do OS grid to lat lon conversion, have a google for them....
Posted 10 months ago # -
If you're plotting eastings and northings on a UK map then doing the lat lon conversion seems like a waste of time to me.
Posted 10 months ago #
Reply
You must log in to post.
