Mysql Geospatial point DB

Question

Im looking for a geospatial db which can search lat and long in seconds and point me to a point id. I'm new working with geopspatial db's. Can anyone recommend? or point me in a direction?

Are you looking at custom data or do you require full spatial functions available? A simple table of distinct lon/lat points is a very real solution with immediate indexing. — Jé Queue
– Jé Queue, Commented Feb 17, 2011 at 5:07

Zimbabao · Accepted Answer · 2011-02-17 10:35:08Z

2

For spatial search you can try Lucene/Solr spatial search. Store data in mysql and build the index in solr.

MyIASM table support spatial indexes in MySql, have a look at the documentation

answered Feb 17, 2011 at 10:35

Zimbabao

8,2803 gold badges32 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Adam Hopkinson · Accepted Answer · 2012-10-15 13:35:08Z

1

I use MySQL. All the freeness and familiarity, now with spatial functions. This is from wikipedia:

MySQL DBMS implements the datatype geometry plus some spatial functions that haven't been implemented according to the OpenGIS specifications. Functions that test spatial relationships are limited to working with minimum bounding rectangles rather than the actual geometries. MySQL versions earlier than 5.0.16 only supported spatial data in MyISAM tables. As of MySQL 5.0.16, InnoDB, NDB, BDB, and ARCHIVE also support spatial features.

edited Oct 15, 2012 at 13:35

Adam Hopkinson

28.8k9 gold badges74 silver badges105 bronze badges

answered Feb 17, 2011 at 4:16

dmgig

4,5785 gold badges40 silver badges50 bronze badges

Collectives™ on Stack Overflow

Mysql Geospatial point DB

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related