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

توضیحات

مشخصات دوره

• ناشر: Oreilly
• مدرس: Regina O. Obe, Leo S. Hsu
• سطح آموزش: مبتدی تا پیشرفته
• مدت زمان آموزش: 1 ساعت و 57 دقیقه

سرفصل های دوره

• 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. Index performance
• Appendix D. Computed columns

تصاویر دوره PostGIS in Action Third Edition Video Edition

نمونه فیلم دوره

لینک دانلود

دانلود بخش 1 – 1 گیگابایت

دانلود بخش 2 – 1 گیگابایت

دانلود بخش 3 – 1 گیگابایت

دانلود بخش 4 – 175 مگابایت

گذرواژه فایل(ها): www.downloadly.ir

حجم فایل

3.1 گیگابایت