[postgis-users] Geocoder (from extras)

[Stephen Frost]

Stephen,

* Stephen Woodbridge (woodbri at swoodbridge.com) wrote:
> In a geocoder I wrote in 2000, I mapped city, state and/or zipcode
> into a list of counties, then only searched those counties. This
> greatly reduced the 3300 counties in Tiger to a small handful that
> needed to be searched. The FIPS-4 document has a mapping of all
> place names to counties. Zipcodes are easier to handle because you
> can just index the records with zipcodes but if you wanted to widen
> the search, then map the zipcode to a place name and then to
> counties.

Yeah, the geocoder does something similar to this (as I recall, we
create a list of zip codes to scan through, since that's indexed and the
tables aren't stored per-county in my setup).

	Thanks,

		Stephen
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: Digital signature
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110508/b3ca5f09/attachment.pgp>