Find Jobs
Hire Freelancers

Convert mgrs coordinates to decimal degree latitude longitude - repost

$30-250 USD

In Progress
Posted over 11 years ago

$30-250 USD

Paid on delivery
I need a formula I could plug into a sql server table column that will take an mgrs value in that column an populate two other columns with the converted latitude and longitud values. One column for latitude and another for longitude in decimal degrees. I would like the same idea for excel columns as well for a spreadsheet. It is not just one mgrs value conversion at a time but multiple rows of mgrs values.
Project ID: 4116005

About the project

4 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
I will create two t-sql functions that can be used on MS-SQL server to perform the calculations. One function will return the latitude and the other function will return the longitude, given a MGRS string. These will be usable as part of a trigger to populate the columns on update or insert or as part of a general update statement, for both of which I will provide usage examples. My knowledge of MGRS is limited, so I can only promise the t-sql functions, however if I find myself completing those functions faster than anticipated, I will make an effort at the excel formula(s). As discussed in pm, I cannot promise that the functions will perform well as the conversion is somewhat complicated. The conversion will be restricted to Grid Zones 41S, 42S, 41R, and 42R, and the functions will be delivered by the 10th of February. I look forward to working with you!
$200 USD in 30 days
5.0 (6 reviews)
3.9
3.9
4 freelancers are bidding on average $105 USD for this job
User Avatar
It looks like you need some Excel formulaes and a SQL query. I can do this quickly and easily. Please check PM for references.
$80 USD in 1 day
5.0 (24 reviews)
5.2
5.2
User Avatar
Dear Sir, This involves stored procedure and function. Oracle Database Expert here and it will be a smooth job for me. Looking forward to work in this nice project. Quality and Cheap is what I offer to my clients.
$100 USD in 2 days
5.0 (10 reviews)
3.7
3.7
User Avatar
Hi, I am expert with SQL Server & Excel. Please refer PM for more details. Regards, Brindabanb
$40 USD in 1 day
5.0 (1 review)
1.7
1.7

About the client

Flag of UNITED STATES
Land o lakes, United States
5.0
1
Payment method verified
Member since Dec 13, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.