Egil Kvaleberg wrote:
Egil Kvaleberg wrote:
I have now included support for the geo database, and included support for finding neighboring articles as well as support for generating points for Wikimaps.
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.
The definition then becomes:
CREATE TABLE wikipedia_gis ( gis_id int(8) unsigned NOT NULL, gis_latitude_min real NOT NULL, gis_latitude_max real NOT NULL, gis_longitude_min real NOT NULL, gis_longitude_max real NOT NULL, gis_globe char(12) binary, gis_type char(12) binary, gis_type_arg char(12) binary,
KEY gis_id (gis_id), INDEX gis_latitude_min (gis_latitude_min), INDEX gis_latitude_max (gis_latitude_max), INDEX gis_longitude_min (gis_longitude_min), INDEX gis_longitude_max (gis_longitude_max));
where gis_globe is NULL for Earth.
Again, comments very much invited.
You've missed adding a field for storing the geodetic reference (for example, WGS 84), which is particularly important for high-precision measurements. Some kind of height field would be good too (again, the nature of the height field would be defined by the geodetic reference).
-- Neil