MySQL Forums
Forum List  »  GIS

MySQL and GIS, GeoIP: FAQs, How-To, Articles, Blogs
Posted by: Edwin DeSouza
Date: November 24, 2007 06:04PM

MySQL GIS docs:
http://dev.mysql.com/doc/refman/5.1/en/spatial-extensions.html

MySQL GIS preview builds:
http://forge.mysql.com/wiki/GIS_Functions

MySQL GIS: Geo-Spatial Search with MySQL
http://www.scribd.com/doc/2569355/Geo-Distance-Search-with-MySQL

MySQL GIS: Presentations
http://assets.en.oreilly.com/1/event/21/Spatial%20SQL_%20Who%20Needs%20a%20Traditional%20GIS_%20Presentation%201.zip
http://en.oreilly.com/mysql2010/public/schedule/detail/13455

MySQl UDF: GIS functions distance_sphere() and distance_spheroid()
http://www.lenzg.net/archives/220-New-UDF-for-MySQL-5.1-provides-GIS-functions-distance_sphere-and-distance_spheroid.html
http://forge.mysql.com/projects/project.php?id=296
http://okilab.jp/blog/2008/07/distance_sphere_distance_spher.html
http://okilab.jp/blog/2008/08/the_documentation_of_udf_dista.html
http://www.osgeo.jp/wordpress/wp-content/uploads/2008/11/foss4g2008_okumura.pdf

MySQL GIS: Benchmarks
http://pento.net/2009/05/18/mysql-and-geospatial-data/

MySQL GIS: Quick Start
http://markmaunder.com/2009/mysql-gis-extensions-quick-start/

MySQL GIS: Review
http://www.mysqlfanboy.com/2010/08/mysql-gis-part-1/
http://www.mysqlfanboy.com/2010/08/mysql-gis-part-2/
http://www.mysqlfanboy.com/2010/08/mysql-gis-part-3/
http://www.mysqlfanboy.com/2010/09/mysql-gis-part-4/
http://www.mysqlfanboy.com/2010/09/mysql-gis-part-5/
http://www.mysqlfanboy.com/2010/09/mysql-gis-part-6/


How To: Storing and retrieving spatial data on MySQL server with Connector/Net
https://blogs.oracle.com/MySqlOnWindows/entry/howto_storing_and_retrieving_spatial


Implementing efficient Geo IP location system in MySQL
http://www.dbasquare.com/2012/06/01/implementing-efficient-geo-ip-location-system-in-mysql/

Calculating Distance Between Points In MySQL
http://maisonbisson.com/blog/post/12146/calculating-distance-between-points-in-mysql/

Working With Spatial Data in MySQL
http://maisonbisson.com/blog/post/12147/working-with-spatial-data-in-mysql/

WL#1326: GIS: Precise spatial operations
http://forge.mysql.com/worklog/task.php?id=1326

MySQL GIS: Using Circular Area Selection
http://howto-use-mysql-spatial-ext.blogspot.com/

MySQL GIS: Reverse Geocoding
http://gtowey.blogspot.com/2009/05/reverse-geocoding-using-mysql-gis.html

IP Address Geolocation From MySQL
http://www.howtoforge.com/ip-address-geolocation-from-a-mysql-database

MySQL: finding a user’s country/region based on IP
http://code.openark.org/blog/mysql/sql-finding-a-users-countryregion-based-on-ip

GeoTargeting How-To:
http://ekstreme.com/geotargeting/ip-database-setup.php
http://ekstreme.com/geotargeting/geotargeting-php-code.php
http://ekstreme.com/geotargeting/flags-comments.php

On efficiently geo-referencing IPs with MaxMind GeoIP and MySQL GIS:
http://jcole.us/blog/archives/2007/11/24/on-efficiently-geo-referencing-ips-with-maxmind-geoip-and-mysql-gis/

HOW-TO Import the MaxMind GeoIP Free Country CSV file into MySQL and save diskspace:
http://vincent.delau.net/php/geoip.html

MaxMind GeoIP install setup tutorial using PHPMyAdmin:
http://bartomedia.blogspot.com/2007/11/maxmind-geoip-setup-tutorial-using.html

Loads MaxMind GeoIP Country data into a MySQL database:
http://www.kelvinwong.ca/code/sql/maxmind_importers/mygeoipcountry.sql

Mapping visitors' IP addresses to their country with MaxMind GeoIP:
http://articles.techrepublic.com.com/5100-22_11-5226901.html

MaxMind GeoIP databases:
http://www.maxmind.com/app/ip-location
http://www.maxmind.com/app/geolitecountry (FREE)
http://forum.maxmind.com/

IPinfoDB: IP address geolocation SQL database (FREE)
http://ipinfodb.com/ip_database.php

lib_mysqludf_fPROJ4
This library is based on program PROJ.4 which is a standard Unix filter function which converts geographic longitude and latitude coordinates into cartesian coordinates, by means of a wide variety of cartographic projection functions.
http://www.mysqludf.org/lib_mysqludf_fPROJ4/index.php

Wikipedia:
http://en.wikipedia.org/wiki/Latitude
http://en.wikipedia.org/wiki/Longitude
http://en.wikipedia.org/wiki/Geographical_distance



Edited 17 time(s). Last edit at 04/17/2013 10:40AM by Edwin Desouza.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL and GIS, GeoIP: FAQs, How-To, Articles, Blogs
49372
November 24, 2007 06:04PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.