Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

bc2pg ddl, record geometry type #177

Open
smnorris opened this issue Apr 26, 2024 · 1 comment
Open

bc2pg ddl, record geometry type #177

smnorris opened this issue Apr 26, 2024 · 1 comment

Comments

@smnorris
Copy link
Owner

smnorris commented Apr 26, 2024

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
Copy link
Owner Author

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

@smnorris smnorris modified the milestone: 0.11.0 Jun 28, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant