[postgis-users] TIGER/Line Shapefiles released

[Stephen Frost]

* Dan Putler (dan.putler at sauder.ubc.ca) wrote:
> True to an extent. However, I've pulled up fe_2007_06085_addr.dbf (Santa
> Clara County, California), and have discovered that one TLID 123180546
> has 1246 different right side address records, while TLID 122928561 has
> 88 right side address records. Cleaning things up so that you could use
> a standard address geocoder (which would need the *most-inclusive*
> address range) would be an interesting challenge.

The main thing is that the address ranges *are* there, and you can
derive the most-inclusive address range from them, but what Census
recommends is that you just scan through all of them.  That's really not
that hard to do.  It's certainly what I'm planning to do with the tiger
geocoder that I maintain as part of the PostGIS extras..

	Thanks,

		Stephen

> On Mon, 2008-03-31 at 22:18 -0400, Stephen Frost wrote:
> > 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
> > _______________________________________________
> > 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/b1d10a9b/attachment.pgp>