laravel-mysql-spatial
laravel-mysql-spatial copied to clipboard
grimzy
MySQL Spatial Data Extension integration with Laravel.
Hello there, I wanted to know if there is a method within this package that calculates the distance of a stored polyline. Say for instance I have a route object...
- Library: 2.2.3 - Laravel: 7.x - Mysql 5.7 When I tried to execute this command to get data using Laravel and version 2.2;3 ``` DeliveryPoint::distanceSphereValue($geometryColumn, $geometry) ->distanceSphere($geometryColumn, $geometry, $distance)...
Point toString return lng lat, I think the correct order is lat, lng Wrong: `public function __toString() { return $this->getLng().' '.$this->getLat(); }` Correct: `public function __toString() { return $this->getLat().' '.$this->getLng();...
I've created a point type field in my DB on a `location` model, I can set its value explicitly by creating a `Point` instance as per the examples, but what...
Resolving issue #91 Added an optional `radius` input for spherical functions and fixed the default radius of the earth. Made some annotations and phpdoc.
As I point out in https://github.com/grimzy/laravel-mysql-spatial/issues/77, `distanceSphereValue` does not currently allow a 3rd `distance` parameter like `distanceSphere` does So if I want to get all cities within a 50km radius,...
Hi, I'm working with Laravel 7, php 7.4 and MySQL 5.7 I have a problem with Geometry::fromJson and a GeometryCollection Feature (single). I have a column `geo_data` of type `geometry`...
This avoids that most spatial query functions fail when invoked from observer methods. E.g. Test setup $incomingMessage = new RawMessage(); $incomingMessage->beacon_id = $boat->beacon_id; $incomingMessage->boat_id = $boat->id; $incomingMessage->timestamp = CarbonImmutable::now(); $incomingMessage->type...
It is adding a parameter for spherical functions for radius, annotates SpatialTrait with PHPDoc blocks, and defaults the earth radius to a more accurate median (down to cm). It references...
Since MySQL doesn't allow spatial indexes on nullable POINT type columns (and it also doesn't allow setting default value for POINT type columns), it would be handy if there is...
