Functions

pggeodb.nancy.inra.fr/db_cefs - db_cefs on pggeodb.nancy.inra.fr

Functions

Schema	Function	Returns	Arguments	Owner	Language	Description
analyse	ps_analyse_geom	record	geom public.geometry, out is_null boolean, out is_valid boolean, out nb_geom integer, out nb_ring integer, out nb_points integer, out nb_geom_invalide integer, out diffsurface double precision, out nb_ring_intersect integer, out nb_ring_not_closed integer, out nb_ring_fermeture_simple integer, out nb_ring_intersect_after_fermeture_ok integer, out nb_ring_intersect_after_fermeture_douteux integer, out nb_ring_not_closed_erreur integer, out nb_geom_apres_correction integer, out nb_ring_apres_correction integer, out nb_points_apres_correction integer	albenard	plpgsql	Cette fonction analyse l'objet géométrique passé en paramètre et retourne un ensemble d'indicateurs sur la situation qualitative de cet objet : - is_null boolean précisant si l'objet est null - is_valid boolean précisant si l'objet est valide Si l'objet est invalide les indicateurs suivant sont renseignés : - nb_geom nombre de géométries de l'objet - nb_ring nombre d'anneaux présents dans l'objet - nb_points nombre de point présents dans l'objet - nb_geom_invalide nombre de géométries invalides de l'objet - diffsurface différence de surface entre la géométrie initiale et la géométrie corrigée de manière automatique - nb_ring_intersect nombre d'auto-intersection total de la géométrie. - nb_ring_not_closed nombre d'anneaux non fermés dans l'objet - nb_ring_fermeture_simple nombre d'anneaux ouverts qui peuvent être fermés sans doute sur la correction - nb_ring_intersect_after_fermeture_ok nombre d'anneaux ouverts qui peuvent être fermés sans doute sur la correction même si la fermeture a engendré un autointersection - nb_ring_intersect_after_fermeture_douteux nombre d'anneaux ouverts dont la fermeture engendre une autointersection dont le traitement est incertain (nécessite action humaine) - nb_ring_not_closed_erreur nombre d'anneaux ouverts dont la fermeture est en erreur (nécessite action humaine) - nb_geom_apres_correction nombre de géométries de l'objet corrige - nb_ring_apres_correction nombre d'anneaux présents dans l'objet corrige - nb_points_apres_correction nombre de point présents dans l'objet corrige
analyse	ps_analyse_geom_table	record	nom_table_concernee varchar, nom_cle_table varchar, nom_autre_champ varchar, nom_champ_geom varchar, out cle varchar, out autre_champ varchar, out is_null boolean, out is_valid boolean, out nb_geom integer, out nb_ring integer, out nb_points integer, out nb_geom_invalide integer, out diffsurface double precision, out nb_ring_intersect integer, out nb_ring_not_closed integer, out nb_ring_fermeture_simple integer, out nb_ring_intersect_after_fermeture_ok integer, out nb_ring_intersect_after_fermeture_douteux integer, out nb_ring_not_closed_erreur integer, out nb_geom_apres_correction integer, out nb_ring_apres_correction integer, out nb_points_apres_correction integer	albenard	plpgsql	Cette fonction effectue un listing sur la qualité d'un objet géométrique au sein d'une table complète passée comme premier paramètre. Afin que le listing soit exploitable par l'appellant elle s'appuie sur 2 parmaètres qui précise quel est le champ clé de la table (second paramètre) et éventuellement quel autre champ l'opérateur désire récupérer dans le listing (3° paramètre). L'appelant doit également préciser en 4° paramètre quel est le nom du champ qui contient l'objet géométrique à ananlyser. Chaque ligne du listing contient donc un ensemble de colonne : - clé de l'enregistment selon le paramètre en entrée. - autre champs éventuel ou null - les indicateurs qualitatifs que renseigne la fonction ps_ananlyse_geom à savoir : - nb_geom nombre de géométries de l'objet - nb_ring nombre d'anneaux présents dans l'objet - nb_points nombre de point présents dans l'objet - nb_geom_invalide nombre de géométries invalides de l'objet - diffsurface différence de surface entre la géométrie initiale et la géométrie corrigée de manière automatique - nb_ring_intersect nombre d'anneaux en auto-intersection. - nb_ring_not_closed nombre d'anneaux non fermés dans l'objet - nb_ring_fermeture_simple nombre d'anneaux ouverts qui peuvent être fermés sans doute sur la correction - nb_ring_intersect_after_fermeture_ok nombre d'anneaux ouverts qui peuvent être fermés sans doute sur la correction même si la fermeture a engendré un autointersection - nb_ring_intersect_after_fermeture_douteux nombre d'anneaux ouverts dont la fermeture engendre une autointersection dont le traitement est incertain (nécessite action humaine) - nb_ring_not_closed_erreur nombre d'anneaux ouverts dont la fermeture est en erreur (nécessite action humaine) - nb_geom_apres_correction nombre de géométries de l'objet corrige - nb_ring_apres_correction nombre d'anneaux présents dans l'objet corrige - nb_points_apres_correction nombre de point présents dans l'objet corrige
analyse	ps_analyse_geom_table_sommaire	record	nom_table_concernee varchar, nom_cle_table varchar, nom_champ_geom varchar, out libelle_sortie varchar, out nb_sortie integer	albenard	plpgsql	Cette fonction effectue un comptage sur la qualité de l'objet géométrique d'une table. Les paramètres à utiliser sont : - nom de la table concernée. - colonne contenant un identifiant au sein de la table (pour permettre le comptage) - nom de la colonne contenant les objets géométriques à ananlyser.
analyse	ps_distance_os	boolean	annee_traitement integer = 2005, tailleoffset integer = 2000	albenard	plpgsql	Cette fonction calcule la distance à certains éléments (route, bati ...) et met à jour les champs de la table t_positionnement_pos dédiés au stockage de cette information.
analyse	ps_statut_non_ferme	integer	bad_ring public.geometry	albenard	plpgsql	Cette fonction prend comme argument un objet géométrique normalement de type ST_LineString. Le cas d'usage le plus courant est un appel depuis la fonction ps_analyse_geom qui tente de fermer un anneau ouvert et s'appuie sur la présente fonction pour savoir comment s'est passée la fermeture. La fonction renvoie : 0 : La géométrie passée en paramètre ne respecte pas le type ST_LineString ou bien n'est pas une géométrie fermée. 1 : La géométrie passée en paramètre ne nécessite pas de correction (anneau simple fermé) 2 : La géométrie passée en paramètre présente une intersection qui se corrige avec un simple ajout de polygone ou trou (3 points supplémentaires) 3 : La géométrie passée en paramètre présente une intersection que Postgis corrige d'une façon appelant des vérifications et certainement une intervention.
public	__st_countagg_transfn	public.agg_count	agg public.agg_count, rast public.raster, nband integer = 1, exclude_nodata_value boolean = true, sample_percent double precision = 1	postgres	plpgsql
public	_add_overview_constraint	boolean	ovschema name, ovtable name, ovcolumn name, refschema name, reftable name, refcolumn name, factor integer	postgres	plpgsql
public	_add_raster_constraint	boolean	cn name, sql text	postgres	plpgsql
public	_add_raster_constraint_alignment	boolean	rastschema name, rasttable name, rastcolumn name	postgres	plpgsql
public	_add_raster_constraint_blocksize	boolean	rastschema name, rasttable name, rastcolumn name, axis text	postgres	plpgsql
public	_add_raster_constraint_coverage_tile	boolean	rastschema name, rasttable name, rastcolumn name	postgres	plpgsql
public	_add_raster_constraint_extent	boolean	rastschema name, rasttable name, rastcolumn name	postgres	plpgsql
public	_add_raster_constraint_nodata_values	boolean	rastschema name, rasttable name, rastcolumn name	postgres	plpgsql
public	_add_raster_constraint_num_bands	boolean	rastschema name, rasttable name, rastcolumn name	postgres	plpgsql
public	_add_raster_constraint_out_db	boolean	rastschema name, rasttable name, rastcolumn name	postgres	plpgsql
public	_add_raster_constraint_pixel_types	boolean	rastschema name, rasttable name, rastcolumn name	postgres	plpgsql
public	_add_raster_constraint_scale	boolean	rastschema name, rasttable name, rastcolumn name, axis char	postgres	plpgsql
public	_add_raster_constraint_spatially_unique	boolean	rastschema name, rasttable name, rastcolumn name	postgres	plpgsql
public	_add_raster_constraint_srid	boolean	rastschema name, rasttable name, rastcolumn name	postgres	plpgsql
public	_drop_overview_constraint	boolean	ovschema name, ovtable name, ovcolumn name	postgres	sql
public	_drop_raster_constraint	boolean	rastschema name, rasttable name, cn name	postgres	plpgsql
public	_drop_raster_constraint_alignment	boolean	rastschema name, rasttable name, rastcolumn name	postgres	sql
public	_drop_raster_constraint_blocksize	boolean	rastschema name, rasttable name, rastcolumn name, axis text	postgres	plpgsql
public	_drop_raster_constraint_coverage_tile	boolean	rastschema name, rasttable name, rastcolumn name	postgres	sql
public	_drop_raster_constraint_extent	boolean	rastschema name, rasttable name, rastcolumn name	postgres	sql
public	_drop_raster_constraint_nodata_values	boolean	rastschema name, rasttable name, rastcolumn name	postgres	sql
public	_drop_raster_constraint_num_bands	boolean	rastschema name, rasttable name, rastcolumn name	postgres	sql
public	_drop_raster_constraint_out_db	boolean	rastschema name, rasttable name, rastcolumn name	postgres	sql
public	_drop_raster_constraint_pixel_types	boolean	rastschema name, rasttable name, rastcolumn name	postgres	sql
public	_drop_raster_constraint_regular_blocking	boolean	rastschema name, rasttable name, rastcolumn name	postgres	sql
public	_drop_raster_constraint_scale	boolean	rastschema name, rasttable name, rastcolumn name, axis char	postgres	plpgsql
public	_drop_raster_constraint_spatially_unique	boolean	rastschema name, rasttable name, rastcolumn name	postgres	plpgsql
public	_drop_raster_constraint_srid	boolean	rastschema name, rasttable name, rastcolumn name	postgres	sql
public	_overview_constraint	boolean	ov public.raster, factor integer, refschema name, reftable name, refcolumn name	postgres	sql
public	_overview_constraint_info	record	ovschema name, ovtable name, ovcolumn name, out refschema name, out reftable name, out refcolumn name, out factor integer	postgres	sql
public	_postgis_deprecate	void	oldname text, newname text, version text	postgres	plpgsql
public	_postgis_join_selectivity	double precision	pg_catalog.regclass, text, pg_catalog.regclass, text, text = '2'::text	postgres	c
public	_postgis_selectivity	double precision	tbl pg_catalog.regclass, att_name text, geom public.geometry, mode text = '2'::text	postgres	c
public	_postgis_stats	text	tbl pg_catalog.regclass, att_name text, text = '2'::text	postgres	c
public	_raster_constraint_info_alignment	boolean	rastschema name, rasttable name, rastcolumn name	postgres	sql
public	_raster_constraint_info_blocksize	integer	rastschema name, rasttable name, rastcolumn name, axis text	postgres	sql
public	_raster_constraint_info_coverage_tile	boolean	rastschema name, rasttable name, rastcolumn name	postgres	sql
public	_raster_constraint_info_extent	public.geometry	rastschema name, rasttable name, rastcolumn name	postgres	sql
public	_raster_constraint_info_index	boolean	rastschema name, rasttable name, rastcolumn name	postgres	sql
public	_raster_constraint_info_nodata_values	double precision []	rastschema name, rasttable name, rastcolumn name	postgres	sql
public	_raster_constraint_info_num_bands	integer	rastschema name, rasttable name, rastcolumn name	postgres	sql
public	_raster_constraint_info_out_db	boolean []	rastschema name, rasttable name, rastcolumn name	postgres	sql
public	_raster_constraint_info_pixel_types	text []	rastschema name, rasttable name, rastcolumn name	postgres	sql
public	_raster_constraint_info_regular_blocking	boolean	rastschema name, rasttable name, rastcolumn name	postgres	plpgsql
public	_raster_constraint_info_scale	double precision	rastschema name, rasttable name, rastcolumn name, axis char	postgres	sql
public	_raster_constraint_info_spatially_unique	boolean	rastschema name, rasttable name, rastcolumn name	postgres	sql
public	_raster_constraint_info_srid	integer	rastschema name, rasttable name, rastcolumn name	postgres	sql
public	_raster_constraint_nodata_values	numeric []	rast public.raster	postgres	sql
public	_raster_constraint_out_db	boolean []	rast public.raster	postgres	sql
public	_raster_constraint_pixel_types	text []	rast public.raster	postgres	sql
public	_st_3ddfullywithin	boolean	geom1 public.geometry, geom2 public.geometry, double precision	postgres	c
public	_st_3ddwithin	boolean	geom1 public.geometry, geom2 public.geometry, double precision	postgres	c
public	_st_3dintersects	boolean	geom1 public.geometry, geom2 public.geometry	postgres	c
public	_st_asgeojson	text	integer, public.geography, integer, integer	postgres	c
public	_st_asgeojson	text	integer, public.geometry, integer, integer	postgres	sql
public	_st_asgml	text	integer, public.geography, integer, integer, text, text	postgres	c
public	_st_asgml	text	integer, public.geometry, integer, integer, text, text	postgres	c
public	_st_askml	text	integer, public.geography, integer, text	postgres	c
public	_st_askml	text	integer, public.geometry, integer, text	postgres	c
public	_st_aspect4ma	double precision	value double precision [], pos integer [], variadic userargs text [] = NULL::text[]	postgres	plpgsql
public	_st_asraster	public.raster	geom public.geometry, scalex double precision = 0, scaley double precision = 0, width integer = 0, height integer = 0, pixeltype text [] = ARRAY['8BUI'::text], value double precision [] = ARRAY[1::double precision], nodataval double precision [] = ARRAY[0::double precision], upperleftx double precision = NULL::double precision, upperlefty double precision = NULL::double precision, gridx double precision = NULL::double precision, gridy double precision = NULL::double precision, skewx double precision = 0, skewy double precision = 0, touched boolean = false	postgres	c
public	_st_asx3d	text	integer, public.geometry, integer, integer, text	postgres	c
public	_st_bestsrid	integer	public.geography	postgres	sql
public	_st_bestsrid	integer	public.geography, public.geography	postgres	c
public	_st_buffer	public.geometry	public.geometry, double precision, pg_catalog.cstring	postgres	c
public	_st_clip	public.raster	rast public.raster, nband integer [], geom public.geometry, nodataval double precision [] = NULL::double precision[], crop boolean = true	postgres	c
public	_st_colormap	public.raster	rast public.raster, nband integer, colormap text, method text = 'INTERPOLATE'::text	postgres	c
public	_st_concavehull	public.geometry	param_inputgeom public.geometry	postgres	plpgsql
public	_st_contains	boolean	geom1 public.geometry, geom2 public.geometry	postgres	c
public	_st_contains	boolean	rast1 public.raster, nband1 integer, rast2 public.raster, nband2 integer	postgres	c
public	_st_containsproperly	boolean	geom1 public.geometry, geom2 public.geometry	postgres	c
public	_st_containsproperly	boolean	rast1 public.raster, nband1 integer, rast2 public.raster, nband2 integer	postgres	c
public	_st_convertarray4ma	double precision []	value double precision []	postgres	plpgsql
public	_st_count	bigint	rast public.raster, nband integer = 1, exclude_nodata_value boolean = true, sample_percent double precision = 1	postgres	plpgsql
public	_st_count	bigint	rastertable text, rastercolumn text, nband integer = 1, exclude_nodata_value boolean = true, sample_percent double precision = 1	postgres	plpgsql
public	_st_countagg_finalfn	bigint	agg public.agg_count	postgres	plpgsql
public	_st_countagg_transfn	public.agg_count	agg public.agg_count, rast public.raster, exclude_nodata_value boolean	postgres	plpgsql
public	_st_countagg_transfn	public.agg_count	agg public.agg_count, rast public.raster, nband integer, exclude_nodata_value boolean	postgres	plpgsql
public	_st_countagg_transfn	public.agg_count	agg public.agg_count, rast public.raster, nband integer, exclude_nodata_value boolean, sample_percent double precision	postgres	plpgsql
public	_st_coveredby	boolean	geom1 public.geometry, geom2 public.geometry	postgres	c
public	_st_coveredby	boolean	rast1 public.raster, nband1 integer, rast2 public.raster, nband2 integer	postgres	c
public	_st_covers	boolean	geom1 public.geometry, geom2 public.geometry	postgres	c
public	_st_covers	boolean	public.geography, public.geography	postgres	c
public	_st_covers	boolean	rast1 public.raster, nband1 integer, rast2 public.raster, nband2 integer	postgres	c
public	_st_crosses	boolean	geom1 public.geometry, geom2 public.geometry	postgres	c
public	_st_dfullywithin	boolean	geom1 public.geometry, geom2 public.geometry, double precision	postgres	c
public	_st_dfullywithin	boolean	rast1 public.raster, nband1 integer, rast2 public.raster, nband2 integer, distance double precision	postgres	c
public	_st_distance	double precision	public.geography, public.geography, double precision, boolean	postgres	c
public	_st_distancetree	double precision	public.geography, public.geography	postgres	sql
public	_st_distancetree	double precision	public.geography, public.geography, double precision, boolean	postgres	c
public	_st_distanceuncached	double precision	public.geography, public.geography	postgres	sql
public	_st_distanceuncached	double precision	public.geography, public.geography, boolean	postgres	sql
public	_st_distanceuncached	double precision	public.geography, public.geography, double precision, boolean	postgres	c
public	_st_dumppoints	public.geometry_dump	the_geom public.geometry, cur_path integer []	postgres	plpgsql
public	_st_dwithin	boolean	geom1 public.geometry, geom2 public.geometry, double precision	postgres	c
public	_st_dwithin	boolean	public.geography, public.geography, double precision, boolean	postgres	c
public	_st_dwithin	boolean	rast1 public.raster, nband1 integer, rast2 public.raster, nband2 integer, distance double precision	postgres	c
public	_st_dwithinuncached	boolean	public.geography, public.geography, double precision	postgres	sql
public	_st_dwithinuncached	boolean	public.geography, public.geography, double precision, boolean	postgres	c
public	_st_equals	boolean	geom1 public.geometry, geom2 public.geometry	postgres	c
public	_st_expand	public.geography	public.geography, double precision	postgres	c
public	_st_gdalwarp	public.raster	rast public.raster, algorithm text = 'NearestNeighbour'::text, maxerr double precision = 0.125, srid integer = NULL::integer, scalex double precision = 0, scaley double precision = 0, gridx double precision = NULL::double precision, gridy double precision = NULL::double precision, skewx double precision = 0, skewy double precision = 0, width integer = NULL::integer, height integer = NULL::integer	postgres	c
public	_st_geomfromgml	public.geometry	text, integer	postgres	c
public	_st_hillshade4ma	double precision	value double precision [], pos integer [], variadic userargs text [] = NULL::text[]	postgres	plpgsql
public	_st_histogram	record	rast public.raster, nband integer = 1, exclude_nodata_value boolean = true, sample_percent double precision = 1, bins integer = 0, width double precision [] = NULL::double precision[], right boolean = false, min double precision = NULL::double precision, max double precision = NULL::double precision, out min double precision, out max double precision, out count bigint, out percent double precision	postgres	c
public	_st_histogram	record	rastertable text, rastercolumn text, nband integer = 1, exclude_nodata_value boolean = true, sample_percent double precision = 1, bins integer = 0, width double precision [] = NULL::double precision[], right boolean = false, out min double precision, out max double precision, out count bigint, out percent double precision	postgres	c
public	_st_intersects	boolean	geom public.geometry, rast public.raster, nband integer = NULL::integer	postgres	plpgsql
public	_st_intersects	boolean	geom1 public.geometry, geom2 public.geometry	postgres	c
public	_st_intersects	boolean	rast1 public.raster, nband1 integer, rast2 public.raster, nband2 integer	postgres	c
public	_st_linecrossingdirection	integer	geom1 public.geometry, geom2 public.geometry	postgres	c
public	_st_longestline	public.geometry	geom1 public.geometry, geom2 public.geometry	postgres	c
public	_st_mapalgebra	public.raster	rastbandargset public.rastbandarg [], callbackfunc pg_catalog.regprocedure, pixeltype text = NULL::text, distancex integer = 0, distancey integer = 0, extenttype text = 'INTERSECTION'::text, customextent public.raster = NULL::raster, mask double precision [] = NULL::double precision[], weighted boolean = NULL::boolean, variadic userargs text [] = NULL::text[]	postgres	c
public	_st_mapalgebra	public.raster	rastbandargset public.rastbandarg [], expression text, pixeltype text = NULL::text, extenttype text = 'INTERSECTION'::text, nodata1expr text = NULL::text, nodata2expr text = NULL::text, nodatanodataval double precision = NULL::double precision	postgres	c
public	_st_maxdistance	double precision	geom1 public.geometry, geom2 public.geometry	postgres	c
public	_st_neighborhood	double precision []	rast public.raster, band integer, columnx integer, rowy integer, distancex integer, distancey integer, exclude_nodata_value boolean = true	postgres	c
public	_st_orderingequals	boolean	geometrya public.geometry, geometryb public.geometry	postgres	c
public	_st_overlaps	boolean	geom1 public.geometry, geom2 public.geometry	postgres	c
public	_st_overlaps	boolean	rast1 public.raster, nband1 integer, rast2 public.raster, nband2 integer	postgres	c
public	_st_pixelaspolygons	record	rast public.raster, band integer = 1, columnx integer = NULL::integer, rowy integer = NULL::integer, exclude_nodata_value boolean = true, out geom public.geometry, out val double precision, out x integer, out y integer	postgres	c
public	_st_pointoutside	public.geography	public.geography	postgres	c
public	_st_quantile	record	rast public.raster, nband integer = 1, exclude_nodata_value boolean = true, sample_percent double precision = 1, quantiles double precision [] = NULL::double precision[], out quantile double precision, out value double precision	postgres	c
public	_st_quantile	record	rastertable text, rastercolumn text, nband integer = 1, exclude_nodata_value boolean = true, sample_percent double precision = 1, quantiles double precision [] = NULL::double precision[], out quantile double precision, out value double precision	postgres	c
public	_st_rastertoworldcoord	record	rast public.raster, columnx integer = NULL::integer, rowy integer = NULL::integer, out longitude double precision, out latitude double precision	postgres	c
public	_st_reclass	public.raster	rast public.raster, variadic reclassargset public.reclassarg []	postgres	c
public	_st_roughness4ma	double precision	value double precision [], pos integer [], variadic userargs text [] = NULL::text[]	postgres	plpgsql
public	_st_samealignment_finalfn	boolean	agg public.agg_samealignment	postgres	sql
public	_st_samealignment_transfn	public.agg_samealignment	agg public.agg_samealignment, rast public.raster	postgres	plpgsql
public	_st_setvalues	public.raster	rast public.raster, nband integer, x integer, y integer, newvalueset double precision [], noset boolean [] = NULL::boolean[], hasnosetvalue boolean = false, nosetvalue double precision = NULL::double precision, keepnodata boolean = false	postgres	c
public	_st_slope4ma	double precision	value double precision [], pos integer [], variadic userargs text [] = NULL::text[]	postgres	plpgsql
public	_st_summarystats	public.summarystats	rast public.raster, nband integer = 1, exclude_nodata_value boolean = true, sample_percent double precision = 1	postgres	c
public	_st_summarystats	public.summarystats	rastertable text, rastercolumn text, nband integer = 1, exclude_nodata_value boolean = true, sample_percent double precision = 1	postgres	plpgsql
public	_st_summarystats_finalfn	public.summarystats	pg_catalog.internal	postgres	c
public	_st_summarystats_transfn	pg_catalog.internal	pg_catalog.internal, public.raster, boolean, double precision	postgres	c
public	_st_summarystats_transfn	pg_catalog.internal	pg_catalog.internal, public.raster, integer, boolean	postgres	c
public	_st_summarystats_transfn	pg_catalog.internal	pg_catalog.internal, public.raster, integer, boolean, double precision	postgres	c
public	_st_tile	public.raster	rast public.raster, width integer, height integer, nband integer [] = NULL::integer[], padwithnodata boolean = false, nodataval double precision = NULL::double precision	postgres	c
public	_st_touches	boolean	geom1 public.geometry, geom2 public.geometry	postgres	c
public	_st_touches	boolean	rast1 public.raster, nband1 integer, rast2 public.raster, nband2 integer	postgres	c
public	_st_tpi4ma	double precision	value double precision [], pos integer [], variadic userargs text [] = NULL::text[]	postgres	plpgsql
public	_st_tri4ma	double precision	value double precision [], pos integer [], variadic userargs text [] = NULL::text[]	postgres	plpgsql
public	_st_union_finalfn	public.raster	pg_catalog.internal	postgres	c
public	_st_union_transfn	pg_catalog.internal	pg_catalog.internal, public.raster	postgres	c
public	_st_union_transfn	pg_catalog.internal	pg_catalog.internal, public.raster, integer	postgres	c
public	_st_union_transfn	pg_catalog.internal	pg_catalog.internal, public.raster, integer, text	postgres	c
public	_st_union_transfn	pg_catalog.internal	pg_catalog.internal, public.raster, public.unionarg []	postgres	c
public	_st_union_transfn	pg_catalog.internal	pg_catalog.internal, public.raster, text	postgres	c
public	_st_valuecount	record	rast public.raster, nband integer = 1, exclude_nodata_value boolean = true, searchvalues double precision [] = NULL::double precision[], roundto double precision = 0, out value double precision, out count integer, out percent double precision	postgres	c
public	_st_valuecount	record	rastertable text, rastercolumn text, nband integer = 1, exclude_nodata_value boolean = true, searchvalues double precision [] = NULL::double precision[], roundto double precision = 0, out value double precision, out count integer, out percent double precision	postgres	c
public	_st_within	boolean	geom1 public.geometry, geom2 public.geometry	postgres	sql
public	_st_within	boolean	rast1 public.raster, nband1 integer, rast2 public.raster, nband2 integer	postgres	sql
public	_st_worldtorastercoord	record	rast public.raster, longitude double precision = NULL::double precision, latitude double precision = NULL::double precision, out columnx integer, out rowy integer	postgres	c
public	_updaterastersrid	boolean	schema_name name, table_name name, column_name name, new_srid integer	postgres	plpgsql
public	addauth	boolean	text	postgres	plpgsql	args: auth_token - Add an authorization token to be used in current transaction.
public	addgeometrycolumn	text	catalog_name varchar, schema_name varchar, table_name varchar, column_name varchar, new_srid_in integer, new_type varchar, new_dim integer, use_typmod boolean = true	postgres	plpgsql	args: catalog_name, schema_name, table_name, column_name, srid, type, dimension, use_typmod=true - 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 constraint based behavior
public	addgeometrycolumn	text	schema_name varchar, table_name varchar, column_name varchar, new_srid integer, new_type varchar, new_dim integer, use_typmod boolean = true	postgres	plpgsql	args: schema_name, table_name, column_name, srid, type, dimension, use_typmod=true - 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 constraint based behavior
public	addgeometrycolumn	text	table_name varchar, column_name varchar, new_srid integer, new_type varchar, new_dim integer, use_typmod boolean = true	postgres	plpgsql	args: table_name, column_name, srid, type, dimension, use_typmod=true - 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 constraint based behavior
public	addoverviewconstraints	boolean	ovschema name, ovtable name, ovcolumn name, refschema name, reftable name, refcolumn name, ovfactor integer	postgres	plpgsql	args: ovschema, ovtable, ovcolumn, refschema, reftable, refcolumn, ovfactor - Tag a raster column as being an overview of another.
public	addoverviewconstraints	boolean	ovtable name, ovcolumn name, reftable name, refcolumn name, ovfactor integer	postgres	sql	args: ovtable, ovcolumn, reftable, refcolumn, ovfactor - Tag a raster column as being an overview of another.
public	addrasterconstraints	boolean	rastschema name, rasttable name, rastcolumn name, srid boolean = true, scale_x boolean = true, scale_y boolean = true, blocksize_x boolean = true, blocksize_y boolean = true, same_alignment boolean = true, regular_blocking boolean = false, num_bands boolean = true, pixel_types boolean = true, nodata_values boolean = true, out_db boolean = true, extent boolean = true	postgres	plpgsql	args: rastschema, rasttable, rastcolumn, srid=true, scale_x=true, scale_y=true, blocksize_x=true, blocksize_y=true, same_alignment=true, regular_blocking=false, num_bands=true, pixel_types=true, nodata_values=true, out_db=true, extent=true - 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.
public	addrasterconstraints	boolean	rastschema name, rasttable name, rastcolumn name, variadic constraints text []	postgres	plpgsql	args: rastschema, rasttable, rastcolumn, VARIADIC constraints - 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.
public	addrasterconstraints	boolean	rasttable name, rastcolumn name, srid boolean = true, scale_x boolean = true, scale_y boolean = true, blocksize_x boolean = true, blocksize_y boolean = true, same_alignment boolean = true, regular_blocking boolean = false, num_bands boolean = true, pixel_types boolean = true, nodata_values boolean = true, out_db boolean = true, extent boolean = true	postgres	sql	args: rasttable, rastcolumn, srid, scale_x, scale_y, blocksize_x, blocksize_y, same_alignment, regular_blocking, num_bands=true, pixel_types=true, nodata_values=true, out_db=true, extent=true - 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.
public	addrasterconstraints	boolean	rasttable name, rastcolumn name, variadic constraints text []	postgres	sql	args: rasttable, rastcolumn, VARIADIC constraints - 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.
public	box2df_in	public.box2df	pg_catalog.cstring	postgres	c
public	box2df_out	pg_catalog.cstring	public.box2df	postgres	c
public	box3d	public.box3d	public.raster	postgres	sql
public	bytea	bytea	public.geography	postgres	c
public	bytea	bytea	public.raster	postgres	c
public	checkauth	integer	text, text	postgres	sql	args: a_table_name, a_key_column_name - Creates trigger on a table to prevent/allow updates and deletes of rows based on authorization token.
public	checkauth	integer	text, text, text	postgres	plpgsql	args: a_schema_name, a_table_name, a_key_column_name - Creates trigger on a table to prevent/allow updates and deletes of rows based on authorization token.
public	checkauthtrigger	trigger		postgres	c
public	disablelongtransactions	text		postgres	plpgsql	Disable long transaction support. This function removes the long transaction support metadata tables, and drops all triggers attached to lock-checked tables.
public	dropgeometrycolumn	text	catalog_name varchar, schema_name varchar, table_name varchar, column_name varchar	postgres	plpgsql	args: catalog_name, schema_name, table_name, column_name - Removes a geometry column from a spatial table.
public	dropgeometrycolumn	text	schema_name varchar, table_name varchar, column_name varchar	postgres	plpgsql	args: schema_name, table_name, column_name - Removes a geometry column from a spatial table.
public	dropgeometrycolumn	text	table_name varchar, column_name varchar	postgres	plpgsql	args: table_name, column_name - Removes a geometry column from a spatial table.
public	dropgeometrytable	text	catalog_name varchar, schema_name varchar, table_name varchar	postgres	plpgsql	args: catalog_name, schema_name, table_name - Drops a table and all its references in geometry_columns.
public	dropgeometrytable	text	schema_name varchar, table_name varchar	postgres	sql	args: schema_name, table_name - Drops a table and all its references in geometry_columns.
public	dropgeometrytable	text	table_name varchar	postgres	sql	args: table_name - Drops a table and all its references in geometry_columns.
public	dropoverviewconstraints	boolean	ovschema name, ovtable name, ovcolumn name	postgres	plpgsql	args: ovschema, ovtable, ovcolumn - Untag a raster column from being an overview of another.
public	dropoverviewconstraints	boolean	ovtable name, ovcolumn name	postgres	sql	args: ovtable, ovcolumn - Untag a raster column from being an overview of another.
public	droprasterconstraints	boolean	rastschema name, rasttable name, rastcolumn name, srid boolean = true, scale_x boolean = true, scale_y boolean = true, blocksize_x boolean = true, blocksize_y boolean = true, same_alignment boolean = true, regular_blocking boolean = true, num_bands boolean = true, pixel_types boolean = true, nodata_values boolean = true, out_db boolean = true, extent boolean = true	postgres	plpgsql	args: rastschema, rasttable, rastcolumn, srid=true, scale_x=true, scale_y=true, blocksize_x=true, blocksize_y=true, same_alignment=true, regular_blocking=false, num_bands=true, pixel_types=true, nodata_values=true, out_db=true, extent=true - Drops PostGIS raster constraints that refer to a raster table column. Useful if you need to reload data or update your raster column data.
public	droprasterconstraints	boolean	rastschema name, rasttable name, rastcolumn name, variadic constraints text []	postgres	plpgsql	args: rastschema, rasttable, rastcolumn, constraints - Drops PostGIS raster constraints that refer to a raster table column. Useful if you need to reload data or update your raster column data.
public	droprasterconstraints	boolean	rasttable name, rastcolumn name, srid boolean = true, scale_x boolean = true, scale_y boolean = true, blocksize_x boolean = true, blocksize_y boolean = true, same_alignment boolean = true, regular_blocking boolean = true, num_bands boolean = true, pixel_types boolean = true, nodata_values boolean = true, out_db boolean = true, extent boolean = true	postgres	sql	args: rasttable, rastcolumn, srid, scale_x, scale_y, blocksize_x, blocksize_y, same_alignment, regular_blocking, num_bands=true, pixel_types=true, nodata_values=true, out_db=true, extent=true - Drops PostGIS raster constraints that refer to a raster table column. Useful if you need to reload data or update your raster column data.
public	droprasterconstraints	boolean	rasttable name, rastcolumn name, variadic constraints text []	postgres	sql
public	enablelongtransactions	text		postgres	plpgsql	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.
public	equals	boolean	geom1 public.geometry, geom2 public.geometry	postgres	c
public	geography	public.geography	bytea	postgres	c
public	geography	public.geography	public.geography, integer, boolean	postgres	c
public	geography	public.geography	public.geometry	postgres	c
public	geography_analyze	boolean	pg_catalog.internal	postgres	c
public	geography_cmp	integer	public.geography, public.geography	postgres	c
public	geography_distance_knn	double precision	public.geography, public.geography	postgres	c
public	geography_eq	boolean	public.geography, public.geography	postgres	c
public	geography_ge	boolean	public.geography, public.geography	postgres	c
public	geography_gist_compress	pg_catalog.internal	pg_catalog.internal	postgres	c
public	geography_gist_consistent	boolean	pg_catalog.internal, public.geography, integer	postgres	c
public	geography_gist_decompress	pg_catalog.internal	pg_catalog.internal	postgres	c
public	geography_gist_distance	double precision	pg_catalog.internal, public.geography, integer	postgres	c
public	geography_gist_penalty	pg_catalog.internal	pg_catalog.internal, pg_catalog.internal, pg_catalog.internal	postgres	c
public	geography_gist_picksplit	pg_catalog.internal	pg_catalog.internal, pg_catalog.internal	postgres	c
public	geography_gist_same	pg_catalog.internal	public.box2d, public.box2d, pg_catalog.internal	postgres	c
public	geography_gist_union	pg_catalog.internal	bytea, pg_catalog.internal	postgres	c
public	geography_gt	boolean	public.geography, public.geography	postgres	c
public	geography_in	public.geography	pg_catalog.cstring, oid, integer	postgres	c
public	geography_le	boolean	public.geography, public.geography	postgres	c
public	geography_lt	boolean	public.geography, public.geography	postgres	c
public	geography_out	pg_catalog.cstring	public.geography	postgres	c
public	geography_overlaps	boolean	public.geography, public.geography	postgres	c
public	geography_recv	public.geography	pg_catalog.internal, oid, integer	postgres	c
public	geography_send	bytea	public.geography	postgres	c
public	geography_typmod_in	integer	pg_catalog.cstring []	postgres	c
public	geography_typmod_out	pg_catalog.cstring	integer	postgres	c
public	geometry	public.geometry	path	postgres	c
public	geometry	public.geometry	point	postgres	c
public	geometry	public.geometry	polygon	postgres	c
public	geometry	public.geometry	public.geography	postgres	c
public	geometry	public.geometry	public.geometry, integer, boolean	postgres	c
public	geometry_above	boolean	geom1 public.geometry, geom2 public.geometry	postgres	c
public	geometry_below	boolean	geom1 public.geometry, geom2 public.geometry	postgres	c
public	geometry_cmp	integer	geom1 public.geometry, geom2 public.geometry	postgres	c
public	geometry_contained_by_raster	boolean	public.geometry, public.raster	postgres	sql
public	geometry_contains	boolean	geom1 public.geometry, geom2 public.geometry	postgres	c
public	geometry_distance_box	double precision	geom1 public.geometry, geom2 public.geometry	postgres	c
public	geometry_distance_centroid	double precision	geom1 public.geometry, geom2 public.geometry	postgres	c
public	geometry_distance_centroid_nd	double precision	public.geometry, public.geometry	postgres	c
public	geometry_distance_cpa	double precision	public.geometry, public.geometry	postgres	c
public	geometry_eq	boolean	geom1 public.geometry, geom2 public.geometry	postgres	c
public	geometry_ge	boolean	geom1 public.geometry, geom2 public.geometry	postgres	c
public	geometry_gist_compress_2d	pg_catalog.internal	pg_catalog.internal	postgres	c
public	geometry_gist_compress_nd	pg_catalog.internal	pg_catalog.internal	postgres	c
public	geometry_gist_consistent_2d	boolean	pg_catalog.internal, public.geometry, integer	postgres	c
public	geometry_gist_consistent_nd	boolean	pg_catalog.internal, public.geometry, integer	postgres	c
public	geometry_gist_decompress_2d	pg_catalog.internal	pg_catalog.internal	postgres	c
public	geometry_gist_decompress_nd	pg_catalog.internal	pg_catalog.internal	postgres	c
public	geometry_gist_distance_2d	double precision	pg_catalog.internal, public.geometry, integer	postgres	c
public	geometry_gist_distance_nd	double precision	pg_catalog.internal, public.geometry, integer	postgres	c
public	geometry_gist_penalty_2d	pg_catalog.internal	pg_catalog.internal, pg_catalog.internal, pg_catalog.internal	postgres	c
public	geometry_gist_penalty_nd	pg_catalog.internal	pg_catalog.internal, pg_catalog.internal, pg_catalog.internal	postgres	c
public	geometry_gist_picksplit_2d	pg_catalog.internal	pg_catalog.internal, pg_catalog.internal	postgres	c
public	geometry_gist_picksplit_nd	pg_catalog.internal	pg_catalog.internal, pg_catalog.internal	postgres	c
public	geometry_gist_same_2d	pg_catalog.internal	geom1 public.geometry, geom2 public.geometry, pg_catalog.internal	postgres	c
public	geometry_gist_same_nd	pg_catalog.internal	public.geometry, public.geometry, pg_catalog.internal	postgres	c
public	geometry_gist_union_2d	pg_catalog.internal	bytea, pg_catalog.internal	postgres	c
public	geometry_gist_union_nd	pg_catalog.internal	bytea, pg_catalog.internal	postgres	c
public	geometry_gt	boolean	geom1 public.geometry, geom2 public.geometry	postgres	c
public	geometry_le	boolean	geom1 public.geometry, geom2 public.geometry	postgres	c
public	geometry_left	boolean	geom1 public.geometry, geom2 public.geometry	postgres	c
public	geometry_lt	boolean	geom1 public.geometry, geom2 public.geometry	postgres	c
public	geometry_overabove	boolean	geom1 public.geometry, geom2 public.geometry	postgres	c
public	geometry_overbelow	boolean	geom1 public.geometry, geom2 public.geometry	postgres	c
public	geometry_overlaps	boolean	geom1 public.geometry, geom2 public.geometry	postgres	c
public	geometry_overlaps_nd	boolean	public.geometry, public.geometry	postgres	c
public	geometry_overleft	boolean	geom1 public.geometry, geom2 public.geometry	postgres	c
public	geometry_overright	boolean	geom1 public.geometry, geom2 public.geometry	postgres	c
public	geometry_raster_contain	boolean	public.geometry, public.raster	postgres	sql
public	geometry_raster_overlap	boolean	public.geometry, public.raster	postgres	sql
public	geometry_right	boolean	geom1 public.geometry, geom2 public.geometry	postgres	c
public	geometry_same	boolean	geom1 public.geometry, geom2 public.geometry	postgres	c
public	geometry_typmod_in	integer	pg_catalog.cstring []	postgres	c
public	geometry_typmod_out	pg_catalog.cstring	integer	postgres	c
public	geometry_within	boolean	geom1 public.geometry, geom2 public.geometry	postgres	c
public	geometrytype	text	public.geography	postgres	c
public	gettransactionid	pg_catalog.xid		postgres	c
public	gidx_in	public.gidx	pg_catalog.cstring	postgres	c
public	gidx_out	pg_catalog.cstring	public.gidx	postgres	c
public	gserialized_gist_joinsel_2d	double precision	pg_catalog.internal, oid, pg_catalog.internal, smallint	postgres	c
public	gserialized_gist_joinsel_nd	double precision	pg_catalog.internal, oid, pg_catalog.internal, smallint	postgres	c
public	gserialized_gist_sel_2d	double precision	pg_catalog.internal, oid, pg_catalog.internal, integer	postgres	c
public	gserialized_gist_sel_nd	double precision	pg_catalog.internal, oid, pg_catalog.internal, integer	postgres	c
public	lockrow	integer	text, text, text	postgres	sql	args: a_table_name, a_row_key, an_auth_token - Set lock/authorization for specific row in table
public	lockrow	integer	text, text, text, text	postgres	sql
public	lockrow	integer	text, text, text, text, timestamp	postgres	plpgsql	args: a_schema_name, a_table_name, a_row_key, an_auth_token, expire_dt - Set lock/authorization for specific row in table
public	lockrow	integer	text, text, text, timestamp	postgres	sql	args: a_table_name, a_row_key, an_auth_token, expire_dt - Set lock/authorization for specific row in table
public	longtransactionsenabled	boolean		postgres	plpgsql
public	path	path	public.geometry	postgres	c
public	pgis_abs_in	public.pgis_abs	pg_catalog.cstring	postgres	c
public	pgis_abs_out	pg_catalog.cstring	public.pgis_abs	postgres	c
public	pgis_geometry_accum_finalfn	public.geometry []	public.pgis_abs	postgres	c
public	pgis_geometry_accum_transfn	public.pgis_abs	public.pgis_abs, public.geometry	postgres	c
public	pgis_geometry_accum_transfn	public.pgis_abs	public.pgis_abs, public.geometry, double precision	postgres	c
public	pgis_geometry_clusterintersecting_finalfn	public.geometry []	public.pgis_abs	postgres	c
public	pgis_geometry_clusterwithin_finalfn	public.geometry []	public.pgis_abs	postgres	c
public	pgis_geometry_collect_finalfn	public.geometry	public.pgis_abs	postgres	c
public	pgis_geometry_makeline_finalfn	public.geometry	public.pgis_abs	postgres	c
public	pgis_geometry_polygonize_finalfn	public.geometry	public.pgis_abs	postgres	c
public	pgis_geometry_union_finalfn	public.geometry	public.pgis_abs	postgres	c
public	point	point	public.geometry	postgres	c
public	polygon	polygon	public.geometry	postgres	c
public	populate_geometry_columns	integer	tbl_oid oid, use_typmod boolean = true	postgres	plpgsql	args: relation_oid, use_typmod=true - 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
public	populate_geometry_columns	text	use_typmod boolean = true	postgres	plpgsql	args: use_typmod=true - 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
public	postgis_addbbox	public.geometry	public.geometry	postgres	c	args: geomA - Add bounding box to the geometry.
public	postgis_cache_bbox	trigger		postgres	c
public	postgis_constraint_dims	integer	geomschema text, geomtable text, geomcolumn text	postgres	sql
public	postgis_constraint_srid	integer	geomschema text, geomtable text, geomcolumn text	postgres	sql
public	postgis_constraint_type	varchar	geomschema text, geomtable text, geomcolumn text	postgres	sql
public	postgis_dropbbox	public.geometry	public.geometry	postgres	c	args: geomA - Drop the bounding box cache from the geometry.
public	postgis_gdal_version	text		postgres	c	Reports the version of the GDAL library in use by PostGIS.
public	postgis_getbbox	public.box2d	public.geometry	postgres	c
public	postgis_hasbbox	boolean	public.geometry	postgres	c	args: geomA - Returns TRUE if the bbox of this geometry is cached, FALSE otherwise.
public	postgis_libjson_version	text		postgres	c
public	postgis_liblwgeom_version	text		postgres	c
public	postgis_libxml_version	text		postgres	c	Returns the version number of the libxml2 library.
public	postgis_noop	public.geometry	public.geometry	postgres	c
public	postgis_noop	public.geometry	public.raster	postgres	c
public	postgis_raster_lib_build_date	text		postgres	c	Reports full raster library build date.
public	postgis_raster_lib_version	text		postgres	c	Reports full raster version and build configuration infos.
public	postgis_raster_scripts_installed	text		postgres	sql
public	postgis_svn_version	text		postgres	c
public	postgis_transform_geometry	public.geometry	public.geometry, text, text, integer	postgres	c
public	postgis_type_name	varchar	geomname varchar, coord_dimension integer, use_new_name boolean = true	postgres	sql
public	postgis_typmod_dims	integer	integer	postgres	c
public	postgis_typmod_srid	integer	integer	postgres	c
public	postgis_typmod_type	text	integer	postgres	c
public	ps_animal_synonyme	boolean	animal_officiel varchar, animal_synonyme varchar	albenard	plpgsql	Cette procédure stockée permet de remplacer un animal et ses données associées par un autre animal.
public	ps_maj_indic_cpos	integer	annee_suivi integer, tolerance_nb_min integer = 4	postgres	plpgsql	Fonction de positionnnement des indicateurs de suivi des campagnes de positionnement
public	ps_maj_indic_cpos_finish	integer	annee_suivi integer, nb_mini_camp10min integer = 45, nb_mini_camp1heure integer = 20	postgres	plpgsql	Fonction de positionnnement final (après un premier passage) des indicateurs de suivi des campagnes de positionnement
public	ps_normalise_interval	integer	interval_param interval	postgres	plpgsql	Procédure qui retourne une valeur normalisée représentant un nombre de minutes pour l'intervalle passé en paramètre.
public	ps_suivi1h	boolean	pheure time, ptolerance integer	postgres	plpgsql	Function renvoyant vrai si le paramètre pheure correspond à un suivi 1 heure (toutes les heures pleines de la journée) avec la précision de ptolerance (second paramètre) minute
public	ps_suivi3h	boolean	pheure time, ptolerance integer	postgres	plpgsql	Function renvoyant vrai si le paramètre pheure correspond à un suivi 3 heures (0,3,6,9,12,15,18,21 heure) avec la précision de ptolerance (second paramètre) minute
public	ps_suivi4h	boolean	pheure time, ptolerance integer	postgres	plpgsql	Function renvoyant vrai si le paramètre pheure correspond à un suivi 4 heures (0,4,8,12,16,20 heure) avec la précision de ptolerance (second paramètre) minute
public	ps_suivi6h	boolean	pheure time, ptolerance integer	postgres	plpgsql	Function renvoyant vrai si le paramètre pheure correspond à un suivi 6 heures (0,6,12,18 heure) avec la précision de ptolerance (second paramètre) minute
public	ps_suppression_data_animal_campagne	boolean	animal_concerne varchar, campagne integer	albenard	plpgsql	Cette procédure stockée permet de supprimer les données de positionnement et/ou d'activité pour un animal pour une année de suivi définie.
public	raster_above	boolean	public.raster, public.raster	postgres	sql
public	raster_below	boolean	public.raster, public.raster	postgres	sql
public	raster_contain	boolean	public.raster, public.raster	postgres	sql
public	raster_contained	boolean	public.raster, public.raster	postgres	sql
public	raster_contained_by_geometry	boolean	public.raster, public.geometry	postgres	sql
public	raster_eq	boolean	public.raster, public.raster	postgres	sql
public	raster_geometry_contain	boolean	public.raster, public.geometry	postgres	sql
public	raster_geometry_overlap	boolean	public.raster, public.geometry	postgres	sql
public	raster_hash	integer	public.raster	postgres	internal
public	raster_in	public.raster	pg_catalog.cstring	postgres	c
public	raster_left	boolean	public.raster, public.raster	postgres	sql
public	raster_out	pg_catalog.cstring	public.raster	postgres	c
public	raster_overabove	boolean	public.raster, public.raster	postgres	sql
public	raster_overbelow	boolean	public.raster, public.raster	postgres	sql
public	raster_overlap	boolean	public.raster, public.raster	postgres	sql
public	raster_overleft	boolean	public.raster, public.raster	postgres	sql
public	raster_overright	boolean	public.raster, public.raster	postgres	sql
public	raster_right	boolean	public.raster, public.raster	postgres	sql
public	raster_same	boolean	public.raster, public.raster	postgres	sql
public	st_3dclosestpoint	public.geometry	geom1 public.geometry, geom2 public.geometry	postgres	c	args: g1, g2 - Returns the 3-dimensional point on g1 that is closest to g2. This is the first point of the 3D shortest line.
public	st_3ddfullywithin	boolean	geom1 public.geometry, geom2 public.geometry, double precision	postgres	sql	args: g1, g2, distance - Returns true if all of the 3D geometries are within the specified distance of one another.
public	st_3ddistance	double precision	geom1 public.geometry, geom2 public.geometry	postgres	c	args: g1, g2 - For geometry type Returns the 3-dimensional cartesian minimum distance (based on spatial ref) between two geometries in projected units.
public	st_3ddwithin	boolean	geom1 public.geometry, geom2 public.geometry, double precision	postgres	sql	args: g1, g2, distance_of_srid - For 3d (z) geometry type Returns true if two geometries 3d distance is within number of units.
public	st_3dintersects	boolean	geom1 public.geometry, geom2 public.geometry	postgres	sql	args: geomA, geomB - Returns TRUE if the Geometries "spatially intersect" in 3d - only for points, linestrings, polygons, polyhedral surface (area). With SFCGAL backend enabled also supports TINS
public	st_3dlength	double precision	public.geometry	postgres	c	args: a_3dlinestring - Returns the 3-dimensional or 2-dimensional length of the geometry if it is a linestring or multi-linestring.
public	st_3dlength_spheroid	double precision	public.geometry, public.spheroid	postgres	sql
public	st_3dlongestline	public.geometry	geom1 public.geometry, geom2 public.geometry	postgres	c	args: g1, g2 - Returns the 3-dimensional longest line between two geometries
public	st_3dmakebox	public.box3d	geom1 public.geometry, geom2 public.geometry	postgres	c	args: point3DLowLeftBottom, point3DUpRightTop - Creates a BOX3D defined by the given 3d point geometries.
public	st_3dmaxdistance	double precision	geom1 public.geometry, geom2 public.geometry	postgres	c	args: g1, g2 - For geometry type Returns the 3-dimensional cartesian maximum distance (based on spatial ref) between two geometries in projected units.
public	st_3dperimeter	double precision	public.geometry	postgres	c	args: geomA - Returns the 3-dimensional perimeter of the geometry, if it is a polygon or multi-polygon.
public	st_3dshortestline	public.geometry	geom1 public.geometry, geom2 public.geometry	postgres	c	args: g1, g2 - Returns the 3-dimensional shortest line between two geometries
public	st_addband	public.raster	rast public.raster, addbandargset public.addbandarg []	postgres	c	args: rast, addbandargset - 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.
public	st_addband	public.raster	rast public.raster, index integer, outdbfile text, outdbindex integer [], nodataval double precision = NULL::double precision	postgres	c	args: rast, index, outdbfile, outdbindex, nodataval=NULL - 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.
public	st_addband	public.raster	rast public.raster, index integer, pixeltype text, initialvalue double precision = '0'::numeric, nodataval double precision = NULL::double precision	postgres	sql	args: rast, index, pixeltype, initialvalue=0, nodataval=NULL - 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.
public	st_addband	public.raster	rast public.raster, outdbfile text, outdbindex integer [], index integer = NULL::integer, nodataval double precision = NULL::double precision	postgres	sql	args: rast, outdbfile, outdbindex, index=at_end, nodataval=NULL - 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.
public	st_addband	public.raster	rast public.raster, pixeltype text, initialvalue double precision = '0'::numeric, nodataval double precision = NULL::double precision	postgres	sql	args: rast, pixeltype, initialvalue=0, nodataval=NULL - 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.
public	st_addband	public.raster	torast public.raster, fromrast public.raster, fromband integer = 1, torastindex integer = NULL::integer	postgres	c	args: torast, fromrast, fromband=1, torastindex=at_end - 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.
public	st_addband	public.raster	torast public.raster, fromrasts public.raster [], fromband integer = 1, torastindex integer = NULL::integer	postgres	c	args: torast, fromrasts, fromband=1, torastindex=at_end - 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.
public	st_addmeasure	public.geometry	public.geometry, double precision, double precision	postgres	c	args: geom_mline, measure_start, measure_end - Return a derived geometry with measure elements linearly interpolated between the start and end points.
public	st_addpoint	public.geometry	geom1 public.geometry, geom2 public.geometry	postgres	c	args: linestring, point - Adds a point to a LineString before point (0-based index).
public	st_addpoint	public.geometry	geom1 public.geometry, geom2 public.geometry, integer	postgres	c	args: linestring, point, position - Adds a point to a LineString before point (0-based index).
public	st_affine	public.geometry	public.geometry, double precision, double precision, double precision, double precision, double precision, double precision	postgres	sql	args: geomA, a, b, d, e, xoff, yoff - Applies a 3d affine transformation to the geometry to do things like translate, rotate, scale in one step.
public	st_affine	public.geometry	public.geometry, double precision, double precision, double precision, double precision, double precision, double precision, double precision, double precision, double precision, double precision, double precision, double precision	postgres	c	args: geomA, a, b, c, d, e, f, g, h, i, xoff, yoff, zoff - Applies a 3d affine transformation to the geometry to do things like translate, rotate, scale in one step.
public	st_approxcount	bigint	rast public.raster, exclude_nodata_value boolean, sample_percent double precision = 0.1	postgres	sql
public	st_approxcount	bigint	rast public.raster, nband integer = 1, exclude_nodata_value boolean = true, sample_percent double precision = 0.1	postgres	sql
public	st_approxcount	bigint	rast public.raster, nband integer, sample_percent double precision	postgres	sql
public	st_approxcount	bigint	rast public.raster, sample_percent double precision	postgres	sql
public	st_approxcount	bigint	rastertable text, rastercolumn text, exclude_nodata_value boolean, sample_percent double precision = 0.1	postgres	sql
public	st_approxcount	bigint	rastertable text, rastercolumn text, nband integer = 1, exclude_nodata_value boolean = true, sample_percent double precision = 0.1	postgres	sql
public	st_approxcount	bigint	rastertable text, rastercolumn text, nband integer, sample_percent double precision	postgres	sql
public	st_approxcount	bigint	rastertable text, rastercolumn text, sample_percent double precision	postgres	sql
public	st_approxhistogram	record	rast public.raster, nband integer, exclude_nodata_value boolean, sample_percent double precision, bins integer, right boolean, out min double precision, out max double precision, out count bigint, out percent double precision	postgres	sql
public	st_approxhistogram	record	rast public.raster, nband integer = 1, exclude_nodata_value boolean = true, sample_percent double precision = 0.1, bins integer = 0, width double precision [] = NULL::double precision[], right boolean = false, out min double precision, out max double precision, out count bigint, out percent double precision	postgres	sql
public	st_approxhistogram	record	rast public.raster, nband integer, sample_percent double precision, bins integer, right boolean, out min double precision, out max double precision, out count bigint, out percent double precision	postgres	sql
public	st_approxhistogram	record	rast public.raster, nband integer, sample_percent double precision, bins integer, width double precision [] = NULL::double precision[], right boolean = false, out min double precision, out max double precision, out count bigint, out percent double precision	postgres	sql
public	st_approxhistogram	record	rast public.raster, nband integer, sample_percent double precision, out min double precision, out max double precision, out count bigint, out percent double precision	postgres	sql
public	st_approxhistogram	record	rast public.raster, sample_percent double precision, out min double precision, out max double precision, out count bigint, out percent double precision	postgres	sql
public	st_approxhistogram	record	rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, sample_percent double precision, bins integer, right boolean, out min double precision, out max double precision, out count bigint, out percent double precision	postgres	sql
public	st_approxhistogram	record	rastertable text, rastercolumn text, nband integer = 1, exclude_nodata_value boolean = true, sample_percent double precision = 0.1, bins integer = 0, width double precision [] = NULL::double precision[], right boolean = false, out min double precision, out max double precision, out count bigint, out percent double precision	postgres	sql
public	st_approxhistogram	record	rastertable text, rastercolumn text, nband integer, sample_percent double precision, bins integer, right boolean, out min double precision, out max double precision, out count bigint, out percent double precision	postgres	sql
public	st_approxhistogram	record	rastertable text, rastercolumn text, nband integer, sample_percent double precision, bins integer, width double precision [] = NULL::double precision[], right boolean = false, out min double precision, out max double precision, out count bigint, out percent double precision	postgres	sql
public	st_approxhistogram	record	rastertable text, rastercolumn text, nband integer, sample_percent double precision, out min double precision, out max double precision, out count bigint, out percent double precision	postgres	sql
public	st_approxhistogram	record	rastertable text, rastercolumn text, sample_percent double precision, out min double precision, out max double precision, out count bigint, out percent double precision	postgres	sql
public	st_approxquantile	double precision	rast public.raster, exclude_nodata_value boolean, quantile double precision = NULL::double precision	postgres	sql
public	st_approxquantile	double precision	rast public.raster, nband integer, exclude_nodata_value boolean, sample_percent double precision, quantile double precision	postgres	sql
public	st_approxquantile	record	rast public.raster, nband integer = 1, exclude_nodata_value boolean = true, sample_percent double precision = 0.1, quantiles double precision [] = NULL::double precision[], out quantile double precision, out value double precision	postgres	sql
public	st_approxquantile	double precision	rast public.raster, nband integer, sample_percent double precision, quantile double precision	postgres	sql
public	st_approxquantile	record	rast public.raster, nband integer, sample_percent double precision, quantiles double precision [] = NULL::double precision[], out quantile double precision, out value double precision	postgres	sql
public	st_approxquantile	double precision	rast public.raster, quantile double precision	postgres	sql
public	st_approxquantile	record	rast public.raster, quantiles double precision [], out quantile double precision, out value double precision	postgres	sql
public	st_approxquantile	double precision	rast public.raster, sample_percent double precision, quantile double precision	postgres	sql
public	st_approxquantile	record	rast public.raster, sample_percent double precision, quantiles double precision [] = NULL::double precision[], out quantile double precision, out value double precision	postgres	sql
public	st_approxquantile	double precision	rastertable text, rastercolumn text, exclude_nodata_value boolean, quantile double precision = NULL::double precision	postgres	sql
public	st_approxquantile	double precision	rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, sample_percent double precision, quantile double precision	postgres	sql
public	st_approxquantile	record	rastertable text, rastercolumn text, nband integer = 1, exclude_nodata_value boolean = true, sample_percent double precision = 0.1, quantiles double precision [] = NULL::double precision[], out quantile double precision, out value double precision	postgres	sql
public	st_approxquantile	double precision	rastertable text, rastercolumn text, nband integer, sample_percent double precision, quantile double precision	postgres	sql
public	st_approxquantile	record	rastertable text, rastercolumn text, nband integer, sample_percent double precision, quantiles double precision [] = NULL::double precision[], out quantile double precision, out value double precision	postgres	sql
public	st_approxquantile	double precision	rastertable text, rastercolumn text, quantile double precision	postgres	sql
public	st_approxquantile	record	rastertable text, rastercolumn text, quantiles double precision [], out quantile double precision, out value double precision	postgres	sql
public	st_approxquantile	double precision	rastertable text, rastercolumn text, sample_percent double precision, quantile double precision	postgres	sql
public	st_approxquantile	record	rastertable text, rastercolumn text, sample_percent double precision, quantiles double precision [] = NULL::double precision[], out quantile double precision, out value double precision	postgres	sql
public	st_approxsummarystats	public.summarystats	rast public.raster, exclude_nodata_value boolean, sample_percent double precision = 0.1	postgres	sql
public	st_approxsummarystats	public.summarystats	rast public.raster, nband integer = 1, exclude_nodata_value boolean = true, sample_percent double precision = 0.1	postgres	sql
public	st_approxsummarystats	public.summarystats	rast public.raster, nband integer, sample_percent double precision	postgres	sql
public	st_approxsummarystats	public.summarystats	rast public.raster, sample_percent double precision	postgres	sql
public	st_approxsummarystats	public.summarystats	rastertable text, rastercolumn text, exclude_nodata_value boolean	postgres	sql
public	st_approxsummarystats	public.summarystats	rastertable text, rastercolumn text, nband integer = 1, exclude_nodata_value boolean = true, sample_percent double precision = 0.1	postgres	sql
public	st_approxsummarystats	public.summarystats	rastertable text, rastercolumn text, nband integer, sample_percent double precision	postgres	sql
public	st_approxsummarystats	public.summarystats	rastertable text, rastercolumn text, sample_percent double precision	postgres	sql
public	st_area	double precision	geog public.geography, use_spheroid boolean = true	postgres	c	args: geog, use_spheroid=true - Returns the area of the surface if it is a Polygon or MultiPolygon. For geometry, a 2D Cartesian area is determined with units specified by the SRID. For geography, area is determined on a curved surface with units in square meters.
public	st_area	double precision	public.geometry	postgres	c	args: g1 - Returns the area of the surface if it is a Polygon or MultiPolygon. For geometry, a 2D Cartesian area is determined with units specified by the SRID. For geography, area is determined on a curved surface with units in square meters.
public	st_area	double precision	text	postgres	sql
public	st_area2d	double precision	public.geometry	postgres	c
public	st_asbinary	bytea	public.geography	postgres	c	args: g1 - Return the Well-Known Binary (WKB) representation of the geometry/geography without SRID meta data.
public	st_asbinary	bytea	public.geography, text	postgres	sql	args: g1, NDR_or_XDR - Return the Well-Known Binary (WKB) representation of the geometry/geography without SRID meta data.
public	st_asbinary	bytea	public.geometry	postgres	c	args: g1 - Return the Well-Known Binary (WKB) representation of the geometry/geography without SRID meta data.
public	st_asbinary	bytea	public.geometry, text	postgres	c	args: g1, NDR_or_XDR - Return the Well-Known Binary (WKB) representation of the geometry/geography without SRID meta data.
public	st_asbinary	bytea	public.raster, outasin boolean = false	postgres	c	args: rast, outasin=FALSE - Return the Well-Known Binary (WKB) representation of the raster without SRID meta data.
public	st_asencodedpolyline	text	geom public.geometry, integer = 5	postgres	c	args: geom, precision=5 - Returns an Encoded Polyline from a LineString geometry.
public	st_asewkb	bytea	public.geometry	postgres	c	args: g1 - Return the Well-Known Binary (WKB) representation of the geometry with SRID meta data.
public	st_asewkb	bytea	public.geometry, text	postgres	c	args: g1, NDR_or_XDR - Return the Well-Known Binary (WKB) representation of the geometry with SRID meta data.
public	st_asewkt	text	public.geography	postgres	c	args: g1 - Return the Well-Known Text (WKT) representation of the geometry with SRID meta data.
public	st_asewkt	text	public.geometry	postgres	c	args: g1 - Return the Well-Known Text (WKT) representation of the geometry with SRID meta data.
public	st_asewkt	text	text	postgres	sql
public	st_asgdalraster	bytea	rast public.raster, format text, options text [] = NULL::text[], srid integer = NULL::integer	postgres	c	args: rast, format, options=NULL, srid=sameassource - 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.
public	st_asgeojson	text	geog public.geography, maxdecimaldigits integer = 15, options integer = 0	postgres	sql	args: geog, maxdecimaldigits=15, options=0 - Return the geometry as a GeoJSON element.
public	st_asgeojson	text	geom public.geometry, maxdecimaldigits integer = 15, options integer = 0	postgres	c	args: geom, maxdecimaldigits=15, options=0 - Return the geometry as a GeoJSON element.
public	st_asgeojson	text	gj_version integer, geog public.geography, maxdecimaldigits integer = 15, options integer = 0	postgres	sql	args: gj_version, geog, maxdecimaldigits=15, options=0 - Return the geometry as a GeoJSON element.
public	st_asgeojson	text	gj_version integer, geom public.geometry, maxdecimaldigits integer = 15, options integer = 0	postgres	sql	args: gj_version, geom, maxdecimaldigits=15, options=0 - Return the geometry as a GeoJSON element.
public	st_asgeojson	text	text	postgres	sql
public	st_asgml	text	geog public.geography, maxdecimaldigits integer = 15, options integer = 0	postgres	sql	args: geog, maxdecimaldigits=15, options=0 - Return the geometry as a GML version 2 or 3 element.
public	st_asgml	text	geom public.geometry, maxdecimaldigits integer = 15, options integer = 0	postgres	sql	args: geom, maxdecimaldigits=15, options=0 - Return the geometry as a GML version 2 or 3 element.
public	st_asgml	text	text	postgres	sql
public	st_asgml	text	version integer, geog public.geography, maxdecimaldigits integer = 15, options integer = 0, nprefix text = NULL::text, id text = NULL::text	postgres	sql	args: version, geog, maxdecimaldigits=15, options=0, nprefix=null, id=null - Return the geometry as a GML version 2 or 3 element.
public	st_asgml	text	version integer, geom public.geometry, maxdecimaldigits integer = 15, options integer = 0, nprefix text = NULL::text, id text = NULL::text	postgres	sql	args: version, geom, maxdecimaldigits=15, options=0, nprefix=null, id=null - Return the geometry as a GML version 2 or 3 element.
public	st_ashexewkb	text	public.geometry	postgres	c	args: g1 - Returns a Geometry in HEXEWKB format (as text) using either little-endian (NDR) or big-endian (XDR) encoding.
public	st_ashexewkb	text	public.geometry, text	postgres	c	args: g1, NDRorXDR - Returns a Geometry in HEXEWKB format (as text) using either little-endian (NDR) or big-endian (XDR) encoding.
public	st_asjpeg	bytea	rast public.raster, nband integer, options text [] = NULL::text[]	postgres	sql	args: rast, nband, options=NULL - 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.
public	st_asjpeg	bytea	rast public.raster, nband integer, quality integer	postgres	sql	args: rast, nband, quality - 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.
public	st_asjpeg	bytea	rast public.raster, nbands integer [], options text [] = NULL::text[]	postgres	sql	args: rast, nbands, options=NULL - 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.
public	st_asjpeg	bytea	rast public.raster, nbands integer [], quality integer	postgres	plpgsql	args: rast, nbands, quality - 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.
public	st_asjpeg	bytea	rast public.raster, options text [] = NULL::text[]	postgres	plpgsql	args: rast, options=NULL - 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.
public	st_askml	text	geog public.geography, maxdecimaldigits integer = 15	postgres	sql	args: geog, maxdecimaldigits=15 - Return the geometry as a KML element. Several variants. Default version=2, default precision=15
public	st_askml	text	geom public.geometry, maxdecimaldigits integer = 15	postgres	sql	args: geom, maxdecimaldigits=15 - Return the geometry as a KML element. Several variants. Default version=2, default precision=15
public	st_askml	text	text	postgres	sql
public	st_askml	text	version integer, geog public.geography, maxdecimaldigits integer = 15, nprefix text = NULL::text	postgres	sql	args: version, geog, maxdecimaldigits=15, nprefix=NULL - Return the geometry as a KML element. Several variants. Default version=2, default precision=15
public	st_askml	text	version integer, geom public.geometry, maxdecimaldigits integer = 15, nprefix text = NULL::text	postgres	sql	args: version, geom, maxdecimaldigits=15, nprefix=NULL - Return the geometry as a KML element. Several variants. Default version=2, default precision=15
public	st_aslatlontext	text	geom public.geometry, tmpl text = ''::text	postgres	c	args: pt, format=' - Return the Degrees, Minutes, Seconds representation of the given point.
public	st_aspect	public.raster	rast public.raster, nband integer, customextent public.raster, pixeltype text = '32BF'::text, units text = 'DEGREES'::text, interpolate_nodata boolean = false	postgres	plpgsql
public	st_aspect	public.raster	rast public.raster, nband integer = 1, pixeltype text = '32BF'::text, units text = 'DEGREES'::text, interpolate_nodata boolean = false	postgres	sql
public	st_aspng	bytea	rast public.raster, nband integer, compression integer	postgres	sql	args: rast, nband, compression - 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.
public	st_aspng	bytea	rast public.raster, nband integer, options text [] = NULL::text[]	postgres	sql	args: rast, nband, options=NULL - 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.
public	st_aspng	bytea	rast public.raster, nbands integer [], compression integer	postgres	plpgsql	args: rast, nbands, compression - 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.
public	st_aspng	bytea	rast public.raster, nbands integer [], options text [] = NULL::text[]	postgres	sql	args: rast, nbands, options=NULL - 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.
public	st_aspng	bytea	rast public.raster, options text [] = NULL::text[]	postgres	plpgsql	args: rast, options=NULL - 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.
public	st_asraster	public.raster	geom public.geometry, ref public.raster, pixeltype text [] = ARRAY['8BUI'::text], value double precision [] = ARRAY[1::double precision], nodataval double precision [] = ARRAY[0::double precision], touched boolean = false	postgres	plpgsql	args: geom, ref, pixeltype=ARRAY['8BUI'], value=ARRAY[1], nodataval=ARRAY[0], touched=false - Converts a PostGIS geometry to a PostGIS raster.
public	st_asraster	public.raster	geom public.geometry, ref public.raster, pixeltype text, value double precision = 1, nodataval double precision = 0, touched boolean = false	postgres	sql	args: geom, ref, pixeltype, value=1, nodataval=0, touched=false - Converts a PostGIS geometry to a PostGIS raster.
public	st_asraster	public.raster	geom public.geometry, scalex double precision, scaley double precision, gridx double precision = NULL::double precision, gridy double precision = NULL::double precision, pixeltype text [] = ARRAY['8BUI'::text], value double precision [] = ARRAY[1::double precision], nodataval double precision [] = ARRAY[0::double precision], skewx double precision = 0, skewy double precision = 0, touched boolean = false	postgres	sql	args: geom, scalex, scaley, gridx=NULL, gridy=NULL, pixeltype=ARRAY['8BUI'], value=ARRAY[1], nodataval=ARRAY[0], skewx=0, skewy=0, touched=false - Converts a PostGIS geometry to a PostGIS raster.
public	st_asraster	public.raster	geom public.geometry, scalex double precision, scaley double precision, gridx double precision, gridy double precision, pixeltype text, value double precision = 1, nodataval double precision = 0, skewx double precision = 0, skewy double precision = 0, touched boolean = false	postgres	sql	args: geom, scalex, scaley, gridx, gridy, pixeltype, value=1, nodataval=0, skewx=0, skewy=0, touched=false - Converts a PostGIS geometry to a PostGIS raster.
public	st_asraster	public.raster	geom public.geometry, scalex double precision, scaley double precision, pixeltype text [], value double precision [] = ARRAY[1::double precision], nodataval double precision [] = ARRAY[0::double precision], upperleftx double precision = NULL::double precision, upperlefty double precision = NULL::double precision, skewx double precision = 0, skewy double precision = 0, touched boolean = false	postgres	sql	args: geom, scalex, scaley, pixeltype, value=ARRAY[1], nodataval=ARRAY[0], upperleftx=NULL, upperlefty=NULL, skewx=0, skewy=0, touched=false - Converts a PostGIS geometry to a PostGIS raster.
public	st_asraster	public.raster	geom public.geometry, scalex double precision, scaley double precision, pixeltype text, value double precision = 1, nodataval double precision = 0, upperleftx double precision = NULL::double precision, upperlefty double precision = NULL::double precision, skewx double precision = 0, skewy double precision = 0, touched boolean = false	postgres	sql	args: geom, scalex, scaley, pixeltype, value=1, nodataval=0, upperleftx=NULL, upperlefty=NULL, skewx=0, skewy=0, touched=false - Converts a PostGIS geometry to a PostGIS raster.
public	st_asraster	public.raster	geom public.geometry, width integer, height integer, gridx double precision = NULL::double precision, gridy double precision = NULL::double precision, pixeltype text [] = ARRAY['8BUI'::text], value double precision [] = ARRAY[1::double precision], nodataval double precision [] = ARRAY[0::double precision], skewx double precision = 0, skewy double precision = 0, touched boolean = false	postgres	sql	args: geom, width, height, gridx=NULL, gridy=NULL, pixeltype=ARRAY['8BUI'], value=ARRAY[1], nodataval=ARRAY[0], skewx=0, skewy=0, touched=false - Converts a PostGIS geometry to a PostGIS raster.
public	st_asraster	public.raster	geom public.geometry, width integer, height integer, gridx double precision, gridy double precision, pixeltype text, value double precision = 1, nodataval double precision = 0, skewx double precision = 0, skewy double precision = 0, touched boolean = false	postgres	sql	args: geom, width, height, gridx, gridy, pixeltype, value=1, nodataval=0, skewx=0, skewy=0, touched=false - Converts a PostGIS geometry to a PostGIS raster.
public	st_asraster	public.raster	geom public.geometry, width integer, height integer, pixeltype text [], value double precision [] = ARRAY[1::double precision], nodataval double precision [] = ARRAY[0::double precision], upperleftx double precision = NULL::double precision, upperlefty double precision = NULL::double precision, skewx double precision = 0, skewy double precision = 0, touched boolean = false	postgres	sql	args: geom, width, height, pixeltype, value=ARRAY[1], nodataval=ARRAY[0], upperleftx=NULL, upperlefty=NULL, skewx=0, skewy=0, touched=false - Converts a PostGIS geometry to a PostGIS raster.
public	st_asraster	public.raster	geom public.geometry, width integer, height integer, pixeltype text, value double precision = 1, nodataval double precision = 0, upperleftx double precision = NULL::double precision, upperlefty double precision = NULL::double precision, skewx double precision = 0, skewy double precision = 0, touched boolean = false	postgres	sql	args: geom, width, height, pixeltype, value=1, nodataval=0, upperleftx=NULL, upperlefty=NULL, skewx=0, skewy=0, touched=false - Converts a PostGIS geometry to a PostGIS raster.
public	st_assvg	text	geog public.geography, rel integer = 0, maxdecimaldigits integer = 15	postgres	c	args: geog, rel=0, maxdecimaldigits=15 - Returns a Geometry in SVG path data given a geometry or geography object.
public	st_assvg	text	geom public.geometry, rel integer = 0, maxdecimaldigits integer = 15	postgres	c	args: geom, rel=0, maxdecimaldigits=15 - Returns a Geometry in SVG path data given a geometry or geography object.
public	st_assvg	text	text	postgres	sql
public	st_astext	text	public.geography	postgres	c	args: g1 - Return the Well-Known Text (WKT) representation of the geometry/geography without SRID metadata.
public	st_astext	text	public.geometry	postgres	c	args: g1 - Return the Well-Known Text (WKT) representation of the geometry/geography without SRID metadata.
public	st_astext	text	text	postgres	sql
public	st_astiff	bytea	rast public.raster, compression text, srid integer = NULL::integer	postgres	plpgsql	args: rast, compression=', srid=sameassource - Return the raster selected bands as a single TIFF image (byte array). If no band is specified, then will try to use all bands.
public	st_astiff	bytea	rast public.raster, nbands integer [], compression text, srid integer = NULL::integer	postgres	sql	args: rast, nbands, compression=', srid=sameassource - Return the raster selected bands as a single TIFF image (byte array). If no band is specified, then will try to use all bands.
public	st_astiff	bytea	rast public.raster, nbands integer [], options text [] = NULL::text[], srid integer = NULL::integer	postgres	sql	args: rast, nbands, options, srid=sameassource - Return the raster selected bands as a single TIFF image (byte array). If no band is specified, then will try to use all bands.
public	st_astiff	bytea	rast public.raster, options text [] = NULL::text[], srid integer = NULL::integer	postgres	plpgsql	args: rast, options=', srid=sameassource - Return the raster selected bands as a single TIFF image (byte array). If no band is specified, then will try to use all bands.
public	st_astwkb	bytea	geom public.geometry [], ids bigint [], prec integer = NULL::integer, prec_z integer = NULL::integer, prec_m integer = NULL::integer, with_sizes boolean = NULL::boolean, with_boxes boolean = NULL::boolean	postgres	c	args: geometries, unique_ids, decimaldigits_xy=0, decimaldigits_z=0, decimaldigits_m=0, include_sizes=false, include_bounding_boxes=false - Returns the geometry as TWKB, aka "Tiny Well-Known Binary"
public	st_astwkb	bytea	geom public.geometry, prec integer = NULL::integer, prec_z integer = NULL::integer, prec_m integer = NULL::integer, with_sizes boolean = NULL::boolean, with_boxes boolean = NULL::boolean	postgres	c	args: g1, decimaldigits_xy=0, decimaldigits_z=0, decimaldigits_m=0, include_sizes=false, include_bounding boxes=false - Returns the geometry as TWKB, aka "Tiny Well-Known Binary"
public	st_asx3d	text	geom public.geometry, maxdecimaldigits integer = 15, options integer = 0	postgres	sql	args: g1, maxdecimaldigits=15, options=0 - Returns a Geometry in X3D xml node element format: ISO-IEC-19776-1.2-X3DEncodings-XML
public	st_azimuth	double precision	geog1 public.geography, geog2 public.geography	postgres	c	args: pointA, pointB - Returns the north-based azimuth as the angle in radians measured clockwise from the vertical on pointA to pointB.
public	st_azimuth	double precision	geom1 public.geometry, geom2 public.geometry	postgres	c	args: pointA, pointB - Returns the north-based azimuth as the angle in radians measured clockwise from the vertical on pointA to pointB.
public	st_band	public.raster	rast public.raster, nband integer	postgres	sql	args: rast, nband - Returns one or more bands of an existing raster as a new raster. Useful for building new rasters from existing rasters.
public	st_band	public.raster	rast public.raster, nbands integer [] = ARRAY[1]	postgres	c	args: rast, nbands = ARRAY[1] - Returns one or more bands of an existing raster as a new raster. Useful for building new rasters from existing rasters.
public	st_band	public.raster	rast public.raster, nbands text, delimiter char = ','::bpchar	postgres	sql	args: rast, nbands, delimiter=, - Returns one or more bands of an existing raster as a new raster. Useful for building new rasters from existing rasters.
public	st_bandisnodata	boolean	rast public.raster, band integer = 1, forcechecking boolean = false	postgres	c	args: rast, band, forceChecking=true - Returns true if the band is filled with only nodata values.
public	st_bandisnodata	boolean	rast public.raster, forcechecking boolean	postgres	sql	args: rast, forceChecking=true - Returns true if the band is filled with only nodata values.
public	st_bandmetadata	record	rast public.raster, band integer [], out bandnum integer, out pixeltype text, out nodatavalue double precision, out isoutdb boolean, out path text	postgres	c
public	st_bandmetadata	record	rast public.raster, band integer = 1, out pixeltype text, out nodatavalue double precision, out isoutdb boolean, out path text	postgres	sql	args: rast, bandnum=1 - Returns basic meta data for a specific raster band. band num 1 is assumed if none-specified.
public	st_bandnodatavalue	double precision	rast public.raster, band integer = 1	postgres	c	args: rast, bandnum=1 - Returns the value in a given band that represents no data. If no band num 1 is assumed.
public	st_bandpath	text	rast public.raster, band integer = 1	postgres	c	args: rast, bandnum=1 - Returns system file path to a band stored in file system. If no bandnum specified, 1 is assumed.
public	st_bandpixeltype	text	rast public.raster, band integer = 1	postgres	c	args: rast, bandnum=1 - Returns the type of pixel for given band. If no bandnum specified, 1 is assumed.
public	st_bdmpolyfromtext	public.geometry	text, integer	postgres	plpgsql	args: WKT, srid - Construct a MultiPolygon given an arbitrary collection of closed linestrings as a MultiLineString text representation Well-Known text representation.
public	st_bdpolyfromtext	public.geometry	text, integer	postgres	plpgsql	args: WKT, srid - Construct a Polygon given an arbitrary collection of closed linestrings as a MultiLineString Well-Known text representation.
public	st_boundary	public.geometry	public.geometry	postgres	c	args: geomA - Returns the closure of the combinatorial boundary of this Geometry.
public	st_boundingdiagonal	public.geometry	geom public.geometry, fits boolean = false	postgres	c	args: geom, fits=false - Returns the diagonal of the supplied geometrys bounding box.

