Laravel with PostgreSQL and Postgis point

Question

I develop an application which allows to post(show) a list of restaurants according to the location(localization) of the user.

For that purpose, I have a base(basis) of datum containing bars with their latitudes-longitudes.

My database is under postgresql and I would like to use, all my back-service(back-office) is under Laravel. At present to add a POINT, I make: ST_GeogFromText('SRID=4326;(110 30)'), but on Laravel, the request SQL ( db:seed ) includes the ST_ guillement enter.

DB::table('establishments')->insert(['location' =>ST_GeogFromText(\'SRID=4326;POINT(-110 30)\'),]), but ST_GeogFromText is not a fonction -- The error message:

parse error - invalid geometry HINT: "ST"

How may I make to manage PostgreSQL-Postgis and Laravel?

Have you tried ST_GeogFromText('SRID=4326;POINT(110 30)');? — Jim Jones
– Jim Jones, Commented May 18, 2018 at 13:40
I didn't quite get the issue here. Are you unable to add points to your db? If so, can you elaborate a bit more on the procedure and the error message? — Jim Jones
– Jim Jones, Commented May 18, 2018 at 13:42
I try to add an entity in my db with Laravel seeding, so i make DB::table('establishments')->insert(['location' => ST_GeogFromText(\'SRID=4326;POINT(-110 30)\'),]), but ST_GeogFromText is not a fonction -- The error message are : parse error - invalid geometry HINT: "ST" — Dubleyu
– Dubleyu, Commented May 18, 2018 at 13:52
Just to make it clearer: you're sure that the PostGIS extension is installed in your database, right? — Jim Jones
– Jim Jones, Commented May 18, 2018 at 13:58

Adrian Mole · Accepted Answer · 2020-12-02 16:41:09Z

1

ST_GeogFromText is a PostGIS function not a PHP/Laravel function, and you cannot wrap it in quotes (i.e. ""), as Laravel will then consider it a string.

Instead, pass a raw query expression like below:

DB::table('establishments')->insert([
    'location' => DB::raw("ST_GeogFromText('SRID=4326;POINT(-110 30)')"),
    // your other columns & values
]);

edited Dec 2, 2020 at 16:41

Adrian Mole

52.2k193 gold badges61 silver badges101 bronze badges

answered Dec 2, 2020 at 15:58

sai_ekkaldevi

1131 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Laravel with PostgreSQL and Postgis point

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related