Extract data from csv and export to json
$10-30 USD
Kiszállításkor fizetve
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 = [login to view URL]();
var φ2 = [login to view URL]();
var Δφ = (lat2-lat1).toRadians();
var Δλ = (lon2-lon1).toRadians();
var a = [login to view URL](Δφ/2) * [login to view URL](Δφ/2) +
[login to view URL](φ1) * [login to view URL](φ2) *
[login to view URL](Δλ/2) * [login to view URL](Δλ/2);
var c = 2 * [login to view URL]([login to view URL](a), [login to view URL](1-a));
var d = R * c;
Projektazonosító: #11566204
A projektről
13 szabadúszó tett átlagosan 22$ összegű árajánlatot erre a munkára
Hello sir , Waiting for your positive response , so we can start the work soon. Thank you.
Hi, I can help you to extract data from csv and export to json. I can easily make it. Contact me for quality work and quick services. Thanks!
I can develop php script that you need. I will need an hour or so to make it. The script will display just JSON so you can use it on your project.
Hi, We can create script to extract the data from csv and convert into json format in one day. -Thanks
Hello. I'll do this simple task in several hours. Are there any additional comments? When I can start? Best Regards, Nikolay Maksimov