[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    RE: [postgis-users] geo-coding question
From:       Lee Keel <lee.keel () uai ! com>
Date:       2007-06-27 18:30:58
Message-ID: 76758090F8686C47A44B6FF52514A1D308C9C16C () hermes ! uai ! int
[Download RAW message or body]

> -----Original Message-----
> From: postgis-users-bounces@postgis.refractions.net [mailto:postgis-users-
> bounces@postgis.refractions.net] On Behalf Of Stephen Woodbridge
> Sent: Wednesday, June 27, 2007 1:04 PM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] geo-coding question
> 
> Lee,
> 
> Another question, can you talk about how you are doing your livesearch?
> Is this doing a fulltext search, are you parsing the incoming address
> string and generating dynamic queries?
> 
> For example: "543 Hough St, Illinois" does not filter non Illinois
> addresses. Are you only searching for the street name? What happens when
> you search for something common like "101 main st" It seems you only
> return 12 results, What if you put them in a grid as permalinks, and
> then you could page through the results like 12 at a time to see more.
> 
> Anyway, just some ideas. I like it.
> 
> -Steve
> 

We are using a customized version of the Ajax AutoComplete control that I
created that calls a webservice to do a query each time you pause for 3/4 of
a second.  This length is a parameter on the control.  It passes the entire
text and a requested limit to the database where we are doing address
parsing and gecoding the results.  Currently the functionality expects to
have city if you enter a state.  Like I said before, we have a little more
work to do.  I also want to be able to enter the address with a zipcode, but
I have got to leave them wanting something. :)  Some of the addresses you
see in the results don't have a city because they didn't have the city for
that road in the Tiger data.

We started at 12 as a round number for displaying and not killing the server
but will probably bump that number up once we get on better servers.  I am
currently working on some javascript code that will be aware of a combobox
to allow the ability to pass in the layer that you want to geocode against
(for example we have a client that wants to geocode to their own parcel and
centerline data before using Tiger).  This code will list the address as
links in a grid and allow the user to pick them as they want.  This listbox
was just the simplest approach since most of the functionality was written
already by Ajax.

I am glad you like it.  I am a big fan of postgres.  Especially since I have
been trying to rewrite this same geocoding functionality in Sql Server 2005.

Thanks,
Lee Keel
This email and any files transmitted with it are confidential and intended solely for \
the use of the individual or entity to whom they are addressed. If you have received \
this email in error please notify the sender. This message contains confidential \
information and is intended only for the individual named. If you are not the named \
addressee you should not disseminate, distribute or copy this e-mail. \
_______________________________________________ postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


[prev in list] [next in list] [prev in thread] [next in thread]