Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

New CSV report for RANGES work #8383

Open
mkoo opened this issue Dec 18, 2024 · 3 comments
Open

New CSV report for RANGES work #8383

mkoo opened this issue Dec 18, 2024 · 3 comments
Labels
contact auto-added from contact template Enhancement I think this would make Arctos even awesomer!
Milestone

Comments

@mkoo
Copy link
Member

mkoo commented Dec 18, 2024

          Tentative list of fields to include in CSV:

-GUID
-catalog number
-simple identifiers
-part names
-county - asserted
-state - asserted
-specific locality
-verbatim date
-age (from flat)
-total length (from flat)
-tail length (from flat)
-hind foot with claw (from flat)
-ear (from notch) (from flat)
-weight (from flat)
-reproductive data (from flat)

rest are not in flat so hopefully Dusty can retrieve from JSON blob of attributes and include as part of the CSV
-ear (from crown)--
-crown-rump length
-unformatted measurements (this is text)
-life stage (yes this is a controlled vocab)

Originally posted by @mkoo in #8382 (comment)
(sorry this needs a new issue)

@mkoo
Copy link
Member Author

mkoo commented Dec 18, 2024

More notes:
metadata for attributes to CSV -- > , <attribute-type+ attribute_units>, <attribute-value+ attribute_date>, <attribute-value+ attribute_determiner>, etc

Example for attribute-type= length: cols are:
-length (which has the attribute_value), length_units, length_date, length_determiner etc

The attribute metadata will be in the CSV but as columns so user can delete or hide as desired

Typical duplicate attribute_type handling will be to duplicate row with the record. (right?)

@mkoo mkoo added contact auto-added from contact template Enhancement I think this would make Arctos even awesomer! labels Dec 18, 2024
@dustymc dustymc added this to the Reporter milestone Dec 19, 2024
@dustymc
Copy link
Contributor

dustymc commented Dec 31, 2024

This is done as mvz_ranges_csv.

I'm not at all sure that I've correctly understood the needs so I just added the record attribute summaries from flat, and the rest using the same function I use to cache them in FLAT. That should at least be enough to support a conversation, let me know when/if something needs adjusted.

We can also discuss the record limit if necessary, let me know details if pulling more than 20K records at a time becomes a bottleneck.

@Jegelewicz
Copy link
Member

@jebrad will probably want to use this report eventually.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
contact auto-added from contact template Enhancement I think this would make Arctos even awesomer!
Projects
None yet
Development

No branches or pull requests

3 participants