[PostGIS] #5691: Revive tiger_topology function

[PostGIS]

#5691: Revive tiger_topology function
----------------------------+---------------------------
 Reporter:  robe            |      Owner:  robe
     Type:  enhancement     |     Status:  new
 Priority:  medium          |  Milestone:  PostGIS 3.5.0
Component:  tiger geocoder  |    Version:  master
 Keywords:                  |
----------------------------+---------------------------
 I had written topology_load_tiger eons ago like 20 years ago partly as a
 tool to stress test topology and also to see if I could retrofit an
 existings SQL/MM topology model into postgis_topology.

 Now that so much is going on with postgis_topology, seems like a good idea
 to revive that function and revise it to use some of the new enhancements
 in topology.

 The idea I had behind it, was to take the TIGER schema setup
 (Topologically Integrated Geographic Encoding and Referencing system),
 which is also based on SQL/MM Topology model (but that they had built on
 Oracle), and use the same ids they have etc to directly load into a
 postgis_topology setup (totally skipping all that nice work Sandro had
 done to load geometries into postgis topology), but then use the
 validation functions and then moving forward see how it could be edited
 with postgis_topology.

 Somewhere down the line, my original tests became horribly slow and I was
 too lazy to investigate what went wrong, if it was a change in GEOS or
 addition of triggers etc. in topology.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5691>
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.