Requests for comment/Native geospatial data types
This page is currently a draft.
|
Native geospatial data types | |
---|---|
Component | General |
Creation date | |
Author(s) | Jnatividad |
Document status | in draft |
Background[edit]
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.