A Comparison of Lidar and Stereo-pair Derived Surface Models – Andy Walz
Thursday, October 27, 2016 from 11:00 a.m. – 11:30 a.m. (Session Number 8)
Lake Superior Room O
How does a surface model derived from stereo-pair imagery stack up against a lidar DSM? Lidar has quickly become the gold standard for elevation data but you might surprised what can be accomplished with high resolution imagery and automated stereogrammetry software like Ames Stereo Pipeline. Lidar data is becoming cheaper and more accessible but it just isn’t available for the majority of our planet. Satellite imagery on the other hand is collected constantly and depending on your application, stereo-pair images might just be able to meet your elevation data needs.
The goal of this project was to assess the viability of using stereo-pair imagery as source data for modeling areas where lidar is insufficient (bare-earth only, non-existent or dated) for a comprehensive analysis. We’ll talk about tools and techniques available for automated stereogrammetry, look at some model visualizations, and examine the differences discovered between the two products.
MySQL : The right database for GIS sometimes – Michael Moore
Thursday, October 27, 2016 from 11:30 a.m. – 12:00 p.m. (Session Number 5)
Split Rock Room 2
MySQL is not a popular database for use with GIS data. It is, however, the most popular database on the Internet. As use of GIS on the web continues to expand we, as GIS professionals, will be asked to integrate with WordPress, Drupal and other MySQL based systems.
Does it make sense to use MySQL for spatial data today? The answer is a strong “Maybe”, with a checklist of conditions and caveats to look into before saying “Yes”.
The main reason to consider using MySQL is to allow spatial integration with an existing non-spatial system. If you (or a client) are already heavily invested in a MySQL based solution, switching to an alternative platform might not be practical. You can also avoid the overhead of running and managing a second database and the complexities of managing relationships between entries in both.
In this presentation we will (1) discuss the pros and cons of using MySQL for spatial data (2) walk through some simple demos that showcase its capabilities and limitations and (3) help you determine if MySQL is right for your projects.
The Grass is Greener with Turf.js – Andy Walz
Thursday, October 27, 2016 from 2:00 p.m. – 2:30 p.m. (Session Number 18)
Lake Superior Room O
Can GIS and WordPress be friends? – Michael Moore
Friday, October 28, 2016 from 8:30 a.m. – 10:00 a.m. (Session Number 25)
Split Rock Room 1
WordPress is a Content Management System (CMS) that powers 25% of the websites on the Internet. Its growth is due in large part to its ease of use and a thriving plugin ecosystem.
Unfortunately support for GIS data and operations is severely lacking. I believe that geo-enabling popular frameworks like WordPress represents the next big area of growth for GIS on the web. Creating tools that work the way non-GIS admins expect lowers the barrier to entry into the world of GIS.
I have been experimenting with different approaches to add actual GIS capabilities to WordPress, in a way that is friendly to WordPress users. The results of the successful experiments have resulted in two free WordPress plugins, SavvyMapper and WP_GeoQuery.
SavvyMapper links WordPress data to GIS data in an external data source such as CartoDB, ArcGIS Server or an external GeoJSON file.
WP_GeoQuery use MySQL spatial support to store feature geometry right inside the MySQL database.
In this presentation I will discuss the results of my experiments in more depth, show off the methods I’ve used and talk about the status and future of GIS in WordPress.