0
votes
1answer
37 views

Getting fail to store Polygon Shape Object in Geometry Datatype with hibernate spatial API

Tried to store Polygon shape in database with HibernateSpatial API. I have followed this tutorial to store values. I am using Mysql as my database server. So Made some couple of changes for my ...
1
vote
1answer
60 views

is MySQL spatial ready for production?

currently I'm using PostgreSQL/PostGIS for a small spatial project. Last week the project manager asked me if we could migrate to MySQL with Spatial Extension. I know MySQL but have no experience ...
1
vote
2answers
101 views

Connect AutoCAD Map 3D 2014 with MySQL

I need to connect AutoCAD Map 3D 2014 with an Spatial MySQL database (version 5.5) but first I have to install "libmysql.dll" to connect as specified in the software user's manual. This file is ...
0
votes
1answer
307 views

How to find points inside each polygon in Mysql?

I have points table (with latitude and longitude columns) and polygons table with geometry stored in Mysql. I want to get points inside one polygon, for example in polygon which has column ...
0
votes
0answers
486 views

Convert a decimal degree to meters from the MySQL Spatial GLength

The MySQL Spatial function GLength returns the distance between two points, this distance is in the same unit from the projection. Since I'm using the WGS84 (SRID:4326) the answer will be with ...
1
vote
0answers
258 views

Check if a point is near a linestring with MySQL Spatial Extension (untrustable)

I have to discover if a given point is at least 500 meters (ou other distance) from a route line that exist in my database recorded using the MySQL Spatial. I see there is no similar function in ...
1
vote
0answers
58 views

Solve Mysql Spatial error

Converting shp2mysql will leads an null value in geom filed. how to rectify the the problem. shp2mysql -s 32643 landuse landuse LIS >landuse.sql
3
votes
1answer
502 views

Does MySQL only support bounding boxes calculations instead of the real polygon geometry?

Within our company we are deciding which DBMS we will use to store spatial data. IT wants MySQL with the Spatial extension because there is already knowledge about handling MySQL DB. We are doing ...
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 ...
2
votes
1answer
494 views

How to speed up this simple MySQL points in the box query

MySQL doesn't have nearest neighbor search so. So I try to come up with a "distance" that's reasonable so the number of returned query is around 20-200. That way innodb doesn't have to compute ...
0
votes
0answers
246 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 ...
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 ...
7
votes
3answers
3k views

Poor Performance when using Spatial Indexes in MySQL

Re-post of a question asked on Stack Overflow when it was suggested this would be a better forum. I'm trying a little experiment at pushing a data set which is not geo-spatial but fits it quite well ...
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 ...