Simple latitude / longitude + integer database?

Question

Is there a fast, permanent database for storing latitude, longitude, and integer values for quick geospatial searches?

The idea is that I have a lot of IDs of different things, and I want to search in the lat / lon squares for the entire ID in a specific place.

My first thought was to creatively use key-value stores such as membase or redis. However, I cannot find a search method based on properties such as latitude and longitude without creating lat / lon sized blocks with the set sizes and putting all identifiers as a value (which doesn't work very well).

Answer 1

What about Spatiallite, geocouch, mongodb with spatial extension or postgis? Do not use MySQL - it does not have most of the spatial functions currently implemented.

Answer 2

I would go for MongoDB. It is simple and has good support for geoinformation indexing and queries in the neighborhood.

http://www.mongodb.org/display/DOCS/Geospatial+Indexing#GeospatialIndexing-Querying