Issue with contractors GIS format used for their tracking system.

[MKH2001]

Anyone seen a Format like this.

Latitude Longitude
5136.0770N 00035.5890E
5136.0814N 00035.5937E
5136.5631N 00034.8301E
5135.7585N 00034.4094E
5135.2930N 00033.3064E
5135.3990N 00031.5775E
5135.5574N 00029.8621E

Does not seem to be any standard positive or negative.... assume it is Degrees (Lat and Long) but any ideas how I can convert it (and how many processes might be required) into eastings and northings?
Was thinking could import it into a database which then trims the S/N or E/W Suffixes and where necessary (N or W) enters a negative value symbol?

Anyone seen that before.
Is there a way I can translate my esri project into a similar format so instead of a whole conversion process (in theory will be many files being submitted daily) I could just import?

Thanks in advance for any light anyone might be able to shed.

 

[oharab]

Looking at the format, they looks like malformed Lat Long degrees. The decimal place is in the wrong place, if I convert the first one to
51.360770N ,0.355890E
and assume they are standard WGS84 lat longs and put that into nearby.org.uk then it gives me OSGB grid ref of TQ 6411865045[\b] or putting it into streetmap.co.uk you get an easting,northing of 564117,165045.

If these are right, then you just need to jig the formatting & I assume ESRI will handle WGS84 lat longs without any major problems.

hth

Ben


----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

We could be confused in exactly the same way, but confusion might be like Nulls, and not comparable.