Opened 6 years ago

Last modified 4 years ago

#3247 new enhancement

Bring in additional faces columns

Reported by: mattybe Owned by: robe
Priority: medium Milestone: PostGIS Fund Me
Component: tiger geocoder Version: master
Keywords: Cc: mattybe

Description (last modified by robe)

As noted in #3227 by mattybe


Could the columns in tiger.faces be updated with this? I still see cd108fp, cd111fp, statefp00, etc. Some columns missing from current faces files are cd114fp, statefp10, blkgrpce10, etc. Details of the current columns are on page 3-66 here: ​http://www2.census.gov/geo/pdfs/maps-data/data/tiger/tgrshp2015/TGRSHP2015_TechDoc.pdf


Regina's note I'm hesitant to do this because it requires extra maintainance each year, and it's not used by the geocoder.

Attachments (1)

tiger2015.diff (75.5 KB) - added by mattybe 6 years ago.
patch

Download all attachments as: .zip

Change History (8)

comment:1 Changed 6 years ago by robe

Description: modified (diff)
Reporter: changed from robe to mattybe

comment:2 Changed 6 years ago by mattybe

I hope it will be maintained since the changes are well documented and there are many uses for having the census data loaded. But if the team's not committed to staying consistent with the TIGER data it would probably be best to just drop all the old columns, since now there are just a bunch of nonsense columns full of NULLs taking up space.

comment:3 Changed 6 years ago by mattybe

Cc: mattybe added

Changed 6 years ago by mattybe

Attachment: tiger2015.diff added

patch

comment:4 Changed 6 years ago by mattybe

possible patch attached

comment:5 Changed 6 years ago by robe

mattybe,

I see you caught some changes I missed on upgrade_geocode script.

Unfortunately, like I said this will need to wait. The problem with changing the lookup tables, is I don't currently upgrade them during extension upgrade, and since people data inherits these tables, any upgrade they do will destroy their existing data.

The only way I can think of to not make upgrade a nightmare would be to have existing obsolete table columns renamed (to their equivalent new) and add additional columns that are missing.

Anyway still too late for PostGIS 2.2 round.

Thanks, Regina

comment:6 Changed 6 years ago by 18595

Count me in as a +1 for updating the FACES table for census work.

The 'new' column names appear to be consistent to the 2014 data which remained unfixed (I thought waiting for this 2015 release) from ticket #2915.

The 2013 set appears to be the last version that provides the needed census lookup information.

comment:7 Changed 4 years ago by robe

Milestone: PostGIS FuturePostGIS Fund Me

Milestone renamed

Note: See TracTickets for help on using tickets.