JSDoc: Schema: data

Specialized AI4SoilHealth data related objects

Tables

aggregate_region

Aggregate region

Name	Type	Description
`id`	integer
`soil_type_code`	character_varying
`key`	character_varying
`environmental_zone_id`	integer	foreign key to catalog.environmental_zone.id
`soil_type_id`	integer	foreign key to catalog.soil_type.id
`environmental_zone_code`	character_varying

aggregate_stability

Aggregate stability

Name	Type	Description
`observation_id`	integer	foreign key to data.observation.id
`id`	integer
`app_version`	character_varying
`aggregate_stability_index`	double_precision
`aggregate_stability_app_id`	integer	foreign key to catalog.aggregate_stability_app.id

asset

Assets from Open Environmental Data Cube

Name	Type	Description
`main_sld_url`	character_varying
`ignore_29feb`	boolean
`date_style_id`	integer	foreign key to catalog.date_style.id
`date_unit_id`	integer	foreign key to catalog.date_unit.id
`date_offset`	character_varying
`date_step`	integer
`end_date`	date
`start_date`	date
`gsd`	character_varying
`instruments_list`	character_varying
`platform`	character_varying
`constellation_list`	character_varying
`license_id`	integer	foreign key to catalog.license.id
`providers_list`	character_varying
`person_id`	integer	foreign key to auth.person.id
`scale_factor`	character_varying
`unit_id`	integer	foreign key to catalog.unit.id
`doi`	character_varying
`asset_version_id`	integer	foreign key to catalog.asset_version.id
`keywords_list`	character_varying
`color_map`	character_varying
`asset_theme_id`	integer	foreign key to catalog.asset_theme.id
`description`	character_varying
`title`	character_varying
`asset_catalog_id`	integer	foreign key to catalog.asset_catalog.id
`ignore`	boolean
`orig_id`	character_varying
`id`	integer
`no_data`	integer
`synonyms`	character_varying
`decimals`	integer
`indicator_id`	integer	foreign key to data.indicator.id
`main_url`	character_varying
`main_qml_url`	character_varying
`sld_1_url`	character_varying
`depth_list`	character_varying

attribute

Values for non numerical attributes of data sets.

Name	Type	Description
`id`	integer
`depth_id`	integer	foreign key to data.depth.id
`attribute_description_id`	integer	foreign key to data.attribute_description.id
`date`	date
`data_source_id`	integer	foreign key to data.data_source.id
`indicator_id`	integer	foreign key to data.indicator.id
`point_id`	integer	foreign key to data.point.id

attribute_description

Catalog of non numerical attributes of data sets.

Name	Type	Description
`indicator_id`	integer	foreign key to data.indicator.id
`id`	integer
`name`	character_varying
`color_id`	integer	foreign key to general.color.id
`code`	character_varying
`value`	integer

bioinformatic_treatment

Bioinformatic treatment

Name	Type	Description
`id`	integer
`url`	character_varying
`name`	character_varying

catalog

Catalog

Name	Type	Description
`unit`	integer
`id`	integer

cultivation

Cultivation

Name	Type	Description
`cultivation_season_end_date`	date
`main_crop_id`	integer	foreign key to catalog.crop.id
`catch_crop_id`	integer	foreign key to catalog.crop.id
`manure_fertilisation_kg_ha`	smallint
`main_yield_kg_ha`	smallint
`irrigation_mm`	smallint
`id`	integer
`point_id`	integer	foreign key to data.point.id
`pesticides_kg_ha`	smallint
`chemical_fertilisation_kg_ha`	smallint
`catch_yield_kg_ha`	smallint
`person_id`	integer	foreign key to auth.person.id
`start_date`	date
`end_date`	date
`perennial_crop`	boolean
`cultivation_year`	smallint
`cultivation_season_start_date`	date
`tillage`	boolean
`baresoil_over_whole_season`	boolean

custom_geometry

User points or polygons for soil health data collection.

Name	Type	Description
`time_modified`	timestamp_with_time_zone
`public`	boolean
`name`	character_varying
`geometry`	geometry
`person_id`	integer	foreign key to auth.person.id
`id`	integer
`time_created`	timestamp_with_time_zone

custom_geometry_file

Files attached to user points or polygons.

Name	Type	Description
`id`	integer
`time_modified`	timestamp_with_time_zone
`time_created`	timestamp_with_time_zone
`geometry`	geometry
`lat`	double_precision
`lon`	double_precision
`pitch`	integer
`compass`	integer
`mime_type`	character_varying
`extension`	character_varying
`name`	character_varying
`custom_geometry_id`	integer	foreign key to data.custom_geometry.id

custom_geometry_property

Properties of user points or polygons.

Name	Type	Description
`value`	character_varying
`id`	integer
`custom_geometry_time_id`	integer	foreign key to data.custom_geometry_time.id
`property_id`	integer	foreign key to data.property.id

custom_geometry_time

Points in time when properties of user points or polygons are collected.

Name	Type	Description
`custom_geometry_id`	integer	foreign key to data.custom_geometry.id
`id`	integer
`observation_time`	timestamp_with_time_zone

data_source

Catalog of data sources of measurements or attributes.

Name	Type	Description
`contact_person_id`	integer	foreign key to auth.person.id
`person_id`	integer	foreign key to auth.person.id
`public`	boolean
`name`	character_varying
`country_id`	integer	foreign key to general.country.id
`date_to`	date
`id`	integer
`srid`	integer
`description`	text
`url`	character_varying
`ai4soilhealth_pilot`	boolean
`date_from`	date

depth

Catalog of depths of measurements or attributes.

Name	Type	Description
`color_id`	integer	foreign key to general.color.id
`name`	character_varying
`id`	integer

edna

Edna

Name	Type	Description
`purification_id`	integer	foreign key to catalog.purification.id
`extraction_id`	integer	foreign key to catalog.extraction.id
`accession_url`	character_varying
`accession_code`	character_varying
`observation_id`	integer	foreign key to data.observation.id
`nucleotide_archive_id`	integer	foreign key to data.nucleotide_archive.id
`id`	integer
`sequencing_id`	integer	foreign key to catalog.sequencing.id
`amplification_id`	integer	foreign key to catalog.amplification.id

