Changes between Version 26 and Version 27 of UsersWikiplpgsqlfunctions


Ignore:
Timestamp:
Aug 5, 2020, 10:23:28 AM (4 years ago)
Author:
mdavis
Comment:

—

Legend:

Unmodified
Added
Removed
Modified

  • UsersWikiplpgsqlfunctions

    v26 v27  
    6060}}}
    6161
    62 * '''Convert degree minutes seconds to long lat decimals '''
     62== Convert degree minutes seconds to lon/lat decimals ==
    6363
    6464This is from Simon Greener's article [http://www.spatialdbadvisor.com/postgis_tips_tricks/115/dms2dd-for-postgis/ DMS2DD for PostGIS]
    … …  
    157157
    158158
    159  * '''Find Length of Day for a given location and date'''
     159== Find Length of Day for a given location and date ==
    160160{{{
    161161#!sql
    … …  
    179179}}}
    180180
    181  * '''Create Ellipse (x,y,rx,ry,rotation,#of segments in 1/4 of ellipse)'''
     181== Create Ellipse (x,y,rx,ry,rotation,#of segments in 1/4 of ellipse) ==
    182182{{{
    183183#!sql
    … …  
    190190}}}
    191191
    192  * '''Return a multilinestring consisting of the interior and exterior rings of a polygon/multipolygon'''
     192== Construct a multilinestring consisting of the interior and exterior rings of a polygon/multipolygon ==
    193193
    194194''This already exists in PostGIS: see ST_Boundary(geometry)''
    … …  
    220220}}}
    221221
    222  * '''Shift a straight line along dist units along its perpendicular'''
     222== Shift a straight line along dist units along its perpendicular ==
    223223This was written before the existence of ST_OffSetCurve.  Using ST_OffsetCurve(http://postgis.net/docs/ST_OffsetCurve.html) does the same and can handle non-straight lines
    224224