Session Schedule

Primary tabs

Tuesday, March 10, 2015

Harbour ABRegency ARegency BRegency C
09:00 - 10:00 KEYNOTE: Infinite Possibilities (Grand Peninsula DEFG) 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:30Morning Break (Exhibit Area)
10:30 - 11:05 How PostGIS Powers Offline Mobile Mapping and Open Data 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 Dam it, even beginners can make awesome maps. 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 for GIS People 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 The Two (Geo) Cultures: Why GIScience and geo-tech rarely talk--and how open-source software provides opportunities for collaboration Geographic information scientists at research universities and geo-tech developers in industry are working on many of the same geographic problems, and yet they rarely talk, they rarely use each others’ work, they rarely realize they’re asking the same questions, just phrased in different terms. From the vantage points of "Research I" universities and of Silicon Valley start-ups and corporations, I've seen too many of these missed connections between the cultures of GIScience and geo-tech. I'll provide a few examples (from my own experience and from others working at the intersection of... The Two (Geo) Cultures: Why GIScience and geo-tech rarely talk--and how open-source software provides opportunities for collaboration
11:15 - 11:50 pg_shard: Shard and scale out PostgreSQL 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 On-Ramps to Open Source 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 Introduction to Spatial Data Analysis with Python 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 Bring developers+ scientists together to unlock (Big, Open?) Geospatial Data to Build Climate and Disaster Resilience 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:30Lunch (Atrium)
13:30 - 14:05 PostGIS Feature Frenzy What can you do with this PostGIS thing? This talk covers some basic and not­so­basic 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 not­so­basic 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 How to Win Friends and Use QGIS 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 Caching is Your Friend - Creating Tons of Maps on the Fly and Auto-Updating Some 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 Everyone's a Geographer 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 Explaining the Postgres Query Optimizer 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 Integrating QGIS/Postgis into a forestry client's workflow Small clients can be challenging. NRGS has a technology challenged client that started drowning in shapefiles in 2014. The data drowning also started causing other issues with software and workflow. During 2014 we started a slow migration into QGIS and Postgis/Postgresql. It became a bit of a challenge since we had to "throw out" bad habits and start redefining workflow and expectations. Surprisingly by the end we went from 1 to 3 GIS Capable computers using QGIS and a working PostGIS database. Surprisingly also because the consultant who had been threatening to learn PostGIS finally had... Integrating QGIS/Postgis into a forestry client's workflow PyGeoprocessing, an open source high performance geoprocessing and hydrological routing API 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 Building a Sustainable Open Source Training Academy Using QGIS 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 PostgreSQL Performance Presentation (9.5devel edition) 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) Carto CSS and UTF Grids for Collaborative Mapping 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 Five years of geo Open Source evolution in a commercial setting: projects and the business ecosystem 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 How... Five years of geo Open Source evolution in a commercial setting: projects and the business ecosystem How to be an Opportunity Maker in the Geo Community We all want to use our mapping talents to create something meaningful with our lives. But how do we get started? In this talk, I’ll share my own experiences creating community in New York City including my own personal “convening” event after a bicycle accident. In order for us to create community momentum, opportunity makers must value the power of collective reach over individual achievement. By seeking the disruptive and diverse opportunities for collaboration, we are able to become true opportunity makers in the mapping communities we touch. And it is only through community that... How to be an Opportunity Maker in the Geo Community
15:35 - 16:15Afternoon Break (Exhibit Area)
16:15 - 16:50 Logical Decoding and Auditing 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 particular: - Simplicity - Performance - Separation between live data and audit data Logical Decoding and Auditing Parkadelphia: building Philadelphia's first street parking maplication 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 Hazard Owl – Watching Assets for the Impact of Natural Hazards 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 Creation, Analysis, Sharing, and Visualization of Complex Spatiotemporal Data using Free and Open Source Software at the National Renewable Energy Laboratory 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 PGDay Lightning talks 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 Flying the Open Source Skies: GIS in Air Traffic Management A case study of the development of the NAS Common Reference (NCR) system prototype, developed by Mosaic ATM, for the Federal Aviation Administration (FAA). This presentation will outline the goals and challenges of the project, and how changing from commercial to open source GIS software improved development speed, application performance, and organizational positioning—for future work. It is believed that sharing the lessons learned from this project will benefit the FOSS4G community members, especially those working on similar projects. Flying the Open Source Skies: GIS in Air Traffic Management Think Before You Code (... & Other UX Considerations) 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) What is a map? 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:00Exhibitors Reception (Exhibit Area)
19:00 - 21:00Hackathon (Harbour AB)
21:00 - 23:00Late Night (Knuckles Bar)

Co-located with EclipseCon 2015

eclipsecon logo



FOSS4G NA is co-located with EclipseCon, an open source software conference for the Eclipse community that includes Theme Days on CDT, IoT, PolarSys, Science, and Xtext.
All FOSS4G registrants may attend any of the EclipseCon sessions at no additional charge. Check out their program.