hello sorry for the weights my name is ismail torch and watch sports I'm working for you never know with CMC in Cambridge in the United Kingdom and the number is at the end doing a presentation on on 1 of our projects it's called protected planets so this is our office in sunny England's um we have 4 around what 120 people working here um we have several programs working in different areas on biodiversity and basically we our the biodiversity assessment branch of you never United Nations Environment Program so uh we have several people working in protected areas climate change ecosystem assessment and we have also and Informatics team that's where I work as a victim manager and the geospatial developer uh where we creates web products to show to the world of the work that's always scientists do in order to tool to improve the policies around the world and you and policies on on biodiversity so this project

01:31

is called put the planets and basically used showing all protected areas of often work of 2 worlds in 1 websites you can just as a go to this URL and start exploring our prompted the planets

01:49

and this is based on the the World Database on Protected Areas that is a database that is being growing for almost 30 years is a joint work by the IUCN and the and you never and uh and every year there there is a report on this world database on but that the various we also have a means it's being constantly updated we have monthly really is that really is is that you can just Donald pressing here um and we try to gather all the information on but the various in our planet's for each put that in the area we have um a page that shows the maps and uh some some other information like to IUCN Qatari the area if it is a national park if it is just a wreck Regional Park um all the information that we can get from from from we just putting this uh protected area page and then we have our

03:06

data repository so all our Colby no been all our projects we have Web tools Web sites um databases and we we have our were needs have a repositories so everyone can just go there and get the colds and use in in different ways so everything that's we we we have used and that that we produce is now open source um so let's but let's go back to tool to our data sets a and we have a data set that using a file later raised due to legacy issues because these still being in our Informatics program we just work with open source but we still have some other departments on our organization that's you use as re uh we we maybe half using fuel as hot now using open source and open source also open source the best top solutions like you Jews we have several projects running in the country's under development that that we are into the scene q Jews to them but in this specific by case our part at the various program you still managing these in a file geodatabase that 3 we'll not we'll have to convert every month to to our website so we have more than 200 thousand but that the various induced that database 91 per cent of them are have the boundaries defined so we have volumes for them and just 9 per cent of from countries that they don't have their own GAS system they don't have their own uh protected areas in a GIS uh format so we just have a point we its latitude and longitude and some of them they also have areas for them so so 1 way of calculating statistics will be buffering those points according to to that area um and then we we this our reported and there's program does a monthly really is ofthis beta-rays so they content they are in constant contact 3 different countries countries just send them uh in in g formants the the their new protected areas or they the a plate it's the a plate is protected areas and they act and its power at or if if they have removed for that there's with they also removed them so we try to keep these data always updated estimates of course it's difficult because because we have more than 200 countries we which we we work for for so so it's not apparatus dates of a so we have in 1 5 1 department 1 program of our of our organization the protected areas the program may contact countries they at the it's the the database and they create an annual reports which all statistics news for there's still work seen as really software and then we have to informatics websites we just work we open source we built the at the website we create tasks to convert the file database pursues that is the beta ways behind our websites and we try to automate statistics and this is very important so this is what I'm talking about um the team with as with software usually takes that almost a man to create statistics but if we want to have statistics updated every month uh in our website uh we have to to speed up that that process and we are using post choose to go that's the and so our objective is to calculate every month and automatically without any human spending time on that uh calculated territory covered the in each country by protected areas we have also terrestrial and marine protected areas and you we use we must although also you know what what is the area of land covered by protected areas and land of marine areas so exclusive economic zones and territorial seas converted by marine for that the various and then we can have the percentages off uh um off the areas that are covered in each country with that of the various uh we work mainly in rubyonrail so I uh web development framework We the post you've database uh to calculate the statistics we look through all the countries so so we we don't have a script for doing everything we just go cattle up might we country by countries because the process is weaker like to use and we start the geometries in the post West stable and then we we show the data in the website using Ruby on Rails and JavaScript so this is the result for instance for South Korea right this is not the very good for 4 days that was I I the brightness London rejected it but it just frightens this to the right and OK anyway and you can see that Will Smith was there uh and so we have for South Korea the percentage of area that is covered by protected areas that is around 8 for terrestrial around 8 per cent of the various for marine areas it's around 4 per cent we have this kind of results for every country in the world and they are victims every month the so where this is not so easy because many of 2 protected areas are the overlap we we have here and in an exemple in in in Korea so we have 2 different but there is but in fact they are in the same place that this happens why uh because we have a place that can be a world heritage sites but it can also be a national park in Europe for instance you have the Natura 2000 areas that can also be uh regional Park so in some places we have a difference the long hair or land fall in the same place but for protecting it so we can have can put that in there is just overlaps for in the same

