Find Jobs
Hire Freelancers

sql to calculate distance in miles between latitude and longitude

$10-30 USD

Opravljeno
Objavljeno pred več kot 6 leti

$10-30 USD

Plačilo ob dostavi
I have attached a file of insert statements that have 5000 rows. we need to calculate how many miles this truck went through each state ( in USA) it crossed. speed, date and time is given along with lat & long
ID projekta: 15203008

Več o projektu

19 ponudb
Projekt na daljavo
Aktivno pred 7 leti

Želite zaslužiti?

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir
Prejmite plačilo za svoje delo
Povzetek predloga
Registracija in oddajanje ponudb sta brezplačna
Dodeljeno:
Avatar uporabnika
I have done this before the SQL Server geography type is even available. If you are on 2008 or above, I can use sql::geography, or as an alternative we can use plain SQL queries and a formula. Relevant Skills and Experience MS SQL Server developer since v7.0. Google Maps API / geospatial developer since 2010. Proposed Milestones $30 USD - complete calculations & provide sql queries
$30 USD v 1 dnevu
5,0 (46 ocen)
5,7
5,7
19 freelancerjev je oddalo ponudbo s povprečno vrednostjo $28 USD za to delo
Avatar uporabnika
Hi there I don't see any attachments. But I know how to calculate the distance between 2 coordinates. Looking forward to working with you on this project. Thanks Rinsad
$34 USD v 1 dnevu
4,9 (745 ocen)
9,3
9,3
Avatar uporabnika
Extensive experience (more than 10 years) with SQL Server. MCSA SQL Server 2014 certified. I can have it done in less than 2 working hours. Relevant Skills and Experience SQL Server: Advanced English: Near-Native Proposed Milestones $28 USD - Job done
$28 USD v 1 dnevu
4,9 (21 ocen)
5,5
5,5
Avatar uporabnika
A proposal has not yet been provided
$30 USD v 1 dnevu
4,9 (48 ocen)
5,2
5,2
Avatar uporabnika
SQL expert with 15 years of experience in DBA, writing and tuning queries and procedures. Have worked as DB programmer for ERP systems. Relevant Skills and Experience SQL DBA, Database Programming, Query Optimization Proposed Milestones $30 USD - On completion There was no attachment in the project, can you please provide. Is this for MSSQL or MySQL?
$30 USD v 1 dnevu
5,0 (36 ocen)
5,1
5,1
Avatar uporabnika
Let me get it done for you. I can start now... Relevant Skills and Experience 9 years of experience in Databases like SQL Server, Oracle, Microsoft Access and MySQL, Programming languages like Android, PHP, Net technologies(Asp.Net, Vb.Net / C#, MVC ) Proposed Milestones $25 USD - D
$25 USD v 1 dnevu
5,0 (30 ocen)
5,0
5,0
Avatar uporabnika
Hello, I'm interested to work on this. Please message me. I hope I will do this. I didn't see any attachment. Thanks, Sheik
$25 USD v 1 dnevu
4,9 (24 ocen)
4,7
4,7
Avatar uporabnika
Hello sir, i would like to make this query. Thanks
$30 USD v 1 dnevu
4,9 (15 ocen)
4,1
4,1
Avatar uporabnika
Hi there i have read your project requirements and can complete your task by finding the distance in around 10-20 min Relevant Skills and Experience I am a regular expressions expert so can easily extract the desire data and calculate distance through it. Proposed Milestones $20 USD - Default
$20 USD v 1 dnevu
5,0 (6 ocen)
2,6
2,6
Avatar uporabnika
Hi there I have the code that you need (assuming this is MSSQL) - happy to let you have the code for free. Regards Peter Relevant Skills and Experience Project Manager with SQL skills and experience (not interested in the project but have the code for you). Proposed Milestones $25 USD - SQL code to send to you Hi I have the SQL code that you need
$25 USD v 1 dnevu
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
Hello i can calculate your truck distance across US states Relevant Skills and Experience skilled Proposed Milestones $30 USD - milestone contact me for more details
$30 USD v 1 dnevu
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
Should be no problem as we can order the listings by time and then compare the data google maps api data. Relevant Skills and Experience Recent graduate from Georgia State University Stay tuned, I'm still working on this proposal.
$20 USD v 1 dnevu
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
I can complete this in less than one day waiting for your data inputs.
$25 USD v 1 dnevu
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
I am good in writing SQL server querying, performance tuning etc. please allow me to work on your project
$30 USD v 2 dneh
0,0 (0 ocen)
0,0
0,0

O stranki

Zastava UNITED STATES
Pasadena, United States
5,0
4
Plačilna metoda je verificirana
Član(ica) od mar. 12, 2017

Verifikacija stranke

Hvala! Po e-pošti smo vam poslali povezavo za prevzem brezplačnega dobropisa.
Pri pošiljanju vašega e-sporočila je šlo nekaj narobe. Poskusite znova.
Registrirani uporabniki Skupaj objavljenih del
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Nalaganje predogleda
Geolociranje je bilo dovoljeno.
Vaša prijavna seja je potekla, zato ste bili odjavljeni. Prosimo, da se znova prijavite.