{"id":7570,"date":"2026-08-10T09:45:42","date_gmt":"2026-08-10T09:45:42","guid":{"rendered":"https:\/\/nokobox.com\/index.php\/item\/oreilly-postgis-in-action-third-edition-video-edition-2024-11\/"},"modified":"2026-08-10T09:45:42","modified_gmt":"2026-08-10T09:45:42","slug":"oreilly-postgis-in-action-third-edition-video-edition-2024-11","status":"publish","type":"digital_item","link":"https:\/\/nokobox.com\/index.php\/item\/oreilly-postgis-in-action-third-edition-video-edition-2024-11\/","title":{"rendered":"Oreilly \u2013 PostGIS in Action, Third Edition, Video Edition 2024-11"},"content":{"rendered":"<div class=\"w-post-elm post_content\">\n<h2 style=\"text-align: left\"><span style=\"vertical-align: inherit\">Description<\/span><\/h2>\n<div id=\"chat-history\" class=\"chat-history-scroll-container ng-tns-c2537533752-2\" style=\"text-align: left\">\n<div id=\"c8e0407409249800\" class=\"conversation-container ng-tns-c2537533752-2 message-actions-hover-boundary response-optimization ng-star-inserted\">\n<div class=\"response-container ng-tns-c2001758256-47 response-optimization is-mobile ng-star-inserted response-container-has-multiple-responses\">\n<div class=\"presented-response-container ng-tns-c2001758256-47\">\n<div class=\"response-container-content ng-tns-c2001758256-47\">\n<div class=\"response-content ng-tns-c2001758256-47\">\n<div class=\"markdown markdown-main-panel tutor-markdown-rendering response-optimization stronger\">\n<p data-sourcepos=\"7:1-7:316\"><span style=\"vertical-align: inherit\">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.<\/span><\/p>\n<h3 data-sourcepos=\"13:1-13:25\"><span style=\"vertical-align: inherit\">What you will learn:<\/span><\/h3>\n<ul data-sourcepos=\"15:1-22:0\">\n<li data-sourcepos=\"15:1-15:93\"><span style=\"vertical-align: inherit\">Introduction to Spatial Databases: You will learn the basic concepts of spatial databases.<\/span><\/li>\n<li data-sourcepos=\"16:1-16:174\"><span style=\"vertical-align: inherit\">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.<\/span><\/li>\n<li data-sourcepos=\"17:1-17:113\"><span style=\"vertical-align: inherit\">Real-World Applications of PostGIS: You will learn how to solve real-world problems using PostGIS.<\/span><\/li>\n<li data-sourcepos=\"18:1-18:137\"><span style=\"vertical-align: inherit\">Developing Web and Desktop Applications with PostGIS: You will learn how to extend PostGIS to your web and desktop applications.<\/span><\/li>\n<li data-sourcepos=\"19:1-19:132\"><span style=\"vertical-align: inherit\">Querying Foreign Data: You will learn how to query foreign data using PostgreSQL Foreign Data Wrappers.<\/span><\/li>\n<li data-sourcepos=\"20:1-20:101\"><span style=\"vertical-align: inherit\">Query Optimization: You will learn different ways to optimize queries to increase speed.<\/span><\/li>\n<li data-sourcepos=\"21:1-22:0\"><span style=\"vertical-align: inherit\">Simplifying geometries: You will learn techniques for simplifying geometries to increase efficiency.<\/span><\/li>\n<\/ul>\n<h3 data-sourcepos=\"23:1-23:31\"><span style=\"vertical-align: inherit\">This course is suitable for people who:<\/span><\/h3>\n<ul data-sourcepos=\"25:1-29:0\">\n<li data-sourcepos=\"25:1-25:52\"><span style=\"vertical-align: inherit\">They are familiar with relational databases and the SQL language.<\/span><\/li>\n<li data-sourcepos=\"26:1-26:69\"><span style=\"vertical-align: inherit\">They are looking to learn the concepts of spatial databases and PostGIS.<\/span><\/li>\n<li data-sourcepos=\"27:1-27:74\"><span style=\"vertical-align: inherit\">They want to develop their spatial applications using PostGIS.<\/span><\/li>\n<li data-sourcepos=\"28:1-29:0\"><span style=\"vertical-align: inherit\">They do not require prior knowledge of spatial data or geographic information systems.<\/span><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<h3 style=\"text-align: left\"><span style=\"vertical-align: inherit\">Course details<\/span><\/h3>\n<ul style=\"text-align: left\">\n<li><span style=\"vertical-align: inherit\">Publisher: <\/span><a href=\"https:\/\/href.li\/?https:\/\/www.oreilly.com\/library\/view\/postgis-in-action\/9781617296697VE\/\" target=\"_blank\" rel=\"noopener\"><span style=\"vertical-align: inherit\">Oreilly<\/span><\/a><\/li>\n<li><span style=\"vertical-align: inherit\">Instructor: <\/span><a href=\"https:\/\/downloadlynet.ir\/tag\/regina-o-obe\/\"><span style=\"vertical-align: inherit\">Regina O. Obe<\/span><\/a><span style=\"vertical-align: inherit\"> , <a href=\"https:\/\/downloadlynet.ir\/tag\/leo-s-hsu\/\">Leo S. Hsu<\/a><\/span><\/li>\n<li><span style=\"vertical-align: inherit\">Training level: Beginner to advanced<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">Training duration: 1 hour and 57 minutes<\/span><\/li>\n<\/ul>\n<h3 style=\"text-align: left\"><span style=\"vertical-align: inherit\">Course headings<\/span><\/h3>\n<ul style=\"text-align: left\">\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Part 1. Introduction to PostGIS<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Chapter 1. What is a spatial database?<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Chapter 1. Introducing PostGIS<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Chapter 1. Installing PostGIS<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Chapter 1. Spatial data types<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Chapter 1. Hello real world<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Chapter 1. Summary<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Chapter 2. Spatial data types<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Chapter 2. Geometry<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Chapter 2. Geography<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Chapter 2. Raster<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Chapter 2. Summary<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Chapter 3. Spatial reference systems<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 3. Selecting a spatial reference system for storing data<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 3. Determining the spatial reference system of source data<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 3. History of PROJ support in PostGIS<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 3. Summary<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 4. Working with real data<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 4. Downloading files<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 4. Extracting files<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 4. Importing and exporting shapefiles<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 4. Importing and exporting vector data with ogr2ogr<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 4. Querying external data using PostgreSQL foreign data wrappers<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 4. Importing raster data with raster2pgsql<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 4. Exporting raster data with GDAL<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 4. Summary<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 5. Using PostGIS on the desktop<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 5. OpenJUMP<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 5. QGIS<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 5. GvSIG<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 5. JupyterLab and Jupyter Notebook<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 5. Summary<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 6. Geometry and geography functions<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 6. Constructor functions<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 6. Accessor and setter functions<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 6. Measurement functions<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 6. Decomposition functions<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 6. Composition functions<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 6. Simplification functions<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 6. Summary<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 7. Raster functions<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 7. Raster constructors<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 7. Raster output functions<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 7. Raster accessors and setters<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 7. Georeferencing functions<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 7. Reclassing functions<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 7. Polygonizing functions<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 7. Summary<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 8. Spatial relationships<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 8. Relating two geometries<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 8. Summary<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Part 2. Putting PostGIS to work<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 9. Proximity analysis<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 9. Using KNN with geography types<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 9. Geotagging<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 9. Summary<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 10. PostGIS TIGER geocoder<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 10. Loading TIGER data<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 10. Normalizing addresses<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 10. Geocoding<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 10. Reverse geocoding<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 10. Summary<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 11. Geometry and geography processing<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 11. Clipping, splitting, tessellating<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 11. Breaking linestrings into smaller segments<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 11. Translating, scaling, and rotating geometries<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 11. Using geometry functions to manipulate and create geographies<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 11. Summary<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 12. Raster processing<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 12. Forming larger rasters using spatial aggregate functions<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 12. Working with bands<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 12. Tiling rasters<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 12. Raster and geometry intersections<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 12. Raster statistics<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 12. Map algebra<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 12. Summary<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 13. Building and using topologies<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 13. Using topologies<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 13. Topology of Victoria, BC<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 13. Fixing topogeometry issues by editing topology primitives<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 13. Inserting and editing large data sets<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 13. Simplifying with topology in mind<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 13. Topology validation and summary functions<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 13. Summary<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 14. Organizing spatial data<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 14. Modeling a real city<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 14. Making auto-updatable views<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 14. Using triggers and rules<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 14. Summary<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 15. Query performance tuning<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 15. Planner statistics<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 15. Using explain to diagnose problems<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 15. Planner and indexes<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 15. Common SQL patterns and how they affect plans<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 15. System and function settings<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 15. Optimizing spatial data<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Chapter 15. Summary<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Part 3. Using PostGIS with other tools<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Chapter 16. Extending PostGIS with pgRouting and procedural languages<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Chapter 16. Extending PostgreSQL with PLs<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Chapter 16. PL\/R<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Chapter 16. PL\/Python<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Chapter 16. PL\/V8: JavaScript in the database<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Chapter 16. Summary<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Chapter 17. Using PostGIS in web applications<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Chapter 17. Mapping servers<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Chapter 17. Mapping clients<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Chapter 17. Using MapServer<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Chapter 17. Using GeoServer<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Chapter 17. Basics of OpenLayers and Leaflet<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Chapter 17. Displaying data with PostGIS queries and web scripting<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Chapter 17. Summary<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Appendix C. SQL primer<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Appendix C. Querying data with SQL<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Appendix C. UPDATE, INSERT, and DELETE<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Appendix D. PostgreSQL features<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Appendix D. Useful PostgreSQL resources<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Appendix D. Connecting to a PostgreSQL server<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Appendix D. Controlling access to data<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Appendix D. Backup and restore<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Appendix D. Data structures and objects<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Appendix D. Writing functions in SQL<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Appendix D. Writing functions in PL\/pgSQL<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Appendix D. Performance index<\/span><\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Appendix D. Computed columns<\/span><\/li>\n<\/ul>\n<h3 style=\"text-align: left\"><span style=\"vertical-align: inherit\">PostGIS in Action Third Edition Video Edition Course Images<\/span><\/h3>\n<p style=\"text-align: left\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-950499 size-full\" src=\"https:\/\/downloadly.ir\/wp-content\/uploads\/2024\/12\/PostGIS-in-Action-Third-Edition-Video-Edition2.png\" alt=\"PostGIS in Action Third Edition Video Edition\" width=\"1047\" height=\"367\"><\/p>\n<h3 style=\"text-align: left\"><span style=\"vertical-align: inherit\">Sample course video<\/span><\/h3>\n<div style=\"width: 640px;\" class=\"wp-video\"><span class=\"mejs-offscreen\">Video Player<\/span><\/p>\n<div id=\"mep_0\" class=\"mejs-container mejs-container-keyboard-inactive wp-video-shortcode mejs-video\" tabindex=\"0\" role=\"application\" aria-label=\"Video Player\" style=\"width: 640px; height: 360px; min-width: 217px;\">\n<div class=\"mejs-inner\">\n<div class=\"mejs-mediaelement\"><mediaelementwrapper id=\"video-148851-1\"><video class=\"wp-video-shortcode\" id=\"video-148851-1_html5\" width=\"640\" height=\"360\" preload=\"metadata\" src=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/PostGIS_in_Action_Third_Edition_Video_Edition_Downloadly.ir.mp4?_=1\" style=\"width: 640px; height: 360px;\"><source type=\"video\/mp4\" src=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/PostGIS_in_Action_Third_Edition_Video_Edition_Downloadly.ir.mp4?_=1\"><a href=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/PostGIS_in_Action_Third_Edition_Video_Edition_Downloadly.ir.mp4?nocache=1786110069078\">https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/PostGIS_in_Action_Third_Edition_Video_Edition_Downloadly.ir.mp4<\/a><\/video><\/mediaelementwrapper><\/div>\n<div class=\"mejs-layers\">\n<div class=\"mejs-poster mejs-layer\" style=\"display: none; width: 100%; height: 100%;\"><\/div>\n<div class=\"mejs-overlay mejs-layer\" style=\"display: none; width: 100%; height: 100%;\">\n<div class=\"mejs-overlay-loading\"><span class=\"mejs-overlay-loading-bg-img\"><\/span><\/div>\n<\/div>\n<div class=\"mejs-overlay mejs-layer\" style=\"display: none; width: 100%; height: 100%;\">\n<div class=\"mejs-overlay-error\"><\/div>\n<\/div>\n<div class=\"mejs-overlay mejs-layer mejs-overlay-play\" style=\"width: 100%; height: 100%;\">\n<div class=\"mejs-overlay-button\" role=\"button\" tabindex=\"0\" aria-label=\"Play\" aria-pressed=\"false\"><\/div>\n<\/div>\n<\/div>\n<div class=\"mejs-controls\">\n<div class=\"mejs-button mejs-playpause-button mejs-play\"><button type=\"button\" aria-controls=\"mep_0\" title=\"Play\" aria-label=\"Play\" tabindex=\"0\"><\/button><\/div>\n<div class=\"mejs-time mejs-currenttime-container\" role=\"timer\" aria-live=\"off\"><span class=\"mejs-currenttime\">00:00<\/span><\/div>\n<div class=\"mejs-time-rail\"><span class=\"mejs-time-total mejs-time-slider\" role=\"slider\" tabindex=\"0\" aria-label=\"Time Slider\" aria-valuemin=\"0\" aria-valuemax=\"0\" aria-valuenow=\"0\" aria-valuetext=\"00:00\"><span class=\"mejs-time-buffering\" style=\"display: none;\"><\/span><span class=\"mejs-time-loaded\"><\/span><span class=\"mejs-time-current\"><\/span><span class=\"mejs-time-hovered no-hover\"><\/span><span class=\"mejs-time-handle\"><span class=\"mejs-time-handle-content\"><\/span><\/span><span class=\"mejs-time-float\"><span class=\"mejs-time-float-current\">00:00<\/span><span class=\"mejs-time-float-corner\"><\/span><\/span><\/span><\/div>\n<div class=\"mejs-time mejs-duration-container\"><span class=\"mejs-duration\">00:00<\/span><\/div>\n<div class=\"mejs-button mejs-volume-button mejs-mute\"><button type=\"button\" aria-controls=\"mep_0\" title=\"Mute\" aria-label=\"Mute\" tabindex=\"0\"><\/button><a href=\"javascript:void(0);\" class=\"mejs-volume-slider\" aria-label=\"Volume Slider\" aria-valuemin=\"0\" aria-valuemax=\"100\" role=\"slider\" aria-orientation=\"vertical\"><span class=\"mejs-offscreen\">Use Up\/Down Arrow keys to increase or decrease volume.<\/span><\/p>\n<div class=\"mejs-volume-total\">\n<div class=\"mejs-volume-current\" style=\"bottom: 0px; height: 100%;\"><\/div>\n<div class=\"mejs-volume-handle\" style=\"bottom: 100%; margin-bottom: -3px;\"><\/div>\n<\/div>\n<p><\/a><\/div>\n<div class=\"mejs-button mejs-fullscreen-button\"><button type=\"button\" aria-controls=\"mep_0\" title=\"Fullscreen\" aria-label=\"Fullscreen\" tabindex=\"0\"><\/button><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"text-align: left\">\n<h3><span style=\"vertical-align: inherit\">Installation Guide<\/span><\/h3>\n<p><span style=\"vertical-align: inherit\">After Extract, view with your favorite player.<\/span><\/p>\n<p><span style=\"vertical-align: inherit\">Subtitles: None<\/span><\/p>\n<p><span style=\"vertical-align: inherit\">Quality: 1080p<\/span><\/p>\n<\/div>\n<h3 style=\"text-align: left\"><span style=\"vertical-align: inherit\">Download link<\/span><\/h3>\n<p style=\"text-align: left\"><a href=\"https:\/\/dl2.downloadly.ir\/Files\/Elearning\/Oreilly_PostGIS_in_Action_Third_Edition_Video_Edition_2024-11.part1_Downloadly.ir.rar?nocache=1786110067\"><span style=\"vertical-align: inherit\">Download Part 1 \u2013 1 GB<\/span><\/a><\/p>\n<p style=\"text-align: left\"><a href=\"https:\/\/dl2.downloadly.ir\/Files\/Elearning\/Oreilly_PostGIS_in_Action_Third_Edition_Video_Edition_2024-11.part2_Downloadly.ir.rar?nocache=1786110067\"><span style=\"vertical-align: inherit\">Download Part 2 \u2013 1 GB<\/span><\/a><\/p>\n<p style=\"text-align: left\"><a href=\"https:\/\/dl2.downloadly.ir\/Files\/Elearning\/Oreilly_PostGIS_in_Action_Third_Edition_Video_Edition_2024-11.part3_Downloadly.ir.rar?nocache=1786110067\"><span style=\"vertical-align: inherit\">Download Part 3 \u2013 1 GB<\/span><\/a><\/p>\n<p style=\"text-align: left\"><a href=\"https:\/\/dl2.downloadly.ir\/Files\/Elearning\/Oreilly_PostGIS_in_Action_Third_Edition_Video_Edition_2024-11.part4_Downloadly.ir.rar?nocache=1786110067\"><span style=\"vertical-align: inherit\">Download Part 4 \u2013 175 MB<\/span><\/a><\/p>\n<p style=\"text-align: left\"><span style=\"vertical-align: inherit\">File(s) password: www.downloadly.ir<\/span><\/p>\n<h3 style=\"text-align: left\"><span style=\"vertical-align: inherit\">File size<\/span><\/h3>\n<p style=\"text-align: left\"><span style=\"vertical-align: inherit\">3.1 GB<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Description PostGIS in Action Third Edition Video Edition. In this video course, you will be introduced to one of the most powerful Postgres database extensions<\/p>\n","protected":false},"author":1,"template":"","dgi_category":[10458],"dgi_tag":[68885,68886,68887,68888,68889,68890,68891],"class_list":["post-7570","digital_item","type-digital_item","status-publish","has-post-thumbnail","hentry","dgi_category-video-tutorials","dgi_tag-course-postgis-in-action-third-edition-video-edition","dgi_tag-download-course-postgis-in-action-third-edition-video-edition","dgi_tag-download-postgis-in-action-third-edition-video-edition","dgi_tag-free-download-postgis-in-action-third-edition-video-edition","dgi_tag-free-postgis-in-action-third-edition-video-edition","dgi_tag-leo-s-hsu","dgi_tag-regina-o-obe"],"_links":{"self":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/digital_item\/7570","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/digital_item"}],"about":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/types\/digital_item"}],"author":[{"embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"version-history":[{"count":0,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/digital_item\/7570\/revisions"}],"wp:attachment":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/media?parent=7570"}],"wp:term":[{"taxonomy":"dgi_category","embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/dgi_category?post=7570"},{"taxonomy":"dgi_tag","embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/dgi_tag?post=7570"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}