Changes between Version 30 and Version 31 of UsersWikiplpgsqlfunctions

Timestamp:

Aug 5, 2020, 10:39:11 AM (4 years ago)

Author:

mdavis

Comment:

—

UsersWikiplpgsqlfunctions

@@ -3 +3 @@
  
 This is an area to put utility functions or wrappers around PostGIS.
+
+== Rotate Geometry around a point(geom,x,y) ==
+{{{
+#!sql
+CREATE OR REPLACE FUNCTION RotateAtPoint(the_geom geometry, pt_x double precision, pt_y double precision, rotrads double precision)
+ RETURNS geometry AS 
+$$
+SELECT ST_Translate( ST_Rotate( ST_Translate( $1, -1*$2, -1*$3), $4), $2, $3)
+$$
+   LANGUAGE 'sql';
+}}}
+
+== Construct Ellipse ( x,y, rx,ry [,rotation [,#of segments in 1/4 of ellipse] ] ) ==
+{{{
+#!sql
+CREATE OR REPLACE FUNCTION ST_Ellipse(x double precision, y double precision, 
+  rx double precision, ry double precision, 
+  rotation double precision DEFAULT 0.0, quadSeg integer DEFAULT 8)
+ RETURNS geometry AS
+ $$
+   SELECT ST_Translate( ST_Rotate( ST_Scale( ST_Buffer(ST_Point(0,0), 0.5, quadSeg), rx, ry), rotation), x, y)
+$$
+ LANGUAGE 'sql';
+}}}
 
 == Construct an arc given two points on the arc, the centre point and direction or size ==
@@ -167 +191 @@
 }}}
 
-== Rotate Geometry around a point(geom,x,y) ==
-{{{
-#!sql
-CREATE OR REPLACE FUNCTION RotateAtPoint(the_geom geometry, pt_x double precision, pt_y double precision, rotrads double precision)
- RETURNS geometry AS 
-$$
-SELECT ST_Translate( ST_Rotate( ST_Translate( $1, -1*$2, -1*$3), $4), $2, $3)
-$$
-   LANGUAGE 'sql';
-}}}
-
-== Construct Ellipse ( x,y, rx,ry [,rotation [,#of segments in 1/4 of ellipse] ] ) ==
-{{{
-#!sql
-CREATE OR REPLACE FUNCTION ST_Ellipse(x double precision, y double precision, 
-  rx double precision, ry double precision, 
-  rotation double precision DEFAULT 0.0, quadSeg integer DEFAULT 8)
- RETURNS geometry AS
- $$
-   SELECT ST_Translate( ST_Rotate( ST_Scale( ST_Buffer(ST_Point(0,0), 0.5, quadSeg), rx, ry), rotation), x, y)
-$$
- LANGUAGE 'sql';
-}}}
 
 == Construct a multilinestring consisting of the interior and exterior rings of a polygon/multipolygon ==