SARV API

Estonian geocollections information system public API

Brief documentation

1. Get an individual data object by record ID

Main syntax: https://api.geocollections.info/$table/$id[.xml | .json | .jsonp | .api]

Examples:

  • https://api.geocollections.info/locality/10230
  • https://api.geocollections.info/locality/10230.json
  • https://api.geocollections.info/sample/77508
  • https://api.geocollections.info/taxon/4085
  • https://api.geocollections.info/stratigraphy/123


  • 2. Search and/or get a list of records

    Main syntax: https://api.geocollections.info/$table

    Optional parameters:

  • to specify output format: ?format=json|xml|jsonp|api (If not specified, default format is api)
  • to specify page: ?page=$page
  • to specify the number of records per page: ?paginate_by=$paginate_by (page limits are specified in List of Tables below. If not specified, limit is 1000 records)
  • to specify list of fields to retrieve: ?fields=$field1,$field2,...
  • to specify search criteria: ?$field__$lookuptype=$search_string (where $lookuptype is one of: exact, iexact, in, range, contains, icontains, startswith, istartswith, endswith, iendswith, gt, lt, gte, lte, isnull, hierarchy. If omitted is equivalent to __exact)
  • to display related data: ?related_data=$table&fields=$field1,$field2,... (only available for single object requests by record ID)
  • to make hierarchical search: ?$field__hierarchy=$value or ?$field__$lookuptype__hierarchy=$value (only for tables 'taxon', 'classification', 'classification_rock' and 'stratigraphy')
  • to order results by a field: ?order_by=$field (ascending) or ?order_by=-$field (descending)
  • to group results by a field: ?group_by=$field
  • to exclude records by some criteria: ?$field!=$value
  • to exclude null values: ?$field__isnull!=True or ?$field__isnull=False or ?$field!=null
  • Examples:

  • https://api.geocollections.info/taxon
  • https://api.geocollections.info/taxon?page=10
  • https://api.geocollections.info/taxon/?format=json&?fields=taxon,id&taxon__istartswith=Asaphus
  • https://api.geocollections.info/sample/?number__istartswith=OM6
  • https://api.geocollections.info/analysis_results/?name__exact=U [ppm]&value__gt=100
  • https://api.geocollections.info/reference/?author__icontains=nõlvak, j
  • https://api.geocollections.info/locality/21104?fields=locality,id&related_data=drillcore&related_data=locality_reference&fields=reference__reference
  • https://api.geocollections.info/taxon/?format=json&fields=id,taxon,author_year&taxon__istartswith__hierarchy=Prot
  • OR search:

    OR search, one value from multiple fields: ?multi_search=value:$value;fields:$field1,$field2,$field3;lookuptype:$lookuptype

  • To exclude values: value:!$value
  • Lookuptype parameter can be omitted, is equivalent to exact
  • Multiple multi_search query strings can be added
  • Example:

  • https://api.geocollections.info/specimen/?format=json&fields=id&multi_search=value:pirgu;fields:stratigraphy__stratigraphy,stratigraphy__stratigraphy_en;lookuptype:icontains&multi_search=value:orjak;fields:locality__country__value,locality__country__value_en,locality__vald__vald,locality__maakond__maakond,locality__asustusyksus__asustusyksus,locality__locality,locality__locality_en;lookuptype:icontains

  • OR search, different fields, different values: ?or_search=$field1:$value1;$field2:$value2;$field3:$value3

  • https://api.geocollections.info/locality/?format=json&or_search=country__value:Läti;vald__vald__icontains:ants

  • 3. List of tables and fields that can currently be accessed

    analysis

    Fields:

    • agent__agent
    • analysis_method__analysis_method
    • analysis_method__method_en
    • analysisresults__id
    • analysisresults__name
    • analysisresults__value
    • database__acronym
    • database__name
    • database__name_en
    • date
    • date_added
    • date_changed
    • date_free
    • id
    • instrument
    • instrument_txt
    • lab
    • lab_analysis_number
    • lab_txt
    • location
    • mass
    • material
    • method_details
    • method_details_en
    • remarks
    • sample
    • sample__agent_collected__agent
    • sample__agent_collected_free
    • sample__classification_rock__name
    • sample__classification_rock__name_en
    • sample__database__acronym
    • sample__date_collected
    • sample__date_collected_free
    • sample__depth
    • sample__depth_interval
    • sample__id
    • sample__lithostratigraphy__stratigraphy
    • sample__lithostratigraphy__stratigraphy_en
    • sample__lithostratigraphy_id
    • sample__locality__asustusyksus__asustusyksus
    • sample__locality__asustusyksus__asustusyksus_en
    • sample__locality__country__value
    • sample__locality__country__value_en
    • sample__locality__depth
    • sample__locality__eelis
    • sample__locality__elevation
    • sample__locality__latitude
    • sample__locality__locality
    • sample__locality__locality_en
    • sample__locality__longitude
    • sample__locality__maaamet_pa_id
    • sample__locality__maakond__maakond
    • sample__locality__maakond__maakond_en
    • sample__locality__number
    • sample__locality__parent__locality
    • sample__locality__remarks_location
    • sample__locality__stratigraphy_base__stratigraphy
    • sample__locality__stratigraphy_base__stratigraphy_en
    • sample__locality__stratigraphy_base_id
    • sample__locality__stratigraphy_top__stratigraphy
    • sample__locality__stratigraphy_top__stratigraphy_en
    • sample__locality__stratigraphy_top_id
    • sample__locality__type__value
    • sample__locality__type__value_en
    • sample__locality__vald__vald
    • sample__locality__vald__vald_en
    • sample__locality_free
    • sample__locality_id
    • sample__location
    • sample__mass
    • sample__number
    • sample__number_additional
    • sample__parent_sample
    • sample__remarks
    • sample__rock
    • sample__rock_en
    • sample__series_id
    • sample__soil_site__id
    • sample__soil_site__land_use
    • sample__soil_site__latitude
    • sample__soil_site__longitude
    • sample__soil_site__site
    • sample__soil_site__site_en
    • sample__soil_site__soil
    • sample__soil_site_id
    • sample__stratigraphy__stratigraphy
    • sample__stratigraphy__stratigraphy_en
    • sample__stratigraphy_bed
    • sample__stratigraphy_bed
    • sample__stratigraphy_free
    • sample__stratigraphy_id
    • sample_id

    Related data:

    • analysis_results
    • attachment_link

    Limit: 1000

    analysis_results

    Fields:

    • analysis
    • analysis__analysis_method__analysis_method
    • analysis__analysis_method__method_en
    • analysis__date
    • analysis__date_free
    • analysis__id
    • analysis__instrument
    • analysis__instrument_txt
    • analysis__lab
    • analysis__method_details
    • analysis__sample__agent_collected__agent
    • analysis__sample__agent_collected_free
    • analysis__sample__classification_rock__name
    • analysis__sample__classification_rock__name_en
    • analysis__sample__database__acronym
    • analysis__sample__date_collected
    • analysis__sample__date_collected_free
    • analysis__sample__depth
    • analysis__sample__depth_interval
    • analysis__sample__id
    • analysis__sample__lithostratigraphy__stratigraphy
    • analysis__sample__lithostratigraphy__stratigraphy_en
    • analysis__sample__lithostratigraphy_id
    • analysis__sample__locality
    • analysis__sample__locality__asustusyksus__asustusyksus
    • analysis__sample__locality__asustusyksus__asustusyksus_en
    • analysis__sample__locality__country__value
    • analysis__sample__locality__country__value_en
    • analysis__sample__locality__depth
    • analysis__sample__locality__eelis
    • analysis__sample__locality__elevation
    • analysis__sample__locality__latitude
    • analysis__sample__locality__locality
    • analysis__sample__locality__locality_en
    • analysis__sample__locality__longitude
    • analysis__sample__locality__maaamet_pa_id
    • analysis__sample__locality__maakond__maakond
    • analysis__sample__locality__maakond__maakond_en
    • analysis__sample__locality__number
    • analysis__sample__locality__parent__locality
    • analysis__sample__locality__remarks_location
    • analysis__sample__locality__stratigraphy_base__stratigraphy
    • analysis__sample__locality__stratigraphy_base__stratigraphy_en
    • analysis__sample__locality__stratigraphy_base_id
    • analysis__sample__locality__stratigraphy_top__stratigraphy
    • analysis__sample__locality__stratigraphy_top__stratigraphy_en
    • analysis__sample__locality__stratigraphy_top_id
    • analysis__sample__locality__type__value
    • analysis__sample__locality__type__value_en
    • analysis__sample__locality__vald__vald
    • analysis__sample__locality__vald__vald_en
    • analysis__sample__locality_free
    • analysis__sample__locality_id
    • analysis__sample__location
    • analysis__sample__mass
    • analysis__sample__number
    • analysis__sample__number_additional
    • analysis__sample__remarks
    • analysis__sample__rock
    • analysis__sample__rock_en
    • analysis__sample__series_id
    • analysis__sample__soil_site__land_use
    • analysis__sample__soil_site__latitude
    • analysis__sample__soil_site__longitude
    • analysis__sample__soil_site__site
    • analysis__sample__soil_site__site_en
    • analysis__sample__soil_site__soil
    • analysis__sample__soil_site_id
    • analysis__sample__stratigraphy__stratigraphy
    • analysis__sample__stratigraphy__stratigraphy_en
    • analysis__sample__stratigraphy_bed
    • analysis__sample__stratigraphy_id
    • analysis__sample_id
    • analysis_id
    • id
    • name
    • value
    • value_bin
    • value_txt

    attachment

    Fields:

    • agent_digitised__agent
    • agent_digitised__forename
    • agent_digitised__surename
    • attach_link__analysis__id
    • attach_link__collection__id
    • attach_link__collection__number
    • attach_link__dataset__id
    • attach_link__dataset__name
    • attach_link__dataset__name_en
    • attach_link__doi__id
    • attach_link__doi__identifier
    • attach_link__drillcore__drillcore
    • attach_link__drillcore__drillcore_en
    • attach_link__drillcore__id
    • attach_link__drillcore_box__drillcore__drillcore
    • attach_link__drillcore_box__drillcore__drillcore_en
    • attach_link__drillcore_box__drillcore__id
    • attach_link__drillcore_box__number
    • attach_link__locality__id
    • attach_link__locality__locality
    • attach_link__locality__locality_en
    • attach_link__preparation__id
    • attach_link__preparation__preparation_number
    • attach_link__reference__id
    • attach_link__reference__reference
    • attach_link__sample__id
    • attach_link__sample__number
    • attach_link__specimen__coll__number
    • attach_link__specimen__id
    • attach_link__specimen__specimen_id
    • attachment_format__value
    • author__agent
    • author__forename
    • author__surename
    • author_free
    • copyright_agent
    • copyright_agent__agent
    • database__acronym
    • database__name
    • database__name_en
    • date_added
    • date_changed
    • date_created
    • date_created_free
    • date_digitised
    • date_digitised_free
    • description
    • description_en
    • device__name
    • device_digitised__name
    • device_txt
    • drillcore_box__depth_end
    • drillcore_box__depth_start
    • drillcore_box__id
    • drillcore_box__number
    • drillcore_box__stratigraphy_base__stratigraphy
    • drillcore_box__stratigraphy_base__stratigraphy_en
    • drillcore_box__stratigraphy_base_id
    • drillcore_box__stratigraphy_top__stratigraphy
    • drillcore_box__stratigraphy_top__stratigraphy_en
    • drillcore_box__stratigraphy_top_id
    • drillcore_box_id
    • filename
    • id
    • image_altitude
    • image_category__value
    • image_category__value_en
    • image_description
    • image_description_en
    • image_height
    • image_latitude
    • image_longitude
    • image_number
    • image_object
    • image_people
    • image_place
    • image_scalebar
    • image_type__value
    • image_type__value_en
    • image_width
    • imageset__imageset_number
    • imageset__imageset_series
    • is_locked
    • is_preferred
    • licence__licence_en
    • licence__licence_url_en
    • locality
    • locality__asustusyksus__asustusyksus
    • locality__asustusyksus__asustusyksus_en
    • locality__country__value
    • locality__country__value_en
    • locality__depth
    • locality__id
    • locality__latitude
    • locality__locality
    • locality__locality_en
    • locality__localityreference__reference__reference
    • locality__localitystratigraphy__stratigraphy__stratigraphy
    • locality__localitystratigraphy__stratigraphy__stratigraphy_en
    • locality__longitude
    • locality__maaamet_pa_id
    • locality__maakond__maakond
    • locality__maakond__maakond_en
    • locality__number
    • locality__vald__vald
    • locality__vald__vald_en
    • locality_id
    • original_filename
    • reference__id
    • reference__reference
    • reference_id
    • remarks
    • specimen
    • specimen__agent_collected__agent
    • specimen__agent_collected__forename
    • specimen__agent_collected__surename
    • specimen__classification__class_en
    • specimen__classification__class_field
    • specimen__coll__number
    • specimen__database__acronym
    • specimen__date_added
    • specimen__depth
    • specimen__depth_interval
    • specimen__id
    • specimen__lithostratigraphy__stratigraphy
    • specimen__lithostratigraphy__stratigraphy_en
    • specimen__locality
    • specimen__locality__asustusyksus__asustusyksus
    • specimen__locality__asustusyksus__asustusyksus_en
    • specimen__locality__country__value
    • specimen__locality__country__value_en
    • specimen__locality__locality
    • specimen__locality__locality
    • specimen__locality__locality_en
    • specimen__locality__locality_en
    • specimen__locality__maakond__maakond
    • specimen__locality__maakond__maakond_en
    • specimen__locality__vald__vald
    • specimen__locality__vald__vald_en
    • specimen__locality_free
    • specimen__original_status__value
    • specimen__original_status__value_en
    • specimen__part
    • specimen__specimen_id
    • specimen__specimen_nr
    • specimen__specimenidentification__name
    • specimen__specimenidentification__taxon__hierarchy_string
    • specimen__specimenidentification__taxon__id
    • specimen__specimenidentification__taxon__taxon
    • specimen__specimenidentificationgeologies__name
    • specimen__specimenidentificationgeologies__name_en
    • specimen__specimenidentificationgeologies__rock__name
    • specimen__specimenidentificationgeologies__rock__name_en
    • specimen__specimenreference__reference__author
    • specimen__specimenreference__reference__reference
    • specimen__specimenreference__reference__title
    • specimen__stratigraphy
    • specimen__stratigraphy__stratigraphy
    • specimen__stratigraphy__stratigraphy
    • specimen__stratigraphy__stratigraphy_en
    • specimen__stratigraphy__stratigraphy_en
    • specimen__stratigraphy_free
    • specimen_id
    • specimen_id
    • specimen_image_attachment
    • specimen_image_id
    • stars
    • tags
    • type__value
    • type__value_en
    • uuid
    • uuid_filename

    Limit: 100

    attachment_link

    Fields:

    • attachment__author__agent
    • attachment__author_free
    • attachment__date_added
    • attachment__date_digitised
    • attachment__date_digitised_free
    • attachment__description
    • attachment__description_en
    • attachment__filename
    • attachment__id
    • attachment__is_private
    • attachment__link_table
    • attachment__type__value
    • attachment__type__value_en
    • attachment__uuid
    • attachment__uuid_filename
    • dataset

    classification

    Fields:

    • class_en
    • class_field

    collection

    Fields:

    • agent__agent
    • classification__class_en
    • database__acronym
    • date_added
    • date_changed
    • id
    • locality__id
    • locality__locality
    • locality__locality_en
    • name
    • name_en
    • name_long
    • name_long_en
    • number
    • number_objects
    • reference__id
    • reference__reference
    • remarks
    • remarks
    • stratigraphy__id
    • stratigraphy__stratigraphy
    • stratigraphy__stratigraphy_en

    dataset

    Fields:

    • copyright_agent__agent
    • date
    • date_added
    • date_changed
    • date_txt
    • description
    • description_en
    • id
    • licence__licence
    • licence__licence_en
    • licence__licence_url
    • licence__licence_url_en
    • name
    • name_en
    • owner__agent
    • owner_txt

    Related data:

    • attachment
    • dataset_analysis
    • dataset_reference

    Limit: 100

    dataset_analysis

    Fields:

    • analysis__analysisresults__name
    • analysis__analysisresults__value
    • analysis__id
    • analysis__sample__depth
    • analysis__sample__depth_interval
    • analysis__sample__id
    • analysis__sample__lithostratigraphy__id
    • analysis__sample__lithostratigraphy__stratigraphy
    • analysis__sample__lithostratigraphy__stratigraphy_en
    • analysis__sample__locality__country__value_en
    • analysis__sample__locality__id
    • analysis__sample__locality__latitude
    • analysis__sample__locality__locality
    • analysis__sample__locality__locality_en
    • analysis__sample__locality__longitude
    • analysis__sample__locality_free
    • analysis__sample__number
    • analysis__sample__rock
    • analysis__sample__rock_en
    • analysis__sample__stratigraphy__id
    • analysis__sample__stratigraphy__stratigraphy
    • analysis__sample__stratigraphy__stratigraphy_en
    • analysis__sample__stratigraphy_free
    • id

    dataset_reference

    Fields:

    • reference__book
    • reference__book_original
    • reference__id
    • reference__journal__journal_name
    • reference__journal_additional
    • reference__pages
    • reference__reference
    • reference__title
    • reference__title_original

    doi

    Fields:

    • abstract
    • copyright_agent__agent
    • copyright_agent__institution_name
    • copyright_agent__institution_name_en
    • creators
    • database
    • database__acronym
    • datacite_created
    • datacite_updated
    • dataset__name
    • dataset__name_en
    • dataset_id
    • date_added
    • date_changed
    • doiattachment__attachment__description
    • doiattachment__attachment__description_en
    • doiattachment__attachment__filename
    • doiattachment__attachment__type__value
    • doiattachment__attachment__type__value_en
    • formats
    • id
    • identifier
    • language__value
    • language__value_en
    • licence__licence_en
    • licence__licence_url_en
    • methods
    • publication_year
    • publisher
    • reference__author
    • reference__doi
    • reference__journal__journal_short
    • reference__pages
    • reference__reference
    • reference__title
    • reference__volume
    • reference__year
    • reference_id
    • resource
    • resource_type__value
    • sizes
    • subjects
    • title
    • version

    Related data:

    • attachment
    • doi_agent
    • doi_geolocation
    • doi_related_identifier

    doi_agent

    Fields:

    • affiliation
    • agent_type__value
    • name

    doi_geolocation

    Fields:

    • locality__country__value_en
    • locality__id
    • locality__locality
    • locality__locality_en
    • locality_id
    • place
    • point

    doi_related_identifier

    Fields:

    • identifier_type__value
    • relation_type__value
    • remarks
    • value

    drillcore

    Fields:

    • agent__agent
    • box_numbers
    • boxes
    • database__acronym
    • depository__value
    • depository__value_en
    • depth
    • direction_lr
    • drillcore
    • drillcore_en
    • drillcorebox__stratigraphy_free
    • id
    • locality__asustusyksus__asustusyksus
    • locality__asustusyksus__asustusyksus_en
    • locality__country__iso_code
    • locality__country__value
    • locality__country__value_en
    • locality__depth
    • locality__latitude
    • locality__locality
    • locality__locality_en
    • locality__localitystratigraphy__stratigraphy__stratigraphy
    • locality__localitystratigraphy__stratigraphy__stratigraphy_en
    • locality__longitude
    • locality__maaamet_pa_id
    • locality__maakond__maakond
    • locality__maakond__maakond_en
    • locality__vald__vald
    • locality__vald__vald_en
    • locality_id
    • number_meters
    • remarks
    • storage__location
    • year

    Related data:

    • attachment
    • drillcore_box

    Limit: 1000

    drillcore_box

    Fields:

    • attachment__author__agent
    • attachment__date_created
    • attachment__date_created_free
    • attachment__uuid
    • attachment__uuid_filename
    • database__acronym
    • date_added
    • date_changed
    • depth_end
    • depth_other
    • depth_start
    • drillcore__drillcore
    • drillcore__drillcore_en
    • drillcore__id
    • drillcore__locality
    • id
    • location
    • number
    • number_meters
    • remarks
    • stratigraphy_base__stratigraphy
    • stratigraphy_base__stratigraphy_en
    • stratigraphy_base_free
    • stratigraphy_base_id
    • stratigraphy_top__stratigraphy
    • stratigraphy_top__stratigraphy_en
    • stratigraphy_top_free
    • stratigraphy_top_id

    Related data:

    • attachment
    • attachment_link

    Limit: 1000

    drillcore_image

    Fields:

    • drillcore_box
    • drillcore_box__drillcore
    • id
    • uuid
    • uuid_filename

    Limit: 200

    file

    Fields:

    • agent_digitised__agent
    • agent_digitised__forename
    • agent_digitised__surename
    • attach_link__analysis__id
    • attach_link__collection__id
    • attach_link__collection__number
    • attach_link__dataset__id
    • attach_link__dataset__name
    • attach_link__dataset__name_en
    • attach_link__doi__id
    • attach_link__doi__identifier
    • attach_link__drillcore__drillcore
    • attach_link__drillcore__drillcore_en
    • attach_link__drillcore__id
    • attach_link__drillcore_box__drillcore__drillcore
    • attach_link__drillcore_box__drillcore__drillcore_en
    • attach_link__drillcore_box__drillcore__id
    • attach_link__drillcore_box__number
    • attach_link__locality__id
    • attach_link__locality__locality
    • attach_link__locality__locality_en
    • attach_link__preparation__id
    • attach_link__preparation__preparation_number
    • attach_link__reference__id
    • attach_link__reference__reference
    • attach_link__sample__id
    • attach_link__sample__number
    • attach_link__specimen__coll__number
    • attach_link__specimen__id
    • attach_link__specimen__specimen_id
    • attachment_format__value
    • author__agent
    • author__forename
    • author__surename
    • author_free
    • copyright_agent__agent
    • database__acronym
    • database__name
    • database__name_en
    • date_added
    • date_changed
    • date_created
    • date_created_free
    • date_digitised
    • date_digitised_free
    • description
    • description_en
    • device__name
    • device_digitised__name
    • device_txt
    • drillcore_box_id
    • filename
    • id
    • image_altitude
    • image_category__value
    • image_category__value_en
    • image_description
    • image_description_en
    • image_height
    • image_latitude
    • image_longitude
    • image_number
    • image_object
    • image_people
    • image_place
    • image_scalebar
    • image_type__value
    • image_type__value_en
    • image_width
    • imageset__imageset_number
    • imageset__imageset_series
    • is_locked
    • is_preferred
    • licence__licence_en
    • licence__licence_url_en
    • locality__asustusyksus__asustusyksus
    • locality__asustusyksus__asustusyksus_en
    • locality__country__value
    • locality__country__value_en
    • locality__depth
    • locality__id
    • locality__latitude
    • locality__locality
    • locality__locality_en
    • locality__localityreference__reference__reference
    • locality__localitystratigraphy__stratigraphy__stratigraphy
    • locality__localitystratigraphy__stratigraphy__stratigraphy_en
    • locality__longitude
    • locality__maaamet_pa_id
    • locality__maakond__maakond
    • locality__maakond__maakond_en
    • locality__number
    • locality__vald__vald
    • locality__vald__vald_en
    • locality_id
    • remarks
    • specimen
    • specimen__agent_collected__agent
    • specimen__agent_collected__forename
    • specimen__agent_collected__surename
    • specimen__classification__class_en
    • specimen__classification__class_field
    • specimen__coll__number
    • specimen__database__acronym
    • specimen__date_added
    • specimen__depth
    • specimen__depth_interval
    • specimen__id
    • specimen__lithostratigraphy__stratigraphy
    • specimen__lithostratigraphy__stratigraphy_en
    • specimen__locality
    • specimen__locality__asustusyksus__asustusyksus
    • specimen__locality__asustusyksus__asustusyksus_en
    • specimen__locality__country__value
    • specimen__locality__country__value_en
    • specimen__locality__locality
    • specimen__locality__locality
    • specimen__locality__locality_en
    • specimen__locality__locality_en
    • specimen__locality__maakond__maakond
    • specimen__locality__maakond__maakond_en
    • specimen__locality__vald__vald
    • specimen__locality__vald__vald_en
    • specimen__locality_free
    • specimen__original_status__value
    • specimen__original_status__value_en
    • specimen__part
    • specimen__specimen_id
    • specimen__specimen_nr
    • specimen__specimenidentification__name
    • specimen__specimenidentification__taxon__id
    • specimen__specimenidentification__taxon__taxon
    • specimen__specimenidentificationgeologies__name
    • specimen__specimenidentificationgeologies__name_en
    • specimen__specimenidentificationgeologies__rock__name
    • specimen__specimenidentificationgeologies__rock__name_en
    • specimen__specimenreference__reference__author
    • specimen__specimenreference__reference__reference
    • specimen__specimenreference__reference__title
    • specimen__stratigraphy
    • specimen__stratigraphy__stratigraphy
    • specimen__stratigraphy__stratigraphy
    • specimen__stratigraphy__stratigraphy_en
    • specimen__stratigraphy__stratigraphy_en
    • specimen__stratigraphy_free
    • specimen_id
    • specimen_id
    • specimen_image_attachment
    • stars
    • tags
    • type__value
    • type__value_en
    • uuid
    • uuid_filename

    Limit: 100

    fossils_search

    Fields:

    • id

    Limit: 100

    image

    Fields:

    • agent_digitised
    • agent_digitised__date_added
    • agent_digitised__forename
    • agent_digitised__surename
    • altitude
    • author__agent
    • author__forename
    • author__surename
    • author_free
    • category__value
    • category__value_en
    • copyright_agent__agent
    • database__acronym
    • date_added
    • date_changed
    • date_digitised
    • date_digitised_free
    • date_taken
    • date_taken_free
    • description
    • device__name
    • device_digitised__name
    • filename
    • id
    • image_number
    • imageset__imageset_number
    • imageset__imageset_series
    • keywords
    • latitude
    • licence__licence_en
    • licence__licence_url_en
    • locality__asustusyksus__asustusyksus
    • locality__asustusyksus__asustusyksus_en
    • locality__country__value
    • locality__country__value_en
    • locality__depth
    • locality__id
    • locality__latitude
    • locality__locality
    • locality__locality_en
    • locality__localityreference__reference__reference
    • locality__localitystratigraphy__stratigraphy__stratigraphy
    • locality__localitystratigraphy__stratigraphy__stratigraphy_en
    • locality__longitude
    • locality__maaamet_pa_id
    • locality__maakond__maakond
    • locality__maakond__maakond_en
    • locality__number
    • locality__vald__vald
    • locality__vald__vald_en
    • locality_id
    • longitude
    • object
    • people
    • place
    • size_x
    • size_y
    • stars
    • type__value
    • type__value_en
    • user_added
    • user_changed
    • uuid
    • uuid_filename

    Limit: 1000

    library

    Fields:

    • abstract
    • abstract_en
    • author
    • author_txt
    • date_added
    • date_changed
    • id
    • keywords
    • remarks
    • title
    • title_en
    • year

    Limit: 100

    library_reference

    Fields:

    • date_added
    • date_changed
    • id
    • keywords
    • library
    • reference
    • reference__attachment__filename
    • reference__author
    • reference__book
    • reference__doi
    • reference__is_oa
    • reference__journal__journal_name
    • reference__pages
    • reference__publisher
    • reference__publisher_place
    • reference__reference
    • reference__title
    • reference__url
    • reference__volume
    • remarks
    • sort

    Limit: 100

    locality

    Fields:

    • asustusyksus__asustusyksus
    • asustusyksus__asustusyksus_en
    • coord_det_agent__agent
    • coord_det_method__value
    • coord_det_method__value_en
    • coord_det_precision__value
    • coord_system
    • coordx
    • coordy
    • country__iso_code
    • country__value
    • country__value_en
    • date_added
    • date_changed
    • depth
    • eelis
    • elevation
    • id
    • latitude
    • locality
    • locality_en
    • localityreference__reference__reference
    • localitystratigraphy__stratigraphy__stratigraphy
    • localitystratigraphy__stratigraphy__stratigraphy_en
    • localitysynonym__synonym
    • longitude
    • maaamet_pa_id
    • maakond__maakond
    • maakond__maakond_en
    • number
    • parent__locality
    • remarks
    • remarks_location
    • stratigraphy_base__stratigraphy
    • stratigraphy_base__stratigraphy_en
    • stratigraphy_base_free
    • stratigraphy_base_id
    • stratigraphy_top__stratigraphy
    • stratigraphy_top__stratigraphy_en
    • stratigraphy_top_free
    • stratigraphy_top_id
    • type__value
    • type__value_en
    • user_added
    • vald__vald
    • vald__vald_en

    Related data:

    • attachment
    • attachment_link
    • drillcore
    • image
    • locality_reference
    • locality_synonym
    • sample
    • specimen
    • stratigraphy_stratotype

    Limit: 1000

    locality_parameter

    Fields:

    • locality_id
    • parameter

    Limit: 1000

    locality_reference

    Fields:

    • figures
    • locality__id
    • locality__locality
    • locality__locality_en
    • pages
    • reference__reference
    • reference_id
    • remarks

    Limit: 1000

    locality_stratigraphy

    Fields:

    • agent__agent
    • current
    • depth_base
    • depth_top
    • id
    • locality_id
    • reference__reference
    • reference_id
    • stratigraphy__color_code_cgmw
    • stratigraphy__index_additional
    • stratigraphy__index_main
    • stratigraphy__level
    • stratigraphy__stratigraphy
    • stratigraphy__stratigraphy_en
    • stratigraphy_id
    • year

    Limit: 100

    locality_summary

    Fields:

    • analyses
    • citing_references
    • drillcores
    • egk_id
    • id
    • images
    • latitude
    • longitude
    • name
    • name_en
    • samples
    • specimens
    • stratotypes
    • taxon_occurrences
    • total_related_records
    • url

    Limit: 10000

    locality_synonym

    Fields:

    • pages
    • reference__reference
    • remarks
    • synonym

    Limit: 1000

    locality_taxon

    Fields:

    • locality_id
    • taxon
    • taxon_id

    Limit: 1000

    preparation

    Fields:

    • classification__class_en
    • classification__class_field
    • date_added
    • date_changed
    • id
    • identification_agent__agent
    • identification_date
    • identification_remarks
    • location
    • preparation_number
    • preparationtaxa__frequency
    • preparationtaxa__name
    • remarks
    • sample__agent_collected__agent
    • sample__agent_collected__forename
    • sample__agent_collected__surename
    • sample__agent_collected_free
    • sample__database__acronym
    • sample__database__name
    • sample__database__name_en
    • sample__depth
    • sample__depth_interval
    • sample__id
    • sample__lithostratigraphy__stratigraphy
    • sample__lithostratigraphy__stratigraphy_en
    • sample__lithostratigraphy_id
    • sample__locality__id
    • sample__locality__locality
    • sample__locality__locality_en
    • sample__mass
    • sample__stratigraphy__stratigraphy
    • sample__stratigraphy__stratigraphy_en
    • sample__stratigraphy_free
    • sample__stratigraphy_id
    • sample_id
    • sample_palaeontology__agent__agent
    • sample_palaeontology__date_end
    • sample_palaeontology__date_free
    • sample_palaeontology__date_start
    • sample_palaeontology__location
    • sample_palaeontology__mass
    • sample_palaeontology__method__value
    • sample_palaeontology__method__value_en
    • sample_palaeontology__method_details
    • sample_palaeontology__remarks
    • storage__location
    • storage__location_location
    • taxon__taxon
    • taxonlist__frequency
    • taxonlist__id
    • taxonlist__name
    • taxonlist__taxon__id
    • taxonlist__taxon__remarks
    • taxonlist__taxon__taxon
    • user_added
    • user_changed

    Related data:

    • attachment_link
    • preparation_taxa

    Limit: 1000

    preparation_taxa

    Fields:

    • frequency
    • id
    • name
    • preparation
    • remarks

    reference

    Fields:

    • abstract
    • attachment__filename
    • attachment__id
    • author
    • book
    • book_original
    • date_added
    • date_changed
    • doi
    • figures
    • id
    • is_oa
    • journal
    • journal__journal_name
    • journal_additional
    • language__value
    • language__value_en
    • number
    • pages
    • publisher
    • publisher_place
    • reference
    • referencekeywords__keyword
    • remarks
    • tags
    • title
    • title_original
    • type__value
    • type__value_en
    • url
    • user_added
    • volume
    • year

    Related data:

    • attachment_link
    • doi
    • locality_reference
    • specimen_reference
    • taxon

    Limit: 1000

    reference_keyword

    Fields:

    • id
    • keyword
    • reference
    • reference__reference

    Limit: 100

    rock

    Fields:

    • description
    • description_en
    • description_in_estonia
    • description_in_estonia_en
    • description_usage
    • description_usage_en
    • formula
    • formula_html
    • id
    • ima_status
    • in_estonia
    • in_portal
    • is_resource
    • link_wikipedia
    • link_wikipedia_en
    • lithostratigraphy__stratigraphy
    • mindat_id
    • name
    • name_en
    • rock_rank__name
    • rock_type__name
    • stratigraphy__id
    • stratigraphy__stratigraphy

    Limit: 100

    rock_classification

    Fields:

    • hierarchy_top_rock__id
    • hierarchy_top_rock__name
    • id
    • name
    • name_en
    • name_long
    • name_long_en

    Limit: 100

    rock_image

    Fields:

    • id
    • image
    • image__agent__agent
    • image__copyright_agent__agent
    • image__database
    • image__date
    • image__date_taken_free
    • image__image
    • image__image_url
    • image__licence__licence
    • image__specimen_id
    • rock_id

    Limit: 100

    rock_locality

    Fields:

    • id
    • locality
    • locality__latitude
    • locality__locality
    • locality__locality_en
    • locality__longitude
    • rock_id

    Related data:

    • locality

    Limit: 100

    rock_mineral

    Fields:

    • id
    • is_primary
    • mineral__formula_html
    • mineral__name
    • mineral__name_en
    • rock_id

    Limit: 100

    rock_property

    Fields:

    • id
    • property
    • property_en
    • reference
    • rock_id
    • value_max
    • value_min
    • value_txt

    Limit: 100

    rock_reference

    Fields:

    • id
    • reference__author
    • reference__doi
    • reference__reference
    • reference__title
    • reference__year
    • reference_id
    • rock_id

    Limit: 100

    rock_synonym

    Fields:

    • id
    • language__iso1
    • language__value_en
    • language_id
    • name
    • rock_id

    Limit: 100

    rock_tree

    Fields:

    • id
    • parent__name
    • parent__name_en
    • parent_id
    • parent_string
    • rock__name
    • rock__name_en
    • rock_classification__hierarchy_top_rock__name
    • rock_classification__hierarchy_top_rock_id
    • rock_classification__name
    • rock_classification_id
    • rock_id

    Limit: 100

    sample

    Fields:

    • agent_collected__agent
    • agent_collected__forename
    • agent_collected__surename
    • agent_collected_free
    • analysis
    • analysis__analysis_method__analysis_method
    • analysis__analysis_method__method_en
    • analysis__analysisresults__name
    • analysis__analysisresults__value
    • analyzed
    • classification_rock__name
    • classification_rock__name_en
    • database__acronym
    • database__name
    • database__name_en
    • date_added
    • date_changed
    • date_collected
    • date_collected_free
    • depth
    • depth_interval
    • fossils
    • id
    • lithostratigraphy__stratigraphy
    • lithostratigraphy__stratigraphy_en
    • lithostratigraphy_id
    • locality
    • locality__asustusyksus__asustusyksus
    • locality__asustusyksus__asustusyksus_en
    • locality__country__iso_code
    • locality__country__value
    • locality__country__value_en
    • locality__depth
    • locality__eelis
    • locality__elevation
    • locality__latitude
    • locality__locality
    • locality__locality_en
    • locality__longitude
    • locality__maaamet_pa_id
    • locality__maakond__maakond
    • locality__maakond__maakond_en
    • locality__number
    • locality__parent__locality
    • locality__remarks_location
    • locality__stratigraphy_base__stratigraphy
    • locality__stratigraphy_base__stratigraphy_en
    • locality__stratigraphy_base_id
    • locality__stratigraphy_top__stratigraphy
    • locality__stratigraphy_top__stratigraphy_en
    • locality__stratigraphy_top_id
    • locality__type__value
    • locality__type__value_en
    • locality__vald__vald
    • locality__vald__vald_en
    • locality_free
    • locality_id
    • location
    • mass
    • number
    • number_additional
    • number_field
    • owner__agent
    • palaeontology
    • parent_sample
    • reference
    • reference__author
    • reference__book
    • reference__doi
    • reference__journal
    • reference__journal__journal_name
    • reference__journal_additional
    • reference__language__value_en
    • reference__pages
    • reference__reference
    • reference__remarks
    • reference__title
    • reference__title_original
    • reference__volume
    • reference__year
    • remarks
    • rock
    • rock_en
    • sample_purpose__value
    • sample_purpose__value_en
    • series_id
    • soil_horizon
    • soil_site__id
    • soil_site__land_use
    • soil_site__latitude
    • soil_site__longitude
    • soil_site__site
    • soil_site__site_en
    • soil_site__soil
    • soil_site_id
    • stratigraphy
    • stratigraphy__hierarchy_string
    • stratigraphy__stratigraphy
    • stratigraphy__stratigraphy_en
    • stratigraphy_bed
    • stratigraphy_free
    • stratigraphy_free
    • stratigraphy_id
    • taxonlist__frequency
    • taxonlist__taxon__taxon
    • x1
    • y1

    Related data:

    • analysis
    • analysis_results
    • attachment_link
    • preparation
    • specimen
    • taxon_list

    Limit: 1000

    soil_horizon

    Fields:

    • depth
    • granulometry_1
    • granulometry_2
    • horizon
    • horizon_number
    • id
    • korese_aste_1
    • korese_aste_2
    • korese_tyyp_a
    • korese_tyyp_b
    • remarks
    • soil_site_id
    • transition_a
    • transition_b

    soil_site

    Fields:

    • area_name
    • coord_system
    • coordx
    • coordy
    • date
    • date_free
    • id
    • is_deep
    • k_aste_a
    • k_size_a
    • land_use
    • latitude
    • longitude
    • site
    • site_en
    • soil
    • transect
    • transect_point

    Related data:

    • sample
    • soil_horizon

    specimen

    Fields:

    • agent_collected__agent
    • agent_collected__forename
    • agent_collected__surename
    • agent_collected_free
    • agent_collected_id
    • attachment__filename
    • classification__class_en
    • classification__class_field
    • classification__class_lat
    • coll__id
    • coll__name
    • coll__number
    • coll__remarks
    • coll_id
    • database__acronym
    • database__name
    • database__name_en
    • date_added
    • date_changed
    • date_collected
    • date_collected_free
    • depth
    • depth_interval
    • fossil__value
    • fossil__value_en
    • id
    • kind__value
    • kind__value_en
    • lithostratigraphy__stratigraphy
    • lithostratigraphy__stratigraphy_en
    • lithostratigraphy_id
    • locality__asustusyksus__asustusyksus
    • locality__asustusyksus__asustusyksus_en
    • locality__country__value
    • locality__country__value_en
    • locality__depth
    • locality__eelis
    • locality__elevation
    • locality__id
    • locality__latitude
    • locality__locality
    • locality__locality_en
    • locality__longitude
    • locality__maaamet_pa_id
    • locality__maakond__maakond
    • locality__maakond__maakond_en
    • locality__number
    • locality__parent__locality
    • locality__remarks_location
    • locality__stratigraphy_base__stratigraphy
    • locality__stratigraphy_base__stratigraphy_en
    • locality__stratigraphy_base_id
    • locality__stratigraphy_top__stratigraphy
    • locality__stratigraphy_top__stratigraphy_en
    • locality__stratigraphy_top_id
    • locality__type__value
    • locality__type__value_en
    • locality__vald__vald
    • locality__vald__vald_en
    • locality_free
    • locality_id
    • original_status__value
    • original_status__value_en
    • part
    • remarks
    • remarks_collecting
    • sample__mass
    • sample__number
    • sample__rock
    • sample__rock_en
    • sample_id
    • specimen_id
    • specimen_nr
    • specimen_nr
    • specimenidentification__current
    • specimenidentification__name
    • specimenidentification__taxon__author_year
    • specimenidentification__taxon__fossil_group__taxon
    • specimenidentification__taxon__parent__taxon
    • specimenidentification__taxon__taxon
    • specimenidentification__taxon_id
    • specimenidentificationgeologies__current
    • specimenidentificationgeologies__name
    • specimenidentificationgeologies__name_en
    • specimenidentificationgeologies__rock__id
    • specimenidentificationgeologies__rock__name
    • specimenidentificationgeologies__rock__name_en
    • specimenimage__image
    • specimenimage__image_url
    • specimenimage__specimen__database__acronym
    • specimenreference__reference__author
    • specimenreference__reference__reference
    • specimenreference__reference__title
    • status__value_en
    • status_status_value
    • stratigraphy__remarks
    • stratigraphy__stratigraphy
    • stratigraphy__stratigraphy
    • stratigraphy__stratigraphy_en
    • stratigraphy__stratigraphy_en
    • stratigraphy_free
    • stratigraphy_id
    • tags
    • type__value
    • type__value_en

    Related data:

    • attachment
    • attachment_link
    • specimen_identification
    • specimen_identification_geology
    • specimen_image
    • specimen_reference

    Limit: 1000

    specimen_identification

    Fields:

    • agent__agent
    • current
    • date_added
    • date_changed
    • date_identified
    • date_identified_free
    • id
    • identification_type__value
    • identification_type__value_en
    • name
    • name
    • reference__reference
    • reference_id
    • remarks
    • specimen_id
    • taxon__taxon
    • taxon_id

    specimen_identification_geology

    Fields:

    • agent__agent
    • current
    • date_added
    • date_identified
    • date_identified_free
    • id
    • name
    • name_en
    • reference__reference
    • reference_id
    • remarks
    • rock__formula
    • rock__formula_html
    • rock__name
    • rock__name_en
    • rock_id
    • specimen_id

    specimen_image

    Fields:

    • agent__agent
    • agent__forename
    • agent__surename
    • agent_digitised__forename
    • agent_digitised__surename
    • camera
    • copyright_agent__agent
    • database__acronym
    • date
    • date_added
    • date_changed
    • date_digitised
    • date_digitised_free
    • date_taken_free
    • description
    • description_en
    • device_id__name
    • id
    • image
    • image_url
    • licence__licence_en
    • licence__licence_url
    • licence__licence_url_en
    • remarks
    • remarks_en
    • scalebar
    • specimen
    • specimen__agent_collected__agent
    • specimen__agent_collected__forename
    • specimen__agent_collected__surename
    • specimen__classification__class_en
    • specimen__classification__class_field
    • specimen__coll__number
    • specimen__database__acronym
    • specimen__date_added
    • specimen__depth
    • specimen__depth_interval
    • specimen__id
    • specimen__lithostratigraphy__stratigraphy
    • specimen__lithostratigraphy__stratigraphy_en
    • specimen__locality
    • specimen__locality__asustusyksus__asustusyksus
    • specimen__locality__asustusyksus__asustusyksus_en
    • specimen__locality__country__value
    • specimen__locality__country__value_en
    • specimen__locality__locality
    • specimen__locality__locality
    • specimen__locality__locality_en
    • specimen__locality__locality_en
    • specimen__locality__maakond__maakond
    • specimen__locality__maakond__maakond_en
    • specimen__locality__vald__vald
    • specimen__locality__vald__vald_en
    • specimen__locality_free
    • specimen__original_status__value
    • specimen__original_status__value_en
    • specimen__part
    • specimen__specimen_id
    • specimen__specimen_nr
    • specimen__specimenidentification__name
    • specimen__specimenidentification__taxon__id
    • specimen__specimenidentification__taxon__taxon
    • specimen__specimenidentificationgeologies__name
    • specimen__specimenidentificationgeologies__name_en
    • specimen__specimenidentificationgeologies__rock__name
    • specimen__specimenidentificationgeologies__rock__name_en
    • specimen__specimenreference__reference__author
    • specimen__specimenreference__reference__reference
    • specimen__specimenreference__reference__title
    • specimen__stratigraphy
    • specimen__stratigraphy__stratigraphy
    • specimen__stratigraphy__stratigraphy
    • specimen__stratigraphy__stratigraphy_en
    • specimen__stratigraphy__stratigraphy_en
    • specimen__stratigraphy_free
    • specimen__stratigraphy_free
    • specimen_id
    • tags
    • taxon
    • type__value
    • type__value_en
    • user_added
    • user_changed
    • uuid
    • uuid_filename

    Limit: 1000

    specimen_image1

    Fields:

    • agent_digitised__forename
    • agent_digitised__surename
    • author__agent
    • author__forename
    • author__surename
    • copyright_agent__agent
    • database__acronym
    • date_added
    • date_changed
    • date_created
    • date_created_free
    • date_digitised
    • date_digitised_free
    • device__name
    • device_txt
    • filename
    • id
    • image_description
    • image_description_en
    • image_scalebar
    • image_type__value
    • image_type__value_en
    • licence__licence_en
    • licence__licence_url
    • licence__licence_url_en
    • remarks
    • specimen
    • specimen__agent_collected__agent
    • specimen__agent_collected__forename
    • specimen__agent_collected__surename
    • specimen__classification__class_en
    • specimen__classification__class_field
    • specimen__coll__number
    • specimen__database__acronym
    • specimen__date_added
    • specimen__depth
    • specimen__depth_interval
    • specimen__id
    • specimen__lithostratigraphy__stratigraphy
    • specimen__lithostratigraphy__stratigraphy_en
    • specimen__locality
    • specimen__locality__asustusyksus__asustusyksus
    • specimen__locality__asustusyksus__asustusyksus_en
    • specimen__locality__country__value
    • specimen__locality__country__value_en
    • specimen__locality__locality
    • specimen__locality__locality
    • specimen__locality__locality_en
    • specimen__locality__locality_en
    • specimen__locality__maakond__maakond
    • specimen__locality__maakond__maakond_en
    • specimen__locality__vald__vald
    • specimen__locality__vald__vald_en
    • specimen__locality_free
    • specimen__original_status__value
    • specimen__original_status__value_en
    • specimen__part
    • specimen__specimen_id
    • specimen__specimen_nr
    • specimen__specimenidentification__name
    • specimen__specimenidentification__taxon__id
    • specimen__specimenidentification__taxon__taxon
    • specimen__specimenidentificationgeologies__name
    • specimen__specimenidentificationgeologies__name_en
    • specimen__specimenidentificationgeologies__rock__name
    • specimen__specimenidentificationgeologies__rock__name_en
    • specimen__specimenreference__reference__author
    • specimen__specimenreference__reference__reference
    • specimen__specimenreference__reference__title
    • specimen__stratigraphy
    • specimen__stratigraphy__stratigraphy
    • specimen__stratigraphy__stratigraphy
    • specimen__stratigraphy__stratigraphy_en
    • specimen__stratigraphy__stratigraphy_en
    • specimen__stratigraphy_free
    • specimen_id
    • specimen_image_attachment
    • tags
    • taxon
    • user_added
    • user_changed
    • uuid_filename

    Limit: 1000

    specimen_reference

    Fields:

    • figures
    • id
    • pages
    • reference__doi
    • reference__reference
    • reference_id
    • remarks

    specimen_union

    Fields:

    • reference
    • reference__author
    • reference__book
    • reference__doi
    • reference__journal__journal_name
    • reference__number
    • reference__pages
    • reference__reference
    • reference__title
    • reference__year
    • specimen_union_id
    • taxon
    • taxon__hierarchy_string
    • taxon__taxon

    Limit: 100

    stratigraphy

    Fields:

    • age_base
    • age_chronostratigraphy__stratigraphy
    • age_chronostratigraphy__stratigraphy_en
    • age_chronostratigraphy_id
    • age_reference__id
    • age_reference__reference
    • age_top
    • author_free
    • color_code_cgmw
    • date_changed
    • description
    • description_en
    • etymon
    • etymon_en
    • hierarchy_string
    • id
    • index_additional
    • index_additional_html
    • index_main
    • index_main_html
    • lithology
    • lithology_en
    • max_thickness
    • original_locality
    • parent__stratigraphy
    • parent__stratigraphy_en
    • parent_id
    • rank__value
    • rank__value_en
    • region
    • region_en
    • remarks
    • scope__value
    • scope__value_en
    • status__value
    • status__value_en
    • stratigraphy
    • stratigraphy_base
    • stratigraphy_en
    • stratigraphysynonym__synonym
    • stratigraphysynonym__synonym_en
    • type__value
    • type__value_en
    • year

    Related data:

    • locality
    • sample
    • specimen
    • stratigraphy_reference
    • stratigraphy_stratotype
    • stratigraphy_synonym

    Limit: 1000

    stratigraphy_reference

    Fields:

    • pages
    • reference__reference
    • reference_id
    • remarks

    stratigraphy_stratotype

    Fields:

    • depth_base
    • depth_top
    • id
    • locality__id
    • locality__locality
    • locality__locality_en
    • reference__id
    • reference__reference
    • remarks
    • stratigraphy__stratigraphy
    • stratigraphy__stratigraphy_en
    • stratotype_type__value
    • stratotype_type__value_en

    stratigraphy_synonym

    Fields:

    • id
    • language__value
    • language__value_en
    • reference__id
    • reference__reference
    • remarks
    • synonym
    • synonym_en

    taxon

    Fields:

    • author_year
    • common_name__name
    • date_added
    • date_changed
    • fossil_group__id
    • fossil_group__taxon
    • hierarchy_string
    • id
    • in_baltoscandia
    • in_estonia
    • is_fossil
    • is_fossil_group
    • is_valid
    • parent
    • parent__author_year
    • parent__taxon
    • parent_id
    • rank__rank
    • rank__rank_en
    • rank__rank_short
    • reference__reference
    • reference_id
    • remarks
    • stratigraphy_base__age_base
    • stratigraphy_base__stratigraphy
    • stratigraphy_base__stratigraphy_en
    • stratigraphy_base_id
    • stratigraphy_top__age_top
    • stratigraphy_top__stratigraphy
    • stratigraphy_top__stratigraphy_en
    • stratigraphy_top_id
    • synonym_of
    • synonym_of_reference_id
    • taxon
    • taxon_epithet
    • taxon_id_eol
    • taxon_id_nrm
    • taxon_id_pbdb
    • taxon_id_plutof
    • taxon_id_tol

    Related data:

    • taxon_common_name

    Limit: 10000

    taxon_common_name

    Fields:

    • id
    • is_preferred
    • language
    • name
    • taxon
    • taxon__rank__rank_short
    • taxon__taxon

    Limit: 10

    taxon_description

    Fields:

    • agent__agent
    • author_free
    • description
    • id
    • reference
    • reference__id
    • reference__reference
    • reference__title
    • remarks
    • taxon
    • taxon__taxon

    Limit: 100

    taxon_image

    Fields:

    • attachment
    • attachment__author__agent
    • attachment__author_id
    • attachment__date_created
    • attachment__date_created_free
    • attachment__uuid_filename
    • diagnosis
    • diagnosis_en
    • id
    • link
    • link__taxon
    • remarks
    • sort
    • taxon
    • taxon__hierarchy_string
    • taxon__taxon
    • title
    • title_en

    Limit: 100

    taxon_list

    Fields:

    • frequency
    • id
    • name
    • remarks
    • remarks
    • sample
    • sample__depth
    • sample__depth_interval
    • sample__locality__locality
    • sample__locality__locality_en
    • sample__locality_id
    • sample__number
    • taxon
    • taxon__taxon
    • taxon_id

    Limit: 1000

    taxon_occurrence

    Fields:

    • depth
    • depth_interval
    • geographic_distribution
    • geographic_distribution_en
    • locality
    • locality__latitude
    • locality__locality
    • locality__locality_en
    • locality__longitude
    • locality_free
    • occurrence_id
    • reference
    • reference__author
    • reference__book
    • reference__doi
    • reference__journal__journal_name
    • reference__number
    • reference__pages
    • reference__reference
    • reference__title
    • reference__year
    • remarks
    • stratigraphic_distribution
    • stratigraphic_distribution_en
    • stratigraphy_base__stratigraphy
    • stratigraphy_base__stratigraphy_en
    • stratigraphy_base_free
    • stratigraphy_top
    • stratigraphy_top__stratigraphy
    • stratigraphy_top__stratigraphy_en
    • stratigraphy_top_free
    • taxon
    • taxon__hierarchy_string
    • taxon__taxon

    Limit: 100

    taxon_page

    Fields:

    • author__agent
    • author_txt
    • content
    • date_txt
    • frontpage
    • frontpage_order
    • frontpage_title
    • id
    • language
    • link_wikipedia
    • on_frontpage
    • taxon
    • taxon__taxon
    • title

    Limit: 100

    taxon_rank

    Fields:

    • id
    • rank
    • rank_en
    • rank_short
    • sort

    Limit: 100

    taxon_simple_search

    Fields:

    • hierarchy_string
    • id
    • name
    • rank

    Limit: 100

    taxon_synonym

    Fields:

    • author
    • figures
    • pages
    • reference
    • reference__reference
    • remarks
    • taxon
    • taxon__taxon
    • taxon_id
    • taxon_synonym
    • year

    Limit: 100

    taxon_type_specimen

    Fields:

    • attachment
    • attachment__filename
    • level
    • locality
    • locality__latitude
    • locality__locality
    • locality__locality_en
    • locality__longitude
    • locality_free
    • locality_free_en
    • reference
    • reference__reference
    • remarks
    • repository
    • specimen
    • specimen_number
    • stratigraphy
    • stratigraphy__stratigraphy
    • stratigraphy__stratigraphy_en
    • stratigraphy_free
    • stratigraphy_free_en
    • taxon
    • taxon__taxon
    • taxon_id
    • type_type__value
    • type_type__value_en

    Limit: 10

    webnews

    Fields:

    • date_added
    • date_expires
    • id
    • public
    • text_en
    • text_et
    • title_en
    • title_et

    Limit: 100

    webpages

    Fields:

    • content_en
    • content_et
    • date_expires
    • date_inserted
    • id
    • menu_title_en
    • menu_title_et
    • parent
    • public
    • sort
    • title_en
    • title_et

    Limit: 10