10:54

place so this brings 1st some uh a huge challenge because if you want to calculate the area we developed have we we can't go uh just simply copy summing up all the areas in the country we need to to have a flaps datasets just with the area that is covered by put of the various and this is at a challenge in countries like Germany where they just have very small part of their areas but they have files and their sold it it's a really huge geospatial analysis that we need to every month uh 404 countries weeds uh very complex geometries and they're very and very different ways of protecting areas of what of policies that they have the so we have an entire planet like these we have a lot of places covered by part of areas and we need to cope with the statistics for for these the and so firstly the what we need to do is to the all all our in just uh and uh flaps datasets uh we use just at 1 1 most used uh scripts well for the men in the developers here I'll just try to be simple uh so basically I there is some lines of coal there and that that is the basic uh selection for for the getting all the part of the various but what we do is it what it would do is just um developed but that's small sweeping very big great to meet all our requirements so firstly we deserve our book all geometries the for that we need to place by countries so we have a column that saves which country is the the what where is this part of the there the mean which country so we we can just go country-by-country using our rule grid the but we can also to split by type would have marine and we have terrestrial protected areas that you can see that I'm I'm just putting also images of of examples of people of places where we have uh and building the the query we can but we then add need to add . geometries and for these as we just don't have a mn some some some the some polygons we we we use the area to quit buffers and and we have the we add those points geometries as especially in the would with the error buffets we simplify geometries and this is where we save a lot of time so we did is we can just from my 1 month and several days of processing time we just the take a few hours doing these so far countries with which have more protected areas we just uh simplify the geometries in a way that doesn't influence the the overall results so that the margin of error is is smaller than what we show in the in the statistics by age as always simplified the geometries what countries like Great Britain USA Canada uh Germany and Spain New Zealand Poland fetch Republic and so we do that and we also deal with transnational profits various we don't have many but there are several put that in there is that our in 2 countries like the using the United States and Canada but if you want to to to have this that this is for the United States we need to call and use the the country boundaries to get just the the the United States and the can of that area so we also need to deal with this but then we also have some sample that there is now a database that that they are still the proposed Saudi were not reported so this but there there is we we don't use them for calculating statistics and then we have to make the all the geometries valley this isn't marked technical questions so then we we apply play that country's stable with the flat geometries we have a Fletcher datasets for we departed the there the errors but that that's but country and then we calculate the statistics properly so we finish the geospatial stuff there weight with a we have a geom fields on on a post you say well we just the errors that we want and now it's easy is basically uh calculating the area but we we try we converted to mall lights uh same area projections so so it's everything OK and then we wiII from that we get the uh the percentages these this is just uh the circumference here so this is for the United States they have 14 per cent off off very protective off uh um offer land area protective that we need to handle new new null values to so is for China they have 17 per cent of the land area protected and then the we mean certain of stats table all information so this is basically the the on the work that is done on on the screen so my the final remarks is that with open source and we post choose we are uh improving uh the way we work so the work that means usually doing 1 mouth our team we that's really does mean 1 month we can speed up to 6 hours dissolving those the German and simply find geometries so we still do every year for our main report uh the long way and not simply find geometries but for every month we have a the a and every month in just running a script 3 with 6 hours and without needing the need of a human being being they're doing uh compilations an so they're all automatic and we have a full of open source solution I'll show you how this is working the Internet is not too fast here and this the

18:43

