search

npolar / marine-db

https://doi.org/10.21334/marine-db
0 stars 0 forks source link

Non-unique eventIDs #40

Closed cnrdh closed 4 years ago

cnrdh commented 4 years ago 

conrad@nordfjellet:~/npolar/marine-db$ ./bin/sampling-events-mosjify  | ndjson-map d.eventID | sort | uniq -cd
      3 "08817bd2-4180-5cc3-9b45-6cdf015c891e"
      2 "08d55c4d-fce4-5986-976f-2ad844bb0efd"
      3 "0f04da54-3719-5ed6-a70e-efcc513f807f"
      5 "13c9ac48-e4ee-528b-b4be-648178bbb1a4"
      2 "1b645c10-5fee-5dc8-9a0d-8c008a25df47"
      3 "1c86f0c0-ec76-5291-953e-b2b9edfe6235"
      2 "20cf7938-6fc2-58d5-be69-789df6df61ba"
      3 "30db2ee1-65f5-572b-b7d5-a03499e2e37d"
      2 "37717336-59cc-5e30-95ba-51dbd88a23ca"
     10 "3c6c288e-70db-5abc-9560-6f692c0ba848"
      2 "3ef566f3-080e-5c80-9ad8-4a3d3d472741"
      2 "43b08d3e-30ae-5333-a9c4-e27e5e90bb03"
      2 "5cb4d680-956a-5186-a31a-18592bcdab64"
      3 "60beb0a3-72bf-5f75-b33f-3665d3087547"
      3 "6419d686-386d-56f0-b71e-a093509f4bc4"
      2 "679b0ec0-730e-5530-ae31-e826cdd2daca"
      4 "6c99d65c-aee9-5f0b-a2ec-66ef5d468919"
      2 "73aa7509-fc6c-5f61-aee5-1629b582ef8f"
     11 "83fcdd18-3d5b-501b-936c-51b9f1c7add1"
      2 "8e465810-4c5e-58bd-8302-34fba5dc4dc2"
      2 "938d1b8b-0f44-5ce3-85a9-23a37c3009c7"
      2 "9680d820-ac54-58b7-bcec-fbb749e65670"
      2 "9e35b381-4a24-5dfb-b51c-9dd50030fb57"
      2 "a1617564-32d2-55a2-b14e-7e00f6a69a92"
      2 "a44a2a6c-7a3e-59ed-bb0a-83f7bc0dba36"
      2 "a4d1433f-ac1e-586a-a996-dc63279fc244"
      2 "ad4aac1f-a7c2-56ed-9910-646635f5b4b1"
      2 "b1f9c3d5-e817-59fe-be33-7d92454c9a45"
      2 "b7015fc2-13f5-50f2-a6dd-dc626f6504a0"
      2 "bb0793c8-7b4b-5a7f-acab-1d3ebed6b93e"
      2 "bb41e464-2bac-58e3-a939-92144f863f0f"
      3 "bb494ea6-62a9-57b3-97b7-3b0f7025fb63"
     10 "be7e618d-8224-5b64-97c8-ecb8af50e73f"
      6 "bf566495-0b65-5f39-8e94-7f854ce79d1a"
      2 "c757b467-7bf0-5dd5-9013-649db3644e1b"
      2 "d0eeca30-1280-5fb4-88d6-75d1313701e2"
      2 "d4c841f1-33eb-57e4-8ac9-e4ec8738d192"
      2 "d949eb5d-245e-56b7-870e-c01bb558f748"
      2 "d9881d64-2331-51c1-8cb2-5bb2716c6b01"
      2 "e0257498-4609-5a12-8973-747861eb886e"
      2 "e02f6abf-a81e-5f9b-94d6-4c3582458865"
     13 "e093485e-6401-5e8d-8ece-80036b88ec48"
      2 "e30c519a-3163-52d3-b0bf-01d003dc4ecd"
     16 "e55187c4-c0bc-5317-add4-842d0a0ecb63"
      3 "e5e46509-d7be-57a9-8409-3e152389115a"
     12 "ec211c2a-5eaa-588c-a919-ceeab87b6054"
      2 "ecc061ab-7e82-5ac4-827b-dbf3c1c2f4ae"
      2 "ed99dcbd-ea7a-53b6-b979-ad443b3a9141"
      2 "f399a97c-4f34-58f0-903a-9c46135eab6f"
      2 "f522dd1c-a2ae-515c-aed6-d93c2cdbd012"
cnrdh commented 4 years ago

Example


