Chaos Computer Club - archive feed

Comet Time Series (CometTS) is an open-source tool that facilitates analysis and visualization of satellite imagery time series. Such analysis can enable population estimation research, change detection methods, or natural disaster monitoring. Historically, analyzing large time series of satellite imagery was achieved using proprietary GIS tools or by time-intensive methods requiring substantial geospatial expertise. CometTS requires only a web browser, Python, and dependent packages to function, obviating the GIS requirement for time series analysis and visualization. CometTS provides a partially automated approach for analyzing a time series of satellite imagery in any user defined area of interest, then calculating relevant statistical quantities (e.g., measures of central tendency and variation), and visualizing their changes over time, all in a matter of seconds. The overall focus of this talk will be on the development and application of CometTS for two analyses: 1) analyzing dynamic population changes over time in Africa and the Middle East and 2) ccreating the first independent estimate of the number of persons without power over time in Puerto Rico following Hurricane Maria. None about this event: https://talks.2019.foss4g.org/bucharest/talk/A8W7SM/

When disaster strikes developing countries, a lack of geographic data is often a hindrance to first response and relief operations. To address this lack of geographic data, remote mapping and especially mapathons have played an important role in collecting geographic data in OpenStreetMap (OSM) that can be used to plan activities in areas effected by disaster or other humanitarian efforts. During mapathons, volunteers from various backgrounds get together to map a specific area using satellite imagery or aerial photographs. The expertise and motivation of these volunteers generally differ. Even though the geographic data in OSM is invaluable in cases where little to no data is available, the quality of the data collected during mapathons is often questioned. In this paper, we present our results from an evaluation of university students’ motivation for participating in mapathons and their productivity (i.e. how much data they contributed). To achieve our aim, we hosted four mapathons for final year university students where the participants were asked to complete a short questionnaire to determine their motivations and personal opinions of the mapathon. Afterwards, the productivity for two mapathons were evaluated. Final year students enrolled in a geoinformatics module were offered extra credit for participating in the mapathons. As a result, the majority of the students participated in all four mapathons and the answers did not differ significantly between the four mapathons. One of the main reasons mentioned, apart from extra credit, was that the participants felt a sense of humanitarianism through contributing to communities in need by assisting. Additionally, the social aspect also came through with a large percentage of the participants indicating that mapathons are fun and that they learned something new, for example by improving their digitizing skills or that humanitarian organizations need help. Participants also indicated that the tools (i.e. OSM and iD editor) were easy to use, but that the imagery is sometimes not good enough due to cloud coverage. The general productivity for two mapathons was evaluated and we found that with more experience the participants were generally more productive. A further step was taken by investigating five individuals productivity. It was clear that their productivity increased, and that they made fewer errors during the subsequent mapathons. The results from this evaluation provided insight and knowledge that could assist mapathon organisers to create a more productive environment for participants with the hopes of encouraging them to produce high quality data. The feedback from students was clear that if they receive information about the aim of a mapathon and why the data is important, they are more motivated to produce high volumes of quality data. None about this event: https://talks.2019.foss4g.org/bucharest/talk/THMVYS/

The sheer amount of statistics collected as the world entered the age of Big Data transformed computers from simple tools for processing data into complex machines able to present the results of this processing as compelling visuals with little to no human input. And when it comes to presenting the evolution of phenomena that vary in space and time, there is no better solution than a map. As part of a project involving a major institutional client, we developed a FOSSGIS-based custom spatial visualisation widget for use with Microsoft’s PowerBi. Integrating with an environment that includes a plethora of graphical representations for data, the developed widget, built on top of OpenLayers, provides a novel view of data with spatial characteristics. Unlike the default map widgets, it allows the use of custom, time-enabled geometries, as well as custom basemaps, consumed using open standards (GeoJSON, WMS), custom projections (with Proj4js), feature zoom across the International Date Line and complex visualisation using charts on top of choropleth maps. We thus show the advantages of using open-source GIS technology on top of proprietary frameworks, providing advanced, project-specific features supported by a wide community. None about this event: https://talks.2019.foss4g.org/bucharest/talk/A9LKYS/

The ingredients are existing data that may or may not have a spatial component, your understanding of said data at your disposal and finally PostGIS and the bevvy of functions that it ships with. No need to venture into the kitchen or even ignite your stove; 'Cooking' here refers to the practice of using select bits of data from an experiment to get results that you should be getting, even if your experiment is going awry. There are times when you need spatial data for a given purpose, but sending a team out into the field is not practical given existing constraints. In cases where accuracy need not be sub decameter then there are ways and means to generate spatial data for visualization purposes that can be just good enough. PostGIS has a plethora of functions to help you get to that point of having spatial data that is just good enough, especially for visualization. In this talk, I will show how, for real instances, PostGIS was used to generate the data needed and how in some cases, the data was spatially accurate to within 10 meters. None about this event: https://talks.2019.foss4g.org/bucharest/talk/JULQSH/

