GPS coordinates problem

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

GPS coordinates problem

Timmy Siu
Dear All Postgre Users,

I want to develop a new project on Lavarel 5 and Postgresql 11.

Now, I need Global Position System coordinates as a data type. How do I
define it in Postgresql 11 or 12?


Thanks for your help.

Timmy



Reply | Threaded
Open this post in threaded view
|

Re: GPS coordinates problem

Andreas Kretschmer-3


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



rob
Reply | Threaded
Open this post in threaded view
|

Re: GPS coordinates problem

rob
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 <[hidden email]> 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