meta data for this page
  •  

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
workshops:cosmocerege [2026/06/08 16:28] – joetulenkoworkshops:cosmocerege [2026/06/08 17:24] (current) – gregbalco
Line 1: Line 1:
-====ICE-D workshop: COSMO26 @ CEREGE - Aix-en-provence June 15, 2026====+====ICE-D workshop: COSMO2026 @ CEREGE - Aix-en-provence June 15, 2026====
  
  
 ===Objective=== ===Objective===
  
-We aim to expand the community of people who can contribute to and work with the ICE-D database and infrastructure by inviting any individuals attending COSMO26 to this pre-conference ICE-D workshop.  We will be giving an overview of the ICE-D Project, giving folks credentials to interact directly with the database, and providing an example walk-thru for entering datasets into the database.+We aim to expand the community of people who can contribute to and work with the ICE-D database and infrastructure by inviting any individuals attending COSMO2026 to this pre-conference ICE-D workshop.  We will be giving an overview of the ICE-D Project, an introduction to how the data are organized, and describing methods to access and work with the data. In addition, this is an opportunity to ask questions of the developers. The goal will be for attendees to know enough about the project to (i) organize their own data in a way that is compatible with incorporation into the database, and (ii) understand enough about how to access the data to get some ideas about how ICE-D data could be used in their research. 
  
 For more information about the ICE-D project, please visit the **[[https://wiki.ice-d.org/start | Top level page of this wiki]]** For more information about the ICE-D project, please visit the **[[https://wiki.ice-d.org/start | Top level page of this wiki]]**
Line 13: Line 13:
 **Ideally, attendees will come away from the workshop with the following:** **Ideally, attendees will come away from the workshop with the following:**
  
-**1)** Enough knowledge of how the ICE-D database and associated software works to interact with it, add data to it and quality-control existing data, and contribute to maintaining and improving it. +**1)** Enough knowledge of how the ICE-D database and associated software works to understand how to organize newly collected data for later inclusion in the database. 
  
 **2)** Some ideas about what visualizations, applications and analyses are possible with this tool and what software/skills you need to make them happen. **2)** Some ideas about what visualizations, applications and analyses are possible with this tool and what software/skills you need to make them happen.
Line 25: Line 25:
 -- How the infrastructure is set up -- How the infrastructure is set up
  
--- How the database is organized+-- A brief introduction to how relational databases are set up
  
--- How to put data into the database (hands-on)+-- How to view the raw data tables and understand the general organizational concept
  
--- Spend some time digging data out of the literature/contributing your own data to expand the database+-- A brief introduction to how to get data out of the database using desktop software
  
--- How to get data out of the database using MATLAB, Python, GIS, etc. 
- 
-\\ 
- 
- 
- 
-===Workshop logistics/travel/lodging === 
- 
-\\ 
  
 ==Workshop Location== ==Workshop Location==
  