email_template

Email template

Name	Type	Description
`subject`	text
`id`	integer
`body`	text
`time_created`	timestamp_with_time_zone
`time_modified`	timestamp_with_time_zone

enzyme

Enzyme

Name	Type	Description
`id`	integer
`temperature`	double_precision
`observation_id`	integer	foreign key to data.observation.id

enzyme_item

Enzyme item

Name	Type	Description
`is_valid`	boolean
`id`	integer
`std_err`	double_precision
`enzyme_type_id`	integer	foreign key to catalog.enzyme_type.id
`pmol_min`	double_precision
`enzyme_id`	integer	foreign key to data.enzyme.id
`not_valid_reason`	character_varying

equipment

Equipment

Name	Type	Description
`model`	character_varying
`nickname`	character_varying
`person_id`	integer	foreign key to auth.person.id
`equipment_type_id`	integer	foreign key to catalog.equipment_type.id
`serial_number`	character_varying
`id`	integer
`brand_id`	integer	foreign key to catalog.brand.id

equipment_indicator

Equipment indicator

Name	Type	Description
`indicator_id`	integer	foreign key to data.indicator.id
`unit_id`	integer	foreign key to catalog.unit.id
`gain`	double_precision
`add`	double_precision
`id`	integer
`equipment_id`	integer	foreign key to data.equipment.id

field_boundary

Field boundary

Name	Type	Description
`determination_method`	character_varying
`ogc_fid`	integer
`id`	integer
`area`	real
`determination_datetime`	timestamp_with_time_zone
`planet:ca_ratio`	real
`planet:micd`	real
`planet:qa`	smallint
`geometry`	geometry
`crop_type_id`	integer

geometry

Geometries of sites.

Name	Type	Description
`id`	integer
`parent_id`	integer
`geom`	geometry
`geometry_type_id`	integer	foreign key to data.geometry_type.id
`properties`	json

geometry_statistics

Geometry statistics

Name	Type	Description
`n`	integer
`depth_id`	integer
`id`	integer
`parent_id`	integer
`indicator_id`	integer
`data_source_id`	integer
`min`	real
`max`	real
`mean`	real
`median`	real
`q1`	real
`q3`	real
`stdev`	real
`time_span`	character_varying
`geometry_type_id`	integer
`x`	Array.<real>
`y`	Array.<integer>

geometry_type

Catalog of types of custom geometries.

Name	Type	Description
`id`	integer
`name`	character_varying

image

Image

Name	Type	Description
`id`	integer
`file_name`	character_varying
`image_lightsource_id`	integer	foreign key to catalog.image_lightsource.id
`image_setup_id`	integer	foreign key to catalog.image_setup.id
`image_camera_id`	integer	foreign key to catalog.image_camera.id
`extension`	character_varying
`mime_type`	character_varying
`compass`	integer
`image_substrate_id`	integer	foreign key to catalog.image_substrate.id
`image_approach_id`	integer	foreign key to catalog.image_approach.id
`lon`	double_precision
`time_created`	timestamp_with_time_zone
`time_modified`	timestamp_with_time_zone
`pitch`	integer
`sample_id`	integer	foreign key to data.sample.id
`simple_observation_id`	integer	foreign key to data.simple_observation.id
`name`	character_varying
`lat`	double_precision

import_procedure

Utility table to enable different imports

Name	Type	Description
`data_source_id`	integer	foreign key to data.data_source.id
`proc_name`	character_varying
`id`	integer
`sheet`	character_varying
`date`	date
`preprocess`	character_varying

indicator

Catalog of AI4SoilHealth data indicators.

Name	Type	Description
`value_to`	real
`id`	integer
`display_name`	character_varying
`unit_id`	integer	foreign key to catalog.unit.id
`lod`	character_varying
`name`	character_varying
`decimals_for_stats`	integer
`decimals_for_display`	integer
`numerical`	boolean
`value_from`	real
`data_type_id`	integer
`simple_observation`	boolean
`description`	character_varying

indicator_color

Coloring scheme of AI4SoilHealth data indicators depending on value.

Name	Type	Description
`color_id`	integer	foreign key to general.color.id
`id`	integer
`indicator_id`	integer	foreign key to data.indicator.id
`value_to`	real

indicator_lang

Translations of AI4SoilHealth data indicators.

Name	Type	Description
`value`	character_varying
`id`	integer
`indicator_id`	integer	foreign key to data.indicator.id
`lang_id`	integer	foreign key to meta.lang.id

infiltration

Infiltration

Name	Type	Description
`soil_moisture_after_infiltration`	double_precision
`observation_id`	integer	foreign key to data.observation.id
`saturated_conductivity`	real
`field_capacity`	real
`wilting_point`	real
`water_content`	real
`water_potential`	real
`soil_moisture_method_id`	integer	foreign key to catalog.soil_moisture_method.id
`id`	integer
`unit_volume`	integer
`ring_diameter`	double_precision

infiltration_time

Infiltration time

Name	Type	Description
`infiltration_id`	integer	foreign key to data.infiltration.id
`order_no`	smallint
`duration`	smallint
`id`	integer

lab_analysis_method

Lab analysis method

Name	Type	Description
`fao_standard_id`	integer	foreign key to catalog.fao_standard.id
`name`	character_varying
`id`	integer
`usda_standard_id`	integer	foreign key to catalog.usda_standard.id

lab_analysis_method_indicator

Lab analysis method indicator

Name	Type	Description
`indicator_id`	integer	foreign key to data.indicator.id
`lab_analysis_method_id`	integer	foreign key to data.lab_analysis_method.id
`id`	integer
`unit_id`	integer	foreign key to catalog.unit.id

laboratory

Laboratory

Name	Type	Description
`contact`	character_varying
`id`	integer
`name`	character_varying
`address`	character_varying
`country_id`	integer	foreign key to general.country.id
`url`	character_varying

land_use_boundary

Land use boundary

Name	Type	Description
`geometry`	geometry
`ogc_fid`	integer
`dn`	integer

land_use_cover

Land use cover

