Just as a hint for implementation:
1) MySQL allows REGEX searches - perhaps this helps ! 2) You can also HAVE REGEXes AS table entries, which is a very, very, very interesting feature not everybody knows of. Both could help for storing or finding coordinates.
Tom
Brion Vibber schrieb:
Egil Kvaleberg wrote:
Following up my previous mail, I've removed the gis_region column, and instead added a gis_globe column, so that it is easy to make this work in other worlds too, e.g. "Moon", "Mars" and I guess, "Sky" for the star maps.
Neat! :)
CREATE TABLE wikipedia_gis ( gis_id int(8) unsigned NOT NULL, gis_latitude_min real NOT NULL,