Unable to answer "What type of bicycle barrier is this?" – Cycle Barrier – https://osm.org/node/6684349075 via StreetComplete 58.2:

Drehbare Schranke und zwei feste Pfosten

Attached photo(s):
https://westnordost.de/p/235214.jpg