Opened 12 years ago

Closed 12 years ago

#1494 closed enhancement (fixed)

Ability to load census tract/block data when loading tiger_geocoder with shapefiles

Reported by: kiwi Owned by: robe
Priority: medium Milestone: PostGIS 2.0.0
Component: tiger geocoder Version: master
Keywords: Cc:


Would be pretty nice to have instructions/mechanisms for loading the block data and then using it with a geomout. Thanks!

Change History (3)

comment:1 by robe, 12 years ago

Status: newassigned
Version: 1.5.Xtrunk

comment:2 by robe, 12 years ago

Have logic to load blockgroups (bg), census tracts (tract) and tabulation blocks (tabblock) at r9168.

I tested the differential state load on windows, but haven't retested the full load.

Can you give it a try. After you run the upgrade script, you just need to do something like

SELECT loader_generate_census(ARRAY['TX'], 'sh');

To load for just the census data for Texas.

As far as functions to use it, haven't thought what things would be most useful to output given a geometry.

Would the full geoids be too much. Since I deal with just state data, I usually use the tractce and blkgrpce (from block groups).

I'm thinking of renaming those fields to just tract, blkgrp but I should probably leave well enough alone.

comment:3 by robe, 12 years ago

Resolution: fixed
Status: assignedclosed

I'm going to consider this done at r9191, r9190.

I changed the name of the function to:

SELECT loader_generate_census_script(ARRAY['TX'], 'sh');

details of new census tract loader and get_tract functions in docs

You should get these new features by just running the script.

Note: See TracTickets for help on using tickets.