OSGeo Planet

PostGIS Development: PostGIS 2.5.0beta1

OSGeo Planet - Tue, 2018-07-03 00:00

The PostGIS development team is pleased to release PostGIS 2.5.0beta1.

This release is a work in progress. No more api changes will be made from this point on before 2.5.0 release. Remaining time will be focused on bug fixes and documentation for the new functionality and performance enhancements under the covers. Although this release will work for PostgreSQL 9.4 and above, to take full advantage of what PostGIS 2.5 will offer, you should be running PostgreSQL 11beta2+ and GEOS 3.7.0beta1 which were released recently.

Best served with PostgreSQL 11beta2 which was recently released.

View all closed tickets for 2.5.0.

After installing the binaries or after running pg_upgrade, make sure to do:


— if you use the other extensions packaged with postgis — make sure to upgrade those as well

ALTER EXTENSION postgis_sfcgal UPDATE; ALTER EXTENSION postgis_topology UPDATE; ALTER EXTENSION postgis_tiger_geocoder UPDATE;

If you use legacy.sql or legacy_minimal.sql, make sure to rerun the version packaged with these releases.


Categories: OSGeo Planet

GeoSolutions: Afghanistan disasterrisk Platform: Using GeoNode, GeoServer and MapStore to help resilient development planning

OSGeo Planet - Mon, 2018-07-02 14:14

Disasterrisk Featured Image

Dear Reader,

in this post we want to talk about how we used GeoNodeGeoServer, and MapStore to build a platform for visualization and cost-benefit analysis to support decision makers with resilient development planning, public policy and investments in Afghanistan in cooperation with the GFDRR group at the World Bank. While in this post we will concentrate a little more on the technicalities behind the platform, in case you were interested more into the higher level motivations and objectives you can read this blog post from the GFDRR group.

The goal of the project is to improve the decision-making and data-extraction capabilities for Afghanistan by expanding GeoNode with two additional modules:

  • The first, called Risk Data Extraction and Visualization, to allow users to easily generate maps and extract tabular results for their area and indicator of interest at different return periods and with the ability to drill down at different administrative levels.
  • The second, called Cost/Benefit Analysis and Decision Tool, to  allow users to perform costs-benefits analysis for various hazards (primarily earthquakes and floods) using pre-calculated risk management options, thus allowing the user to discover the benefits of investing in risk reduction.
Both modules are integrated within the GeoNode platform and are based on pre-calculated tabular statistical and geospatial layers (both vector and raster data). The responsive graphical user interface is based on the MapStore framework. Risk Data Extraction & Visualization

This module enables users to easily visualize and extract risk data for the area of interest at different administrative levels (district, province, national). Based on the selection of administrative area, indicator and return period, the user is presented with a map and a series of charts about the risk assessments.

Input tables are delivered for each indicator (population, GDP, roads, etc), outlining damage/value for all return periods, an example is provided in the table below.

[caption id="attachment_4253" align="aligncenter" width="800"]Example losses per district for all return periods Example of losses per district for all return periods[/caption]

The tool is able to ingest tabular data (i.e. Excel files and CSV files), automatically process and convert inputs into internal model linked to administrative areas, and finally to present to the users a friendly and modern interface to navigate the collected information.  A summary of all the Risk Analysis available per Hazard type at the country level is presented to users as a first landing page (see below).

[caption id="attachment_4260" align="aligncenter" width="800"]Risk Management Tool Options for Afghanistan Risk Management Tool Options for Afghanistan. Various hazards are available.[/caption] By clicking on a Hazard type (e.g. earthquake), it is possible to view the list of available Risk Analysis ordered by Category of target (Agriculture, Airports, Buildings, Healthcare, …), as shown below. [caption id="attachment_4261" align="aligncenter" width="800"]Earthquake Risk Analysises ordered by Category of Target Earthquake Risk Analyzes available[/caption]

Users can click on the analysis panel to open the brief abstract and then click on 'Analysis Data' button to go into the detailed data page, as shown below.

[caption id="attachment_4262" align="aligncenter" width="800"]Earthquake Risk Analysises available -2- Earthquake Risk Analyzes available -2-[/caption]

The detailed view of the Risk Analysis presents the title of the analysis along with its brief description. An interactive chart that let the user to change the values shown in the map interactively. On top of the map, a toolbar gives the possibility to navigate through the data, get information or switch layers or dimensions.  The “Dimensions Switcher” tool allows to switch between “Scenarios” and “Return Periods” view instead. Charts and dashboards are updated dynamically. Additional GeoNode resources and documents (PDF reports, images, …) can also be linked to the analysis data and presented to the user for further readings. Last but not least, as shown below, data is available at multiple administrative levels (country, region, county) and we can use the interactive map to drill down geographically, as shown below.

[caption id="attachment_4263" align="aligncenter" width="800"]Hazard-Exposures for affected irrigated agriculture Hazard-Exposures for affected irrigated agriculture at Afghanistan Level[/caption] [caption id="attachment_4264" align="aligncenter" width="800"]Hazard-Exposures for affected irrigated agriculture at Afghanistan Level Hazard-Exposures for affected irrigated agriculture in Kunduz Region[/caption] [caption id="attachment_4265" align="aligncenter" width="800"]Hazard-Exposures for affected irrigated agriculture in Emamsaheb county in Kunduz region Hazard-Exposures for affected irrigated agriculture in Emamsaheb county in Kunduz region - Return period of 10 years[/caption] Cost-benefit Analysis & Decision Tool

This module allows the users to access precomputed (obviously by domain experts) cost-benefit analyses of risk management options in a user-friendly way by making use of maps and charts. This various cost-benefit analyses have been conducted for a number of risk management options for floods, earthquakes, and landslides. For each of the options precomputed  reductions in disaster losses have been produced and ingested into the system (a specific ingestion system was developed suitably for this).  Input tables are delivered for each indicator with precomputed  data as in the table below.

