[postgis-users] Reg importing Tiger data into Postgres

[Randy George]

Hi,

 

            There are several ways to load TIGER. 

 

Ogr2ogr http://www.gdal.org/ogr/ogr_formats.html  has a TIGER to PostGIS
capability. Here is some info on using it:

http://www.bostongis.com/PrinterFriendly.aspx?content_name=ogr_cheatsheet

 

FME has a translator utility for sale. 

 

I have recently been experimenting with http://geotools.codehaus.org/ which
also has TIGERDataStore capability. This is an api so you would need to do
some Java programming to use it. I can't vouch for its accuracy or
completeness yet. 

 

I believe there are others on the list who have worked with TIGER and may in
fact have it already in a PostGIS format. I have done it for clients here
and there but only on a single state basis.

 

However, I think your easiest and cheapest (free) approach is Frank
Warmerdam's ogr2ogr utility unless you need to do something custom.

 

Thanks

randy

 

  _____  

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
mobiledreamers at gmail.com
Sent: Sunday, February 11, 2007 1:39 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Reg importing Tiger data into Postgres

 

Hello Guys

I m trying out PostGIS + Postgresql 8.2 inorder to geocode US Addresses to
Lat long points and vice-versa.
I got Postgis running as a postgresql extension and tried out the example in
the tutorial powerpoint and it worked without any problems. 
 I found that the next step is to import  Tiger/Line data. I googled couldnt
come up with a straightforward method. Please let me know if one of you has
a way of doing this.

Thanks for your anwers and reading

I really congragulate the effort of the group to keep Postgres the BEST DB
on the world


Thanks

Mark

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