Requests for comment/Native geospatial data types

Jump to navigation Jump to search
Request for comment (RFC)
Native geospatial data types
Component General
Creation date 2014-02-18
Author(s) Jnatividad
Document status in draft


The GeoData extension is deployed in mediawiki sites and its API is widely used by the community to hyperlocalize knowledge. It currently stores geospatial data using int/float MySQL datatypes, rather than native spatial data types.

Proposal (in general)[edit]

  • GeoData as it is, already requires MySQL 5. MySQL 5 supports spatial datatypes anyway, why not use them instead?
  • Using spatial datatypes will allow us to take advantage of more advanced spatial functions (e.g. within, touches, etc.)
  • A lot of knowledge stored in mediawikis are geospatial by nature.