MySQL · Web Development

MySQL GIS Extension & HaverSine Geo-Spatial Search

MySQL Stored Procedure

[link]

GIS Model

[link]

Database Table

[link]

Search Query & Caller Function

[link]

References:

    1 – http://howto-use-mysql-spatial-ext.blogspot.com.eg/
    2 – https://www.percona.com/blog/2013/10/21/using-the-new-mysql-spatial-functions-5-6-for-geo-enabled-applications/
    3 – http://markmaunder.com/2009/10/10/mysql-gis-extensions-quick-start/
    4 – ftp://ftp.ntu.edu.tw/tmp/MySQL/tech-resources/articles/4.1/gis-with-mysql.html
    5 – https://developers.google.com/maps/articles/phpsqlsearch_v3?csw=1
    6 – http://www.longitudestore.com/haversine-formula.html
    7 – http://blog.jcole.us/2007/11/24/on-efficiently-geo-referencing-ips-with-maxmind-geoip-and-mysql-gis/
    8 – https://github.com/sjaakp/yii2-spatial
    9 – https://github.com/UncleCoder/yii-spatialdata-behavior
    10 – http://www.plumislandmedia.net/mysql/stored-function-haversine-distance-computation/
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s