Skip to content

Latest commit

 

History

History
41 lines (28 loc) · 1.24 KB

readme.md

File metadata and controls

41 lines (28 loc) · 1.24 KB
Raw

CodeIgniter Haversine Model

CodeIgniter Model implementing the haversine formula, giving great-circle distances between two points on a sphere from their longitudes and latitudes.

Installation

Just drop this model into your application/models folder (download or git)

Usage

Load the Model

$this->load->model('haversine');

Define the Table Name

$this->haversine->table_name = 'locations';

Run the "Spatial" query

$locations = $this->haversine->closest(36, -80); //lat, lng

Extra Params

Maximum Distance

$locations = $this->haversine->closest(36, -80, 25); //25 Miles

Maximum Locations

$locations = $this->haversine->closest(36, -80, 25, 10); //10 Locations

Define the Units of Measurement

$locations = $this->haversine->closest(36, -80, 25, 10, 'miles'); //miles or kilometers

Define what fields you would like back

$locations = $this->haversine->closest(36, -80, 25, 10, 'miles', array('id, name')); //false for * or single dim array

TODO

  • More units of measurement (feet, meters)
  • Support joins (ie join company meta to a store locations table)
  • Change direction of result
  • Put units param right after longitude
  • Refractor into a more general GIS model?

NOTES

  • Only tested on MySQL