-[[https://nuage.osupytheas.fr/s/NkDBBycc6ird3YZ?openfile=true|Link to the COSMO26 schedule here]]+The workshop location and details are on the COSMO2026 website:
  
-==GREG TO FILL THIS INFO IN?==+[[https://nuage.osupytheas.fr/s/NkDBBycc6ird3YZ?openfile=true|Link to the COSMO2026 schedule here]]
  
-\\ 
-\\ 
- 
-==Travel and lodging== 
- 
-==NOT APPLICABLE?== 
  
 \\ \\
  
 ===Pre-workshop preparations/tasks=== ===Pre-workshop preparations/tasks===
- 
-Much of our process for viewing and adding data to ICE-D has become quite streamlined, but you can help expedite the process even more by taking the following steps prior to the meeting: 
  
 \\ \\
  
-**Step 1:** Come prepared with a brief bio about yourself; what are your interests, current projects you are working on, and what you are hoping to get out of the workshop (5-ish minutes). +**Step 1:** We will use a few minutes at the beginning of the workshop for introductions. Come prepared with a brief bio about yourself; what are your interests, current projects you are working on, and what you are hoping to learn at the workshop. 
  
 \\ \\
  
-**Step 2:** Determine what personal machine (most likely a laptop) you plan on using for a while to interact with ICE-D (the setup is basically platform-independent and we are using/have used Mac, Windows, and Linux machines). Part of the connection scheme is unique to each individual machine, so it is best to try to pick one and stick with it if you can.+**Step 2:** We expect that most of the workshop attendees will bring their own laptops to the workshop and want to connect to the database. To do this, it is necessary to install some software and set up some security credentials. Specifically, you will need to install a MySQL client and send us a SSH key. **For best time management, it is extremely helpful if everyone connecting to the database follows the instructions linked below and sends us an SSH key for their personal laptop ahead of the workshop.** It is possible to do this at the workshop, but it will waste valuable time in what is already a very short schedule. 
  
-\\+Find the tutorials for connecting to the database through SQL Clients here: **[[applications:connect:windowssql | Windows Users ]]**   |   **[[applications:connect:macsql | Mac and Linux Users ]]**
  
-**Step 3:** Read through our tutorials for connecting to the database. **For best time management, it is super helpful if everyone connecting to the database follows the instructions linked in 3.1 and sends us an SSH key for their personal laptop ahead of the workshop.**  +If you are interested in the GIS interface to ICE-D data, please have some sort of GIS software (typically Arc or QGIS) operating on your computer. 
- +
-**3.1:** Find the tutorials for connecting to the database through SQL Clients here: **[[applications:connect:windowssql | Windows Users ]]**   |   **[[applications:connect:macsql | Mac and Linux Users ]]** +
- +
-**3.2:** Find the tutorial for getting set up and adding data through the admin panel on the ICE-D webpage here: **[[applications:add | Data entry page ]]** +
- +
-**3.3:** The page general page for connecting to ICE-D, adding data to ICE-D and examples of applications and visualizations also has lots of other info available that attendees are encouraged to check out: **[[applications:diy | ICE-D tutorials, visualization and analysis applications page ]]** +
- +
-\\ +
- +
-**Step 4:** if you can, and have time for it, come to the workshop with either your own data for data entry or data from a paper or two that you know of that have not yet been entered into ICE-D. Furthermore, try to brainstorm ahead of the workshop what sorts of visualizations, applications, and/or analyses you might like to explore using ICE-D. +
- +
-\\ +
-\\ +
- +
- +
-==Tentative schedule of events== +
- +
-==BELOW IS COPIED FROM OTHER WORKSHOP PROGRAM, DELETE OR ADJUST?== +
- +
-The workshop is scheduled for 2 (ish) days, and each day is laid out roughly as follows: +
- +
-**Day 1 Thur 7th:** Introduction, database connections/structure, and data entry +
- +
--- **10:00am - 11:00am:** Intro to the ICE-D project, ice breakers, basic concepts of database setup, etc.  +
- +
--- **11:00am - 12:00pm:** Check in with everyone to make sure they know how to 1) connect to the database, and 2) add data to the database through our admin page on the website (see tutorial links below for instructions) +
- +
--- **12:00pm - 1:00pm** break for lunch +
- +
--- **1:00pm - 4:00pm** Finish getting folks set up to see the database and add data, data entry. Data analysis examples if time +
-  +
-\\ +
- +
-**Day 2 Fri 8th:** Data visualizations, applications and analyses using ICE-D +
- +
--- **10:00am - 11:00am:** review of previous day's topics/intro today's topics, questions, discussion, etc. (if necessary) +
- +
--- **11:00am - 12:00pm:** Setting up connections to ICE-D through other software, mainly Python (can do matlab too if wanted) and desktop GIS applications like QGIS +
- +
--- **12:00pm - 1:00pm:** break for lunch +
- +
--- **1:00pm - 4:00pm:** examples/discussion of potential visualizations/applications/analyses using ICE-D and free work time +
- +
-\\+
  
 +**Step 3:** If you have some data that is either your newly generated data, or some literature data that is not yet in the ICE-D database, bring it with you. We may have time for an exercise in organizing data for inclusion in the database. 
  
 ---- ----