ext::postgisNew
This extension exposes the functionality of the PostGIS library. It is a vast library dedicated to handling geographic and various geometric data. The scope of the EdgeDB extension is to mainly adapt the types and functions used in this library with minimal changes.
As a rule, many of the functions in PostGIS library have a ST_`
prefix, however, we omitted it since in EdgeDB all these functions would already be in the ext::postgis
namespace and additional disambiguation is unnecessary.
Types
There are four basic scalar types introduced by this extension:
The type representing 2- or 3-dimensional spatial features.
By default most of the geometry
values are assumed to be representing planar geometry in a Cartesian coordinate system.
Every other ext::postgis
scalar type is castable into geometry
. Many of the PostGIS functions only accept geometry
as input.
The type representing spatial features with geodetic coordinate systems.
The PostGIS geography
data type provides native support for spatial features represented on "geographic" coordinates (sometimes called "geodetic" coordinates, or "lat/lon", or "lon/lat"). Geographic coordinates are spherical coordinates expressed in angular units (degrees).
Operators
There are many functions available for processing all this geometric and geographic data. Of note are the functions that represent operations affected by the indexes (pg::gist
, pg::brin
, and pg::spgist
). These functions all have a op_
prefix to help identify them.
This is exposing the ~
operator.
This is exposing the @
operator.
This is exposing the &&
operator.
Functions
The core functions can be roughly grouped into the following categories.
Geometry Constructors
ext::postgis::collect() (added in 6.0) |
This is exposing st_collect. |
ext::postgis::hexagon() (added in 6.0) |
This is exposing st_hexagon. |
ext::postgis::linefrommultipoint() (added in 6.0) |
This is exposing st_linefrommultipoint. |
ext::postgis::makeenvelope() (added in 6.0) |
This is exposing st_makeenvelope. |
ext::postgis::makeline() (added in 6.0) |
This is exposing st_makeline. |
ext::postgis::makepoint() (added in 6.0) |
This is exposing st_makepoint. |
ext::postgis::makepointm() (added in 6.0) |
This is exposing st_makepointm. |
ext::postgis::makepolygon() (added in 6.0) |
This is exposing st_makepolygon. |
ext::postgis::point() (added in 6.0) |
This is exposing st_point. |
ext::postgis::pointm() (added in 6.0) |
This is exposing st_pointm. |
ext::postgis::pointz() (added in 6.0) |
This is exposing st_pointz. |
ext::postgis::pointzm() (added in 6.0) |
This is exposing st_pointzm. |
ext::postgis::polygon() (added in 6.0) |
This is exposing st_polygon. |
ext::postgis::square() (added in 6.0) |
This is exposing st_square. |
ext::postgis::tileenvelope() (added in 6.0) |
This is exposing st_tileenvelope. |
Geometry Accessors
ext::postgis::boundary() (added in 6.0) |
This is exposing st_boundary. |
ext::postgis::boundingdiagonal() (added in 6.0) |
This is exposing st_boundingdiagonal. |
ext::postgis::coorddim() (added in 6.0) |
This is exposing st_coorddim. |
ext::postgis::dimension() (added in 6.0) |
This is exposing st_dimension. |
ext::postgis::endpoint() (added in 6.0) |
This is exposing st_endpoint. |
ext::postgis::envelope() (added in 6.0) |
This is exposing st_envelope. |
ext::postgis::exteriorring() (added in 6.0) |
This is exposing st_exteriorring. |
ext::postgis::geometryn() (added in 6.0) |
This is exposing st_geometryn. |
ext::postgis::geometrytype() (added in 6.0) |
This is exposing geometrytype. |
ext::postgis::hasarc() (added in 6.0) |
This is exposing st_hasarc. |
ext::postgis::interiorringn() (added in 6.0) |
This is exposing st_interiorringn. |
ext::postgis::isclosed() (added in 6.0) |
Tests if a geometry in 2D or 3D is closed. |
ext::postgis::iscollection() (added in 6.0) |
This is exposing st_iscollection. |
ext::postgis::isempty() (added in 6.0) |
This is exposing st_isempty. |
ext::postgis::ispolygonccw() (added in 6.0) |
Tests counter-clockwise poligonal orientation of a geometry. |
ext::postgis::ispolygoncw() (added in 6.0) |
Tests clockwise poligonal orientation of a geometry. |
ext::postgis::isring() (added in 6.0) |
This is exposing st_isring. |
ext::postgis::issimple() (added in 6.0) |
This is exposing st_issimple. |
ext::postgis::m() (added in 6.0) |
This is exposing st_m. |
ext::postgis::memsize() (added in 6.0) |
This is exposing st_memsize. |
ext::postgis::ndims() (added in 6.0) |
This is exposing st_ndims. |
ext::postgis::npoints() (added in 6.0) |
This is exposing st_npoints. |
ext::postgis::nrings() (added in 6.0) |
This is exposing st_nrings. |
ext::postgis::numgeometries() (added in 6.0) |
This is exposing st_numgeometries. |
ext::postgis::numinteriorring() (added in 6.0) |
This is exposing st_numinteriorring. |
ext::postgis::numinteriorrings() (added in 6.0) |
This is exposing st_numinteriorrings. |
ext::postgis::numpatches() (added in 6.0) |
Return the number of faces on a Polyhedral Surface. |
ext::postgis::numpoints() (added in 6.0) |
This is exposing st_numpoints. |
ext::postgis::patchn() (added in 6.0) |
This is exposing st_patchn. |
ext::postgis::pointn() (added in 6.0) |
Returns the Nth point in the first LineString in a geometry. |
ext::postgis::points() (added in 6.0) |
This is exposing st_points. |
ext::postgis::startpoint() (added in 6.0) |
This is exposing st_startpoint. |
ext::postgis::summary() (added in 6.0) |
This is exposing st_summary. |
ext::postgis::x() (added in 6.0) |
This is exposing st_x. |
ext::postgis::y() (added in 6.0) |
This is exposing st_y. |
ext::postgis::z() (added in 6.0) |
This is exposing st_z. |
ext::postgis::zmflag() (added in 6.0) |
This is exposing st_zmflag. |
Geometry Editors
ext::postgis::addpoint() (added in 6.0) |
This is exposing st_addpoint. |
ext::postgis::collectionextract() (added in 6.0) |
This is exposing st_collectionextract. |
ext::postgis::collectionhomogenize() (added in 6.0) |
This is exposing st_collectionhomogenize. |
ext::postgis::curvetoline() (added in 6.0) |
This is exposing st_curvetoline. |
ext::postgis::flipcoordinates() (added in 6.0) |
This is exposing st_flipcoordinates. |
ext::postgis::force2d() (added in 6.0) |
This is exposing st_force2d. |
ext::postgis::force3d() (added in 6.0) |
This is exposing st_force3d. |
ext::postgis::force3dm() (added in 6.0) |
This is exposing st_force3dm. |
ext::postgis::force3dz() (added in 6.0) |
This is exposing st_force3dz. |
ext::postgis::force4d() (added in 6.0) |
This is exposing st_force4d. |
ext::postgis::forcecollection() (added in 6.0) |
This is exposing st_forcecollection. |
ext::postgis::forcecurve() (added in 6.0) |
This is exposing st_forcecurve. |
ext::postgis::forcepolygonccw() (added in 6.0) |
This is exposing st_forcepolygonccw. |
ext::postgis::forcepolygoncw() (added in 6.0) |
This is exposing st_forcepolygoncw. |
ext::postgis::forcerhr() (added in 6.0) |
Forces the orientation of the vertices in a polygon to follow the RHR. |
ext::postgis::forcesfs() (added in 6.0) |
This is exposing st_forcesfs. |
ext::postgis::lineextend() (added in 6.0) |
This is exposing st_lineextend. |
ext::postgis::linetocurve() (added in 6.0) |
This is exposing st_linetocurve. |
ext::postgis::multi() (added in 6.0) |
This is exposing st_multi. |
ext::postgis::normalize() (added in 6.0) |
This is exposing st_normalize. |
ext::postgis::project() (added in 6.0) |
Returns a point projected from a start point by a distance and bearing. |
ext::postgis::quantizecoordinates() (added in 6.0) |
This is exposing st_quantizecoordinates. |
ext::postgis::removepoint() (added in 6.0) |
This is exposing st_removepoint. |
ext::postgis::removerepeatedpoints() (added in 6.0) |
This is exposing st_removerepeatedpoints. |
ext::postgis::reverse() (added in 6.0) |
This is exposing st_reverse. |
ext::postgis::scroll() (added in 6.0) |
This is exposing st_scroll. |
ext::postgis::segmentize() (added in 6.0) |
Makes a new geometry/geography with no segment longer than a given distance. |
ext::postgis::setpoint() (added in 6.0) |
This is exposing st_setpoint. |
ext::postgis::shiftlongitude() (added in 6.0) |
This is exposing st_shiftlongitude. |
ext::postgis::snap() (added in 6.0) |
This is exposing st_snap. |
ext::postgis::snaptogrid() (added in 6.0) |
This is exposing st_snaptogrid. |
ext::postgis::wrapx() (added in 6.0) |
This is exposing st_wrapx. |
Geometry Validation
ext::postgis::isvalid() (added in 6.0) |
This is exposing st_isvalid. |
ext::postgis::isvalidreason() (added in 6.0) |
This is exposing st_isvalidreason. |
ext::postgis::makevalid() (added in 6.0) |
This is exposing st_makevalid. |
Spatial Reference System Functions
ext::postgis::inversetransformpipeline() (added in 6.0) |
This is exposing st_inversetransformpipeline. |
ext::postgis::postgis_srs_codes() (added in 6.0) |
This is exposing postgis_srs_codes. |
ext::postgis::setsrid() (added in 6.0) |
This is exposing st_setsrid. |
ext::postgis::srid() (added in 6.0) |
This is exposing st_srid. |
ext::postgis::transform() (added in 6.0) |
Transforms a geometry to a different spatial reference system. |
ext::postgis::transformpipeline() (added in 6.0) |
This is exposing st_transformpipeline. |
Well-Known Text (WKT)
ext::postgis::asewkt() (added in 6.0) |
Returns a geometry in WKT format with SRID meta data. |
ext::postgis::astext() (added in 6.0) |
Returns a geometry/geography in WKT format without SRID metadata. |
ext::postgis::bdmpolyfromtext() (added in 6.0) |
This is exposing st_bdmpolyfromtext. |
ext::postgis::bdpolyfromtext() (added in 6.0) |
This is exposing st_bdpolyfromtext. |
ext::postgis::geogfromtext() (added in 6.0) |
Creates a geography value from WKT or EWTK. |
ext::postgis::geomcollfromtext() (added in 6.0) |
Makes a collection Geometry from collection WKT. |
ext::postgis::geomfromewkt() (added in 6.0) |
Creates a geometry value from EWKT representation. |
ext::postgis::geomfrommarc21() (added in 6.0) |
This is exposing st_geomfrommarc21. |
ext::postgis::geomfromtext() (added in 6.0) |
Creates a geometry value from WKT representation. |
ext::postgis::linefromtext() (added in 6.0) |
Creates a geometry from WKT LINESTRING. |
ext::postgis::mlinefromtext() (added in 6.0) |
This is exposing st_mlinefromtext. |
ext::postgis::mpointfromtext() (added in 6.0) |
Creates a geometry from WKT MULTIPOINT. |
ext::postgis::mpolyfromtext() (added in 6.0) |
Creates a geometry from WKT MULTIPOLYGON. |
ext::postgis::pointfromtext() (added in 6.0) |
Makes a POINT geometry from WKT. |
ext::postgis::polygonfromtext() (added in 6.0) |
Creates a geometry from WKT POLYGON. |
Well-Known Binary (WKB)
ext::postgis::asbinary() (added in 6.0) |
Returns a geometry/geography in WKB format without SRID meta data. |
ext::postgis::asewkb() (added in 6.0) |
Returns a geometry in EWKB format with SRID meta data. |
ext::postgis::ashexewkb() (added in 6.0) |
Returns a geometry in HEXEWKB format (as text). |
ext::postgis::geogfromwkb() (added in 6.0) |
Creates a geography value from WKB or EWKB. |
ext::postgis::geomfromewkb() (added in 6.0) |
Creates a geometry value from EWKB. |
ext::postgis::geomfromwkb() (added in 6.0) |
Creates a geometry value from WKB representation. |
ext::postgis::linefromwkb() (added in 6.0) |
This is exposing st_linefromwkb. |
ext::postgis::linestringfromwkb() (added in 6.0) |
This is exposing st_linestringfromwkb. |
ext::postgis::pointfromwkb() (added in 6.0) |
This is exposing st_pointfromwkb. |
Other Formats
ext::postgis::asencodedpolyline() (added in 6.0) |
This is exposing st_asencodedpolyline. |
ext::postgis::asgeojson() (added in 6.0) |
This is exposing st_asgeojson. |
ext::postgis::asgml() (added in 6.0) |
This is exposing st_asgml. |
ext::postgis::askml() (added in 6.0) |
This is exposing st_askml. |
ext::postgis::aslatlontext() (added in 6.0) |
This is exposing st_aslatlontext. |
ext::postgis::asmarc21() (added in 6.0) |
This is exposing st_asmarc21. |
ext::postgis::asmvtgeom() (added in 6.0) |
This is exposing st_asmvtgeom. |
ext::postgis::assvg() (added in 6.0) |
This is exposing st_assvg. |
ext::postgis::astwkb() (added in 6.0) |
This is exposing st_astwkb. |
ext::postgis::asx3d() (added in 6.0) |
Returns a geometry in X3D format. |
ext::postgis::box2dfromgeohash() (added in 6.0) |
This is exposing st_box2dfromgeohash. |
ext::postgis::geohash() (added in 6.0) |
This is exposing st_geohash. |
ext::postgis::geomfromgeohash() (added in 6.0) |
This is exposing st_geomfromgeohash. |
ext::postgis::geomfromgeojson() (added in 6.0) |
Creates a geometry value from a geojson representation of a geometry. |
ext::postgis::geomfromgml() (added in 6.0) |
Creates a geometry value from GML representation of a geometry. |
ext::postgis::geomfromkml() (added in 6.0) |
Creates a geometry value from KML representation of a geometry. |
ext::postgis::geomfromtwkb() (added in 6.0) |
This is exposing st_geomfromtwkb. |
ext::postgis::linefromencodedpolyline() (added in 6.0) |
This is exposing st_linefromencodedpolyline. |
ext::postgis::pointfromgeohash() (added in 6.0) |
This is exposing st_pointfromgeohash. |
Topological Relationships
ext::postgis::contains() (added in 6.0) |
This is exposing st_contains. |
ext::postgis::containsproperly() (added in 6.0) |
Tests if every point of geom2 lies in the interior of geom1. |
ext::postgis::coveredby() (added in 6.0) |
This is exposing st_coveredby. |
ext::postgis::covers() (added in 6.0) |
This is exposing st_covers. |
ext::postgis::crosses() (added in 6.0) |
This is exposing st_crosses. |
ext::postgis::disjoint() (added in 6.0) |
This is exposing st_disjoint. |
ext::postgis::equals() (added in 6.0) |
This is exposing st_equals. |
ext::postgis::intersects() (added in 6.0) |
This is exposing st_intersects. |
ext::postgis::intersects3d() (added in 6.0) |
Tests if two geometries spatially intersect in 3D. |
ext::postgis::linecrossingdirection() (added in 6.0) |
This is exposing st_linecrossingdirection. |
ext::postgis::orderingequals() (added in 6.0) |
Tests if two geometries are the same geometry including points order. |
ext::postgis::overlaps() (added in 6.0) |
Tests if two geometries overlap. |
ext::postgis::relate() (added in 6.0) |
Tests if two geometries have a topological relationship. |
ext::postgis::relatematch() (added in 6.0) |
This is exposing st_relatematch. |
ext::postgis::touches() (added in 6.0) |
Tests if two geometries touch without intersecting interiors. |
ext::postgis::within() (added in 6.0) |
This is exposing st_within. |
Distance Relationships
ext::postgis::dfullywithin() (added in 6.0) |
Tests if two geometries are entirely within a given distance. |
ext::postgis::dfullywithin3d() (added in 6.0) |
This is exposing st_3ddfullywithin. |
ext::postgis::dwithin() (added in 6.0) |
This is exposing st_dwithin. |
ext::postgis::dwithin3d() (added in 6.0) |
This is exposing st_3ddwithin. |
ext::postgis::pointinsidecircle() (added in 6.0) |
This is exposing st_pointinsidecircle. |
Measurement Functions
ext::postgis::angle() (added in 6.0) |
This is exposing st_angle. |
ext::postgis::area() (added in 6.0) |
This is exposing st_area. |
ext::postgis::azimuth() (added in 6.0) |
This is exposing st_azimuth. |
ext::postgis::closestpoint() (added in 6.0) |
Returns the 2D point of the first geometry closest to the second. |
ext::postgis::closestpoint3d() (added in 6.0) |
Returns the 3D point of the first geometry closest to the second. |
ext::postgis::distance() (added in 6.0) |
This is exposing st_distance. |
ext::postgis::distance3d() (added in 6.0) |
Returns the 3D cartesian minimum distance between two geometries. |
ext::postgis::distancesphere() (added in 6.0) |
This is exposing st_distancesphere. |
ext::postgis::distancespheroid() (added in 6.0) |
This is exposing st_distancespheroid. |
ext::postgis::frechetdistance() (added in 6.0) |
This is exposing st_frechetdistance. |
ext::postgis::hausdorffdistance() (added in 6.0) |
This is exposing st_hausdorffdistance. |
ext::postgis::length() (added in 6.0) |
This is exposing st_length. |
ext::postgis::length2d() (added in 6.0) |
This is exposing st_length2d. |
ext::postgis::length3d() (added in 6.0) |
This is exposing st_3dlength. |
ext::postgis::longestline() (added in 6.0) |
This is exposing st_longestline. |
ext::postgis::longestline3d() (added in 6.0) |
This is exposing st_3dlongestline. |
ext::postgis::maxdistance() (added in 6.0) |
This is exposing st_maxdistance. |
ext::postgis::maxdistance3d() (added in 6.0) |
Returns the 3D cartesian maximum distance between two geometries. |
ext::postgis::minimumclearance() (added in 6.0) |
This is exposing st_minimumclearance. |
ext::postgis::minimumclearanceline() (added in 6.0) |
This is exposing st_minimumclearanceline. |
ext::postgis::perimeter() (added in 6.0) |
This is exposing st_perimeter. |
ext::postgis::perimeter2d() (added in 6.0) |
This is exposing st_perimeter2d. |
ext::postgis::perimeter3d() (added in 6.0) |
This is exposing st_3dperimeter. |
ext::postgis::shortestline() (added in 6.0) |
This is exposing st_shortestline. |
ext::postgis::shortestline3d() (added in 6.0) |
This is exposing st_3dshortestline. |
Overlay Functions
ext::postgis::clipbybox2d() (added in 6.0) |
This is exposing st_clipbybox2d. |
ext::postgis::difference() (added in 6.0) |
Computes a geometry resulting from removing all points in geom2 from geom1. |
ext::postgis::intersection() (added in 6.0) |
This is exposing st_intersection. |
ext::postgis::node() (added in 6.0) |
This is exposing st_node. |
ext::postgis::split() (added in 6.0) |
This is exposing st_split. |
ext::postgis::subdivide() (added in 6.0) |
This is exposing st_subdivide. |
ext::postgis::symdifference() (added in 6.0) |
Merges two geometries excluding where they intersect. |
ext::postgis::unaryunion() (added in 6.0) |
This is exposing st_unaryunion. |
ext::postgis::union() (added in 6.0) |
This is exposing st_union. |
Geometry Processing
ext::postgis::buffer() (added in 6.0) |
Returns a geometry covering all points within a given distance from a geometry. |
ext::postgis::buildarea() (added in 6.0) |
This is exposing st_buildarea. |
ext::postgis::centroid() (added in 6.0) |
This is exposing st_centroid. |
ext::postgis::chaikinsmoothing() (added in 6.0) |
This is exposing st_chaikinsmoothing. |
ext::postgis::concavehull() (added in 6.0) |
This is exposing st_concavehull. |
ext::postgis::convexhull() (added in 6.0) |
This is exposing st_convexhull. |
ext::postgis::delaunaytriangles() (added in 6.0) |
This is exposing st_delaunaytriangles. |
ext::postgis::filterbym() (added in 6.0) |
This is exposing st_filterbym. |
ext::postgis::generatepoints() (added in 6.0) |
This is exposing st_generatepoints. |
ext::postgis::geometricmedian() (added in 6.0) |
This is exposing st_geometricmedian. |
ext::postgis::linemerge() (added in 6.0) |
This is exposing st_linemerge. |
ext::postgis::minimumboundingcircle() (added in 6.0) |
This is exposing st_minimumboundingcircle. |
ext::postgis::offsetcurve() (added in 6.0) |
This is exposing st_offsetcurve. |
ext::postgis::orientedenvelope() (added in 6.0) |
This is exposing st_orientedenvelope. |
ext::postgis::pointonsurface() (added in 6.0) |
This is exposing st_pointonsurface. |
ext::postgis::polygonize() (added in 6.0) |
Computes a collection of polygons formed from a set of linework. |
ext::postgis::reduceprecision() (added in 6.0) |
This is exposing st_reduceprecision. |
ext::postgis::seteffectivearea() (added in 6.0) |
This is exposing st_seteffectivearea. |
ext::postgis::sharedpaths() (added in 6.0) |
This is exposing st_sharedpaths. |
ext::postgis::simplify() (added in 6.0) |
This is exposing st_simplify. |
ext::postgis::simplifypolygonhull() (added in 6.0) |
This is exposing st_simplifypolygonhull. |
ext::postgis::simplifypreservetopology() (added in 6.0) |
This is exposing st_simplifypreservetopology. |
ext::postgis::simplifyvw() (added in 6.0) |
This is exposing st_simplifyvw. |
ext::postgis::triangulatepolygon() (added in 6.0) |
This is exposing st_triangulatepolygon. |
ext::postgis::voronoilines() (added in 6.0) |
This is exposing st_voronoilines. |
ext::postgis::voronoipolygons() (added in 6.0) |
This is exposing st_voronoipolygons. |
Coverages
ext::postgis::coverageunion() (added in 6.0) |
Computes polygonal coverage from a set of polygons. |
Affine Transformations
ext::postgis::affine() (added in 6.0) |
This is exposing st_affine. |
ext::postgis::rotate() (added in 6.0) |
This is exposing st_rotate. |
ext::postgis::rotatex() (added in 6.0) |
This is exposing st_rotatex. |
ext::postgis::rotatey() (added in 6.0) |
This is exposing st_rotatey. |
ext::postgis::rotatez() (added in 6.0) |
This is exposing st_rotatez. |
ext::postgis::scale() (added in 6.0) |
This is exposing st_scale. |
ext::postgis::translate() (added in 6.0) |
This is exposing st_translate. |
ext::postgis::transscale() (added in 6.0) |
This is exposing st_transscale. |
Clustering Functions
ext::postgis::clusterintersecting() (added in 6.0) |
This is exposing st_clusterintersecting. |
ext::postgis::clusterwithin() (added in 6.0) |
This is exposing st_clusterwithin. |
Bounding Box Functions
ext::postgis::expand() (added in 6.0) |
This is exposing st_expand. |
ext::postgis::makebox2d() (added in 6.0) |
This is exposing st_makebox2d. |
ext::postgis::makebox3d() (added in 6.0) |
This is exposing st_3dmakebox. |
ext::postgis::to_box2d() (added in 6.0) |
This is exposing box2d. |
ext::postgis::to_box3d() (added in 6.0) |
This is exposing box3d. |
ext::postgis::xmax() (added in 6.0) |
This is exposing st_xmax. |
ext::postgis::xmin() (added in 6.0) |
This is exposing st_xmin. |
ext::postgis::ymax() (added in 6.0) |
This is exposing st_ymax. |
ext::postgis::ymin() (added in 6.0) |
This is exposing st_ymin. |
ext::postgis::zmax() (added in 6.0) |
This is exposing st_zmax. |
ext::postgis::zmin() (added in 6.0) |
This is exposing st_zmin. |
Linear Referencing
ext::postgis::addmeasure() (added in 6.0) |
This is exposing st_addmeasure. |
ext::postgis::interpolatepoint() (added in 6.0) |
This is exposing st_interpolatepoint. |
ext::postgis::lineinterpolatepoint() (added in 6.0) |
This is exposing st_lineinterpolatepoint. |
ext::postgis::lineinterpolatepoint3d() (added in 6.0) |
This is exposing st_3dlineinterpolatepoint. |
ext::postgis::lineinterpolatepoints() (added in 6.0) |
This is exposing st_lineinterpolatepoints. |
ext::postgis::linelocatepoint() (added in 6.0) |
This is exposing st_linelocatepoint. |
ext::postgis::linesubstring() (added in 6.0) |
This is exposing st_linesubstring. |
ext::postgis::locatealong() (added in 6.0) |
This is exposing st_locatealong. |
ext::postgis::locatebetween() (added in 6.0) |
This is exposing st_locatebetween. |
ext::postgis::locatebetweenelevations() (added in 6.0) |
This is exposing st_locatebetweenelevations. |
Trajectory Functions
ext::postgis::closestpointofapproach() (added in 6.0) |
This is exposing st_closestpointofapproach. |
ext::postgis::cpawithin() (added in 6.0) |
Tests if two trajectoriesis approach within the specified distance. |
ext::postgis::distancecpa() (added in 6.0) |
This is exposing st_distancecpa. |
ext::postgis::isvalidtrajectory() (added in 6.0) |
This is exposing st_isvalidtrajectory. |
Other
ext::postgis::area2d() (added in 6.0) |
This is exposing st_area2d. |
ext::postgis::cleangeometry() (added in 6.0) |
This is exposing st_cleangeometry. |
ext::postgis::combinebbox() (added in 6.0) |
This is exposing st_combinebbox. |
ext::postgis::curven() (added in 6.0) |
This is exposing st_curven. |
ext::postgis::geography_cmp() (added in 6.0) |
This is exposing geography_cmp. |
ext::postgis::geomcollfromwkb() (added in 6.0) |
This is exposing st_geomcollfromwkb. |
ext::postgis::geometry_cmp() (added in 6.0) |
This is exposing geometry_cmp. |
ext::postgis::geometry_hash() (added in 6.0) |
This is exposing geometry_hash. |
ext::postgis::get_proj4_from_srid() (added in 6.0) |
This is exposing get_proj4_from_srid. |
ext::postgis::hasm() (added in 6.0) |
This is exposing st_hasm. |
ext::postgis::hasz() (added in 6.0) |
This is exposing st_hasz. |
ext::postgis::mlinefromwkb() (added in 6.0) |
This is exposing st_mlinefromwkb. |
ext::postgis::mpointfromwkb() (added in 6.0) |
This is exposing st_mpointfromwkb. |
ext::postgis::mpolyfromwkb() (added in 6.0) |
This is exposing st_mpolyfromwkb. |
ext::postgis::multilinefromwkb() (added in 6.0) |
This is exposing st_multilinefromwkb. |
ext::postgis::multilinestringfromtext() (added in 6.0) |
This is exposing st_multilinestringfromtext. |
ext::postgis::multipointfromtext() (added in 6.0) |
This is exposing st_multipointfromtext. |
ext::postgis::multipointfromwkb() (added in 6.0) |
This is exposing st_multipointfromwkb. |
ext::postgis::multipolyfromwkb() (added in 6.0) |
This is exposing st_multipolyfromwkb. |
ext::postgis::multipolygonfromtext() (added in 6.0) |
This is exposing st_multipolygonfromtext. |
ext::postgis::numcurves() (added in 6.0) |
This is exposing st_numcurves. |
ext::postgis::polyfromtext() (added in 6.0) |
This is exposing st_polyfromtext. |
ext::postgis::polyfromwkb() (added in 6.0) |
This is exposing st_polyfromwkb. |
ext::postgis::polygonfromwkb() (added in 6.0) |
This is exposing st_polygonfromwkb. |
ext::postgis::postgis_addbbox() (added in 6.0) |
This is exposing postgis_addbbox. |
ext::postgis::postgis_constraint_dims() (added in 6.0) |
This is exposing postgis_constraint_dims. |
ext::postgis::postgis_constraint_srid() (added in 6.0) |
This is exposing postgis_constraint_srid. |
ext::postgis::postgis_dropbbox() (added in 6.0) |
This is exposing postgis_dropbbox. |
ext::postgis::postgis_full_version() (added in 6.0) |
This is exposing postgis_full_version. |
ext::postgis::postgis_geos_compiled_version() (added in 6.0) |
This is exposing postgis_geos_compiled_version. |
ext::postgis::postgis_geos_noop() (added in 6.0) |
This is exposing postgis_geos_noop. |
ext::postgis::postgis_geos_version() (added in 6.0) |
This is exposing postgis_geos_version. |
ext::postgis::postgis_getbbox() (added in 6.0) |
This is exposing postgis_getbbox. |
ext::postgis::postgis_hasbbox() (added in 6.0) |
This is exposing postgis_hasbbox. |
ext::postgis::postgis_lib_build_date() (added in 6.0) |
This is exposing postgis_lib_build_date. |
ext::postgis::postgis_lib_revision() (added in 6.0) |
This is exposing postgis_lib_revision. |
ext::postgis::postgis_lib_version() (added in 6.0) |
This is exposing postgis_lib_version. |
ext::postgis::postgis_libjson_version() (added in 6.0) |
This is exposing postgis_libjson_version. |
ext::postgis::postgis_liblwgeom_version() (added in 6.0) |
This is exposing postgis_liblwgeom_version. |
ext::postgis::postgis_libprotobuf_version() (added in 6.0) |
This is exposing postgis_libprotobuf_version. |
ext::postgis::postgis_libxml_version() (added in 6.0) |
This is exposing postgis_libxml_version. |
ext::postgis::postgis_noop() (added in 6.0) |
This is exposing postgis_noop. |
ext::postgis::postgis_proj_compiled_version() (added in 6.0) |
This is exposing postgis_proj_compiled_version. |
ext::postgis::postgis_proj_version() (added in 6.0) |
This is exposing postgis_proj_version. |
ext::postgis::postgis_scripts_build_date() (added in 6.0) |
This is exposing postgis_scripts_build_date. |
ext::postgis::postgis_scripts_installed() (added in 6.0) |
This is exposing postgis_scripts_installed. |
ext::postgis::postgis_scripts_released() (added in 6.0) |
This is exposing postgis_scripts_released. |
ext::postgis::postgis_svn_version() (added in 6.0) |
This is exposing postgis_svn_version. |
ext::postgis::postgis_transform_geometry() (added in 6.0) |
This is exposing postgis_transform_geometry. |
ext::postgis::postgis_transform_pipeline_geometry() (added in 6.0) |
This is exposing postgis_transform_pipeline_geometry. |
ext::postgis::postgis_typmod_dims() (added in 6.0) |
This is exposing postgis_typmod_dims. |
ext::postgis::postgis_typmod_srid() (added in 6.0) |
This is exposing postgis_typmod_srid. |
ext::postgis::postgis_typmod_type() (added in 6.0) |
This is exposing postgis_typmod_type. |
ext::postgis::postgis_version() (added in 6.0) |
This is exposing postgis_version. |
ext::postgis::postgis_wagyu_version() (added in 6.0) |
This is exposing postgis_wagyu_version. |
ext::postgis::removeirrelevantpointsforview() (added in 6.0) |
This is exposing st_removeirrelevantpointsforview. |
ext::postgis::removesmallparts() (added in 6.0) |
This is exposing st_removesmallparts. |
ext::postgis::symmetricdifference() (added in 6.0) |
This is exposing st_symmetricdifference. |
ext::postgis::to_geography() (added in 6.0) |
This is exposing geography. |
ext::postgis::to_geometry() (added in 6.0) |
This is exposing geometry. |
This is exposing st_addpoint
.
This is exposing st_affine
.
This is exposing st_angle
.
Returns a geometry/geography in WKB format without SRID meta data.
Returns the OGC/ISO Well-Known Binary (WKB) representation of the geometry/geography without SRID meta data.
This is exposing st_asbinary
.
Returns a geometry in EWKB format with SRID meta data.
Returns the Extended Well-Known Binary (EWKB) representation of the geometry with SRID meta data.
This is exposing st_asewkb
.
Returns a geometry in WKT format with SRID meta data.
Returns the Well-Known Text (WKT) representation of the geometry with SRID meta data.
This is exposing st_asewkt
.
This is exposing st_asgeojson
.
This is exposing st_asgml
.
Returns a geometry in HEXEWKB format (as text).
Returnss a geometry in HEXEWKB format (as text) using either little-endian (NDR) or big-endian (XDR) encoding.
This is exposing st_ashexewkb
.
This is exposing st_askml
.
This is exposing st_asmvtgeom
.
This is exposing st_assvg
.
Returns a geometry/geography in WKT format without SRID metadata.
Returns the Well-Known Text (WKT) representation of the geometry/geography without SRID metadata.
This is exposing st_astext
.
This is exposing st_astwkb
.
Returns a geometry in X3D format.
Returns a geometry in X3D xml node element format: ISO-IEC-19776-1.2-X3DEncodings-XML.
This is exposing st_asx3d
.
Returns a geometry covering all points within a given distance from a geometry.
This is exposing st_buffer
.
This is exposing st_centroid
.
Returns the 2D point of the first geometry closest to the second.
Returns the 2D point of the first geometry/geography that is closest to the second geometry/geography. This is the first point of the shortest line from one geometry to the other.
This is exposing st_closestpoint
.
Returns the 3D point of the first geometry closest to the second.
Returns the 3D point of the first geometry/geography that is closest to the second geometry/geography. This is the first point of the 3D shortest line.
This is exposing st_3dclosestpoint
.
This is exposing st_combinebbox
.
This is exposing st_coveredby
.
This is exposing st_covers
.
Tests if two trajectoriesis approach within the specified distance.
Tests if the closest point of approach of two trajectoriesis within the specified distance.
This is exposing st_cpawithin
.
Computes a geometry resulting from removing all points in geom2 from geom1.
Computes a geometry representing the part of geometry geom1 that does not intersect geometry geom2.
This is exposing st_difference
.
This is exposing st_distance
.
Returns the 3D cartesian minimum distance between two geometries.
Returns the 3D cartesian minimum distance (based on spatial ref) between two geometries in projected units.
This is exposing st_3ddistance
.
This is exposing st_distancesphere
.
This is exposing st_dwithin
.
This is exposing st_expand
.
Forces the orientation of the vertices in a polygon to follow the RHR.
Forces the orientation of the vertices in a polygon to follow a Right-Hand-Rule, in which the area that is bounded by the polygon is to the right of the boundary. In particular, the exterior ring is orientated in a clockwise direction and the interior rings in a counter-clockwise direction.
This is exposing st_forcerhr
.
This is exposing st_generatepoints
.
Creates a geography value from WKB or EWKB.
Creates a geography value from a Well-Known Binary geometry representation (WKB) or extended Well Known Binary (EWKB).
This is exposing st_geogfromwkb
.
Makes a collection Geometry from collection WKT.
Makes a collection Geometry from collection WKT with the given SRID. If SRID is not given, it defaults to 0.
This is exposing st_geomcollfromtext
.
This is exposing st_geometricmedian
.
Creates a geometry value from a geojson representation of a geometry.
Takes as input a geojson representation of a geometry and outputs a
geometry
value.
This is exposing st_geomfromgeojson
.
Creates a geometry value from GML representation of a geometry.
Takes as input GML representation of geometry and outputs a geometry
value.
This is exposing st_geomfromgml
.
Creates a geometry value from WKT representation.
Creates a geometry value from Well-Known Text representation (WKT).
This is exposing st_geomfromtext
.
Creates a geometry value from WKB representation.
Creates a geometry value from a Well-Known Binary geometry representation (WKB) and optional SRID.
This is exposing st_geomfromwkb
.
This is exposing st_hausdorffdistance
.
This is exposing st_intersection
.
This is exposing st_intersects
.
Tests if two geometries spatially intersect in 3D.
Tests if two geometries spatially intersect in 3D - only for points, linestrings, polygons, polyhedral surface (area).
This is exposing st_3dintersects
.
Tests counter-clockwise poligonal orientation of a geometry.
Tests if Polygons have exterior rings oriented counter-clockwise and interior rings oriented clockwise.
This is exposing st_ispolygonccw
.
Creates a geometry from WKT LINESTRING.
Makes a Geometry from WKT representation with the given SRID. If SRID is not given, it defaults to 0.
This is exposing st_linefromtext
.
This is exposing st_lineinterpolatepoint
.
This is exposing st_lineinterpolatepoints
.
This is exposing st_linelocatepoint
.
This is exposing st_linesubstring
.
This is exposing st_makepoint
.
Returns the 3D cartesian maximum distance between two geometries.
Returns the 3D cartesian maximum distance (based on spatial ref) between two geometries in projected units.
This is exposing st_3dmaxdistance
.
Creates a geometry from WKT MULTIPOINT.
Makes a Geometry from WKT with the given SRID. If SRID is not given, it defaults to 0.
This is exposing st_mpointfromtext
.
Creates a geometry from WKT MULTIPOLYGON.
Makes a MultiPolygon Geometry from WKT with the given SRID. If SRID is not given, it defaults to 0.
This is exposing st_mpolyfromtext
.
Tests if two geometries are the same geometry including points order.
Tests if two geometries represent the same geometry and have points in the same directional order.
This is exposing st_orderingequals
.
Tests if two geometries overlap.
Tests if two geometries have the same dimension and intersect, but each has at least one point not in the other.
This is exposing st_overlaps
.
Makes a POINT geometry from WKT.
Makes a POINT geometry from WKT with the given SRID. If SRID is not given, it defaults to unknown.
This is exposing st_pointfromtext
.
Creates a geometry from WKT POLYGON.
Makes a Geometry from WKT with the given SRID. If SRID is not given, it defaults to 0.
This is exposing st_polygonfromtext
.
Computes a collection of polygons formed from a set of linework.
Computes a collection of polygons formed from the linework of a set of geometries.
This is exposing st_polygonize
.
Returns a point projected from a start point by a distance and bearing.
This is exposing st_project
.
This is exposing st_quantizecoordinates
.
Tests if two geometries have a topological relationship.
Tests if two geometries have a topological relationship matching an Intersection Matrix pattern, or computes their Intersection Matrix.
This is exposing st_relate
.
This is exposing st_rotate
.
This is exposing st_scale
.
Makes a new geometry/geography with no segment longer than a given distance.
This is exposing st_segmentize
.
This is exposing st_shortestline
.
This is exposing st_snaptogrid
.
This is exposing st_tileenvelope
.
This is exposing geometry
.
Tests if two geometries touch without intersecting interiors.
Tests if two geometries have at least one point in common, but their interiors do not intersect.
This is exposing st_touches
.
Transforms a geometry to a different spatial reference system.
Returns a new geometry with coordinates transformed to a different spatial reference system.
This is exposing st_transform
.
This is exposing st_translate
.
This is exposing st_union
.
Aggregates
These functions operate of sets of geometric data.
Computes polygonal coverage from a set of polygons.
Computes the union of a set of polygons forming a coverage by removing shared edges.
This is exposing st_coverageunion
.
Computes a collection of polygons formed from a set of linework.
Computes a collection of polygons formed from the linework of a set of geometries.
This is exposing st_polygonize
.