Functions

GLHI Database HTML Dump

Functions

Function	Schema	Returns	Arguments	Owner	Language
accum	public	public.geometry []	public.geometry	wetlands	internal
addbbox	public	public.geometry	public.geometry	wetlands	c
addgeometrycolumn	public	text	varchar, varchar, varchar, varchar, integer, varchar, integer	wetlands	plpgsql
addgeometrycolumn	public	text	varchar, varchar, varchar, integer, varchar, integer	wetlands	plpgsql
addgeometrycolumn	public	text	varchar, varchar, integer, varchar, integer	wetlands	plpgsql
addpoint	public	public.geometry	public.geometry, public.geometry	wetlands	c
addpoint	public	public.geometry	public.geometry, public.geometry, integer	wetlands	c
area	public	double precision	public.geometry	wetlands	c
area2d	public	double precision	public.geometry	wetlands	c
asbinary	public	bytea	public.geometry	wetlands	c
asbinary	public	bytea	public.geometry, text	wetlands	c
asewkb	public	bytea	public.geometry	wetlands	c
asewkb	public	bytea	public.geometry, text	wetlands	c
asewkt	public	text	public.geometry	wetlands	c
asgml	public	text	public.geometry, integer, integer	wetlands	c
asgml	public	text	public.geometry, integer	wetlands	c
asgml	public	text	public.geometry	wetlands	c
assvg	public	text	public.geometry, integer, integer	wetlands	c
assvg	public	text	public.geometry, integer	wetlands	c
assvg	public	text	public.geometry	wetlands	c
astext	public	text	public.geometry	wetlands	c
azimuth	public	double precision	public.geometry, public.geometry	wetlands	c
bdmpolyfromtext	public	public.geometry	text, integer	wetlands	plpgsql
bdpolyfromtext	public	public.geometry	text, integer	wetlands	plpgsql
boundary	public	public.geometry	public.geometry	wetlands	c
box	public	box	public.geometry	wetlands	c
box	public	box	public.box3d	wetlands	c
box2d	public	public.box2d	public.geometry	wetlands	c
box2d	public	public.box2d	public.box3d	wetlands	c
box2d_contain	public	boolean	public.box2d, public.box2d	wetlands	c
box2d_contained	public	boolean	public.box2d, public.box2d	wetlands	c
box2d_in	public	public.box2d	pg_catalog.cstring	wetlands	c
box2d_intersects	public	boolean	public.box2d, public.box2d	wetlands	c
box2d_left	public	boolean	public.box2d, public.box2d	wetlands	c
box2d_out	public	pg_catalog.cstring	public.box2d	wetlands	c
box2d_overlap	public	boolean	public.box2d, public.box2d	wetlands	c
box2d_overleft	public	boolean	public.box2d, public.box2d	wetlands	c
box2d_overright	public	boolean	public.box2d, public.box2d	wetlands	c
box2d_right	public	boolean	public.box2d, public.box2d	wetlands	c
box2d_same	public	boolean	public.box2d, public.box2d	wetlands	c
box3d	public	public.box3d	public.geometry	wetlands	c
box3d	public	public.box3d	public.box2d	wetlands	c
box3d_in	public	public.box3d	pg_catalog.cstring	wetlands	c
box3d_out	public	pg_catalog.cstring	public.box3d	wetlands	c
box3dtobox	public	box	public.box3d	wetlands	sql
buffer	public	public.geometry	public.geometry, double precision	wetlands	c
buffer	public	public.geometry	public.geometry, double precision, integer	wetlands	c
build_histogram2d	public	public.histogram2d	public.histogram2d, text, text	wetlands	c
build_histogram2d	public	public.histogram2d	public.histogram2d, text, text, text	wetlands	plpgsql
buildarea	public	public.geometry	public.geometry	wetlands	c
bytea	public	bytea	public.geometry	wetlands	c
cache_bbox	public	trigger		wetlands	c
centroid	public	public.geometry	public.geometry	wetlands	c
chip_in	public	public.chip	pg_catalog.cstring	wetlands	c
chip_out	public	pg_catalog.cstring	public.chip	wetlands	c
collect	public	public.geometry	public.geometry, public.geometry	wetlands	c
collect	public	public.geometry	public.geometry	wetlands	internal
collect_garray	public	public.geometry	public.geometry []	wetlands	c
collector	public	public.geometry	public.geometry, public.geometry	wetlands	c
combine_bbox	public	public.box2d	public.box2d, public.geometry	wetlands	c
combine_bbox	public	public.box3d	public.box3d, public.geometry	wetlands	c
compression	public	integer	public.chip	wetlands	c
contains	public	boolean	public.geometry, public.geometry	wetlands	c
convexhull	public	public.geometry	public.geometry	wetlands	c
create_histogram2d	public	public.histogram2d	public.box2d, integer	wetlands	c
crosses	public	boolean	public.geometry, public.geometry	wetlands	c
datatype	public	integer	public.chip	wetlands	c
difference	public	public.geometry	public.geometry, public.geometry	wetlands	c
dimension	public	integer	public.geometry	wetlands	c
disjoint	public	boolean	public.geometry, public.geometry	wetlands	c
distance	public	double precision	public.geometry, public.geometry	wetlands	c
distance_sphere	public	double precision	public.geometry, public.geometry	wetlands	c
distance_spheroid	public	double precision	public.geometry, public.geometry, public.spheroid	wetlands	c
dropbbox	public	public.geometry	public.geometry	wetlands	c
dropgeometrycolumn	public	text	varchar, varchar, varchar, varchar	wetlands	plpgsql
dropgeometrycolumn	public	text	varchar, varchar, varchar	wetlands	plpgsql
dropgeometrycolumn	public	text	varchar, varchar	wetlands	plpgsql
dropgeometrytable	public	text	varchar, varchar	wetlands	sql
dropgeometrytable	public	text	varchar	wetlands	sql
dropgeometrytable	public	text	varchar, varchar, varchar	wetlands	plpgsql
dump	public	public.geometry_dump	public.geometry	wetlands	c
endpoint	public	public.geometry	public.geometry	wetlands	c
envelope	public	public.geometry	public.geometry	wetlands	c
equals	public	boolean	public.geometry, public.geometry	wetlands	c
estimate_histogram2d	public	double precision	public.histogram2d, public.box2d	wetlands	c
estimated_extent	public	public.box2d	text, text, text	wetlands	c
estimated_extent	public	public.box2d	text, text	wetlands	c
expand	public	public.geometry	public.geometry, double precision	wetlands	c
expand	public	public.box3d	public.box3d, double precision	wetlands	c
expand	public	public.box2d	public.box2d, double precision	wetlands	c
explode_histogram2d	public	public.histogram2d	public.histogram2d, text	wetlands	c
extent	public	public.box2d	public.geometry	wetlands	internal
extent3d	public	public.box3d	public.geometry	wetlands	internal
exteriorring	public	public.geometry	public.geometry	wetlands	c
factor	public	real	public.chip	wetlands	c
find_extent	public	public.box2d	text, text, text	wetlands	plpgsql
find_extent	public	public.box2d	text, text	wetlands	plpgsql
find_srid	public	integer	varchar, varchar, varchar	wetlands	plpgsql
fix_geometry_columns	public	text		wetlands	plpgsql
force_2d	public	public.geometry	public.geometry	wetlands	c
force_3d	public	public.geometry	public.geometry	wetlands	c
force_3dm	public	public.geometry	public.geometry	wetlands	c
force_3dz	public	public.geometry	public.geometry	wetlands	c
force_4d	public	public.geometry	public.geometry	wetlands	c
force_collection	public	public.geometry	public.geometry	wetlands	c
forcerhr	public	public.geometry	public.geometry	wetlands	c
geom_accum	public	public.geometry []	public.geometry [], public.geometry	wetlands	c
geomcollfromtext	public	public.geometry	text, integer	wetlands	sql
geomcollfromtext	public	public.geometry	text	wetlands	sql
geomcollfromwkb	public	public.geometry	bytea, integer	wetlands	sql
geomcollfromwkb	public	public.geometry	bytea	wetlands	sql
geometry	public	public.geometry	text	wetlands	c
geometry	public	public.geometry	public.box2d	wetlands	c
geometry	public	public.geometry	bytea	wetlands	c
geometry	public	public.geometry	public.box3d	wetlands	c
geometry	public	public.geometry	public.chip	wetlands	c
geometry_above	public	boolean	public.geometry, public.geometry	wetlands	c
geometry_analyze	public	boolean	pg_catalog.internal	wetlands	c
geometry_below	public	boolean	public.geometry, public.geometry	wetlands	c
geometry_cmp	public	integer	public.geometry, public.geometry	wetlands	c
geometry_contain	public	boolean	public.geometry, public.geometry	wetlands	c
geometry_contained	public	boolean	public.geometry, public.geometry	wetlands	c
geometry_eq	public	boolean	public.geometry, public.geometry	wetlands	c
geometry_ge	public	boolean	public.geometry, public.geometry	wetlands	c
geometry_gt	public	boolean	public.geometry, public.geometry	wetlands	c
geometry_in	public	public.geometry	pg_catalog.cstring	wetlands	c
geometry_le	public	boolean	public.geometry, public.geometry	wetlands	c
geometry_left	public	boolean	public.geometry, public.geometry	wetlands	c
geometry_lt	public	boolean	public.geometry, public.geometry	wetlands	c
geometry_out	public	pg_catalog.cstring	public.geometry	wetlands	c
geometry_overabove	public	boolean	public.geometry, public.geometry	wetlands	c
geometry_overbelow	public	boolean	public.geometry, public.geometry	wetlands	c
geometry_overlap	public	boolean	public.geometry, public.geometry	wetlands	c
geometry_overleft	public	boolean	public.geometry, public.geometry	wetlands	c
geometry_overright	public	boolean	public.geometry, public.geometry	wetlands	c
geometry_recv	public	public.geometry	pg_catalog.internal	wetlands	c
geometry_right	public	boolean	public.geometry, public.geometry	wetlands	c
geometry_same	public	boolean	public.geometry, public.geometry	wetlands	c
geometry_send	public	bytea	public.geometry	wetlands	c
geometryfromtext	public	public.geometry	text	wetlands	c
geometryfromtext	public	public.geometry	text, integer	wetlands	c
geometryn	public	public.geometry	public.geometry, integer	wetlands	c
geometrytype	public	text	public.geometry	wetlands	c
geomfromewkb	public	public.geometry	bytea	wetlands	c
geomfromewkt	public	public.geometry	text	wetlands	c
geomfromtext	public	public.geometry	text	wetlands	sql
geomfromtext	public	public.geometry	text, integer	wetlands	sql
geomfromwkb	public	public.geometry	bytea	wetlands	c
geomfromwkb	public	public.geometry	bytea, integer	wetlands	sql
geomunion	public	public.geometry	public.geometry	wetlands	internal
geomunion	public	public.geometry	public.geometry, public.geometry	wetlands	c
geosnoop	public	public.geometry	public.geometry	wetlands	c
get_proj4_from_srid	public	text	integer	wetlands	plpgsql
getbbox	public	public.box2d	public.geometry	wetlands	c
getsrid	public	integer	public.geometry	wetlands	c
hasbbox	public	boolean	public.geometry	wetlands	c
height	public	integer	public.chip	wetlands	c
histogram2d_in	public	public.histogram2d	pg_catalog.cstring	wetlands	c
histogram2d_out	public	pg_catalog.cstring	public.histogram2d	wetlands	c
interiorringn	public	public.geometry	public.geometry, integer	wetlands	c
intersection	public	public.geometry	public.geometry, public.geometry	wetlands	c
intersects	public	boolean	public.geometry, public.geometry	wetlands	c
isclosed	public	boolean	public.geometry	wetlands	c
isempty	public	boolean	public.geometry	wetlands	c
isring	public	boolean	public.geometry	wetlands	c
issimple	public	boolean	public.geometry	wetlands	c
isvalid	public	boolean	public.geometry	wetlands	c
jtsnoop	public	public.geometry	public.geometry	wetlands	c
length	public	double precision	public.geometry	wetlands	c
length2d	public	double precision	public.geometry	wetlands	c
length2d_spheroid	public	double precision	public.geometry, public.spheroid	wetlands	c
length3d	public	double precision	public.geometry	wetlands	c
length3d_spheroid	public	double precision	public.geometry, public.spheroid	wetlands	c
length_spheroid	public	double precision	public.geometry, public.spheroid	wetlands	c
line_interpolate_point	public	public.geometry	public.geometry, double precision	wetlands	c
line_locate_point	public	double precision	public.geometry, public.geometry	wetlands	c
line_substring	public	public.geometry	public.geometry, double precision, double precision	wetlands	c
linefrommultipoint	public	public.geometry	public.geometry	wetlands	c
linefromtext	public	public.geometry	text, integer	wetlands	sql
linefromtext	public	public.geometry	text	wetlands	sql
linefromwkb	public	public.geometry	bytea	wetlands	sql
linefromwkb	public	public.geometry	bytea, integer	wetlands	sql
linemerge	public	public.geometry	public.geometry	wetlands	c
linestringfromtext	public	public.geometry	text	wetlands	sql
linestringfromtext	public	public.geometry	text, integer	wetlands	sql
linestringfromwkb	public	public.geometry	bytea	wetlands	sql
linestringfromwkb	public	public.geometry	bytea, integer	wetlands	sql
locate_along_measure	public	public.geometry	public.geometry, double precision	wetlands	sql
locate_between_measures	public	public.geometry	public.geometry, double precision, double precision	wetlands	c
lwgeom_gist_compress	public	pg_catalog.internal	pg_catalog.internal	wetlands	c
lwgeom_gist_consistent	public	boolean	pg_catalog.internal, public.geometry, integer	wetlands	c
lwgeom_gist_decompress	public	pg_catalog.internal	pg_catalog.internal	wetlands	c
lwgeom_gist_penalty	public	pg_catalog.internal	pg_catalog.internal, pg_catalog.internal, pg_catalog.internal	wetlands	c
lwgeom_gist_picksplit	public	pg_catalog.internal	pg_catalog.internal, pg_catalog.internal	wetlands	c
lwgeom_gist_same	public	pg_catalog.internal	public.box2d, public.box2d, pg_catalog.internal	wetlands	c
lwgeom_gist_union	public	pg_catalog.internal	bytea, pg_catalog.internal	wetlands	c
m	public	double precision	public.geometry	wetlands	c
makebox2d	public	public.box2d	public.geometry, public.geometry	wetlands	c
makebox3d	public	public.box3d	public.geometry, public.geometry	wetlands	c
makeline	public	public.geometry	public.geometry	wetlands	internal
makeline	public	public.geometry	public.geometry, public.geometry	wetlands	c
makeline_garray	public	public.geometry	public.geometry []	wetlands	c
makepoint	public	public.geometry	double precision, double precision, double precision, double precision	wetlands	c
makepoint	public	public.geometry	double precision, double precision, double precision	wetlands	c
makepoint	public	public.geometry	double precision, double precision	wetlands	c
makepointm	public	public.geometry	double precision, double precision, double precision	wetlands	c
makepolygon	public	public.geometry	public.geometry	wetlands	c
makepolygon	public	public.geometry	public.geometry, public.geometry []	wetlands	c
max_distance	public	double precision	public.geometry, public.geometry	wetlands	c
mem_size	public	integer	public.geometry	wetlands	c
memcollect	public	public.geometry	public.geometry	wetlands	internal
memgeomunion	public	public.geometry	public.geometry	wetlands	internal
mk_the_geom	public	trigger		glosdb	plpgsql
mk_the_geom2	public	trigger		glosdb	plpgsql
mlinefromtext	public	public.geometry	text, integer	wetlands	sql
mlinefromtext	public	public.geometry	text	wetlands	sql
mlinefromwkb	public	public.geometry	bytea	wetlands	sql
mlinefromwkb	public	public.geometry	bytea, integer	wetlands	sql
mpointfromtext	public	public.geometry	text, integer	wetlands	sql
mpointfromtext	public	public.geometry	text	wetlands	sql
mpointfromwkb	public	public.geometry	bytea, integer	wetlands	sql
mpointfromwkb	public	public.geometry	bytea	wetlands	sql
mpolyfromtext	public	public.geometry	text	wetlands	sql
mpolyfromtext	public	public.geometry	text, integer	wetlands	sql
mpolyfromwkb	public	public.geometry	bytea	wetlands	sql
mpolyfromwkb	public	public.geometry	bytea, integer	wetlands	sql
multi	public	public.geometry	public.geometry	wetlands	c
multilinefromwkb	public	public.geometry	bytea, integer	wetlands	sql
multilinefromwkb	public	public.geometry	bytea	wetlands	sql
multilinestringfromtext	public	public.geometry	text, integer	wetlands	sql
multilinestringfromtext	public	public.geometry	text	wetlands	sql
multipointfromtext	public	public.geometry	text	wetlands	sql
multipointfromtext	public	public.geometry	text, integer	wetlands	sql
multipointfromwkb	public	public.geometry	bytea	wetlands	sql
multipointfromwkb	public	public.geometry	bytea, integer	wetlands	sql
multipolyfromwkb	public	public.geometry	bytea	wetlands	sql
multipolyfromwkb	public	public.geometry	bytea, integer	wetlands	sql
multipolygonfromtext	public	public.geometry	text	wetlands	sql
multipolygonfromtext	public	public.geometry	text, integer	wetlands	sql
ndims	public	smallint	public.geometry	wetlands	c
noop	public	public.geometry	public.geometry	wetlands	c
npoints	public	integer	public.geometry	wetlands	c
nrings	public	integer	public.geometry	wetlands	c
numgeometries	public	integer	public.geometry	wetlands	c
numinteriorring	public	integer	public.geometry	wetlands	c
numinteriorrings	public	integer	public.geometry	wetlands	c
numpoints	public	integer	public.geometry	wetlands	c
overlaps	public	boolean	public.geometry, public.geometry	wetlands	c
perimeter	public	double precision	public.geometry	wetlands	c
perimeter2d	public	double precision	public.geometry	wetlands	c
perimeter3d	public	double precision	public.geometry	wetlands	c
point_inside_circle	public	boolean	public.geometry, double precision, double precision, double precision	wetlands	c
pointfromtext	public	public.geometry	text, integer	wetlands	sql
pointfromtext	public	public.geometry	text	wetlands	sql
pointfromwkb	public	public.geometry	bytea	wetlands	sql
pointfromwkb	public	public.geometry	bytea, integer	wetlands	sql
pointn	public	public.geometry	public.geometry, integer	wetlands	c
pointonsurface	public	public.geometry	public.geometry	wetlands	c
polyfromtext	public	public.geometry	text, integer	wetlands	sql
polyfromtext	public	public.geometry	text	wetlands	sql
polyfromwkb	public	public.geometry	bytea, integer	wetlands	sql
polyfromwkb	public	public.geometry	bytea	wetlands	sql
polygonfromtext	public	public.geometry	text, integer	wetlands	sql
polygonfromtext	public	public.geometry	text	wetlands	sql
polygonfromwkb	public	public.geometry	bytea	wetlands	sql
polygonfromwkb	public	public.geometry	bytea, integer	wetlands	sql
polygonize	public	public.geometry	public.geometry	wetlands	internal
polygonize_garray	public	public.geometry	public.geometry []	wetlands	c
postgis_full_version	public	text		wetlands	plpgsql
postgis_geos_version	public	text		wetlands	c
postgis_gist_joinsel	public	double precision	pg_catalog.internal, oid, pg_catalog.internal, smallint	wetlands	c
postgis_gist_sel	public	double precision	pg_catalog.internal, oid, pg_catalog.internal, integer	wetlands	c
postgis_jts_version	public	text		wetlands	c
postgis_lib_build_date	public	text		wetlands	c
postgis_lib_version	public	text		wetlands	c
postgis_proj_version	public	text		wetlands	c
postgis_scripts_build_date	public	text		wetlands	sql
postgis_scripts_installed	public	text		wetlands	sql
postgis_scripts_released	public	text		wetlands	c
postgis_uses_stats	public	boolean		wetlands	c
postgis_version	public	text		wetlands	c
probe_geometry_columns	public	text		wetlands	plpgsql
relate	public	boolean	public.geometry, public.geometry, text	wetlands	c
relate	public	text	public.geometry, public.geometry	wetlands	c
removepoint	public	public.geometry	public.geometry, integer	wetlands	c
rename_geometry_table_constraints	public	text		wetlands	sql
reverse	public	public.geometry	public.geometry	wetlands	c
scale	public	public.geometry	public.geometry, double precision, double precision, double precision	wetlands	c
scale	public	public.geometry	public.geometry, double precision, double precision	wetlands	sql
segmentize	public	public.geometry	public.geometry, double precision	wetlands	c
setfactor	public	public.chip	public.chip, real	wetlands	c
setpoint	public	public.geometry	public.geometry, integer, public.geometry	wetlands	c
setsrid	public	public.geometry	public.geometry, integer	wetlands	c
setsrid	public	public.chip	public.chip, integer	wetlands	c
shift_longitude	public	public.geometry	public.geometry	wetlands	c
simplify	public	public.geometry	public.geometry, double precision	wetlands	c
snaptogrid	public	public.geometry	public.geometry, double precision, double precision	wetlands	sql
snaptogrid	public	public.geometry	public.geometry, double precision	wetlands	sql
snaptogrid	public	public.geometry	public.geometry, double precision, double precision, double precision, double precision	wetlands	c
snaptogrid	public	public.geometry	public.geometry, public.geometry, double precision, double precision, double precision, double precision	wetlands	c
spheroid_in	public	public.spheroid	pg_catalog.cstring	wetlands	c
spheroid_out	public	pg_catalog.cstring	public.spheroid	wetlands	c
srid	public	integer	public.geometry	wetlands	c
srid	public	integer	public.chip	wetlands	c
startpoint	public	public.geometry	public.geometry	wetlands	c
summary	public	text	public.geometry	wetlands	c
symdifference	public	public.geometry	public.geometry, public.geometry	wetlands	c
symmetricdifference	public	public.geometry	public.geometry, public.geometry	wetlands	c
text	public	text	boolean	wetlands	c
text	public	text	public.geometry	wetlands	c
touches	public	boolean	public.geometry, public.geometry	wetlands	c
transform	public	public.geometry	public.geometry, integer	wetlands	c
transform_geometry	public	public.geometry	public.geometry, text, text, integer	wetlands	c
translate	public	public.geometry	public.geometry, double precision, double precision	wetlands	sql
translate	public	public.geometry	public.geometry, double precision, double precision, double precision	wetlands	c
transscale	public	public.geometry	public.geometry, double precision, double precision, double precision, double precision	wetlands	c
unite_garray	public	public.geometry	public.geometry []	wetlands	c
update_geometry_stats	public	text		wetlands	sql
update_geometry_stats	public	text	varchar, varchar	wetlands	sql
updategeometrysrid	public	text	varchar, varchar, varchar, varchar, integer	wetlands	plpgsql
updategeometrysrid	public	text	varchar, varchar, integer	wetlands	plpgsql
updategeometrysrid	public	text	varchar, varchar, varchar, integer	wetlands	plpgsql
width	public	integer	public.chip	wetlands	c
within	public	boolean	public.geometry, public.geometry	wetlands	c
x	public	double precision	public.geometry	wetlands	c
xmax	public	double precision	public.box3d	wetlands	c
xmin	public	double precision	public.box3d	wetlands	c
y	public	double precision	public.geometry	wetlands	c
ymax	public	double precision	public.box3d	wetlands	c
ymin	public	double precision	public.box3d	wetlands	c
z	public	double precision	public.geometry	wetlands	c
zmax	public	double precision	public.box3d	wetlands	c
zmflag	public	smallint	public.geometry	wetlands	c
zmin	public	double precision	public.box3d	wetlands	c

Pete Giencke
pgiencke@glc.org