Is there a fast, persistent database for storing a latitude, longitude, and integer value for quick geo-spacial lookups?
The idea is that I have lots of ID's of different things and I want to search by lat/lon squares for all the ID's in a given location.
My first thought was the creative use of key-value store like membase or redis. However, I can't figure out a method to search based on properties like latitude and longitude short of creating set sized lat/lon blocks and placing all ids as the value (which doesn't work very well).
