-
-
Notifications
You must be signed in to change notification settings - Fork 199
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
custom provider query -> wrong/too much results #869
Comments
Are the in levels integers or text in the database? Your query has '8' which indicates text. Double check the data type on the admin levels column. Also, for the provider, take a look at mvt_postgis as you will see some great performance gains. |
While you seem to be correct that admin level is type int, the expected outcome of using |
8 or '8' didn't do any difference. tried both. looks like its ignored completely. but syntax-errors in the query are not ignored (changes are recognized) @ARolek i will look into mvt_postgis, thanks :) |
@baststar hmm, seems strange. One way to debug this is to turn on |
where is the output of the logs? tegola-deployment.yaml
EDIT 01.07.2022: |
Start tegola with --log-level DEBUG from v0.15.0 upwards. |
@iwpnd Thank you! That works. With only this single Layer
i got these logs:
so there is a second query happenig... it is this little (bad named) thing here:
http://xxx.xxx.xxx.xxx/maps/osm/admin_lines_level_8/{z}/{x}/{y}.pbf?debug=true admin_lines_level_8 becomes "admin_lines" and "admin_lines_level_8" on the server i renamed it to "adminlines8" and now i'm getting only admin-levels of 8!! Thanks all!! :) |
Awesome! |
@baststar did you figure out if that was OpenLayers or tegola mutating the name? |
I'm not near my computer this week, I will look into it more when i get back. Could you create a small test case, this sounds like a bug on our side. Thank you. |
Hi,
i have this layer configured:
with this map:
and my provider-configuration:
but instead of getting data only where admin_level = 8 i get also all other admin_levels (2, 4, 6, 9)
Am i doing this right or am i misunderstanding something?
Im using no cache at the moment
The text was updated successfully, but these errors were encountered: