SHARE
TWEET

Example osm2pgsql local name view

a guest Sep 30th, 2013 278 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT
  2.   osm_id
  3. , access
  4. , "addr:flats"
  5. , "addr:housenumber"
  6. , "addr:interpolation"
  7. , admin_level
  8. , aerialway
  9. , aeroway
  10. , amenity
  11. , area
  12. , barrier
  13. , bicycle
  14. , bridge
  15. , boundary
  16. , building
  17. , capital
  18. , construction
  19. , cutting
  20. , disused
  21. , ele
  22. , embankment
  23. , foot
  24. , highway
  25. , historic
  26. , horse
  27. , junction
  28. , landuse
  29. , layer
  30. , learning
  31. , leisure
  32. , lock
  33. , man_made
  34. , military
  35. , motorcar
  36. , CASE WHEN
  37.    tags->'name:en' IS NOT NULL AND tags->'name:en' <> name
  38.    THEN name || ' (' || tags->'name:en' || ')'
  39.    ELSE name
  40.   END AS name
  41. , natural
  42. , oneway
  43. , operator
  44. , poi
  45. , power
  46. , power_source
  47. , place
  48. , railway
  49. , ref
  50. , religion
  51. , residence
  52. , route
  53. , service
  54. , shop
  55. , sport
  56. , tourism
  57. , tunnel
  58. , waterway
  59. , width
  60. , wood
  61. , z_order
  62. , tags
  63. , way
  64. FROM raw_point
  65.  order by ordinal_position
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top