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.

Sign up for GitHub

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

Jump to bottom

Query with bbox_filter returns HTTP 500 #606

Closed
jirik opened this issue Apr 19, 2022 · 1 comment
Closed

Query with bbox_filter returns HTTP 500 #606

jirik opened this issue Apr 19, 2022 · 1 comment
Labels
bug Something isn't working
Milestone
Release 1.17

Comments

@jirik
Copy link
Member

jirik commented Apr 19, 2022

If there is a layer in pro db schema with BOX(-180 -90,-180 -90), EPSG:4326, and HTTP request comes with bbox_filter in EPSG:3857, Layman returns 500 caused by psycopg2.errors.InternalError_: transform: tolerance condition error (-20)

It can be solved e.g. by cropping each BBOX to world_bounds before transformation.
@jirik jirik added the bug Something isn't working label Apr 19, 2022
@jirik jirik added this to the Release 1.17 milestone Apr 19, 2022
@jirik
Copy link
Member Author

jirik commented Apr 19, 2022

Related code:

layman/src/layman/common/prime_db_schema/publications.py

Line 72 in 2125672

(bbox_filter, 'ST_TRANSFORM(ST_SetSRID(p.bbox, p.srid), %s) && ST_MakeBox2D(ST_MakePoint(%s, %s), ST_MakePoint(%s, %s))',

@index-git index-git mentioned this issue Jun 24, 2022
Merged
2 tasks
@index-git index-git mentioned this issue Jul 18, 2022
Merged
2 tasks
@jirik jirik closed this as completed Jul 20, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug Something isn't working
Projects
None yet
Milestone
Release 1.17
Development

No branches or pull requests
1 participant
@jirik