Friday, May 16, 2008



MADEIRA GPS, a company that started in 2005, with a simple project in mind: Deliver PDA-based navigation, with autorouting, for Madeira Island's tourism. We've achieved that goal and more... Since then our company evolved to provide full fleet management solutions and is currently making business as far as Brasil. All thanks to PostgreSQL and, of course, PostGIS.

All our geographic data (maps) is stored with PostGIS and it serves hundreds of requests per minute providing street name resolution for vehicles locations.

We used OpenJump as our preferred application to edit our geo-data. This application, combined with the PostGIS plugin, capable of reading/writing to/fro PgSQL DBs, proved to be a 'killer' combination.

Why did we choose PostGIS? Simple enough:


GlobeXplorer provides web services access to satellite and aerial imagery over the internet. GlobeXplorer manages relationships with dozens of source imagery providers and then provides simple web access to a multi-terrabyte unified collection of images.

GlobeXplorer clients range from individual end-users with Web Map Server (WMS) clients to consumer-oriented web portals serving millions of hits a day. This high-load, high-volume environment requires a very reliable technical solution that scales up efficiently to support millions of requests per day.

The GlobeXplorer (GX) architecture does not store imagery inside the database itself, but uses the database to store metadata about available imagery. The GX middleware handles incoming image requests by first querying the database to determine image availability, then retrieving the actual images from storage and delivers them to the client. So, each image request generates one or more database hits on the database metadata.