topic converting latitude and longitude from meter to decimal format in Data Management Questions

converting latitude and longitude from meter to decimal format

johnfred — Sun, 24 Feb 2013 16:43:40 GMT

HI,
I have a large no of data i.e. latitude and longitude in meters format,(995866.8412), i want to convert them into decimal format(25.55941), is there any method which can do this conversion in bulk.

Re: converting latitude and longitude from meter to decimal format

VinceAngelo — Sun, 24 Feb 2013 17:18:29 GMT

Unfortunately, this isn't really a trivial thing. Data in meters must be in a projection. You need
to know what the projection is, so you can de-project it into decimal degrees. The conversion
itself is simple, but without knowing the source projection (and the target datum for the degrees,
if it's different from the datum used in the projection), there's literally no way to get there.

When you have the projection, you'll also need to tell us what GIS software you have available to
do the conversion.

- V

Re: converting latitude and longitude from meter to decimal format

johnfred — Mon, 25 Feb 2013 04:37:56 GMT

Projection name is Ain el Abd / UTM zone 38N, and currently we are not using any GIS software , we are receiving it the data in an excel sheet and then upload that excel sheet into a DB table , so while inserting in in the DB table we want to convert that data to decimal format.

Re: converting latitude and longitude from meter to decimal format

johnfred — Mon, 25 Feb 2013 04:45:58 GMT

correction to my last post:

Base Geographic CRS: Ain el Abd

Projection: UTM zone 38N

Code: 16038

Re: converting latitude and longitude from meter to decimal format

VinceAngelo — Mon, 25 Feb 2013 11:05:25 GMT

I'm not aware of any way to execute deprojection without GIS software.

- V