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

albenard

plpgsql

public

_add_overview_constraint

boolean

ovschema name, ovtable name, ovcolumn name, refschema name, reftable name, refcolumn name, factor integer

albenard

plpgsql

public

_add_raster_constraint

boolean

cn name, sql text

albenard

plpgsql

public

_add_raster_constraint_alignment

boolean

rastschema name, rasttable name, rastcolumn name

albenard

plpgsql

public

_add_raster_constraint_blocksize

boolean

rastschema name, rasttable name, rastcolumn name, axis text

albenard

plpgsql

public

_add_raster_constraint_coverage_tile

boolean

rastschema name, rasttable name, rastcolumn name

albenard

plpgsql

public

_add_raster_constraint_extent

boolean

rastschema name, rasttable name, rastcolumn name

albenard

plpgsql

public

_add_raster_constraint_nodata_values

boolean

rastschema name, rasttable name, rastcolumn name

albenard

plpgsql

public

_add_raster_constraint_num_bands

boolean

rastschema name, rasttable name, rastcolumn name

albenard

plpgsql

public

_add_raster_constraint_out_db

boolean

rastschema name, rasttable name, rastcolumn name

albenard

plpgsql

public

_add_raster_constraint_pixel_types

boolean

rastschema name, rasttable name, rastcolumn name

albenard

plpgsql

public

_add_raster_constraint_scale

boolean

rastschema name, rasttable name, rastcolumn name, axis char

albenard

plpgsql

public

_add_raster_constraint_spatially_unique

boolean

rastschema name, rasttable name, rastcolumn name

albenard

plpgsql

public

_add_raster_constraint_srid

boolean

rastschema name, rasttable name, rastcolumn name

albenard

plpgsql

public

_drop_overview_constraint

boolean

ovschema name, ovtable name, ovcolumn name

albenard

sql

public

_drop_raster_constraint

boolean

rastschema name, rasttable name, cn name

albenard

plpgsql

public

_drop_raster_constraint_alignment

boolean

rastschema name, rasttable name, rastcolumn name

albenard

sql

public

_drop_raster_constraint_blocksize

boolean

rastschema name, rasttable name, rastcolumn name, axis text

albenard

plpgsql

public

_drop_raster_constraint_coverage_tile

boolean

rastschema name, rasttable name, rastcolumn name

albenard

sql

public

_drop_raster_constraint_extent

boolean

rastschema name, rasttable name, rastcolumn name

albenard

sql

public

_drop_raster_constraint_nodata_values

boolean

rastschema name, rasttable name, rastcolumn name

albenard

sql

public

_drop_raster_constraint_num_bands

boolean

rastschema name, rasttable name, rastcolumn name

albenard

sql

public

_drop_raster_constraint_out_db

boolean

rastschema name, rasttable name, rastcolumn name

albenard

sql

public

_drop_raster_constraint_pixel_types

boolean

rastschema name, rasttable name, rastcolumn name

albenard

sql

public

_drop_raster_constraint_regular_blocking

boolean

rastschema name, rasttable name, rastcolumn name

albenard

sql

public

_drop_raster_constraint_scale

boolean

rastschema name, rasttable name, rastcolumn name, axis char

albenard

plpgsql

public

_drop_raster_constraint_spatially_unique

boolean

rastschema name, rasttable name, rastcolumn name

albenard

plpgsql

public

_drop_raster_constraint_srid

boolean

rastschema name, rasttable name, rastcolumn name

albenard

sql

public

_overview_constraint

boolean

ov public.raster, factor integer, refschema name, reftable name, refcolumn name

albenard

sql

public

_overview_constraint_info

record

ovschema name, ovtable name, ovcolumn name, out refschema name, out reftable name, out refcolumn name, out factor integer

albenard

sql

public

_postgis_deprecate

void

oldname text, newname text, version text

albenard

plpgsql

public

_postgis_join_selectivity

double precision

pg_catalog.regclass, text, pg_catalog.regclass, text, text = '2'::text

albenard

c

public

_postgis_selectivity

double precision

tbl pg_catalog.regclass, att_name text, geom public.geometry, mode text = '2'::text

albenard

c

public

_postgis_stats

text

tbl pg_catalog.regclass, att_name text, text = '2'::text

albenard

c

public

_raster_constraint_info_alignment

boolean

rastschema name, rasttable name, rastcolumn name

albenard

sql

public

_raster_constraint_info_blocksize

integer

rastschema name, rasttable name, rastcolumn name, axis text

albenard

sql

public

_raster_constraint_info_coverage_tile

boolean

rastschema name, rasttable name, rastcolumn name

albenard

sql

public

_raster_constraint_info_extent

public.geometry

rastschema name, rasttable name, rastcolumn name

albenard

sql

public

_raster_constraint_info_index

boolean

rastschema name, rasttable name, rastcolumn name

albenard

sql

public

_raster_constraint_info_nodata_values

double precision []

rastschema name, rasttable name, rastcolumn name

albenard

sql

public

_raster_constraint_info_num_bands

integer

rastschema name, rasttable name, rastcolumn name

albenard

sql

public

_raster_constraint_info_out_db

boolean []

rastschema name, rasttable name, rastcolumn name

albenard

sql

public

_raster_constraint_info_pixel_types

text []

rastschema name, rasttable name, rastcolumn name

albenard

sql

public

_raster_constraint_info_regular_blocking

