|09:00 - 10:00||
Sometimes making choices in our career paths is difficult. Wouldn't it be helpful to have guidelines to help us make decisions that expand options rather than restrict them? Discover how choosing creativity, a growth mindset, finding your Flow, and being a Maker puts you on the path of having infinite possibilities in your career, creating a clear path to a future where you can not only be awesome, but also do meaningful work.
KEYNOTE: Infinite Possibilities (Grand Peninsula DEFG)
|10:00 - 10:30||Morning Break (Exhibit Area)
|10:30 - 11:05||
PostGIS is the cornerstone of most open source GIS applications. Combining it with the power of other open source applications, mobile devices, and cloud computing , you can bring quick data collection, data analyzation, and open data to a wide audience.
How PostGIS Powers Offline Mobile Mapping and Open Data
After an international twist of fate facilitated by the Twittersphere, an eager but ill-equipped beginner lands a contract to build a dynamic web map of dams in the Mekong River Basin.
Specifically, this map needs to allow users to highlight river catchments and change the dam layer's display parameters. Researchers have ranked aspects like natural flood threat and flood control capacity of 67 dams in the Mekong, and they want users to be able to change between those aspects to see how rankings play out across the region.
Armed with an aging MacBook, Google, and the...
Dam it, even beginners can make awesome maps.
Python is one of the most powerful tools you could keep in your open geospatial toolkit, but too many of us tend to put Python in a box labeled "for developers only" and walk away. I want to crush that misconception by showing GIS people who are interested in learning more about Python how easy it is to get started, and how useful Python can be to their specific needs.
This presentation is intended to be the inverse counterpart of a talk I've given previously, "GIS for Python People". In that talk, my goal was to bridge the gap to spatial concepts for an audience of Python developers --...
Python for GIS People
|11:15 - 11:50||
pg_shard is a sharding extension for PostgreSQL. It shards and replicates your PostgreSQL tables for horizontal scale and high availability. The extension also seamlessly distributes your SQL statements, without requiring any changes to your application.
As a standalone extension, pg_shard addresses many NoSQL use cases. It also enables real-time analytics, and has an easy upgrade path to CitusDB for complex analytical workloads (distributed joins). Further, the extension provides access to standard SQL tools, and powerful PostgreSQL features, such as diverse set of indexes and semi-...
pg_shard: Shard and scale out PostgreSQL
So you've decided you want to learn more about open source tools and offerings in geospatial technology. Congratulations! Now where the heck do you start?
This talk will provide starting points for newcomers to open source geo in several common interest areas, including web mapping, cartography, databases, analysis, and more. For each subsection of the field, we will:
- cover the current trends and conversations happening in the space
- provide a glossary of some common terms and themes
- suggest a starting point for continued education and independent learning
Attendees will come...
On-Ramps to Open Source
Attendees will learn about geoprocessing, analyzing and visualizing spatial data using Python and how it compares to other available options such as desktop GIS options (ArcMap or QGIS) or R. The talk will introduce various Python projects such as PySAL, GeoPandas, and Rasterio, and give attendees a starting place for independently exploring and learning geoprocessing skills using Python.
Slides for this talk are below. Materials for the 3-hr workshop are posted on: https://2015.foss4g-na.org/session/hands-introduction-spatial-data-analysis-python
Introduction to Spatial Data Analysis with Python
Just like access to money and decision-makers, access to data grants power and privilege for disaster response and preparation which small vulnerable communities and the general public lack. Imagine if we could unlock the best high-computer mapping, vulnerability science and big data to allow any city and any internet user around the world do sophisticated hydrological modeling or predict how their community will be affected by climate change in the coming decades.
I will start the session by briefly showing a proof of concept for a web application that draws from data in the cloud (...
Bring developers+ scientists together to unlock (Big, Open?) Geospatial Data to Build Climate and Disaster Resilience
|11:50 - 13:30||Lunch (Atrium)
|13:30 - 14:05||
What can you do with this PostGIS thing? This talk covers some basic and notsobasic ways to use PostGIS/PostgreSQL to process spatial data, to build infrastructures, and to do crazy things with data.
PostGIS has over 300 functions, which in turn can be used with the many features of the underlying PostgreSQL database. This talk covers some basic and notsobasic ways to use PostGIS/PostgreSQL to process spatial data, to build infrastructures, and to do crazy things with data. Consider the possibilities: raster, topology, linear referencing, history tracking, web services, overlays, unions...
PostGIS Feature Frenzy
Using QGIS for cartographic design, whether it's destined for print media or digital media, has never been easier or more complex. See what this paradox is all about through a demo-rich exploration of the intuitive QGIS interface and the deep processing and visualization capabilities that underlie it.
How to Win Friends and Use QGIS
Julie Goldberg is the co-founder and chief engineer behind Empower Engine, a 2-person start-up that maps electoral campaign data for Democrats and their allies. She’ll talk a bit about the domain and a lot about some technical challenges she faced, mostly solved by caching. The system is built using Django, Leaflet, Tilestache and Postgres.
Campaigns organize geographically, so maps are very important. Organizers have their own turf, and it’s important to see how things vary in just their local area. Some data is static, but other data must be recomputed every day. We never know...
Caching is Your Friend - Creating Tons of Maps on the Fly and Auto-Updating Some
Because mapping has become such an interdisciplinary subject, we design CartoDB to appeal to artists and scientists, journalists and educators. This requires us to design a curriculum through our Academy and portfolio of tutorials that is both focused and broadly applicable. Based on feedback from educators at events like our Educators Night, meetings at colleges with professors, open source engagement, and many workshops all over the world, CartoDB continually hones its materials while aiming to teach for the next generation of mappers.
I will be speaking about the methodology that we use...
Everyone's a Geographer
|14:15 - 14:50||
The optimizer is the "brain" of the database, interpreting SQL queries and determining the fastest method of execution. This talk uses the explain command to show how the optimizer interprets queries and determines optimal execution. The talk will assist developers and administrators in understanding how Postgres optimally executes their queries and what steps they can take to understand and perhaps improve its behavior.
Explaining the Postgres Query Optimizer
PyGeoprocessing is an open source, free, high performance, memory efficient set of geoprocessing routines developed natively in Python. It includes: a programmable raster stack calculator that handles common GIS routines such as interpolation, masking by shapefile, vector processing, and more; a set of shapefile aggregation and processing routines that handle overlapping polygon features by solving a maximal subset problem; a linear time and space efficient distance transform function; and a set of d-infinity hydrological routing routines including flow direction, flow accumulation, average...
PyGeoprocessing, an open source high performance geoprocessing and hydrological routing API
For the past five years the GeoAcademy has been developing a series of GIS courses based on open source tools, like QGIS. This work is funded by the US National Science Foundation and Department of Labor and has resulted in the first complete set of FOSS4G curriculum freely usable by any educator. The material is all copyrighted under Creative Commons BY 3.0 allowing for its free reuse and modification with attribution. The courses are all aligned with the national US Dept of Labor's Geospatial Technology Competency Model (GTCM). They are currently in use in numerous college and...
Building a Sustainable Open Source Training Academy Using QGIS
|15:00 - 15:35||
This presentation will take a look at the performance changes in the development version of PostgreSQL. A selection of features, some proposed and some already committed, are evaluated using synthetic open source workloads. One of the workloads used is the former OSDL's Database Test 3 that consists of business oriented ad-hob queries with concurrent data modification.
Some of these proposed features include:
- New index type called Block Range Indexes (BRIN)
- Improvements to the buffer cache management
- Improvements to the data lock management
- Other internal data structure...
PostgreSQL Performance Presentation (9.5devel edition)
Warning, this talk is about cartographers designing and building web applications. Tasked with making a mapping application for internal business use, we reached out for open source tools that could be combined to produce a platform for collaborative mapping and data sharing. We used tools like Mapbox.js, windshaft, mapnik, and PostGIS to build a web based application that allows its users to create, filter, edit, and share interactive maps and data with teams or individuals. The presentation will take you through the challenges of building on FOSS, and the importance of small group...
Carto CSS and UTF Grids for Collaborative Mapping
Our company began delivering projects based on geo open source technology in late 2008. Since that time we have consistently and annually increased our use of FOSS4G in our projects. Five years later, this presentation will retrospectively look at our corporate and technological evolution including:
The increasing sophistication of the open source solutions that have been developed
Representative case studies from each of the past 5 years
The changing business landscape including the emerging ecosystem of companies that support FOSS4G
Five years of geo Open Source evolution in a commercial setting: projects and the business ecosystem
|15:35 - 16:15||Afternoon Break (Exhibit Area)
|16:15 - 16:50||
Logical Decoding" is the cryptic name for a very powerful feature
introduced in PostgreSQL 9.4. After a brief historical overview, we
apply Logical Decoding to the specific problem of auditing a database.
We also compare this solution to the more traditional approach, where
triggers are created on those tables subject to auditing, evaluating in
- Separation between live data and audit data
Logical Decoding and Auditing
Street parking in Philadelphia is so difficult to navigate, it was the inspiration for a television show that ran for 5 seasons on AMC. That's right: there are parking enforcement officers in Philadelphia that have IMDB entries for playing themselves. While entertaining, it seemed to me that there might be some room to improve the way drivers could access parking rules and regulations.
After considering the layers of data that were needed and searching available open data sets, I realized they didn't exist (or weren't publicly released). So I set out to build my own: I started...
Parkadelphia: building Philadelphia's first street parking maplication
Every new building or structure that is constructed within a natural hazard zone is designed to withstand particular levels of disruption from relevant hazards – for instance a new building in an earthquake zone is required to meet particular seismic codes, and a new bridge is designed to withstand certain levels of flood event.
Hazard Owl is a platform designed to warn stakeholders of predicted, ongoing, and recent hazards, furnishing them with the information they need to manage the event and its aftermath, such as the type and severity of event, the applicable design standards for the...
Hazard Owl – Watching Assets for the Impact of Natural Hazards
Geospatial data science at the National Renewable Energy Laboratory incorporates a wide range of activities including the creation of large spatiotemporal resource datasets, modeling the technical potential of renewable energy at the national level, web based visualization of complex scenario based modeling, and sharing of both datasets and analysis methods with industry, academia, and the public through web services. In this presentation, we describe an integrated system in which all of the steps from data acquisition through analysis and collaborative research to sharing results with the...
Creation, Analysis, Sharing, and Visualization of Complex Spatiotemporal Data using Free and Open Source Software at the National Renewable Energy Laboratory
|17:00 - 18:00||
Drink from a firehose of amazing PostgreSQL lightning talks as we wrap up PGDay 2015. This promises to be an educational and entertaining hour!
PGDay Lightning talks
In 2014, NOAA Coastal Services Center, ASFPM, USACE, ERG, and the City of Toledo partnered together to conduct an assessment of the implication of future climate models on chronic urban flooding in Toledo, and the effectiveness of green infrastructure in mitigating the financial losses imposed by flood events. The Flood Hazard Visualizer utilizes an array of open source libraries to transform the results of this assessment into an interactive tool that supports the needs of both novice and expert users.
This presentation will walk through both the basic and advanced functionality...
Think Before You Code (... & Other UX Considerations)
New developments in mapping technology, access to geospatial platforms and data, and methods for data visualization have redefined who and what are being mapped. While maps are being produced and consumed faster than ever before, our very understanding of what defines a map has slowly drifted from what technology actually enables. The "map" still holds a strong conceptual link to the foldable paper maps popular in the past centuries. However, the nature of the map today is defined by data that changes before our eyes and information that wont be the same from one viewer to the next....
What is a map?
|18:00 - 19:00||Exhibitors Reception (Exhibit Area)
|19:00 - 21:00||Hackathon (Harbour AB)
|21:00 - 23:00||Late Night (Knuckles Bar)