446 (SELECT |
446 (SELECT |
447 way, |
447 way, |
448 name, |
448 name, |
449 bilingual_name, |
449 bilingual_name, |
450 railway, |
450 railway, |
451 tags->'railway:ref' AS ref |
451 COALESCE(tags->'network', 'FI:local') AS network, |
|
452 tags->'railway:ref' AS ref, |
|
453 (CASE WHEN tags->'station' = 'subway' THEN 1 ELSE 0 END) AS subway |
452 FROM planet_osm_point |
454 FROM planet_osm_point |
453 WHERE "railway" IN ('station', 'halt') |
455 WHERE "railway" IN ('station', 'halt') |
454 ) AS train_stations |
456 ) AS train_stations |
455 - id: place-medium |
457 - id: place-medium |
456 geometry: point |
458 geometry: point |