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

phat-ass at thinkheavyindustries.com phat-ass at thinkheavyindustries.com
Wed Mar 22 19:17:38 PST 2006

This is my first post here. 
        Oddly enough I'm working on the same type of project.
        I've got some questions. You might be able to help me. I might
        be able
        to help you, too.
        There should be only one polygon for any block itself. What
        query are
        you using to get this polygon?
        What geocoder are you using and how did you get it installed?
        Eric Aspengren

On Wed, 2006-03-22 at 06:59 -0600, Dylan Oliver wrote:
> 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 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

More information about the postgis-users mailing list