Ability to load topogeoms using shp2pgsql

[robe]

In writing chapters of the book, one exercise is to load the data with shp2pgsql and then a second step to load into a specific topology.

Aside from speed issues, I can't see why we can't just go straight to a topogeom column much like we do with geography is -G is chosen.

This would require another switch for topology name and name of topology. The only tricky part is that for the toTopogeom calls we need the generated layer id, which would require a connection to the database to get unless we have a lookup function of some sort that can lookup the layerid based on topo column table/name.

[strk]

I've been actually thinking that AddTopoGeometryColumn could be modified (or overloaded) to also accept an existing column for the purpose of registering it when missing (think CopyTopology). The same function could maybe return an already-registered layer_id too. I like the idea of reducing signatures …

[robe]

This would make a good google summer of code project. Added to page — http://trac.osgeo.org/postgis/wiki/GoogleSummerCode2012

[robe]

Also added link to ​http://wiki.osgeo.org/wiki/Google_Summer_of_Code_2012_Ideas#The_ideas_pages

[robe]

Milestone renamed

[strk]

We have a lookup function now: ​https://trac.osgeo.org/postgis/changeset/429bf56aa47e55a13555a15d20ef08a1c14d2aba/git (undocumented though)

[strk]

shp2pgsql switches -t and -T are already taken, ideas on what switch to use for this ?

[robe]

added to Google Summer Of Code 2022