Geospatial Functions

function bing_tile(bigint, bigint, bigint) returns bingtile
function bing_tile(varchar) returns bingtile

function bing_tile_at(double, double, bigint) returns bingtile

function bing_tile_coordinates(bingtile) returns row(x bigint, y bigint)

function bing_tile_polygon(bingtile) returns geometry

function bing_tile_quadkey(bingtile) returns varchar

function bing_tile_zoom_level(bingtile) returns tinyint

function bing_tiles_around(double, double, bigint) returns array<bingtile>
function bing_tiles_around(double, double, bigint, double) returns array<bingtile>

function convex_hull_agg(geometry) returns geometry

function from_encoded_polyline(varchar) returns geometry

function from_geojson_geometry(varchar) returns sphericalgeography

function geometry_from_hadoop_shape(varbinary) returns geometry

function geometry_invalid_reason(geometry) returns varchar

function geometry_nearest_points(geometry, geometry) returns row(c0 geometry, c1 geometry)

function geometry_to_bing_tiles(geometry, bigint) returns array<bingtile>

function geometry_union(array<geometry>) returns geometry

function geometry_union_agg(geometry) returns geometry

function great_circle_distance(double, double, double, double) returns double

function line_interpolate_point(geometry, double) returns geometry

function line_interpolate_points(geometry, double) returns array<geometry>

function line_locate_point(geometry, geometry) returns double

function simplify_geometry(geometry, double) returns geometry

function ST_Area(geometry) returns double
function ST_Area(sphericalgeography) returns double

function ST_AsBinary(geometry) returns varbinary

function ST_AsText(geometry) returns varchar

function ST_Boundary(geometry) returns geometry

function ST_Buffer(geometry, double) returns geometry

function ST_Centroid(geometry) returns geometry

function ST_Contains(geometry, geometry) returns boolean

function ST_ConvexHull(geometry) returns geometry

function ST_CoordDim(geometry) returns tinyint

function ST_Crosses(geometry, geometry) returns boolean

function ST_Difference(geometry, geometry) returns geometry

function ST_Dimension(geometry) returns tinyint

function ST_Disjoint(geometry, geometry) returns boolean

function ST_Distance(geometry, geometry) returns double
function ST_Distance(sphericalgeography, sphericalgeography) returns double

function ST_EndPoint(geometry) returns geometry

function ST_Envelope(geometry) returns geometry

function ST_EnvelopeAsPts(geometry) returns array<geometry>

function ST_Equals(geometry, geometry) returns boolean

function ST_ExteriorRing(geometry) returns geometry

function ST_Geometries(geometry) returns array<geometry>

function ST_GeometryFromText(varchar) returns geometry

function ST_GeometryN(geometry, bigint) returns geometry

function ST_GeometryType(geometry) returns varchar

function ST_GeomFromBinary(varbinary) returns geometry

function ST_InteriorRingN(geometry, bigint) returns geometry

function ST_InteriorRings(geometry) returns array<geometry>

function ST_Intersection(geometry, geometry) returns geometry

function ST_Intersects(geometry, geometry) returns boolean

function ST_IsClosed(geometry) returns boolean

function ST_IsEmpty(geometry) returns boolean

function ST_IsRing(geometry) returns boolean

function ST_IsSimple(geometry) returns boolean

function ST_IsValid(geometry) returns boolean

function ST_Length(geometry) returns double
function ST_Length(sphericalgeography) returns double

function ST_LineFromText(varchar) returns geometry

function ST_LineString(array<geometry>) returns geometry

function ST_MultiPoint(array<geometry>) returns geometry

function ST_NumGeometries(geometry) returns bigint

function ST_NumInteriorRing(geometry) returns bigint

function ST_NumPoints(geometry) returns bigint

function ST_Overlaps(geometry, geometry) returns boolean

function ST_Point(double, double) returns geometry

function ST_PointN(geometry, bigint) returns geometry

function ST_Points(geometry) returns array<geometry>

function ST_Polygon(varchar) returns geometry

function ST_Relate(geometry, geometry, varchar) returns boolean

function ST_StartPoint(geometry) returns geometry

function ST_SymDifference(geometry, geometry) returns geometry

function ST_Touches(geometry, geometry) returns boolean

function ST_Union(geometry, geometry) returns geometry

function ST_Within(geometry, geometry) returns boolean

function ST_X(geometry) returns double

function ST_XMax(geometry) returns double

function ST_XMin(geometry) returns double

function ST_Y(geometry) returns double

function ST_YMax(geometry) returns double

function ST_YMin(geometry) returns double

function to_encoded_polyline(geometry) returns varchar

function to_geojson_geometry(sphericalgeography) returns varchar

function to_geometry(sphericalgeography) returns geometry

function to_spherical_geography(geometry) returns sphericalgeography