MySQL Geospatial Query
$10-30 USD
Dibayar semasa penghantaran
I need help writing a Geospatial Query in MySQL.
I have a table with GPS coordinates generated from tracking devices. These are linked to trips by a vehicle ID and start and end date. I then have another table which includes routes as Linestring geometries.
I need a query which for a given datetime range, will give me the following:
All the trips that followed the routes in the routes table (or part of the route) and the time spent on each route (time is saved with coordinates).
A single trip will follow multiple routes.
A single trip might include the same route multiple times.
Multiple trips for different vehicles could follow the same route.
I would also like to know which portion/s of a trip are not on a route.
ID Projek: #36091854
Tentang projek
17 pekerja bebas membida secara purata $80 untuk pekerjaan ini
Hi there, I'm Shihan, an experienced PHP and MySQL developer with 7 years of work experience. I'm confident that I can help you write a Geospatial Query in MySQL that meets your needs. I understand that you need a que Lagi
MySQL Geospatial Query Hello George G., I would like to grab this opportunity and will be dedicated to your work till you get 100% satisfied with the tasks. I have 10+ years of experience on PHP, MySQL, Geospatial Lagi
Hi George, I'm pretty confident I can do this for you. I need more details on the structure of the tables and maybe example data, if you can provide.
Greetings! I can help you with your project at a high level! I have lots of experience in MySQL. My skills and experience is a great match for your needs. Looking forward to hearing from you. Best regards.
Hello, I'm Omema and I am a Solution Provider. I understand that you need help writing a Geospatial Query in MySQL. Specifically, you need help finding all the trips that followed each route in the routes table and the Lagi
Dear , I am thrilled to have come across your job posting and am excited to submit my proposal for your project. As a new freelance data scientist on freelancer.com, I am eager to showcase my skills and deliver qualit Lagi
Hello mate ! We went through your project description and it seems like our team is a great fit for this job. We are an expert team which have many years of experience on PHP, MySQL, Geospatial, Database Programming Lagi
Hola, estoy muy interesado en este proyecto. Soy un desarrollador y me gustaría trabajar para usted según sus requisitos. Skill: Html, Css, Sass, PHP, JavaScript, Sql, Git, Bootstrap, Cdnjs, Java Tools: Node JS, Visu Lagi
Available to start right now and deliver within a few hours. Let me know if you're interested. Have prior experience in such works. Contact me to talk more about the work.
Hi there, i can perform all types of SQL queries. Lets just talk about the requirements, schema design and possible solutions over the chat.