Routines
| Name | Type | Language | Deterministic | Return Type | Security Restriction | Comments |
|---|---|---|---|---|---|---|
| manage_object_timestamps() | FUNCTION | plpgsql | false | trigger | INVOKER | |
| control_observation_editing_capability() | FUNCTION | plpgsql | false | trigger | INVOKER | |
| trg_after_import_validation() | FUNCTION | plpgsql | false | trigger | INVOKER | |
| get_series_data(series_id integer, add_geometry boolean) | FUNCTION | plpgsql | false | TABLE(id integer, spatial_object_code text, geom geometry, observation_start text, observation_end text, observation_start_timestamp timestamp without time zone, observation_end_timestamp timestamp without time zone, observation_values json, id_actor integer) | INVOKER | Get the given series observation data, with optional geometry. |
| trg_parse_indicator_paths() | FUNCTION | plpgsql | false | trigger | INVOKER | |
| find_observation_with_wrong_spatial_object(_id_series integer) | FUNCTION | plpgsql | false | TABLE(ob_uid uuid, so_unique_id text) | INVOKER | Find the observations with having incompatible start and end timestamp with related spatial objects validity dates |
| log_deleted_object() | FUNCTION | plpgsql | false | trigger | INVOKER | |
| update_observations_with_wrong_spatial_objects(_id_series integer) | FUNCTION | plpgsql | false | TABLE(modified_obs_count integer, remaining_obs_count integer) | INVOKER | Update observations with wrong spatial objects: it search the observation for which the start and end timestamp does not match anymore the related spatial objects validity dates. It gets the correct one if possible and perform an UPDATE for these observations. It returns a line with 2 integer columns: modified_obs_count (number of modified observations) and remaining_obs_count (number of observations still with wrong observations |
| update_spatial_object_end_validity() | FUNCTION | plpgsql | false | trigger | INVOKER | |
| parse_indicator_paths(i_id integer, i_path text) | FUNCTION | plpgsql | false | integer | INVOKER | |
| update_observation_on_spatial_object_change() | FUNCTION | plpgsql | false | trigger | INVOKER | |
| get_spatial_layer_vector_data(spatial_layer_id integer, validity_date date) | FUNCTION | plpgsql | false | TABLE(id integer, code text, label text, uid text, valid_from date, valid_to date, id_actor integer, geom geometry) | INVOKER | Get the spatial object vector data corresponding to the given spatial layer ID. A date can be given to restrict objects corresponding to this date. |