[postgis-tickets] [PostGIS] #3227: Support for Tiger 2015

[PostGIS]

#3227: Support for Tiger 2015
-----------------------------+---------------------------
  Reporter:  robe            |      Owner:  robe
      Type:  enhancement     |     Status:  reopened
  Priority:  high            |  Milestone:  PostGIS 2.2.0
 Component:  tiger geocoder  |    Version:  trunk
Resolution:                  |   Keywords:
-----------------------------+---------------------------

Comment (by robe):

 Brian,

 On second thought, I guess just in case users have another state table in
 their search path, probably a good idea to schema qualify all these
 tables.  I don't plan on changing the schema from tiger for a while so
 that seems safe.

 Now regarding your issue above, I just tried reloading my state and works
 fine (though perhaps you have another state table and its inheriting from
 the wrong one).
 Here is my output for compare:


 {{{
 c:\gisdata\ftp2.census.gov\geo\tiger\TIGER2015\STATE>"C:\Program
 Files\7-Zip\7z.exe" e
 c:\gisdata\ftp2.census.gov\geo\tiger\TIGER2015\STATE\tl_2015_us_state.zip
 -o\gisdata\temp\

 7-Zip [64] 9.38 beta  Copyright (c) 1999-2014 Igor Pavlov  2015-01-03

 Processing archive:
 c:\gisdata\ftp2.census.gov\geo\tiger\TIGER2015\STATE\tl_2015_us_state.zip

 Extracting  tl_2015_us_state.cpg
 Extracting  tl_2015_us_state.dbf
 Extracting  tl_2015_us_state.prj
 Extracting  tl_2015_us_state.shp
 Extracting  tl_2015_us_state.shp.ea.iso.xml
 Extracting  tl_2015_us_state.shp.iso.xml
 Extracting  tl_2015_us_state.shp.xml
 Extracting  tl_2015_us_state.shx

 Everything is Ok

 Files: 8
 Size:       14045142
 Compressed: 8780814

 Kernel  Time =     0.000 =    0%
 User    Time =     0.156 =   91%
 Process Time =     0.156 =   91%    Virtual  Memory =      2 MB
 Global  Time =     0.170 =  100%    Physical Memory =      5 MB

 c:\gisdata\ftp2.census.gov\geo\tiger\TIGER2015\STATE>cd \gisdata\temp\

 c:\gisdata\temp>"C:\ming64gcc48\projects\postgresql\rel\pg9.4w64gcc48edb\bin\psql"
 -c "CREATE TABLE tiger_data.state_all(CONSTRAINT pk_state_all PRIMARY KEY
 (statefp),CONSTRAINT uidx_state_all_stusps  UNIQUE (stusps), CONSTRAINT
 uidx_state_all_gid UNIQUE (gid) ) INHERITS(state); "
 CREATE TABLE

 c:\gisdata\temp>"C:\ming64gcc48\projects\postgresql\rel\pg9.4w64gcc48edb\bin\shp2pgsql"
 -D -c -s 4269 -g the_geom   -W "latin1" tl_2015_us_state.dbf
 tiger_staging.state   |
 "C:\ming64gcc48\projects\postgresql\rel\pg9.4w64gcc48edb\bin\psql"
 Shapefile type: Polygon
 Postgis type: MULTIPOLYGON[2]
 SET
 SET
 BEGIN
 CREATE TABLE
 ALTER TABLE
                         addgeometrycolumn
 ------------------------------------------------------------------
  tiger_staging.state.the_geom SRID:4269 TYPE:MULTIPOLYGON DIMS:2
 (1 row)

 COPY 56
 COMMIT
 ANALYZE

 c:\gisdata\temp>"C:\ming64gcc48\projects\postgresql\rel\pg9.4w64gcc48edb\bin\psql"
 -c "SELECT loader_load_staged_data(lower('state'), lower('state_all')); "
 NOTICE:  INSERT INTO
 tiger_data.state_all(region,division,statefp,statens,stusps,name,lsad,mtfcc,funcstat,aland,awater,intptlat,intptlon,the_geom)
 SELECT
 region,division,statefp,statens,stusps,name,lsad,mtfcc,funcstat,aland,awater,intptlat,intptlon,the_geom
 FROM tiger_staging.state;
 CONTEXT:  SQL function "loader_load_staged_data" statement 1
  loader_load_staged_data
 -------------------------
                       56
 (1 row)



 c:\gisdata\temp>"C:\ming64gcc48\projects\postgresql\rel\pg9.4w64gcc48edb\bin\psql"
 -c "CREATE INDEX tiger_data_state_all_the_geom_gist ON
 tiger_data.state_all USING gist(the_geom);"
 CREATE INDEX

 }}}

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3227#comment:11>
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.