How to insert [Spatial Point] values with a query in MySQL in Laravel

Question

I have a table with a column of type Spatial point ,,

I want the query to insert the values of that column with laravel

and if there a queries to get items within a specific range ?

any help here ??

That's my table here :

public function up()
{
    Schema::create('markers', function(Blueprint $table)
    {
        $table->integer('marker_id')->primary();
        $table->string('marker_name', 45);
        $table->timestamp('created_at')->default(DB::raw('CURRENT_TIMESTAMP'));
    });
    DB::raw("ALTER TABLE markers ADD COLUMN location POINT");
}

insert single value?post your table and code – Deenadhayalan Manoharan Feb 21 '15 at 11:54 — Deenadhayalan Manoharan, Feb 21 '15 at 11:54
I edited my question with the table ,, – Mahmoud Nassar Feb 21 '15 at 12:03 — Mahmoud Nassar, Feb 21 '15 at 12:03

score 11 · Accepted Answer · edited May 23 '17 at 12:10

11

You can insert data as follows:

ModelName::firstOrCreate(
    array(
        ..//other fields
        'location' => DB::raw("(GeomFromText('POINT(37.774929 -122.419415)'))")
    )
);

To retrieve data:

SELECT X(`location`), Y(`location`) FROM markers;

I too was stuck here & got help from: Spatial Point functions using Laravel Eloquent ORM. Hope this helps.

edited May 23 '17 at 12:10

Community

1
1

answered Sep 16 '15 at 22:02

Nishant Jani

1,965
8
30
41

As a side note. I got the error `GeomFromText does not exist`. So I had to change it to `ST_GeomFromText` – Refilon Mar 08 '22 at 14:43

How to insert [Spatial Point] values with a query in MySQL in Laravel

1 Answers1