convertlatitude longitude
I have a database with a list of address and their location as an East and North coordinate. An example is:
East=431833
North=336684
Postcode=DE22 4LF
When I try to convert this address using this tool:
http://www.engineeringtoolbox.com/utm-latitude-longitude-d_1370.html
The result in longitude and latitude in Google gives me a location in Africa, not England where the address actually is.
Can anyone tell me which format the East and North coordinates are in and how to convert them?
With arcmap,
add the csv and use the lat longs to create an event table. (right click layer> "Display XY Data")
This creates an event layer with the table and a point layer (not a real point layer, it needs to be exported later)
set the document projection (data frame properties) to the desired output of the file. (right click layers "in the TOC">properties> coordinate system tab).
right click the layer in TOC > Export Data
Use the option to "use the same coordinate system as: the data frame"
Seems to be http://en.wikipedia.org/wiki/UN/LOCODE
Coordinate syntax explained in http://www.unece.org/fileadmin/DAM/cefact/locode/Service/LocodeColumn.htm#Coordinates
1.10 Column "Coordinates"
This column contains the geographical coordinates (latitude/longitude) of the location, if there is any.
In order to avoid unnecessary use of non-standard characters and space, the following standard presentation is used:
0000lat 00000long
(lat - Latitude: N or S ; long – Longitude: W or E, only one digit, capital letter) Where the last two rightmost digits refer to minutes and the first two or three digits refer to the degrees for latitude and longitude respectively. In addition, you must specify N or S for latitude and W or E for longitude, as appropriate.
Best Answer
Your coordinates are Ordnance Survey GB (OSGB36 Airy 1830 ellipsoid) 431833,336684 (base on a false origin with the Transverse Mercator projection. http://en.wikipedia.org/wiki/Ordnance_Survey_National_Grid
To convert them correctly to Lat/Lng
Use this site:http://www.nearby.org.uk
example: http://www.nearby.org.uk/coord.cgi?p=431833%2C336684 look for the result in yellow Converts to 52.926628 -1.527923 (WGS84)
copy and paste into google maps
https://maps.google.co.uk/maps?q=52.926628+-1.527923&hl=en&ll=52.926598,-1.5278&spn=0.00098,0.002792&sll=55.378051,-3.435973&sspn=15.177344,45.74707&t=m&z=19
You can also just use the postcode for google maps
https://maps.google.co.uk/maps?q=DE22+4LF&hl=en&ll=52.927293,-1.528076&spn=0.003919,0.011169&sll=52.926598,-1.5278&sspn=0.00098,0.002792&hnear=Derby+DE22+4LF,+United+Kingdom&t=m&z=17
Which returns the correct location - as is automatically geocoded into lat/lng coordinates