[postgis-users] TIGER/Line Shapefiles released

Stephen Frost sfrost at snowman.net
Mon Mar 31 19:18:55 PDT 2008


Dan,

* Dan Putler (dan.putler at sauder.ubc.ca) wrote:
> Unfortunately, the data isn't what one would hope for. It appears that
> the 2007 release will not include address range or zip code information,
> but later releases (2008?) will. Here is the link to the right point in
> the FAQ: http://www.census.gov/geo/www/tiger/faq.html#18

Please don't take offense, but I think you're smoking something pretty
good..  That FAQ is about the *most-inclusive* address range
information.  The address ranges are there (I'm looking at them right
now...), they've just been normalized out of the actual shape files and
are only in .dbf files (eg: fe_2007_01133_addr.dbf).  There can now also
be more than one address range for a given edge, which is what they're
talking about in the second paragraph of that FAQ.  Actually, that was
true in the old TIGER/Line data, but it was in RT-6.

I'd encourge you to read the TIGER/Shapefiles relationship documentation
found here:
http://www.census.gov/geo/www/tiger/rel_file_desc.pdf
and here:
http://www.census.gov/geo/www/tiger/rel_file_desc.txt

I'm still working on importing the data, so perhaps I've missed
something, but I don't think so..

	Thanks,

		Stephen

> On Mon, 2008-03-31 at 20:57 -0400, Stephen Frost wrote:
> > * Peter Foley (pwfoley at gmail.com) wrote:
> > > For those of you who have been waiting, the Census bureau finally released
> > > the new TIGER/Line shapefiles.
> > > The information page and download links are here:
> > > http://www.census.gov/geo/www/tiger/tgrshp2007/tgrshp2007.html
> > 
> > Yup, *finally*.
> > 
> > > This download page is more wget-friendly:
> > > http://www2.census.gov/geo/tiger/TIGER2007FE/
> > 
> > I think they may have also upgraded their pipe..  I got about 1.41MB/s
> > (11 Mb/s) for the whole transfer.  It's about 22G all told.  I'll
> > probably be trying to load it up into PG on one of our servers tomorrow.
> > It was a bit over 4 hours for me to pull down off of their
> > ftp2.census.gov ftp site.
> > 
> > lftp ftp2.census.gov:/geo/tiger/TIGER2007FE> mirror .
> > Total: 3313 directories, 56534 files, 0 symlinks
> > New: 56520 files, 0 symlinks
> > 22363894773 bytes transferred in 15137 seconds (1.41M/s)
> > 
> > 	Enjoy,
> > 
> > 		Stephen
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> -- 
> Dan Putler
> Sauder School of Business
> University of British Columbia
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080331/8343beb9/attachment.pgp>


More information about the postgis-users mailing list