[caption id="attachment_4254" align="aligncenter" width="800"]damages to schools under baseline conditions and for different risk reduction scenarios damages to schools under baseline conditions and for different risk reduction scenarios[/caption]

The cost-benefits analysis overview is similar to the previous one, see below.

[caption id="attachment_4242" align="aligncenter" width="800"]Cost-benefits analysis overview Cost-benefits analysis overview[/caption]

The cost-benefit detail dashboards change accordingly to the type of analysis. Typically cost-benefit analysis is conducted on site-specific use cases (roads, rivers, schools, sub-areas, etc…). Panels, charts and dashboards are automatically rendered by the tool and comparison charts and tables are presented to the users for each “Risk Reduction Scenario”. Here below an example for Flood hazard and its impact on the buildings in Kabul.

[caption id="attachment_4256" align="aligncenter" width="800"]Cost-benefit Analysis Tool Options for Earthquakes Cost-benefit Analysis Tool Options for Floods - before loading analysis data[/caption] [caption id="attachment_4257" align="aligncenter" width="800"]Impact and flood risk assessment for Kabul -1- Impact and flood risk assessment for Kabul -1-[/caption] [caption id="attachment_4258" align="aligncenter" width="800"]Impact and flood risk assessment for Kabul -2- Impact and flood risk assessment for Kabul -2-[/caption]

The entire framework leverage on GeoNode and GeoServer Parametric SQL Views while the front-end is based on modern technologies and concepts like material views on a single page application based on MapStore and D3-JS for the rendering of charts and dashboards. If you are interested in knowing more about the platform, please, feel free to send us some emails. The code is Open Source as usual, although these very specific modules will not be contributed back to the GeoNode community version.

Last but not least, if you are interested in learning about how we can help you achieving your goals with open source products like GeoServerMapStoreGeoNode and GeoNetwork through our Enterprise Support Services and GeoServer Deployment Warranty offerings, feel free to contact us!

The GeoSolutions Team,

Categories: OSGeo Planet

gvSIG Team: Nueva extensión de gvSIG para cargar ficheros XML de SIGPAC en España

OSGeo Planet - Thu, 2018-06-28 15:00

Ya está disponible para instalar en gvSIG el plugin que permite cargar los ficheros XML de SIGPAC, el Sistema de Información Geográfica de Parcelas Agrícolas de España.Para instalar esta extensión se debe acceder al administrador de complementos de gvSIG (menú “Herramientas”), seleccionando la opción por URL, y conectando al servidor por defecto. En la siguiente ventana escribiremos en la parte superior “SIGPAC”, y nos aparecerá la extensión, que debemos marcar. Una vez instalada deberemos reiniciar gvSIG y ya tendremos la herramienta disponible en el menú “Herramientas->SIGPAC”.

Si la capa XML es de líneas o puntos, se cargará como un fichero CSV, y si es de polígonos se cargará directamente como SHP.

Una vez nos aparece el fichero en la ventana de “Añadir capa”, si está en un sistema de referencia diferente al de la Vista deberemos entrar en sus propiedades e indicárselo. De esa forma se reproyectará al vuelo, por lo que deberemos exportar la capa a un nuevo SHP para que esté ya en el sistema de la Vista.

En el siguiente vídeo podéis ver el funcionamiento:

Categories: OSGeo Planet

Antonio Santiago: Joppy, the Tinder for tech recruitment

OSGeo Planet - Thu, 2018-06-28 14:10

TLTR: This post is about Joppy, a new service I’m working on that tries to eliminate the pain currently exists in the communication among recruiters and tech professionals. Let me describe you the current scenario in the recruitment world and, please, any feedback will be welcome.

Tech professionals: Wherever I wrote tech professionals I mean any kind of role related with tech companies: software engineers, developers or programmers, manager, product owners, QA, designers, …


It all starts…

…taken a beer and asking your friends: How many connection requests do you receive per week from LinkedIn? All three (two developers and a UI/UX designer) answer the same enough to be annoying. Every tech professional want to have his/her CV updated in LinkedIn, it is a great service, but no one agrees with the myriad of emails asking for connections from recruiters that has awesome job offers from awesome companies.

Do you thing the job of a recruiter is easy? Well, let me say you are completely wrong. It is not an easy job and often ungrateful. If you think in a more or less important city with many tech companies you can image the competition existing among companies to get tech professional.

Currently there are two main things recruiters can do to arrive to candidates:

  1. Publish offers in some kind of board and wait candidates applies (we all have in mind web sites that crawls and shows tons of job offers)
  2. Make an active search of potential candidates. Recruiters need to use services like LinkedIn, where they can search techies in a given geographical area, that know about X, Y, Z skills and many other options. Once filtered they need to contact each of them where, probably, most of them are not interested in a change or in the position the recruiter is offering.
Categories: OSGeo Planet

GeoSolutions: DECAT Platform: Early Warning & Alert Systems with GeoNode, GeoServer and MapStore

OSGeo Planet - Wed, 2018-06-27 17:37


Dear Reader,

in this post we want to talk about how we twisted and extended GeoNodeGeoServer, and MapStore to build a platform for emergency response and early warning for the DeCATastrophize European Project (acronym DECAT).

DECAT Project

Effective systems for early warning, mitigation of impacts, and emergency management can save lives and protect people, property and the environment in the event of natural and man-made disasters. The goal of the DECAT project is to design, implement and operate a geospatial decision support system to assess, prepare for and respond to multiple and/or simultaneous natural and man-made hazards and disasters in a synergistic way. The DECAT platform provides:

  • Workflows and functionalities for early warning and rapid notification for risk resilience at all levels
  • Methodologies for rapid assessment and mitigation of impacts and decision-making through rapid mapping
  • Ability to disseminate geospatial data and information about various types of multi-hazards
  • Dedicated capabilities aimed to support impact assessment as well as emergency management based on activities suitable for overall operational scenarios

