PostGIS

Table of contents

1. 1. Introductory Quiz

   0/8

   Not sure if you're ready to take this course? Take this preliminary quiz to find out.

   List of exercises Start now
   1. Introduction
      1. Welcome
      2. Selecting data
      3. Filtering rows
      4. Grouping rows
      5. Ordering rows
      6. Filtering groups
      7. Joining tables
      8. Congratulations

2. 2. Introduction to spatial databases and PostGIS

   0/6

   We're getting started with PostGIS. You'll learn the basic terminology related to spatial databases.

   List of exercises Start now
   1. Introduction to spatial databases
      1. Spatial databases
      2. PostgreSQL and PostGIS
      3. Geometry vs. Geography columns
      4. Foretaste of part 2
   2. Short quiz
      1. Quiz
      2. Congratulations

3. 3. Geometry basics

   0/38

   That's where the real fun begins. You'll get to know points, linestrings and polygons.

   List of exercises Buy course
   1. Introduction
      1. Welcome
      2. Our data
      3. Geometry vs. Geography - detailed explanation
      4. Visualizing results in our course
      5. Simple types of spatial data
   2. Points
      1. Getting to know the table sf_tram_stops
      2. Getting to know the table sf_atms
      3. WKT for points
      4. GPS coordinates
      5. ST_X, ST_Y
      6. ST_GeomFromText
   3. Linestrings
      1. Getting to know the sf_selected_railways table
      2. Getting to know the sf_bicycle_routes table
      3. WKT for linestrings
      4. ST_StartPoint and ST_EndPoint
      5. ST_Npoints
      6. ST_Length
      7. SRIDs and SRS
      8. SRIDs and SRS 2
      9. ST_Transform
      10. ST_Transform - exercise
      11. ST_SRID
      12. Exercise 1
      13. Exercise 2
   4. Polygons
      1. Getting to know the table sf_planning_districts
      2. Getting to know the table sf_hotels
      3. Polygons
      4. WKT for polygons
      5. ST_Perimeter
      6. ST_Area
      7. Exercise 1
      8. Exercise 2
   5. Summary
      1. Summary
      2. Exercise 1
      3. Exercise 2
      4. Exercise 3
      5. Exercise 4
      6. Congratulations

4. 4. Relationships between geometries

   0/29

   How can points, linestrings and polygons relate to each other? Let's find out in this part of the course.

   List of exercises Buy course
   1. Introduction
      1. Introduction
   2. ST_Equals
      1. Get to know sf_restaurants
      2. Function - ST_Equals
      3. How ST_Equals works
      4. ST_Equals and equality
   3. Relationships Between Geometries
      1. Function - ST_Overlaps
      2. ST_Within
      3. ST_Contains
      4. ST_Touches
      5. ST_Intersects
      6. Additional exercise - ST_Intersects
      7. Additional exercise 1
      8. Additional exercise 2
   4. ST_Distance and ST_Dwithin
      1. ST_Distance
      2. ST_DWithin
      3. ST_DWithin additional exercise
      4. ST_DWithin together with ST_Distance
   5. Spatial joins practice
      1. Get to know sf_household_types
      2. Spatial joins - exercise 1
      3. Spatial joins - exercise 2
      4. Spatial function inside aggregates
      5. Spatial functions inside aggregates - exercise
   6. Summary
      1. Summary
      2. Exercise 1
      3. Exercise 2
      4. Exercise 3
      5. Exercise 4
      6. Exercise 5
      7. Congratulations

5. 5. Additional geometry features

   0/19

   In this part, we'll present further spatial functions and introduce collections.

   List of exercises Buy course
   1. Introduction
      1. Welcome
   2. Functions returning geometries
      1. Functions returning geometries - introduction
      2. ST_Centroid
      3. ST_PointOnSurface
      4. ST_Centroid vs ST_PointOnSurface
      5. ST_Buffer
      6. ST_Intersection
      7. ST_Union
      8. Further functions
   3. Collections
      1. Introduction to collections
      2. ST_GeometryN
      3. ST_NumGeometries
      4. ST_Area
      5. ST_Length
   4. Summary
      1. Summary
      2. Exercise 1
      3. Exercise 2
      4. Exercise 3
      5. Congratulations

6. 6. Geography

   0/18

   Finally, it's time to get to know geography column type.

   List of exercises Buy course
   1. Introduction
      1. Introduction
   2. Geometry vs. Geography
      1. Get to know table usa_states
      2. Geometry vs. Geography - performance
      3. Geometry vs. Geography - how they work
      4. Geometry vs. Geography - when to use
      5. Casting geometry to geography
      6. Comparing two values from the same table
      7. Casting geography to geometry
      8. Functions which support geography
      9. Functions which support geography - additional exercise
      10. Functions which quasi-support geography
      11. Functions which do not support geography
      12. Geography in geometry functions
   3. Summary
      1. Summary
      2. Question 1
      3. Question 2
      4. Question 3
      5. Congratulations

7. 7. Practice

   0/18

   Do you think you remember everything from our course? It's time to practice before the final quiz.

   List of exercises Buy course
   1. Introduction
      1. Introduction
   2. Practice
      1. Exercise 1
      2. Exercise 2
      3. Exercise 3
      4. Exercise 4
      5. Exercise 5
      6. Exercise 6
      7. Exercise 7
      8. Exercise 8
      9. Exercise 9
      10. Exercise 10
      11. Exercise 11
      12. Exercise 12
      13. Exercise 13
      14. Exercise 14
      15. Exercise 15
      16. Exercise 16
   3. Summary
      1. Congratulations

8. 8. Final quiz

   0/12

   The time has come to test your knowledge in the final PostGIS quiz.

   List of exercises Buy course
   1. Introduction
      1. Introduction
   2. Quiz
      1. Question 1
      2. Question 2
      3. Question 3
      4. Question 4
      5. Question 5
      6. Question 6
      7. Question 7
      8. Question 8
      9. Question 9
      10. Question 10
   3. Congratulations
      1. Congratulations

Get the Certificate of Competency in SQL

This certificate will confirm your practical SQL problem-solving skills

Obtain the Certificate Learn more