boolean

rastschema name, rasttable name, rastcolumn name

albenard

plpgsql

public

_raster_constraint_info_scale

double precision

rastschema name, rasttable name, rastcolumn name, axis char

albenard

sql

public

_raster_constraint_info_spatially_unique

boolean

rastschema name, rasttable name, rastcolumn name

albenard

sql

public

_raster_constraint_info_srid

integer

rastschema name, rasttable name, rastcolumn name

albenard

sql

public

_raster_constraint_nodata_values

numeric []

rast public.raster

albenard

sql

public

_raster_constraint_out_db

boolean []

rast public.raster

albenard

sql

public

_raster_constraint_pixel_types

text []

rast public.raster

albenard

sql

public

_st_3ddfullywithin

boolean

geom1 public.geometry, geom2 public.geometry, double precision

albenard

c

public

_st_3ddwithin

boolean

geom1 public.geometry, geom2 public.geometry, double precision

albenard

c

public

_st_3dintersects

boolean

geom1 public.geometry, geom2 public.geometry

albenard

c

public

_st_asgeojson

text

integer, public.geography, integer, integer

albenard

c

public

_st_asgeojson

text

integer, public.geometry, integer, integer

albenard

sql

public

_st_asgml

text

integer, public.geography, integer, integer, text, text

albenard

c

public

_st_asgml

text

integer, public.geometry, integer, integer, text, text

albenard

c

public

_st_askml

text

integer, public.geography, integer, text

albenard

c

public

_st_askml

text

integer, public.geometry, integer, text

albenard

c

public

_st_aspect4ma

double precision

value double precision [], pos integer [], variadic userargs text [] = NULL::text[]

albenard

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

albenard

c

public

_st_bestsrid

integer

public.geography

albenard

sql

public

_st_bestsrid

integer

public.geography, public.geography

albenard

c

public

_st_buffer

public.geometry

public.geometry, double precision, pg_catalog.cstring

albenard

c

public

_st_clip

public.raster

rast public.raster, nband integer [], geom public.geometry, nodataval double precision [] = NULL::double precision[], crop boolean = true

albenard

c

public

_st_colormap

public.raster

rast public.raster, nband integer, colormap text, method text = 'INTERPOLATE'::text

albenard

c

public

_st_concavehull

public.geometry

param_inputgeom public.geometry

albenard

plpgsql

public

_st_contains

boolean

geom1 public.geometry, geom2 public.geometry

albenard

c

public

_st_contains

boolean

rast1 public.raster, nband1 integer, rast2 public.raster, nband2 integer

albenard

c

public

_st_containsproperly

boolean

geom1 public.geometry, geom2 public.geometry

albenard

c

public

_st_containsproperly

boolean

rast1 public.raster, nband1 integer, rast2 public.raster, nband2 integer

albenard

c

public

_st_convertarray4ma

double precision []

value double precision []

albenard

plpgsql

public

_st_count

bigint

rast public.raster, nband integer = 1, exclude_nodata_value boolean = true, sample_percent double precision = 1

albenard

plpgsql

public

_st_count

bigint

rastertable text, rastercolumn text, nband integer = 1, exclude_nodata_value boolean = true, sample_percent double precision = 1

albenard

plpgsql

public

_st_countagg_finalfn

bigint

agg public.agg_count

albenard

plpgsql

public

_st_countagg_transfn

public.agg_count

agg public.agg_count, rast public.raster, exclude_nodata_value boolean

albenard

plpgsql

public

_st_countagg_transfn

public.agg_count

agg public.agg_count, rast public.raster, nband integer, exclude_nodata_value boolean

albenard

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

albenard

plpgsql

public

_st_coveredby

boolean

geom1 public.geometry, geom2 public.geometry

albenard

c

public

_st_coveredby

boolean

rast1 public.raster, nband1 integer, rast2 public.raster, nband2 integer

albenard

c

public

_st_covers

boolean

geom1 public.geometry, geom2 public.geometry

albenard

c

public

_st_covers

boolean

public.geography, public.geography

albenard

c

public

_st_covers

boolean

rast1 public.raster, nband1 integer, rast2 public.raster, nband2 integer

albenard

c

public

_st_crosses

boolean

geom1 public.geometry, geom2 public.geometry

albenard

c

public

_st_dfullywithin

boolean

geom1 public.geometry, geom2 public.geometry, double precision

albenard

c

public

_st_dfullywithin

boolean

rast1 public.raster, nband1 integer, rast2 public.raster, nband2 integer, distance double precision

albenard

c

public

_st_distance

double precision

public.geography, public.geography, double precision, boolean

albenard

c

public

_st_distancetree

double precision

public.geography, public.geography

albenard

sql

public

_st_distancetree

double precision

public.geography, public.geography, double precision, boolean

albenard

c

public

_st_distanceuncached

double precision

public.geography, public.geography

albenard

sql

public

_st_distanceuncached

double precision

public.geography, public.geography, boolean

albenard

sql

public

_st_distanceuncached

double precision

public.geography, public.geography, double precision, boolean

albenard

c

public

_st_dumppoints

public.geometry_dump

the_geom public.geometry, cur_path integer []

albenard

plpgsql

public

_st_dwithin

boolean

geom1 public.geometry, geom2 public.geometry, double precision

albenard

c

public

_st_dwithin

boolean

public.geography, public.geography, double precision, boolean

albenard

c