Manual polygon digitization on maps by non-gis people creates possibility to encouter with topology exceptions and user mistakes like holes, slices and so on. We used solution to build blocks grid over Estonia so whole country is covered with various size of blocks based on versatile information like cadasters, roads and addresspoints. Result is massive arrays of relations between blocks identificators and areas. This solution creates one geospatial layer with more than million block identificators which can be used by multiple datalayers. If one block changes then all datalayers where this block were used, are affected. It offers us to discover areas which are not covered or areas which are overlapping each other. In presentation I will talk about why this idea came up, how we created block grid from data we had, how we choosed technology to build whole system and how we succeed in result. Technologies in presentation includes OpenLayers, React, Redux, GeoServer, PostgreSQL, PostGIS, Mapbox Vecor Tile, OGC Standards WFS-T, WMS, SLD and many more. None about this event: https://talks.2019.foss4g.org/bucharest/talk/XRWMPM/

In the Czech republic and countries in the central-east European region, the market share of the open source software for geospatial is on very slowly ascending curve. We asked a question, what is the market missing, so that the acceptance of the FOSS4G software could be done in much faster way? We came into several conclusions: * Public administration does miss technical support * Both do need training courses, to pass her required set of skills as fast as possible * Current status of the FOSS4G software is still relatively diverse and the interoperability in some fields is unsatisfied, even though it's already manageable Helping the FOSS4G software to grow into public administration organisations as well as into private sector, we started to work on an ecosystem, where users will find * Training capacities * Technical support * Single point of contact for the development communities This talk is about history of building the ecosystem in the region of the Czech republic, about activities of GISMentors open training initiative and what we do for the ecosystem to grow. Several numbers will be presented about the market and it's development during last five years. None about this event: https://talks.2019.foss4g.org/bucharest/talk/JRGZAG/

See that little map on the geoserver.org web site? While looking a lot like plain OpenStreetMap tiles, it’s actually rendered by a GeoServer, using CSS styles, off a PostGIS database. The map aims to be a very close clone of the actual OSM official one, meaning it has a lot of little details often removed from lookalikes to reduce the data to be loaded and rendered. This presentation will provide a little history of its development, the performance added to speed up its rendering, a good look at the styles styles used, and the overall setup and the of the GeoServer, both in terms of physical deployment, configuration and tuning. Finally, we’ll show an alternative setup and map, still working on GeoServer, but based on styles and data from the OpenMapTiles project. None about this event: https://talks.2019.foss4g.org/bucharest/talk/YELW78/

The assessment of renewable energy potentials in urban environments gained a lot of interest in the recent decades due to CO2 reduction goals by cities, national policies as well as directives by the EU. In combination with advances in data creation and processing as well as the definition of standards like CityGML, new ways of modeling urban potentials have been developed. This lead to numerous approaches estimating roof-top solar photovoltaic (PV) production. However, in recent years due to research in building materials, the façades became more attractive and feasible for PV electricity production. This paper describes results on the development of an completely FOSS-based approach to assess the electricity production potential by building façade PV. To estimate solar irradiation we followed the hemispherical viewshed approach described by Fu, 1999. Combining it with an approach to dissect walls into regular 3D point grids (1 meter spacing) we calculate the sun visibility (each hour) and the sky viewshed throughout the year. This results in direct and diffuse irradiation for every wall point. To generate the electricity potential, the irradiation values are summed up for the wall points and are fed into an economic model. This is driven by technical parameters of the installation, such as module efficiency, installation and maintenance costs, figures about payback tariffs and envisaged module lifetime. The overall result is a city-wide PV suitability and electricity production potential map of every building façade. The processing is based on a city model in the CityGML format using the 3DCityDB database and the spatial processing functionalities of PostGIS. A set of Python scripts has been developed as a central control instance. The scripts control the processing of direct and diffuse irradiation as well as clear sky irradiation relying on the external “pvlib” Python library. Furthermore, we use the scripts to manage parallel processing of queries against the database to achieve scalability and improved performance. The parallelisation is done by processing single building walls. We run a case study with approximately 7000 single wall elements to process. We identified so far one of the major bottlenecks of the approach. This are the calculations of sun visibility for every wall point per timestamp (intersection with surrounding buildings) which takes per wall several minutes to process depending on the number of points per wall. Since we implemented a parallel processing of the walls running on a 80-core dedicated server machine, the completion for an entire city of 3 million wall points uses a decent amount of time for the given size of data set. Here we describe a scalable and highly parallelised approach which can be easily implemented through standard tools and libraries. This open up now for distributed approaches using multiple database servers for even better scalability. None about this event: https://talks.2019.foss4g.org/bucharest/talk/RYCCWV/

