Switch HSLMapServer layers to pg_tileserv service

[hbruch]

Currently, stadtnavi still use HSLMapServer to generate vector tiles for weather stations.
This should be implemented via the new pg_tileserv service.

To use pg_tileserv,

• the weathe rstations need to be imported regularly into the postgres database (e.g. via ogr2ogr, see e.g. this blog post) and
• possible pg_tileserve needs some custom configuration

Note: roadworks vector tiles will be retrieved from mobidata, parking, sharing and stops layers are nowadays retrieved directly from OTP, charging stations via ocpdb. Switching the weather stations will turn hsl-map-server service obsolete so it should be removed.

[leonardehrenfried]

I completely forgot everything about the weather feature so I dug through the ansible code and found out that the export to geojson that I set up in 2020-ish still works! https://api.dev.stadtnavi.eu/herrenberg/weather/weather.geojson

I will see if I can make ogr2ogr work.

[leonardehrenfried]

Looking good.

Frankly I can't believe how easy it was.

[leonardehrenfried]

https://features.stadtnavi.eu/public.weather_stations.html#14.01/48.6043/8.84464

[stadtnavimanager]

@hbruch implementation in digitransit

[hbruch]

While https://api.dev.stadtnavi.eu/herrenberg/weather/weather.geojson (and it's pendant at https://api.stadtnavi.de/herrenberg/weather/weather.geojson) are continuously updated, this is not the case for https://features.stadtnavi.eu/:

Could you have a look again, please @leonardehrenfried?

[hbruch]

Looks like the issue is rather that features are not replaced but rather added for each import...

[leonardehrenfried]

Yikes!

[leonardehrenfried]

Do you know how you can teach ogr2ogr to delete the old entries?

[hbruch]

-overwrite should according to the docs be the option to go

[hbruch]

updatedat still shows 2024-12-04(?)

[leonardehrenfried]

Sorry, the vector tiles are cached by the browser. I think featureserver looks ok, doesn' it? https://featuredetails.stadtnavi.eu/collections/public.weather_stations/items.json

[hbruch]

Another request: could you please use LAUNDER=NO as import option so that column case is preserved as was before? Currently import switch column names to lowercase requiring, besides changing the layer names, additional changes, which I'd like to avoid. Thanks

[leonardehrenfried]

Does this make a difference? 3cef8db

[hbruch]

Closing as completet