This question already has an answer here:

Creating a geometry in Postgis is fairly simple:


These lat/lon should be in decimal degrees format like 33.02505 -96.70668

Is there a way/function to enter them in the degrees and decimal minutes format provided by NMEA $GPRMC sentences like 3301.5032 09642.4010?

Of course you can convert them in php or nodejs; but it would be easier (faster) to have it natively in Postgis.

marked as duplicate by PolyGeo, Paul, Fezter, BradHards, mkennedy Apr 20 '14 at 15:41

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.


Here is a user contributed PostGIS function called dms2dd. Your data however looks like Degree, decimal Minutes. You may need to modify the function to suite your needs. functions

Not the answer you're looking for? Browse other questions tagged or ask your own question.