Name	Type	Description
`id`	integer
`managed`	boolean
`organic_farming`	boolean
`protected`	boolean
`land_usage_detail_id`	integer
`point_id`	integer	foreign key to data.point.id

landscape

Landscape

Name	Type	Description
`comment`	text
`id`	integer
`point_id`	integer	foreign key to data.point.id
`date_stamp`	date
`downward_slope`	smallint
`upward_slope`	smallint
`distance_to_drainage_m`	smallint
`person_id`	integer	foreign key to auth.person.id
`hillslope_position_id`	integer	foreign key to catalog.hillslope_position.id
`major_landform_id`	integer	foreign key to catalog.major_landform.id

logistic

Logistic

Name	Type	Description
`preservation_id`	integer	foreign key to catalog.preservation.id
`transport_id`	integer	foreign key to catalog.transport.id
`transport_duration_h`	smallint
`storage_id`	integer	foreign key to catalog.storage.id
`storage_duration_h`	smallint
`person_id`	integer	foreign key to auth.person.id
`observation_type_id`	integer	foreign key to catalog.observation_type.id
`id`	integer
`observation_id`	integer	foreign key to data.observation.id

macrofauna

Macrofauna

Name	Type	Description
`weight`	double_precision
`id`	integer
`observation_id`	integer	foreign key to data.observation.id
`extraction_method_id`	integer	foreign key to catalog.extraction_method.id
`monolith_id`	integer	foreign key to catalog.monolith.id
`taxa_id`	integer	foreign key to data.taxa.id
`layer_id`	integer	foreign key to catalog.layer.id
`life_cycle_stage_id`	integer	foreign key to catalog.life_cycle_stage.id
`specimen_quantity`	integer
`monolith_top`	integer
`monolith_bottom`	integer
`person_id`	integer	foreign key to auth.person.id
`excavation_tool_id`	integer	foreign key to catalog.macrofauna_excavation_tool.id

measurement

Values of numerical measurements.

Name	Type	Description
`lod`	character
`depth_id`	integer	foreign key to data.depth.id
`data_source_id`	integer	foreign key to data.data_source.id
`date`	date
`id`	integer
`indicator_id`	integer	foreign key to data.indicator.id
`value`	real
`point_id`	integer	foreign key to data.point.id

method_transformation

Method transformation

Name	Type	Description
`transformation`	character_varying
`lab_analysis_method_to_id`	integer	foreign key to data.lab_analysis_method.id
`lab_analysis_method_from_id`	integer	foreign key to data.lab_analysis_method.id
`id`	integer

microbiometer

Microbiometer

Name	Type	Description
`carbon_content`	double_precision
`observation_id`	integer	foreign key to data.observation.id
`bacteria`	smallint
`fungi`	smallint
`id`	integer

nucleotide_archive

Nucleotide archive

Name	Type	Description
`database_name`	character_varying
`proprietor_id`	integer	foreign key to catalog.proprietor.id
`info`	character_varying
`url`	character_varying
`id`	integer

observation

Observation

Name	Type	Description
`repeat`	smallint
`equipment_id`	integer	foreign key to data.equipment.id
`laboratory_id`	integer	foreign key to data.laboratory.id
`comment`	character_varying
`sample_preparation_id`	integer	foreign key to catalog.sample_preparation.id
`date_stamp`	timestamp_with_time_zone
`observation_type_id`	integer	foreign key to catalog.observation_type.id
`id`	integer
`sample_id`	integer	foreign key to data.sample.id
`subsample`	character_varying
`person_id`	integer	foreign key to auth.person.id

observation_measurement

Observation measurement

Name	Type	Description
`std_dev`	real
`value`	real
`indicator_id`	integer	foreign key to data.indicator.id
`observation_id`	integer	foreign key to data.observation.id
`id`	integer
`person_id`	integer	foreign key to auth.person.id
`unit_id`	integer	foreign key to catalog.unit.id
`date_stamp`	timestamp_with_time_zone
`lab_analysis_method_id`	integer	foreign key to data.lab_analysis_method.id

point

Points where measurements were taken orr attributes recorded.

Name	Type	Description
`lon`	double_precision
`lat`	double_precision
`point_key`	character_varying
`id`	integer
`geom`	geometry
`soil_class_id`	integer	foreign key to catalog.soil_class.id
`person_id`	integer	foreign key to auth.person.id
`point_abandoned`	date
`elev`	integer
`name`	character_varying
`x`	double_precision
`y`	double_precision
`site_id`	integer	foreign key to data.site.id
`position_error`	double_precision
`sample`	integer
`data_source_id`	integer	foreign key to data.data_source.id
`notes`	character_varying
`l3_id`	integer	foreign key to general.nuts.id

point_state

Point state

Name	Type	Description
`lichen_moss_presence`	boolean
`id`	integer
`sampling_log_id`	integer	foreign key to data.sampling_log.id
`tree_presence`	boolean
`shrub_presence`	boolean
`graminoid_presence`	boolean
`forb_presence`	boolean
`crop_growth_stage_id`	integer	foreign key to catalog.crop_growth_stage.id
`visible_sheet_erosion`	boolean
`visible_rill_erosion`	boolean
`visible_gully_erosion`	boolean
`visible_wind_erosion`	boolean
`erosion_measure_id`	integer	foreign key to catalog.erosion_conservation_measure.id
`rock_cover_percent`	smallint
`stone_cover_percent`	smallint
`gravel_cover_percent`	smallint
`bare_rock_presence`	boolean

prediction_model

Prediction model

Name	Type	Description
`method`	character_varying
`indicator_id`	integer
`id`	integer
`model`	bytea

property

Catalog of properties that can be attached to a certain geometry type.

Name	Type	Description
`unit_id`	integer	foreign key to catalog.unit.id
`indicator_id`	integer	foreign key to data.indicator.id
`name`	character_varying
`id`	integer
`mask`	character_varying
`numerical`	boolean
`data_type_id`	integer

sample

Points in time when properties of user points or polygons are collected.

Name	Type	Description
`min_depth`	integer
`max_depth`	integer
`sampling_log_id`	integer	foreign key to data.sampling_log.id
`name`	character_varying
`date_stamp`	timestamp_with_time_zone
`id`	integer
`person_id`	integer	foreign key to auth.person.id
`comment`	text
`sample_type_id`	integer	foreign key to catalog.sample_type.id

