Thursday, January 24, 2013

PostGIS 2.0 functions list

I couldn't find a simple list of PostGIS functions on the web so here is a list of PostGIS 2.0 functions and a sql command to list them for yourself:
SELECT  proname
FROM    pg_catalog.pg_namespace n
JOIN    pg_catalog.pg_proc p
ON      pronamespace = n.oid
WHERE   nspname = 'public'
order by proname
See the list after the jump:


_st_3ddfullywithin
_st_3ddwithin
_st_asgeojson
_st_asgml
_st_askml
_st_asx3d
_st_bestsrid
_st_buffer
_st_concavehull
_st_contains
_st_containsproperly
_st_coveredby
_st_covers
_st_crosses
_st_dfullywithin
_st_distance
_st_dumppoints
_st_dwithin
_st_equals
_st_expand
_st_geomfromgml
_st_intersects
_st_linecrossingdirection
_st_longestline
_st_maxdistance
_st_orderingequals
_st_overlaps
_st_pointoutside
_st_touches
_st_within
accum
addauth
addbbox
addcolumnifnotexists
addconstraintifnotexists
addgeometrycolumn
addindexifnotexists
addpoint
addschemaifnotexists
addsequenceifnotexists
addtableifnotexists
addtriggerifnotexists
affine
area
area2d
asbinary
asewkb
asewkt
asgml
ashexewkb
askml
assvg
astext
average_pixels
azimuth
bdmpolyfromtext
bdpolyfromtext
boundary
box
box2d
box2d_in
box2d_out
box2df_in
box2df_out
box3d
box3d_in
box3d_out
box3dtobox
buffer
buildarea
bytea
calculateproductunits
calculateproductunitssafe
centroid
checkauth
checkauthtrigger
collect
combine_bbox
contains
convexhull
crosses
date_range
days_in_month
difference
dimension
disablelongtransactions
disjoint
distance
distance_sphere
distance_spheroid
dropbbox
dropcolumnifexists
dropconstraintifexists
dropgeometrycolumn
dropgeometrytable
dropindexifexists
dropkeyifexists
dropsequenceifexists
droptableifexists
dropviewifexists
dump
dumprings
enablelongtransactions
endpoint
envelope
equals
estimated_extent
executeifnotexists
expand
extent
extent3d
exteriorring
find_extent
find_srid
fix_geometry_columns
force_2d
force_3d
force_3dm
force_3dz
force_4d
force_collection
forcerhr
geography
geography_analyze
geography_cmp
geography_eq
geography_ge
geography_gist_compress
geography_gist_consistent
geography_gist_decompress
geography_gist_join_selectivity
geography_gist_penalty
geography_gist_picksplit
geography_gist_same
geography_gist_selectivity
geography_gist_union
geography_gt
geography_in
geography_le
geography_lt
geography_out
geography_overlaps
geography_recv
geography_send
geography_typmod_in
geography_typmod_out
geomcollfromtext
geomcollfromwkb
geometry
geometry_above
geometry_analyze
geometry_below
geometry_cmp
geometry_contains
geometry_distance_box
geometry_distance_centroid
geometry_eq
geometry_ge
geometry_gist_compress_2d
geometry_gist_compress_nd
geometry_gist_consistent_2d
geometry_gist_consistent_nd
geometry_gist_decompress_2d
geometry_gist_decompress_nd
geometry_gist_distance_2d
geometry_gist_joinsel_2d
geometry_gist_penalty_2d
geometry_gist_penalty_nd
geometry_gist_picksplit_2d
geometry_gist_picksplit_nd
geometry_gist_same_2d
geometry_gist_same_nd
geometry_gist_sel_2d
geometry_gist_union_2d
geometry_gist_union_nd
geometry_gt
geometry_in
geometry_le
geometry_left
geometry_lt
geometry_out
geometry_overabove
geometry_overbelow
geometry_overlaps
geometry_overlaps_nd
geometry_overleft
geometry_overright
geometry_recv
geometry_right
geometry_same
geometry_send
geometry_typmod_in
geometry_typmod_out
geometry_within
geometryfromtext
geometryn
geometrytype
geomfromewkb
geomfromewkt
geomfromtext
geomfromwkb
geomunion
get_proj4_from_srid
getbbox
getsrid
gettransactionid
gidx_in
gidx_out
hasbbox
interiorringn
intersection
intersects
isclosed
isempty
isring
issimple
isvalid
isvalid_cronexpression
length
length2d
length2d_spheroid
length3d
length3d_spheroid
length_spheroid
line_interpolate_point
line_locate_point
line_substring
linefrommultipoint
linefromtext
linefromwkb
linemerge
linestringfromtext
linestringfromwkb
locate_along_measure
locate_between_measures
lockrow
log2monitor
longtransactionsenabled
m
makebox2d
makebox3d
makeline
makeline_garray
makepoint
makepointm
makepolygon
map_scale
max_distance
mem_size
memcollect
memgeomunion
mlinefromtext
mlinefromwkb
mpointfromtext
mpointfromwkb
mpolyfromtext
mpolyfromwkb
multi
multilinefromwkb
multilinestringfromtext
multipointfromtext
multipointfromwkb
multipolyfromwkb
multipolygonfromtext
ndims
next_scheduled_time
noop
npoints
nrings
numgeometries
numinteriorring
numinteriorrings
numpoints
overlaps
perimeter2d
perimeter3d
pgis_abs_in
pgis_abs_out
pgis_geometry_accum_finalfn
pgis_geometry_accum_transfn
pgis_geometry_collect_finalfn
pgis_geometry_makeline_finalfn
pgis_geometry_polygonize_finalfn
pgis_geometry_union_finalfn
point_inside_circle
pointfromtext
pointfromwkb
pointn
pointonsurface
polyfromtext
polyfromwkb
polygonfromtext
polygonfromwkb
polygonize
polygonize_garray
populate_geometry_columns
postgis_addbbox
postgis_cache_bbox
postgis_constraint_dims
postgis_constraint_srid
postgis_constraint_type
postgis_dropbbox
postgis_full_version
postgis_geos_version
postgis_getbbox
postgis_hasbbox
postgis_lib_build_date
postgis_lib_version
postgis_libjson_version
postgis_libxml_version
postgis_noop
postgis_proj_version
postgis_scripts_build_date
postgis_scripts_installed
postgis_scripts_released
postgis_svn_version
postgis_transform_geometry
postgis_type_name
postgis_typmod_dims
postgis_typmod_srid
postgis_typmod_type
postgis_version
probe_geometry_columns
raise_exception
relate
removepoint
rename_geometry_table_constraints
renamecolumnifexists
reverse
rotate
rotatex
rotatey
rotatez
safedivide
scale
se_envelopesintersect
se_is3d
se_ismeasured
se_locatealong
se_locatebetween
se_m
se_z
segmentize
setpoint
setsrid
shift_longitude
simplify
snaptogrid
spheroid_in
spheroid_out
srid
st_3dclosestpoint
st_3ddfullywithin
st_3ddistance
st_3ddwithin
st_3dextent
st_3dintersects
st_3dlength
st_3dlength_spheroid
st_3dlongestline
st_3dmakebox
st_3dmaxdistance
st_3dperimeter
st_3dshortestline
st_accum
st_addmeasure
st_addpoint
st_affine
st_area
st_area2d
st_asbinary
st_asewkb
st_asewkt
st_asgeojson
st_asgml
st_ashexewkb
st_askml
st_aslatlontext
st_assvg
st_astext
st_asx3d
st_azimuth
st_bdmpolyfromtext
st_bdpolyfromtext
st_boundary
st_box
st_box2d
st_box3d
st_box3d_in
st_box3d_out
st_buffer
st_buildarea
st_bytea
st_centroid
st_cleangeometry
st_closestpoint
st_collect
st_collectionextract
st_collectionhomogenize
st_combine_bbox
st_concavehull
st_contains
st_containsproperly
st_convexhull
st_coorddim
st_coveredby
st_covers
st_crosses
st_curvetoline
st_dfullywithin
st_difference
st_dimension
st_disjoint
st_distance
st_distance_sphere
st_distance_spheroid
st_dump
st_dumppoints
st_dumprings
st_dwithin
st_endpoint
st_envelope
st_equals
st_estimated_extent
st_expand
st_extent
st_extent3d
st_exteriorring
st_find_extent
st_flipcoordinates
st_force_2d
st_force_3d
st_force_3dm
st_force_3dz
st_force_4d
st_force_collection
st_forcerhr
st_geogfromtext
st_geogfromwkb
st_geographyfromtext
st_geohash
st_geomcollfromtext
st_geomcollfromwkb
st_geometry
st_geometry_cmp
st_geometry_eq
st_geometry_ge
st_geometry_gt
st_geometry_le
st_geometry_lt
st_geometryfromtext
st_geometryn
st_geometrytype
st_geomfromewkb
st_geomfromewkt
st_geomfromgeojson
st_geomfromgml
st_geomfromkml
st_geomfromtext
st_geomfromwkb
st_gmltosql
st_hasarc
st_hausdorffdistance
st_interiorringn
st_interpolatepoint
st_intersection
st_intersects
st_isclosed
st_iscollection
st_isempty
st_isring
st_issimple
st_isvalid
st_isvaliddetail
st_isvalidreason
st_length
st_length2d
st_length2d_spheroid
st_length3d
st_length_spheroid
st_length_spheroid3d
st_line_interpolate_point
st_line_locate_point
st_line_substring
st_linecrossingdirection
st_linefrommultipoint
st_linefromtext
st_linefromwkb
st_linemerge
st_linestringfromwkb
st_linetocurve
st_locate_along_measure
st_locate_between_measures
st_locatealong
st_locatebetween
st_locatebetweenelevations
st_longestline
st_m
st_makebox2d
st_makebox3d
st_makeenvelope
st_makeline
st_makeline_garray
st_makepoint
st_makepointm
st_makepolygon
st_makevalid
st_maxdistance
st_mem_size
st_memcollect
st_memgeomunion
st_memunion
st_minimumboundingcircle
st_mlinefromtext
st_mlinefromwkb
st_mpointfromtext
st_mpointfromwkb
st_mpolyfromtext
st_mpolyfromwkb
st_multi
st_multilinefromwkb
st_multilinestringfromtext
st_multipointfromtext
st_multipointfromwkb
st_multipolyfromwkb
st_multipolygonfromtext
st_ndims
st_node
st_npoints
st_nrings
st_numgeometries
st_numinteriorring
st_numinteriorrings
st_numpatches
st_numpoints
st_offsetcurve
st_orderingequals
st_overlaps
st_patchn
st_perimeter
st_perimeter2d
st_perimeter3d
st_point
st_point_inside_circle
st_pointfromtext
st_pointfromwkb
st_pointn
st_pointonsurface
st_polyfromtext
st_polyfromwkb
st_polygon
st_polygonfromtext
st_polygonfromwkb
st_polygonize
st_polygonize_garray
st_project
st_relate
st_relatematch
st_removepoint
st_removerepeatedpoints
st_reverse
st_rotate
st_rotatex
st_rotatey
st_rotatez
st_scale
st_segmentize
st_setpoint
st_setsrid
st_sharedpaths
st_shift_longitude
st_shortestline
st_simplify
st_simplifypreservetopology
st_snap
st_snaptogrid
st_split
st_srid
st_startpoint
st_summary
st_symdifference
st_symmetricdifference
st_text
st_touches
st_transform
st_translate
st_transscale
st_unaryunion
st_union
st_unite_garray
st_within
st_wkbtosql
st_wkttosql
st_x
st_xmax
st_xmin
st_y
st_ymax
st_ymin
st_z
st_zmax
st_zmflag
st_zmin
startpoint
streamingbbox_to_pointwkt
streamingbbox_to_wgs84centroid
streamingbbox_to_wgs84geometry
summary
symdifference
symmetricdifference
text
touches
transform
translate
transscale
uidstovalues
uidtovalue
unite_garray
unlockrows
update_simplified_vault_coverage
updategeometrysrid
within
x
xmax
xmin
y
ymax
ymin
z
zmax
zmflag
zmin

1 comment:

  1. This comment has been removed by a blog administrator.

    ReplyDelete