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.