Introduction to PostGIS

Kayla Patel, a member of the city of Boston’s Analytics Team has a three-part write up introducing PostGIS.  PostGIS is an open source extender for PostgreSQL. PostGIS extends the capabilities of PostgreSQL,  increasing its management capabilities by adding geospatial types and functions to enhance spatial data handled within a relational database structure (more: What is PostGIS?).

The first part of the Introduction to PostGIS series provides an over of the open source software program including how and why to use it, how to use it with Boston’s GIS toolsets, and using it to work with map projections.

Part two reviews how to add and populate a geometry column, checking what the map projection is off a GIS dataset, how to transform a dataset to a different map projection, and how to get X and Y coordinate values from a geometry column.

Ad

Part three, entitled “How to get insights from your data”, dives into more advanced functionality of PostGIS.  This includes spatial indexing, spatial joins, buffering, finding the nearest, and clustering.

Each concept review in the introduction to PostGIS contains links for further reading and resources.

Example of a dataset with a geometry type of “multipolygon”. From: Patel, 2019

See Also

Ad:
Share

Recent Posts

R Packages for Spatial Analysis

Looking for R spatial packages?

2 weeks ago

Case Study: How Brindisi, Italy is Using GIS to Help Preserve its Ancient Architecture

The city of Brindisi, Italy deployed a solution from Pitney Bowes® that provides 80 to 90 percent faster performance, while…

3 weeks ago

Free Ways to Learn QGIS

If you want to start learning how to use QGIS, a free and open source GIS software package, there are…

3 weeks ago

Esri Announces Student Rate for Annual International User Conference

For $100, students can attend the entire five-day Esri International User Conference which takes place from July 8 to 12,…

3 weeks ago
Ad

First Data from NASA’s GEDI Program to 3D Map Forests

The first set of data that have returned have demonstrated GEDI is able to measure density of forests far better…

4 weeks ago

Missed the Latest QGIS User Conference? Access the Videos Online

Recorded presentations from the 2019 QGIS International User Conference are now available online.

4 weeks ago