Ryan Lambert
Owner / CEO at RustProof Labs
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.
Upcoming presentations
No upcoming presentations...
Past presentations
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....
Oct 5 2021
OpenStreetMap to PostGIS: Easier and Better!
Loading high quality geospatial data
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...
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.
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.
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.
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.
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.
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...
"Right size" your PostGIS data
Understanding spatial data concepts
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...
Mar 20 2019