public

_st_dwithin

boolean

rast1 public.raster, nband1 integer, rast2 public.raster, nband2 integer, distance double precision

albenard

c

public

_st_dwithinuncached

boolean

public.geography, public.geography, double precision

albenard

sql

public

_st_dwithinuncached

boolean

public.geography, public.geography, double precision, boolean

albenard

c

public

_st_equals

boolean

geom1 public.geometry, geom2 public.geometry

albenard

c

public

_st_expand

public.geography

public.geography, double precision

albenard

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

albenard

c

public

_st_geomfromgml

public.geometry

text, integer

albenard

c

public

_st_hillshade4ma

double precision

value double precision [], pos integer [], variadic userargs text [] = NULL::text[]

albenard

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

albenard

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

albenard

c

public

_st_longestline

public.geometry

geom1 public.geometry, geom2 public.geometry

albenard

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[]

albenard

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

albenard

c

public

_st_maxdistance

double precision

geom1 public.geometry, geom2 public.geometry

albenard

c

public

_st_neighborhood

double precision []

rast public.raster, band integer, columnx integer, rowy integer, distancex integer, distancey integer, exclude_nodata_value boolean = true

albenard

c

public

_st_orderingequals

boolean

geometrya public.geometry, geometryb public.geometry

albenard

c

public

_st_overlaps

boolean

geom1 public.geometry, geom2 public.geometry

albenard

c

public

_st_overlaps

boolean

rast1 public.raster, nband1 integer, rast2 public.raster, nband2 integer

albenard

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

albenard

c

public

_st_pointoutside

public.geography

public.geography

albenard

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

albenard

c

public

_st_reclass

public.raster

rast public.raster, variadic reclassargset public.reclassarg []

albenard

c

public

_st_roughness4ma

double precision

value double precision [], pos integer [], variadic userargs text [] = NULL::text[]

albenard

plpgsql

public

_st_samealignment_finalfn

boolean

agg public.agg_samealignment

albenard

sql

public

_st_samealignment_transfn

public.agg_samealignment

agg public.agg_samealignment, rast public.raster

albenard

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

albenard

c

public

_st_slope4ma

double precision

value double precision [], pos integer [], variadic userargs text [] = NULL::text[]

albenard

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

albenard

c

public

_st_summarystats_transfn

pg_catalog.internal

pg_catalog.internal, public.raster, boolean, double precision

albenard

c

public

_st_summarystats_transfn

pg_catalog.internal

pg_catalog.internal, public.raster, integer, boolean

albenard

c

public

_st_summarystats_transfn

pg_catalog.internal

pg_catalog.internal, public.raster, integer, boolean, double precision

albenard

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

albenard

c

public

_st_touches

boolean

geom1 public.geometry, geom2 public.geometry

albenard

c

public

_st_touches

boolean

rast1 public.raster, nband1 integer, rast2 public.raster, nband2 integer

albenard

c

public

_st_tpi4ma

double precision

value double precision [], pos integer [], variadic userargs text [] = NULL::text[]

albenard

plpgsql

public

_st_tri4ma

double precision

value double precision [], pos integer [], variadic userargs text [] = NULL::text[]

albenard

plpgsql

public

_st_union_finalfn

public.raster

pg_catalog.internal

albenard

c

public

_st_union_transfn

pg_catalog.internal

pg_catalog.internal, public.raster

albenard

c

public

_st_union_transfn

pg_catalog.internal

pg_catalog.internal, public.raster, integer

albenard

c

public

_st_union_transfn

pg_catalog.internal

pg_catalog.internal, public.raster, integer, text

albenard

c

public

_st_union_transfn

pg_catalog.internal

pg_catalog.internal, public.raster, public.unionarg []

albenard

c

public

_st_union_transfn

pg_catalog.internal

pg_catalog.internal, public.raster, text

albenard

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_voronoi

public.geometry

g1 public.geometry, clip public.geometry = NULL::geometry, tolerance double precision = 0.0, return_polygons boolean = true

postgres

c

public

_st_within

boolean

geom1 public.geometry, geom2 public.geometry

albenard

sql

public

_st_within

boolean

rast1 public.raster, nband1 integer, rast2 public.raster, nband2 integer

albenard

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

albenard

c

public

_updaterastersrid

boolean

schema_name name, table_name name, column_name name, new_srid integer

albenard

plpgsql

public

addauth

boolean

text

albenard

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

albenard

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

albenard

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

albenard

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

albenard

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

albenard

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 []

albenard

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

albenard

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 []

albenard

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

albenard

c

public

box2df_out

pg_catalog.cstring

public.box2df

albenard

c

public

box3d

public.box3d

public.raster

albenard

sql

public

bytea

bytea

public.geography

albenard

c

public

bytea

bytea

public.raster

albenard

c

public

cash_dist

money

money, money

albenard

c

public

checkauth

integer

text, text

albenard

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

albenard

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

albenard

c

public

contains_2d

boolean

public.box2df, public.box2df

postgres

c

public

contains_2d

boolean

public.box2df, public.geometry

postgres

c

public

contains_2d

boolean

public.geometry, public.box2df

postgres

sql

public

date_dist

integer

date, date

albenard

c

public

disablelongtransactions

text

albenard

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

albenard

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

albenard

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

albenard

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

albenard

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

albenard

sql

args: schema_name, table_name - Drops a table and all its references in geometry_columns.

