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

Guido Stein certified on Safe Software’s FME Platform

Posted on March 11, 2015 in News

Guido Stein recently earned certification as a Safe Software FME Professional based on his demonstration of advanced expertise and experience with FME.

“Managing interoperability, conversion and transformation processes for multi-sourced, complicated and large geospatial datasets is a constant challenge for many government agencies,” said Rich Grady. “We’ve been using Safe Software’s FME to meet this challenge. Guido’s dedication to applying FME to help our clients automate interoperability workflows and data transformations has been exemplary.”

Safe Software’s FME is a powerful data interoperability and transformation engine with a large set of data readers and writers that AppGeo uses to address CAD-GIS interoperability, data aggregation, data transformation and standardization, and data quality assurance and control for its clients. By authoring workflows, AppGeo also help clients automate challenging data transformation tasks.

“I am very excited about getting this certification,” said Stein. “I have been using the Safe Software FME platform for many years and continue to look forward to solving problems with it. Having this certification will allow me to continue to spread the good word about the software and people at Safe Software.”

continue reading...