User Tools

Site Tools


sift:tutorials:openbiomechanics_project:refine_queries_with_metadata

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
sift:tutorials:openbiomechanics_project:refine_queries_with_metadata [2024/11/29 17:52] wikisysopsift:tutorials:openbiomechanics_project:refine_queries_with_metadata [2024/11/29 18:43] (current) sgranger
Line 46: Line 46:
   - CMZ files may take a while to build. Check the status bar in the bottom left hand corner of the interface for the build status.    - CMZ files may take a while to build. Check the status bar in the bottom left hand corner of the interface for the build status. 
   - After the files are built, check that the Library Path dialog is set correctly and hit "Load" in the **[[:sift:application:Load_Library_Dialog|Load Library]]** dialog.   - After the files are built, check that the Library Path dialog is set correctly and hit "Load" in the **[[:sift:application:Load_Library_Dialog|Load Library]]** dialog.
-    - On the [[:sift:application:load_page|Load Page]], you will see all of the workspaces for the pitching data have been created and loaded.+    - On the [[:sift:application:load_page|Load Page]], you will see all of the workspaces for the hitting data have been created and loaded.
 {{ :BuildCMZsDlg.png }} {{ :BuildCMZsDlg.png }}
 ==== Refining Hitting Data ==== ==== Refining Hitting Data ====
Line 56: Line 56:
 Let's say we want to query this data set, but we **only** want data from subjects that are under age 20. Let's say we want to query this data set, but we **only** want data from subjects that are under age 20.
  
-We start by loading library with the hitting data set, navigating to the Query Builder dialog, and opening the Auto-Populate dialog. Ensure that "Baseball" is checked. Find the "Refine using signal" checkbox and click "Add". Then you can enter your query refinements.+We start by loading library with the hitting data set, navigating to the [[sift:application:Query_builder_dialog|Query Builder dialog]], and opening the [[sift:application:query_builder_dialog#auto_populate_queries|Auto-Populate dialog]]
  
-{{:AutoPopulate.png}}+Under "Combine Sides", select Baseball from the drop down. Here you will see the info box auto-populated by the meta data in the CMZ files.  
 + 
 +Additional refinements, under the "Refinements" tab, find the "Refine using signal" checkbox and click "Add Signal". Then you can enter your query refinements for athletes under age 20: 
 + 
 +{{sift:tutorials:openbiomechanics_project:refinehittingdlg.png}} {{:sift:tutorials:openbiomechanics_project:refineunder20.png}}
  
 When refining queries it can be helpful to have the metadata file open, so that you can see the values it contains. Note that in this case, accessing athlete_age has been set as a global metric, and you will not be able to find the meta folder unless Global Value is checked. When refining queries it can be helpful to have the metadata file open, so that you can see the values it contains. Note that in this case, accessing athlete_age has been set as a global metric, and you will not be able to find the meta folder unless Global Value is checked.
  
 The result of this procedure is that data is queried only if it meets this refinement category, and the refinement name will be applied as a suffix to the end of the signal name. The result of this procedure is that data is queried only if it meets this refinement category, and the refinement name will be applied as a suffix to the end of the signal name.
 +
 +When you hit "Create" on the Auto-Populate Dialog, you will see the queries appear for athletes under 20, and with L and R batting sides combined for each query.
 +{{ :sift:tutorials:openbiomechanics_project:autopophitting.png }}
  
 ===== Build Your Own Metadata File ===== ===== Build Your Own Metadata File =====
Line 72: Line 79:
 In the example below, we can see that there are four headers (static_model, dynamic_file, walking_speed and subject_mass). In the example below, we can see that there are four headers (static_model, dynamic_file, walking_speed and subject_mass).
  
-{{:_buildYourOwnMeta.png}}+{{:RefineQueriesWithMeta_-_buildYourOwnMeta.png}}
  
 Here you can edit the description fields and subject specific fields. After you are satisfied with the fields, click "Apply" to build CMZs and load the library. Here you can edit the description fields and subject specific fields. After you are satisfied with the fields, click "Apply" to build CMZs and load the library.
Line 84: Line 91:
 If you navigate from the Query Builder dialog to the Auto-Populate menu, In the **Signals** tab Select **Metric** as the signal type and **meta** as the signal folder. Now switch over to the **Refinements** tab, click {{:sift_action_add.png}} **Add Signal**, create three refinements as seen in the picture below, and then hit {{:sift_apply.png}} **Create**. If you navigate from the Query Builder dialog to the Auto-Populate menu, In the **Signals** tab Select **Metric** as the signal type and **meta** as the signal folder. Now switch over to the **Refinements** tab, click {{:sift_action_add.png}} **Add Signal**, create three refinements as seen in the picture below, and then hit {{:sift_apply.png}} **Create**.
  
-{{:AutoSignals.png}}+{{:RefineQueriesUsingMeta-AutoSignals.png}}
  
  
-{{:AutoRefinements.png}}+{{:RefineQueriesUsingMeta-AutoRefinements.png}}
  
  
Line 96: Line 103:
 Since I want to refine my data by walking speed in this example, I name the refinement "2.0", choose the data under METRIC>meta>walking_speed>X and indicate that the value must be "Equal to" 2.0. I can then save my refinements as an .xml file which can be loaded at any time if I want to re-query my library. Since I want to refine my data by walking speed in this example, I name the refinement "2.0", choose the data under METRIC>meta>walking_speed>X and indicate that the value must be "Equal to" 2.0. I can then save my refinements as an .xml file which can be loaded at any time if I want to re-query my library.
  
-{{:QueryBuilderDlg.png}}+{{:RefineQueriesWithMeta-QueryBuilderDlg.png}}
  
 ==== Visualizing Refined Queries ==== ==== Visualizing Refined Queries ====
Line 104: Line 111:
 Insure that **Plot Type** is set to Metric Plot, then check the boxes for **Select All Groups** and **Select All Workspaces**. Insure that **Plot Type** is set to Metric Plot, then check the boxes for **Select All Groups** and **Select All Workspaces**.
  
-{{:Plot.png}}+{{:RefineQueriesWithMeta-Plot.png}}
  
  
  
sift/tutorials/openbiomechanics_project/refine_queries_with_metadata.1732902742.txt.gz · Last modified: 2024/11/29 17:52 by wikisysop