sample_mass

Sample mass

Name	Type	Description
`topsoil`	boolean
`id`	integer
`density`	double_precision
`soil_moisture_method_id`	integer	foreign key to catalog.soil_moisture_method.id
`repeat`	smallint
`sample_id`	integer	foreign key to data.sample.id

sampling_checklist

Sampling checklist

Name	Type	Description
`soil_spectra_ds`	boolean
`moulder`	boolean
`microbiometer`	boolean
`macrofauna`	boolean
`edna`	boolean
`wet_chemistry`	boolean
`id`	integer
`infiltration`	boolean
`ise_ph`	boolean
`enzymes`	boolean
`penetrometer_npkphcth`	boolean
`soil_spectra_mx`	boolean
`soil_spectra_no`	boolean
`fieldobs`	boolean
`point_id`	integer	foreign key to data.point.id

sampling_log

Sampling log

Name	Type	Description
`name`	character_varying
`id`	integer
`date_stamp`	timestamp_with_time_zone
`person_id`	integer	foreign key to auth.person.id
`point_id`	integer	foreign key to data.point.id

sampling_log_image

Sampling log image

Name	Type	Description
`sampling_log_id`	integer	foreign key to data.sampling_log.id
`name`	character_varying
`file_name`	character_varying
`extension`	character_varying
`direction_id`	integer	foreign key to catalog.direction.id
`person_id`	integer	foreign key to auth.person.id
`mime_type`	character_varying
`id`	integer

sampling_log_tool

Sampling log tool

Name	Type	Description
`id`	integer
`direction_id`	integer	foreign key to catalog.direction.id
`depth_restriction`	integer
`soil_excavation_tool_id`	integer
`sampling_log_id`	integer	foreign key to data.sampling_log.id

shdc

Shdc

Name	Type	Description
`confidence_list`	character_varying
`id`	integer
`property`	character_varying
`indicator_id`	integer	foreign key to data.indicator.id
`scale_factor`	real
`no_data`	integer
`details`	character_varying
`qml`	character_varying
`sld`	character_varying
`file_name`	character_varying
`color_map`	text
`unit_id`	integer	foreign key to catalog.unit.id
`depth_list`	character_varying
`max_zoom`	integer
`custom_restricted_api`	json

shdc_file

Shdc file

Name	Type	Description
`shdc_id`	integer	foreign key to data.shdc.id
`temporal_coverage_start`	character_varying
`temporal_coverage_end`	character_varying
`value`	character_varying
`wasabi_link`	character_varying
`depth_id`	integer	foreign key to data.depth.id
`description`	text
`id`	integer
`file_name`	character_varying

shdc_soil_type

Shdc soil type

Name	Type	Description
`wrb_22_code`	character_varying
`code`	integer
`id`	integer
`formatted_code`	character_varying
`number_of_occurrances_training_points`	integer

simple_observation

Simple observation

Name	Type	Description
`comment`	text
`name`	character_varying
`indicator_id`	integer
`id`	integer
`value`	real
`date`	date
`custom_geometry_id`	integer	foreign key to data.custom_geometry.id
`person_id`	integer	foreign key to auth.person.id

site

Site

Name	Type	Description
`person_id`	integer	foreign key to auth.person.id
`data_source_id`	integer	foreign key to data.data_source.id
`name`	character_varying
`id`	integer
`url`	character_varying
`description`	text

site_sampling_checklist

Site sampling checklist

Name	Type	Description
`ise_ph`	boolean
`enzymes`	boolean
`penetrometer_npkphcth`	boolean
`soil_spectra_ds`	boolean
`soil_spectra_mx`	boolean
`soil_spectra_no`	boolean
`fieldobs`	boolean
`moulder`	boolean
`id`	integer
`microbiometer`	boolean
`site_id`	integer	foreign key to data.site.id
`wet_chemistry`	boolean
`edna`	boolean
`macrofauna`	boolean
`infiltration`	boolean

spectra_scan

Spectra scan

Name	Type	Description
`observation_id`	integer	foreign key to data.observation.id
`ext_frequency`	real
`neg_frequency`	real
`na_frequency`	real
`id`	integer
`signal_stddev`	Array.<real>
`signal_mean`	Array.<real>
`spectroscopy_method_id`	integer	foreign key to catalog.spectroscopy_method.id

spectrometer

Spectrometer

Name	Type	Description
`id`	integer
`wavelengths`	Array.<real>
`equipment_id`	integer	foreign key to data.equipment.id

spectrum

Spectrum

Name	Type	Description
`id`	integer
`point_id`	integer	foreign key to data.point.id
`data_source_id`	integer	foreign key to data.data_source.id
`date`	date
`values`	Array.<real>
`wavelengths`	Array.<smallint>

taxa

Taxa

Name	Type	Description
`taxa_status_id`	integer
`taxa_code_id`	integer
`link`	character_varying
`vern`	character_varying
`env`	character_varying
`chrono`	character_varying
`parent_id`	integer
`id_text`	character_varying
`id`	integer
`name`	character_varying
`latin_name`	citext
`taxa_level_id`	integer
`remarks`	character_varying
`reference`	character_varying
`extinct`	boolean
`uncertain`	boolean
`synonym`	boolean

taxa_function

Taxa function

Name	Type	Description
`taxa_status_id`	integer	foreign key to catalog.taxa_status.id
`id`	integer
`name`	character_varying

taxa_heterogeneity

Taxa heterogeneity

Name	Type	Description
`richness`	double_precision
`shannon`	double_precision
`abundance`	double_precision
`sequence_reference_id`	integer	foreign key to catalog.sequence_reference_library.id
`bioinformatic_treatment_id`	integer	foreign key to data.bioinformatic_treatment.id
`id`	integer
`barcoding_pipeline_id`	integer
`edna_id`	integer	foreign key to data.edna.id
`bioinformatic_treatment_date`	timestamp_with_time_zone
`taxa_id`	integer	foreign key to data.taxa.id

taxa_heterogeneity_function

Taxa heterogeneity function