public

dropgeometrytable

text

table_name varchar

albenard

sql

args: table_name - Drops a table and all its references in geometry_columns.

public

dropoverviewconstraints

boolean

ovschema name, ovtable name, ovcolumn name

albenard

plpgsql

args: ovschema, ovtable, ovcolumn - Untag a raster column from being an overview of another.

public

dropoverviewconstraints

boolean

ovtable name, ovcolumn name

albenard

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

albenard

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 []

albenard

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

albenard

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 []

albenard

sql

public

enablelongtransactions

text

albenard

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

albenard

c

public

float4_dist

real

real, real

albenard

c

public

float8_dist

double precision

double precision, double precision

albenard

c

public

gbt_bit_consistent

boolean

pg_catalog.internal, bit, smallint, oid, pg_catalog.internal

albenard

c

public

gbt_bpchar_consistent

boolean

pg_catalog.internal, char, smallint, oid, pg_catalog.internal

albenard

c

public

gbt_bytea_consistent

boolean

pg_catalog.internal, bytea, smallint, oid, pg_catalog.internal

albenard

c

public

gbt_cash_consistent

boolean

pg_catalog.internal, money, smallint, oid, pg_catalog.internal

albenard

c

public

gbt_cash_distance

double precision

pg_catalog.internal, money, smallint, oid

albenard

c

public

gbt_cash_fetch

pg_catalog.internal

pg_catalog.internal

albenard

c

public

gbt_date_consistent

boolean

pg_catalog.internal, date, smallint, oid, pg_catalog.internal

albenard

c

public

gbt_date_distance

double precision

pg_catalog.internal, date, smallint, oid

albenard

c

public

gbt_date_fetch

pg_catalog.internal

pg_catalog.internal

albenard

c

public

gbt_float4_consistent

boolean

pg_catalog.internal, real, smallint, oid, pg_catalog.internal

albenard

c

public

gbt_float4_distance

double precision

pg_catalog.internal, real, smallint, oid

albenard

c

public

gbt_float4_fetch

pg_catalog.internal

pg_catalog.internal

albenard

c

public

gbt_float8_consistent

boolean

pg_catalog.internal, double precision, smallint, oid, pg_catalog.internal

albenard

c

public

gbt_float8_distance

double precision

pg_catalog.internal, double precision, smallint, oid

albenard

c

public

gbt_float8_fetch

pg_catalog.internal

pg_catalog.internal

albenard

c

public

gbt_inet_consistent

boolean

pg_catalog.internal, inet, smallint, oid, pg_catalog.internal

albenard

c

public

gbt_int2_consistent

boolean

pg_catalog.internal, smallint, smallint, oid, pg_catalog.internal

albenard

c

public

gbt_int2_distance

double precision

pg_catalog.internal, smallint, smallint, oid

albenard

c

public

gbt_int2_fetch

pg_catalog.internal

pg_catalog.internal

albenard

c

public

gbt_int4_consistent

boolean

pg_catalog.internal, integer, smallint, oid, pg_catalog.internal

albenard

c

public

gbt_int4_distance

double precision

pg_catalog.internal, integer, smallint, oid

albenard

c

public

gbt_int4_fetch

pg_catalog.internal

pg_catalog.internal

albenard

c

public

gbt_int8_consistent

boolean

pg_catalog.internal, bigint, smallint, oid, pg_catalog.internal

albenard

c

public

gbt_int8_distance

double precision

pg_catalog.internal, bigint, smallint, oid

albenard

c

public

gbt_int8_fetch

pg_catalog.internal

pg_catalog.internal

albenard

c

public

gbt_intv_consistent

boolean

pg_catalog.internal, interval, smallint, oid, pg_catalog.internal

albenard

c

public

gbt_intv_distance

double precision

pg_catalog.internal, interval, smallint, oid

albenard

c

public

gbt_intv_fetch

pg_catalog.internal

pg_catalog.internal

albenard

c

public

gbt_macad_consistent

boolean

pg_catalog.internal, macaddr, smallint, oid, pg_catalog.internal

albenard

c

public

gbt_macad_fetch

pg_catalog.internal

pg_catalog.internal

albenard

c

public

gbt_numeric_consistent

boolean

pg_catalog.internal, numeric, smallint, oid, pg_catalog.internal

albenard

c

public

gbt_oid_consistent

boolean

pg_catalog.internal, oid, smallint, oid, pg_catalog.internal

albenard

c

public

gbt_oid_distance

double precision

pg_catalog.internal, oid, smallint, oid

albenard

c

public

gbt_oid_fetch

pg_catalog.internal

pg_catalog.internal

albenard

c

public

gbt_text_consistent

boolean

pg_catalog.internal, text, smallint, oid, pg_catalog.internal

albenard

c

public

gbt_time_consistent

boolean

pg_catalog.internal, time, smallint, oid, pg_catalog.internal

albenard

c

public

gbt_time_distance

double precision

pg_catalog.internal, time, smallint, oid

albenard

c

public

gbt_time_fetch

pg_catalog.internal

pg_catalog.internal

albenard

c

public

gbt_timetz_consistent

boolean

pg_catalog.internal, timetz, smallint, oid, pg_catalog.internal

albenard

c

public

gbt_ts_consistent

boolean

pg_catalog.internal, timestamp, smallint, oid, pg_catalog.internal

albenard

c

public

gbt_ts_distance

double precision

