Easily add longitude and latitude columns to your records and use inherited functionality for calculating distances
gleman17/laravel-geographical is a Laravel package for easily add longitude and latitude columns to your records and use inherited functionality for calculating distances.
It currently has 0 GitHub stars and 55 downloads on Packagist (latest version 1.0.4).
Install it with composer require gleman17/laravel-geographical.
Discover more Laravel packages by gleman17
or browse all Laravel packages to compare alternatives.
Last updated
Easily add longitude and latitude columns to your records and use inherited functionality for calculating distances.
First either update your database or add this to a migration for each model:
$table->double('longitude');
$table->double('latitude');
Finally in your model use:
use Geographical;
Find the distance to all the entries in your table from a particular location.
$query = Model::distance($latitude, $longitude);
$asc = $query->orderBy('distance', 'ASC')->get();
Find all the entries in your table inside a circular geo-fence.
$query = Model::geofence($latitude, $longitude, $inner_radius, $outer_radius);
$all = $query->get();
The default unit of distance is miles. You can change it to kilometers by putting this in your model
protected static $kilometers = true;
Eloquent\Builder object so that you can add optional conditions if you want.select().
Model::select('id', 'name')->distance($latitude, $longitude);
(select() should precede the distance()/geofence())distance as an aggregate column in the result.
(Aggregate columns cannot be used in WHERE, use HAVING to execute any condition.)const LATITUDE = 'lat';
const LONGITUDE = 'lng';
PHP 5.6.4+ and Laravel 5+ are required.
To get the latest version of Laravel Geographical, simply require the project using Composer:
$ composer require malhal/laravel-geographical