Develop street address autocomplete query with Postgresql PotGIS data

$12-25 AUD / hour

Κλειστή

Αναρτήθηκε

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

$12-25 AUD / hour

Hello, I have a PostgreSQL table of 14 million addresses. The table has the following fields - ID, House Number, Street Name, Street Type, Locality, State, Postcode, Geom. I need a DB expert to develop a query that will return results to enable me to build the autocomplete form shown on this page - [login to view URL] Therefore I need a fast query that returns approximately 30 addresses based on partial input. We can discuss further on private chat.

Database Administration

Database Programming

PostgreSQL

SQL

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

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

11 προτάσεις

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

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

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

Διεύθυνση Email

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

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

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

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

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

11 freelancers δίνουν μια μέση προσφορά $18 AUD/ώρα για αυτή τη δουλειά

@iticus

Hello, I have experience with PostgreSQL, PostGIS, Python and geocoding data. Is your data based on GNAF? I have developed an API based on that data some time ago. If your autocomplete form can be designed in a "top-down" fashion (select state, then locality, then street and ultimately number) I think we can get quite fast results (a few milliseconds). If you need a single input for the whole address then it gets quite complicated due to the large number of records which can prove difficult even if using indexes like pg_trgm. Best wishes, iticus

$25 AUD σε 20 ημέρες

5,0

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

5,3

@mrkrunaldoshi

I understand we need to write a query which could return 30 addresses based on input from PostgreSQL table containing 14 million records similar to Google Maps example. I'll be honest and transparent to you, we are new to PostgreSQL however we have huge experience with Microsoft SQL hence I am confident of doing it. I have 12+ year of experience in IT field, most of my work is done in MS Technologies. Awaiting an opportunity from you.

$15 AUD σε 40 ημέρες

5,0

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

3,7

@Darwin21015

HELLO AS YOU ARE WAITING YOU ARE GOOD, CONTRACT ME I HAVE GOOD EXPERIENCE IN POSTGRES AND I THINK I CAN HELP YOU I WILL NOT COLLECT YOU FOR HOUR I WILL COLLECT YOU FOR THE WORK YOU WILL GO OUT MORE CHEAP WE ALL WILL GO WINNING, I HAVE DEVELOPED COMPLEX QUERYS AND SIMPLE QUERYS, VIEWS, PROCEDURES STORED IN THE DATABASE. ETC SEND THE TABLE WITH THE RECORDS AND I WILL WORK ABOUT IT

$20 AUD σε 40 ημέρες

4,6

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

3,2

@grtdeveloper

Rich experience in writing PostgreSQL queries. can donit in a day.

$22 AUD σε 2 ημέρες

5,0

(1 αξιολόγηση)

2,0

@PratikB012

Hi, I am a person from Geo-Informatics background and we always use to play with that 'the_geom' thing. It is nice to work with GIS( Geographical Information System) things with web.

$21 AUD σε 40 ημέρες