Schema

Function

Returns

Arguments

Owner

Language

Description

analyse

ps_analyse_geom

record

geom public.geometry, out is_null boolean, out is_valid boolean, out nb_geom integer, out nb_ring integer, out nb_points integer, out nb_geom_invalide integer, out diffsurface double precision, out nb_ring_intersect integer, out nb_ring_not_closed integer, out nb_ring_fermeture_simple integer, out nb_ring_intersect_after_fermeture_ok integer, out nb_ring_intersect_after_fermeture_douteux integer, out nb_ring_not_closed_erreur integer, out nb_geom_apres_correction integer, out nb_ring_apres_correction integer, out nb_points_apres_correction integer

albenard

plpgsql

Cette fonction analyse l'objet géométrique passé en paramètre et retourne un ensemble d'indicateurs sur la situation qualitative de cet objet :
- is_null boolean précisant si l'objet est null
- is_valid boolean précisant si l'objet est valide
Si l'objet est invalide les indicateurs suivant sont renseignés :
- nb_geom nombre de géométries de l'objet
- nb_ring nombre d'anneaux présents dans l'objet
- nb_points nombre de point présents dans l'objet
- nb_geom_invalide nombre de géométries invalides de l'objet
- diffsurface différence de surface entre la géométrie initiale et la géométrie corrigée de manière automatique
- nb_ring_intersect nombre d'auto-intersection total de la géométrie.
- nb_ring_not_closed nombre d'anneaux non fermés dans l'objet
- nb_ring_fermeture_simple nombre d'anneaux ouverts qui peuvent être fermés sans doute sur la correction
- nb_ring_intersect_after_fermeture_ok nombre d'anneaux ouverts qui peuvent être fermés sans doute sur la correction même si la fermeture a engendré un autointersection
- nb_ring_intersect_after_fermeture_douteux nombre d'anneaux ouverts dont la fermeture engendre une autointersection dont le traitement est incertain (nécessite action humaine)
- nb_ring_not_closed_erreur nombre d'anneaux ouverts dont la fermeture est en erreur (nécessite action humaine)
- nb_geom_apres_correction nombre de géométries de l'objet corrige
- nb_ring_apres_correction nombre d'anneaux présents dans l'objet corrige
- nb_points_apres_correction nombre de point présents dans l'objet corrige