pg_catalog.internal, timestamp, smallint, oid

albenard

c

public

gbt_ts_fetch

pg_catalog.internal

pg_catalog.internal

albenard

c

public

gbt_tstz_consistent

boolean

pg_catalog.internal, timestamptz, smallint, oid, pg_catalog.internal

albenard

c

public

gbt_tstz_distance

double precision

pg_catalog.internal, timestamptz, smallint, oid

albenard

c

public

gbt_var_fetch

pg_catalog.internal

pg_catalog.internal

albenard

c

public

geog_brin_inclusion_add_value

boolean

pg_catalog.internal, pg_catalog.internal, pg_catalog.internal, pg_catalog.internal

postgres

c

public

geography

public.geography

bytea

albenard

c

public

geography

public.geography

public.geography, integer, boolean

albenard

c

public

geography

public.geography

public.geometry

albenard

c

public

geography_analyze

boolean

pg_catalog.internal

albenard

c

public

geography_cmp

integer

public.geography, public.geography

albenard

c

public

geography_distance_knn

double precision

public.geography, public.geography

albenard

c

public

geography_eq

boolean

public.geography, public.geography

albenard

c

public

geography_ge

boolean

public.geography, public.geography

albenard

c

public

geography_gist_compress

pg_catalog.internal

pg_catalog.internal

albenard

c

public

geography_gist_consistent

boolean

pg_catalog.internal, public.geography, integer

albenard

c

public

geography_gist_decompress

pg_catalog.internal

pg_catalog.internal

albenard

c

public

geography_gist_distance

double precision

pg_catalog.internal, public.geography, integer

albenard

c

public

geography_gist_penalty

pg_catalog.internal

pg_catalog.internal, pg_catalog.internal, pg_catalog.internal

albenard

c

public

geography_gist_picksplit

pg_catalog.internal

pg_catalog.internal, pg_catalog.internal

albenard

c

public

geography_gist_same

pg_catalog.internal

public.box2d, public.box2d, pg_catalog.internal

albenard

c

public

geography_gist_union

pg_catalog.internal

bytea, pg_catalog.internal

albenard

c

public

geography_gt

boolean

public.geography, public.geography

albenard

c

public

geography_in

public.geography

pg_catalog.cstring, oid, integer

albenard

c

public

geography_le

boolean

public.geography, public.geography

albenard

c

public

geography_lt

boolean

public.geography, public.geography

albenard

c

public

geography_out

pg_catalog.cstring

public.geography

albenard

c

public

geography_overlaps

boolean

public.geography, public.geography

albenard

c

public

geography_recv

public.geography

pg_catalog.internal, oid, integer

albenard

c

public

geography_send

bytea

public.geography

albenard

c

public

geography_typmod_in

integer

pg_catalog.cstring []

albenard

c

public

geography_typmod_out

pg_catalog.cstring

integer

albenard

c

public

geom2d_brin_inclusion_add_value

boolean

pg_catalog.internal, pg_catalog.internal, pg_catalog.internal, pg_catalog.internal

postgres

c

public

geom3d_brin_inclusion_add_value

boolean

pg_catalog.internal, pg_catalog.internal, pg_catalog.internal, pg_catalog.internal

postgres

c

public

geom4d_brin_inclusion_add_value

boolean

pg_catalog.internal, pg_catalog.internal, pg_catalog.internal, pg_catalog.internal

postgres

c

public

geometry

public.geometry

path

albenard

c

public

geometry

public.geometry

point

albenard

c

public

geometry

public.geometry

polygon

albenard

c

public

geometry

public.geometry

public.geography

albenard

c

public

geometry

public.geometry

public.geometry, integer, boolean

albenard

c

public

geometry_above

boolean

geom1 public.geometry, geom2 public.geometry

albenard

c

public

geometry_below

boolean

geom1 public.geometry, geom2 public.geometry

albenard

c

public

geometry_cmp

integer

geom1 public.geometry, geom2 public.geometry

albenard

c

public

geometry_contained_by_raster

boolean

public.geometry, public.raster

albenard

sql

public

geometry_contains

boolean

geom1 public.geometry, geom2 public.geometry

albenard

c

public

geometry_distance_box

double precision

geom1 public.geometry, geom2 public.geometry

albenard

c

public

geometry_distance_centroid

double precision

geom1 public.geometry, geom2 public.geometry

albenard

c

public

geometry_distance_centroid_nd

double precision

public.geometry, public.geometry

albenard

c

public

geometry_distance_cpa

double precision

public.geometry, public.geometry

albenard

c

public

geometry_eq

boolean

geom1 public.geometry, geom2 public.geometry

albenard

c

public

geometry_ge

boolean

geom1 public.geometry, geom2 public.geometry

albenard

c

public

geometry_gist_compress_2d

pg_catalog.internal

pg_catalog.internal

albenard

c

public

geometry_gist_compress_nd

pg_catalog.internal

pg_catalog.internal

albenard

c

public

geometry_gist_consistent_2d

boolean

pg_catalog.internal, public.geometry, integer

albenard

c

public

geometry_gist_consistent_nd

boolean

pg_catalog.internal, public.geometry, integer

albenard

c

public

geometry_gist_decompress_2d

pg_catalog.internal

pg_catalog.internal

albenard

c

public

geometry_gist_decompress_nd

pg_catalog.internal

pg_catalog.internal

albenard

c

public

