Application – ski lift scout

To show the ability to assess current data and use notifications to learn of changes, we’ll present a scenario related to the ski lifts used at ski resorts to transport passengers. Yes, in the wide array of data updated in the OSM platform, you’ll find most major ski areas are mapped out with the exact location of loading stations as well as the cable lines themselves.

To understand how this data can be accessed, it is first important to look at how it is stored. You have been introduced to the concept of tags in OSM nodes and way data. Let’s take a look at the data tagged with aerialway=station:

CREATE OR REPLACE VIEW "skilifts_vw" AS
SELECT
  p.tags['name'] lift_name
, p.tags['operator'] operator
, p.tags['state'] state
, p.id
, p.type
, p.lat
, p.lon
, p.timestamp
, p.uid
, p.user
, p.version
, p.tags
FROM
  planet p
WHERE ((p.tags['aerialway'] = ...