ST_Intersection

Returns the closed-set spherical intersection of two Geography values. Edges are interpreted as great-circle arcs. Boundary-only intersections are retained.

Signatures

ST_Intersection(A: Geography, B: Geography)

Parameters

Geography

required

The first geography.

Geography

required

The second geography.

Return type

The spherical intersection.

The output copies the first input’s SRID without transforming either input or validating that their SRIDs match.

Example

SELECT ST_AsText(ST_Intersection(
  ST_GeogFromWKT('POINT (-73.9857 40.7484)', 4326),
  ST_GeogFromWKT('POINT (-73.9857 40.7484)', 4326)
))

POINT (-73.9857 40.7484)

⌘I

Wherobots Cloud REST API

WherobotsDB

Vector tiles (PMTiles)

Havasu (Iceberg) table management

GeoStats and Map Matching

Rasterflow

Signatures

Parameters

Return type

Example

​Signatures

​Parameters

​Return type

​Example

Signatures

Parameters

Return type

Example