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.
Also, but anyone could take time to look at my other questions, that would be really, really apprecieated. To summarize:
How to make addition of this table possible without shell access via the maintenance module?
Should the table use article ID or title as key?
How to rerieve article title based on ID in a portable manner?
Any chance to test this extension on a broader scale?
Regards, en:User:Egil