Hi, Stephen,
I seem to be able to geocode an address after running your script. A new
question I have now is the schema of the result returned from "geocode". It
seems that a geocoded result may come from one of functions in your script (
e.g., "geocode_address_state" or "geocode_address_zip"). Do results obtained
from different functions share the same schema (columns)? The reason I'm
asking is that I want to set up a table to hold the results but don't know
where to look for the structure of the results.
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
