Opened 15 years ago
Closed 13 years ago
#135 closed task (fixed)
Upgrade geocoder to use the new tiger 2010 files
| Reported by: | robe | Owned by: | sfrost |
|---|---|---|---|
| Priority: | medium | Milestone: | PostGIS 2.0.0 |
| Component: | postgis | Version: | master |
| Keywords: | tiger | Cc: |
Description (last modified by )
What steps will reproduce the problem?
- the tiger geocoder relies on the 2006 and below which tiger files which
were in the proprietary Tiger format. In 2007 census switched to using ESRI shape file format and corrected a lot of data.
- Most people I know want to use the new stuff, but the structure has
changed quite a bit. E.g. the address file is now a separate table called addr and can have a 1 to many with the edges table (what used to be complete chain)
- This will all take a bit of work. Not sure if Steve Frost has started
this work yet or not.
Change History (10)
comment:1 by , 15 years ago
comment:2 by , 15 years ago
| Description: | modified (diff) |
|---|---|
| Owner: | changed from to |
| Priority: | → blocker |
| Status: | assigned → new |
comment:3 by , 15 years ago
| Owner: | changed from to |
|---|---|
| Status: | new → assigned |
comment:4 by , 15 years ago
| Owner: | changed from to |
|---|---|
| Status: | assigned → new |
comment:5 by , 15 years ago
| Priority: | blocker → medium |
|---|
comment:7 by , 14 years ago
| Milestone: | PostGIS 1.5.0 → PostGIS Future |
|---|
comment:8 by , 14 years ago
| Keywords: | tiger added |
|---|
comment:9 by , 13 years ago
| Milestone: | PostGIS Future → PostGIS 2.0.0 |
|---|---|
| Summary: | Upgrade geocoder to use the new tiger 2008 files → Upgrade geocoder to use the new tiger 2010 files |
I think we can get this into PostGIS 2.0.0. Steve let me know if you are still interested in working on this. If so I'd like it committed to trunk. If not I'll take what you have so far and merge in my corrections and commit to trunk.
comment:10 by , 13 years ago
| Resolution: | accepted → fixed |
|---|---|
| Status: | new → closed |
We've ammended the tiger geocoder to work with tiger 2010 and as far as we can tell, it works fine. At least for Massachusetts data anyway. We'll be stress testing it more with a consulting project we are currently working on and tweaking it as we go along, but we consider it more or less done. It is now also documented as part of the official PostGIS docs. http://www.postgis.org/documentation/manual-svn/Extras.html#Tiger_Geocoder
We still haven't gotten around to testing the loader script on linux if anyone else wants to take a stab at that. Jan had tested it on Ubuntu for our book, and we incorporated his corrections as best we could.
We may add a reverse geocoder function to it before we are done since we'll need to build that anyway for work we are currently doing, but will add that as a separate task item.
I've already updated the geocoder itself to use the TIGER 2007/2008 shapefile data. I'm working with someone else on improving it further as well as improving the load scripts to build the whole system.
If you have git, you can pull the latest from here: http://www.snowman.net/git/tiger_geocoder
Once it's working well with the import scripts, the 2008 data, etc, I'll be committing it back to the PostGIS SVN. I'm on the hook to complete this work before PgCon 2009 (in May).