need postgresql geolocation queries

$30-250 USD

Κλειστή

Αναρτήθηκε

πάνω από 5 χρόνια πριν

$30-250 USD

Πληρωμή κατά την παράδοση

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

MySQL

PostgreSQL

Ταυτότητα εργασίας: 18628036

Σχετικά με την εργασία

7 προτάσεις

Απομακρυσμένη Εργασία

Ενεργός/ή 5 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Διεύθυνση Email

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα

Πληρώσου για τη δουλειά σου

Περίγραψε την πρόταση σου

Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν

7 freelancers δίνουν μια μέση προσφορά $150 USD για αυτή τη δουλειά

@schoudhary1553

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

$250 USD σε 4 ημέρες

4,5

(17 αξιολογήσεις)

5,2

@sergioeliot3

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

$160 USD σε 3 ημέρες

5,0

(14 αξιολογήσεις)

4,3

@toshazed

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.

$50 USD σε 1 ημέρα

5,0

(3 αξιολογήσεις)

3,0

@BeepConsulting

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.

$166 USD σε 3 ημέρες

0,0

(0 αξιολογήσεις)

0,0

@manojmo

hi, The queries are ready in mysql. i have 20+ years experience overall, and good expertise in sql. regards, manoj

$111 USD σε 1 ημέρα

0,0

(0 αξιολογήσεις)

0,0

@AbdullahSti

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

$155 USD σε 3 ημέρες