Changes between Version 34 and Version 35 of UsersWikiplpgsqlfunctions
- Timestamp:
- 08/05/20 15:50:59 (4 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
UsersWikiplpgsqlfunctions
v34 v35 4 4 This is an area to put utility functions or wrappers around PostGIS. 5 5 6 == Rotate Geometry around a point(geom,x,y) == 7 {{{ 8 #!sql 9 CREATE OR REPLACE FUNCTION RotateAtPoint(the_geom geometry, pt_x double precision, pt_y double precision, rotrads double precision) 6 == Rotate Geometry around a Point == 7 {{{ 8 #!sql 9 CREATE OR REPLACE FUNCTION RotateAtPoint( 10 geom geometry, pt_x double precision, pt_y double precision, angle double precision) 10 11 RETURNS geometry AS 11 12 $$ … … 15 16 }}} 16 17 17 == Construct Ellipse ( x,y, rx,ry [,rotation [,#of segments in 1/4 of ellipse] ] ) == 18 {{{ 19 #!sql 20 CREATE OR REPLACE FUNCTION ST_Ellipse(x double precision, y double precision, 18 == Construct Ellipse == 19 {{{ 20 #!sql 21 CREATE OR REPLACE FUNCTION ST_Ellipse( 22 x double precision, y double precision, 21 23 rx double precision, ry double precision, 22 24 rotation double precision DEFAULT 0.0, … … 175 177 {{{ 176 178 #!sql 177 179 CREATE OR REPLACE FUNCTION daylength(geometry, date) 178 180 RETURNS double precision AS 179 181 $$