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