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 | 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 Date | |
| Language | |
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 | |