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

[Dylan Oliver]

Hi,

I've made some good headway on a project to import TIGER and census data.
Given any address/coordinated, I want to be able to query which block that
point is in, and also extract the number of houses in that block from the
census data. Matching up the tiger and census blocks is no trick; it's done
on module (eg tgr55111 to indicate county 111 (Sauk) of state 55 (WI)) and
block number. The problem is that multiple TIGER polygons may exist for a
single block, and worse that the only difference in these (as they appear in
the polygons table) is their geometry. Which polygon is the one which
describes the border of the block, and not, say, a lake inside it?

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