dbt staging model: `stg_osm__bike_shops`

[MattTriano]

Summary

Extract bike shops and repair stations from raw_data.osm_nodes. Important for commuters to know — especially self-service repair stations with tools and air pumps.

Source table

raw_data.osm_nodes

Filter logic

• shop=bicycle (full-service bike shops)
• amenity=bicycle_repair_station (self-service stands with tools)

Key tags extracted

• name, shop_type (derived: bike_shop or repair_station), opening_hours, website, phone, addr:street, addr:housenumber

Notes

• After running OSM tag exploration, also check for service:bicycle:pump=yes and amenity=compressed_air — these are air pump stations that aren't captured by the current filters
• Feeds into: bike_commuter__points_of_interest mart under category bike_shop