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.


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.