Thread: GPS coordinates problem
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
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
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