Name	Type	Description
`quantity`	double_precision
`taxa_function_id`	integer	foreign key to data.taxa_function.id
`taxa_heterogeneity_id`	integer	foreign key to data.taxa_heterogeneity.id
`id`	integer
`info`	character_varying

unit_conversion

Unit conversion

Name	Type	Description
`unit_from_id`	integer	foreign key to catalog.unit.id
`factor`	double_precision
`add`	double_precision
`unit_to_id`	integer	foreign key to catalog.unit.id
`id`	integer

vw_asset

Vw asset

Name	Type	Description
`scale_factor`	character_varying
`synonyms`	character_varying
`time_span`	text
`url`	text
`main_sld_url`	character_varying
`depth`	text
`no_data`	integer
`indicator_id`	integer
`orig_id`	character_varying
`title_id`	integer
`title`	character_varying

vw_avg_indicator_values_by_nuts

Average indicator values by nuts.

Name	Type	Description
`indicator_id`	integer
`value_max`	real
`value_avg`	double_precision
`nuts_id`	character_varying
`levl_code`	integer
`data_source_id`	integer
`value_min`	real

vw_geom

Vw geom

Name	Type	Description
`name`	character_varying
`level2`	integer
`atts`	text
`type`	text
`country`	character_varying
`id`	integer
`parent_id`	integer
`geometry_type_id`	integer
`level1`	integer

vw_geometry

Vw geometry

Name	Type	Description
`atts`	text
`level2`	integer
`level1`	integer
`name`	character_varying
`geometry_type_id`	integer
`geom`	geometry
`id`	integer
`parent_id`	integer
`properties`	text
`country`	character_varying
`type`	text

vw_indicator_color

Colors for indicators by value intervals.

Name	Type	Description
`color_name`	character_varying
`value_to`	real
`indicator_id`	integer
`color_code`	character_varying
`value_from`	real

weather

Weather

Name	Type	Description
`temperature_1h_mean`	smallint
`temperature_24h_max`	smallint
`temperature_24h_min`	smallint
`person_id`	integer	foreign key to auth.person.id
`temperature_24h_mean`	real
`sampling_log_id`	integer	foreign key to data.sampling_log.id
`id`	integer
`sky_condition_id`	integer	foreign key to catalog.sky_condition.id
`ground_condition_id`	integer	foreign key to catalog.ground_condition.id
`precipitation_1h`	smallint
`precipitation_24h`	smallint

Functions

copy_color_scheme

Copy color scheme from one indicator to another

Parameters:

Name	Type	Description
`IndicatorIdFrom`	integer
`IndicatorIdTo`	integer

Source:

jsdoc-db-procedures.js, line 634

Returns:

Type: void

data_asset_import_excel

Data asset import from excel function

Parameters:

Name	Type	Description
`jsonCV`	text
`jsonData`	text

Source:

jsdoc-db-procedures.js, line 658

Returns:

Type: void

data_file_metadata_import_excel

Data file metadata import from excel function

Parameters:

Name	Type	Description
`jsonCV`	text
`jsonData`	text

Source:

jsdoc-db-procedures.js, line 745

Returns:

Type: void

data_point_import_excel

Data point import from excel function

Parameters:

Name	Type	Description
`jsonCV`	text
`jsonData`	text

Source:

jsdoc-db-procedures.js, line 849

Returns:

Type: void

delete_custom_geometry

Delete custom geometry

Parameters:

Name	Type	Description
`PersonId`	integer
`Id`	integer

Source:

jsdoc-db-procedures.js, line 1022

Returns:

Type: void

delete_file

Delete file

Parameters:

Name	Type	Description
`PersonId`	integer
`FileId`	integer

Source:

jsdoc-db-procedures.js, line 1043

Returns:

Type: void

delete_image_from_os

Delete image from os

Source:

jsdoc-db-procedures.js, line 1074

Returns:

Type: trigger

delete_simple_observation

Delete simple observation

Parameters:

Name	Type	Description
`Id`	integer

Source:

jsdoc-db-procedures.js, line 1095

Returns:

Type: void

extract_file_name

Extract file name from a path

Parameters:

Name	Type	Description
`s`	character_varying

Source:

jsdoc-db-procedures.js, line 1115

Returns:

Type: character_varying

generate_observations_for_points

Generate observations for points

Parameters:

Name	Type	Description
`SiteId`	integer

Source:

jsdoc-db-procedures.js, line 1139

Returns:

Type: void

get_all_assets

Get all assets

Properties:

Name	Type	Description
`id`	character_varying
`ignore`	boolean
`asset_catalog_id`	integer
`title`	character_varying
`description`	character_varying
`asset_theme_id`	integer
`keywords_list`	character_varying
`asset_version_id`	integer
`doi`	character_varying
`unit_id`	integer
`scale_factor`	character_varying
`person_id`	integer
`providers_list`	character_varying
`license_id`	integer
`constellation_list`	character_varying
`platform`	character_varying
`instruments_list`	character_varying
`gsd`	character_varying
`start_date`	date
`end_date`	date
`date_step`	integer
`date_offset`	character_varying
`date_unit_id`	integer
`date_style_id`	integer
`ignore_29feb`	boolean
`depth_list`	character_varying
`main_sld_url`	character_varying
`sld_1_url`	character_varying
`main_qml_url`	character_varying
`main_url`	character_varying
`asset_catalog_id_val`	character_varying
`asset_theme_id_val`	character_varying
`asset_version_id_val`	character_varying
`unit_id_val`	character_varying
`person_id_val`	character_varying
`license_id_val`	character_varying
`date_unit_id_val`	character_varying
`date_style_id_val`	character_varying

Source:

jsdoc-db-procedures.js, line 1167

Returns:

Type: Object

get_assets

Get assets

Parameters:

Name	Type	Description
`TitleId`	integer
`Depth`	character_varying
`Srid`	integer

Source:

jsdoc-db-procedures.js, line 1237

Returns:

Type: json

get_assets_for_statistics

Get assets for statistics

Parameters:

Name	Type	Description
`IndicatorId`	integer

Source:

jsdoc-db-procedures.js, line 1287

Returns:

