[postgis-tickets] r14783 - more formatting fixes

[Regina Obe]

Author: robe
Date: 2016-03-13 12:22:28 -0700 (Sun, 13 Mar 2016)
New Revision: 14783

Modified:
   web/_content/posts/2016/03-13_tip_pixels_of_range_value.html
Log:
more formatting fixes

Modified: web/_content/posts/2016/03-13_tip_pixels_of_range_value.html
===================================================================
--- web/_content/posts/2016/03-13_tip_pixels_of_range_value.html	2016-03-13 19:20:56 UTC (rev 14782)
+++ web/_content/posts/2016/03-13_tip_pixels_of_range_value.html	2016-03-13 19:22:28 UTC (rev 14783)
@@ -27,7 +27,8 @@
 
 {% geshi 'sql' %}
 SELECT ST_Reclass(rast, 1, 
-	'[0-90]:0,(90-100):1,[100-1000):2', '4BUI', 0) As rast
+	'[0-90]:0,(90-100):1,[100-1000):2', 
+		'4BUI', 0) As rast
     FROM  sometable
     WHERE filename = '123.tif';
 {% endgeshi %}
@@ -40,17 +41,20 @@
 {% geshi 'sql' %}
 WITH cgeoms AS ( SELECT ST_DumpAsPolygons( 
 	ST_Reclass(rast, 1, 
-	'[0-90]:0,(90-100):1,[100-1000):2', '4BUI', 0), 1
+	'[0-90]:0,(90-100):1,[100-1000):2', 
+		'4BUI', 0), 1
 	) AS gval
     FROM  sometable
     WHERE filename = '123.tif' )
-SELECT ST_Centroid( ST_Union( (gval).geom ) ) As geom, (gval).val
+SELECT ST_Centroid( 
+	ST_Union( (gval).geom ) ) As geom,
+	(gval).val
 FROM cgeoms
 GROUP BY (gval).val;
+{% endgeshi %}
 
 
 There are also many stats you can do with functions such as ```ST_Histogram``` and ```ST_ValueCount``` so you do not 
 have to resort to vectorizing your raster to do basic stats on it.
-{% endgeshi %}