About
PostgreSQL is my database of choice; skydiving is my adrenaline rush of choice!
I started my technology-heavy career in 2003 working in the professional audio industry from a computing perspective. By 2008 I had become fully immersed in the world of databases, programming, and automating away tedious data-related tasks for the office. PostGIS was the driving force behind my initial use, and eventual love, of PostgreSQL.
Ryan Lambert has presented the following presentations
Routing with PostGIS and OpenStreetMap
at
South Africa 2021
presented by Ryan Lambert
Show how to easily load and prepare OpenStreetMap roads for routing. Data prep includes access control and multiple routing methods (motor, cycle, foot). This process shows a variety of intro-PostGIS concepts and functions as part of a more advanced talk in disguise. Also covers new features in osm2pgsql, the main tool used to load OSM data into PostGIS.
Download and Links: [https://blog....
more Tue 5 2021 PostGIS
OpenStreetMap to PostGIS: Easier and Better!
at
2021 Postgres Conference Webinars
Loading high quality geospatial data
presented by Ryan Lambert
video
This session will be a live demo to show how easy it is to import high quality OpenStreetMap data into PostGIS / Postgres. The long-used osm2pgsql tool has a new Flex output (Flex == "flexible") that has completely changed the game! This demo highlights how the osm2pgsql Flex output is being used by PgOSM-Flex to provide a high quality "off-th...
more Wed 31 2021 Dev
Advanced Operations and Features
at
Postgres Webinar Series
presented by Ryan Lambert
video
This final session focuses on PostGIS, scratching the surface of a range of the advanced operations PostGIS is capable of. Preparing data in a different formats (GeoJSON, MVT) for external dependencies, 3D rendering, and routing are some of the topics covered.
Tue 3 2020 GIS
PostgreSQL 12 and PostGIS 3.0
at
Postgres Webinar Series
presented by Ryan Lambert
video
PostgreSQL 12 and PostGIS 3.0 bring an amazing plethora of improvements to PostGIS-enabled databases. This session highlights a number of reasons to upgrade to the latest and greatest versions! Parallel query improvements, generated columns and covering GIST indexes are some of the highlights.
Wed 26 2020 GIS
PostGIS Spatial Queries and Performance Tuning
at
Postgres Webinar Series
presented by Ryan Lambert
video
This session is a deep dive into complex spatial queries and performance tuning with PostGIS. Common performance headaches are explored with a variety of approaches to remedy. GIST indexes, proper data modeling, and materialized views are demonstrated.
Tue 11 2020 GIS
Loading PostGIS with osm2pgsql
at
Postgres Webinar Series
presented by Ryan Lambert
video
This session dives into how to install, configure and use osm2pgsql on Linux to load OpenStreetMap data into PostGIS. Loading the data into PostGIS is the first step required to begin consuming and leveraging OpenStreetMap data. Where to download OSM data, best practices, helpful tricks and common pitfalls are all covered.
Exploring OpenStreetMap from PostGIS: Tools and Queries
at
Postgres Webinar Series
presented by Ryan Lambert
video
This session introduces the tools, concepts and basic queries needed for working with spatial data stored in PostGIS. Building on the prior session, this session illustrates how to query and visualize OpenStreetMap data loaded to PostGIS. Tools discussed in this session include GUI software as well as on-line resources for learning more about OpenStreetMap's Key/Value data structure.
Tue 28 2020 GIS
Getting Started with PostGIS and OpenStreetMap
at
Postgres Webinar Series
presented by Ryan Lambert
video
This is the first of six (6) sessions covering how to find, load, and consume OpenStreetMap data using PostGIS and PostgreSQL. This session covers what PostGIS and OpenStreetMap are, and why they are important in our modern world. No prior experience with PostGIS or OpenStreetMap is required for this introductory session.
The session recording and links shown are available at: https://blo...
more Mon 6 2020 GIS
"Right size" your PostGIS data
at
Postgres Conference
Understanding spatial data concepts
presented by Ryan Lambert
The PostGIS extension turns Postgres into the world's most advanced open source spatial database. Not all DBA's are experienced with spatial data or spatial analysis and that can cause misunderstandings and performance problems. The core problem is often a problem with how the spatial data is loaded and provided to analysts. This presentation provides practical examples of how to understand a...
more Wed 20 2019 Data