Find Jobs
Hire Freelancers

Develop street address autocomplete query with Postgresql PotGIS data

$12-25 AUD / hour

Zaprt
Objavljeno pred več kot 6 leti

$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.
ID projekta: 15957434

Več o projektu

11 ponudb
Projekt na daljavo
Aktivno pred 6 leti

Želite zaslužiti?

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir
Prejmite plačilo za svoje delo
Povzetek predloga
Registracija in oddajanje ponudb sta brezplačna
11 freelancerjev je oddalo ponudbo s povprečno vrednostjo $18 AUD/uro za to delo
Avatar uporabnika
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 v 20 dneh
5,0 (16 ocen)
5,3
5,3
Avatar uporabnika
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 v 40 dneh
5,0 (6 ocen)
3,7
3,7
Avatar uporabnika
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 v 40 dneh
4,6 (5 ocen)
3,2
3,2
Avatar uporabnika
Rich experience in writing PostgreSQL queries. can donit in a day.
$22 AUD v 2 dneh
5,0 (1 ocena)
2,0
2,0
Avatar uporabnika
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 v 40 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
A proposal has not yet been provided
$13 AUD v 40 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
A proposal has not yet been provided
$22 AUD v 2 dneh
0,0 (0 ocen)
0,0
0,0

O stranki

Zastava AUSTRALIA
private, Australia
5,0
46
Plačilna metoda je verificirana
Član(ica) od jan. 10, 2011

Verifikacija stranke

Hvala! Po e-pošti smo vam poslali povezavo za prevzem brezplačnega dobropisa.
Pri pošiljanju vašega e-sporočila je šlo nekaj narobe. Poskusite znova.
Registrirani uporabniki Skupaj objavljenih del
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Nalaganje predogleda
Geolociranje je bilo dovoljeno.
Vaša prijavna seja je potekla, zato ste bili odjavljeni. Prosimo, da se znova prijavite.