Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

PostGIS

Introduction to spatial databases
Short quiz
5. Quiz

Instruction

Good job! Before we call it a day, we'd like to present you with a couple theoretical questions to answer in a short quiz. Let's get started!

  • Spatial databases are optimized to store and query geometric data.
  • Points, linestrings, and polygons are basic geometric objects that can be found in spatial databases.
  • Spatial database also goes under the following names: geodatabase, geospatial database, geographical database.
  • PostGIS is the spatial extension for PostgresSQL that enables spatial data management.
  • Even though there are a few spatial databases other than PostGIS, all the popular ones follow the standard set out by Open Geospatial Consortium.
  • There are two main types of spatial columns: geometry and geography. The first one is quicker, the latter is more accurate.
  • The data in geometry columns are stored in the internal PostGIS format. We can convert this data to a few text output formats: Well-Known Text (WKT), Well-Known Binary (WKB), Geographic Mark-up Language (GML), etc.

Exercise

Answer following questions – fill the template with trues and falses.

  1. PostGIS is a spatial extension for PostgreSQL. True or false?
  2. PostgreSQL stores points as Well-Known Text. True or false?
  3. The function ST_AsText is used to convert a numerical column into a column with text. True or false?