[postgis-tickets] [PostGIS] #2968: TIGER Geocoder data loading misc

[PostGIS]

#2968: TIGER Geocoder data loading misc
----------------------------+-----------------------------------------------
 Reporter:  darkblueb       |       Owner:  robe         
     Type:  defect          |      Status:  new          
 Priority:  medium          |   Milestone:  PostGIS 2.2.0
Component:  tiger geocoder  |     Version:  trunk        
 Keywords:                  |  
----------------------------+-----------------------------------------------

Comment(by robe):

 I assume you mean 9.4beta3 right? These are the counts I get for cali on
 my windows box.  I think they agree with your numbers.


 {{{
 PostgreSQL 9.4beta3, compiled by Visual C++ build 1800, 32-bit
 POSTGIS="2.2.0de
  r13057" GEOS="3.5.0dev-CAPI-1.9.0 r4026" PROJ="Rel. 4.8.0, 6 March 2012"
 GDAL=
 GDAL 1.11.1, released 2014/09/24" LIBXML="2.7.8" LIBJSON="0.12" RASTER
 }}}

 tabblock I know needs fixing cause I didn't fix it and they changed the
 struct in tiger 2014.


 {{{
      table_name     |   cnt
 --------------------+---------
  ca_addr            | 2934938
  ca_bg              |   23212
  ca_cousub          |     397
  ca_edges           | 3923238
  ca_faces           | 1133110
  ca_featnames       | 4526071
  ca_place           |    1516
  ca_tabblock        |       0
  ca_tract           |    8057
  ca_zcta5           |    1769
  ca_zip_lookup_base |    4947
  ca_zip_state       |    2214
  ca_zip_state_loc   |    4861
 }}}

 Do you happen to have 2013 data lying around.  I don't have for CA but in
 MA I think the edge count went down presumably because of some fixing.
 After I loaded MA 2014 data issues that Leo had with geocoding one newly
 renovated area in cambridge, ma was fixed.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2968#comment:4>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.