Changes between Version 22 and Version 23 of UsersWikiplpgsqlfunctions


Ignore:
Timestamp:
Jan 20, 2011, 7:45:25 PM (13 years ago)
Author:
robe
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • UsersWikiplpgsqlfunctions

    v22 v23  
    6262
    6363* '''Convert degree minutes seconds to long lat decimals '''
     64
    6465This is from Simon Greener's article [http://www.spatialdbadvisor.com/postgis_tips_tricks/115/dms2dd-for-postgis/ DMS2DD for PostGIS]
    65 and was an adaptation of his Oracle function described in [http://www.spatialdbadvisor.com/oracle_spatial_tips_tricks/114/converting-google-earth-formatted-longitude-latitude-points-to-decimal-degrees Converting Google Earth Formatted Longitude/Latitude points to decimal degrees]
     66
     67and was an adaptation of his Oracle function described in
     68[http://www.spatialdbadvisor.com/oracle_spatial_tips_tricks/114/converting-google-earth-formatted-longitude-latitude-points-to-decimal-degrees Converting Google Earth Formatted Longitude/Latitude points to decimal degrees]
     69Example use:
    6670{{{
    6771CREATE OR REPLACE FUNCTION DMS2DD(strDegMinSec varchar)