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

learn more… | top users | synonyms

2
votes
1answer
660 views

MySQL GeoSpatial function for ST_Distance_Spheroid? Metric used in return Type of GLength?

Is there a ST_Distance_Sphere, ST_Distance_Spheroid equivalent function in MySQL's GeoSpatial Support? If not, any way to emulate this? What is the metric used in return type of ...
7
votes
3answers
2k views

how to find 20 closest points efficiently

Say I want to find 20 closest business near me. My table structure is like this: BusinessID varchar(250) utf8_unicode_ci No None Browse distinct values Change Drop ...
3
votes
1answer
3k views

Establishing a MySQL connection in ArcGIS 10

Is it possible to create a connection to a MySQL database in ArcGIS 10?
0
votes
0answers
245 views

MySQL SQL command to find points within a rectangle with spatial extension and index [duplicate]

Possible Duplicate: how to find 20 closest points efficiently How to find points, sort them based on closeness, and get 1-20, 21-40, etc. Efficiently using Myisam and mysql Actually I ...
0
votes
1answer
378 views

shp2MySQL GIS Import Coordinates Not Correct

I'm attempting to import the Chicago Neighborhood Boundaries into a MySQL database from the shape files available at ...
2
votes
2answers
417 views

Map Coordinates to Neighborhoods from MySQL Table

I have a MySQL database with a set of coordinates and a shape file (Zillow Neighborhood Database for Chicago) containing the boundaries for each neighborhood which I have converted to a spatial ...
2
votes
3answers
833 views

Accessing coordinates of polygon

I have designed a polygon in a web page and the coordinates are stored in the database of the type polygon. However when I check the database, I find GEOMETRY - 120B under polygon field. What does ...
1
vote
1answer
300 views

Calculate MBR envelope for different geometry shapes in different rows

I have some different kinds of geometry (Polygons and line strings) stored in my mysql database. On different rows. I know I can retrieve the envelope of one row with: SELECT Envelope(zoneShape) FROM ...
0
votes
1answer
931 views

Adding MySQL to Geoserver for Non-Spatial Data

I need to connect to a MySql table, which has all the attribute values and the lat & long. I am using a GeoServer Suite to host my raster and so felt the best way to go about it would be to add ...
1
vote
0answers
111 views

refactoring an XSLT processor with minor changes

having an extremely large xml-file - which is derived from the field of geo informatics. i got it from a German subsite or the OpenStreetMap-Project: the Geograpical-Engineering-site that deilvers a ...
2
votes
1answer
2k views

How to add polygon in MySQL database

I have a table which contains an field zoneShape of the type Polygon. When inserting some geometry in this field, in phpmyadmin it says: affected 1 row. The row is added, but the geometry field says ...
0
votes
1answer
393 views

MySQL: Query the envelope (mbr, extents) of a spatial table?

this question provides a solution to get the evelope (aka: mbr, aka: extents) of a spatial table in PostGIS, but I'm having trouble doing the same in MySQL. The ogr MySQL driver does this, and a ...
1
vote
3answers
1k views

Android GIS - Reverse Geocode using Shapefile (.shp)

I want to develop an Android application. I'm still a newbie here. What I want is to develop my app just like a GIS that can implement reverse geocoding. So I can put in lat / lon coordinates and ...
2
votes
2answers
745 views

MySQL Query to fetch all cities and POI's near the route

I'm implementing alghorithm to search POI near the route (array of Lat, Long points). My problem is that I don't know how to calculate distance beetween line segment and POI. Look at picture that I ...
20
votes
4answers
2k views

Would PostGIS offer an advantage over MySQL for a produce farm application?

I have a web app that stores the locations of farms in West Michigan. You can search for a product (e.g. "broccoli") and it will show you all the farms that grow that product. Right now I'm using ...
0
votes
6answers
2k views

Is it possible to query a MySQL database using the results from map.getBounds() with Google Maps API v3?

I have a MySQL database that contains a large number of polygons, one for each district on a map. They are all quite complicated and it's unrealistic to simply load them all at once. I've looked into ...
10
votes
2answers
6k 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
480 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 ...
4
votes
1answer
738 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
920 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. ...