individualcount is empty / please replace in list view with quantity #4382
Labels
Bug
Arctos is not performing as it should.
Milestone
Comments
|
Duplicate of #4032 (comment) - let me know what you want (still |
|
Whatever equals a count of organisms of the taxon of the catalog record.
It sounds like we're getting confused between counts of parts and counts of
organisms? If I have 1 organism that has 3 parts I want to see a count of 1
for that record. If I have 355 organisms in a vial I want to see a count of
355 for that record.
Can we do this? Please say yes.
…-Derek
On Fri, Feb 25, 2022 at 2:22 PM dustymc ***@***.***> wrote:
Duplicate of #4032 (comment)
<#4032 (comment)>
- let me know what you want (still max(lot_count)?) and I can create the
initial attributes.
—
Reply to this email directly, view it on GitHub
<#4382 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/ACFNUM5OSMANKQTTL22UJ7TU5AFL5ANCNFSM5PLQMWWA>
.
Triage notifications on the go with GitHub Mobile for iOS
<https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675>
or Android
<https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.
You are receiving this because you authored the thread.Message ID:
***@***.***>
--
+++++++++++++++++++++++++++++++++++
*Derek S. Sikes*, Curator of Insects, Professor of Entomology
University of Alaska Museum (UAM), University of Alaska Fairbanks
1962 Yukon Drive, Fairbanks, AK 99775-6960
***@***.*** phone: 907-474-6278 he/him/his
University of Alaska Museum <https://www.uaf.edu/museum/collections/ento/>
- search 357,704 digitized arthropod records
<http://arctos.database.museum/uam_ento>
+++++++++++++++++++++++++++++++++++
Interested in Alaskan Entomology? Join the Alaska Entomological
Society and / or sign up for the email listserv "Alaska Entomological
Network" at
http://www.akentsoc.org/contact_us
|
Yes, that's where the other issue came from. I'm not very good at guessing (probably, I can't know that either!) at what might be cataloged, if this is an important number then it needs to come from the folks who can know. That's you - but I can help with the initial load if you can provide direction. (I know exactly how many parts you claim to have, I can just count them and multiply by lot count, this brings the same kind of certainty to organisms.) "Yes" - if you can tell me how I can tell those two situations apart. Sum of whole organism lot counts, or 1 for records with no whole organism part?? |
|
Good!
& yes= Sum of whole organism lot counts, or 1 for records with no whole
organism part. But perhaps I should first look at some records that have no
whole organism part... I doubt we have any but if we do I'm curious to find
these.
…-Derek
On Fri, Feb 25, 2022 at 2:40 PM dustymc ***@***.***> wrote:
getting confused between counts of parts and counts of organisms
Yes, that's where the other issue came from. I'm not very good at guessing
(probably, I can't know that either!) at what might be cataloged, if this
is an important number then it needs to come from the folks who can know.
That's you - but I can help with the initial load if you can provide
direction. (I know exactly how many parts you claim to have, I can just
count them and multiply by lot count, this brings the same kind of
certainty to organisms.)
"Yes" - if you can tell me how I can tell those two situations apart.
Sum of whole organism lot counts, or 1 for records with no whole organism
part??
—
Reply to this email directly, view it on GitHub
<#4382 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/ACFNUM3RD54IAEWFLFXQ6X3U5AHORANCNFSM5PLQMWWA>
.
Triage notifications on the go with GitHub Mobile for iOS
<https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675>
or Android
<https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.
You are receiving this because you authored the thread.Message ID:
***@***.***>
--
+++++++++++++++++++++++++++++++++++
*Derek S. Sikes*, Curator of Insects, Professor of Entomology
University of Alaska Museum (UAM), University of Alaska Fairbanks
1962 Yukon Drive, Fairbanks, AK 99775-6960
***@***.*** phone: 907-474-6278 he/him/his
University of Alaska Museum <https://www.uaf.edu/museum/collections/ento/>
- search 357,704 digitized arthropod records
<http://arctos.database.museum/uam_ento>
+++++++++++++++++++++++++++++++++++
Interested in Alaskan Entomology? Join the Alaska Entomological
Society and / or sign up for the email listserv "Alaska Entomological
Network" at
http://www.akentsoc.org/contact_us
|
|
yes= Sum of whole organism lot counts, or 1 for records with no whole |
Not many - here they are I can get the rest out if you want to preview them, but the table's a little huge. Here are a few, hopefully that's sufficient. |
Like most things DWC (or Occurrence, hopefully https://github.com/ArctosDB/internal/issues/168 is going to change things), this completely falls apart when there's any complexity involved. The definition does not help (see the other issue for an example!): "The number of individuals present at the time of the Occurrence." What the hell's that supposed to mean? Something involving spatial and temporal precision? What's the sightability correction factor?! That can't be right.... If this is somehow useful to you, put whatever's useful in there. If it's not, ignore it. |
|
D,
I checked two of these and they both have part = whole organism
https://arctos.database.museum/guid/UAM:Ento:411674
https://arctos.database.museum/guid/UAM:Ento:259614
So I'm confused, I thought you were providing a list of records that lack a
whole organism part?
…-Derek
On Fri, Feb 25, 2022 at 3:24 PM dustymc ***@***.***> wrote:
doubt we have any
Not many - here they are
temp_uamecic_nwe.csv.zip
<https://github.com/ArctosDB/arctos/files/8145511/temp_uamecic_nwe.csv.zip>
I can get the rest out if you want to preview them, but the table's a
little huge. Here are a few, hopefully that's sufficient.
***@***.***>> select * from temp_uamecic order by random() limit 100;
collection_object_id | guid | attribute_value | attribute | attribute_units | determiner
----------------------+-----------------+-----------------+------------------+-----------------+----------------
23596658 | UAM:Ento:259614 | 1 | individual count | individuals | Derek S. Sikes
554560 | UAM:Ento:411674 | 1 | individual count | individuals | Derek S. Sikes
24579699 | UAM:Ento:426671 | 1 | individual count | individuals | Derek S. Sikes
22011921 | UAM:Ento:74774 | 1 | individual count | individuals | Derek S. Sikes
26513059 | UAM:Ento:344971 | 2 | individual count | individuals | Derek S. Sikes
22066971 | UAM:Ento:113567 | 2 | individual count | individuals | Derek S. Sikes
22024065 | UAM:Ento:82414 | 1 | individual count | individuals | Derek S. Sikes
22148337 | UAM:Ento:136243 | 1 | individual count | individuals | Derek S. Sikes
23621847 | UAM:Ento:269440 | 1 | individual count | individuals | Derek S. Sikes
28155405 | UAM:Ento:430407 | 1 | individual count | individuals | Derek S. Sikes
22143742 | UAM:Ento:133882 | 1 | individual count | individuals | Derek S. Sikes
22152151 | UAM:Ento:138759 | 1 | individual count | individuals | Derek S. Sikes
29020012 | UAM:Ento:440864 | 1 | individual count | individuals | Derek S. Sikes
22856489 | UAM:Ento:245828 | 2 | individual count | individuals | Derek S. Sikes
22214386 | UAM:Ento:171363 | 7 | individual count | individuals | Derek S. Sikes
28301948 | UAM:Ento:381646 | 1 | individual count | individuals | Derek S. Sikes
24377879 | UAM:Ento:306378 | 1 | individual count | individuals | Derek S. Sikes
22856441 | UAM:Ento:245804 | 1 | individual count | individuals | Derek S. Sikes
24263481 | UAM:Ento:295996 | 12 | individual count | individuals | Derek S. Sikes
25885860 | UAM:Ento:427092 | 1 | individual count | individuals | Derek S. Sikes
28429567 | UAM:Ento:397570 | 1 | individual count | individuals | Derek S. Sikes
22053920 | UAM:Ento:106286 | 1 | individual count | individuals | Derek S. Sikes
28462280 | UAM:Ento:402275 | 1 | individual count | individuals | Derek S. Sikes
23594953 | UAM:Ento:259198 | 3 | individual count | individuals | Derek S. Sikes
22250831 | UAM:Ento:189616 | 1 | individual count | individuals | Derek S. Sikes
22213730 | UAM:Ento:171029 | 1 | individual count | individuals | Derek S. Sikes
24495180 | UAM:Ento:314680 | 1 | individual count | individuals | Derek S. Sikes
22629559 | UAM:Ento:231041 | 1 | individual count | individuals | Derek S. Sikes
22254385 | UAM:Ento:191393 | 1 | individual count | individuals | Derek S. Sikes
30008551 | UAM:Ento:455433 | 1 | individual count | individuals | Derek S. Sikes
28183410 | UAM:Ento:378335 | 1 | individual count | individuals | Derek S. Sikes
24465459 | UAM:Ento:313625 | 1 | individual count | individuals | Derek S. Sikes
22126793 | UAM:Ento:123320 | 1 | individual count | individuals | Derek S. Sikes
28395271 | UAM:Ento:423211 | 1 | individual count | individuals | Derek S. Sikes
22297226 | UAM:Ento:212884 | 1 | individual count | individuals | Derek S. Sikes
22275456 | UAM:Ento:201954 | 1 | individual count | individuals | Derek S. Sikes
28316888 | UAM:Ento:384901 | 1 | individual count | individuals | Derek S. Sikes
22111781 | UAM:Ento:108357 | 1 | individual count | individuals | Derek S. Sikes
23639180 | UAM:Ento:273564 | 1 | individual count | individuals | Derek S. Sikes
23732914 | UAM:Ento:288402 | 1 | individual count | individuals | Derek S. Sikes
23752005 | UAM:Ento:289324 | 1 | individual count | individuals | Derek S. Sikes
22307416 | UAM:Ento:221840 | 1 | individual count | individuals | Derek S. Sikes
22014246 | UAM:Ento:76631 | 1 | individual count | individuals | Derek S. Sikes
22052934 | UAM:Ento:97388 | 1 | individual count | individuals | Derek S. Sikes
22283012 | UAM:Ento:205744 | 1 | individual count | individuals | Derek S. Sikes
23064151 | UAM:Ento:255741 | 1 | individual count | individuals | Derek S. Sikes
22219001 | UAM:Ento:173659 | 1 | individual count | individuals | Derek S. Sikes
25755480 | UAM:Ento:318374 | 1 | individual count | individuals | Derek S. Sikes
23606175 | UAM:Ento:262412 | 1 | individual count | individuals | Derek S. Sikes
22208326 | UAM:Ento:168184 | 1 | individual count | individuals | Derek S. Sikes
23041588 | UAM:Ento:252701 | 2 | individual count | individuals | Derek S. Sikes
28318888 | UAM:Ento:385893 | 1 | individual count | individuals | Derek S. Sikes
22189526 | UAM:Ento:158631 | 1 | individual count | individuals | Derek S. Sikes
22136386 | UAM:Ento:130115 | 1 | individual count | individuals | Derek S. Sikes
21978799 | UAM:Ento:15229 | 1 | individual count | individuals | Derek S. Sikes
22920229 | UAM:Ento:248537 | 3 | individual count | individuals | Derek S. Sikes
22246123 | UAM:Ento:187260 | 1 | individual count | individuals | Derek S. Sikes
28293456 | UAM:Ento:431033 | 1 | individual count | individuals | Derek S. Sikes
25846953 | UAM:Ento:329726 | 27 | individual count | individuals | Derek S. Sikes
28426625 | UAM:Ento:396099 | 1 | individual count | individuals | Derek S. Sikes
28320598 | UAM:Ento:386748 | 1 | individual count | individuals | Derek S. Sikes
21998631 | UAM:Ento:27019 | 1 | individual count | individuals | Derek S. Sikes
22309210 | UAM:Ento:225904 | 2 | individual count | individuals | Derek S. Sikes
22015311 | UAM:Ento:76142 | 1 | individual count | individuals | Derek S. Sikes
23788274 | UAM:Ento:292369 | 1 | individual count | individuals | Derek S. Sikes
22007545 | UAM:Ento:71889 | 1 | individual count | individuals | Derek S. Sikes
28184251 | UAM:Ento:378496 | 1 | individual count | individuals | Derek S. Sikes
27972276 | UAM:Ento:374861 | 10 | individual count | individuals | Derek S. Sikes
23792928 | UAM:Ento:292594 | 1 | individual count | individuals | Derek S. Sikes
22043627 | UAM:Ento:99017 | 1 | individual count | individuals | Derek S. Sikes
24393628 | UAM:Ento:310002 | 1 | individual count | individuals | Derek S. Sikes
26883741 | UAM:Ento:354589 | 1 | individual count | individuals | Derek S. Sikes
22174022 | UAM:Ento:150675 | 3 | individual count | individuals | Derek S. Sikes
22036940 | UAM:Ento:95374 | 1 | individual count | individuals | Derek S. Sikes
24422652 | UAM:Ento:444980 | 1 | individual count | individuals | Derek S. Sikes
22450729 | UAM:Ento:18014 | 1 | individual count | individuals | Derek S. Sikes
24359647 | UAM:Ento:302505 | 2 | individual count | individuals | Derek S. Sikes
21989536 | UAM:Ento:22984 | 1 | individual count | individuals | Derek S. Sikes
23028024 | UAM:Ento:251027 | 1 | individual count | individuals | Derek S. Sikes
22213504 | UAM:Ento:170914 | 7 | individual count | individuals | Derek S. Sikes
21979550 | UAM:Ento:17335 | 1 | individual count | individuals | Derek S. Sikes
22925525 | UAM:Ento:249005 | 1 | individual count | individuals | Derek S. Sikes
22265484 | UAM:Ento:196954 | 1 | individual count | individuals | Derek S. Sikes
29896030 | UAM:Ento:449857 | 1 | individual count | individuals | Derek S. Sikes
24504574 | UAM:Ento:316339 | 1 | individual count | individuals | Derek S. Sikes
25793805 | UAM:Ento:322304 | 1 | individual count | individuals | Derek S. Sikes
22000980 | UAM:Ento:67988 | 1 | individual count | individuals | Derek S. Sikes
22209975 | UAM:Ento:169004 | 1 | individual count | individuals | Derek S. Sikes
30016361 | UAM:Ento:456656 | 1 | individual count | individuals | Derek S. Sikes
28793022 | UAM:Ento:432795 | 1 | individual count | individuals | Derek S. Sikes
22130265 | UAM:Ento:125070 | 1 | individual count | individuals | Derek S. Sikes
22247293 | UAM:Ento:187845 | 1 | individual count | individuals | Derek S. Sikes
28955568 | UAM:Ento:438090 | 1 | individual count | individuals | Derek S. Sikes
22114875 | UAM:Ento:116768 | 50 | individual count | individuals | Derek S. Sikes
26733836 | UAM:Ento:347367 | 1 | individual count | individuals | Derek S. Sikes
23622678 | UAM:Ento:269779 | 1 | individual count | individuals | Derek S. Sikes
22142186 | UAM:Ento:133070 | 1 | individual count | individuals | Derek S. Sikes
24219925 | UAM:Ento:444537 | 2 | individual count | individuals | Derek S. Sikes
25783268 | UAM:Ento:320064 | 4 | individual count | individuals | Derek S. Sikes
22212711 | UAM:Ento:170403 | 1 | individual count | individuals | Derek S. Sikes
(100 rows)
—
Reply to this email directly, view it on GitHub
<#4382 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/ACFNUMZMWW7JO3W7MFDREETU5AMUZANCNFSM5PLQMWWA>
.
Triage notifications on the go with GitHub Mobile for iOS
<https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675>
or Android
<https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.
You are receiving this because you authored the thread.Message ID:
***@***.***>
--
+++++++++++++++++++++++++++++++++++
*Derek S. Sikes*, Curator of Insects, Professor of Entomology
University of Alaska Museum (UAM), University of Alaska Fairbanks
1962 Yukon Drive, Fairbanks, AK 99775-6960
***@***.*** phone: 907-474-6278 he/him/his
University of Alaska Museum <https://www.uaf.edu/museum/collections/ento/>
- search 357,704 digitized arthropod records
<http://arctos.database.museum/uam_ento>
+++++++++++++++++++++++++++++++++++
Interested in Alaskan Entomology? Join the Alaska Entomological
Society and / or sign up for the email listserv "Alaska Entomological
Network" at
http://www.akentsoc.org/contact_us
|
|
The records without a whole organism - all of them - are in the attached zipped csv. The pasted-in list is some random records which do have whole organism parts, and the lot count in them is the sum of the lot counts of all whole organism parts. |
|
Ah, thanks.
Yes, proceed. Thanks!
-Derek
…On Fri, Feb 25, 2022 at 4:15 PM dustymc ***@***.***> wrote:
The records without a whole organism - all of them - are in the attached
zipped csv.
The pasted-in list is some random records which do have whole organism
parts, and the lot count in them is the sum of the lot counts of all whole
organism parts.
—
Reply to this email directly, view it on GitHub
<#4382 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/ACFNUMZJ4H2BS3EW64OXQA3U5ASSRANCNFSM5PLQMWWA>
.
Triage notifications on the go with GitHub Mobile for iOS
<https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675>
or Android
<https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.
You are receiving this because you authored the thread.Message ID:
***@***.***>
--
+++++++++++++++++++++++++++++++++++
*Derek S. Sikes*, Curator of Insects, Professor of Entomology
University of Alaska Museum (UAM), University of Alaska Fairbanks
1962 Yukon Drive, Fairbanks, AK 99775-6960
***@***.*** phone: 907-474-6278 he/him/his
University of Alaska Museum <https://www.uaf.edu/museum/collections/ento/>
- search 357,704 digitized arthropod records
<http://arctos.database.museum/uam_ento>
+++++++++++++++++++++++++++++++++++
Interested in Alaskan Entomology? Join the Alaska Entomological
Society and / or sign up for the email listserv "Alaska Entomological
Network" at
http://www.akentsoc.org/contact_us
|
|
running in the attribute loader - it'll take a few days |
|
OK, I see what's being done and need to know more.
The parts has a field called 'qty' on the display of a catalog record page.
If you click to edit a part this field is called '#' which is also what it
is called on the data entry form.
Now there is another field - an attribute that has a value 'individual
count'.
If we are creating new records, for example one for a vial with 5 spiders.
It seems we now have to enter 5 in the parts field "#" for whole organism
and also make an attribute for 5 for individual count? And if we make an
error and type 4 in one and 5 in the other, or edit one later and forget to
change the other, we have screwed up data?
Entering the same data in two fields with different names does not seem
like good database design. I now have to train my data entry people to
remember to enter the same count in two places (one of which involves a
variety of additional clicks and assignment of an agent and date - thus
turning what was a single field entry into a bunch of new actions) . I
envision problems with this added complexity. How rapidly will we
accumulate records that are missing attribute 'individual count' because of
human error? I know we've got tons of records missing attribute 'age class'
despite my efforts to train all my techs to enter 'adult' for all adult
insects.
…-Derek
On Fri, Feb 25, 2022 at 5:15 PM dustymc ***@***.***> wrote:
running in the attribute loader - it'll take a few days
—
Reply to this email directly, view it on GitHub
<#4382 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/ACFNUM2YA2LHCIQXCNPHR3DU5AZSRANCNFSM5PLQMWWA>
.
Triage notifications on the go with GitHub Mobile for iOS
<https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675>
or Android
<https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.
You are receiving this because you authored the thread.Message ID:
***@***.***>
--
+++++++++++++++++++++++++++++++++++
*Derek S. Sikes*, Curator of Insects, Professor of Entomology
University of Alaska Museum (UAM), University of Alaska Fairbanks
1962 Yukon Drive, Fairbanks, AK 99775-6960
***@***.*** phone: 907-474-6278 he/him/his
University of Alaska Museum <https://www.uaf.edu/museum/collections/ento/>
- search 357,704 digitized arthropod records
<http://arctos.database.museum/uam_ento>
+++++++++++++++++++++++++++++++++++
Interested in Alaskan Entomology? Join the Alaska Entomological
Society and / or sign up for the email listserv "Alaska Entomological
Network" at
http://www.akentsoc.org/contact_us
|
|
It's not the same data. One represents physical things, one is conceptual. How physical things map to conceptual is potentially complicated and varies by collection. I could come up with some sort of a report that finds records without the attribute and guesses at individuals, if that would be useful. |
|
Ok, to solve one problem (and other similar attributes being accidentally
forgotten problems) how about in the customization of data entry tools we
have the option to make some fields required? So they would fail data entry
checks if forgotten?
This won't solve the problem of someone accidentally typing different
values in the individual count attribute field from the whole organism part
field but it will at least make it impossible for one of my techs to forget
to fill in the attribute individual count value.
…-Derek
On Mon, Feb 28, 2022 at 8:33 AM dustymc ***@***.***> wrote:
It's not the same data. One represents physical things, one is conceptual.
How physical things map to conceptual is potentially complicated and varies
by collection.
I could come up with some sort of a report that finds records without the
attribute and guesses at individuals, if that would be useful.
—
Reply to this email directly, view it on GitHub
<#4382 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/ACFNUM5ZMMKSZKUWF4EWHCDU5OWWLANCNFSM5PLQMWWA>
.
Triage notifications on the go with GitHub Mobile for iOS
<https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675>
or Android
<https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.
You are receiving this because you authored the thread.Message ID:
***@***.***>
--
+++++++++++++++++++++++++++++++++++
*Derek S. Sikes*, Curator of Insects, Professor of Entomology
University of Alaska Museum (UAM), University of Alaska Fairbanks
1962 Yukon Drive, Fairbanks, AK 99775-6960
***@***.*** phone: 907-474-6278 he/him/his
University of Alaska Museum <https://www.uaf.edu/museum/collections/ento/>
- search 357,704 digitized arthropod records
<http://arctos.database.museum/uam_ento>
+++++++++++++++++++++++++++++++++++
Interested in Alaskan Entomology? Join the Alaska Entomological
Society and / or sign up for the email listserv "Alaska Entomological
Network" at
http://www.akentsoc.org/contact_us
|
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Issue Documentation is http://handbook.arctosdb.org/how_to/How-to-Use-Issues-in-Arctos.html
individualcount is a field that can be displayed on the list view of catalog records. It once held a count of the # of parts but is now empty. It seems its contents have been moved to a field called 'quantity' ??? But this field is not available for display on catalog list view.
I would like this fixed so I can once again see how many parts each record has in list view.
Priority
Please assign a priority-label. Unprioritized issues get sent into a black hole of despair.
high
The text was updated successfully, but these errors were encountered: