geopython / pygeoapi

pygeoapi is a Python server implementation of the OGC API suite of standards. The project emerged as part of the next generation OGC API efforts in 2018 and provides the capability for organizations to deploy a RESTful OGC API endpoint using OpenAPI, GeoJSON, and HTML. pygeoapi is open source and released under an MIT license.
https://pygeoapi.io
MIT License
459 stars 250 forks source link

PostgreSQL: support numeric types (#1695) #1696

Closed tomkralidis closed 1 week ago

tomkralidis commented 1 week ago

Overview

Adds numeric support for PostgreSQL-based schema/queryable responses.

Related Issue / discussion

Fixes #1695

Additional information

cc @KoalaGeo

Dependency policy (RFC2)

Updates to public demo

Contributions and licensing

(as per https://github.com/geopython/pygeoapi/blob/master/CONTRIBUTING.md#contributions-and-licensing)

tomkralidis commented 1 week ago

FYI as mentioned in #1695, further to approvals, I'd also like @KoalaGeo 's testing to verify, before merging in time for 0.17.0.

KoalaGeo commented 1 week ago

@tomkralidis can confirm thats working now, thank you!

edd@wsl:/mnt/c/GIT/pygeoapi-issue-1695$ docker run -p 5000:80 pygeoapi
START /entrypoint.sh
Trying to generate openapi.yml
Unsupported column type BYTEA
Unsupported column type BYTEA
Unsupported column type BYTEA
Generating /pygeoapi/local.openapi.yml
Done
openapi.yml generated continue to pygeoapi
make SCRIPT_NAME empty from /
Start gunicorn name=pygeoapi on 0.0.0.0:80 with 4 workers and SCRIPT_NAME=
[2024-06-27 11:33:39 +0000] [1] [INFO] Starting gunicorn 20.1.0
[2024-06-27 11:33:39 +0000] [1] [INFO] Listening at: http://0.0.0.0:80 (1)
[2024-06-27 11:33:39 +0000] [1] [INFO] Using worker: gevent
[2024-06-27 11:33:39 +0000] [16] [INFO] Booting worker with pid: 16
[2024-06-27 11:33:39 +0000] [17] [INFO] Booting worker with pid: 17

image