|09:00 - 10:00||
The initiative to create the National Spatial Data Infrastructure (NSDI) was launched by President Clinton in 1994. The ambitious – and as yet partially unfulfilled goals – of the NSDI include creating a national network of distributed geospatial data that can be used to support a wide range of public and private sector applications. At the dawn of the Internet, creating such a network was an extremely lofty goal that stretched the capabilities of technology. Moreover, at that time the federal government was a major architect of and content provider for the nation’s growing...
The US National Spatial Data Infrastructure: Where do we go from here? (Ballroom A)
|10:00 - 10:30||Break
|10:30 - 11:05||
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.
Using a big data example, this session walks through some methods (and challenges) of representing millions of points on a map in a meaningful way...
Beyond Mapping Population Density: Cartography for Big Data
Autonomous Vehicles, Drones and Data Driven decisions happening on a sub inch level. A city of the future? No, a farm today. Come find out the current Precision Agricultural techniques for data collection, analysis and dissimulation and where FOSS4G tech plays a key role. From harvesting millions of data points generated from every vehicle on the farm, to the corporate dashboard and reports, FOSS4G plays a role.
Precision Agriculture, drones are just the tip of the iceberg.
Precision Agriculture and Open Spatial Technologies
For spatial data systems where it's important to avoid overlap, gaps and give any end users a easy way to update the map, Postgis Topology is a must.
Let's look a some headlines :
* Normalize data, for instance shared edges should only be represented once.
Why : Avoid the possibility for gaps , overlaps, spikes and other error in the result.
* Must be simple to expand or reduce a polygon surface even if the border line contains thousands of points.
Why : Moving many points on a screen is difficult and time consuming and its's often is easier just to draw a new line that shows just...
Postgis Topology will replace simple feature.
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.
With the advent of sweeping changes in 3.0, this talk will also highlight how this may affect existing plugins and workflows and how the developers are...
State of the QGIS Project
It's actually quite simple: If fields are updated or rows deleted, a trigger is called storing the changes in one audit table as JSONB. These snippets can be queried efficiently using GIN indexing and we can put them back together to create historical replicas of rows / tables / databases.
Metadata about corresponding transactions and events are stored in seperate logging tables, which is useful to revert changes caused by certain transactions. pgMemento is written in PL/pgSQL and therefore pretty easy to use with every postgres instance (v.9.4 … soon 9.5) incl. extensions like PostGIS...
Old school auditing with the new JSONB stuff: pgMemento
|11:15 - 11:50||
Wake up and take control of your GIS cartography! This talk goes over QGIS cartography 101 topics, via a live demonstration of the map-making process.
Along the way we'll commiserate over our mental, emotional, physical, and financial destiny by taking inspiration from the best-selling mental health book "Awaken the Giant Within," while simultaneously learning QGIS.
But mostly we'll learn QGIS.
Awaken the QGIS Within
I make money by selling free software. I sell it to smart people.
Okay, I don't actually sell free stuff. I just know how it works, so smart people who want the free stuff pay me to get it to work. Look, they're smart people. They could figure this stuff out, if they had the time.
But they don't. And they don't love Open Source GIS tools any more than they love any other software. They're not like us, in that regard.
We love FOSS4G because we love the amazing maps we can produce. We love FOSS4G because of the control we have over our data, and our tools. Many of us did incredible...
GIS for people who aren't GIS people
Over the past 50+ years, NASA has built dozens of spacecraft to study the Earth across a range of scientific disciplines. The data from these missions is freely and openly available to the public and, in recent years, has been made to be more accessible to the geospatial community. Via the Global Imagery Browse Services (GIBS), this data has been converted to imagery and used for a diverse array of applications including wildfire monitoring, air quality research, finding frozen lakes for skating, and soaring above the Earth through immersive planetarium shows. In addition to demonstrating...
Mapping the Planet from Outer Space
This talk will showcase spatial feats you can do with PostGIS
Special focus will be given to features new in PostGIS 2.2 and upcoming PostGIS 2.3.
What we will cover:
* Proximity analysis with improved KNN functionality introduced in PostGIS 2.2
* Geometry dicing for speedier performance in data grouping and proximity analysis,
* Geometry clustering
Geography - Proximity analysis using KNN (new in PostGIS 2.2)
Raster - in-database raster coverage making
Topology - geometry simplification that maintains connectedness of adjoining geometries
PostGIS Spatial Tricks
GeoNode is a web based Content Management System (CMS) for geospatial data and provides the the essential components for a Spatial Data Infrastructure (SDI) node. It is based on mature open source projects including Django, PostGIS, GeoServer and OpenLayers. The project recently released the 2.4 version and usage has exploded all around the world including several downstream projects that are large collaborative efforts in their own right. This presentation will review the current state of the GeoNode project, reviewing what GeoNode is, how it’s used by organizations from Governments and NGOs...
The State of the GeoNode Project
Street names carry local context and meaning and can vary locally, even within a relatively small geographic envelope, frequently appearing in languages other than English. The United States Federal Geographic Data Committee (FGDC) in 2011 released a data content standard for storing address data in a highly normalized way. This standard was intended for use within the United States of America and principally for parsing English language street names.
Street names have cultural importance and are frequently represented in the local language. It is therefore important to consider how to...
Using the FGDC Address Standard with Non-English Street Names
|11:50 - 13:30||Lunch (Ballroom B)
|13:30 - 14:05||
The Ancient Mound Builders of North America may be gone but they left behind a world heritage of huge earthworks, monuments, and mounds dating from 3500 BC to around 1600 AD. What can be discovered about their legacy through the use of publicly available Lidar data and open source software? The answer may surprise you.
This talk shows how discoveries can be made by an Archaeological/GIS hobbyist using open source tools such as 1) QGIS and GDAL to process LIdar derived DEM/DTM data, 2) GeoServer to serve the data, and 3) Leaflet to create a detailed map of ancient known and potential...
Uncovering the Ancient Mound Builders Using Open Data and FOSS Software
Developers of open source software are not only the developers but are users as well. Most of the time they start out as users and then for any number of reasons become developers.
When they start digging into the codebase and making changes, they do so with their specific use-case in mind. This dual role (developer and user) has many advantages; however, it can also lead to software that is very driven by a subset of the users. More often than not, this leads to a focus on expert users, giving little voice to less experienced (non-programmer) users. This is why there is a need to...
Open Source for the Newb - What we as open source developers can do to improve the user experience of our Geospatial applications.
The US Topo topographic 7.5 minute quadrangle maps are one of the most popular products produced by the National Geospatial Progam of the USGS. The newest version of the US Topo is packaged as a layered GeoPDF which is available through the USGS's nationalmap.gov. Though the layered GeoPDF may be convenient for the layman, the nationalmap.gov is always receiving requests for other, more versatile raster formats. To address the issue, we have turned to GDAL for...
Using GDAL to Translate US Topo PDF's
GeoServer and GeoWebCache can, at times, be a significant bottleneck for spatial applications serving raster and/or vector data, especially for applications with large user bases. Often, it is not obvious how to scale GeoServer and GeoWebCache in order to relieve such bottlenecks. Furthermore, the choices that are made can have unintended downstream consequences.
In this talk, I will walk through the process of scaling GeoServer and GeoWebCache. Along the way, I will describe the considerations and reasoning involved with each choice. The goal is to not only display the setup and...
High Performance GeoServer Clusters
At mySidewalk, performance isn't just a feature, it's THE feature. Over the last year, we've spent most of our time trying to make the visualization and analysis of geospatial data faster and easier, and vector tiles have been the special sauce that has allowed us to take data delivery and visualization to a whole new level.
In this talk, I will discuss several performance optimizations that are implemented at various steps in the vector tile pipeline: from client requests, to the tile server, the database, tile caching, and back. Specific technologies/strategies to be discussed are:
Climbing the data mountain: Scaling and optimizing the delivery of vector tiles
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.
I'll present the results of our efforts to build an Open Source toolchain to accomplish this workflow, with a focus on how SfM works and the successes and pitfalls we...
From UAV to Orthomosaic: Building a Toolchain
Many database administrators were first introduced to PostgreSQL years ago and have memories (good...
Don't Forget the Elephant
|14:15 - 14:50||
Illicit trafficking is a serious transnational crime to cause negative socio-economic effects as well as a way to constitute criminal funds promoting various transnational criminal activities. These transnational criminal operations could be detected and prevented by identifying transnational criminal organizations and analyzing high-risk routes for illicit smuggling. However, it’s still hard to find readily available global network data of all possible transportation modes and GIS applications supporting analysis of transnational trafficking pathways despite substantial efforts and...
Using Open Source Web GIS for Analysis of Transnational Illicit Trafficking
To support our oblique imagery acquisition, we have developed an open-source heads up display for our pilots. The system utilizes a number of open tools and data such as: GPSD, PHP, OSSIM, MapBox GL JS API, TileServer, USGS National Map and Open Street Map. The system takes a realtime GPS stream and image collection information from the cameras to generate vector overlays the pilots can use to navigate and tracks progress to ensure full coverage of the survey area. This strategy has vastly improved the the efficiency with which we can collect imagery.
NOAA’s National Geodetic Survey...
Open Source Heads Up Pilots Display for Oblique Image Acquisition
This talk focuses on the dynamic costing methods applied to Valhalla, open source routing and navigation software built to use OpenStreetMap data. Rather than assigning costs to the routing graph during data import or graph creation, Valhalla performs costing at run time using a wide range of attribution. This allows flexible route generation using the same data. Costing modules exist for automobile, bus, truck, bicycle, pedestrian, and public transit. Each costing method allows for options to differentiate routes - for example bicycle routes have options for bicycle type, willingness to use...
Valhalla - A Tiled Hierarchical Open-Source Routing Solution
The Mapbox Vector Tile Specification recently received a massive facelift and was released as version 2.0. This talk is meant to review the core concepts of Vector Tiles and the reason that the specification was updated to 2.0. The talk should inform users of Vector Tiles what they should and should not expect because of the change to the specification.
Mapbox Vector Tile Specification 2.0
Balloons, kites, and poles provide low-cost and easy-to-use methods to capture timely spatial imagery that can be incorporated into environmental and socioeconomic analyses. Citizen scientists, journalists, and activists have used these methods to gather information about the Deepwater Horizon Spill, potentially rediscover one of the oldest American Veterans Cemeteries in New York City, and to stall eviction proceedings in Uganda. In this talk, I'll give an overview of different aerial mapping methods, the construction of camera...
Balloons, Kites & Poles - Low-cost ways to capture and analyze open geodata
BRINs (Block Range INdexes) are one of the major new features introduced with PostgreSQL 9.5. They allow to directly select just blocks of table pages needed for queries execution, resulting on smaller indexes that can be easily contained in memory and that require less maintenance than the existing ones.
These features make BRIN particularly suitable for very large tables, and more in general for query with a low-selectivity that would be executed preferring a sequential scan of all tables blocks instead of using indexes.
Many examples of BRIN usage for numeric and string...
BRIN indexes on geospatial database
|15:00 - 15:35||
DungeonMasters! Do you grow weary of painstakingly crafting level after level of D&D dungeon maps by hand? Find out how to make a randomized - but still customizable! - dungeon generator with Python!
Dungeons & Development: Creating a Randomized D&D Map Generator with Python
A recap of a prototype project that was created for the NYC Department of Transportation to demonstrate the utility of Open Source routing applications in support of large vehicle permitting processes. The DOT asked us to review software options to support the creation of street route and turn by turn directions solutions for large vehicles entering the city of New York. They needed the solution to be performant, scalable, and to support the use of the city's LION dataset with the dynamic inclusion of street closures, turn restrictions, and weight and height restrictions based on analyst...
Open Source Street Routing With PgRouting For Local Government - Dynamic Data and Performance
Team passion for open source technologies, and open data are powerful driving forces for building amazing technologies, highly motivated teams, and international communities and relationships. It can also provide significant advantages for your business when leveraged in a disciplined manner to move your business forward.
In this session you'll hear about the 18 years of the presenters own experience building a business founded on open source technologies and open data. When combined with hundreds of conversations with peers, you too can learn what to do, and importantly what not to do to...
Lessons Learned from 18 Years of Business with Open Source and Open Data
OpenDroneMap (ODM) aims to be a full photogrammetric solution for small Unmanned Aircraft (drones), balloons, and kites. ODM acts as a tool for processing highly overlapping unreferenced imagery, turning the unstructured data (simple photos) + GPS into structured data including colorized point clouds, digital surface models, textured digital surface models, and orthophotography.
The project can be found at https://github.com/OpenDroneMap/OpenDroneMap . This session will act as an introduction to OpenDroneMap, give an overview of what the current status of the project is, detail what the...
Open Source Photogrammetry with OpenDroneMap
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:
MLS PostGIS: Multi-level Security in PostgreSQL/PostGIS with RLS and SELinux
|15:35 - 16:15||Break
|16:15 - 16:50||
Marine Protected and Managed Areas (MPAs) are a cornerstone of coastal and ocean conservation efforts and reflect years of dedicated effort to protect species and habitats through science-based regulation. When they are effective, biomass increases dramatically, and up to 14 fold and play a significant role in conserving biodiversity. Effective MPAs have enforcement. Enforcement cannot occur without awareness of their location among ocean stakeholders and the general public. The Anthropocene Institute, in partnership with the NOAA Marine Protected Area Center, is creating an actively...
Marine Protected Area Mapping - Promoting Awareness, Compliance, and Enforcement via Open Data and Tools
Need to expose thousands of geo-referenced images with ability to constrain the mosaic by temporal, spatial or custom attributes? GeoServer provides out-of-the box support for this capability and we will walk through a quick set up of GeoServer and configuration of a sample mosaic.
Presentation will include a brief overview of the dataset used, the FOSS stack selected, examples of WMS queries, as well as a live demonstration on the initialization of the complete stack using Docker Compose using GeoServer's REST API. We will highlight areas where performance can be optimized and how to...
Image Mosaics & Automation
pgRouting is an extension that builds on PostGIS for performing network routing such as road navigation, hiking, and other things.
In this talk we'll give a crash course of what you can do with pgRouting with a special focus on pgRouting 2.1, and time permitting, highlights of upcoming pgRouting 2.2.
Coverage will detail:
1) Making general data routable and applying costs to data
2) Using dijkstra to determine optimal paths from one start location to one destination
or for choice travel options - one source to many destinations
3) Finding multiple paths solutions given a start...
pgRouting: A Crash Course
Why do we care about the emerging technology area of Indoor Location and the location of mobile devices in areas where GPS doesn't work. This presentation will explain the benefits of Indoor Location, such as sales representatives coming to you rather than you finding them, targeted sales promotions as you walk the store and post event analysis to identify areas of interest using spatial temporal analytics tools.
Additionally we will take a deep dive into the sensing technologies of BLE beacons and WiFi detection and explain how these tools can detect and position a user with a device...
Indoor Location - why and how
Imagine being able to hold a GIS in your hands, feeling the shape of the earth, sculpting its topography, and directing the flow of water. We present Tangible Landscape, an open source tangible interface powered by GRASS GIS. Tangible Landscape physically, interactively manifests geospatial data so that you can naturally feel it, see it, and shape it. This makes GIS far more intuitive and accessible for beginners, empowers geospatial experts, and creates new exciting opportunities for developers - like gaming with GIS.
In this talk we will introduce tangible interaction and why it matters...
Tangible interaction for GIS
“Esri union” is a function that is often used by Arcgis users and in many cases an important reason why people still need Arcgis software, even when the data area available in Postgis. For NIBIO the Arcgis software was working ok with smaller datasets, but not bigger datasets. So we asked the users why not run this is in Postgis ? The answer was “The function is not available in Postgis, can you make one that works ?”
In this presentation we will go into how to manage
Content based grid
Postgis “esri union” on a “unlimited” sized data set.
|17:00 - 17:15||
GeoWave is an open source project that bridges the gap between geospatial software and distributed computing systems. This presentation will primarily focus on applications of GeoWave. In this presentation we will illustrate how GeoWave can visualize massive datasets and further enables distributed processing to perform analysis at scale.
We will guide the audience through several examples of utilizing GeoWave to efficiently visualize and analyze very large datasets. Examples include:
PDAL integration to read and...
GeoWave: Visualizing Massive Datasets
If you had medium-resolution imagery of the whole world every day, where would you look? What would you do with it? It can be overwhelming to think about, but at Planet Labs this is always on our mind as we finalize our constellation. And we want to make it easier for others to think about it too, through open data and open source tools.
In this talk, we'll show off what high-cadence imaging looks like, and share some of the tools we'll be open sourcing to help people visualize and share multi-temporal satellite imagery. We'll also talk about our Open California initiative, which opens up...
Surfing the Imagery Tsunami: data exploration with high-frequency Planet Labs imagery
North Carolina's geospatial community and state as a whole has greatly benefitted from having a culture of free and simple access to a large amount of local and state data, thanks to a lot of hard work and collaboration on a number of initiatives.
The cohesion for all of these initiatives comes from NC OneMap and the North Carolina Geographic Information Coordinating Council (NCGICC) and its subcommittees. The public face of NC OneMap is an online portal to download or stream a wide array of state and local data from many partners. We will present the impetus for NC OneMap and its role...
Free, Fast, and Accurate: NC's Open Data Lets You Have All Three
Drones have recently moved from the battlefields to our backyards. Their use is exploding across the U.S. and the rest of the world. Engineers, photographers, journalists, surveyors, researchers and… Amazon, all speak with one voice: drones are here to stay. How does the open source software handle this attack? Can they win the battle with the proprietary solutions for geoprocessing the data from Unmanned Aerial Vehicles? We faced the problem designing innovative graduate level course “Spatiotemporal Analysis with UAV and LiDAR Data” at NC State. In this talk we will present our findings and...
Open the classroom window for... DRONES!
The Geoparser is an open source tool that can process information from any file, extract geographic coordinates, and visualize locations on a map. After the information is parsed and points are plotted on the map, users are able...
PGDay Lightning Talks
|17:20 - 17:35||
A common challenge with niche research, notably in the realm of bicycle and pedestrian travel, is that research results can be very difficult to evaluate and reproduce outside of the context in which the research was originally conducted. In addition, academic research always favors “novel” and “unique” approaches, rather than carefully testing out work in new contexts and incrementally building toward a complete well-developed analytic solution. In many fields there is also a crisis of “reproducible research”, where poorly vetted results are presented as universally true, only to later be...
Using Open Source to support Transportation Research: Nonmotorized Travel Analysis Toolkit (NMTK)
Australia’s NationalMap, nationalmap.gov.au, is an engaging, open-source web site enabling the public to discover and explore Australian government spatial data at the federal, state, and local levels. An interesting feature is that NationalMap does not host any data itself. Instead, it provides a federated interface to the diverse servers already operated by the the various government agencies, running Geoserver, THREDDS Data Server, ArcGIS Server, CKAN, Socrata, and many more. This allows the agencies to retain full control over the hosting and updating of their data, while still...
Australia’s NationalMap: Open Data and Open Source Down Under
MARPLOT (http://response.restoration.noaa.gov/marplot) is a general-purpose GIS designed for emergency responders and planners, and it serves as the mapping component for a suite of software called CAMEO developed jointly by the National Oceanic and Atmospheric Administration and the Environmental Protection Agency. MARPLOT has a sizable user base with over 20 thousand downloads in 2015. The program's core audience presents a challenge, because MARPLOT needs to be able to work offline in an emergency situation where internet may not be available. At the same time, MARPLOT needs to be able to...
MARPLOT: Building a Desktop GIS for Emergency Response from FOSS Components
We are presenting a suite of web mapping tools designed specifically for the Arctic regions. These tools are Arctic Citizen Sensors, Arctic Web Maps, and PolarMap.js. These Arctic-specific web mapping tools allowing researchers and developers to customize map projections for scientifically accurate visualization and analysis, a function that is critical for arctic research but not easy to do with existing web mapping platforms. Arctic Citizen Sensors is a citizen-sensing platform based on open source hardware and the OGC SensorThings API. It empowers the northern communities to collect...
Arctic Citizen Sensors, Arctic Web Map and PolarMap.js
RikiTraki is a mobile-friendly open-source web mapping application for maintaining and sharing GPS tracks of outdoor activities such as hiking, biking, and boating. The application provides visualization of all trailheads over a map or a globe, and allows for filter, search, and click to drill down to the details of each entry. The details include visualization of the GPS track presented over a selection of base maps, along with a description of the trail and associated metrics such as distance and elevation. An interactive elevation widget is...
Visualizing GPS Tracks with RikiTraki
PGDay Lighting Talks
|17:40 - 17:55||
Transportation GeoDesign using Open Data & Select Open Source Tools.
The U. S. Census Bureau created the Geographic Update Partnership Software (GUPS) to assist its partners in the review and collection of geospatial data for the 2020 Census. The GUPS is free software to over 40,000 state, local, and tribal governments, and it is critical for the acquisition of our partner's boundaries, streets, and addresses. The GUPS consists of a suite of Python-based plugins operating within QGIS . QGIS is an open source geographic Information system (GIS) providing core functionality of integrated topology and data editing capabilities to each GUPS geographic program...
The U.S. Census Bureau's Geographic Update Partnership Software (GUPS), a QGIS based solution
There is currently no comprehensive search capability for online spatial information, a critical body of data which now represents an uncurated, “dark web” of data services and data files. One could argue this domain is not even a web since most of it does not link out and most is not linked-to from elsewhere.
Though there are millions of geo-services and datasets just a click away, there is no way to discover most of them. It is difficult to estimate the opportunity cost of having no general purpose geospatial search capability. Imagine not being able to find a web page. That was the...
HHypermap: A Platform to Enable Geospatial Search
This presentation is about my first adventure in using FOSS4G web mapping technology to visualize and disseminate data. The technologies used include leaflet, mapbox, openstreetmap, bootstrap, and c3.js(charting wrapper for d3.js).
The study area is the Texas coast and includes data about birds (from Audubon Society), fish (from Texas Parks and Wildlife), and water quality (from Texas Commission on Environmental Quality). This is important because the data in it's raw form is A. hard to get and B. hard to manage. Making an easy to use webmapping and charting interface provides a useful way...
Texas birds, fish, and water quality - My first adventure using FOSS4G to create an application visualizing data along the TX Coast
Currently, we tend to use tiled data exclusively for rendering maps--not so much for data analysis. In recent projects, we've started developing an approach that leverages the scale-independence and indexed nature of vector tiles to do quantitative + geographical data analysis in the browser--for example, a web map enabling a user to draw any polygon at any zoom and calculate demographic statistics within it.
In this talk I'll show that example and a few others, introduce the underlying collection of Node modules focused on interacting with Mapbox vector tiles, and then...
In-browser, scale-independent geo data analysis using vector tiles
Combining the power of GDAL with a C++ image processing library called CImg, GIPPY provides a Python interface to easily perform common image processing tasks on large remote sensing data sets. By automatically and transparently chunking input imagery and allowing chaining together of operations, users can put together algorithms that are then processed efficiently by deferring all operations until read time, while utilizing multi-threaded functionality of the Boost C++ libraries.
GIPPY not only provides a simply Pythonic interface while abstracting away the chunking and processing of the...
GIPPY: A high performance geospatial image processing library for Python
PGDay Lightning Talks
|17:55 - 19:00||Exhibitors Reception (Exhibit Area)
|21:00 - 23:00||Late Night hosted by LocationTech (Rye Bar at the Marriott)