[postgis-devel] [PostGIS] #1494: Ability to load census tract/block data when loading tiger_geocoder with shapefiles

[PostGIS]

#1494: Ability to load census tract/block data when loading tiger_geocoder with
shapefiles
----------------------------+-----------------------------------------------
 Reporter:  kiwi            |       Owner:  robe         
     Type:  enhancement     |      Status:  assigned     
 Priority:  medium          |   Milestone:  PostGIS 2.0.0
Component:  tiger geocoder  |     Version:  trunk        
 Keywords:                  |  
----------------------------+-----------------------------------------------

Comment(by 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.

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/1494#comment:2>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.