analyse

ps_analyse_geom_table

record

nom_table_concernee varchar, nom_cle_table varchar, nom_autre_champ varchar, nom_champ_geom varchar, out cle varchar, out autre_champ varchar, out is_null boolean, out is_valid boolean, out nb_geom integer, out nb_ring integer, out nb_points integer, out nb_geom_invalide integer, out diffsurface double precision, out nb_ring_intersect integer, out nb_ring_not_closed integer, out nb_ring_fermeture_simple integer, out nb_ring_intersect_after_fermeture_ok integer, out nb_ring_intersect_after_fermeture_douteux integer, out nb_ring_not_closed_erreur integer, out nb_geom_apres_correction integer, out nb_ring_apres_correction integer, out nb_points_apres_correction integer

albenard

plpgsql

Cette fonction effectue un listing sur la qualité d'un objet géométrique au sein d'une table complète passée comme premier paramètre.
Afin que le listing soit exploitable par l'appellant elle s'appuie sur 2 parmaètres qui précise quel est le champ clé de la table (second paramètre)
et éventuellement quel autre champ l'opérateur désire récupérer dans le listing (3° paramètre).
L'appelant doit également préciser en 4° paramètre quel est le nom du champ qui contient l'objet géométrique à ananlyser.
Chaque ligne du listing contient donc un ensemble de colonne :
- clé de l'enregistment selon le paramètre en entrée.
- autre champs éventuel ou null
- les indicateurs qualitatifs que renseigne la fonction ps_ananlyse_geom à savoir :
- nb_geom nombre de géométries de l'objet
- nb_ring nombre d'anneaux présents dans l'objet
- nb_points nombre de point présents dans l'objet
- nb_geom_invalide nombre de géométries invalides de l'objet
- diffsurface différence de surface entre la géométrie initiale et la géométrie corrigée de manière automatique
- nb_ring_intersect nombre d'anneaux en auto-intersection.
- nb_ring_not_closed nombre d'anneaux non fermés dans l'objet
- nb_ring_fermeture_simple nombre d'anneaux ouverts qui peuvent être fermés sans doute sur la correction
- nb_ring_intersect_after_fermeture_ok nombre d'anneaux ouverts qui peuvent être fermés sans doute sur la correction même si la fermeture a engendré un autointersection
- nb_ring_intersect_after_fermeture_douteux nombre d'anneaux ouverts dont la fermeture engendre une autointersection dont le traitement est incertain (nécessite action humaine)
- nb_ring_not_closed_erreur nombre d'anneaux ouverts dont la fermeture est en erreur (nécessite action humaine)
- nb_geom_apres_correction nombre de géométries de l'objet corrige
- nb_ring_apres_correction nombre d'anneaux présents dans l'objet corrige
- nb_points_apres_correction nombre de point présents dans l'objet corrige