integer indicator_idcharacter_varying urlcharacter_varying scale_factorinteger no_datatext time_spaninteger depth_id

Type: Object

get_assets_overload

Get assets

Parameters:

Name	Type	Description
`TitleId`	integer
`Depth`	character_varying
`Srid`	integer

Source:

jsdoc-db-procedures.js, line 2741

Returns:

Type: json

get_catalogs

Get catalogs

Parameters:

Name	Type	Description
`LangId`	integer

Source:

jsdoc-db-procedures.js, line 1319

Returns:

Type: json

get_custom_geometry

Get custom geometry

Parameters:

Name	Type	Description
`PersonId`	integer
`Id`	integer

Source:

jsdoc-db-procedures.js, line 1369

Returns:

Type: json

get_data_source_atts

Get data source data

Parameters:

Name	Type	Description
`PersonId`	integer
`LangId`	integer

Source:

jsdoc-db-procedures.js, line 1441

Returns:

Type: json

get_data_source_data

Get data source data

Parameters:

Name	Type	Description
`Params`	text
`PersonId`	integer
`LangId`	integer

Source:

jsdoc-db-procedures.js, line 1479

Returns:

Type: json

get_data_source_vals

Get data source values

Parameters:

Name	Type	Description
`DataSourceId`	integer

Properties:

Name	Type	Description
`point_name`	character_varying
`date`	date

Source:

jsdoc-db-procedures.js, line 1582

Returns:

Type: Object

get_data_source_vals_overload

Get data source values

Parameters:

Name	Type	Description
`DataSourceId`	integer

Source:

jsdoc-db-procedures.js, line 1612

Returns:

Type: json

get_geometries_for_statistics

Get geometries for statistics

Parameters:

Name	Type	Description
`IndicatorId`	integer

Source:

jsdoc-db-procedures.js, line 1785

Returns:

integer parent_idinteger geometry_type_idtext geometrycharacter_varying name

Type: Object

get_geometry

Get geometry based on id, srid and geometry type id

Parameters:

Name	Type	Description
`Id`	integer
`Srid`	integer

Source:

jsdoc-db-procedures.js, line 1716

Returns:

Type: json

get_geometry_overload

Get geometry based on id, srid and geometry type id

Parameters:

Name	Type	Description
`Id`	integer
`Srid`	integer

Source:

jsdoc-db-procedures.js, line 1815

Returns:

Type: json

get_geometry_statistics

Get geometry statistics

Parameters:

Name	Type	Description
`Params`	text
`PersonId`	integer
`LangId`	integer

Source:

jsdoc-db-procedures.js, line 1914

Returns:

Type: json

get_geometry_statistics_categories

Get geometry statistics categories

Parameters:

Name	Type	Description
`Params`	text
`PersonId`	integer
`LangId`	integer

Source:

jsdoc-db-procedures.js, line 1996

Returns:

Type: json

get_geometry_statistics_single

Get geometry statistics single

Parameters:

Name	Type	Description
`Params`	text
`PersonId`	integer
`LangId`	integer

Source:

jsdoc-db-procedures.js, line 2036

Returns:

Type: json

get_geometry_type_properties

Get geometry type properties

Parameters:

Name	Type	Description
`LangId`	integer

Source:

jsdoc-db-procedures.js, line 2071

Returns:

Type: json

get_indicator_legend

Get indicator legend

Parameters:

Name	Type	Description
`LangId`	integer
`IndicatorId`	integer

Source:

jsdoc-db-procedures.js, line 2120

Returns:

Type: json

get_indicator_values

Get indicator values

Parameters:

Name	Type	Description
`IndicatorId`	integer
`DataSourceId`	integer

Properties:

Name	Type	Description
`lon`	double_precision
`lat`	double_precision
`value`	real
`date`	date
`color_code`	character_varying
`point_key`	character_varying
`nuts_0`	character
`description`	character_varying
`point_name`	character_varying
`point_id`	integer

Source:

jsdoc-db-procedures.js, line 2175

Returns:

Type: Object

get_indicators_by_nuts

Get indicators by NUTS

Parameters:

Name	Type	Description
`Params`	text
`PersonId`	integer
`LangId`	integer

Properties:

Name	Type	Description
`levl_code`	integer
`country`	character_varying
`name_latn`	character_varying
`nuts_id`	character_varying
`indicator`	character_varying
`average`	numeric
`min`	numeric
`max`	numeric

Source:

jsdoc-db-procedures.js, line 2259

Returns:

Type: Object

get_indicators_for_data_source

Get indicators for data source

Parameters:

Name	Type	Description
`DataSourceId`	integer
`LangId`	integer

Source:

jsdoc-db-procedures.js, line 2297

Returns:

Type: json

get_indicators_table

Get indicators in table format

Parameters:

Name	Type	Description
`Params`	text
`PersonId`	integer
`LangId`	integer

Source:

jsdoc-db-procedures.js, line 2341

Returns:

Type: json

get_intersecting_geometries

Get intersecting geometries

Parameters:

Name	Type	Description
`Params`	text
`PersonId`	integer
`LangId`	integer

Source:

jsdoc-db-procedures.js, line 2372

Returns:

Type: json

get_locations

Get locations by person id

Parameters:

Name	Type	Description
`Params`	text
`PersonId`	integer
`LangId`	integer

Properties:

Name	Type	Description
`id`	integer
`name`	character_varying
`type`	character_varying
`public`	boolean

Source:

jsdoc-db-procedures.js, line 2482

Returns:

Type: Object

get_lucas

Get LUCAS data

Parameters:

Name	Type	Description
`Params`	text
`PersonId`	integer
`LangId`	integer

Properties:

Name	Type	Description
`Point`	character_varying
`Depth`	character_varying
`OxAl`	double_precision
`N`	double_precision
`P`	double_precision
`OxFe`	double_precision
`pH_(CaCl₂)`	double_precision
`EC`	double_precision
`K`	double_precision
`OC`	double_precision
`pH_(H₂O)`	double_precision
`CaCO₃`	double_precision
`Nuts_0`	character_varying
`Nuts_1`	character_varying
`Nuts_2`	character_varying
`Nuts_3`	character_varying
`Lat`	double_precision
`Lon`	double_precision
`Date`	date
`Elevation`	integer
`Land_cover`	character_varying
`Land_usage`	character_varying
`Main_land_cover`	character_varying
`Detailed_land_cover`	character_varying
`Detailed_land_use`	character_varying

