[postgis-tickets] [PostGIS] #2915: 2014 TIGER TABBLOCK and FACES Schema Changed

[PostGIS]

#2915: 2014 TIGER TABBLOCK and FACES Schema Changed
----------------------------+-----------------------------------------------
 Reporter:  alferz          |       Owner:  robe 
     Type:  defect          |      Status:  new  
 Priority:  medium          |   Milestone:       
Component:  tiger geocoder  |     Version:  2.1.x
 Keywords:                  |  
----------------------------+-----------------------------------------------
 It looks like the US Census has changed the 2014 TIGER TABBLOCK and FACES
 shapefiles data schema. Some fields are missing from the 2013 version, and
 some have been modified with a "10" suffix. Unfortunately this breaks the
 loader scripts for 2014 state data in PostGIS. I am about 2 days into
 PostGIS so this is the extent of the details I can provide, but until this
 bug is resolved it appears the 2014 census data will be unusable. I would
 note that all other tables appeared to have loaded successfully, but these
 two ended up empty due to the errors in the loader script/

 Running shp2pgsql on both data sets reveals the column names have changed:

 '''TABBLOCK'''

 2013:
 INSERT INTO "tiger_staging"."ca_tabblock"
 ("statefp","countyfp","statefp10","countyfp10","tractce10","blockce10","suffix1ce","geoid","name","mtfcc","ur10","uace10","funcstat","aland","awater","intptlat","intptlon",the_geom)

 2014:
 INSERT INTO tiger_staging"."ca_tabblock"
 ("statefp10","countyfp10","tractce10","blockce10","geoid10","name10","mtfcc10","ur10","uace10","uatyp10","funcstat10","aland10","awater10","intptlat10","intptlon10",the_geom)

 '''FACES'''

 2013:
 INSERT INTO "tiger_staging"."ca_faces"
 ("tfid","statefp10","countyfp10","tractce10","blkgrpce10","blockce10","zcta5ce10","uace10","pumace10","statefp","countyfp","tractce","blkgrpce","blockce","suffix1ce","cousubfp","submcdfp","estatefp","conctyfp","placefp","aiannhfp","aiannhce","comptyp","trsubfp","trsubce","anrcfp","ttractce","tblkgpce","elsdlea","scsdlea","unsdlea","cd113fp","sldust","sldlst","csafp","cbsafp","metdivfp","cnectafp","nectafp","nctadvfp","lwflag","offset","atotal","intptlat","intptlon",the_geom)

 2014:
 INSERT INTO "tiger_staging"."ca_faces"
 ("tfid","statefp10","countyfp10","tractce10","blkgrpce10","blockce10","suffix1ce","zcta5ce10","uace10","pumace10","statefp","countyfp","tractce","blkgrpce","cousubfp","submcdfp","estatefp","conctyfp","placefp","aiannhfp","aiannhce","comptyp","trsubfp","trsubce","anrcfp","ttractce","tblkgpce","elsdlea","scsdlea","unsdlea","cd114fp","sldust","sldlst","csafp","cbsafp","metdivfp","cnectafp","nectafp","nctadvfp","lwflag","offset","atotal","intptlat","intptlon",the_geom)

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2915>
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.