analyse

ps_analyse_geom_table_sommaire

record

nom_table_concernee varchar, nom_cle_table varchar, nom_champ_geom varchar, out libelle_sortie varchar, out nb_sortie integer

albenard

plpgsql

Cette fonction effectue un comptage sur la qualité de l'objet géométrique d'une table.
Les paramètres à utiliser sont :
- nom de la table concernée.
- colonne contenant un identifiant au sein de la table (pour permettre le comptage)
- nom de la colonne contenant les objets géométriques à ananlyser.

analyse

ps_distance_os

boolean

annee_traitement integer = 2005, tailleoffset integer = 2000

albenard

plpgsql

Cette fonction calcule la distance à certains éléments (route, bati ...) et met à jour les champs de la table t_positionnement_pos dédiés au stockage de cette information.

analyse

ps_statut_non_ferme

integer

bad_ring public.geometry

albenard

plpgsql

Cette fonction prend comme argument un objet géométrique normalement de type ST_LineString. Le cas d'usage le plus courant
est un appel depuis la fonction ps_analyse_geom qui tente de fermer un anneau ouvert et s'appuie sur la présente fonction pour
savoir comment s'est passée la fermeture.
La fonction renvoie :
0 : La géométrie passée en paramètre ne respecte pas le type ST_LineString ou bien n'est pas une géométrie fermée.
1 : La géométrie passée en paramètre ne nécessite pas de correction (anneau simple fermé)
2 : La géométrie passée en paramètre présente une intersection qui se corrige avec un simple ajout de polygone ou trou (3 points supplémentaires)
3 : La géométrie passée en paramètre présente une intersection que Postgis corrige d'une façon appelant des vérifications et certainement une intervention.