Find Jobs
Hire Freelancers

sql to calculate distance in miles between latitude and longitude

$10-30 USD

Færdiggjort
Slået op over 6 år siden

$10-30 USD

Betales ved levering
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
Projekt-ID: 15203008

Om projektet

19 forslag
Projekt på afstand
Aktiv 6 år siden

Leder du efter muligheder for at tjene penge?

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme
Bliv betalt for dit arbejde
Oprids dit forslag
Det er gratis at skrive sig op og byde på jobs
Tildel til:
Brug Avatar.
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 på 1 dag
5,0 (46 anmeldelser)
5,7
5,7
19 freelancers are bidding on average $28 USD for this job
Brug Avatar.
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 på 1 dag
4,9 (745 anmeldelser)
9,3
9,3
Brug Avatar.
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 på 1 dag
4,9 (21 anmeldelser)
5,5
5,5
Brug Avatar.
A proposal has not yet been provided
$30 USD på 1 dag
4,9 (48 anmeldelser)
5,2
5,2
Brug Avatar.
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 på 1 dag
5,0 (36 anmeldelser)
5,1
5,1
Brug Avatar.
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 på 1 dag
5,0 (30 anmeldelser)
5,0
5,0
Brug Avatar.
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 på 1 dag
4,9 (24 anmeldelser)
4,7
4,7
Brug Avatar.
Hello sir, i would like to make this query. Thanks
$30 USD på 1 dag
4,9 (15 anmeldelser)
4,1
4,1
Brug Avatar.
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 på 1 dag
5,0 (6 anmeldelser)
2,6
2,6
Brug Avatar.
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 på 1 dag
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
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 på 1 dag
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
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 på 1 dag
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
I can complete this in less than one day waiting for your data inputs.
$25 USD på 1 dag
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
I am good in writing SQL server querying, performance tuning etc. please allow me to work on your project
$30 USD på 2 dage
0,0 (0 anmeldelser)
0,0
0,0

Om klienten

Flag for UNITED STATES
Pasadena, United States
5,0
4
Betalingsmetode verificeret
Medlem siden mar. 12, 2017

Klientverificering

Tak! Vi har sendt dig en e-mail med et link, så du kan modtage din kredit.
Noget gik galt, da vi forsøgte at sende din mail. Prøv venligst igen.
Registrerede brugere Oprettede jobs i alt
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Indlæser forhåndsvisning
Geolokalisering er tilladt.
Din session er udløbet, og du er blevet logget ud. Log venligst ind igen.