We would like to present how our small community of Geoinquiet@s Argentina works. Since 2012 we have been working hard in order to evangelize about free and open source software. Drawing inspiration, and a name, from the Geoinquietos Spain micro chapter a few people started gathering (beer in between) to spread the word about free tools for geomatics. Since then, we have been able to do four conferences, some together with the OpenStreetMap (OSM) community. Recently we became an official OSGEO local chapter (the first constituted in Latin America). In order to keep growing, we have set up an nonprofit organization (Geolibres), to serve as a legal support not only for Geoinquiet@s, but also for OSM Argentina or GeochicasOSM. We propose the bid of Buenos Aires as the location for the 2021 main FOSS4G event, because we believe it would be a great opportunity for the entire region, creating new chances for exchange between key actors in the world of free and open geomatics. Our commitment is for more conferences, workshops and other projects that infect the spirit of free and open source software in more people, communities, companies, organizations and universities every time. None about this event: https://talks.2019.foss4g.org/bucharest/talk/K93FD7/

<p>A common question seen on many open source mailing lists is “When will you guys fix my bug? It is critical to my company!” This is often followed by one of the developers replying to say “When you write a fix or pay someone to do it”. This leads to the user complaining to everyone that this “snarkiness” is not a “welcoming” response or how unreasonable it is to expect them to learn to program, or to pay. The discussion often descends into a rambling maze of twisty insults and justifications. When the fuss dies down, all the developers go back to doing what they the were doing (something useful) and the user becomes either a dissatisfied user or an ex-user. This talk by two veteran open source developers will help users see that play out from our the developer point of view. We’ll look at the reasons that drive developers to share their code, the licencing conditions covering it, the real life of developers and associated constraints, and what is actually reasonable to expect from both sides. None</p> about this event: https://talks.2019.foss4g.org/bucharest/talk/D9MXGV/

QGIS - like Geoserver, Mapserver and all the great OSGEO project - do no longer need to prove they can do the job. We now have millions of users, with great expectations, growing budgets and growing communities. Still we lack funding for boring tasks : packaging, bugfixing, documentation, QA and marketing needs some love. **What about changing minds and stop saying open source does not cost anything ?** Could that solve this situation where countries having most users also have the less contributors ? This talk will take profit of real life examples of big corporations that decided to pivot their approach from "using open source" to "embrace Opensource". Let's get out of our technical comfort zone and expose ourselves to enlarge our contributors' base. This is a **deeply optimistic** talk looking right into the eyes of what we need to improve, as an opensource ecosystem ! None about this event: https://talks.2019.foss4g.org/bucharest/talk/7WCC7G/

Open data and publicly available satellite imagery are transforming how cities can prepare for disaster and climate risks and strengthen urban resilience. In this talk, we present a data-fusion approach that utilizes free satellite imagery (Sentinel-1 and 2) to identify flood prone areas in developing cities. The approach, which is fully automated, relies on SAR (Sentinel-1) and optical data (Sentinel-2) to identify and map urban areas that have been prone to flooding in the last 5 years. None about this event: https://talks.2019.foss4g.org/bucharest/talk/VSLZ8T/

Putting together a conference is a huge amount of work, but one that can reap ongoing benefits for the community that makes it happen. Creating one from scratch is a scary thing, but this is what we attempted to do for Oceania in 2018. In the spirit of openness, we'd like to share what we as a region learned as well as the next steps. We'll cover the forming of a conference committee, preparing and running a conference, and creating a sustainable entity and momentum once the conference is over. We're also going to shamelessly promote FOSS4g SotM Oceania Wellington, 12-15 November 2019. None about this event: https://talks.2019.foss4g.org/bucharest/talk/MCCYR9/

How do you find one pixel in a billion? Cloud Optimized GeoTiffs are a new standard for raster data that support file-level access via the internet. Combined with serverless cloud technologies, raster data can now be queried by client-facing applications without the need for a spatial database or specialist server software. In this talk I present how we used COGs and serverless to build a fast and scalable application to query large raster data using point and polygon geometries. As well as providing an overview of the solution architecture, I’ll explore the challenges we face with large raster data and why we chose to develop the solution using these open source standards and technologies. None about this event: https://talks.2019.foss4g.org/bucharest/talk/SQF7YK/

If a company discovers GIS as a usefull tool, it normally starts with a few desktop GIS (most likely QGIS) users. Later on, if GIS is more widely used within the company, the need for a spatial data infrastructure (SDI) arises. This presentation shows how to step-by-step create a slim SDI around QGIS, which other software components can be used, their advantages and disadvantages and how they play together with QGIS. None about this event: https://talks.2019.foss4g.org/bucharest/talk/F8NTTR/

It is widely known that China will soon be the leading player in world economy overtaking the traditional hubs of North America, Europe and South-East Asia. Its economic activities increasingly influence countries beyond its own borders and dominate global economic growth. The analysis of the shifting axis uses global trade data that countries report through the Harmonised Commodity Description and Coding System (HS-Codes). The shift of power towards China is evident when the spatial mean of some 220 globally traded commodities is calculated for which data is available. Other geo-(statistical) indicators further quantify and visualise China’s growing economic power while other economic centres cannot keep up with this pace or even decline in importance. None about this event: https://talks.2019.foss4g.org/bucharest/talk/MRTSMJ/