submissive this is our website uh and this is all in impose squares all the data that you have here you can free up late to the dataset in in this form of so if you want to use in your own and Jeff desktop software you can you can just download here the you can share check the good the terms and conditions also in the website and for instance if I right yeah uh Philippines as the previous presentation yeah I can just go there and get the

19:31

the information about the protected areas so we may have 51 thousand square kilometers but at the nodes 11 per cent off their land areas but that there's 1 per cent of their marine areas protected so we can just search for your country and and and get cured information on this so thank you very

19:55

much if you have any questions please come back to me if it the the 1st of all it's great warrant and it's great to have a website open source and and the whole dataset this style of downloadable and hasn't seen the terms of use and the data the uh class and no supplies in

20:29

Singapore at this trajectory distribution of the he have 0 I can't just put the yeah it so I can download the data and use it on my

20:40

desktop GIS software but if the modify the data I added our on attribution it's not allowed to republish the on the web so and not you exactly conform to the practice of open data is there are others are there any obstacles to the use of more open license and and and this yes uh so basically uh this is the we don't wait we we get the information some after countries don't want other than commercial use so we need to be always with the country with which has more afraid of giving these data uh around so so we have still dependent on the country's if if it was out of if it was our option we we would put just it's um that just open to 2 so everyone the could use no matter what's what's the the proposes that but uh that that's the issue of the data is sent directly from countries in and they they have some concerns about that anyway you can you can always use that's e-mail if you want to have a different use them then what we have there uh they they are quite weak so tool to reply so we just them an e-mail and then they will see what kind of fuse and if the EER users according to tool to any S people to do the concerns of of other countries um so yes we see we will have it's not the ideal is the ideal solution but that's that's what we can have because there are several countries with different policies on date but I and thank you very much I think I missed the 1st half or so the talk but I I use this dataset all the time I work on lakes around the world they go different places in its excellent so thank you very much for making this on related to those questions on 2 points and 1 is obviously different countries have different policies that some are willing to say let it go get some say no on but we use bundle that here as a single download that's a 2nd point I have and when you do you go to that that download option there you get the whole world I if you considered making of 1 a download specific for country maybe you just select a polygon isn't where they're developing something like that so yeah but firstly to I think we'll have that for for what country and so we have the I'm not sure why and what it should be but but yeah uh starting by country we can we'll have something like that OK very good we are also developing an API to just get that's Allison through through just getting the Pauli and according to the WT PAID you may know that the study of speech but the because the URI much on or related question is about your processing in the dissolved commands and simplified geometry things like that on approximately how long does it does really take you guys to go through and it dissolve your whole dataset without the simplified commands in the system you have been what machines using on I couldn't do it yeah yet yeah I would just squeaks before before finishing the other yeah so yeah that's what region so basically it was getting a while to the let's even using posters and using even using indexes and stuff like that so the EU II ended up trying to see what were the most difficult countries to this all that were taking i'd when when I I act as as I wouldn't be telling you so we had to In this process we just looked through every country to calculate statistics and what when we got to germany or when we got to USA he was just taking a lot of time doing that more than 2 laced the what what I've remember for Germany for instance so I ended up here uh and uh um see seem how how different was from from the the previous results that were that they took a month to calculate and wait we got the margin of error was less than then the 5 per cent or so so for the entire country uh you will run per cent of of their areas much more than that so so we went up for with the same results uh rounded by the the units as so so that's we we we we and the finishing needs but as I was telling a if I were put there's program just migrates to ghost she's will need to Latin pursue so maybe later i can just give you how how long should I take to to run it actually if if anyone follow the international borders on what the city used for that reason he human centers of the of you know and did that is the problem that we have in our organization because it's still don't have an official 1 so I have 4 is those we are not showing the broader but it's uh just call clicking statistically with the a small margin of error I just use the the natural our datasets with thank you of give the I and 1 of the 1st of all it's it's a great Warwick your training data and I'm very impressed I find the right amount of time it and you'll be wanted for this process I and my issues and wondering how only use it to address the discrepancy in any they you would encounter I want the national statistics they publish in an national and so if you have any experience in countering this year Apple Soviet so what can happen and what usually happens is that our team is not big enough to every month gets operated static to even the country's don't sends uh every month of clickers statistics so we have the team of 6 people that wire working permanently contacting Governments in in every country to get the information so what happens is that for instance in a month we get the but there's for a career a pardon on the moon on the following maybe 10 months we'll not contacts query again so we will not have updated statistics so yes we we can have and we we we we are aware that that some of the statistics are not updated as a so given the country statistics and so uh and yes so this is a work in progress and that's why we have that send feedback but in there so any person hours and hours and the government that doesn't I agree with the data that we have there they just going to contact us and we'll just change it's just in that month so I think we that could be quite quick so to to address that but OK thank you very much and

