Python + Geospatial + SQL = More Awesome!!!

Posted on September 15, 2015 in Presentations

This presentation was given at NEURISA Day 2015 on September 14, 2015.

Everything is Awesome!
This overview of using python and SQL to get more from geospatial processes will review tools and workflows for data processing and conversion. Take advantage of open source and esri tools that allow you to perform complex queries against your spatial data or gather aggregate information across multiple datasets.

This presentation was created and presented by Guido Stein, GIS Analyst. Guido’s focus within the company is around work flow automation and technology. He is a certified SafeSoftware FME Professional.


Click here for stand alone Presentation

Filter, Aggregate, and Combine: SQL Queries for Enterprise Databases

Posted on May 4, 2015 in Presentations

This presentation was given at Spring NEARC 2015 on May 11, 2015. If you are interested in getting comfortable writing queries with SQL and SQL spatial data types to take advantage of your enterprise data, then this is a great place to start. This presentation will introduce you to the SQL skills you need to write PostGIS spatial queries. It serves as a hands-on tutorial using real data in a CartoDB test environment. Using these SQL skills you will be able to generate useful ArcSDE views with a geodatabase stored in the PostgreSQL database management system.

This presentation was created and presented by Guido Stein, GIS Analyst, Applied Geographics. Guido’s focus within the company is around work flow automation and technology. He is a certified SafeSoftware FME Professional.

Click here for an embedded slide deck.

Click here for stand alone Presentation