Opened 12 years ago

Closed 12 years ago

Last modified 11 years ago

#1885 closed defect (fixed)

Missing field from tabblock table in tiger2010 census_loader.sql

Reported by: bpanulla Owned by: robe
Priority: medium Milestone: PostGIS 2.0.2
Component: tiger geocoder Version: 2.0.x
Keywords: history Cc:


The TIGER tabblock shapefiles have an extra field "utyp" compared to the tabblock table definition. This causes the loader to break on that table. The TIGER tech docs. p 5-32 says it should be a 1 character field.

Attachments (1)

census_utyp.patch (433 bytes ) - added by bpanulla 12 years ago.
Patch for tabblock schema.

Download all attachments as: .zip

Change History (9)

by bpanulla, 12 years ago

Attachment: census_utyp.patch added

Patch for tabblock schema.

comment:1 by bpanulla, 12 years ago

Summary: Missing field from tabblock table in census_loaderMissing field from tabblock table in tiger2010 census_loader.sql

comment:2 by robe, 12 years ago

Milestone: PostGIS 2.0.1PostGIS 2.0.2

Don't think I'll have time to test this before release so pushing it. I think I had opted to leave out certain fields so I may need to make changes in the loader table instead.

comment:3 by robe, 12 years ago

Forgot to ask — what is your name? Thanks, Regina

comment:4 by robe, 12 years ago

hmm this seems to be a bit of a mess. In the 2011 dataset they don't seem to have this field. I think when I developed this they didn't have this field either and data for tiger 2010 tabblocks seems to have been updated recently (has newer timstamps than the tiger 2011 tabblocks). I think the solution is to just leave it out if present so I'll change the script accordingly. You see a need for this field?

comment:5 by bpanulla, 12 years ago

I don't personally see a strong need for the field. The loader script failed when the schema of the destination table didn't match what it had pulled from the shapefile, and it wasn't too much of a chore to add it.

comment:6 by robe, 12 years ago

Keywords: history added
Resolution: fixed
Status: newclosed

fixed for 2.0 at r10716 (just excluding the field)

in reply to:  6 comment:7 by channelzero, 11 years ago

Replying to robe:

fixed for 2.0 at r10716 (just excluding the field)

This field is present in some, not all, tiger2010 State data. I just hit this bug loading 2010 New Hampshire data.

I'm loading the lower 48 + HI States. Is there a way for me to track how many other States use the column once I add it to the table?

I'm going to leave the bug closed as the inner workings of postGIS are way out of my skill set.

comment:8 by robe, 11 years ago

Hmm — I was afraid that all states were not structured the same. That's probably why I never ran into the issue loading MA data. Are you using r10716. In theory it should work for all states since I'm simply skipping the utyp field if it exists. Though I haven't tried it with New Hampshire for example.

Note: See TracTickets for help on using tickets.