| Speakers | |
|---|---|
|
George James |
| Schedule | |
| Day | Sunday |
| Room | AW1.120 |
| Start time | 15:00 |
| End time | 15:30 |
| Duration | 00:30 |
| Info | |
| Event type | Podium |
| Track | NoSQL |
| Language | English |
OpenStreetMap is a collaborative mapping project inspired by Wikipedia. The heart of OpenStreetMap is its geo-data. All geographic elements are described using a simple database structure and free-form tagging. A road may be described by tagging it as highway=motorway, a hospital by amenity=hospital, a lake by landuse=water, etc.
The main database uses PostgreSQL and is accessed exclusively through a REST based API. It receives continuous updates from a 30,000 strong community of users. Consequently, in order to maintain acceptable performance, queries on the database are restricted to simple rectangular areas of no more than 0.25 square degrees.
The challenge was to mirror this database and provide an API that permitted queries on larger areas and provided extended query capabilities, such as the ability to find hospitals or fire stations or bars. We chose GT.M because of it's a high performance schema-free database that would handle key/value pairs economically and scale well to accommodate the continuous growth of the data.