Only this week, get the SQL Complete Track of 9 courses in a special prize of $330 $89!
Introduction to spatial databases
Short quiz
5. Quiz


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.