geometry_gist_distance_2d

double precision

pg_catalog.internal, public.geometry, integer

albenard

c

public

geometry_gist_distance_nd

double precision

pg_catalog.internal, public.geometry, integer

albenard

c

public

geometry_gist_penalty_2d

pg_catalog.internal

pg_catalog.internal, pg_catalog.internal, pg_catalog.internal

albenard

c

public

geometry_gist_penalty_nd

pg_catalog.internal

pg_catalog.internal, pg_catalog.internal, pg_catalog.internal

albenard

c

public

geometry_gist_picksplit_2d

pg_catalog.internal

pg_catalog.internal, pg_catalog.internal

albenard

c

public

geometry_gist_picksplit_nd

pg_catalog.internal

pg_catalog.internal, pg_catalog.internal

albenard

c

public

geometry_gist_same_2d

pg_catalog.internal

geom1 public.geometry, geom2 public.geometry, pg_catalog.internal

albenard

c

public

geometry_gist_same_nd

pg_catalog.internal

public.geometry, public.geometry, pg_catalog.internal

albenard

c

public

geometry_gist_union_2d

pg_catalog.internal

bytea, pg_catalog.internal

albenard

c

public

geometry_gist_union_nd

pg_catalog.internal

bytea, pg_catalog.internal

albenard

c

public

geometry_gt

boolean

geom1 public.geometry, geom2 public.geometry

albenard

c

public

geometry_le

boolean

geom1 public.geometry, geom2 public.geometry

albenard

c

public

geometry_left

boolean

geom1 public.geometry, geom2 public.geometry

albenard

c

public

geometry_lt

boolean

geom1 public.geometry, geom2 public.geometry

albenard

c

public

geometry_overabove

boolean

geom1 public.geometry, geom2 public.geometry

albenard

c

public

geometry_overbelow

boolean

geom1 public.geometry, geom2 public.geometry

albenard

c

public

geometry_overlaps

boolean

geom1 public.geometry, geom2 public.geometry

albenard

c

public

geometry_overlaps_nd

boolean

public.geometry, public.geometry

albenard

c

public

geometry_overleft

boolean

geom1 public.geometry, geom2 public.geometry

albenard

c

public

geometry_overright

boolean

geom1 public.geometry, geom2 public.geometry

albenard

c

public

geometry_raster_contain

boolean

public.geometry, public.raster

albenard

sql

public

geometry_raster_overlap

boolean

public.geometry, public.raster

albenard

sql

public

geometry_right

boolean

geom1 public.geometry, geom2 public.geometry

albenard

c

public

geometry_same

boolean

geom1 public.geometry, geom2 public.geometry

albenard

c

public

geometry_typmod_in

integer

pg_catalog.cstring []

albenard

c

public

geometry_typmod_out

pg_catalog.cstring

integer

albenard

c

public

geometry_within

boolean

geom1 public.geometry, geom2 public.geometry

albenard

c

public

geometrytype

text

public.geography

albenard

c

public

gettransactionid

pg_catalog.xid

albenard

c

public

gidx_in

public.gidx

pg_catalog.cstring

albenard

c

public

gidx_out

pg_catalog.cstring

public.gidx

albenard

c

public

gserialized_gist_joinsel_2d

double precision

pg_catalog.internal, oid, pg_catalog.internal, smallint

albenard

c

public

gserialized_gist_joinsel_nd

double precision

pg_catalog.internal, oid, pg_catalog.internal, smallint

albenard

c

public

gserialized_gist_sel_2d

double precision

pg_catalog.internal, oid, pg_catalog.internal, integer

albenard

c

public

gserialized_gist_sel_nd

double precision

pg_catalog.internal, oid, pg_catalog.internal, integer

albenard

c

public

int2_dist

smallint

smallint, smallint

albenard

c

public

int4_dist

integer

integer, integer

albenard

c

public

int8_dist

bigint

bigint, bigint

albenard

c

public

interval_dist

interval

interval, interval

albenard

c

public

is_contained_2d

boolean

public.box2df, public.box2df

postgres

c

public

is_contained_2d

boolean

public.box2df, public.geometry

postgres

c

public

is_contained_2d

boolean

public.geometry, public.box2df

postgres

sql

public

lockrow

integer

text, text, text

albenard

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

albenard

sql

public

lockrow

integer

text, text, text, text, timestamp

albenard

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

albenard

sql

args: a_table_name, a_row_key, an_auth_token, expire_dt - Set lock/authorization for specific row in table

public

longtransactionsenabled

boolean

albenard

plpgsql

public

oid_dist

oid

oid, oid

albenard

c

public

overlaps_2d

boolean

public.box2df, public.box2df

postgres

c

public

overlaps_2d

boolean

public.box2df, public.geometry

postgres

c

public

overlaps_2d

boolean

public.geometry, public.box2df

postgres

sql

public

overlaps_geog

boolean

public.geography, public.gidx

postgres

sql

public

overlaps_geog

boolean

public.gidx, public.geography

postgres

c

public

overlaps_geog

boolean

public.gidx, public.gidx

postgres

c

public

overlaps_nd

boolean

public.geometry, public.gidx

postgres

sql

public

overlaps_nd

boolean

public.gidx, public.geometry

postgres

c

public

overlaps_nd

boolean

public.gidx, public.gidx

postgres

c

public

path

path

public.geometry

albenard

c

public

