MySQL is an open-source, relational database management system. Place you question on MySQL Spatial Extensions here.

learn more… | top users | synonyms

10
votes
2answers
9k views

Data types for storing lng/lat in MySQL

I'm storing a large list of lnt/lat points in a MySQL database. At the moment these are projected points for the UK in M, but in the long term I would like to make sure that I can store the ...
6
votes
2answers
527 views

Comparing TIGERLine 2006 (and prior) With New Shapefile Format

I have created a geo database using MySQL and the TIGERLine data files available from the US Census. This is actually an MSSQL database I created that I've transfered to MySQL. Everything works ...
5
votes
1answer
904 views

Best GeoDjango MySQL workaround for distance queries

I'm using mysql 5.1.50, so the distance QuerySet method is not available to me. Here is my model: class Location(models.Model): name = models.CharField(max_length='100') point = ...
3
votes
1answer
1k views

Loading Tiger 2010 Edge Shape File w/ ogr2ogr Produces Reversed Latitude and Longitude

I'm attempting to build a MySQL database that will allow me to reverse geo-code addresses using the MBR functions within MySQL. I've downloaded the latest set (2010) of TIGER edge shape files from ...
2
votes
1answer
2k views

How to calculate distance between two locations using stored procedure in MySQL?

I have a database with locations with its lat and long coordinates. The area of locations is quite small with lots of them quite near each other. Im using this stored procedure in my project. ...