We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

Protecting the Planet with Postgis: How we are calculating complex protected area coverage statistics for all countries in the world.

Formal Metadata

Title
Protecting the Planet with Postgis: How we are calculating complex protected area coverage statistics for all countries in the world.
Title of Series
Number of Parts
183
Author
License
CC Attribution - NonCommercial - ShareAlike 3.0 Germany:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal and non-commercial purpose as long as the work is attributed to the author in the manner specified by the author or licensor and the work or content is shared also in adapted form only under the conditions of this
Identifiers
Publisher
Release Date
Language
Producer
Production Year2015
Production PlaceSeoul, South Korea

Content Metadata

Subject Area
Genre
Abstract
ProtectedPlanet.net is the online interface for the World Database on Protected Areas (WDPA), a joint project of IUCN and UNEP, and the most comprehensive global database on terrestrial and marine protected areas. The WDPA is released every month and consists of a point and polygon dataset of over 210 000 entries. Over 91% of this data is in polygon format and the remaining 8% are points that can have an area as attribute. Displaying protected area coverage statistics is one of the main features of this website. It is very important for the users to know what percentage of the territory is covered by protected areas in a given country, region or the entire planet. Previously, these statistics were calculated manually and every year a team spends several days calculating them for a report using ESRI Software. We had a great challenge this time: Can we automatically calculate the statistics every month for all the protected areas and countries in the entire planet? In this case time matters: if we want to calculate statistics every month, it can't take 2 or 3 days of processing. To work through this, we chose a full open source solution with PostGIS to do all the back end tasks that we need to calculate statistics. We were able to limit all this to 6 hours and we can now run automatically every month keeping coverage statistics up to date.