In this section, we will see a subset of the most useful spatial functions that can be used to extract the information that we need from the databases. These functions will be illustrated through practical examples mentioned earlier. The functions that we will cover are as follows:
It returns the distance between two geometries in projected units, as we saw in Chapter 3, Inserting GIS Objects, which mentions the measurement units in which the spatial coordinate is given. As an example, the
POINT(-1.344165 51.381320) position is given in degrees; another geographic reference system could use a different unit of measurement, such as ...