Source:

jsdoc-db-procedures.js, line 2515

Returns:

Type: Object

get_nuts

Get NUTS regions by level, zoom and bounding box

Parameters:

Name	Type	Description
`Level`	integer
`Srid`	integer
`Zoom`	integer
`Extent`	varchar
`IndicatorId`	integer
`DataSourceId`	integer

Source:

jsdoc-db-procedures.js, line 1666

Returns:

Type: json

get_nuts_overload

Get NUTS regions by level, zoom and bounding box

Parameters:

Name	Type	Description
`Level`	integer
`Srid`	integer
`Zoom`	integer
`MinX`	double_precision
`MinY`	double_precision
`MaxX`	double_precision
`MaxY`	double_precision
`IndicatorId`	integer
`DataSourceId`	integer

Source:

jsdoc-db-procedures.js, line 2434

Returns:

Type: json

get_nuts_overload

Get NUTS regions by level, zoom and bounding box

Parameters:

Name	Type	Description
`Level`	integer
`Srid`	integer
`Zoom`	integer
`Extent`	varchar
`IndicatorId`	integer
`DataSourceId`	integer

Source:

jsdoc-db-procedures.js, line 2610

Returns:

Type: json

get_point_history

Get point history

Parameters:

Name	Type	Description
`PointId`	integer
`IndicatorId`	integer

Properties:

Name	Type	Description
`date`	date
`depth`	character_varying
`value`	real

Source:

jsdoc-db-procedures.js, line 2660

Returns:

Type: Object

get_prediction_model_data

Get prediction model binary data

Parameters:

Name	Type	Description
`PredictionModelId`	integer

Source:

jsdoc-db-procedures.js, line 2693

Returns:

Type: bytea

get_prediction_models_for_data_source

Get prediction models for data source

Parameters:

Name	Type	Description
`DataSourceId`	integer
`LangId`	integer

Source:

jsdoc-db-procedures.js, line 2715

Returns:

Type: json

get_shape_geometry

Get shape geometry

Parameters:

Name	Type	Description
`Id`	integer
`Srid`	integer

Source:

jsdoc-db-procedures.js, line 1877

Returns:

Type: json

get_shape_geometry_overload

Get site geometry

Parameters:

Name	Type	Description
`Id`	integer

Source:

jsdoc-db-procedures.js, line 2826

Returns:

Type: json

get_shapes_for_data_source

Get shapes for data source

Parameters:

Name	Type	Description
`DataSourceId`	integer

Source:

jsdoc-db-procedures.js, line 2868

Returns:

Type: json

get_single_geometry

Get single geometry

Parameters:

Name	Type	Description
`Id`	integer

Source:

jsdoc-db-procedures.js, line 2784

Returns:

Type: json

get_spectra_for_data_source

Get spectra for data source

Parameters:

Name	Type	Description
`Params`	text
`PersonId`	integer
`LangId`	integer

Source:

jsdoc-db-procedures.js, line 2897

Returns:

character_varying namedate datesmallint[] wavelengthsreal[] values

Type: Object

get_spectrum

Get spectrum

Parameters:

Name	Type	Description
`DataSourceId`	integer
`PointId`	integer
`Date`	timestamp_without_time_zone

Source:

jsdoc-db-procedures.js, line 2923

Returns:

smallint wavelengthreal value

Type: Object

get_taxa_children

Get taxa children

Parameters:

Name	Type	Description
`Params`	text
`PersonId`	integer
`LangId`	integer

Source:

jsdoc-db-procedures.js, line 2952

Returns:

Type: json

get_taxa_hierarchy

Get taxa hierarchy

Parameters:

Name	Type	Description
`Params`	text
`PersonId`	integer
`LangId`	integer

Source:

jsdoc-db-procedures.js, line 2983

Returns:

Type: json

get_taxa_hierarchy_overload

Get taxa hierarchy

Parameters:

Name	Type	Description
`Params`	text

Source:

jsdoc-db-procedures.js, line 3037

Returns:

Type: json

get_tile_layers

Get tile layers

Parameters:

Name	Type	Description
`Srid`	integer

Properties:

Name	Type	Description
`fid`	integer
`collection_title`	character_varying
`href`	character_varying
`type`	character_varying
`geom`	text

Source:

jsdoc-db-procedures.js, line 3077

Returns:

Type: Object

get_titles

Get titles

Source:

jsdoc-db-procedures.js, line 3109

Returns:

Type: json

get_vw_assets

Get vw assets

Source:

jsdoc-db-procedures.js, line 3168

Returns:

Type: json

import_croatia

Import croatia data from json (excel)

Parameters:

Name	Type	Description
`jsonCV`	text
`jsonData`	text

Source:

jsdoc-db-procedures.js, line 3190

Returns:

Type: void

import_croatia246

Import croatia246 data from json (excel) file

Parameters:

Name	Type	Description
`jsonCV`	text
`jsonData`	text

Source:

jsdoc-db-procedures.js, line 3239

Returns:

Type: void

import_danish_points

Import danish points

Parameters:

Name	Type	Description
`Params`	text
`Json`	text

Source:

jsdoc-db-procedures.js, line 3294

Returns:

Type: void

import_danish_spectra

Import danish spectra

Parameters:

Name	Type	Description
`Params`	text
`Json`	text

Source:

jsdoc-db-procedures.js, line 3325

Returns:

Type: void

import_lucas2009

Import lucas2009

Parameters:

Name	Type	Description
`jsonCV`	text
`jsonData`	text

Source:

jsdoc-db-procedures.js, line 3359

Returns:

Type: void

import_lucas2015att

Import lucas2015att

Parameters:

Name	Type	Description
`jsonCV`	text
`jsonData`	text

Source:

jsdoc-db-procedures.js, line 3462

Returns:

Type: void

import_lucas2015pm

Import lucas2015pm

Parameters:

Name	Type	Description
`jsonCV`	text
`jsonData`	text

