Celebrate this Post GIS day with these versatile Post GIS day commemorative playing cards. The number of games and fun-filled hours you
can have with these cards is priceless. Here is a small listing of the infinite number of games you can play with Post GIS cards:
POSTGIS
POSTGIS
A box composed of x min, ymin, xmax, ymax. Often used to return the 2d enclosing box of a geometry.
A box composed of x min, ymin, zmin, xmax, ymax, zmax. Often used to return the 3d extent of a geometry or collection of geometries.
Planar spatial data type.
A spatial datatype with two fields - geom (holding a geometry object)
and path[] (a 1-d array holding the position of the geometry within the dumped object.)
Ellipsoidal spatial data type.
Adds a geometry column to an existing table of
attributes. By default uses type modifier to define rather than constraints.
Pass in false for use_typmod to get old check contraint based behavior
Removes a geometry column from a spatial
table.
Drops a table and all its references in
geometry_columns.
Reports full postgis version and build configuration
infos.
Returns the version number of the GEOS
library.
Returns the version number of the libxml2
library.
Returns build date of the PostGIS library.
Returns the version number of the PostGIS
library.
Returns the version number of the PROJ4
library.
PostGIS_Scripts_Build_Date
Returns build date of the PostGIS scripts.
PostGIS_Scripts_Installed
Returns version of the postgis scripts installed in this
database.
Returns the version number of the postgis.sql script
released with the installed postgis lib.
Returns TRUE if STATS usage has been
enabled.
Returns PostGIS version number and compile-time
options.
Populate_Geometry_Columns2
Ensures geometry columns are defined with type modifiers or have appropriate spatial constraints
This ensures they will be registered correctly in geometry_columns view. By default will convert all geometry
columns with no type modifier to ones with type modifiers. To get old behavior set use_typmod=false
Updates the SRID of all features in a geometry
column, geometry_columns metadata and srid table constraint
Construct a Polygon given an arbitrary collection of closed
linestrings as a MultiLineString Well-Known text representation.
Construct a MultiPolygon given an arbitrary collection of
closed linestrings as a MultiLineString text
representation Well-Known text representation.
Return a specified geography value from Well-Known Text representation or extended (WKT).
Return a specified geography value from Well-Known Text representation or extended (WKT).
Creates a geography instance from a Well-Known Binary geometry
representation (WKB) or extended Well Known Binary (EWKB).
Makes a collection Geometry from collection WKT with the given SRID. If SRID is
not give, it defaults to -1.
Return a specified ST_Geometry value from Extended Well-Known Binary representation (EWKB).
Return a specified ST_Geometry value from Extended Well-Known Text representation (EWKT).
Return a specified ST_Geometry value from Well-Known Text representation (WKT). This is an alias name for ST_GeomFromText
Takes as input GML representation of geometry and outputs a PostGIS geometry object
Takes as input a geojson representation of a geometry and outputs a PostGIS geometry object
Takes as input KML representation of geometry and outputs a PostGIS geometry object
Return a specified ST_Geometry value from GML representation. This is an alias name for ST_GeomFromGML
Return a specified ST_Geometry value from Well-Known Text representation (WKT).
Creates a geometry instance from a Well-Known Binary geometry
representation (WKB) and optional SRID.
Creates a LineString from a MultiPoint geometry.
Makes a Geometry from WKT representation with the given SRID. If SRID is
not given, it defaults to -1.
Makes a LINESTRING from WKB with the given SRID
Makes a geometry from WKB with the given SRID.
Creates a BOX2D defined by the given point
geometries.
Creates a BOX3D defined by the given 3d point
geometries.
Creates a Linestring from point geometries.
Creates a rectangular Polygon formed from the given minimums and maximums. Input
values must be in SRS specified by the SRID.
Creates a Polygon formed by the given shell. Input
geometries must be closed LINESTRINGS.
Creates a 2D,3DZ or 4D point geometry.
Creates a point geometry with an x y and m coordinate.
Return a specified ST_MultiLineString value from WKT representation.
Makes a Geometry from WKT with the given SRID. If SRID is
not give, it defaults to -1.
Makes a MultiPolygon Geometry from WKT with the given SRID. If SRID is
not give, it defaults to -1.
Returns an ST_Point with the given coordinate values. OGC alias for ST_MakePoint.
Makes a point Geometry from WKT with the given SRID. If SRID is
not given, it defaults to unknown.
Makes a geometry from WKB with the given SRID
Returns a polygon built from the specified linestring and SRID.
Makes a Geometry from WKT with the given SRID. If SRID is
not give, it defaults to -1.
Return a specified ST_Geometry value from Well-Known Binary representation (WKB). This is an alias name for ST_GeomFromWKB that takes no srid
Return a specified ST_Geometry value from Well-Known Text representation (WKT). This is an alias name for ST_GeomFromText
Returns the type of the geometry as a string. Eg:
'LINESTRING', 'POLYGON', 'MULTIPOINT', etc.
Returns the closure of the combinatorial boundary of this
Geometry.
Return the coordinate dimension of the ST_Geometry value.
The inherent dimension of this Geometry object, which must
be less than or equal to the coordinate dimension.
Returns the last point of a LINESTRING
geometry as a POINT.
Returns a geometry representing the double precision (float8) bounding box of the
supplied geometry.
Returns a line string representing the exterior ring of the POLYGON geometry. Return
NULL if the geometry is not a polygon. Will not work with MULTIPOLYGON
Return the 1-based Nth geometry if the geometry is a
GEOMETRYCOLLECTION, (MULTI)POINT, (MULTI)LINESTRING, MULTICURVE or (MULTI)POLYGON, POLYHEDRALSURFACE
Otherwise, return NULL.
Return the geometry type of the ST_Geometry value.
Return the Nth interior linestring ring of the polygon geometry.
Return NULL if the geometry is not a polygon or the given N is out
of range.
Returns TRUE if the
LINESTRING's start and end points are coincident. For Polyhedral surface is closed (volumetric).
Returns TRUE if the argument is a
collection (MULTI*, GEOMETRYCOLLECTION, ...)
Returns true if this Geometry is an empty geometrycollection, polygon, point etc.
Returns TRUE if this
LINESTRING is both closed and simple.
Returns (TRUE) if this Geometry has no anomalous geometric
points, such as self intersection or self tangency.
Returns true if the
ST_Geometry is well formed.
Returns text stating if a geometry is valid or not and if not valid, a reason why.
Returns a valid_detail (valid,reason,location) row stating if a geometry is valid or not and if not valid, a reason why and a location where.
Return the M coordinate of the point, or NULL if not
available. Input must be a point.
Returns coordinate dimension of the geometry as a small int.
Values are: 2,3 or 4.
Return the number of points (vertexes) in a geometry.
If the geometry is a polygon or multi-polygon returns the number of rings.
If geometry is a GEOMETRYCOLLECTION (or MULTI*) return the
number of geometries, for single geometries will return 1, otherwise return NULL.
Return the number of interior rings of the first polygon in
the geometry. This will work with both POLYGON and MULTIPOLYGON types but only looks at the first polygon.
Return NULL if there is no polygon in the
geometry.
Return the number of interior rings of the first polygon in
the geometry. Synonym to ST_NumInteriorRings.
Return the number of faces on a Polyhedral Surface. Will return null for non-polyhedral geometries.
Return the number of points in an ST_LineString or
ST_CircularString value.
Return the 1-based Nth geometry (face) if the geometry is a
POLYHEDRALSURFACE, POLYHEDRALSURFACEM.
Otherwise, return NULL.
Return the Nth point in the first linestring or circular linestring in the
geometry. Return NULL if there is no linestring in the
geometry.
Returns the spatial reference identifier for the ST_Geometry as defined in spatial_ref_sys table.
Returns the first point of a LINESTRING
geometry as a POINT.
Returns a text summary of the contents of the
ST_Geometry.
Return the X coordinate of the point, or NULL if not
available. Input must be a point.
Returns X maxima of a bounding box 2d or 3d or a geometry.
Returns X minima of a bounding box 2d or 3d or a geometry.
Return the Y coordinate of the point, or NULL if not
available. Input must be a point.
Returns Y maxima of a bounding box 2d or 3d or a geometry.
Returns Y minima of a bounding box 2d or 3d or a geometry.
Return the Z coordinate of the point, or NULL if not
available. Input must be a point.
Returns Z minima of a bounding box 2d or 3d or a geometry.
Returns ZM (dimension semantic) flag of the geometries as a
small int. Values are: 0=2d, 1=3dm, 2=3dz, 3=4d.
Returns Z minima of a bounding box 2d or 3d or a geometry.
Adds a point to a LineString before point position
(0-based index).
Applies a 3d affine transformation to the geometry to do things like translate, rotate, scale in one step.
Forces the geometries into a "2-dimensional mode" so that
all output representations will only have the X and Y coordinates.
Forces the geometries into XYZ mode. This is an alias for ST_Force_3DZ.
Forces the geometries into XYZ mode. This is a synonym for ST_Force_3D.
Forces the geometries into XYM mode.
Forces the geometries into XYZM mode.
Converts the geometry into a GEOMETRYCOLLECTION.
Forces the orientation of the vertices in a polygon to follow the
Right-Hand-Rule.
Returns a (set of) LineString(s) formed by sewing together
a MULTILINESTRING.
Given a GEOMETRYCOLLECTION, returns a MULTI* geometry consisting only of the specified type. Sub-geometries that are not
the specified type are ignored. If there are no sub-geometries of the right type, an EMPTY collection will be returned. Only
points, lines and polygons are supported. Type numbers are 1 == POINT, 2 == LINESTRING, 3 == POLYGON.
Returns the geometry as a MULTI* geometry. If the geometry
is already a MULTI*, it is returned unchanged.
Removes point from a linestring. Offset is 0-based.
Returns the geometry with vertex order reversed.
This is a synonym for ST_RotateZ
Rotate a geometry rotRadians about the X axis.
Rotate a geometry rotRadians about the Y axis.
Rotate a geometry rotRadians about the Z axis.
Scales the geometry to a new size by multiplying the
ordinates with the parameters. Ie: ST_Scale(geom, Xfactor, Yfactor,
Zfactor).
Return a modified geometry having no segment longer than the
given distance. Distance computation is performed in 2d
only.
Replace point N of linestring with given point. Index is
0-based.
Sets the SRID on a geometry to a particular integer
value.
Snap all points of the input geometry to a regular grid.
Snap segments and vertices of input geometry
to vertices of a reference geometry.
Returns a new geometry with its coordinates transformed to
the SRID referenced by the integer parameter.
Translates the geometry to a new location using the numeric
parameters as offsets. Ie: ST_Translate(geom, X, Y) or ST_Translate(geom, X, Y,Z).
Translates the geometry using the deltaX and deltaY args,
then scales it using the XFactor, YFactor args, working in 2D only.
Return the Well-Known Binary (WKB) representation of the geometry/geography without SRID meta data.
Return the Well-Known Binary (WKB) representation of the geometry with SRID meta data.
Return the Well-Known Text (WKT) representation of the geometry with SRID meta data.
Return the geometry as a GeoJSON element.
Return the geometry as a GML version 2 or 3 element.
Returns a Geometry in HEXEWKB format (as text) using either
little-endian (NDR) or big-endian (XDR) encoding.
Return the geometry as a KML element. Several variants. Default version=2, default precision=15
Returns a Geometry in SVG path data given a geometry or geography object.
Returns a Geometry in X3D xml node element format: ISO-IEC-19776-1.2-X3DEncodings-XML
Return a GeoHash representation (geohash.org) of the geometry.
Return the Well-Known Text (WKT) representation of the geometry/geography without SRID metadata.
Return the Degrees, Minutes, Seconds representation of the given point.
Returns TRUE if A's 2D bounding box intersects B's 2D bounding box.
Returns TRUE if A's 3D bounding box intersects B's 3D bounding box.
Returns TRUE if A's bounding box overlaps or is to the left of B's.
Returns TRUE if A's bounding box overlaps or is below B's.
Returns TRUE if A' bounding box overlaps or is to the right of B's.
Returns TRUE if A's bounding box is strictly to the left of B's.
Returns TRUE if A's bounding box is strictly below B's.
Returns TRUE if A's bounding box is the same as B's. Uses double precision bounding box.
Returns TRUE if A's bounding box is strictly to the right of B's.
Returns TRUE if A's bounding box is contained by B's.
Returns TRUE if A's bounding box overlaps or is above B's.
Returns TRUE if A's bounding box is strictly above B's.
Returns TRUE if A's bounding box contains B's.
Returns TRUE if A's bounding box is the same as B's.
Returns the distance between two points. For point / point checks it uses floating point accuracy (as opposed to the double precision accuracy of the underlying point geometry). For other geometry types
the distance between the floating point bounding box centroids is returned. Useful for doing distance ordering and nearest neighbor limits
using KNN gist functionality.
Returns the distance between bounding box of 2 geometries. For point / point checks it's almost the same as distance (though may be different since the bounding box is at floating point accuracy and geometries are double precision). Useful for doing distance ordering and nearest neighbor limits
using KNN gist functionality.
Returns the 3-dimensional point on g1 that is closest to g2. This is the first point of
the 3D shortest line.
For geometry type Returns the 3-dimensional cartesian minimum distance (based on spatial ref) between two geometries in
projected units.
For 3d (z) geometry type Returns true if two geometries 3d distance is within number of units.
Returns true if all of the 3D geometries are within the specified
distance of one another.
Returns TRUE if the Geometries "spatially
intersect" in 3d - only for points and linestrings
Returns the 3-dimensional longest line between two geometries
For geometry type Returns the 3-dimensional cartesian maximum distance (based on spatial ref) between two geometries in
projected units.
Returns the 3-dimensional shortest line between two geometries
Returns the area of the surface if it is a polygon or
multi-polygon. For "geometry" type area is in SRID units. For "geography" area is in square meters.
Returns the angle in radians from the horizontal of the vector defined by pointA and pointB. Angle is computed clockwise from down-to-up: on the clock: 12=0; 3=PI/2; 6=PI; 9=3PI/4.
Returns the geometric center of a geometry.
Returns the 2-dimensional point on g1 that is closest to g2. This is the first point of
the shortest line.
Returns true if and only if no points of B lie in the exterior of A, and at least one point of the interior of B lies in the interior of A.
Returns true if B intersects the interior of A but not the boundary (or exterior). A does not contain properly itself, but does contain itself.
Returns 1 (TRUE) if no point in Geometry B is outside
Geometry A
Returns 1 (TRUE) if no point in Geometry/Geography A is outside
Geometry/Geography B
Returns TRUE if the supplied geometries have some, but not all,
interior points in common.
Given 2 linestrings, returns a number between -3 and 3 denoting what kind of crossing behavior. 0 is no crossing.
Returns TRUE if the Geometries do not "spatially
intersect" - if they do not share any space together.
For geometry type Returns the 2-dimensional cartesian minimum distance (based on spatial ref) between two geometries in
projected units. For geography type defaults to return spheroidal minimum distance between two geographies in meters.
Returns the Hausdorff distance between two geometries. Basically a measure of how similar or dissimilar 2 geometries are. Units are in the units of the spatial
reference system of the geometries.
Returns the 2-dimensional largest distance between two geometries in
projected units.
Returns minimum distance in meters between two lon/lat
geometries. Uses a spherical earth and radius of 6370986 meters.
Faster than ST_Distance_Spheroid , but less
accurate. PostGIS versions prior to 1.5 only implemented for points.
Returns the minimum distance between two lon/lat geometries given a
particular spheroid.
PostGIS versions prior to 1.5 only support points.
Returns true if all of the geometries are within the specified
distance of one another
Returns true if the geometries are within the specified
distance of one another. For geometry units are in those of spatial reference and For geography units are in meters and measurement is
defaulted to use_spheroid=true (measure around spheroid), for faster check, use_spheroid=false to measure along sphere.
Returns true if the given geometries represent the same geometry. Directionality
is ignored.
Returns true if a geometry or geometry collection contains a circular string
Returns TRUE if the Geometries/Geography "spatially
intersect in 2D" - (share any portion of space) and FALSE if they don't (they are Disjoint).
For geography -- tolerance is 0.00001 meters (so any points that close are considered to intersect)
Returns the 2d length of the geometry if it is a linestring or multilinestring. geometry are in units of spatial reference and geography are in meters (default spheroid)
Returns the 2-dimensional length of the geometry if it is a
linestring or multi-linestring. This is an alias for ST_Length
Returns the 3-dimensional or 2-dimensional length of the geometry if it is a
linestring or multi-linestring.
Calculates the 2D or 3D length of a linestring/multilinestring on an ellipsoid. This
is useful if the coordinates of the geometry are in
longitude/latitude and a length is desired without reprojection.
Calculates the 2D length of a linestring/multilinestring on an ellipsoid. This
is useful if the coordinates of the geometry are in
longitude/latitude and a length is desired without reprojection.
Calculates the length of a geometry on an ellipsoid,
taking the elevation into account. This is just an alias for ST_Length_Spheroid.
Returns the 2-dimensional longest line points of two geometries.
The function will only return the first longest line if more than one, that the function finds.
The line returned will always start in g1 and end in g2.
The length of the line this function returns will always be the same as st_maxdistance returns for g1 and g2.
Returns true if the given geometries represent the same geometry
and points are in the same directional order.
Returns TRUE if the Geometries share space, are of the same dimension, but are not completely contained by each other.
Return the length measurement of the boundary of an ST_Surface
or ST_MultiSurface geometry or geography. (Polygon, Multipolygon). geometry measurement is in units of spatial reference and geography is in meters.
Returns the 2-dimensional perimeter of the geometry, if it
is a polygon or multi-polygon. This is currently an alias for ST_Perimeter.
Returns the 3-dimensional perimeter of the geometry, if it
is a polygon or multi-polygon.
Returns a POINT guaranteed to lie on the surface.
Returns a POINT projected from a start point using a bearing and distance.
Returns true if this Geometry is spatially related to
anotherGeometry, by testing for intersections between the
Interior, Boundary and Exterior of the two geometries as specified
by the values in the intersectionMatrixPattern. If no intersectionMatrixPattern
is passed in, then returns the maximum intersectionMatrixPattern that relates the 2 geometries.
Returns true if intersectionMattrixPattern1 implies intersectionMatrixPattern2
Returns the 2-dimensional shortest line between two geometries
Returns TRUE if the geometries have at least one point in common,
but their interiors do not intersect.
Returns true if the geometry A is completely inside geometry B
(T) For geometry: Returns a geometry that represents all points whose distance
from this Geometry is less than or equal to distance. Calculations
are in the Spatial Reference System of this Geometry. For geography: Uses a planar transform wrapper. Introduced in 1.5 support for
different end cap and mitre settings to control shape. buffer_style options: quad_segs=#,endcap=round|flat|square,join=round|mitre|bevel,mitre_limit=#.#
Creates an areal geometry formed by the constituent linework
of given geometry
Return a specified ST_Geometry value from a collection of other geometries.
The concave hull of a geometry represents a possibly concave
geometry that encloses all geometries within the set. You can think of it as shrink wrapping.
The convex hull of a geometry represents the minimum convex
geometry that encloses all geometries within the set.
Converts a CIRCULARSTRING/CURVEDPOLYGON to a LINESTRING/POLYGON
Returns a geometry that represents that part of geometry A
that does not intersect with geometry B.
Returns a set of geometry_dump (geom,path) rows, that make up a geometry g1.
Returns a set of geometry_dump (geom,path) rows of all points that make up a geometry.
Returns a set of geometry_dump rows, representing
the exterior and interior rings of a polygon.
Returns a version of the given geometry with
X and Y axis flipped. Useful for people
who have built latitude/longitude features
and need to fix them.
(T) Returns a geometry that represents the shared portion of geomA and geomB. The geography implementation
does a transform to geometry to do the intersection and then transform back to WGS84.
Converts a LINESTRING/POLYGON to a CIRCULARSTRING, CURVED POLYGON
Attempts to make an invalid geometry valid w/out loosing vertices.
Same as ST_Union, only memory-friendly (uses less memory
and more processor time).
Returns the smallest circle polygon that can fully contain a geometry. Default
uses 48 segments per quarter circle.
Aggregate. Creates a GeometryCollection containing possible
polygons formed from the constituent linework of a set of
geometries.
Node a set of linestrings.
Return an offset line at a given distance and side from an input line. Useful for computing parallel lines about a center line
ST_RemoveRepeatedPoints1 3d
Returns a version of the given geometry with
duplicated points removed.
Returns a collection containing paths shared by the two input linestrings/multilinestrings.
Reads every point/vertex in every component of every feature
in a geometry, and if the longitude coordinate is 0, adds 360
to it. The result would be a 0-360 version of the data to be
plotted in a 180 centric map
Returns a "simplified" version of the given geometry using
the Douglas-Peucker algorithm.
ST_SimplifyPreserveTopology
Returns a "simplified" version of the given geometry using
the Douglas-Peucker algorithm. Will avoid creating derived
geometries (polygons in particular) that are invalid.
Returns a collection of geometries resulting by splitting a geometry.
Returns a geometry that represents the portions of A and B
that do not intersect. It is called a symmetric difference because
ST_SymDifference(A,B) = ST_SymDifference(B,A).
Returns a geometry that represents the point set union of
the Geometries.
Like ST_Union, but working at the geometry component level.
ST_Line_Interpolate_Point3d
Returns a point interpolated along a line. Second argument is a float8 between 0 and 1
representing fraction of total length of linestring the point has to be located.
Returns a float between 0 and 1 representing the location of
the closest point on LineString to the given Point, as a fraction
of total 2d line length.
Return a linestring being a substring of the input one
starting and ending at the given fractions of total 2d length.
Second and third arguments are float8 values between 0 and
1.
Return a derived geometry collection value with elements
that match the specified measure. Polygonal elements are not
supported.
ST_Locate_Between_Measures
Return a derived geometry collection value with elements
that match the specified range of measures inclusively. Polygonal
elements are not supported.
ST_LocateBetweenElevations3d
Return a derived geometry (collection) value with elements
that intersect the specified range of elevations inclusively. Only 3D, 4D LINESTRINGS and MULTILINESTRINGS
are supported.
Return a derived geometry with measure elements linearly interpolated between the start and end points. If the geometry has no measure dimension, one is added. If the geometry has a measure dimension, it is over-written with new values. Only LINESTRINGS and MULTILINESTRINGS are supported.
Add an authorization token to be used in current transaction.
Creates trigger on a table to prevent/allow updates and deletes of rows based on authorization token.
Disable long transaction support. This function removes the
long transaction support metadata tables, and drops all triggers
attached to lock-checked tables.
Enable long transaction support. This function creates the
required metadata tables, needs to be called once before using the
other functions in this section. Calling it twice is
harmless.
Set lock/authorization for specific row in table
Remove all locks held by specified authorization id. Returns
the number of locks released.
Aggregate. Constructs an array of geometries.
Returns a BOX2D representing the maximum extents of the geometry.
Returns a BOX3D representing the maximum extents of the geometry.
Return the 'estimated' extent of the given spatial table.
The estimated is taken from the geometry column's statistics. The
current schema will be used if not specified.
Returns bounding box expanded in all directions from the bounding box of the input geometry. Uses double-precision
an aggregate function that returns the bounding box that bounds rows of geometries.
an aggregate function that returns the box3D bounding box that bounds rows of geometries.
The syntax is find_srid(db/schema, table,
column) and the function returns the integer SRID of the
specified column by searching through the GEOMETRY_COLUMNS table.
Returns the amount of space (in bytes) the geometry takes.
Is the point geometry insert circle defined by center_x, center_y, radius
Add bounding box to the geometry.
Drop the bounding box cache from the geometry.
Returns TRUE if the bbox of this geometry is cached, FALSE otherwise.
A spatial datatype with two fields - geom (holding a geometry object)
and val (holding a double precision pixel value from a raster band)
A composite type used as record output of the ST_Histogram and ST_ApproxHistogram functions.
raster spatial data type.
A composite type used as input into the ST_Reclass function defining the behavior of reclassification.
A composite type used as output of the ST_SummaryStats function.
Adds raster constraints to a loaded raster table for a specific column that constrains spatial ref, scaling, blocksize, alignment, bands, band type and a flag to denote if raster column is regularly blocked. The table must be loaded with data for the constraints to be inferred. Returns true of the constraint setting was accomplished and if issues a notice.
Drops PostGIS raster constraints that refer to a raster table column. Useful if you need to reload data or update your raster column data.
PostGIS_Raster_Lib_Build_Date
Reports full raster library build date
PostGIS_Raster_Lib_Version
Reports full raster version and build configuration
infos.
Returns a list of raster formats supported by your lib gdal. These are the formats you can output your raster using ST_AsGDALRaster.
Returns a raster with the new band(s) of given type added with given initial value in the given index location. If no index is specified, the band is added to the end.
Converts a PostGIS geometry to a PostGIS raster.
Returns one or more bands of an existing raster as a new raster. Useful for building new rasters from existing rasters.
Returns an empty raster (having no bands) of given dimensions, with upperleft x y, pixel size expressed as scalex, scaley, skewx, skewy and reference system (srid).
If a raster is passed in, returns a new raster with same meta data properties. If srid is left out, the spatial ref is set to unknown.
Returns the georeference meta data in GDAL or ESRI format as commonly seen in a world file. Default is GDAL.
Returns the height of the raster in pixels?
Returns basic meta data about a raster object such as skew, rotation, upper,lower left etc.
Returns the number of bands in the raster object.
Returns the pixel height in geometric units of the spatial reference system
Returns the pixel width in geometric units of the spatial reference system
Returns the x size of pixels in units of coordinate reference system?
Returns the y size of pixels in units of coordinate reference system?
Returns the geometric x coordinate upper left of a raster, column and row. Numbering of columns
and rows starts at 1.
Returns the geometric y coordinate upper left corner of a raster, column and row. Numbering of columns
and rows starts at 1.
Returns the rotation of the raster
Returns the georeference X skew (or rotation parameter)
Returns the georeference Y skew (or rotation parameter)
Returns the spatial reference identifier of the raster as defined in spatial_ref_sys table.
Returns the upper left x coordinate of raster in projected spatial ref.
Returns the upper left y coordinate of raster in projected spatial ref.
Returns the width of the raster in pixels?
Returns the column in the raster of the point geometry (pt) or a x y world coordinate (xw, yw) represented
in world spatial reference system of raster.
Returns the row in the raster of the point geometry (pt) or a x y world coordinate (xw, yw) represented
in world spatial reference system of raster.
Returns true if the raster is empty (width = 0 and height = 0). Otherwise, returns false.
Returns basic meta data for a specific raster band. band num 1 is assumed if none-specified.
Returns the value in a given band that represents no data. If no band num 1 is assumed.
Returns true if the band is filled with only nodata values.
Returns system file path to a band stored in file system. If no bandnum specified, 1 is assumed.
Returns the type of pixel for given band. If no bandnum specified, 1 is assumed.
Returns true if there is no band with given band number. If no band number is specified, then band number 1 is assumed.
Returns the geometry that bounds the pixel (for now a rectangle) for a particular band, row, column. If no band
specified band num 1 is assumed.
Returns the value of a given band in a given columnx, rowy pixel or at a particular geometric point. Band numbers start at 1 and assumed to be 1 if not specified. If exclude_nodata_value is set to false, then all pixels include nodata pixels are considered to intersect and return value. If exclude_nodata_value is not passed in then reads it from metadata of raster.
Returns modified raster resulting from setting the value of a given band in a given columnx, rowy pixel or at a pixel that intersects a particular geometric point. Band numbers start at 1 and assumed to be 1 if not specified.
Set Georeference 6 georeference parameters in a single call. Numbers should be separated by white space. Accepts inputs in GDAL or ESRI format. Default is GDAL.
Set the rotation of the raster.
Sets the x and y size of pixels in units of coordinate reference system. Number units/pixel width/height
Sets the georeference X and Y skew (or rotation parameter). If only one is passed in sets x and y to same number.
Sets the SRID of a raster to a particular integer srid defined in the spatial_ref_sys table.
Sets the value of the upper left corner of the pixel to projected x,y coordinates
Warps a raster in a known spatial reference system using a specified resampling algorithm and set of raster attributes or reference raster. If using a reference raster, the new raster will have the same srid, skew, scale and alignment.
Uses NearestNeighbor if no algorithm is specified Options: NearestNeighbor (english or american spelling), Bilinear, Cubic, CubicSpline, Lanczos.
Rescales a raster that is in a known spatial ref and using specified algorithm.
Uses NearestNeighbor if no algorithm is specified Options: NearestNeighbor (english or american spelling), Bilinear, Cubic, CubicSpline, Lanczos.
the scalex, scaley, scalexy are the desired new ratio between pixel coordinates and geometry coordinates
Reprojects a raster in a known spatial reference system to another known spatial reference system using specified resampling algorithm.
Uses NearestNeighbor if no algorithm is specified Options: NearestNeighbor, Bilinear, Cubic, CubicSpline, Lanczos.
Sets the value for the given band that represents no data. Band 1 is assumed if no band is specified. To mark a band as having no nodata value, set the nodata value = NULL
Sets the isnodata flag of the band to TRUE. You may
want to call this function if ST_BandIsNoData(rast, band) !=
ST_BandIsNodata(rast, band, TRUE). This is, if the isnodata flag
is dirty. Band 1 is assumed if no band is specified.
Returns the number of pixels in a given band of a raster or raster coverage. If no band is specified defaults to band 1. If exclude_nodata_value is set to true, will only count pixels that are not equal to the nodata value.
Returns a set of histogram summarizing a raster or raster coverage data distribution separate bin ranges. Number of bins are autocomputed if not specified.
Compute quantiles in the context of the sample or population. Thus, a value could be examined to be at the raster's 25%, 50%, 75% percentile.
Returns summary stats consisting of count,sum,mean,stddev,min,max for a given raster band of a raster or raster coverage. Band 1 is assumed is no band is specified.
Returns a set of records containing a pixel band value and count of the number of pixels in a given band of a raster (or a raster coverage) that have a given set of values. If no band is specified defaults to band 1. By default nodata value pixels are not counted.
and all other values in the pixel are output and pixel band values are rounded to the nearest integer.
Return the Well-Known Binary (WKB) representation of the raster without SRID meta data.
Return the raster tile in the designated GDAL Raster format. Raster formats are one of those supported by your compiled library. Use ST_GDALRasters() to get a list of formats supported by your library.
Return the raster tile selected bands as a single Joint Photographic Exports Group (JPEG) image (byte array). If no band is specified and 1 or more than 3 bands, then only the first band is used. If only 3 bands then all 3 bands are used and mapped to RGB.
Return the raster tile selected bands as a single portable network graphics (PNG) image (byte array). If 1,3, or 4 bands in raster and no bands are specified, then all bands are used. If more 2 or more than 4 bands and no bands specified, then only band 1 is used. Bands are mapped to RGB or RGBA space.
Return the raster tile selected bands as a single TIFF image (byte array). If no band is specified, then will try to use all bands?.
Returns the box 3d representation of the enclosing box of the raster
Returns a single band raster that is a band clipped by the input geometry. If no band is specified band 1 is assumed. If trimraster setting is not specified, false is assumed meaning
the output raster has the same extent as the input raster.
Return the convex hull geometry of the raster including pixel values equal to BandNoDataValue.
For regular shaped and non-skewed
rasters, this gives the same answer as ST_Envelope so only useful for irregularly shaped or skewed rasters.
Returns a set of geomval (geom,val) rows, from a given raster band. If no band number is specified, band num defaults to 1.
Returns the polygon representation of the extent of the raster.
Returns the hypothetical illumination of a raster band using provided azimuth, altitude, brightness, and elevation scale inputs. Useful for visualizing terrain.
Returns a set of geometry-pixelvalue pairs resulting from intersection of a raster band with a geometry when operation is geometry,raster.
If operationis raster,geometry then a raster is returned that is result of the input raser clipped by geometry. If
no band number is specified, band 1 is assumed.
1 raster band version: Creates a new one band raster formed by applying a valid PostgreSQL algebraic operation on the input raster band and of pixeltype provided. band 1 is assumed if no band is specified.
2 raster band version: Creates a new one band raster formed by applying a valid PostgreSQL algebraic operation on the 2 input raster bands and of pixeltype provided. band 1 of each raster is assumed if no band numbers are specified. The resulting raster will be aligned (scale, skew and pixel corners) on the grid defined by the first raster. The resulting raster will have the extent defined by the "extenttype" parameter. Values for "extenttype" can be: INTERSECTION, UNION, FIRST, SECOND
1 band version - Creates a new one band raster formed by applying a valid PostgreSQL function on the input raster band and of pixeltype prodived. Band 1 is assumed if no band is specified.
2 band version - Creates a new one band raster formed by applying a valid PostgreSQL function on the 2 input raster bands and of pixeltype prodived. Band 1 is assumed if no band is specified. Extent type defaults to INTERSECTION if not specified
1-band version: Map Algebra Nearest Neighbor using user-defined PostgreSQL function. Return a raster which values are the result of a PLPGSQL user function involving a neighborhood of values from the input raster band.
Returns a polygon geometry formed by the union of pixels that have a pixel value that is not no data value. If no band number is specified, band num defaults to 1.
Creates a new raster composed of band types reclassified from original. The nband is the band to be changed. If nband is not specified assumed to be 1. All other bands are returned unchanged.
Use case: convert a 16BUI band to a 8 8BUI and so forth for simpler rendering as viewable formats.
Returns the union of a set of raster tiles into a single raster composed of 1 band. If no band is specified for unioning, band num 1 is assumed. The resulting raster's extent is the extent of the whole set. In the case of intersection, the resulting value is defined by p_expression which is one of the following: LAST - the default when none is specified, MEAN, SUM, FIRST, MAX, MIN
Returns TRUE if A's bounding box overlaps B's.
Returns TRUE if A's bounding box is to the left of B's.
Returns TRUE if A's bounding box is to the right of B's.
If band numbers are omitted only considers convex hull of raster. Returns true only if rast pixel in a band with non-nodata band value intersects
with a geometry/raster.
Returns true if rasters have same skew,scale, spatial ref and false if they don't with notice detailing issue.
A composite type that consists of a sequence number and edge number. This is the return type for ST_GetFaceEdges
A composite type that refers to a topology geometry in a specific topology, layer, having specific type (1:[multi]point, 2:[multi]line, 3:[multi]poly, 4:collection) with specific identifier id in the topology. The id uniquely defines the topogeometry in the topology.
validatetopology_returntype
A composite type that consists of an error message and id1 and id2 to denote location of error. This is the return type for ValidateTopology
An array of 2 integers generally used to identify a TopoGeometry component.
An array of element_id,element_type values. a bidimensional array of integers: '{{id,type}, {id,type}, ...}'
Adds a topogeometry column to an existing table, registers this new column as a layer in topology.layer and returns the new layer_id.
Creates a new topology schema and registers this new schema in the topology.topology table.
Use with caution: Drops a topology schema and deletes its reference from topology.topology table and references to tables in that schema from the geometry_columns table.
Makes a copy of a topology structure (nodes, edges, faces, layers and TopoGeometries).
Drops the topogeometry column from the table named table_name in schema schema_name and unregisters the columns from topology.layer table.
Creates a new topology schema and registers this new schema in the topology.topology table and details summary of process.
Takes a topology name and provides summary totals of types of objects in topology
Returns a set of validatetopology_returntype objects detailing issues with topology
Adds a collection of geometries to a given empty topology and returns a message detailing success.
Adds an isolated node to a face in a topology and returns the nodeid of the new node. If face is null, the node is still created.
Adds an isolated edge defined by geometry alinestring to a topology connecting two existing isolated nodes anode and anothernode and returns the edge id of the new edge.
Add a new edge and, if in doing so it splits a face, delete the original face and replace it with two new faces.
Add a new edge and, if in doing so it splits a face, modify the original face and add a new face.
Removes an edge and, if the removed edge separated two faces,
delete the original faces and replace them with a new face.
Removes an edge and, if the removed edge separated two faces,
delete one of the them and modify the other to take the space of both.
Changes the linestring that define the specified edge. Will raise an error if the start and end points are not the same as the original or the new linestring
crosses an existing edge (not at end points) or new linestring is not simple.
Split an edge by creating a new node along an existing edge, modifying the original edge and adding a new edge.
Heal two edges by deleting the node connecting them, modifying the first edge
and deleting the second edge. Returns the id of the deleted node.
Heal two edges by deleting the node connecting them, deleting both edges,
and replacing them with an edge whose direction is the same as the first
edge provided.
Moves an isolated node in a topology from one point to another. If new apoint geometry exists as a node an error is thrown. REturns description of move.
Split an edge by creating a new node along an existing edge, deleting the original edge and replacing it with two new edges. Returns the id of the new node created that joins the new edges.
Removes an isolated node and returns description of action. If the node is not isolated (is start or end of an edge), then an exception is thrown.
Find the edge-id of an edge that intersects a given point
Find the face-id of a face that intersects a given point
Find the id of a node at a point location
Returns the id of a topology in the topology.topology table given the name of the topology.
Returns the name of a topology (schema) given the id of the topology.
Returns a set of ordered edges that bound aface includes the sequence order.
Returns the polygon in the given topology with the specified face id.
Adds a point to an existing topology using a tolerance and possibly splitting an existing edge.
Adds a linestring to an existing topology using a tolerance and possibly splitting existing edges.
Adds a polygon to an existing topology using a tolerance and possibly splitting existing edges/faces.
Find and register all faces defined by topology edges
Adds a point node to the node table in the specified topology schema and returns the nodeid of new node. If point already exists as node, the existing nodeid is returned.
Adds a linestring edge to the edge table and associated start and end points to the point nodes table of the specified topology schema using the specified linestring geometry and returns the edgeid of the new (or existing) edge.
Registers a face primitive to a topology and get it's identifier.
Creates a new topo geometry object from topo element array - tg_type: 1:[multi]point, 2:[multi]line, 3:[multi]poly, 4:collection
Creates a new topo geometry from a simple geometry
Returns a topoelementarray for a set of element_id, type arrays (topoelements)
Returns a topoelementarray (an array of topoelements) containing the topological elements and type of the given TopoGeometry (primitive elements)
Returns a set of topoelement objects containing the topological element_id,element_type of the given TopoGeometry (primitive elements)
Returns the GML representation of a topogeometry.
Drop_Indexes_Generate_Script1
Generates a script that drops all non-primary key and non-unique indexes on tiger schema and user specified schema. Defaults schema to tiger_data if no schema is specified.
Drop_State_Tables_Generate_Script1
Generates a script that drops all tables in the specified schema that are prefixed with the state abbreviation. Defaults schema to tiger_data if no schema is specified.
Takes in an address as a string (or other normalized address) and outputs a set of possible locations which include a point geometry in NAD 83 long lat, a normalized address for each, and the rating. The lower the rating the more likely the match.
Results are sorted by lowest rating first. Can optionally pass in maximum results, defaults to 10, and restrict_region (defaults to NULL)
Takes in 2 streets that intersect and a state, city, zip, and outputs a set of possible locations on the first cross street that is at the intersection, also includes a point geometry in NAD 83 long lat, a normalized address for each location, and the rating. The lower the rating the more likely the match.
Results are sorted by lowest rating first. Can optionally pass in maximum results, defaults to 10
Finds all tables with key columns used in geocoder joins and filter conditions that are missing used indexes on those columns and will add them.
Generates a shell script for the specified platform for the specified states that will download Tiger data, stage and load into tiger_data schema. Each state script is returned as a separate record. Latest version supports Tiger 2010 structural changes.
Missing_Indexes_Generate_Script1
Finds all tables with key columns used in geocoder joins that are missing indexes on those columns and will output the SQL DDL to
define the index for those tables.
Given a textual street address, returns a composite norm_addy type that has road suffix, prefix and type standardized, street, streetname etc. broken into separate fields. This function
will work with just the lookup data packaged with the tiger_geocoder (no need for tiger census data).
Given a norm_addy composite type object, returns a pretty print representation of it. Usually used in conjunction with normalize_address.
Takes a geometry point in a known spatial ref sys and returns a record containing an array of theoretically possible addresses and an array of cross streets. If include_strnum_range = true, includes the street range in the cross streets.
Loads a defined region of tiger data into a PostGIS Topology and transforming the tiger data to spatial reference of the topology
and snapping to the precision tolerance of the topology.
