How Green Was My Valley – Spatial Analytics with PostgreSQL, PostGIS, R, and PL/R

By 14 de março de 2018 Palestrante

Increasingly today, collected data includes a spatial component. PostgreSQL + PostGIS, combined with R via PL/R, provides an awesome tool-chain for advanced spatial analytics on such data! This presentation will introduce the audience to these tools.

Increasingly today, collected data includes a spatial component. PostgreSQL + PostGIS, combined with R via PL/R, provides an awesome tool-chain for advanced spatial analytics on such data! This presentation will introduce the audience to PL/R, discuss the pros and cons of this approach to spatial data analysis, then walk through examples of advanced spatial analysis using PostgreSQL, PostGIS, and PL/R. Specifically covered:

Overview
* Tutorial problem set
* Components
* Environment setup Ingest
* Admin boundaries
* Geocoding
* MODIS Raster data Analytics
* Simple map output
* Raster date processing
* Regional aggregation and trending

Assunto:
SQL: Window Functions, FDW, Full Text Search, visões materializadas, etc

Nível:
Intermediário

Joe Conway

Estados Unidos

Joe Conway is an innovative leader with broad experience in a wide array of disciplines and extensive international business exposure. He has been involved with the PostgreSQL community since 1998, presently as a PostgreSQL Committer, Major Contributor, and Infrastructure Team member. He is also the author and maintainer of a PostgreSQL procedural language handler for the R language, PL/R. Joe is currently VP PostgreSQL Engineering at Crunchy Data Solutions and a Board Member at the United States PostgreSQL Association (PgUS).

Blog
Twitter
LinkedIn