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 <[EMAIL PROTECTED]> 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
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