29:08

admire Bn

Spracherkennung

Texterkennung

Bildinhalt

00:00

Subtraktion

Gewicht <Mathematik>

Statistik

Verzweigendes Programm

Zahlenbereich

Biprodukt

Computeranimation

Office-Paket

Benutzerbeteiligung

Umweltinformatik

Datenmanagement

Flächeninhalt

Flächeninhalt

Projektive Ebene

Softwareentwickler

Optimierung

Ordnung <Mathematik>

01:28

Mapping <Computergraphik>

Arithmetisches Mittel

Web Site

Flächeninhalt

Datenhaltung

Information

Verkehrsinformation

Dialekt

Computeranimation

Homepage

03:03

Resultante

Randverteilung

Krümmung

Punkt

Prozess <Physik>

Compiler

Computeranimation

Internetworking

PROM

Umweltinformatik

Skript <Programm>

Gerade

Metropolitan area network

Software Development Kit

Statistik

Dokumentenserver

Datenhaltung

Abfrage

Disjunktion <Logik>

Zeitzone

Arithmetisches Mittel

Randwert

Datenfeld

Menge

Ablöseblase

Dateiformat

Projektive Ebene

Information

Repository <Informatik>

Instantiierung

Fehlermeldung

Tabelle <Informatik>

Subtraktion

Web Site

Stabilitätstheorie <Logik>

Gewicht <Mathematik>

Selbst organisierendes System

Statistik

Polygon

Räumliche Anordnung

Framework <Informatik>

Demoszene <Programmierung>

Task

Statechart

Benutzerbeteiligung

Software

Datentyp

Stichprobenumfang

Spezifisches Volumen

Softwareentwickler

Optimierung

Zeiger <Informatik>

Bildgebendes Verfahren

Analysis

Touchscreen

Schätzwert

Ruby on Rails

Open Source

Aeroelastizität

Schlussregel

Physikalisches System

Elektronische Publikation

Objekt <Kategorie>

Flächeninhalt

Mereologie

Web-Designer

Verkehrsinformation

18:42

Knotenmenge

Web Site

Bildschirmmaske

Quadratzahl

Flächeninhalt

Software

Konditionszahl

Information

Kombinatorische Gruppentheorie

Term

Instantiierung

19:51

Klasse <Mathematik>

Verteilungsfunktion <Statistische Mechanik>

Term

Term

Computeranimation

20:40

Randverteilung

Resultante

Subtraktion

Punkt

Wellenpaket

Prozess <Physik>

Selbst organisierendes System

Sprachsynthese

Polygon

Räumliche Anordnung

Computeranimation

Virtuelle Maschine

Benutzerbeteiligung

Einheit <Mathematik>

Arithmetische Folge

Software

Vorlesung/Konferenz

Diskrepanz

Optimierung

E-Mail

Attributierte Grammatik

Umwandlungsenthalpie

Beobachtungsstudie

Statistik

Abfrage

Ideal <Mathematik>

Physikalisches System

Konfiguration <Informatik>

Flächeninhalt

Offene Menge

Rechter Winkel

Automatische Indexierung

Ablöseblase

Lateinisches Quadrat

Information

Faserbündel

Fehlermeldung

Instantiierung

Metadaten

Formale Metadaten

Titel

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

Inhaltliche Metadaten

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.