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
– Deenadhayalan Manoharan

2015-02-21 11:54:55 +00:00
Commented Feb 21, 2015 at 11:54 — Deenadhayalan Manoharan
– Deenadhayalan Manoharan, Commented Feb 21, 2015 at 11:54
I edited my question with the table ,,

Mahmoud Nassar
– Mahmoud Nassar

2015-02-21 12:03:49 +00:00
Commented Feb 21, 2015 at 12:03 — Mahmoud Nassar
– Mahmoud Nassar, Commented Feb 21, 2015 at 12:03

Community · Accepted Answer · 2017-05-23 12:10:17Z

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, 2017 at 12:10

CommunityBot

11 silver badge

answered Sep 16, 2015 at 22:02

Nishant Jani

1,9918 gold badges30 silver badges41 bronze badges

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

1 Comment

Refilon Over a year ago

As a side note. I got the error GeomFromText does not exist. So I had to change it to ST_GeomFromText

Collectives™ on Stack Overflow

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

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related