The types of hazards that were taken into account is extensive and so is the scenarios which the platform was tested; the list of hazards comprehends the following:

  • Wildfire
  • Tsunami
  • Flood
  • Earthquake
  • Oil Spill
Tests were conducted in Italy, Spain, France, Greece and Cyprus to evaluate the capabilities of the developed platform. The DECAT Platform

The DECAT platform is composed by a few modules designed to support the needs of the three main phases of emergency management, in the order:

  • Early Warning, during which events are collected and analyzed in order to understand if we are facing of a real hazard or a false alarm
  • Impact Assessment, which triggers once an event has been confirmed to be an hazard  to model, under the guidance of a domain expert, the impact of an hazards on various targets
  • Mitigation of Impact, which deals with the management of the emergency derived from the impact of the to mitigate its impact.
The platform comprises also of a few additional modules providing horizontal functionalities that are needed by all three modules above (e.g. document management, geospatial data management, user management and the like). [caption id="attachment_4178" align="aligncenter" width="800"]Decat Platform Modules Decat Platform Modules[/caption]

The above modules provide the operators with specific tools and customized layouts for each phase of emergency management.

The Early Warning module provides the operator with wizards to create, edit and update so called events which represent potential hazards occurring inside his area of competence; this is supported via geospatial tools to edit point features and record ancillary information useful to characterize events and assess the level of hazard, generally used to revise and debrief the emergency response. Each event can be searched, modified and updated, to evolve to an occurrence treating the community or back to ordinary conditions. In the first case, it will be promoted and notified as early warning, otherwise it will be archived (see below); once an event is promoted the other phases are enabled and the entire workflow to assess the impact and manage the emergency comes to life.

[caption id="attachment_4203" align="aligncenter" width="800"]Early Warning User Interface Early Warning User Interface[/caption]  

As mentioned above, once an event is confirmed (i.e. an earthquake has struck somewhere) the impact assessment phase triggers in order to evaluate and model the hazard as well as to assess its evolution and impact over time. The Impact assessment module allows the impact assessor (i.e. a domain expert with scientific background and experience regarding effects and losses occurring because of a specific type of disaster) to evaluate the context and the environment where the event is taking place, providing by modelling or pre-formulated scenario analyses, additional geospatial information, reports and documents useful to properly identify and locate specific needs of rescue and recovery interventions. This module has been designed to permit the creation and update of the so-called Common Operational Picture (COP) for the emergency managers, which is an evolving geospatial representation of the hazards integrated with preliminary localization of rescue and recovery targets, by integrating relevant hazard models outputs in real-time. The impact assessor has the possibility to create a reference map (the COP) for the emergency management coupling hazards modelling together with geospatial information relevant for emergency plan implementation (e.g. gathering areas, field hospital location, command and control field unit) as well as targets needing urgent intervention. The symbols used to visualize the feature can be adapted to the subject and changed according to its specific evolution. The COP can then be frozen to a specific instant, and shared with the emergency managers, responsible to assign rescue or recovery targets to work-force teams (see below), however the impact assessor can, at any time, perform a new assessment by updating information in the active COP to create an updated one that would more closely represent the current situation.

[caption id="attachment_4202" align="aligncenter" width="800"]Impact Assessment User Interface Impact Assessment User Interface at work for the Paphos flood[/caption]

The last set of functionalities is related to the coordination of field workforce and Emergency Management; thanks to this module the platform provides the emergency managers with capabilities to collaboratively (and concurrently) manage online, directly on the COP geospatial features representing allocated teams, customized according to the type of workforce they belong. Such geospatial features can be updated over time to capture the status of resources engaged with the rescue operations on the field (see figure below) as well as the changing conditions on the field. Moreover, updates of the COP generated by newer impact assessment to capture the evolution of the disaster can be published at any time by the impact assessor and they will refresh background information used by the emergency managers.

[caption id="attachment_4200" align="aligncenter" width="800"]Emergency Management User Interface Emergency Management user interface at work for the Paphos flood[/caption] Technologies and building blocks

The DECAT platform is implemented by leveraging on a few on well-known Open Source building blocks like GeoServer, GeoNode and MapStore, as shown below. GeoServer provides advanced geospatial data management and mapping capabilities according to the OGC Web Map Services (WMS), Web Coverage Services (WCS) and Web Feature Services (WFS) protocols while GeoNode acts as a broker for the data providing OGC Catalogue Services (CSW) capabilities, acting as the catalog for data and metadata discovery. MapStore is used as the mapping and visualization engine and provides geospatial visualization functionalities over the data ingested into the DSS by interacting with OGC protocols.

[caption id="attachment_4186" align="aligncenter" width="800"]DECAT Platform Components DECAT Platform Components[/caption]

Authentication is provided through the support for OAUTH 2.0 protocol having GeoNode play the provider role (i.e. being responsible for the management of users’ credentials and live sessions) hence it takes care of creating and expiring users’ sessions as well as of managing access permission over the ingested geospatial data in coordination with GeoServer. In its default configuration data is private and accessible only to the publisher and the users within his organization. Several additional modules have been implemented during the project to create the DECAT DSS by extending the GeoNode and MapStore frameworks. The user-interface has been completely redesigned to follow a three phases approach during the management of the emergency, where specific back-end modules have been developed in GeoNode to manage alerts and hazards, to perform and disseminate impact assessments associated to hazards, up to the annotations used by emergency managers to support resource allocation to targets in the field.

Conclusions and way forward

A final Table Top / Command Post exercise was conducted in the area of Paphos, Cyprus to assess the utility and usability of the DECAT Platform in disaster preparedness and response. The main objective of the exercise was to test the platform in realistic scenarios to evaluate its impact on existing decision making processes during emergency situations. The tested scenarios included a wildfire threatening the forest of Paphos, nearby villages and other infrastructure as well as an heavy rainfall in the Town of Paphos with a great danger for floods. The DECAT platform was used in order to extract and provide valuable information to the decision makers during the exercise, all the three phases of the platform were used and successfully presented (Early Warning, Impact Assessment and Emergency Management).

