Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- osm_id
- , access
- , "addr:flats"
- , "addr:housenumber"
- , "addr:interpolation"
- , admin_level
- , aerialway
- , aeroway
- , amenity
- , area
- , barrier
- , bicycle
- , bridge
- , boundary
- , building
- , capital
- , construction
- , cutting
- , disused
- , ele
- , embankment
- , foot
- , highway
- , historic
- , horse
- , junction
- , landuse
- , layer
- , learning
- , leisure
- , lock
- , man_made
- , military
- , motorcar
- , CASE WHEN
- tags->'name:en' IS NOT NULL AND tags->'name:en' <> name
- THEN name || ' (' || tags->'name:en' || ')'
- ELSE name
- END AS name
- , natural
- , oneway
- , operator
- , poi
- , power
- , power_source
- , place
- , railway
- , ref
- , religion
- , residence
- , route
- , service
- , shop
- , sport
- , tourism
- , tunnel
- , waterway
- , width
- , wood
- , z_order
- , tags
- , way
- FROM raw_point
- order by ordinal_position
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement