Completed

Extract data from csv and export to json

This project was successfully completed by ramoncho for $20 USD in a day.

Get free quotes for a project like this
Employer working
Completed by:
Skills Required
Project Budget
$10 - $30 USD
Completed In
1 day
Total Bids
14
Project Description

Need small code in php to extract follow from the file attached

name|state|from_dt|to_dt|Points|from_point|to_point|total_time|total_distance|Avg_speed|maximum_speed

here name = vehicle name

state= move/stop

from_dt= start datetime of state

to_dt = end datetime of state

points=inbetween points, separated by ;

from_point=lat,lon of start point

to_point=lat,lon of end point

total_time=to_dt-from_dt

total_distance=inbetween points distance calculated by formula provided below

Avg_speed=sum all speed values and divide by number

maximum_speed= highest speed

Distance formula

JavaScript:

var R = 6371e3; // metres

var φ1 = [url removed, login to view]();

var φ2 = [url removed, login to view]();

var Δφ = (lat2-lat1).toRadians();

var Δλ = (lon2-lon1).toRadians();

var a = [url removed, login to view](Δφ/2) * [url removed, login to view](Δφ/2) +

[url removed, login to view](φ1) * [url removed, login to view](φ2) *

[url removed, login to view](Δλ/2) * [url removed, login to view](Δλ/2);

var c = 2 * [url removed, login to view]([url removed, login to view](a), [url removed, login to view](1-a));

var d = R * c;

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online