Source:

jsdoc-db-procedures.js, line 3515

Returns:

Type: void

import_shdc

Import shdc

Parameters:

Name	Type	Description
`Params`	text
`Json`	text

Source:

jsdoc-db-procedures.js, line 3622

Returns:

Type: void

import_shdc_files

Import shdc files

Parameters:

Name	Type	Description
`Params`	text
`Json`	text

Source:

jsdoc-db-procedures.js, line 3663

Returns:

Type: void

import_shdc_soil_type

Import shdc soil type

Parameters:

Name	Type	Description
`Params`	text
`Json`	text

Source:

jsdoc-db-procedures.js, line 3711

Returns:

Type: void

import_spain

Import spain

Parameters:

Name	Type	Description
`jsonCV`	text
`jsonData`	text

Source:

jsdoc-db-procedures.js, line 3745

Returns:

Type: void

import_spectra

Import spectra

Parameters:

Name	Type	Description
`Params`	text
`Json`	text

Source:

jsdoc-db-procedures.js, line 3818

Returns:

Type: void

import_taxa_heterogeneity_function

Import taxa heterogeneity function

Parameters:

Name	Type	Description
`Params`	text
`Json`	text

Source:

jsdoc-db-procedures.js, line 3849

Returns:

Type: void

import_temp

Import temp

Parameters:

Name	Type	Description
`jsonCV`	text
`jsonData`	text

Source:

jsdoc-db-procedures.js, line 3890

Returns:

Type: void

save_image

Save image

Parameters:

Name	Type	Description
`Id`	integer
`SimpleObservationId`	integer
`Name`	text
`FileName`	text
`Extension`	text
`MimeType`	text
`Compass`	integer
`Lat`	double_precision
`Lon`	double_precision

Source:

jsdoc-db-procedures.js, line 3921

Returns:

Type: integer

save_sampling_log_image_metadata

Save sampling log image metadata

Parameters:

Name	Type	Description
`Id`	integer
`Extension`	text
`MimeType`	text

Source:

jsdoc-db-procedures.js, line 3965

Returns:

Type: integer

set_color_map

Set color map associated with an asset

Parameters:

Name	Type	Description
`Id`	integer
`ColorMap`	text

Source:

jsdoc-db-procedures.js, line 3991

Returns:

Type: void

set_color_map_from_sld

Set color map from sld

Parameters:

Name	Type	Description
`Id`	integer
`Sld`	text

Source:

jsdoc-db-procedures.js, line 4013

Returns:

Type: void

set_lon_lat_nuts_for_points

Set lon lat nuts for points in data.point which have no lon and lat and nuts

Parameters:

Name	Type	Description
`srid`	integer

Source:

jsdoc-db-procedures.js, line 4185

Returns:

Type: void

set_point_geom

Set point geom

Source:

jsdoc-db-procedures.js, line 4273

Returns:

Type: trigger

set_shape_geometry

Set shape geometry

Parameters:

Name	Type	Description
`Id`	integer	site id
`Srid`	integer
`Properties`	text
`Geometry`	text

Source:

jsdoc-db-procedures.js, line 4148

Returns:

Type: void

set_single_geometry

Set single geometry

Parameters:

Name	Type	Description
`Json`	text

Source:

jsdoc-db-procedures.js, line 4329

Returns:

Type: json

site_itrig

Site itrig

Source:

jsdoc-db-procedures.js, line 4384

Returns:

Type: trigger

test

Test

Parameters:

Name	Type	Description
`Params`	text
`PersonId`	integer
`LangId`	integer

Source:

jsdoc-db-procedures.js, line 4405

Returns:

character_varying keydouble_precision latdouble_precision zemljopisna_duljina

Type: Object

test_overload

Test

Source:

jsdoc-db-procedures.js, line 4431

Returns:

Type: void

testpp

Testpp

Source:

jsdoc-db-procedures.js, line 4462

Returns:

Type: void

update_attribute_description

Update attribute description

Parameters:

Name	Type	Description
`PointId`	integer
`IndicatorId`	integer
`DataSourceId`	integer
`Date`	character_varying
`Value`	integer
`DepthId`	integer

Source:

jsdoc-db-procedures.js, line 4480

Returns:

Type: void

update_compass

Update compass for a custom geometry file (image)

Parameters:

Name	Type	Description
`PersonId`	integer
`Id`	integer
`Value`	integer

Source:

jsdoc-db-procedures.js, line 4520

Returns:

Type: void

update_custom_geometry

set custom geometry

Parameters:

Name	Type	Description
`json`	json	object containing custom geometry in 'Feature'

Source:

jsdoc-db-procedures.js, line 4090

Returns:

Type: void

update_depth_lists

Update depth lists

Source:

jsdoc-db-procedures.js, line 4557

Returns:

Type: void

update_geometry_statistics

Update geometry statistics

Parameters:

Name	Type	Description
`Json`	text

Source:

jsdoc-db-procedures.js, line 4591

Returns:

Type: void

update_geometry_statistics_from_points

Update geometry statistics from points

Parameters:

Name	Type	Description
`DataSourceId`	integer

Source:

jsdoc-db-procedures.js, line 4648

Returns:

Type: void

update_point

Update point by id with new geometry

Parameters:

Name	Type	Description
`Id`	integer
`Feature`	text

Source:

jsdoc-db-procedures.js, line 4220

Returns:

Type: void

update_point_lat_lon

Update point by Pointkey with Lat and Lon

Parameters:

Name	Type	Description
`Pointkey`	varchar
`Lat`	double
`Lon`	double
`SiteId`	int

Source:

jsdoc-db-procedures.js, line 4294

Returns:

Type: void

update_taxa

Update taxa

Parameters:

Name	Type	Description
`Json`	text

Source:

jsdoc-db-procedures.js, line 4719

Returns:

Type: void

update_taxa_code

Update taxa code

Parameters:

Name	Type	Description
`Json`	text

Source:

jsdoc-db-procedures.js, line 4752

Returns:

Type: void

update_taxa_level

Update taxa level

Parameters:

Name	Type	Description
`Json`	text

Source:

jsdoc-db-procedures.js, line 4781

Returns:

Type: void