conrad@nordfjellet:~/npolar/marine-db$ ./bin/sampling-events-mosjify  | grep 3c6c288e-70db-5abc-9560-6f692c0ba848
{"eventID":"3c6c288e-70db-5abc-9560-6f692c0ba848","eventDate":"2018-07-15T07:39:00Z","year":2018,"locationID":"V12","decimalLongitude":9.493,"decimalLatitude":78.981,"maximumDepthInMeters":200,"bottomDepth":222,"recordedBy":"Agnetha Fransson","eventRemarks":"Duplicat, bottles 11;18","type":"MaterialSample","modified":"2020-06-11T07:25:28.403Z","gear":"Niskin bottle","expedition":"MOSJ2018","materialSampleID":"UNDEFINED@MOSJ2018","fieldNumber":"UNDEFINED","sampleType":"Oxygen-winkler"}
{"eventID":"3c6c288e-70db-5abc-9560-6f692c0ba848","eventDate":"2018-07-15T07:39:00Z","year":2018,"locationID":"V12","decimalLongitude":9.493,"decimalLatitude":78.981,"maximumDepthInMeters":25,"bottomDepth":222,"recordedBy":"Agnetha Fransson","eventRemarks":"Duplicat, bottles 16;20","type":"MaterialSample","modified":"2020-06-11T07:25:28.403Z","gear":"Niskin bottle","expedition":"MOSJ2018","materialSampleID":"UNDEFINED@MOSJ2018","fieldNumber":"UNDEFINED","sampleType":"Oxygen-winkler"}
{"eventID":"3c6c288e-70db-5abc-9560-6f692c0ba848","eventDate":"2018-07-15T07:39:00Z","year":2018,"locationID":"V12","decimalLongitude":9.493,"decimalLatitude":78.981,"maximumDepthInMeters":10,"bottomDepth":222,"recordedBy":"Agnetha Fransson","eventRemarks":"Duplicat, bottles 12;9","type":"MaterialSample","modified":"2020-06-11T07:25:28.403Z","gear":"Niskin bottle","expedition":"MOSJ2018","materialSampleID":"UNDEFINED@MOSJ2018","fieldNumber":"UNDEFINED","sampleType":"Oxygen-winkler"}
{"eventID":"3c6c288e-70db-5abc-9560-6f692c0ba848","eventDate":"2018-07-15T07:39:00Z","year":2018,"locationID":"V12","decimalLongitude":9.493,"decimalLatitude":78.981,"maximumDepthInMeters":5,"bottomDepth":222,"recordedBy":"Agnetha Fransson","eventRemarks":"Duplicat, bottles 10;20","type":"MaterialSample","modified":"2020-06-11T07:25:28.403Z","gear":"Niskin bottle","expedition":"MOSJ2018","materialSampleID":"UNDEFINED@MOSJ2018","fieldNumber":"UNDEFINED","sampleType":"Oxygen-winkler"}
{"eventID":"3c6c288e-70db-5abc-9560-6f692c0ba848","eventDate":"2018-07-15T15:00:00Z","year":2018,"locationID":"V6","decimalLongitude":7.769,"decimalLatitude":78.923,"maximumDepthInMeters":1100,"bottomDepth":1130,"recordedBy":"Agnetha Fransson","eventRemarks":"Duplicat, bottles 1;2;3","type":"MaterialSample","modified":"2020-06-11T07:25:28.411Z","gear":"Niskin bottle","expedition":"MOSJ2018","materialSampleID":"UNDEFINED@MOSJ2018","fieldNumber":"UNDEFINED","sampleType":"Oxygen-winkler"}
{"eventID":"3c6c288e-70db-5abc-9560-6f692c0ba848","eventDate":"2018-07-15T15:00:00Z","year":2018,"locationID":"V6","decimalLongitude":7.769,"decimalLatitude":78.923,"maximumDepthInMeters":400,"bottomDepth":1130,"recordedBy":"Agnetha Fransson","eventRemarks":"Duplicat, bottles 4;5;6","type":"MaterialSample","modified":"2020-06-11T07:25:28.411Z","gear":"Niskin bottle","expedition":"MOSJ2018","materialSampleID":"UNDEFINED@MOSJ2018","fieldNumber":"UNDEFINED","sampleType":"Oxygen-winkler"}
{"eventID":"3c6c288e-70db-5abc-9560-6f692c0ba848","eventDate":"2018-07-15T18:21:00Z","year":2018,"locationID":"V6","decimalLongitude":7.727,"decimalLatitude":78.921,"maximumDepthInMeters":100,"bottomDepth":1130,"recordedBy":"Agnetha Fransson","eventRemarks":"Duplicat, bottles 7;8;9","type":"MaterialSample","modified":"2020-06-11T07:25:28.416Z","gear":"Niskin bottle","expedition":"MOSJ2018","materialSampleID":"UNDEFINED@MOSJ2018","fieldNumber":"UNDEFINED","sampleType":"Oxygen-winkler"}
{"eventID":"3c6c288e-70db-5abc-9560-6f692c0ba848","eventDate":"2018-07-15T18:21:00Z","year":2018,"locationID":"V6","decimalLongitude":7.727,"decimalLatitude":78.921,"maximumDepthInMeters":50,"bottomDepth":1130,"recordedBy":"Agnetha Fransson","eventRemarks":"Duplicat, bottles 10;11;12","type":"MaterialSample","modified":"2020-06-11T07:25:28.416Z","gear":"Niskin bottle","expedition":"MOSJ2018","materialSampleID":"UNDEFINED@MOSJ2018","fieldNumber":"UNDEFINED","sampleType":"Oxygen-winkler"}
{"eventID":"3c6c288e-70db-5abc-9560-6f692c0ba848","eventDate":"2018-07-15T18:21:00Z","year":2018,"locationID":"V6","decimalLongitude":7.727,"decimalLatitude":78.921,"maximumDepthInMeters":25,"bottomDepth":1130,"recordedBy":"Agnetha Fransson","eventRemarks":"Duplicat, bottles 13;14;15","type":"MaterialSample","modified":"2020-06-11T07:25:28.416Z","gear":"Niskin bottle","expedition":"MOSJ2018","materialSampleID":"UNDEFINED@MOSJ2018","fieldNumber":"UNDEFINED","sampleType":"Oxygen-winkler"}
{"eventID":"3c6c288e-70db-5abc-9560-6f692c0ba848","eventDate":"2018-07-15T18:21:00Z","year":2018,"locationID":"V6","decimalLongitude":7.727,"decimalLatitude":78.921,"maximumDepthInMeters":5,"bottomDepth":1130,"recordedBy":"Agnetha Fransson","eventRemarks":"Duplicat, bottles 16;17;19","type":"MaterialSample","modified":"2020-06-11T07:25:28.416Z","gear":"Niskin bottle","expedition":"MOSJ2018","materialSampleID":"UNDEFINED@MOSJ2018","fieldNumber":"UNDEFINED","sampleType":"Oxygen-winkler"}
cnrdh commented 4 years ago

The duplicate eventIDs only left for future reference