[postgis-tickets] [PostGIS] #4655: TIGER 'addrfeat' table definition vs. current 2019 shapefiles

[PostGIS]

#4655: TIGER 'addrfeat' table definition vs. current 2019 shapefiles
-----------------------+---------------------
  Reporter:  jlrobins  |      Owner:  pramsey
      Type:  defect    |     Status:  new
  Priority:  medium    |  Milestone:
 Component:  postgis   |    Version:  3.0.x
Resolution:            |   Keywords:
-----------------------+---------------------

Comment (by jlrobins):

 Sorry, that last informational query should have projected the tlid of
 some interesting rows, not my own gid serial values:

 {{{
 tiger=# select tlid, fullname, edge_mtfcc, road_mtfcc
     from tiger_data.fl_addrfeat where edge_mtfcc != road_mtfcc
     order by 1, 2, 3, 4 limit 5;


   tlid   | fullname  | edge_mtfcc | road_mtfcc
 ---------+-----------+------------+------------
  5160653 | Waldo St  | P0001      | S1400
  6848822 | 1st Ave   | P0001      | S1200
  6848822 | 1st Ave   | P0001      | S1200
  6980365 | Burns Ave | P0001      | S1400
  7062643 | Hwy 389   | P0001      | S1200
 (5 rows)
 }}}

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