jnicho02

jnicho02

jnicho02

require 'OSM/API'
@api = OSM::API.new
db = @api.get_bbox(-5.2134537,50.040992,-5.0993322,50.2582661)

puts 'require \'sketchup.rb\''
puts 'model = Sketchup.active_model'
db.ways.each { |way| 
  prev = nil
  way[1].node_objects.each { |node|
    if (prev)

jnicho02

SELECT
  t1.way_id, name_tags.v AS name
FROM way_tags AS t1
  INNER JOIN way_tags AS t2 ON (t1.way_id = t2.way_id
    and t2.k = 'railway' and t2.v in ('station','train_station','railway_station','railway station','train_station;bus_station','train station','underground_station','rail_station','trian station')
  )
  LEFT OUTER JOIN way_tags AS name_tags ON (t1.way_id=name_tags.way_id AND name_tags.k='name')
WHERE t1.k = 'building' and t1.v in ('yes','true')

UNION

jnicho02

SELECT
  tag.k, count(*)
FROM
  public.node_tags tag
WHERE
  tag.node_id in
  (SELECT 
     node_id
   FROM
     public.node_tags t2