GeochicasOSM is a community of mainly Spanish-speaking women, from Latin America and Spain, work mapping OpenStreetMap (OSM) and Wikipedia, and related to the geo world and geotechnologies, which work with the goal of closing the gender gap in different communities in which they participate through joint and collaborative projects and initiatives among women. The group was created at the 'SOTM LATAM 2016' Conference in São Paulo (Brazil) and there are currently users in at least 20 countries around 3 continents. The co-founders are Selene, Céline and Miriam, and are based in Mexico and Paraguay. Among its diverse and varied projects, with the common nexus of making women visible, the following can be highlighted: Survey on gender in the OpenStreetMap community; Training spaces; Preparation of maps with different topics with women as focus point; The Violet Streets; Women Mapping the World; The streets of women, which emerged in the framework of International Women Day and it wants to give visibility to gender disparity that exists in the nomenclature of streets while creating collaboration between both communities, GeochicasOSM and Wikipedia, and the show on the roles of women historically and their socio-cultural contributions. None about this event: https://talks.2019.foss4g.org/bucharest/talk/TA7H7D/

ECMWF is an operational centre, producing global numerical weather predictions. ECMWF also operates many services for the EU Copernicus programme . ecCharts is a suite of web based services to visualise and explore ECMWF real-time forecast. The service offers a Web Map Service (WMS) as well as an interactive client application which provides forecast data for meteorological community including Copernicus services. Recent development work involved the replacement of the client application with OpenLayers and implementing a caching system with MapProxy. This posed many challenges due to size and frequent updates of the data, combined with the challenges of offering a fast and smooth user experience. The work also resulted in contributions to open source projects, like OpenLayers, which will benefit the wider user community. This talk presents the benefits of moving to open source community software,the architecture of the updated system and on the challenges and the solutions that are taken when dealing with big and dynamic data sets both at the frontend and at the backend services. None about this event: https://talks.2019.foss4g.org/bucharest/talk/VDZN33/

An overview of GNOSIS CMSS, a styling language for both classic and 3D cartography. Ecere developed the GNOSIS Cascading Map Style Sheets language in conjunction with the OGC Innovation Program's Tetstbed 13 and 14, and the open specifications for it are available in a public Engineering Report: http://docs.opengeospatial.org/per/18-025.html#StylingModel Key features of GNOSIS CMSS include cascading of styling rules and sheets, any symbolizer value can be a complex expression, and a concise and clear syntax. None about this event: https://talks.2019.foss4g.org/bucharest/talk/YBSWUW/

Lizmap is an open-source application to create web map application, based on a QGIS plugin and a Web Client. The project started in 2011 and the 3rd version has been published in 2016. In 2019, the project has to be adapted to QGIS 3. We will present the state of the project, the connected projects as mapbuilder module and extension scripts, and what is coming in the future. None about this event: https://talks.2019.foss4g.org/bucharest/talk/YFKHGP/

Vector tiles are an established format to publish highly interactive maps for use on mobile devices and desktop browsers. A benchmark compares MVT tile generation and tile serving performance of specialized servers like t-rex and proven map servers like UMN Mapserver. None about this event: https://talks.2019.foss4g.org/bucharest/talk/VUHLFF/

In a disaster or humanitarian relief context, time obviously matters. This talk will show how, without concern for the details of servers and storage, you can use small amounts of code to quickly build powerful solutions, using a prototype disaster response pipeline as an example. None about this event: https://talks.2019.foss4g.org/bucharest/talk/ZFWFG9/

The Copernicus data provided on a free, full and open access basis are an invaluable asset for both established and new businesses. EU funded projects such as e-shape and PARSEC aim to support developers and entrepreneurs through solid access to knowledge, technology, capital and markets. e-shape endeavours to build capacity across the whole value chain for the exploitation of EO data and services as well as to boost application sustainability. PARSEC, a holistic acceleration programme, aspires to provide start-ups and SMEs with the necessary resources to develop and launch their own EO based ideas into the market. None about this event: https://talks.2019.foss4g.org/bucharest/talk/WLWCE8/

With Foreign Data Wrappers (FDW) you can access remote objects from SQL databases. This feature is part of the SQL/MED (SQL Management of External Data) specification that was added to the SQL standard. With PostgreSQL you can make use of this great functionality. You can access different remote datasources via FDW for example an ORACLE or MySQL database, JSON- or CSV-file, sources via ODBC and even twitter. The list of FDW is very long: https://wiki.postgresql.org/wiki/Foreign_data_wrappers There are also Geospatial Wrappers for GDAL/OGR, GeoJSON and OpenStreetMap. You can access your geospatial data for example geopackage or OGC WFS via FDW. That is easy and great fun. Some of the wrappers support only read others support read/write access. The presentation will give an overview on the possibilities of Foreign Data Wrappers and show how to setup a connection to remote data using some examples with geospatial data. None about this event: https://talks.2019.foss4g.org/bucharest/talk/TYUYZC/

