[postgis-users] TIGER geocoder question

2007-06-28 Thread Shuo Liu
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

Re: [postgis-users] TIGER geocoder question

2007-06-28 Thread Stephen Frost
* Shuo Liu ([EMAIL PROTECTED]) wrote: > 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",

Re: [postgis-users] TIGER geocoder question

2007-06-28 Thread Marvin
Thanks, Stephen. Your explanation helps me a lot. So you think that it is possible just to change "roads_local" in the script to "completechain"? One more question, there is another table missing ("tiger_geocode_join"). One message says that "tiger_geocode_join" links "roads_local" and "tiger_geo

Re: [postgis-users] TIGER geocoder question

2007-06-28 Thread Stephen Frost
* Marvin ([EMAIL PROTECTED]) wrote: > Thanks, Stephen. Your explanation helps me a lot. So you think that it is > possible just to change "roads_local" in the script to "completechain"? Well, looking back I actually recreate road_local from completechain by doing some simple type conversions and w

Re: [postgis-users] TIGER geocoder question

2007-06-28 Thread Marvin
Thank you so much, Stephen.. I'll check it out. On 6/28/07, Stephen Frost <[EMAIL PROTECTED]> wrote: * Marvin ([EMAIL PROTECTED]) wrote: > Thanks, Stephen. Your explanation helps me a lot. So you think that it is > possible just to change "roads_local" in the script to "completechain"? Well, l

Re: [postgis-users] TIGER geocoder question

2007-06-28 Thread Stephen Frost
* Marvin ([EMAIL PROTECTED]) wrote: > Thank you so much, Stephen.. I'll check it out. Sure. I'd really like to see some of this stuff end up back in the tiger geocoder on the website... I don't think anyone is actively maintaining it, which, in my view, is a real shame. :( Does anyone know of a