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

support for data discovery #102

Closed
aekiss opened this issue Oct 5, 2018 · 3 comments
Closed

support for data discovery #102

aekiss opened this issue Oct 5, 2018 · 3 comments

Comments

@aekiss
Copy link
Collaborator

aekiss commented Oct 5, 2018

I think it would be helpful to enhance the database to better support data discovery, e.g. to allow implementation of a cc.discover(pattern) function that would take a pattern and do a GLOB and/or LIKE SQL query to return any (variable, experiment, ncfile, longname, units) tuples that match (which could then be used to call get_nc_variable). It might also be handy to have optional experiment and ncfile arguments to restrict the search.

It would be most useful if this would also search longnames so that a user can discover what variable names are used for particular physical quantities. I guess for compactness this would be best stored as a separate table that just contains all the unique variable names and their associated longname, which would need to be updated by build_index.

@angus-g angus-g added this to To do in Database improvements Oct 12, 2018
angus-g added a commit to angus-g/cosima-cookbook that referenced this issue Jun 7, 2019
This goes some of the way to solving COSIMA#102, by setting up a table of
longnames that can be queried.
angus-g added a commit to angus-g/cosima-cookbook that referenced this issue Jun 13, 2019
This goes some of the way to solving COSIMA#102, by setting up a table of
longnames that can be queried.
angus-g added a commit to angus-g/cosima-cookbook that referenced this issue Jun 18, 2019
This goes some of the way to solving COSIMA#102, by setting up a table of
common variables, along with attributes like `long_name`,
`standard_name` and `units`, which are all defined in the CF
Conventions.
@aidanheerdegen
Copy link
Collaborator

I have been playing around with ipywidgets for data discovery.

A simple prototype using tables to select experiments and variables is here:

https://nbviewer.jupyter.org/github/aidanheerdegen/cosima-recipes/blob/dataexplore/ContributedExamples/Data%20Explore.ipynb

but needs to be run live to see the table select boxes. When an experiment is selected it refreshes the table showing the available variables

Screen Shot 2020-06-30 at 9 48 14 am

@aidanheerdegen
Copy link
Collaborator

Is this adequately addressed with the explorer gui #200 ?

ping @aekiss

@aekiss
Copy link
Collaborator Author

aekiss commented Sep 1, 2020

Yes, magnificently! thanks @aidanheerdegen

@aekiss aekiss closed this as completed Sep 1, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
No open projects
Development

No branches or pull requests

2 participants