The figure of the Earth can be modelled either by a cartesian plane, a sphere or an (oblate) ellipsoid, in decreasing order with respect to the approximation quality. The shortest path between two points on such a surface is called a geodesic. Studying geodesic problems on ellipsoids dates back to Newton. However, the majority of open-source GIS systems today use methods on the cartesian plane. The main advantages of those approaches are simplicity of implementation and performance. On the other hand, those approaches come with a handicap: accuracy. We experimentally study the accuracy-performance trade-offs of various methods for distance computation (as well as similar geodesic problems such as azimuth and area computation). We test projections paired with cartesian computations, spherical-trigonometric computations and a number of ellipsoidal methods such as [Andoyer'65] and [Thomas'70] formulas, [Vincenty'75] iterative method, great elliptic arc's method, and [Karney'15] series approximation. We also show that some methods from the bibliography (e.g. [Tseng'15]) are neither faster nor more accurate compared to the above list of methods and thus become redundant. For our experiments we use the open source libraries Boost Geometry and GeographicLib. Our results are of independent interest since we are not aware of a similar experimental study. More interestingly, they can be used as a reference for practitioners that want to use the most efficient method with respect to some given accuracy. Geodesic computations (such as distance computations) apart from being a fundamental problem in computational geometry and geography/geodesy are also building blocks for many higher level algorithms such as k-nearest neighbour problems, line interpolation, densification of geometries, area and buffer, to name a few. # References * Some experimental results can be found here: https://github.com/vissarion/geometry/wiki/Accuracy-and-performance-of-geographic-algorithms * A related talk (with some graphs on performance and accuracy) can be found here https://fosdem.org/2019/schedule/event/geo_boostgeometry * The source code of most of the algorithms of the study is in Boost Geometry: https://github.com/boostorg/geometry but we contain to our study GeographicLib https://geographiclib.sourceforge.io None about this event: https://talks.2019.foss4g.org/bucharest/talk/TANLXN/

