Hello..I have a big collection of latitude/longitude data belonging to different devices, looks like this:
deviceid,lat/lon,timestamp
I need someone professional in postgresql and/or mysql to write queries that do the following:
- for each device, find the most frequent location between 2 time ranges over a period of x months
- find the intersection frequency between a device and a certain polygon or circle
Hello,
I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile.
Please visit : https://www.freelancer.com/u/schoudhary1553
I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you.
Kinds Regards,
Sandeep
Hi there,
Thanks for using our website freelancer com.
My name is Sergio and I am a software developer dedicated 100% here on the marketplace.
I am confident in that I will be able to prepare a PostGRes solution for the information you want to query.
Can you ping me to get started?
Kind regards,
Sergio
I am Ring. I am about 18+ years experienced in GNU/Linux based system, server installation and customization, develop, deploy, security and support. I may help you in this regard.
I can create two optimized views that will do the work for you.
Please, provide me a dump of your database ( table structure SQL and your data as SQL), I will come back to you with the answer.
Hey,
I am expert in postgress and mysql and I can work on your project.
i have worked with devices,lat/long and timestamping
I can write queries
- for each device, find the most frequent location between 2 time ranges over a period of x months
- find the intersection frequency between a device and a certain polygon or circle
Thanks,
Kamran
Relevant Skills and Experience
I've excellent expertise in big data, mysql and postgresql