bcdata_py icon indicating copy to clipboard operation
bcdata_py copied to clipboard

bc2pg - record geometry type?

Open smnorris opened this issue 1 year ago • 1 comments

An empty table can be created fairly quickly with bcdata bc2pg -e -c 1 <dataset>, but this still takes a bit of time to round-trip from WFS. For automated testing and generation of db setup scripts, a bc2pg option for emitting only create table SQL would be useful (rather than creating the empty table).

The table is defined by the catalogue api - apart from the geometry type. If we record known geometry types the request to WFS should not be required for defining the table / generating sql.

smnorris avatar Apr 26 '24 16:04 smnorris

Modify/rename this file to include geometry type as well as PK: https://github.com/smnorris/bcdata/blob/main/data/primary_keys.json

smnorris avatar Apr 26 '24 16:04 smnorris