search

geological-survey-of-queensland / geological-properties-database

Sites, samples, observations & results database
Creative Commons Attribution 4.0 International
9 stars 2 forks source link

Other sample location information #6

Open ajtroup opened 4 years ago

ajtroup commented 4 years ago

For future sample cataloging, need to consider how to capture cabinet or slide box rather than core box, though 'box number' could be adaptable.

While not MVP, we need to consider how to integrate the storage locations for non-core/cuttings/sidewall core samples. This is a broad overview of how the location information is stored for some of the other samples:

Thin Sections Box Number (haslocation) Carrier Number Position number in box Palynology Slide box or filing drawer (haslocation) Position number Coal Blocks Cabinet (haslocation) Drawer Position number Thin section blocks Cabinet (e.g. map drawer) or Box (haslocation) Position Geochem/Field Sample (e.g. crushing and rock samples, including geochron) Pallet (haslocation) Drum Pulps Tray/box (haslocation)

geoderekh commented 1 year ago

This issue is tied to the current GSQ Sample collection dataset, which is a catalog of these various types of samples and includes data on the storage location types listed above. The implementation of a fix is dependent on typifying sample_location such that the existing pallet_no becomes a physical location pid with a prefix denoting the storage system being used. Until then, we can surely bodgy something up in sample details or associated documents. Perhaps a json structured to reflect the new typification can be added to the sample to facilitate future ETL