We started working on BIM (Building Information Model) and GIS integration in 2016. At that time, as one of the results of EU funded research project [DIMMER](http://www.drawingtothefuture.polito.it/projects/dimmer/), we [linked](http://2016.foss4g.org/talks.html#140) the simplified representations exported from BIM to the urban environments in Turin, Italy and Manchester, UK. Since 2016, our work on GIS and BIM integration has steadily [progressed](https://webthesis.biblio.polito.it/6408/). Nowadays, the Municipality of Turin uses the successful integration of GIS and BIM objects for internal facility management of thirty public owned buildings in Turin. Adopting the [3D Tiles](https://github.com/AnalyticalGraphicsInc/3d-tiles) OGC standard, we stream and render online the full BIM and photogrammetric reconstruction of Turin buildings and monuments. Also, using open source tools and open data, we extend the value of digital BIM through visualisation and integration with available cartography. This allows us to fully benefit of BIM potentiality in terms of data and object management. Furthermore, we display our maps and models using open source virtual globes, an easily accessible environment. None about this event: https://talks.2019.foss4g.org/bucharest/talk/3EDL7D/

During the last decades, many climatic parameters are more and more deviating from the average according to the mean values registered since consistent weather observations are available. The World Meteorological Organization (WMO) stated that the 2015, 2016 and 2017 years were the warmest since 1850 [1]. This trend is going to be confirmed in 2018 according to the preliminary data analysis of the last year. Drought events will likely occur more frequently or with an higher intensity either in Europe and in Asia [2,3]. Sri Lanka is not an exception, the norther-east area is already facing long period with very few precipitation events. Drought has multiple impacts on environmental and socio-economic aspects such as water resources management, human lives, energy consumption and many others. This climatic scenario highlights the importance of the development of monitoring systems to support the management of the drought risk. The 4onse project (analysis of Open, Non-conventional, Sustainable and Effective monitoring systems), funded by the Swiss National Science Foundation (SNSF), aims to evaluate “non-conventional” Environmental Monitoring System (EMS) based on open technologies both hardware and software. At this state of the project, after developing and validating the prototype [4], 30 weather stations have been deployed in the Deduru Oya Sri Lankan basin and collecting the basic weather parameters (air temperature, humidity, pressure, accumulated rain, wind speed and wind direction). The system can help developing and low-income countries in coping the lack in the monitoring and management of natural hazards. In fact, thanks to the collected data, it is possible to elaborate some drought indexes which help in evaluating the intensity of the dry periods. The Standard Precipitation Index (SPI) has been selected as principal indicator to evaluate droughts. The SPI has been calculated integrating the data collected by the 4onse stations together with the Climate Hazards group Infrared Precipitation with Stations (CHIRPS) dataset. In this paper, the authors present the results of the methodology used and the proposed system to share the information that are useful to better take mitigation actions in time. [1] WMO WMO statement on the state of the global climate in 2017; 2018; ISBN 978-92-63-11212-5. [2] Spinoni, J.; Vogt, J.V.; Naumann, G.; Barbosa, P.; Dosio, A. Will drought events become more frequent and severe in Europe? International Journal of Climatology 2018, 38, 1718–1736. [3] Guo, H.; Bao, A.; Liu, T.; Jiapaer, G.; Ndayisaba, F.; Jiang, L.; Kurban, A.; De Maeyer, P. Spatial and temporal characteristics of droughts in Central Asia during 1966–2015. Science of The Total Environment 2018, 624, 1523–1538. [4] Strigaro, D.; Cannata, M.; Antonovic, M. Boosting a Weather Monitoring System in Low Income Economies using Open and Non-Conventional Systems: Data Quality Analysis. Sensors 2019, (accepted). None about this event: https://talks.2019.foss4g.org/bucharest/talk/MLUXMW/

This is the closing ceremony of FOSS4G2019 Bucharest! None about this event: https://talks.2019.foss4g.org/bucharest/talk/A9PQLB/

During the last years, a Borehole Data Management System (BDMS) has been developed by the Federal Office of Topography of Switzerland (Swisstopo). To facilitate the data exchange procedure, a standalone application built with closed source software is used, but this approach starts to feels too hard working by the users and recently an increasing number of partners start asking for a web-based solution. To fulfill this demand, we developed a new Web Application Prototype, sponsored by Swisstopo, using the latest Free and Open Source Technologies. The new application integrates some of the today’s best OSGeo projects and will be available (summer 2019) as a modular open source solution on GitHub and ready to use in a docker container available on Docker Hub. Through two types of authorization, *Explorer* users are able to search the BDMS for specific boreholes, navigate a configurable user friendly map, apply filters, explore the stratigraphy layers of each borehole and export all the data in Shapefiles, CSV or PDF. *Editors* are able to manage in details the informations and publish the results after passing a validation process. None about this event: https://talks.2019.foss4g.org/bucharest/talk/YSET9H/

Social media have shown significant contribution in disaster reliefs. It could be very valuable source of the on-site information shared by the affected citizens. Particularly, Twitter is currently one of the most popular social media used for the exchange of information connected to the disasters. If this type of source is considered as a real-time crowdsourcing of crisis information, the spatial distribution of geolocated tweets related to an event can represent an early indicator of the severity of impact. This raises a question if rapid mapping teams could use additional information from Twitter before mapping. Would it be possible to estimate the outcome, to understand the affected zones and approximate level of impact? The aim of this paper is to explore the spatial distribution of the Twitter posts related to a disaster and to analyse their potential in providing fast insight regarding the impact. The focus of the analysis was on the tweets related to the hurricane Michael that happened in Florida, in the United States on October 2018. The crisis maps produced by Copernicus Emergency Management service were used as reference data and obtained results were compared with them. Copernicus EMS have produced twenty-five delineation maps over the coast of Florida. Six maps were delivered on the 11th of October and the rest of crisis maps were published on the 12th of October. The focus of this study is to explore the potential of Twitter’s crisis posts in providing information before the delivery of maps. The available message dataset consisted 8169 tweets posted from 10th until 15th October. The tweets published before the delivery of crisis maps that are inside of the crisis maps’ area, in total 30% of the available dataset, were analysed. Weights have been assigned to each tweet, on a base of the date of posting; i.e. newer posts were considered as more relevant. Spatial statistics have been performed with QGIS and GeoDa. For example, the QGIS plugin Hotspot was used to identify where statistically significant spatial clusters were present, more precisely, the zones with significant concentration of relevant posts were corresponding to areas with high impact of the hurricane. Comparisons of the results with the reference data have been performed and discussed, showing the potential value of these data for crisis mapping. None about this event: https://talks.2019.foss4g.org/bucharest/talk/CVUY3C/

PostGIS is a spatial extension to PostgreSQL database. This year it gets new major release, 3.0, after seven years of being in 2.x. We'll go deeper in what was changed, and why you will want to bring these changes into your setup as soon as possible. None about this event: https://talks.2019.foss4g.org/bucharest/talk/ARZPPE/

The European Flood Awareness Ssytem (EFAS) operates on a pan-European scale to provide coherent medium range flood forecasts and related informations and which serves as an independent reference information set for most of the hydrological services responsible for flood forecasting in Europe. EFAS was developed from the Joint Reaserch Centre (JRC) and the European Centre for medium range weather forecsts (ECMWF). EFAS provides information to the national hydrological services when there is a danger that critical flood levels might be excedeed. EFAS displays the results of the flood forecasts through a web application that grants end-users the ability to contribute and share information. A part of information provided by EFAS is restricted to the EFAS users (real time forecasts), non real time forecasts are freely accessible for all the users. Though the EFAS interface flood warnings emails are send the the EFAS partners in order to inform them of a possible upcoming event. There are strict criteria on the activation and deactivation of these warnings. Alongside the alerts a daily overview is sent to the Emergency Response Coordination Centre (ERCC) of the European Commission which contains information on ongoing floods in Europe None about this event: https://talks.2019.foss4g.org/bucharest/talk/YQRTP7/

<p>Most real world features can be presented as vector or raster layers. In open source world, GDAL provides a comprehensive set of tools to interact with such datasets. But vector or raster is not always a suitable description of real world features. Data from oceanography, metrology, hydrology, etc often have multiple components at each location on an irregular structured mesh. A **mesh** can a collection of vertices, edges and faces in 2D or 3D space: - vertices - XY(Z) points (in the layer's coordinate reference system) - edges - connect pairs of vertices - faces - sets of edges forming a closed shape - typically triangles or quadrilaterals (quads), rarely polygons with higher number of vertices  Mesh gives us information about the spatial structure. In addition to the mesh we have **datasets** that assign a value to every vertex. For example, ice cap thickness at particular moment of time. A single file may contain multiple datasets - typically multiple quantities (e.g. water depth, water flow) that may be varying in time. None</p> about this event: https://talks.2019.foss4g.org/bucharest/talk/XD8EZL/

OSGeoIE was formed in 2015 and this year we held our 3rd annual conference. In our mission statement we aim to "create a networked community of OSGeo/FOSS4G users, developers, practitioners, teachers, advocates, etc in Ireland". Our talk will discuss experiences since 2015: Developing a shared understanding of community participation in OSGeoIE events, how to be effectively resourced as a local community, attempts to establish a more coordinated approach to communication and learning between partnerships, governmental agencies, industry and other software communities and how participation in OSGeoIE make a difference for volunteers and OSGeo/FOSS4G users and advocates? There is increasing cross discipline/domain interest in QGIS with particular interest in QGIS from local government authorities. We have also worked on building strategic and synergistic links with other similar communities such as OSM IE and Python IE. The academic community are actually under-represented at our events. We are interested in hearing feedback from FOSS4G delegates on their experiences of building an OSGeo community in similar sized countries and regions. We also hope to provide inspiration to anyone thinking about setting up a local chapter. None about this event: https://talks.2019.foss4g.org/bucharest/talk/AFRCHM/

This is the AGM of OSGeo. None about this event: https://talks.2019.foss4g.org/bucharest/talk/7AWSAW/

The talk will present case architectural solutions behind a cloud platform for Asset Management. The platform manages geo-spatial information and provides analytics services and tools for critical assets and infrastructures monitoring, for customers and prospects worldwide. The huge amount of geo-spatial data to be managed required us to rely on a cloud-based distributed architecture, based on open-source big-data management solutions. In particular, we defined a Docker container-based distributed infrastructure, using Geomesa and Accumulo. The talk will delve into details of architecture and strategies used to ingest, store, indexing, and analyzing the geo-referenced data, for optimal performance in terms of concurrent content delivery to multiple web clients world-wide, each acting on a set of Areas of Interest. Case studies will be presented to show the value of the proposed solution, in terms of user experience and real-time processing capability. None about this event: https://talks.2019.foss4g.org/bucharest/talk/ZSNF3C/

This talk will provide an analysis of U.S. caselaw regarding self-replicating technologies, such as open source code, and patent exhaustion rights. It will discuss what it currently means to "sell" a "product" sufficiently to invoke patent exhaustion, and how that corresponds to the normal ways in which organizations typically interact with FOSS. None about this event: https://talks.2019.foss4g.org/bucharest/talk/STYGFY/

Open source satellite imagery becomes increasingly important in many areas of research and business. In the case of agriculture, it is being used to assess land use, support subsidies, and to help farmers to manage their land more efficiently. Many of these applications require regular revisits to best catch temporal the variety that defines many land uses. Cloud cover can be a serious issue, often obscuring the majority of images acquired from passive sensors. Filtering an area of interest for cloud free images, can be labour intensive or lead to loss of valuable input data. Here we introduce a Python tool developed using open-source packages that will assess user defined areas of interest against supplied cloud masks for three satellite platforms: ESA’s Sentinel-2 (Level 1C products), NASA’s Landsat-8 (Level 1C and SR products) and the joint CNES and ISA platform Venµs. We present a case study from County Meath, Ireland to assess the number of cloud free Sentinel-2 images identified for fields surveyed in the EU Land Use/Cover Area Frame Survey (LUCAS) and compare it to the number of images that would have been obtained by threshold filtering images. None about this event: https://talks.2019.foss4g.org/bucharest/talk/RQFEJA/

For almost 5 decades, ECMWF, the European Centre for Medium-range Weather Forecast, has been producing numerical weather forecasts and maintained one of the largest archives of meteorological data. Recently the European Commission has entrusted ECMWF with the implementation of the Copernicus Climate Change Service (C3S), and Atmosphere Monitoring Service (CAMS), opening up the access to a huge amount of environmental data. ECMWF has a long experience to decode, manipulate and visualise GRIB and NetCDF data. This talk will present how with the help of community open source tools users can more easily explore these large datasets. But even if users have the right tools and knowledge to manipulate the data, the amount of data to transfer is still a bottleneck. It is why ECMWF embarked in various projects to build and use cloud environments. One of these is the EU-funded Horizon 2020 HiDALGO project, which explores the building of workflows using these tools over various HPC and cloud environments. Open source plays again a vital role to make this happen. First findings of this exciting new work will be presented in this talk. None about this event: https://talks.2019.foss4g.org/bucharest/talk/GKRMUY/

TEAM Engine is a testing facility enabling developers and users to test geo services, such as WFS or WFS, and geo formats, like GML or GeoPackage. The Open Geospatial Consortium (OGC) provides various test suites for TEAM Engine to support implementing and testing of GIS software basing on OGC standards. TEAM Engine is an OSGeo project in incubation phase. A test suite for new OGC standard WFS 3.0, which is currently a candidate standard (status of April 2019), was developed as part of OGC Testbed 14 initiative. As this standard uses completely different concepts in comparison to, for example, WFS 2.0, several conceptional questions had to be discussed and solved during implementation of test suite. This talk presents how the new OGC standard WFS 3.0 can be validated with TEAM Engine. The process of creating a new test suite as part of OGC Testbed 14 initiative is highlighted. This includes a short introduction of WFS 3.0 standard itself. Further, current developments in TEAM Engine project are presented and an outlook is given. None about this event: https://talks.2019.foss4g.org/bucharest/talk/FK79AX/

The SoDUCo is a research project proposes to develop methods and models to study the evolution of the urban spatial structure in relation with social and professional practices. It allows the qualification of geo-historical sources (maps, directories, etc.), the semi-automatic extraction of the information and their (spatio-temporal) matching. Software components are all open-source and produced datasets are free to reuse. The reconstitution of the evolution of Paris from 1789 to 1950 will be done by using two specific sets of sources: master maps (datasets mainly from the BnF (French National Libray)) and the complete series of cadastral maps which describe the evolution of road networks and urban fabric and, for the same time period, street & trade directories, which provide the socio-professional activities aor status of people localized by their addresses. This talk will show how partners (French National Institute of Geographic and Forest Information (IGN), EHESS, National Archives and EPITA ) will build the final product of the SoDUCo project consisting in the first unified, distributed, reusable and interoperable platform to handle geo-historical sources. We will also show how we animate this cross-domain project. None about this event: https://talks.2019.foss4g.org/bucharest/talk/GJXH3P/

The Copernicus Global Land Service (CGLS) aims to provide yearly-updated land cover maps, including land cover fractions (i.e. the fraction of each land cover class within each pixel). It makes use of FOSS software (Python, R, GDAL) for all data processing steps. Our work in the project focuses on two aspects: land cover fraction mapping at the continental level (Africa) and yearly map updating. For land cover fraction mapping, to select the most appropriate method, a number of machine learning algorithms were run on over 300 covariates: Proba-V image time series (100m, 4 bands), DEM, soil and climate properties. Random Forest performed the best with RMSE=16.6, MAE=9.2, and 68±4% overall accuracy. To generate yearly map updates, we investigated different vegetation indices and break detection methods, as well as their scalability to big data (MODIS time series, 2009-2019). All change detection methods tended to overestimate change. Proba-V Mission Exploitation Platform Spark cluster was used to run chunked jobs in parallel. In the future, CGLS aims to move to Sentinel-1+2 for land cover classification and Landsat 5+7+8 for change detection for higher spatial and spectral resolution, but that makes big data challenges even bigger. None about this event: https://talks.2019.foss4g.org/bucharest/talk/BJURSG/

The impact of land use and land use change and forestry (LULUCF) on soil organic carbon (SOC) stocks and greenhouse gas (GHG) emissions is important for both national GHG inventory reporting and worldwide strategy to offset GHG emissions. Within the Irish Soil Organic carbon and Land Use Mapping (SOLUM) project, Eurostat’s Land Use/Cover Area frame Survey (LUCAS) of 2015, LUCAS soil survey of 2009, and ancillary national open data were employed in an analytical GIS framework to develop spatially integrated soils and land use dataset specific for Ireland. In order to capture dominant Irish land uses that are not included in the EU wide LUCAS survey, the LUCAS dataset was reclassified to grassland intensification and management for IPCC reporting purposes using a formal, semi-automated, interpretation key approach. All types of land use were ascribed to a soil label using the open source Soil Information System (SIS) for Ireland and other ancillary geospatial data, thus generating LUSII, Land Use and Soil Inventory for Ireland. Thus LUSII builds on an existing EU wide Open Data set with local knowledge and GIS analysis to create a new more applicable national dataset. None about this event: https://talks.2019.foss4g.org/bucharest/talk/9A3ZZF/

Open Source is more than just a license - join us at FOSS4G to dig into the “best practices” that can help your project succeed with open source. This talk builds on the lessons learned by the Open Source Geospatial Foundation in twelve years helping project teams and building the foss4g community. This presentations looks at the core values that OSGeo as an organization ask projects to adopt. We will discuss why we consider these factors critical to success, and practical ways they can be applied to your project. * To introduce OSGeo principles we will look at what is required to list an open source project on our website. * Our community program is used to explore how these principles are applied in practice. * Unpack how each principles is realized in the OSGeo incubation program, using examples of “OSGeo Projects” to explore different ways of achieving success. We invite project teams interested in succeeding with open source to attend this talk (and list your project on the OSGeo project directory after the presentation). If you are new to open source, or cautious, consider this talk an introduction to some of the risk factors associated with open source and community work - and mitigation steps to consider. None about this event: https://talks.2019.foss4g.org/bucharest/talk/Z8RG3T/