point is in polygon

[mohammad6006]

I create places table with name and location column
but location is not point
its polygon and i store polygon of a places in table

now how can i check the point is on which column

I try :

$s9 = new Point(38.021996, 46.3799);
$spaa = Place::find(3);
$spac = $spaa->location;
$result=$spac->contains('location',$s9);

but not work

[grimzy]

Can you please provide the values of $spac and $result?

Also, note that when performing $spac->contains(), the package internally uses ST_Contains().

[grimzy]

Closing due to inactivity.

[menkaff]

it is also not work for me
i try :
` $place = new Neighborhood();
$place->name = 'Empire State Building';
$place->city_id = 296;

    $place->geometry = new Polygon([new LineString([
        new Point(40.74894149554006, -73.98615270853043),
        new Point(40.74848633046773, -73.98648262023926),
        new Point(40.747925497790725, -73.9851602911949),
        new Point(40.74837050671544, -73.98482501506805),
        new Point(40.74894149554006, -73.98615270853043)
    ])]);`

$place->save();

and query a point inside polygon with contains or within functions

$point = new Point(40.7489415 , -73.9861527);

$neighborhood = Neighborhood::contains('geometry', $point)->first();
and returns nothing

[vahidalvandi]

please correct this

You can't call it as a static method

        $point = new Point($location['lat'], $location['lng']);

        $z = new Zone;
        $zones = $z->contains('area', $point)
            ->get();

        dd(count($zones)); // 1 in my case