Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <Parameter name="table"><![CDATA[
- (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>
- becomes:
- <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