pgis_abs_in

public.pgis_abs

pg_catalog.cstring

albenard

c

public

pgis_abs_out

pg_catalog.cstring

public.pgis_abs

albenard

c

public

pgis_geometry_accum_finalfn

public.geometry []

public.pgis_abs

albenard

c

public

pgis_geometry_accum_transfn

public.pgis_abs

public.pgis_abs, public.geometry

albenard

c

public

pgis_geometry_accum_transfn

public.pgis_abs

public.pgis_abs, public.geometry, double precision

albenard

c

public

pgis_geometry_accum_transfn

public.pgis_abs

public.pgis_abs, public.geometry, double precision, integer

postgres

c

public

pgis_geometry_clusterintersecting_finalfn

public.geometry []

public.pgis_abs

albenard

c

public

pgis_geometry_clusterwithin_finalfn

public.geometry []

public.pgis_abs

albenard

c

public

pgis_geometry_collect_finalfn

public.geometry

public.pgis_abs

albenard

c

public

pgis_geometry_makeline_finalfn

public.geometry

public.pgis_abs

albenard

c

public

pgis_geometry_polygonize_finalfn

public.geometry

public.pgis_abs

albenard

c

public

pgis_geometry_union_finalfn

public.geometry

public.pgis_abs

albenard

c

public

point

point

public.geometry

albenard

c

public

polygon

polygon

public.geometry

albenard

c

public

populate_geometry_columns

integer

tbl_oid oid, use_typmod boolean = true

albenard

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

albenard

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

albenard

c

args: geomA - Add bounding box to the geometry.

public

postgis_cache_bbox

trigger

albenard

c

public

postgis_constraint_dims

integer

geomschema text, geomtable text, geomcolumn text

albenard

sql

public

postgis_constraint_srid

integer

geomschema text, geomtable text, geomcolumn text

albenard

sql

public

postgis_constraint_type

varchar

geomschema text, geomtable text, geomcolumn text

albenard

sql

public

postgis_dropbbox

public.geometry

public.geometry

albenard

c

args: geomA - Drop the bounding box cache from the geometry.

public

postgis_gdal_version

text

albenard

c

Reports the version of the GDAL library in use by PostGIS.

public

postgis_getbbox

public.box2d

public.geometry

albenard

c

public

postgis_hasbbox

boolean

public.geometry

albenard

c

args: geomA - Returns TRUE if the bbox of this geometry is cached, FALSE otherwise.

public

postgis_libjson_version

text

albenard

c

public

postgis_liblwgeom_version

text

albenard

c

public

postgis_libxml_version

text

albenard

c

Returns the version number of the libxml2 library.

public

postgis_noop

public.geometry

public.geometry

albenard

c

public

postgis_noop

public.geometry

public.raster

albenard

c

public

postgis_raster_lib_build_date

text

albenard

c

Reports full raster library build date.

public

postgis_raster_lib_version

text

albenard

c

Reports full raster version and build configuration infos.

public

postgis_raster_scripts_installed

text

albenard

sql

public

postgis_svn_version

text

albenard

c

public

postgis_transform_geometry

public.geometry

public.geometry, text, text, integer

albenard

c

public

postgis_type_name

varchar

geomname varchar, coord_dimension integer, use_new_name boolean = true

albenard

sql

public

postgis_typmod_dims

integer

integer

albenard

c

public

postgis_typmod_srid

integer

integer

albenard

c

public

postgis_typmod_type

text

integer

albenard

c

public

ps_insert_affectation

boolean

pjt_id integer, rob_id integer, date_debut date, chemin_fic_ano varchar, nom_fic_ano varchar, date_fin date

postgres

plpgsql

Cette fonction crée un enregistrement dans la table t_affectation_aff en s'occupant de générer le champ aff_periode de type daterange

public

ps_maj_emplacement

boolean

nom_projet varchar

postgres

plpgsql

