[postgis-users] Query to format TIGER data

[Lee Keel]

To be more specific...

 

1) I need to know what the structure and data that is expected to be in the
tiger_geocode_join and roads_local tables?

2) Am I suppose to combine the following columns from the tiger data into a
single column for the tiger_geocode_roads table?

            ** cousubl and cousubr into cousub

            ** placel and placer into place

            ** zipl and zipr into zip

            ** statel and stater into state

 

I am kind of under a time constraint to prove this will work, so I would
appreciate any help that I can get on this.

 

Thanks,
Lee

 

  _____  

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Lee Keel
Sent: Wednesday, April 18, 2007 12:12 PM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Query to format TIGER data

 

Has anyone got the query that will dump the TIGER data into the format that
is being used by the TIGER Geocoder?

This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the sender. This
message contains confidential information and is intended only for the
individual named. If you are not the named addressee you should not
disseminate, distribute or copy this e-mail.

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