Standard [35 minutes]

Wed, 2016-02-10 17:53

MLS PostGIS: Multi-level Security in PostgreSQL/PostGIS with RLS and SELinux

PostgreSQL 9.5 has a new feature called Row Level Security (RLS). Using RLS, a PostgreSQL extension called sepgsql (somewhat modified), and Security Enhanced Linux (SELinux) configured properly, it is possible to create a Multi-level Security, PostGIS enabled, PostgreSQL database. This talk will describe how it can be done, including:

Solution Components
* SELinux
* sepgsql
Database schema/DDL
* Table
* Policies
Example Results
* Select
* Performance

Tue, 2016-02-09 18:07

Efficiently Backing up Terabytes of Data with pgBackRest

pgBackRest is open source software developed to perform efficient backup on PostgreSQL databases that measure in tens of terabytes and greater. It supports per file checksums, compression, partial/failed backup resume, high-performance parallel transfer, asynchronous archiving, tablespaces, expiration, full/differential/incremental, local/remote operation via SSH, hard-linking, restore, and more. pgBackRest is written in Perl and does not depend on rsync or tar but instead performs its own deltas which gives it maximum flexibility.

Tue, 2016-02-09 14:56

A New Vision for OSGeo

The Open Source Geospatial Foundation is undergoing a period of change. For the tenth anniversary of the foundation the board is embracing this change with a new vision, mission statement and goals.

This talk introduces this new direction for the foundation, and explores details of 2016 strategic plan. This talk is of particular importance to foundation projects, community participants and our sponsors.

Attend this talk if you are interested in what OSGeo does in the FOSS4G community and where we are heading next.

Tue, 2016-02-09 14:42

Welcome to the FOSS4G Community

Welcome to the Free and Open Source Software for Geospatial community. Freedom is one of the tools we use to take on the world. This presentation breaks down the principles on which our community built.

This welcome presentation is a quick orientation on open source, open data, open standards and open development.

Please attend this talk if you are new to the FOSS4G community, or would like some background on how all the fun toys you see on display fit together to form a larger picture. A larger picture we like to call the future.

Tue, 2016-02-09 00:27

From UAV to Orthomosaic: Building a Toolchain

Our mission was to create an orthomosaic starting only with the image sequence from a UAV flight. Typically this data is not highly calibrated; the camera characteristics may not be known and motion sensor data may not be present. Structure from Motion (SfM) offers a photogrammetric method for creating 3D models out of overlapping aerial imagery. This model in turn can be draped with the images to produce our orthomosaic.

Mon, 2016-02-08 23:40

PhillyPopeMap: What to Do When a Million Visitors Need a Map

With a projected attendance of one million people, the city planning to shut down for three days and the heart of Philadelphia behind a security fence, the first thing residents wanted was a map. Unfortunately, due to security concerns, the city was not permitted to publish an official web map - announcements from more than eight state, local and federal agencies were released with...PDFs. With no map a few weeks beforehand, we got to work: tracing layers, building a timeline and styling layers.

Mon, 2016-02-08 22:07

State of the QGIS Project

State of QGIS reviews new and noteworthy features for the QGIS project. This talk will cover both Desktop and Server components from version 2.14 just released by the community.

Behind the scenes, the QGIS developer community is fully committed to updating the compatibility of the QGIS codebase with the upcoming version 3.0 release, moving to the latest versions of the Qt5 toolkit and Python 3, and away from deprecated Qt4 and Python 2.

Mon, 2016-02-08 21:50

Beyond Mapping Population Density: Cartography for Big Data

Big data sets are not only 'big' in size and/or number of records, but also in the variety of stories and insights they hold. Piling millions of points on a map can be beautiful and eye-catching, but what story does it tell? Each coordinate in the data provides the opportunity to extract meaningful patterns and observations at multiple scales over a variety of topics. The result? Maps driven by big data that are both beautiful and informative.


Subscribe to Standard [35 minutes]