#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: |
Description
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)
Change History (9)
by , 12 years ago
| Attachment: | census_utyp.patch added |
|---|
comment:1 by , 12 years ago
| Summary: | Missing field from tabblock table in census_loader → Missing field from tabblock table in tiger2010 census_loader.sql |
|---|
comment:2 by , 12 years ago
| Milestone: | PostGIS 2.0.1 → PostGIS 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:4 by , 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 , 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.
follow-up: 7 comment:6 by , 12 years ago
| Keywords: | history added |
|---|---|
| Resolution: | → fixed |
| Status: | new → closed |
fixed for 2.0 at r10716 (just excluding the field)
comment:7 by , 12 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 , 12 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.
Patch for tabblock schema.