[postgis-users] TIGER polygons, census SF1 blocks, and boundaries

Dylan Oliver dylan.oliver at gmail.com
Wed Mar 22 20:53:32 PST 2006

what up phat,

I'd be happy to help you however I can with this TIGER/census/postgis thing.
It's not the polished process that it should be!

I'm using plain ogr2ogr to import the TIGER data. I've been using
tigerpolytransformation by David Blasby as described in the GeoServer docs
(though I'm not using GeoServer). Of course, this program only works on the
polygons which have already been imported through ogr2ogr.

Every time I end up with several records containing the same module, tract,
and block but with different polyids and geometries. I assume that these are
bodies of water or parks or other features within the blocks, so it makes
sense that there should be multiple polygons per block. Only one should
represent the outline of the block, but I've found no fields to discern


select module, tract, block, polyid where module='tgr55111' and tract=43 and

module  tract  block  polyid
tgr55111  43  1034  53
tgr55111  43  1034  54
tgr55111  43  1034  55

So which one is the block border and not a lake or something? Note that I'm
not including the many other fields in the polygon table, as they are all
the same for these polygons sharing a block. They have different geometries,
and I've thought of selecting the one with the biggest area or the like. But
this seems really stupid, and there should just be a binary isblockborder or
something similarly obvious.

This is after I import the data with ogr2ogr, and before I do anything else!

I'm not actually using a geocoder at the moment. I'm importing a file of RF
coverage data which consists of coordinates and predicted signal levels.
This is all A-OK and interesting, but not really relevant to the border

Dylan Oliver
Primaverity, LLC
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060322/8d1f905c/attachment.html>

More information about the postgis-users mailing list