[caption id="attachment_4189" align="aligncenter" width="848"]Flood and fire hazards in DECAT DSS for Cyprus Flood and fire hazards in DECAT Platform for Cyprus[/caption]

The DECAT Platform has been an important step for GeoSolutions in order to strenghten its knowledge on the GeoNode framework given the size and depth of the customizations, moreover it allowed us to perform a first integration between MapStore and GeoNode which is part of our overall strategy for the future of GeoNode. Some of the implemented functionalities and fixes have been already contributed to the respected projects (e.g. map annotations developed to manage field resources during the emergency management phase are now port of MapStore and so are a large number of GeoNode fixes and improvements).

For those who are interested, the DECAT Platform is still up and running here (mind you, this is a snaphot of the cloud instance used during the tests so most data is password protected.; however, most data is not open to the public hence if you are interested in having a look we can schedule a demo. Last but not least, the source code is, obviously, Open Source like everything we do here at GeoSolutions. This work was cofinanced by DG-ECHO under the DECAT European project.


If you are interested in learning about how we can help you achieving your goals with open source products like GeoServerMapStoreGeoNode and GeoNetwork through our Enterprise Support Services and GeoServer Deployment Warranty offerings, feel free to contact us!

The GeoSolutions Team,

Categories: OSGeo Planet

QGIS Blog: QGIS Server certified as official OGC reference implementation

OSGeo Planet - Wed, 2018-06-27 17:34

We are very excited to announce that QGIS Server has been successfully certified as a compliant WMS 1.3 server against the OGC certification platform, and moreover, it is even considered as a reference implementation now!

This is the first step on our roadmap of having a fast, compliant and bullet proof web map server that is straightforward to publish from a classical QGIS project.

What does it mean?

Having a certified server means that QGIS Server successfully passes the automated and semi automated tests that ensure we are 100% compliant with the standards. That means you can trust QGIS to be used by any WMS client seamlessly.
Moreover, that certification is now powered by a continuous integration system that checks every night in developement versions if we still pass the tests.

Daily compliance reports are available on the new tests.qgis.org website.

What’s next?

Building the automated testing platform and getting officially certified was only the first step. We now are starting to certify the WFS services, thanks to the latest grant application program support.

We also want QGIS server development to be performance-driven. The following projects are particularly relevant:

  • MS-Perf produces benchmark reports with MapServer and GeoServer.
  • graffiti  and PerfSuite tools have been designed to create a really light tool, easy to enrich with new datasets and performance tests, and easy to integrate in continuous integration systems. It compares QGIS-ltr, QGIS-rel and QGIS-dev nightlies for the same scenarios in details and produces html reports. It can also graph performance history for the development version to track regressions or improvements.

Many thanks to the supporters and voting members that helped bootstrap all those testing platforms and offer them to the community.

If you want to support or give a hand on the QGIS desktop client side, we think that area would deserve some love too!

Categories: OSGeo Planet

OTB Team: Orfeo ToolBox 6.6 is out!

OSGeo Planet - Tue, 2018-06-26 09:21
We are pleased to announce that Orfeo ToolBox 6.6.0 is out ! As usual, ready-to-use binary packages are available for Windows, Linux and Mac OS X : OTB 6.6 You can also checkout the source directly with git: git clone https://gitlab.orfeo-toolbox.org/orfeotoolbox/otb.git OTB -b release-6.6 We welcome your feedback and requests, and encourage you to join […]
Categories: OSGeo Planet

gvSIG Team: Curso gratuito gvSIG aplicado a Medio Ambiente: Certificación y enlace al curso completo.

OSGeo Planet - Mon, 2018-06-25 09:55

Ya está disponible la certificación del curso gratuito de gvSIG aplicado a Medio Ambiente.

Cartel gvSIG aplicado a Medioambiente2

Esta certificación se abre tras la publicación de los últimos temas del curso, pero seguirá abierta de forma continua, por lo que cualquier usuario/a podrá obtenerla en el momento en que finalice los distintos temas.

Para poder obtener dicha certificación se deberán completar todos los ejercicios de cada tema. Los ejercicios validarán los conocimientos adquiridos durante el curso y serán evaluados por un tutor.

La plataforma y la opción de matrícula abierta la podéis encontrar en www.geoalternativa.com/gvsig-training. Es necesario elegir el curso de gvSIG aplicado a Medio Ambiente. Después debéis elegir la opción “Registrarse como usuario” y, por último, matricularos en él.

Aparte de la entrega y aprobación de los ejercicios, la certificación llevará un coste mínimo, necesario para cubrir los gastos relativos a la evaluación y certificación. Este coste será de 30 €. El pago es posible hacerlo a través de Paypal en el siguiente enlace: http://www.gvsig.com/es/curso-gvsig-aplicado-medio-ambiente

La certificación será emitida por la Asociación gvSIG, y estará compuesta por dos certificados:

Certificado de aprovechamiento del curso, que incluirá toda la información relativa a los contenidos formativos adquiridos.

Certificado oficial gvSIG Usuario, al haber completado los 90 créditos necesarios para ello, y que da derecho a poder obtener el certificado de gvSIG Usuario, realizando y aprobando los créditos necesarios para su convalidación, a través de los cursos ofrecidos por la Asociación gvSIG.

El tiempo de dedicación del curso se ha estimado en 90 horas.

Categories: OSGeo Planet

BostonGIS: New in QGIS 3.2 Save Project to PostgreSQL

OSGeo Planet - Mon, 2018-06-25 05:47

We've got customers discovering PostGIS and GIS in general or migrating away from ArcGIS family of tools. When they ask, "How do I see my data?", we often point them at QGIS which is an open source GIS desktop with rich integration with PostGIS/PostgreSQL.

QGIS is something that is great for people who need to live in their GIS environment since it allows for easily laying on other datasources, web services and maps. The DBManager tool allows for more advanced querying (like writing Spatial SQL queries that take advantage of the 100s of functions PostGIS has to offer) , ability to import/export data, and create PostgreSQL views.

QGIS has this thing called Projects, which allow for defining map layers and the symbology associated with them. For example what colors do you color your roads, and any extra symbols, what field attributes do you overlay - street name etc. Projects are usually saved in files with a .qgs or .qgz extension. If you spent a lot of time styling these layers, chances are you want to share them with other people in your group. This can become challenging if your group is not connected via network share.

Continue reading "New in QGIS 3.2 Save Project to PostgreSQL"
Categories: OSGeo Planet

QGIS Blog: QGIS 3.2 Bonn is released!

OSGeo Planet - Sun, 2018-06-24 19:57

We are pleased to announce the release of QGIS 3.2 ‘Bonn’. The city of Bonn was the location of our 16th developer meeting.


This is the second release in the 3.x series. It comes with tons of new features (see our visual changelog).

Packages and installers for all major platforms are available from downloads.qgis.org.

We would like to thank the developers, documenters, testers and all the many folks out there who volunteer their time and effort (or fund people to do so). From the QGIS community we hope you enjoy this release! If you wish to donate time, money or otherwise get involved in making QGIS more awesome, please wander along to qgis.org and lend a hand!

QGIS is supported by donors and sponsors. A current list of donors who have made financial contributions large and small to the project can be seen on our donors list. If you would like to become and official project sponsor, please visit our sponsorship page for details. Sponsoring QGIS helps us to fund our six monthly developer meetings, maintain project infrastructure and fund bug fixing efforts. A complete list of current sponsors is provided below – our very great thank you to all of our sponsors!

QGIS is Free software and you are under no obligation to pay anything to use it – in fact we want to encourage people far and wide to use it regardless of what your financial or social status is – we believe empowering people with spatial decision making tools will result in a better society for all of humanity.





Categories: OSGeo Planet

QGIS Blog: QGIS Grant Programme 2018 Results

OSGeo Planet - Fri, 2018-06-22 19:03

We are extremely pleased to announce the winning proposals for our 2018 QGIS.ORG grant programme. Funding for the programme was sourced by you, our project donors and sponsorsNote: For more context surrounding our grant programme, please see:

The QGIS.ORG Grant Programme aims to support work from our community that would typically not be funded by client/contractor agreements, and that contributes to the broadest possible swathe of our community by providing cross-cutting, foundational improvements to the QGIS Project.

Voting to select the successful projects was carried out by our QGIS Voting Members. Each voting member was allowed to select up to 6 of the 14 submitted proposals by means of a ranked selection form. The full list of votes are available here (on the first sheet). The second sheet contains the calculations used to determine the winner (for full transparency). The table below summarizes the voting tallies for the proposals:


A couple of extra notes about the voting process:

  • The PSC has an ongoing program to fund documentation so elected to fund the QGIS Training Manual update even if this increases the total funded amount beyond the initial budget.
  • Although the budget for the grant programme was €25,000, the total amount for the winning proposals is €35,500. This increase is possible thanks to the generous support by our donors and sponsors this year.
  • Voting was carried out based on the technical merits of the proposals and the competency of the applicants to execute on these proposals.
  • No restrictions were in place in terms of how many proposals could be submitted per person / organization, or how many proposals could be awarded to each proposing person / organization.
  • Voting was ‘blind’ (voters could not see the existing votes that had been placed).

Of the 45 voting members, 29 registered their votes 17 community representatives and 12 user group representatives.

On behalf of the QGIS.ORG project, I would like to thank everyone who submitted proposals for this call!

A number of interesting and useful proposal didn’t make it because of our limited budget; we encourage organizations to pick up one of their choice and sponsor it.

Categories: OSGeo Planet

QGIS Polska: blog:i_spotkania_uzytkownikow_qgis_juz_za_nami

OSGeo Planet - Fri, 2018-06-22 18:07
Pomysł na zorganizowanie tego spotkania kiełkował od lat, ale zawsze brakowało czasu na jego realizację. Główny problem polegał na określeniu docelowej grupy uczestników oraz formuły. Wiemy oczywiście, jak szerokie jest grono użytkowników programu QGIS, ale ta wiedza wcale nie ułatwiała zadania. Ostatecznie po przeprowadzeniu kilku ankiet na polskim forum QGIS postanowiliśmy zaserwować wszystkiego po trochu. Potrzebni byli tylko prelegenci, miejsce i termin. Zdecydowaliśmy się na 19 czerwca 2018…
Categories: OSGeo Planet

QGIS Polska: blog:i_spotkania_uzytkownikow_qgis_juz_za_nami

OSGeo Planet - Fri, 2018-06-22 18:07
Pomysł na zorganizowanie tego spotkania kiełkował od lat, ale zawsze brakowało czasu na jego realizację. Główny problem polegał na określeniu docelowej grupy uczestników oraz formuły. Wiemy oczywiście, jak szerokie jest grono użytkowników programu QGIS, ale ta wiedza wcale nie ułatwiała zadania. Ostatecznie po przeprowadzeniu kilku ankiet na polskim forum QGIS postanowiliśmy zaserwować wszystkiego po trochu. Potrzebni byli tylko prelegenci, miejsce i termin. Zdecydowaliśmy się na 19 czerwca 2018…
Categories: OSGeo Planet

Marco Bernasocchi: Using Threads in PyQGIS3

OSGeo Planet - Fri, 2018-06-22 11:30
While porting a plugin to QGIS3 I decided to also move all it’s threading infrastructure to QgsTasks. Here three possible variants to implement this. the first uses the static method QgsTask.fromFunction and is simpler to use. A great quick solution.… See more ›
Categories: OSGeo Planet

Paul Ramsey: PostGIS Polygon Splitting

OSGeo Planet - Thu, 2018-06-21 20:00

One of the joys of geospatial processing is the variety of tools in the tool box, and the ways that putting them together can yield surprising results. I have been in the guts of PostGIS for so long that I tend to think in terms of primitives: either there’s a function that does what you want or there isn’t. I’m too quick to ignore the power of combining the parts that we already have.

A community member on the users list asked (paraphrased): “is there a way to split a polygon into sub-polygons of more-or-less equal areas?”

I didn’t see the question, which is lucky, because I would have said: “No, you’re SOL, we don’t have a good way to solve that problem.” (An exact algorithm showed up in the Twitter thread about this solution, and maybe I should implement that.)

PostGIS developer Darafei Praliaskouski did answer, and provided a working solution that is absolutely brilliant in combining the parts of the PostGIS toolkit to solve a pretty tricky problem. He said:

The way I see it, for any kind of polygon:

  • Convert a polygon to a set of points proportional to the area by ST_GeneratePoints (the more points, the more beautiful it will be, guess 1000 is ok);
  • Decide how many parts you’d like to split into, (ST_Area(geom)/max_area), let it be K;
  • Take KMeans of the point cloud with K clusters;
  • For each cluster, take a ST_Centroid(ST_Collect(point));
  • Feed these centroids into ST_VoronoiPolygons, that will get you a mask for each part of polygon;
  • ST_Intersection of original polygon and each cell of Voronoi polygons will get you a good split of your polygon into K parts.

Let’s take it one step at a time to see how it works.

We’ll use Peru as the example polygon, it’s got a nice concavity to it which makes it a little trickier than an average shape.

CREATE TABLE peru AS SELECT * FROM countries WHERE name = 'Peru'

Original Polygon (Petu)

Now create a point field that fills the polygon. On average, each randomly placed point ends up “occupying” an equal area within the polygon.

CREATE TABLE peru_pts AS SELECT (ST_Dump(ST_GeneratePoints(geom, 2000))).geom AS geom FROM peru WHERE name = 'Peru'

2000 Random Points

Now, cluster the point field, setting the number of clusters to the number of pieces you want the polygon divided into. Visually, you can now see the divisions in the polygon! But, we still need to get actual lines to represent those divisions.

CREATE TABLE peru_pts_clustered AS SELECT geom, ST_ClusterKMmeans(geom, 10) over () AS cluster FROM peru_pts;

10 Clusters

Using a point field and K-means clustering to get the split areas was inspired enough. The steps to get actual polygons are equally inspired.

First, calculate the centroid of each point cluster, which will be the center of mass for each cluster.

CREATE TABLE peru_centers AS SELECT cluster, ST_Centroid(ST_collect(geom)) AS geom FROM peru_pts_clustered GROUP BY cluster;

Centroids of Clusters

Now, use a voronoi diagram to get actual dividing edges between the cluster centroids, which end up closely matching the places where the clusters divide!

CREATE TABLE peru_voronoi AS SELECT (ST_Dump(ST_VoronoiPolygons(ST_collect(geom)))).geom AS geom FROM peru_centers;

Voronoi of Centrois

Finally, intersect the voronoi areas with the original polygon to get final output polygons that incorporate both the outer edges of the polgyon and the voronoi dividing lines.

CREATE TABLE peru_divided AS SELECT ST_Intersection(a.geom, b.geom) AS geom FROM peru a CROSS JOIN peru_voronoi b;

Intersection with Original Polygon


Clustering a point field to get mostly equal areas, and then using the voronoi to extract actual dividing lines are wonderful insights into spatial processing. The final picture of all the components of the calculation is also beautiful.

All the Components Together

I’m not 100% sure, but it might be possible to use Darafei’s technique for even more interesting subdivisions, like “map of the USA subdivided into areas of equal GDP”, or “map of New York subdivided into areas of equal population” by generating the initial point field using an economic or demographic weighting.

Categories: OSGeo Planet

gvSIG Team: 5as Jornadas gvSIG Uruguay: Información Geográfica en un ámbito abierto

OSGeo Planet - Thu, 2018-06-21 17:21

Los próximos días 18 y 19 de octubre se celebrarán las 5as Jornadas gvSIG Uruguay y 3as Jornadas de Tecnologías Libres de Información Geográfica y Datos Abiertos en Montevideo (Uruguay), bajo el lema ‘Información Geográfica en un ámbito abierto’.

Desde ahora está abierto el periodo de recepción de resúmenes, los cuales pueden enviarse a la dirección de correo jornadas.uruguay@gvsig.org siguiendo la plantilla facilitada en el apartado Comunicaciones de la web del evento, donde pueden consultarse también las normas para el envío. Los tipos de comunicación admitidos son ponencia y póster.

Durante las jornadas se entregarán los premios del Concurso de Uso de Tecnologías Libres de Información Geográfica 2018, organizado por GeoForAll Iberoamérica y OSGeo. para el cual los usuarios de cualquier Tecnología Libre de Información Geográfica pueden enviar ya sus trabajos.

Las jornadas serán gratuitas, y el periodo de inscripción se abrirá el 24 de septiembre.

Así mismo, cualquier entidad interesada en colaborar con las jornadas, puede hacerlo de varias formas, que incluyen desde una aportación económica hasta el aporte de recursos que de forma equivalente cubran las necesidades de apoyo detectado por el comité organizador. Toda la información relacionada con ello está disponible en la web de las jornadas.

Categories: OSGeo Planet

GIS for Thought: QGIS OpenStreetMap Scales

OSGeo Planet - Wed, 2018-06-20 09:00

Save as a text file ending in .xml like qgis_scales.xml

These are the scales OpenStreetMap tiles are rendered in for 96 dpi, so the map will look sharp on most monitors.

The xml file can then be loaded into the project from:

Project> Project Properties…> General> Project scales

<qgsScales version="1.0"> <scale value="1:554678932"/> <scale value="1:277339466"/> <scale value="1:138669733"/> <scale value="1:69334866"/> <scale value="1:34667433"/> <scale value="1:17333716"/> <scale value="1:8666858"/> <scale value="1:4333429"/> <scale value="1:2166714"/> <scale value="1:1083357"/> <scale value="1:541678"/> <scale value="1:270839"/> <scale value="1:135419"/> <scale value="1:67709"/> <scale value="1:33854"/> <scale value="1:16927"/> <scale value="1:8463"/> <scale value="1:4231"/> <scale value="1:2115"/> </qgsScales>


1,000,000 (QGIS default):

1,083,357 (OSM wiki):

1,155,584 (From: 3liz):

Scales from:
OSM wiki

Categories: OSGeo Planet

GeoServer Team: GeoServer 2.12.4 Release

OSGeo Planet - Wed, 2018-06-20 08:44

We are happy to announce the release of GeoServer 2.12.4. Downloads are available (zipwar, and exe) along with docs and extensions.

This is a maintenance release and a recommend update production systems. This release is made in conjunction with GeoTools 18.4.

Highlights of this release are featured below, for more information please see the release notes (,2.12.2, | 2.12-RC1 | 2.12-beta).

  • Add forceLabels=on in the style editor map legend to help users,
  • Remove language warnings during Windows setup compilation and remove ‘work’ folder when uninstalling on Windows
  • Move MongoDB community module to supported status
Bug Fixes
  • Response time of WMS 1.3.0 significantly higher than vs WMS 1.x.x on systems whose axis in north/east order
  • Exception with NULL values with AggregateProcess
  • Style with Interpolate function causes NullPointerException on GetLegendGraphic
  • WFS with startIndex doesn’t return some results
  • Vector identifying feature info uses an undocumented system variable to set the default search area
  • Removing extensions with own configuration bits may cause GeoServer not to start up anymore
  • Windows Installation issue – upgrading GeoServer results in corrupt data_dir
  • Class java.util.Map$Entry is not whitelisted for XML parsing.
  • Add WMS GetMap and GetFeatureInfo tests for App-Schema MongoDB integration
  • CatalogRepository cannot find a store by name, if the store has just been added
  • WCS 1.0.0 generates wrong links in GetCapabilities
  • CatalogRepository should return a null on store not found, instead it throws a RuntimeException
  • Layer page will only show up to 25 bands, regardless of the actual set of bands available
  • Undocumented GDAL 2.3.0 CSV output geometry column name change breaks WPSOgrTest
Security Updates

Please update your production instances of GeoServer to receive the latest security updates and fixes.

If you encounter a security vulnerability in GeoServer, or any other open source software, please take care to report the issue in a responsible fashion.

About GeoServer 2.12 Series

Additional information on the 2.12 series:

Categories: OSGeo Planet

gvSIG Team: New mailing list for gvSIG Developers

OSGeo Planet - Tue, 2018-06-19 11:05

A new mailing list for gvSIG Developers has been created, that replaces the previous one. This list will continue being the main contact point for English speaking developers to ask about any doubt or problem on gvSIG development (Java, Scripting…).

The previous mailing list was hosted in Joinup, but their support has been ended. Therefore, we have decided to migrate the mailing list to OSGeo.

The new mailing list is available here:

https://lists.osgeo.org/mailman/listinfo/gvsig-desktop-devel You can configure the mailing list to receive list traffic bunched in digests, or if you don’t want to receive the e-mails from the list you can choose that option at settings. Then you will be able to send the doubts to the list, and you can consult replies from


We also want to thank OSGeo for their offer to host the mailing list.

Categories: OSGeo Planet

GeoSolutions: Rilasciata nuova versione del profilo DCAT-AP IT per CKAN

OSGeo Planet - Tue, 2018-06-19 08:43


Dear Reader,

We apologize in advance, but this post is for our italian readers (hence in Italian only) to announce that we have finalized a new version of the DCAT-AP_IT Metadata Profile leveraging on the CKAN Open Data product.

Siamo lieti di condividere con voi le ultime novità che caratterizzeranno la nuova versione dell’estensione CKAN per il supporto al profilo applicativo DCAT-AP_IT. Come forse molti di voi già sapranno il profilo per la documentazione dei dati delle pubbliche amministrazioni (DCAT-AP_IT), reso disponibile dall’Agenzia per l’Italia Digitale (AgID), è nato con l’obiettivo di armonizzare i metadati con cui vengono descritti i dataset pubblici, al fine di migliorarne la qualità e favorire il riuso delle informazioni.

La prima versione, rilasciata ufficialmente nel Febbraio del 2017 e disponibile gratuitamente con licenza AGPL v3.0, fu sostenuta in uno sforzo congiunto dalla Provincia di Bolzano/Sud Tirol e dalla Provincia di Trento e fornisce ancora oggi un insieme valido ed eterogeneo di funzionalità non solo per la creazione guidata di datasets, ma anche per l’integrazione di metadati provenienti da sorgenti esterne (CSW, RDF, JSON-LD) in conformità al Profilo Applicativo. Sviluppata con scrupolosa attenzione alla stabilità delle sue caratteristiche funzionali, l’estensione ckanext-dcatapit, disponibile su una repository dedicata sotto il nostro account GitHub, nasce garantendo la più alta compatibilità possibile con le altre estensioni che spesso sono presenti nelle piattaforme CKAN. Anche gli aspetti legati al multilinguismo e la localizzazione dell’interfaccia sono stati affrontati e resi disponibili per garantire la massima usabilità da parte di quelle realtà che li necessitano, come per esempio le Provincie di Bolzano/Sud Tirol e Trento: l’estensione fornisce i propri files di localizzazione che aiutano a snellire eventuali personalizzazioni in questi termini, mentre l’estensione ckanext-multilang fornisce supporto per il multilinguismo dei contenuti presenti nel catalogo (dataset, organizzazioni, gruppi, risorse e altro).

Ad oggi non pochi sono i portali open data italiani che utilizzano questa estensione e tra questi si annoverano sicuramente:

  • Il portale OpenData della Provincia di Bolzano/Sud Tirol
  • Il portale OpenData del Trentino
  • L’infrastruttura federata OpenDataNetwork per il capofila Città Metropolitana di Firenze, che raccoglie e distribuisce i dati di vari enti toscani tra cui: Città Metropolitana di Firenze, Provincia di Prato, Provincia di Pistoia ed Autorità di Bacino dell’Arno.

Ma anche molti altri tra cui:

Grazie all’interesse mostrato dall’Agenzia per l’Italia Digitale (AgID) riguardo alle potenzialità e alle caratteristiche proprie di questa estensione, hanno avuto inizio alla fine del 2017 gli sviluppi per la realizzazione di una nuova versione arricchita e migliorata.

Gli sforzi di AgID nel finanziare questo progetto hanno avuto l’obiettivo di creare un unico hub di raccolta nazionale per i dataset pubblici basato su CKAN e fornire quindi, in un unico punto di accesso, le principali informazioni sui dati aperti esposti dalle PA locali e centrali (si fa in particolar modo riferimento al progetto DAF e la sua componente Dataportal).

Un insieme eterogeneo di funzionalità e peculiari caratteristiche sono state introdotte nella nuova versione per garantire non solo una più completa adesione al Profilo Applicativo, ma anche per aiutare l’utente nella ricerca dei datasets con nuove funzioni di indicizzazione e raggruppamento dei dataset stessi per regione di provenienza. È stato aggiunto dunque il supporto alla cardinalità multipla per le proprietà che la richiedono (come per esempio gli identificativi del dataset,  temi e sottotemi, autori e altre) e le funzionalità di catalogo sono state arricchite per identificare il catalogo e l’organizzazione di origine dei dataset  harvestati. In aggiunta, nuove facets saranno disponibili per filtrare i datasets per catalogo di origine, regioni e sottotemi.

[caption id="attachment_4152" align="aligncenter" width="800"]Nuove facet di ricerca disponibili nella schermata di ricerca Nuove facet di ricerca disponibili nella schermata di ricerca[/caption] Le caratteristiche proprie della form di creazione e modifica del dataset sono state migliorate offrendo delle mini guide di inserimento più dettagliate per l’utente, mentre il supporto al multilinguismo, offerto dall’estensione ckanext-multilang, è stato esteso anche ad altre proprietà, come per esempio rightsHolder, publisher, creator e conformsTo sia in harvesting che in serializzazione del dataset. [caption id="attachment_4153" align="aligncenter" width="800"]Scheda di dettaglio del dataset Scheda di dettaglio del dataset[/caption] La web form di creazione del dataset è stata inoltre ristrutturata attraverso un flusso di editing basato su macro ambiti di inserimento, per meglio indirizzare l’utente nella valorizzazione delle proprietà richieste dal Profilo. [caption id="attachment_4160" align="aligncenter" width="800"]Nuova form di modifica del dataset Nuova form di modifica del dataset[/caption] Anche i vocabolari controllati, primo tra tutti quello delle licenze, sono stati aggiornati e la nuova estensione ckanext-dcatapit metterà a disposizione un campo addizionale per la licenza a livello di risorsa del dataset. [caption id="attachment_4155" align="aligncenter" width="800"]Impostazione della licenza per la risorsa Impostazione della licenza per la risorsa[/caption]  

Anche il supporto al vocabolario controllato dei sottotemi, precedentemente mancante, è stato introdotto insieme al vocabolario controllato per la classificazione del territorio che consente l’associazione di una o più regioni italiane ad ogni organizzazione e facilitare quindi la ricerca dei datasets.

[caption id="attachment_4161" align="aligncenter" width="800"]Nuova form di modifica del dataset, selezione di temi e sottotemi Nuova form di modifica del dataset, selezione di temi e sottotemi[/caption]

Gli sforzi per la realizzazione della nuova versione si sono concentrati anche sul consolidare e accrescere le funzionalità di harvesting dei dataset con lo scopo sia di organizzare e catalogare al meglio i dataset raccolti ma anche di correggere, per quanto possibile, eventuali difformità nei dataset di origine (per esempio temi non conformi al Profilo Applicativo). Tra gli aspetti importanti riguardanti l’harvesting dei dataset troviamo anche i seguenti:

  • Migliorata la validazione dei tag in modo da gestire tag non conformi
  • Introdotto la mappatura delle licenze non conformi con quelle del vocabolario controllato aggiornato
  • Consolidamento delle funzionalità di harvesting già esistenti

Come ultimo punto, ma non per questo meno importante, lo sviluppo di una infrastruttura basata su Docker è stato messo a disposizione (attualmente ancora in fase di testing in vista del prossimo rilascio). Questo progetto, sviluppato in parallelo dal team di GeoSolutions, è disponibile sul GitHub Developers Italia e mette a disposizione tutto ciò di cui avete bisogno per ottenere rapidamente ed in pochi passi un’installazione completa di CKAN corredata dell’estensione ckanext-dcatapit.

Invitiamo tutti coloro che sono interessati a partecipare allo sforzo per lo sviluppo di questa estensione o che fossero interessati ad utilizzare questa estensione a seguire il nostro blog o iscriversi alla nostra newsletter; raccomandiamo di visionare anche i nostri pacchetti di supporto professionale GeoSolutions Enterprise Support Services nel caso si volesse usufruire di un supporto attento e qualificato per la messa in produzione di questa estensione. Allo stesso modo vi invitiamo a visionare le informazioni sugli altri nostri prodotti Open Source quali GeoServerMapstore, GeoNode e GeoNetwork.

The GeoSolutions team,
Categories: OSGeo Planet
Syndicate content