Guest User

Untitled

a guest
Feb 21st, 2018
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.11 KB | None | 0 0
  1. <Parameter name="table"><![CDATA[
  2. (SELECT *,
  3. (CASE WHEN round(way_area * 1000000) >= 20 THEN 'large'
  4. WHEN round(way_area * 1000000) >= 1 THEN 'medium'
  5. ELSE 'small' END) AS size,
  6. REGEXP_REPLACE(UPPER(name), '(.)', E'\\1\xC2\xA0\xC2\xA0', 'g') AS name_stretched
  7. FROM planet_osm_polygon
  8. WHERE building IS NOT NULL
  9. ORDER BY z_order ASC, way_area DESC) AS citylike]]></Parameter>
  10.  
  11. becomes:
  12.  
  13. <Parameter name="table"> (SELECT *, (CASE WHEN round(way_area * 1000000) >= 20 THEN 'large' WHEN round(way_area * 1000000) >= 1 THEN 'medium' ELSE 'small' END) AS size, REGEXP_REPLACE(UPPER(name), '(.)', E'\\1\xC2\xA0\xC2\xA0', 'g') AS name_stretched FROM planet_osm_polygon WHERE building IS NOT NULL ORDER BY z_order ASC, way_area DESC) AS citylike</Parameter>
Add Comment
Please, Sign In to add comment