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:laurentide1 [2023/01/24 19:52] – joetulenkoworkshops:laurentide1 [2023/02/28 17:42] (current) – joetulenko
Line 29: Line 29:
 -- How to put data into the database (hands-on) -- How to put data into the database (hands-on)
  
--- Spend some time digging LIS data out of the literature and building the database+-- Spend some time digging LIS/other data out of the literature and expanding the database
  
 -- How to get data out of the database using MATLAB, Python, GIS, etc. -- How to get data out of the database using MATLAB, Python, GIS, etc.
Line 50: Line 50:
 **Day 1:** Introduction, database connections, and data entry **Day 1:** Introduction, database connections, and data entry
  
--- **9:00am - 10:00am:** Intro the ICE-D project, ice breakers, etc. +-- **9:00am - 10:00am:** Intro to the ICE-D project, ice breakers, basic concepts of database setup, etc. 
  
 -- **10: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) -- **10: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)
Line 56: Line 56:
 -- **12:00pm - 1:00pm** break for lunch -- **12:00pm - 1:00pm** break for lunch
  
--- **1:00pm - 5:00pm** Spend the remainder of the day mining the literature and doing data entry if everyone is connected and able to add data+-- **1:00pm - 5:00pm** Spend the remainder of the day mining the literature and doing data entry
    
 \\ \\
Line 92: Line 92:
 \\ \\
  
-**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. 5ish minutes+**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 2** Determine what personal machine (most likely a laptop) you plan on using for a while to interact with ICE-D (we can accommodate Macs or PCs no problem, and have had good success with Linux users as well). We get users to connect to the database with a connection that is unique to each individual machine so it is best to try to pick one and stick with it if you can.+**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 3** Read through our tutorials ahead of time! Inevitably there will be challenges with getting everyone connected to the database but as previously stated things are somewhat streamlined at this point and the tutorials are helpful+**Step 3** Read through our tutorials ahead of time! Inevitably there will be challenges with getting everyone connected to the database but as previously stated things are somewhat streamlined at this point and the tutorials are helpful.
  
 **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.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 ]]**
Line 114: Line 114:
 \\ \\
  
-**//Step 5: Bring some form of government issued ID such as a drivers license (please read the following section about entering the USGS office. There are a few things we will be required to do as guests in the building so be prepared).//**+**//Step 5: Bring some form of government issued ID such as a drivers license for US citizens and passports for international folks (please read the following section about entering the USGS office). There are a few things we will be required to do as guests in the building so be prepared).//**
  
 \\ \\
Line 126: Line 126:
 -- Our contact at the USGS, Will Odom has reserved a space in the USGS building. There are a few things to prepare for, and Will has kindly written out instructions for us: -- Our contact at the USGS, Will Odom has reserved a space in the USGS building. There are a few things to prepare for, and Will has kindly written out instructions for us:
  
-1) The room number is **3B457**.  The building can be confusing to navigate ({{ :workshops:usgs_building_report.pdf |see p. 21 here for a map of the third floor}}), so we may benefit from putting up some signage when the time comes. That said, guests will need to check in through the visitor center (see oblique view USGS building image at the bottom). **They will need to bring driver's licenses (or other IDs) and pass through a metal detector, in addition to having their belongings X-rayed.**+1) The room number is **3B457**.  The building can be confusing to navigate ({{ :workshops:usgs_building_report.pdf |see p. 21 here for a map of the third floor}}), so we may benefit from putting up some signage when the time comes. That said, guests will need to check in through the visitor center (see oblique view USGS building image at the bottom). **They will need to bring driver's licenses (or other IDs) for US citizens - passports for international folks - and pass through a metal detector, in addition to having their belongings X-rayed.**
  
 2) Upon going through security, they will take the elevator at the end of the security checkpoint to the third floor. They'll then take a left out of the elevator, which will lead them to a long hall to their left. They will walk nearly all the way down that hall, until they reach 3B457 on the right. 2) Upon going through security, they will take the elevator at the end of the security checkpoint to the third floor. They'll then take a left out of the elevator, which will lead them to a long hall to their left. They will walk nearly all the way down that hall, until they reach 3B457 on the right.
Line 138: Line 138:
 ==Lodging== ==Lodging==
  
--- Greg and Joe plan on reserving rooms at the Hyatt Regency Reston 1800 Presidents St, Reston, VA 20190 **([[https://www.hyatt.com/en-US/hotel/virginia/hyatt-regency-reston/resto?src=adm_sem_crp_chico_crp_ppc_NAM-UnitedStates-VA-Reston-HR-RESTO_google_Evergreen2022_e_hyatt%20regency%20reston&gclid=CjwKCAiAzp6eBhByEiwA_gGq5ESX5XviPA-cAswJpQCsKo4bHcog0VCTL6V6OFeLUXadEh9jkdtWGhoCizcQAvD_BwE|Booking page]])**. +-- The official hotel for the immediately following GSA section meeting is the Hyatt in Reston Town Center. However, it appears that the conference rate is not valid during the workshop, so it is quite expensive. 
  
---This is the hotel that is planned for use for the GSA Sectional Meeting following the workshop, and is close to the downtown center of Reston where there are options for food, shopping, etc. We would recommend this hotel to attendees but please feel free to book whatever lodging spaces you prefer.+-- Greg and Joe have reserved rooms at the Sheraton Reston Hotel - 11810 Sunrise Valley Dr, Reston, VA 20191 **([[https://www.marriott.com/en-us/hotels/wassr-sheraton-reston-hotel/overview/?scid=f2ae0541-1279-4f24-b197-a979c79310b0|Booking page]])**. 
  
---A major highway isolates the USGS Offices so we will either need to walk the ~1.8 mi walk to the offices or call Ubers or perhaps we will rent a passenger van. //See google earth image at the bottom of this page for the general layout.//+--This hotel is slightly outside the downtown center where most Reston restaurants are located, but is approximately equidistant from the USGS office and downtown, about a mile apart from each. We will likely be walking to and from the hotel for the workshop/dinners/etc. //See google earth image at the bottom of this page for the general layout.// 
 + 
 +-- Workshop attendees who will be getting reimbursed and/or those who will not have access to a car, we recommend the Sheraton Reston Hotel since 1) the hotel is in a convenient location, and 2) we can only reimburse attendees up to ~$1000 per person. Although please feel free to make whatever reservations work best for you. Let Joe know if you have any issues with bookings.
  
 \\ \\
Line 173: Line 175:
  
 Please email Joe Tulenko (jtulenko@bgc.org) if you have any questions. Please email Joe Tulenko (jtulenko@bgc.org) if you have any questions.
 +
 +**Please find the travel reimbursement form here: {{ :workshops:travelform.xls |}}**
  
 \\ \\
Line 179: Line 183:
  
 ===Applications=== ===Applications===
 +
 +**NOTE: applications for this workshop are closed as of Feb 15th.** 
  
 Some workshop participants have been invited by the organizers. We are also soliciting applications for additional participants. Applicants should have the following properties: Some workshop participants have been invited by the organizers. We are also soliciting applications for additional participants. Applicants should have the following properties:
Line 204: Line 210:
 \\ \\
  
-A map of Reston, VA with the Hyatt Hotel, downtown, and the USGS highlighted.+A map of Reston, VA with the Hyatt Hotel, downtown, and the USGS highlighted. The Sheraton is also visible. 
  
 {{ :workshops:working_map-01.png?nolink |}} {{ :workshops:working_map-01.png?nolink |}}