Cette fonction analyse tous les mouvements de plants (pour un projet donné) et reconstruit les différents emplacements (associant un plant à une palette d'un robot pour une période donnée).
Elle met à null le champ dat_plt_id de toutes les données issues des fichiers du projet puis tente pour chacune de ces données de trouver le plant à rattacher et effectue la mise à jour.

public

ps_maj_specificite

boolean

prefix_robot varchar, nom_projet varchar

postgres

plpgsql

Cette fonction utilise le contenue de la table contenant les anomalies pour le couple robot/projet passé en paramètre afin de positionner des indicateurs qui permettront de corriger les variables calculées si besoin.

public

ps_maj_variables_corrigees

boolean

nom_projet varchar

postgres

plpgsql

Cette fonction traite les données pour un projet précisé en paramètre.
Elle met à jour les variables corrigées WA_corrige, TA_corrige, TDIFF_corrige et TR_corrige de la table t_datarobot_dat en tenant compte de la présence / absence des plants sur le robot ainsi que des arrosages et apport de poids hors robot.

public

ps_maj_variables_data_brutes

boolean

date_deb date, date_fin date, nom_projet varchar

postgres

plpgsql

Cette fonction traite les données brutes sur une période donnée en paramètre pour le projet précisé en paramètre.
Elle met à jour les variables WA, TA, TDIFF et TR de la table t_datarobot_dat en tenant compte uniquement des données brutes (poids avant et après et horodatage).
Les variables corrigées seront alimentées par une autre fonction après exploitation de la table des spécificités concernée.
Si besoin le traitement des mouvements de plants est lancé puis l'ensemble des variables brutes est réinitialisé / recalculé pour l'ensemble du projet.

public

raster_above

boolean

public.raster, public.raster

albenard

sql

public

raster_below

boolean

public.raster, public.raster

albenard

sql

public

raster_contain

boolean

public.raster, public.raster

albenard

sql

public

raster_contained

boolean

public.raster, public.raster

albenard

sql

public

raster_contained_by_geometry

boolean

public.raster, public.geometry

albenard

sql

public

raster_eq

boolean

public.raster, public.raster

albenard

sql

public

raster_geometry_contain

boolean

public.raster, public.geometry

albenard

sql

public

raster_geometry_overlap

boolean

public.raster, public.geometry

albenard

sql

public

raster_hash

integer

public.raster

albenard

internal

public

raster_in

public.raster

pg_catalog.cstring

albenard

c

public

raster_left

boolean

public.raster, public.raster

albenard

sql

public

raster_out

pg_catalog.cstring

public.raster

albenard

c

public

raster_overabove

boolean

public.raster, public.raster

albenard

sql

public

raster_overbelow

boolean

public.raster, public.raster

albenard

sql

public

raster_overlap

boolean

public.raster, public.raster

albenard

sql

public

raster_overleft

boolean

public.raster, public.raster

albenard

sql

public

raster_overright

boolean

public.raster, public.raster

albenard

sql

public

raster_right

boolean

public.raster, public.raster

albenard

sql

public

raster_same

boolean

public.raster, public.raster

albenard

sql

public

st_3dclosestpoint

public.geometry

geom1 public.geometry, geom2 public.geometry

albenard

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

albenard

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

albenard

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

albenard

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

albenard

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

albenard

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

albenard

sql

public

st_3dlongestline

public.geometry

geom1 public.geometry, geom2 public.geometry

albenard

c

args: g1, g2 - Returns the 3-dimensional longest line between two geometries

public

st_3dmakebox

public.box3d

geom1 public.geometry, geom2 public.geometry

albenard

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

albenard

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

albenard

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

albenard

c

args: g1, g2 - Returns the 3-dimensional shortest line between two geometries

public

st_addband

public.raster

rast public.raster, addbandargset public.addbandarg []

albenard

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

albenard

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

albenard

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

albenard

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

albenard

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

albenard

c

args: linestring, point - Add a point to a LineString.

public

st_addpoint

public.geometry

geom1 public.geometry, geom2 public.geometry, integer

albenard

c

args: linestring, point, position - Add a point to a LineString.

public

st_affine

public.geometry

public.geometry, double precision, double precision, double precision, double precision, double precision, double precision

albenard

sql

args: geomA, a, b, d, e, xoff, yoff - Apply a 3d affine transformation to a geometry.

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

albenard

c

args: geomA, a, b, c, d, e, f, g, h, i, xoff, yoff, zoff - Apply a 3d affine transformation to a geometry.

public

st_approxcount

bigint

rast public.raster, exclude_nodata_value boolean, sample_percent double precision = 0.1

albenard

sql

public

st_approxcount

bigint

rast public.raster, nband integer = 1, exclude_nodata_value boolean = true, sample_percent double precision = 0.1

albenard

sql

public

st_approxcount

bigint

rast public.raster, nband integer, sample_percent double precision

albenard

sql

public

st_approxcount

bigint

rast public.raster, sample_percent double precision

albenard

sql

public

st_approxcount

bigint

rastertable text, rastercolumn text, exclude_nodata_value boolean, sample_percent double precision = 0.1

albenard

sql

public

st_approxcount

bigint

rastertable text, rastercolumn text, nband integer = 1, exclude_nodata_value boolean = true, sample_percent double precision = 0.1

albenard

sql

public

st_approxcount

bigint

rastertable text, rastercolumn text, nband integer, sample_percent double precision

albenard

sql

public

st_approxcount

bigint

rastertable text, rastercolumn text, sample_percent double precision

albenard

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

albenard

sql

public

st_approxquantile

double precision

rast public.raster, nband integer, exclude_nodata_value boolean, sample_percent double precision, quantile double precision

albenard

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

albenard

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

albenard

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

albenard

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

albenard

sql

public

st_approxquantile

double precision

rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, sample_percent double precision, quantile double precision

albenard

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

albenard

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

albenard

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

albenard

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

albenard

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

albenard

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

albenard

sql

public

st_area2d

double precision

public.geometry

albenard

c

public

st_asbinary

bytea

public.geography

albenard

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

albenard

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

albenard

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

albenard

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

albenard

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

albenard

c

args: geom, precision=5 - Returns an Encoded Polyline from a LineString geometry.

public

st_asewkb

bytea

public.geometry

albenard

c

args: g1 - Return the Well-Known Binary (WKB) representation of the geometry with SRID meta data.

public

st_asewkb

bytea

public.geometry, text

albenard

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

albenard

c

args: g1 - Return the Well-Known Text (WKT) representation of the geometry with SRID meta data.

public

st_asewkt

text

public.geometry

albenard

c

args: g1 - Return the Well-Known Text (WKT) representation of the geometry with SRID meta data.

public

st_asewkt

text

text

albenard

sql

public

st_asgdalraster

bytea

rast public.raster, format text, options text [] = NULL::text[], srid integer = NULL::integer

albenard

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.