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
applications:connect [2022/05/25 06:06] – gregbalcoapplications:connect [2023/01/17 20:53] (current) – joetulenko
Line 1: Line 1:
 === GETTING SET UP WITH ICE-D === === GETTING SET UP WITH ICE-D ===
-Please find descriptions and links to tutorials here for connecting with ICE-D from your personal desktop on various applications. Whether you use Mac or prefer the Windows darkside like myself (J. Tulenko speaking here), we've got you covered.+Please find descriptions and links to tutorials here for connecting with ICE-D from your personal desktop on various applications. Whether you use Mac or prefer Windows, we've got you covered.
  
 ---- ----
Line 10: Line 10:
 ICE-D is hosted in a MySQL server, and there are free desktop applications that one can download from the internet and set up to connect with the actual database itself. This section may eventually get archived, but for now, set up directions are linked below. ICE-D is hosted in a MySQL server, and there are free desktop applications that one can download from the internet and set up to connect with the actual database itself. This section may eventually get archived, but for now, set up directions are linked below.
  
-Please find the tutorial for **Windows** computers using the MySQL application **HeidiSQL** {{ :applications:heidisql_set_up.pdf |here}}. +Please find the tutorial for **Windows** computers using the MySQL application **HeidiSQL** **[[applications:connect:windowssql | on this page]]** 
  
 {{:applications:heidisql_logo.jpg?nolink&200|}} {{:applications:heidisql_logo.jpg?nolink&200|}}
  
-Please find the tutorial for **Mac** computers using the MySQL application **Sequel Pro** {{ :applications:sequel_pro_set_up.pdf |here}}.+Please find the tutorial for **Mac** computers using the MySQL application **TablePlus** **[[applications:connect:macsql | on this page]]**
  
-{{:applications:sequelpro_logo.jpg?nolink&200|}}+ 
 +{{:applications:tableplus_logo.jpg?nolink&200|}}
  
  
Line 26: Line 28:
 Please find the tutorial to connect with ICE-D through Matlab {{ :applications:connect_through_matlab_windows_.pdf |for Windows here}}. Please find the tutorial to connect with ICE-D through Matlab {{ :applications:connect_through_matlab_windows_.pdf |for Windows here}}.
  
-Please find the tutorial to connect with ICE-D through Matlab for Mac{{ :applications:connect_MATLAB_mac | here}}+Please find the tutorial to connect with ICE-D through Matlab for Mac[[:applications:connect_MATLAB_mac | here.]]
  
 {{:applications:matlab_logo.png?nolink&200|}} {{:applications:matlab_logo.png?nolink&200|}}
Line 33: Line 35:
  
 **3) Connecting to the database using Geospatial software (ArcGIS/QGIS)** **3) Connecting to the database using Geospatial software (ArcGIS/QGIS)**
-At the moment, we are still working on how to figure this out, but we believe the best way to do this might be to set up a Web Feature Service (WFS) directly on the ICE-D webpage. The WFS would create one large file (probably something in a shapefile format or a geojson format) that can be essentially copied over into your GIS application. The link would be live, and continuously updated as the database updates so you would once again circumvent the need to download and store static copies of whatever subset you want to extract from the database. 
  
-For now, please see this example of what a WFS looks like on a webpage and how to open the {{ :applications:connect_through_wfs_in_qgis.pdf |WFS in QGIS here}}. +We have successfully set up a Web Feature Service for ICE-D Data! Briefly, this means that whenever there are updates to the data in ICE-D (e.g., users add new data to ICE-D), the WFS also gets updated and so as long as you have an internet connection, you will be viewing the latest and most up-to-date account of samples in ICE-D in your own personal desktop application! 
 + 
 +Find more details and how to connect using the WFS, **[[pluginto:wfs|visit this page]]** 
 + 
 +\\  
 +\\ 
  
-I am currently showing examples using QGIS but I know you can do it in ArcGIS as well. QGIS is a FREE alternative to ArcGIS that has a lot of the same functionality.+In the instructions page linked above, I am only showing examples using QGIS (free alternative with much of the same functionality) but WFS's are also functional in ArcGIS is you have a license for ArcGIS.
  
 {{:applications:qgis_logo.png?nolink&200|}} {{:applications:qgis_logo.png?nolink&200|}}