|
||
Welcome to the RBINS-collection databaseThe Royal Belgian Institute of Natural Sciences houses a precious collection of zoological, anthropological, paleontological, mineralogical and geological materials and data. The renowned Iguanodons from Bernissart, ambassadors of the Belgian science institute in Brussels, represent a natural history collection currently estimated to hold over 37 million specimens. The roots of the present day collection reach far back in history. It evolved from the Natural History collection of Karel of Lotharingen, governor of The Netherlands (1712-1780) and was part of didactic materials owned by the Central School of the City of Brussels. After the independence of Belgium, the City of Brussels donated the collection to the Belgian Government and became part of the autonomous “Royal Natural History Museum” in 1846, known as the “Royal Belgian Institute of Natural Sciences” since 1948. Fieldwork by researchers and collaborators, in Belgium and abroad, donations and purchases have been expanding the assets ever since. The darwin website (darwin.naturalsciences.be) is the main gate to glimpse the extent and diversity of the collections. Today, the darwin database manages information on about 2.637.600 specimens (540.000 records) stored in the institute’s depositories. This number rises on a daily basis thanks to the continued efforts of patrimonium directorate, the curators and their adjuncts that are responsible for maintaining the stored specimens and information. Our online database provides information about the collections of the Vertebrates, Invertebrates, Entomology, Paleontology, Geology and Mineralogy. Information on the Anthropological collection is maintained on a parallel system: mars (Multimedia Archaeological Research System). This data can be consulted following: www.naturalsciences.be/mars. The Department of Geology and the Department of Marine Ecosystems provide information on different systems. More information on these departments can be found on www.naturalsciences.be/en/science/do/25/scientific-research/research-programmes/94 And odnature.naturalsciences.be/home/ The corner stone of the darwin database is the specimen and the information about its origin and its status. Although the status of the specimens follow the current regulations of the International Code on Zoological Nomenclature other status specifications not treated by the ICZN regulations (eg. topotype) have been maintained as supplementary information about the specimen(s) in question. Enjoy your virtual visit through our collections! Discover some random specimens :
|
||
|
options: path_info_key: PATH_INFO path_info_array: SERVER http_port: null https_port: null default_format: null trust_proxy: true logging: '1' relative_url_root: null formats: { txt: text/plain, js: [application/javascript, application/x-javascript, text/javascript], css: text/css, json: [application/json, application/x-json], xml: [text/xml, application/xml, application/x-xml], rdf: application/rdf+xml, atom: application/atom+xml } no_script_name: false parameterHolder: action: index module: board attributeHolder: sf_route: 'sfRoute Object()'
status: code: 200 text: OK options: http_protocol: HTTP/1.0 logging: '1' charset: utf-8 send_http_headers: false content_type: 'text/html; charset=utf-8' cookies: { } httpHeaders: Content-Type: 'text/html; charset=utf-8' javascripts: jquery-1.7.1.min.js: { } jquery.ui.all.min.js: { } core.js: { } stylesheets: reset.css: { } menu_pub.css: { } content.css: { } metas: title: 'Darwin 2' httpMetas: Content-Type: 'text/html; charset=utf-8'
options: auto_shutdown: false culture: null default_culture: en use_flash: true logging: '1' timeout: 14400 attributeHolder: { } culture: en authenticated: false credentials: { } lastRequest: 1714835876
app_ldap_attr_displayname: displayName app_ldap_attr_id: samaccountname app_ldap_attr_mail: mail app_ldap_baseuser: 'cn=Users, dc=rbins, dc=be' app_ldap_host: dc2012.rbins.be app_ldap_ldap_enabled: true app_ldap_pass: adReader2! app_ldap_port: 389 app_ldap_user: adreader2 app_ldap_version: 3 dw_allowed_ip_ranges: rmca: 193.190.234 dw_analytics_code: UA-25371885-5 dw_analytics_enabled: true dw_bing_key: Ap3eFRefFd94_D4cqsicw-Fk1-d4kRat9pstTO4oo_i9anyUqrfQcqL9Ew9CJahg dw_catalogueRecLimit: 200 dw_contactMail: darwin-ict@naturalsciences.be dw_dateLowerBound: 0001/01/01 dw_dateUpperBound: 2038/12/31 dw_defaultInstitutionRef: 47859 dw_disableXSDValidation: false dw_domain_disable_menu: 'http://collections.naturalsciences.be' dw_gbif_url: 'https://www.gbif.org/species/search?q=' dw_iiif_viewer: 'https://virtual-collections.naturalsciences.be/mirador/index.php?manifest=' dw_mailer_sender: darwin-ict@naturalsciences.be dw_pagerSlidingSize: 5 dw_php_console: php dw_preview_max_size: 10 dw_queryTimeout: 600000 dw_recPerPage: 10 dw_recaptcha_private_key: 6Le-P1gUAAAAANoyBu1hwmNHU_Z0nu7nQPXV9Cty dw_recaptcha_proxy_host: 193.190.234.40 dw_recaptcha_proxy_port: 3128 dw_recaptcha_public_key: 6Le-P1gUAAAAAFskoU9q9lK1oMMUlAnU5n9dvgKo dw_report_server: 'https://jasperadmin:jasperadmin@darwin.naturalsciences.be/jasperserver' dw_reports_names_and_options: default: { server: main, language_added_to_name: false } loans_form_complete: { path: loans } annual_stat_collection: { language_added_to_name: true } dw_reports_servers: main: { server: darwin.naturalsciences.be, username: jasperadmin, password: jasperadmin, protocol: https, port: '443', base_path: /jasperserver/rest_v2/reports/darwin } dw_root_url_darwin: 'https://darwin.naturalsciences.be' dw_root_url_uuid: 'https://darwin.naturalsciences.be/darwin/search/view/uuid/' dw_root_url_wfs: 'https://darwin.naturalsciences.be/geoserver/' dw_salt: mySecret$alt dw_tagsDisplayLimit: 10 dw_tagsLowerLimit: 4 dw_tempFilePath: /tmp/temp_file dw_tracking_enabled: true dw_wfs_layers: rbins_natural_earth_adm: 'Natural Earth Administrative' rbins_natural_earth_physical: 'Natural Earth Physical' flanders_marine_institute_layers: 'Flanders Marine Institute' rbins_osm: 'Open Street Map' rbins_generic: 'RBINS Other layers' dw_yearRangeMax: 2026 dw_yearRangeMin: 1700 dw_yearUpperBound: '2038' mod_board_enabled: true mod_board_view_class: sfPHP mod_login_enabled: true mod_login_view_class: sfPHP sf_admin_module_web_dir: /sfDoctrinePlugin sf_admin_web_dir: /sf/sf_admin sf_app: public sf_app_base_cache_dir: /var/www/html/darwin/cache/public sf_app_cache_dir: /var/www/html/darwin/cache/public/dev sf_app_config_dir: /var/www/html/darwin/apps/public/config sf_app_dir: /var/www/html/darwin/apps/public sf_app_i18n_dir: /var/www/html/darwin/apps/public/i18n sf_app_lib_dir: /var/www/html/darwin/apps/public/lib sf_app_module_dir: /var/www/html/darwin/apps/public/modules sf_app_template_dir: /var/www/html/darwin/apps/public/templates sf_apps_dir: /var/www/html/darwin/apps sf_cache: false sf_cache_dir: /var/www/html/darwin/cache sf_charset: utf-8 sf_check_lock: on sf_cli: false sf_compressed: false sf_config_cache_dir: /var/www/html/darwin/cache/public/dev/config sf_config_dir: /var/www/html/darwin/config sf_csrf_secret: TemporarySecret sf_data_dir: /var/www/html/darwin/data sf_debug: true sf_default_culture: en sf_enabled_modules: - default sf_environment: dev sf_error_404_action: error404 sf_error_404_module: default sf_error_reporting: 32767 sf_escaping_method: ESC_SPECIALCHARS sf_escaping_strategy: on sf_etag: false sf_file_link_format: null sf_i18n: on sf_i18n_cache_dir: /var/www/html/darwin/cache/public/dev/i18n sf_lib_dir: /var/www/html/darwin/lib sf_log_dir: /var/www/html/darwin/log sf_logging_enabled: true sf_login_action: login sf_login_module: default sf_module_cache_dir: /var/www/html/darwin/cache/public/dev/modules sf_module_disabled_action: disabled sf_module_disabled_module: default sf_no_script_name: false sf_orm: doctrine sf_plugins_dir: /var/www/html/darwin/plugins sf_psr_logger: false sf_root_dir: /var/www/html/darwin sf_secure_action: secure sf_secure_module: default sf_standard_helpers: - Partial - Cache - I18N - Asset sf_symfony_lib_dir: /var/www/html/darwin/lib/vendor/symfony/lib sf_template_cache_dir: /var/www/html/darwin/cache/public/dev/template sf_test_cache_dir: /var/www/html/darwin/cache/public/dev/test sf_test_dir: /var/www/html/darwin/test sf_upload_dir: /var/www/html/darwin/web/uploads sf_upload_dir_name: uploads sf_use_database: true sf_web_debug: true sf_web_debug_web_dir: /sf/sf_web_debug sf_web_dir: /var/www/html/darwin/web symfony.asset.javascripts_included: true symfony.asset.stylesheets_included: true tpl_authorizedversion: taxonomy: [1.2, 1.3] specimens: [1.4]
cookie: { } env: { } files: { } get: { } post: { } server: CONTEXT_DOCUMENT_ROOT: /var/www/html/darwin/web/ CONTEXT_PREFIX: '' DOCUMENT_ROOT: /var/www/html/darwin/web/ FCGI_ROLE: RESPONDER GATEWAY_INTERFACE: CGI/1.1 HOME: /var/www HTTPS: on HTTP_ACCEPT: '*/*' HTTP_CONNECTION: close HTTP_HOST: darwin.naturalsciences.be HTTP_USER_AGENT: 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' HTTP_X_FORWARDED_FOR: 18.188.142.146 HTTP_X_FORWARDED_PROTO: https HTTP_X_REAL_IP: 18.188.142.146 PATH: '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin' PATH_INFO: / PATH_TRANSLATED: 'https://darwin.naturalsciences.be/dw_public/form/' PHP_SELF: /public_dev.php/ QUERY_STRING: '' REMOTE_ADDR: 193.190.146.36 REMOTE_PORT: '60218' REQUEST_METHOD: GET REQUEST_SCHEME: https REQUEST_TIME: 1714835876 REQUEST_TIME_FLOAT: 1714835876.6005 REQUEST_URI: /public_dev.php/ SCRIPT_FILENAME: //var/www/html/darwin/web/public_dev.php SCRIPT_NAME: /public_dev.php SCRIPT_URI: 'https://darwin.naturalsciences.be/public_dev.php/' SCRIPT_URL: /public_dev.php/ SERVER_ADDR: 192.168.36.184 SERVER_ADMIN: webmaster@localhost SERVER_NAME: darwin.naturalsciences.be SERVER_PORT: '443' SERVER_PROTOCOL: HTTP/1.0 SERVER_SIGNATURE: "<address>Apache/2.4.59 (Debian) Server at darwin.naturalsciences.be Port 443</address>\n" SERVER_SOFTWARE: 'Apache/2.4.59 (Debian)' SSL_CIPHER: ECDHE-RSA-AES256-GCM-SHA384 SSL_CIPHER_ALGKEYSIZE: '256' SSL_CIPHER_EXPORT: 'false' SSL_CIPHER_USEKEYSIZE: '256' SSL_CLIENT_VERIFY: NONE SSL_COMPRESS_METHOD: 'NULL' SSL_PROTOCOL: TLSv1.2 SSL_SECURE_RENEG: 'true' SSL_SERVER_A_KEY: rsaEncryption SSL_SERVER_A_SIG: sha384WithRSAEncryption SSL_SERVER_I_DN: 'CN=GEANT OV RSA CA 4,O=GEANT Vereniging,C=NL' SSL_SERVER_I_DN_C: NL SSL_SERVER_I_DN_CN: 'GEANT OV RSA CA 4' SSL_SERVER_I_DN_O: 'GEANT Vereniging' SSL_SERVER_M_SERIAL: 4CE88C7711A7342AC85DE1EB018977CD SSL_SERVER_M_VERSION: '3' SSL_SERVER_SAN_DNS_0: '*.naturalsciences.be' SSL_SERVER_SAN_DNS_1: naturalsciences.be SSL_SERVER_S_DN: 'CN=*.naturalsciences.be,O=Institut royal des Sciences naturelles de Belgique,ST=Bruxelles-Capitale\, Région de,C=BE' SSL_SERVER_S_DN_C: BE SSL_SERVER_S_DN_CN: '*.naturalsciences.be' SSL_SERVER_S_DN_O: 'Institut royal des Sciences naturelles de Belgique' SSL_SERVER_S_DN_ST: 'Bruxelles-Capitale, Région de' SSL_SERVER_V_END: 'Jan 3 23:59:59 2025 GMT' SSL_SERVER_V_START: 'Jan 4 00:00:00 2024 GMT' SSL_SESSION_RESUMED: Initial SSL_VERSION_INTERFACE: mod_ssl/2.4.59 SSL_VERSION_LIBRARY: OpenSSL/1.1.1w USER: www-data proxy-nokeepalive: '1' proxy-sendchunked: '' session: { }
php: 8.2.15 os: 'Linux diptera1 5.10.0-20-amd64 #1 SMP Debian 5.10.158-2 (2022-12-13) x86_64' extensions: 18: 'apcu (5.1.23)' 19: 'bz2 (8.2.15)' 20: 'calendar (8.2.15)' 15: 'cgi-fcgi (8.2.15)' 0: 'Core (8.2.15)' 21: 'ctype (8.2.15)' 22: 'curl (8.2.15)' 1: 'date (8.2.15)' 23: 'dom (20031129)' 33: 'exif (8.2.15)' 25: 'FFI (8.2.15)' 26: 'fileinfo (8.2.15)' 6: 'filter (8.2.15)' 27: 'ftp (8.2.15)' 28: 'gettext (8.2.15)' 7: 'hash (8.2.15)' 29: 'iconv (8.2.15)' 30: 'igbinary (3.2.15)' 31: 'intl (8.2.15)' 8: 'json (8.2.15)' 32: 'ldap (8.2.15)' 2: 'libxml (8.2.15)' 24: 'mbstring (8.2.15)' 34: 'memcache (8.2)' 51: 'memcached (3.2.0)' 35: 'msgpack (2.2.0)' 3: 'openssl (8.2.15)' 4: 'pcre (8.2.15)' 16: 'PDO (8.2.15)' 36: 'pdo_pgsql (8.2.15)' 37: 'pgsql (8.2.15)' 38: 'Phar (8.2.15)' 39: 'posix (8.2.15)' 9: 'random (8.2.15)' 40: 'readline (8.2.15)' 10: 'Reflection (8.2.15)' 12: 'session (8.2.15)' 41: 'shmop (8.2.15)' 42: 'SimpleXML (8.2.15)' 43: 'sockets (8.2.15)' 14: 'sodium (8.2.15)' 11: 'SPL (8.2.15)' 13: 'standard (8.2.15)' 44: 'sysvmsg (8.2.15)' 45: 'sysvsem (8.2.15)' 46: 'sysvshm (8.2.15)' 47: 'tokenizer (8.2.15)' 17: 'xml (8.2.15)' 48: 'xmlreader (8.2.15)' 49: 'xmlwriter (8.2.15)' 50: 'xsl (8.2.15)' 52: 'Zend OPcache (8.2.15)' 5: 'zlib (8.2.15)'
version: 1.5.12-dev path: /var/www/html/darwin/lib/vendor/symfony/lib
Parameters:
$specimens
(Doctrine_Collection)Parameters:
$specimens
(sfOutputEscaperIteratorDecorator)No parameters were passed to this template.
Parameters:
No parameters were passed to this template.
# | type | message |
---|---|---|
1 | sfPatternRouting | Match route "homepage" (/) for / with parameters array ( 'module' => 'board', 'action' => 'index',) |
2 | sfFilterChain | Executing filter "sfRenderingFilter" |
3 | sfFilterChain | Executing filter "sfExecutionFilter" |
4 | boardActions | Call "boardActions->executeIndex()" |
5 | Doctrine_Connection_Pgsql | exec : SET NAMES 'UTF8' - () |
6 | Doctrine_Connection_Pgsql | query : SELECT s.id AS s__id, s.category AS s__category, s.collection_ref AS s__collection_ref, s.expedition_ref AS s__expedition_ref, s.gtu_ref AS s__gtu_ref, s.taxon_ref AS s__taxon_ref, s.litho_ref AS s__litho_ref, s.chrono_ref AS s__chrono_ref, s.lithology_ref AS s__lithology_ref, s.mineral_ref AS s__mineral_ref, s.acquisition_category AS s__acquisition_category, s.acquisition_date_mask AS s__acquisition_date_mask, s.acquisition_date AS s__acquisition_date, s.station_visible AS s__station_visible, s.ig_ref AS s__ig_ref, s.restricted_access AS s__restricted_access, s.spec_coll_ids AS s__spec_coll_ids, s.spec_ident_ids AS s__spec_ident_ids, s.spec_don_sel_ids AS s__spec_don_sel_ids, s.collection_type AS s__collection_type, s.collection_code AS s__collection_code, s.collection_name AS s__collection_name, s.collection_is_public AS s__collection_is_public, s.collection_parent_ref AS s__collection_parent_ref, s.collection_path AS s__collection_path, s.expedition_name AS s__expedition_name, s.expedition_name_indexed AS s__expedition_name_indexed, s.gtu_code AS s__gtu_code, s.gtu_from_date_mask AS s__gtu_from_date_mask, s.gtu_from_date AS s__gtu_from_date, s.gtu_to_date_mask AS s__gtu_to_date_mask, s.gtu_to_date AS s__gtu_to_date, s.gtu_others_tag_value AS s__gtu_others_tag_value, s.gtu_tag_values_indexed AS s__gtu_tag_values_indexed, s.gtu_country_tag_indexed AS s__gtu_country_tag_indexed, s.gtu_country_tag_value AS s__gtu_country_tag_value, s.gtu_location AS s__gtu_location, s.gtu_elevation AS s__gtu_elevation, s.gtu_elevation_accuracy AS s__gtu_elevation_accuracy, s.taxon_name AS s__taxon_name, s.taxon_name_indexed AS s__taxon_name_indexed, s.taxon_level_ref AS s__taxon_level_ref, s.taxon_level_name AS s__taxon_level_name, s.taxon_status AS s__taxon_status, s.taxon_path AS s__taxon_path, s.taxon_parent_ref AS s__taxon_parent_ref, s.taxon_extinct AS s__taxon_extinct, s.litho_name AS s__litho_name, s.litho_name_indexed AS s__litho_name_indexed, s.litho_level_ref AS s__litho_level_ref, s.litho_level_name AS s__litho_level_name, s.litho_status AS s__litho_status, s.litho_local AS s__litho_local, s.litho_color AS s__litho_color, s.litho_path AS s__litho_path, s.litho_parent_ref AS s__litho_parent_ref, s.chrono_name AS s__chrono_name, s.chrono_name_indexed AS s__chrono_name_indexed, s.chrono_level_ref AS s__chrono_level_ref, s.chrono_level_name AS s__chrono_level_name, s.chrono_status AS s__chrono_status, s.chrono_local AS s__chrono_local, s.chrono_color AS s__chrono_color, s.chrono_path AS s__chrono_path, s.chrono_parent_ref AS s__chrono_parent_ref, s.lithology_name AS s__lithology_name, s.lithology_name_indexed AS s__lithology_name_indexed, s.lithology_level_ref AS s__lithology_level_ref, s.lithology_level_name AS s__lithology_level_name, s.lithology_status AS s__lithology_status, s.lithology_local AS s__lithology_local, s.lithology_color AS s__lithology_color, s.lithology_path AS s__lithology_path, s.lithology_parent_ref AS s__lithology_parent_ref, s.mineral_name AS s__mineral_name, s.mineral_name_indexed AS s__mineral_name_indexed, s.mineral_level_ref AS s__mineral_level_ref, s.mineral_level_name AS s__mineral_level_name, s.mineral_status AS s__mineral_status, s.mineral_local AS s__mineral_local, s.mineral_color AS s__mineral_color, s.mineral_path AS s__mineral_path, s.mineral_parent_ref AS s__mineral_parent_ref, s.ig_num AS s__ig_num, s.ig_num_indexed AS s__ig_num_indexed, s.ig_date_mask AS s__ig_date_mask, s.type AS s__type, s.type_group AS s__type_group, s.type_search AS s__type_search, s.sex AS s__sex, s.stage AS s__stage, s.state AS s__state, s.social_status AS s__social_status, s.rock_form AS s__rock_form, s.specimen_part AS s__specimen_part, s.complete AS s__complete, s.institution_ref AS s__institution_ref, s.building AS s__building, s.floor AS s__floor, s.room AS s__room, s.row AS s__row, s.col AS s__col, s.shelf AS s__shelf, s.container AS s__container, s.sub_container AS s__sub_container, s.container_type AS s__container_type, s.sub_container_type AS s__sub_container_type, s.container_storage AS s__container_storage, s.sub_container_storage AS s__sub_container_storage, s.surnumerary AS s__surnumerary, s.specimen_status AS s__specimen_status, s.specimen_count_min AS s__specimen_count_min, s.specimen_count_max AS s__specimen_count_max, s.object_name AS s__object_name, s.object_name_indexed AS s__object_name_indexed, s.specimen_count_males_min AS s__specimen_count_males_min, s.specimen_count_males_max AS s__specimen_count_males_max, s.specimen_count_females_min AS s__specimen_count_females_min, s.specimen_count_females_max AS s__specimen_count_females_max, s.specimen_count_juveniles_min AS s__specimen_count_juveniles_min, s.specimen_count_juveniles_max AS s__specimen_count_juveniles_max, s.specimen_creation_date AS s__specimen_creation_date, s.import_ref AS s__import_ref, s.main_code_indexed AS s__main_code_indexed, s.nagoya AS s__nagoya, s.uuid AS s__uuid, s.ig_main_code_indexed AS s__ig_main_code_indexed, s.mids_level AS s__mids_level FROM specimens s WHERE (s.collection_is_public = true) ORDER BY RANDOM() LIMIT 3 - () |
7 | sfPHPView | Render "sf_app_dir/modules/board/templates/indexSuccess.php" |
8 | main | Set slot "title" |
9 | sfPartialView | Render "sf_app_dir/modules/board/templates/_welcome_en.php" |
10 | sfPHPView | Decorate content with "sf_app_dir/templates/layout.php" |
11 | sfPHPView | Render "sf_app_dir/templates/layout.php" |
12 | main | Get slot "title" |
13 | sfPartialView | Render "sf_app_dir/templates/_head_menu.php" |
14 | main | Call "login->executeMenuLogin()" |
15 | sfPartialView | Render "sf_app_dir/modules/login/templates/_MenuLogin.php" |
16 | sfPartialView | Render "sf_app_dir/templates/_analytics.php" |
17 | sfWebResponse | Send status "HTTP/1.0 200 OK" |
18 | sfWebResponse | Send header "Content-Type: text/html; charset=utf-8" |
type | calls | time (ms) | time (%) |
---|---|---|---|
Configuration | 14 | 47.33 | 0 |
Factories | 1 | 1.34 | 0 |
Action "board/index" | 1 | 5916.28 | 99 |
Database (Doctrine) | 2 | 5897.40 | 98 |
View "Success" for "board/index" | 1 | 3.41 | 0 |
Partial "board/_welcome_en" | 1 | 0.55 | 0 |
Partial "global/_head_menu" | 1 | 1.18 | 0 |
Component "login/MenuLogin" | 1 | 0.31 | 0 |
Partial "login/_MenuLogin" | 1 | 0.26 | 0 |
Partial "global/_analytics" | 1 | 0.06 | 0 |
SET NAMES 'UTF8'
SELECT s.id AS s__id, s.category AS s__category, s.collection_ref AS s__collection_ref, s.expedition_ref AS s__expedition_ref, s.gtu_ref AS s__gtu_ref, s.taxon_ref AS s__taxon_ref, s.litho_ref AS s__litho_ref, s.chrono_ref AS s__chrono_ref, s.lithology_ref AS s__lithology_ref, s.mineral_ref AS s__mineral_ref, s.acquisition_category AS s__acquisition_category, s.acquisition_date_mask AS s__acquisition_date_mask, s.acquisition_date AS s__acquisition_date, s.station_visible AS s__station_visible, s.ig_ref AS s__ig_ref, s.restricted_access AS s__restricted_access, s.spec_coll_ids AS s__spec_coll_ids, s.spec_ident_ids AS s__spec_ident_ids, s.spec_don_sel_ids AS s__spec_don_sel_ids, s.collection_type AS s__collection_type, s.collection_code AS s__collection_code, s.collection_name AS s__collection_name, s.collection_is_public AS s__collection_is_public, s.collection_parent_ref AS s__collection_parent_ref, s.collection_path AS s__collection_path, s.expedition_name AS s__expedition_name, s.expedition_name_indexed AS s__expedition_name_indexed, s.gtu_code AS s__gtu_code, s.gtu_from_date_mask AS s__gtu_from_date_mask, s.gtu_from_date AS s__gtu_from_date, s.gtu_to_date_mask AS s__gtu_to_date_mask, s.gtu_to_date AS s__gtu_to_date, s.gtu_others_tag_value AS s__gtu_others_tag_value, s.gtu_tag_values_indexed AS s__gtu_tag_values_indexed, s.gtu_country_tag_indexed AS s__gtu_country_tag_indexed, s.gtu_country_tag_value AS s__gtu_country_tag_value, s.gtu_location AS s__gtu_location, s.gtu_elevation AS s__gtu_elevation, s.gtu_elevation_accuracy AS s__gtu_elevation_accuracy, s.taxon_name AS s__taxon_name, s.taxon_name_indexed AS s__taxon_name_indexed, s.taxon_level_ref AS s__taxon_level_ref, s.taxon_level_name AS s__taxon_level_name, s.taxon_status AS s__taxon_status, s.taxon_path AS s__taxon_path, s.taxon_parent_ref AS s__taxon_parent_ref, s.taxon_extinct AS s__taxon_extinct, s.litho_name AS s__litho_name, s.litho_name_indexed AS s__litho_name_indexed, s.litho_level_ref AS s__litho_level_ref, s.litho_level_name AS s__litho_level_name, s.litho_status AS s__litho_status, s.litho_local AS s__litho_local, s.litho_color AS s__litho_color, s.litho_path AS s__litho_path, s.litho_parent_ref AS s__litho_parent_ref, s.chrono_name AS s__chrono_name, s.chrono_name_indexed AS s__chrono_name_indexed, s.chrono_level_ref AS s__chrono_level_ref, s.chrono_level_name AS s__chrono_level_name, s.chrono_status AS s__chrono_status, s.chrono_local AS s__chrono_local, s.chrono_color AS s__chrono_color, s.chrono_path AS s__chrono_path, s.chrono_parent_ref AS s__chrono_parent_ref, s.lithology_name AS s__lithology_name, s.lithology_name_indexed AS s__lithology_name_indexed, s.lithology_level_ref AS s__lithology_level_ref, s.lithology_level_name AS s__lithology_level_name, s.lithology_status AS s__lithology_status, s.lithology_local AS s__lithology_local, s.lithology_color AS s__lithology_color, s.lithology_path AS s__lithology_path, s.lithology_parent_ref AS s__lithology_parent_ref, s.mineral_name AS s__mineral_name, s.mineral_name_indexed AS s__mineral_name_indexed, s.mineral_level_ref AS s__mineral_level_ref, s.mineral_level_name AS s__mineral_level_name, s.mineral_status AS s__mineral_status, s.mineral_local AS s__mineral_local, s.mineral_color AS s__mineral_color, s.mineral_path AS s__mineral_path, s.mineral_parent_ref AS s__mineral_parent_ref, s.ig_num AS s__ig_num, s.ig_num_indexed AS s__ig_num_indexed, s.ig_date_mask AS s__ig_date_mask, s.type AS s__type, s.type_group AS s__type_group, s.type_search AS s__type_search, s.sex AS s__sex, s.stage AS s__stage, s.state AS s__state, s.social_status AS s__social_status, s.rock_form AS s__rock_form, s.specimen_part AS s__specimen_part, s.complete AS s__complete, s.institution_ref AS s__institution_ref, s.building AS s__building, s.floor AS s__floor, s.room AS s__room, s.row AS s__row, s.col AS s__col, s.shelf AS s__shelf, s.container AS s__container, s.sub_container AS s__sub_container, s.container_type AS s__container_type, s.sub_container_type AS s__sub_container_type, s.container_storage AS s__container_storage, s.sub_container_storage AS s__sub_container_storage, s.surnumerary AS s__surnumerary, s.specimen_status AS s__specimen_status, s.specimen_count_min AS s__specimen_count_min, s.specimen_count_max AS s__specimen_count_max, s.object_name AS s__object_name, s.object_name_indexed AS s__object_name_indexed, s.specimen_count_males_min AS s__specimen_count_males_min, s.specimen_count_males_max AS s__specimen_count_males_max, s.specimen_count_females_min AS s__specimen_count_females_min, s.specimen_count_females_max AS s__specimen_count_females_max, s.specimen_count_juveniles_min AS s__specimen_count_juveniles_min, s.specimen_count_juveniles_max AS s__specimen_count_juveniles_max, s.specimen_creation_date AS s__specimen_creation_date, s.import_ref AS s__import_ref, s.main_code_indexed AS s__main_code_indexed, s.nagoya AS s__nagoya, s.uuid AS s__uuid, s.ig_main_code_indexed AS s__ig_main_code_indexed, s.mids_level AS s__mids_level FROM specimens s WHERE (s.collection_is_public = true) ORDER BY RANDOM() LIMIT 3