[postgis-users] Re: Tiger geocoder

[Randy George]

Hi,

 

            Sorry if this a double post but the earlier email from this
morning didn't seem to go through.

 

I'd like to experiment with the geocoder, but need to know some information
about the required table formats.

 

If I use ogr2ogr from FWTools 1.0.0a6 like this:

ogr2ogr -f PostgreSQL PG:"user=postgres dbname=TIGER host=localhost
password=pass port=5432" H:\downloads\tiger\CO\tgr08001

 

I get the ogr set of tables,but the geocoder Lookup_T.SQL seems to need a
couple of gazetteer files:

 

-- Create place and countysub lookup tables

SELECT name, state INTO TABLE place_lookup FROM gazetteer_places group by
name, state;

SELECT name, state INTO TABLE countysub_lookup FROM
gazetteer_county_subdivisions group by name, state;

 

And the geocoder TIGER_GE.SQL needs:

roads_local, tiger_geocode_roads and tiger_geocode_join

 

So it looks like several tables need to be available from the TIGER (perhaps
others)

gazetteer_places

gazetteer_county_subdivisions

roads_local

tiger_geocode_roads

tiger_geocode_join

 

Are these table schemas available somewhere? I can populate the tables from
the TIGER if I know what these tables should be for use with geocoder. This
might be better than using ogr2ogr since a number of the ogr2ogr generated
tables don't appear to be necessary for the geocoder.

 

Thanks

Randy

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20051118/bf25607a/attachment.html>