 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
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.
I did it (a long time ago) like this...
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?
I'm not sure what your actually asking but if you want to convert grid positions into Lat/Long use this:-
[url= http://www.ordnancesurvey.co.uk/oswebsite/gps/osnetfreeservices/furtherinfo/questsoftware.html ]OS grid program[/url]
or [url= http://gps.ordnancesurvey.co.uk/convert.asp ]OS grid on line[/url]
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.
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.
There are free Excel sheets online to do OS grid to lat lon conversion, have a google for them....
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.