[postgis-users] Re: TIGER geocoder question

[Marvin]

Stephen,

I think it would be great if you can post a complete set of scripts/files
that you used to create TIGER Geocoder. It is a very handy tool but lacks
some maintenance, IMHO.

BTW, it seems that there are some inconsistency in your script to create
"tiger_geocode_roads". Tables "state_lookup", "countysub_lookup", and
"place_lookup" were used in the script with some fields that didn't exist
when those tables were created (such as "st_code", "co_code", and
"cs_code"). I guess those fields refer to corresponding FIPS codes, am I
right? Also, table "county_lookup" was not created in the script that came
with the geocoder. I assume that it includes FIPS codes for states and
counties. Please let me know if I'm on the right track.

Thanks.

On 6/28/07, Shuo Liu <delphet at gmail.com> wrote:
>
> Hi, All,
>
> I'm working on a GIS project and trying to use TIGER Geocoder from the
> refractions website on TIGER data. The two sql files in the Geocoder
> generated some errors when being loaded, complaining that some tables
> ("gazetteer_places", "tiger_geocode_roads", "place_lookup", "roads_local",
> and "countysub_lookup") are missing. Some messages from the mailing list say
> that gazetteer tables should be loaded from the Census Bureau gazetteer
> files. But that doesn't help find "tiger_geocode_roads" and "roads_local"
> which don't exist in the loaded TIGER database. I used ogr2ogr to load the
> TIGER data (
> http://docs.codehaus.org/display/GEOSDOC/Loading+TIGER+basedata) and it
> seems that some fields required by the Geocoder are in "completechain" but
> not all. Can anybody who have experience share some hint on this problem?
> Thank you very much.
>
> Marvin
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070628/ea75b973/attachment.html>