“Your Geospatial Destiny” was the theme of this year’s 26th Annual Minnesota GIS/LIS conference held in Duluth, MN (#MNGISLIS). The Cimbura.com GIS team was there to speak, learn, network, and tour a really cool Great Lakes research vessel known as the Blue Heron. It was a great opportunity to connect with friends and learn about all the latest new projects and technologies in the GIS world.
Building “apps” was definitely a sub-theme of this years presentations. There were great talks on accessible maps, cartography, analytics, usability, crowd-sourced data, ArcGIS Online, and custom apps. We were really impressed with demos we saw of North Point Geographic’s adopt-a-highway app, RESPEC’s smart irrigation app, and Houston Engineering’s MS4 permit app. Other hot topics this year included open data, parcel fabric, elevation data, data privacy and collecting data with drones. Evening social events included a reception at the quintessential Grandma’s Saloon (at the foot of the aerial lift bridge) and a craft beer tasting event, featuring brews from across the Northland region–Bent Paddle, Castle Danger, Canal Park Brewery, and even the Duluth Homebrewers Guild were there.
A Comparison of Lidar and Stereo-pair Derived Surface Models – Andy Walz
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
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
Can GIS and WordPress be friends? – Michael Moore
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 uses 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.