Opened 11 years ago
Closed 4 years ago
#2465 closed enhancement (fixed)
Update tiger geocoder to use zcta5 from current year (state folder) instead of 2010
| Reported by: | yjoyas | Owned by: | robe |
|---|---|---|---|
| Priority: | medium | Milestone: | PostGIS 2.4.10 |
| Component: | tiger geocoder | Version: | 2.0.x |
| Keywords: | Cc: |
Description
Is it possible to update tiger geocoder to use the t_2013_us_zcta510 file instead of the individual files from 2010. Zip code geometry are always changing and would be nice to be able to update the zip codes easily.
Change History (7)
comment:1 by , 11 years ago
comment:2 by , 11 years ago
Correct that file does not have the statefps since its not really handled by census group anymore. Also last I checked there were about 5 zips that crossed state lines. Am working on a script to import the contiguous file and associate it to the states they're in. After that updating the loader_create_script to read values from that table and insert into main table. Going to try with ogr2ogr as i think it's faster than sh2pgsl. Loading the entire US takes almost as much time as downloading all the files. Let me know your thoughts please.
comment:3 by , 11 years ago
That was one thought I had. I think its doable since we load up the states table so we could use that to compute the statefp with a ST_Covered (in geography mode) and then an ST_Intersection for those that don't completely cover — splitting those zips into pieces and having just that portion of the zip that falls in the state.
We could do it by forcing the order to ensure state load happens first and the zip division as extra steps in processing.
In parctice the sata just gets loaded in to staging first anyway so we can apply any additional steps as part of the processing of that zip all table.
comment:4 by , 9 years ago
| Milestone: | PostGIS 2.2.0 → PostGIS 2.3.0 |
|---|---|
| Summary: | Update tiger geocoder to use zcta5 from 2013 → Update tiger geocoder to use zcta5 from current year (state folder) instead of 2010 |
It's actually whatever the current ones are which is now a single file. This is tricky since I need to do an intersection to have that portion of zip fall in the state. So putting this off.
comment:5 by , 8 years ago
| Milestone: | PostGIS 2.3.0 → PostGIS Future |
|---|
I took zcta download out completely. Seems I may not need it since I build zip lists from other tables. I'll revisit in future if it's worthwhile to add another 600MB download.
comment:7 by , 4 years ago
| Milestone: | PostGIS Fund Me → PostGIS 2.4.10 |
|---|---|
| Resolution: | → fixed |
| Status: | new → closed |
This was done a while ago.
I think I used to do that but I forget why I stopped. I think it might have beeen that the zip code contiguous was missing a field like statefps or something. Let me look at it again.