Re: GPS coordinates problem - Mailing list pgsql-general

From Robert Heinen
Subject Re: GPS coordinates problem
Date
Msg-id CAKQp+O=0=-HsLTiLNuKtpRaRfVj5dKp59g6z9qfM1FxwujhW9w@mail.gmail.com
Whole thread Raw
In response to Re: GPS coordinates problem  (Andreas Kretschmer <andreas@a-kretschmer.de>)
List pgsql-general
You can use the postgis extension:

create extension postgis;

Then you can create a geography coulmn

location geography( point, 4326) 

and insert a lat /long as a point like this:
ST_GeographyFromText('SRID=4326;POINT(%(longitude)s %(latitude)s)'),





On Tue, Oct 8, 2019 at 1:30 PM Andreas Kretschmer <andreas@a-kretschmer.de> wrote:


Am 08.10.19 um 12:50 schrieb Timmy Siu:
> Now, I need Global Position System coordinates as a data type. How do
> I define it in Postgresql 11 or 12?

consider PostGIS.


Regards, Andreas

--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com



pgsql-general by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: GPS coordinates problem
Next
From: Shatamjeev Dewan
Date:
Subject: RE: Declarative Range Partitioning Postgres 11