Oreilly – PostGIS in Action, Third Edition, Video Edition 2024-11

Apr 18, 2025 - 19:29

0 0

PostGIS in Action Third Edition Video Edition. In this video course, you will be introduced to one of the most powerful Postgres database extensions, PostGIS. This course takes a practical, step-by-step approach to help you perform complex spatial queries on your spatial data and use it to build a variety of spatial applications. This course is the video version of the third edition of the best-selling book PostGIS in Action. In this course, you can view the text, diagrams, sample code, and images while watching the videos. This learning method gives you a deeper understanding of the concepts.

What you will learn:

Introduction to Spatial Databases: You will learn the basic concepts of spatial databases.
Spatial Data Types: You will explore different types of spatial data, such as vector, raster, and topology, and learn how to work with functions and queries related to each.
Real-World Applications of PostGIS: You will learn how to solve real-world problems using PostGIS.
Developing Web and Desktop Applications with PostGIS: You will learn how to extend PostGIS to your web and desktop applications.
Querying Foreign Data: You will learn how to query foreign data using PostgreSQL Foreign Data Wrappers.
Query Optimization: You will learn different ways to optimize queries to increase speed.
Simplifying geometries: You will learn techniques for simplifying geometries to increase efficiency.

This course is suitable for people who:

They are familiar with relational databases and the SQL language.
They are looking to learn the concepts of spatial databases and PostGIS.
They want to develop their spatial applications using PostGIS.
They do not require prior knowledge of spatial data or geographic information systems.

Course details

Publisher: Oreilly
Instructor: Regina O. Obe , Leo S. Hsu
Training level: Beginner to advanced
Training duration: 1 hour and 57 minutes

Course headings

Part 1. Introduction to PostGIS
Chapter 1. What is a spatial database?
Chapter 1. Introducing PostGIS
Chapter 1. Installing PostGIS
Chapter 1. Spatial data types
Chapter 1. Hello real world
Chapter 1. Summary
Chapter 2. Spatial data types
Chapter 2. Geometry
Chapter 2. Geography
Chapter 2. Raster
Chapter 2. Summary
Chapter 3. Spatial reference systems
Chapter 3. Selecting a spatial reference system for storing data
Chapter 3. Determining the spatial reference system of source data
Chapter 3. History of PROJ support in PostGIS
Chapter 3. Summary
Chapter 4. Working with real data
Chapter 4. Downloading files
Chapter 4. Extracting files
Chapter 4. Importing and exporting shapefiles
Chapter 4. Importing and exporting vector data with ogr2ogr
Chapter 4. Querying external data using PostgreSQL foreign data wrappers
Chapter 4. Importing raster data with raster2pgsql
Chapter 4. Exporting raster data with GDAL
Chapter 4. Summary
Chapter 5. Using PostGIS on the desktop
Chapter 5. OpenJUMP
Chapter 5. QGIS
Chapter 5. GvSIG
Chapter 5. JupyterLab and Jupyter Notebook
Chapter 5. Summary
Chapter 6. Geometry and geography functions
Chapter 6. Constructor functions
Chapter 6. Accessor and setter functions
Chapter 6. Measurement functions
Chapter 6. Decomposition functions
Chapter 6. Composition functions
Chapter 6. Simplification functions
Chapter 6. Summary
Chapter 7. Raster functions
Chapter 7. Raster constructors
Chapter 7. Raster output functions
Chapter 7. Raster accessors and setters
Chapter 7. Georeferencing functions
Chapter 7. Reclassing functions
Chapter 7. Polygonizing functions
Chapter 7. Summary
Chapter 8. Spatial relationships
Chapter 8. Relating two geometries
Chapter 8. Summary
Part 2. Putting PostGIS to work
Chapter 9. Proximity analysis
Chapter 9. Using KNN with geography types
Chapter 9. Geotagging
Chapter 9. Summary
Chapter 10. PostGIS TIGER geocoder
Chapter 10. Loading TIGER data
Chapter 10. Normalizing addresses
Chapter 10. Geocoding
Chapter 10. Reverse geocoding
Chapter 10. Summary
Chapter 11. Geometry and geography processing
Chapter 11. Clipping, splitting, tessellating
Chapter 11. Breaking linestrings into smaller segments
Chapter 11. Translating, scaling, and rotating geometries
Chapter 11. Using geometry functions to manipulate and create geographies
Chapter 11. Summary
Chapter 12. Raster processing
Chapter 12. Forming larger rasters using spatial aggregate functions
Chapter 12. Working with bands
Chapter 12. Tiling rasters
Chapter 12. Raster and geometry intersections
Chapter 12. Raster statistics
Chapter 12. Map algebra
Chapter 12. Summary
Chapter 13. Building and using topologies
Chapter 13. Using topologies
Chapter 13. Topology of Victoria, BC
Chapter 13. Fixing topogeometry issues by editing topology primitives
Chapter 13. Inserting and editing large data sets
Chapter 13. Simplifying with topology in mind
Chapter 13. Topology validation and summary functions
Chapter 13. Summary
Chapter 14. Organizing spatial data
Chapter 14. Modeling a real city
Chapter 14. Making auto-updatable views
Chapter 14. Using triggers and rules
Chapter 14. Summary
Chapter 15. Query performance tuning
Chapter 15. Planner statistics
Chapter 15. Using explain to diagnose problems
Chapter 15. Planner and indexes
Chapter 15. Common SQL patterns and how they affect plans
Chapter 15. System and function settings
Chapter 15. Optimizing spatial data
Chapter 15. Summary
Part 3. Using PostGIS with other tools
Chapter 16. Extending PostGIS with pgRouting and procedural languages
Chapter 16. Extending PostgreSQL with PLs
Chapter 16. PL/R
Chapter 16. PL/Python
Chapter 16. PL/V8: JavaScript in the database
Chapter 16. Summary
Chapter 17. Using PostGIS in web applications
Chapter 17. Mapping servers
Chapter 17. Mapping clients
Chapter 17. Using MapServer
Chapter 17. Using GeoServer
Chapter 17. Basics of OpenLayers and Leaflet
Chapter 17. Displaying data with PostGIS queries and web scripting
Chapter 17. Summary
Appendix C. SQL primer
Appendix C. Querying data with SQL
Appendix C. UPDATE, INSERT, and DELETE
Appendix D. PostgreSQL features
Appendix D. Useful PostgreSQL resources
Appendix D. Connecting to a PostgreSQL server
Appendix D. Controlling access to data
Appendix D. Backup and restore
Appendix D. Data structures and objects
Appendix D. Writing functions in SQL
Appendix D. Writing functions in PL/pgSQL
Appendix D. Performance index
Appendix D. Computed columns

Oreilly – PostGIS in Action, Third Edition, Video Edition 2024-11