Skip to content

Instantly share code, notes, and snippets.

@springmeyer
Created December 5, 2008 06:02
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save springmeyer/32252 to your computer and use it in GitHub Desktop.
Save springmeyer/32252 to your computer and use it in GitHub Desktop.
<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) &gt;= 20 THEN 'large' WHEN round(way_area * 1000000) &gt;= 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>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment