Stephen, * Stephen Woodbridge (wood...@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
signature.asc
Description: Digital signature
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users