We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

Using PostGIS in a real advanced way!

Formal Metadata

Title
Using PostGIS in a real advanced way!
Title of Series
Part Number
11
Number of Parts
193
Author
License
CC Attribution 3.0 Germany:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal purpose as long as the work is attributed to the author in the manner specified by the author or licensor.
Identifiers
Publisher
Release Date2016
LanguageEnglish

Content Metadata

Subject Area
Genre
Abstract
A lot of people use PostGIS as a basic GIS toolbox, but very few use it in a real advanced way. To progress towards full PostGIS power, we can first make use of advanced native PostGIS functions. Using some extensions related to PostGIS, such as SFCGAL (for 3D data management), PostGIS Raster, PgPointCloud or even the latest pgsql-postal (for address normalization)... Then we can mix PostGIS functions with advanced standardized SQL features provided by PostgreSQL 9.x itself (CTE, Window functions, FDW, join and aggregate pushdowns…). Even better, use PostgreSQL bindings for data analysis languages such as R or Python to create your own dedicated function set, and integrate them into your SQL queries. We conclude this session with perspectives on what the combination between GIS and data science could be.
Keywords