> ## Documentation Index
> Fetch the complete documentation index at: https://docs.cockroachlabs.com/llms.txt
> Use this file to discover all available pages before exploring further.

# ST_Equals

Given two shapes *A* and *B*, `ST_Equals(A, B)` returns `true` if every point in the set of points that make up *A* is also in *B*, and if every point in the set of points that make up *B* is also in *A*.  The ordering of the points in *A* and *B* may differ, but they must be made up of equivalent sets.

Another way of describing `ST_Equals(A, B)` is that it will return `true` if both `ST_Within(A, B)` and `ST_Within(B, A)` also return `true`.

`ST_Equals` works on the following data types:

* [`GEOMETRY`](/docs/stable/architecture/glossary#geometry)

> [!NOTE]
>
> \`\` will attempt to use any available [spatial index](/docs/stable/spatial-indexes.md) to speed up its operation.  Use the prefixed variant `_` if you do not want any spatial indexes to be used.

## Examples

> [!NOTE]
>
> The screenshots in these examples were generated using [geojson.io](http://geojson.io), but they are designed to showcase the shapes, not the map.  Representing `GEOMETRY` data in GeoJSON can lead to unexpected results if using geometries with [SRIDs](/docs/stable/architecture/glossary.md#srid) other than 4326 (as shown below).

### True

In this example, \`\` returns `true` because:

* Every Point in the set of Points that make up Polygon *A* is also in Polygon *B*, and  every Point in the set of Points that make up Polygon *B* is also in Polygon *A*

As mentioned above, the ordering of the points in *A* and *B* does not matter.  Below, there are two triangles with the same vertices, which are ordered differently.  In the screenshot, one triangle is drawn in yellow, and the other blue.  The blue and yellow strokes of the two separate triangles' boundaries are visible. Because the images are overlaid on each other, the yellow and blue combine to make part of the exterior outline of the image a green color.

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
SELECT st_equals(st_geomfromtext('SRID=4326;POLYGON((-87.906471 43.038902, -95.992775 36.153980, -75.704722 36.076944, -87.906471 43.038902))'), st_geomfromtext('SRID=4326;POLYGON((-95.992775 36.153980, -87.906471 43.038902, -75.704722 36.076944, -95.992775 36.153980))'));
```

```
   st_equals
---------------
     true

(1 row)
```

![ST\_Equals - true](https://mintcdn.com/cockroachlabs/bBD0UEapbn6fk8Rb/images/common/geospatial/st_equals_true.png?fit=max\&auto=format\&n=bBD0UEapbn6fk8Rb\&q=85\&s=da756c919f3920f018eea2c5b474b3d3)

### False

In this example, \`\` returns `false` because:

* It's obvious that not every Point that makes up the set of Points in Polygon *A* is not also in Polygon *B*.

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
SELECT st_equals(st_geomfromtext('SRID=4326;POLYGON((-87.906471 43.038902, -95.992775 36.153980, -75.704722 36.076944, -87.906471 43.038902))'), st_geomfromtext('SRID=4326;POLYGON((-84.191605 39.758949, -75.165222 39.952583, -78.878738 42.880230, -84.191605 39.758949))'));
```

```
   st_equals
---------------
     false
(1 row)
```

![ST\_Equals - false](https://mintcdn.com/cockroachlabs/bBD0UEapbn6fk8Rb/images/common/geospatial/st_equals_false.png?fit=max\&auto=format\&n=bBD0UEapbn6fk8Rb\&q=85\&s=4abe93c67383c323a8288a6a97fce51b)

## See also

* [Spatial and GIS Glossary of Terms](/docs/stable/architecture/glossary.md)
* [Spatial indexes](/docs/stable/spatial-indexes.md)
* [Spatial functions](/docs/stable/functions-and-operators.md#spatial-functions)
* [`ST_Covers`](/docs/stable/st_covers)
* [`ST_CoveredBy`](/docs/stable/st_coveredby)
* [`ST_Contains`](/docs/stable/st_contains)
* [`ST_Within`](/docs/stable/st_within)
* [`ST_Intersects`](/docs/stable/st_intersects)
* [`ST_CoveredBy`](/docs/stable/st_coveredby)
* [`ST_Covers`](/docs/stable/st_covers)
* [`ST_Disjoint`](/docs/stable/st_disjoint)
* [`ST_Overlaps`](/docs/stable/st_overlaps)
* [`ST_Touches`](/docs/stable/st_touches)
* [`ST_ConvexHull`](/docs/stable/st_convexhull)
* [`ST_Union`](/docs/stable/st_union)
* [Migrate from Shapefiles](/docs/stable/migrate-from-shapefiles.md)
* [Migrate from GeoJSON](/docs/stable/migrate-from-geojson.md)
* [Migrate from GeoPackage](/docs/stable/migrate-from-geopackage.md)
* [Migrate from OpenStreetMap](/docs/stable/migrate-from-openstreetmap.md)
* [Introducing Distributed Spatial Data in CockroachDB](https://www.cockroachlabs.com/blog/spatial-data/) (blog post)