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

[kiwi]

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

[robe]

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.

[robe]

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

​http://www.postgis.org/documentation/manual-svn/Loader_Generate_Census_Script.html

​http://www.postgis.org/documentation/manual-svn/Get_Tract.html

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