[postgis-users] Tiger Files on Windows PostGIS

[Obe, Regina]

Tom,
 
It is my understanding that the 2007 and up Tiger files are going to be
in ESRI shape.  I haven't verified that though.  If in ESRI shp format
you can use the shp2pgsql packaged with PostGIS or Ogr2OGr.
 
Anyrate as Marty mentioned - you can import tiger format with Ogr2OGR or
other Gdal tools.  I documented general use of Ogr2OGr here since it
seems to be a commonly asked question and have a section on importing
Tiger files.  I tried to make it as untechy as possible so its easy to
follow.
 
http://www.bostongis.com/PrinterFriendly.aspx?content_name=ogr_cheatshee
t
 
Depending on how many you are importing, you may have to write a dos
script to loop thru the specific files you want.  Thats what I have done
in the past for say importing all of Massachusetts or US.
 
Hope that helps,
Regina
 
 
 
 

________________________________

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Tom
McAndless
Sent: Thursday, September 27, 2007 11:01 PM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Tiger Files on Windows PostGIS



I work in a Windows environment and want to do GeoCoding and Web Mapping
in a .NET environment   I have recently downloaded all the tiger files
for the US but really can not make out how I am to get them into the
database.

Part of the problem is that I have worked with Windows based GIS
packages in the past so the instructions about Pearl scripts and such
are foreign to me.  The only piece of information I found was a county
by county script which would obviously take an enormous amount of time.
I also noticed that of the scripts were for the 2005 tiger files and
wondered if there are some changes that needed to be accounted for in
the new ones.

If someone has experience and information about working in Windows and
especially getting the Tiger data into the database I would be glad to
set up a forum on the net to help pass along the information.

Thanks for any information you might have   

Tom McAndless




-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070928/d6b6faad/attachment.html>