Changes between Version 22 and Version 23 of UsersWikiplpgsqlfunctions
- Timestamp:
- 01/20/11 19:45:25 (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
UsersWikiplpgsqlfunctions
v22 v23 62 62 63 63 * '''Convert degree minutes seconds to long lat decimals ''' 64 64 65 This 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 67 and 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] 69 Example use: 66 70 {{{ 67 71 CREATE OR REPLACE FUNCTION DMS2DD(strDegMinSec varchar)