RustProof Labs: blogging for education (logo)

Webinar: Postgres 12 and PostGIS 3 (5/6)

By Ryan Lambert -- Published February 26, 2020

Below is the recording of my PostgreSQL 12 and PostGIS 3 webinar from February 26, 2020. This is the fifth in a series of six covering how I work with PostGIS and OpenStreetMap.

I had a great time presenting this session, I hope having this recording available is helpful. Below the video is a list the links showing throughout the slides.

Recording

Continue Reading

qgis2web to export and share interactive maps

By Ryan Lambert -- Published February 20, 2020

QGIS is an open-source GUI for working with GIS data, both for spatial analysis and creating beautiful maps. One of my favorite components of QGIS is its qgis2web plugin that makes it quick and easy to convert a styled QGIS map into a browser-based slippy map that can be easily shared. qgis2web currently supports generating output in three (3) popular formats: OpenLayers, Leaflet, and MapBox GL JS. This post covers the basic process of preparing a QGIS project to generate polished interactive maps via qgis2web.

I discovered QGIS a few years ago. Over time it has become my go-to desktop GUI for GIS work.

Click here for the interactive map.

QGIS Project

I setup an example project in QGIS that uses an OpenStreetMap base layer (from QuickMapServices plug-in) plus two layers of U.S. Census Bureau data loaded from a PostGIS database I had handy. One layer provides boundaries and labels for the counties in Colorado, the other visualizes population density by block group.

Continue Reading

Webinar: PostGIS Queries and Performance (4/6)

By Ryan Lambert -- Published February 16, 2020

Below is the recording of my PostGIS Spatial Queries and Performance Tuning webinar from February 11, 2020. This is the fouth in a series of six covering how I work with PostGIS and OpenStreetMap.

I had a great time presenting this session, I hope having this recording available is helpful. Below the video is a list the links showing throughout the slides.

Recording

Continue Reading

Webinar: Exploring OpenStreetMap from PostGIS: Tools and Queries (3/6)

By Ryan Lambert -- Published February 09, 2020

Below is the recording of my Exploring OpenStreetMap from PostGIS: Tools and Queries webinar from January 28, 2020. This is the third in a series of six covering how I work with PostGIS and OpenStreetMap.

I had a great time presenting this session, I hope having this recording available is helpful. Below the video is a list the links showing throughout the slides.

Recording

Continue Reading

Webinar: Load PostGIS with osm2pgsql (2/6)

By Ryan Lambert -- Published January 27, 2020

Below is the recording of my Load PostGIS with osm2pgsql webinar from January 14, 2020. This is the second in a series of six covering how I work with PostGIS and OpenStreetMap.

I had a great time presenting this session, I hope having this recording available is helpful. Below the video is a list the links showing throughout the slides.

Recording

Continue Reading