Opened 10 years ago
Last modified 14 months ago
#2103 new enhancement
Ability to load topogeoms using shp2pgsql
|Reported by:||robe||Owned by:||strk|
|Priority:||medium||Milestone:||PostGIS Fund Me|
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.
Change History (11)
comment:1 by , 10 years ago
comment:2 by , 10 years ago
This would make a good google summer of code project. Added to page — http://trac.osgeo.org/postgis/wiki/GoogleSummerCode2012
comment:3 by , 10 years ago
Also added link to http://wiki.osgeo.org/wiki/Google_Summer_of_Code_2012_Ideas#The_ideas_pages
comment:4 by , 10 years ago
comment:5 by , 10 years ago
|Milestone:||PostGIS 2.1.0 → PostGIS 2.2.0|
comment:6 by , 8 years ago
|Milestone:||PostGIS 2.2.0 → PostGIS Future|
comment:7 by , 6 years ago
|Milestone:||PostGIS Future → PostGIS Fund Me|
comment:8 by , 16 months ago
We have a lookup function now: https://trac.osgeo.org/postgis/changeset/429bf56aa47e55a13555a15d20ef08a1c14d2aba/git (undocumented though)
comment:9 by , 16 months ago
shp2pgsql switches -t and -T are already taken, ideas on what switch to use for this ?
comment:10 by , 14 months ago
comment:11 by , 14 months ago
added to Google Summer Of Code 2022
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 …