Schema: catalog

catalog

null



Tables


aggregate_stability_app

Aggregate stability app

Name Type Description
id integer
version character_varying
name character_varying


amplification

Amplification

Name Type Description
name character_varying
id integer
url character_varying


application

Application

Name Type Description
name character_varying
id integer


asset_catalog

Asset catalog

Name Type Description
id integer
name character_varying


asset_theme

Asset themes

Name Type Description
name character_varying
id integer


asset_version

Asset versions

Name Type Description
srid character_varying
name character_varying
id integer


brand

Brand

Name Type Description
name character_varying
id integer


crop

Crop

Name Type Description
name character_varying
id integer


crop_growth_stage

Crop growth stage

Name Type Description
name character_varying
id integer


date_style

Catalog of date styles for asset name generation.

Name Type Description
id integer
name character_varying


date_unit

Catalog of date units for asset name generation.

Name Type Description
format character_varying
id integer
name character_varying


direction

Direction

Name Type Description
name character_varying
id integer


environmental_zone

Environmental zone

Name Type Description
code character_varying
name character_varying
id integer


enzyme_type

Enzyme type

Name Type Description
id integer
code character_varying
name character_varying


equipment_type

Equipment type

Name Type Description
observation_type_id integer

foreign key to catalog.observation_type.id

name character_varying
id integer
application_id integer

foreign key to catalog.application.id


erosion_conservation_measure

Erosion conservation measure

Name Type Description
id integer
name character_varying


extraction

Extraction

Name Type Description
id integer
name character_varying


extraction_method

Extraction method

Name Type Description
name character_varying
id integer


fao_standard

Fao standard

Name Type Description
version character_varying
effective_from date
identifyer character_varying
id integer
name character_varying


ground_condition

Ground condition

Name Type Description
name character_varying
id integer


hillslope_position

Hillslope position

Name Type Description
name character_varying
id integer


image_approach

Image approach

Name Type Description
name character_varying
id integer


image_camera

Image camera

Name Type Description
name character_varying
id integer


image_lightsource

Image lightsource

Name Type Description
name character_varying
id integer


image_setup

Image setup

Name Type Description
name character_varying
id integer


image_substrate

Image substrate

Name Type Description
name character_varying
id integer


layer

Layer

Name Type Description
name character_varying
id integer


license

Catalog of licenses that can be defined for assets.

Name Type Description
id integer
name character_varying


life_cycle_stage

Life cycle stage

Name Type Description
id integer
name character_varying


macrofauna_excavation_tool

Macrofauna excavation tool

Name Type Description
id integer
name character_varying


major_landform

Major landform

Name Type Description
id integer
name character_varying


monolith

Monolith

Name Type Description
id integer
name character_varying


observation_type

Observation type

Name Type Description
id integer
name character_varying


preservation

Preservation

Name Type Description
name character_varying
id integer


proprietor

Proprietor

Name Type Description
id integer
name character_varying


purification

Purification

Name Type Description
id integer
name character_varying


sample_preparation

Sample preparation

Name Type Description
id integer
name character_varying
url character_varying
info text


sample_type

Sample type

Name Type Description
id integer
name character_varying


sequence_reference_library

Sequence reference library

Name Type Description
url character_varying
name character_varying
id integer


sequencing

Sequencing

Name Type Description
name character_varying
id integer


simple_observation_type

Simple observation type

Name Type Description
id integer
name character_varying


sky_condition

Sky condition

Name Type Description
name character_varying
id integer


soil_class

Soil class

Name Type Description
name character_varying
id integer


soil_moisture_method

Soil moisture method

Name Type Description
name character_varying
id integer


soil_moisture_nominal

Soil moisture nominal

Name Type Description
name character_varying
id integer


soil_type

Soil type

Name Type Description
code character_varying
name character_varying
id integer


spectroscopy_method

Spectroscopy method

Name Type Description
id integer
name character_varying


storage

Storage

Name Type Description
name character_varying
id integer


taxa_code

Taxa code

Name Type Description
id integer
name text


taxa_level

Taxa level

Name Type Description
id integer
name character_varying


taxa_status

Taxa status

Name Type Description
name character_varying
id integer


transport

Transport

Name Type Description
id integer
name character_varying


unit

Catalog of units of measurements.

Name Type Description
id integer
display_name character_varying
name character_varying
name_match character_varying


usda_standard

Usda standard

Name Type Description
id integer
name character_varying


Functions

import_environmental_zone

Import environmental zone

Parameters:
Name Type Description
Params text
Json text
Source:
Returns:
Type
void

import_soil_type

Import soil type

Parameters:
Name Type Description
Json text
Params text
Source:
Returns:
Type
void