[postgis-users] Re: TIGER geocoder question

[Marvin]

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 <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/20070629/c428b86e/attachment.html>