Checking for non-preferred file/folder path names (may take a long time depending on the number of files/folders) ...
This resource contains some files/folders that have non-preferred characters in their name. Show non-conforming files/folders.
This resource contains content types with files that need to be updated to match with metadata changes. Show content type files that need updating.
| Authors: |
|
|
|---|---|---|
| Owners: |
|
This resource does not have an owner who is an active HydroShare user. Contact CUAHSI (help@cuahsi.org) for information on this resource. |
| Type: | Resource | |
| Storage: | The size of this resource is 358.6 MB | |
| Created: | Jan 28, 2022 at 11:25 p.m. (UTC) | |
| Last updated: | Jul 01, 2026 at 8:48 a.m. (UTC) | |
| Citation: | See how to cite this resource |
| Sharing Status: | Public |
|---|---|
| Views: | 3320 |
| Downloads: | 133 |
| +1 Votes: | Be the first one to this. |
| Comments: | No comments (yet) |
Abstract
This resource contains Jupyter Notebooks with examples that illustrate how to work with SQLite databases in Python including database creation and viewing and querying with SQL. The resource is part of set of materials for hydroinformatics and water data science instruction. Complete learning module materials are found in HydroLearn: Jones, A.S., Horsburgh, J.S., Bastidas Pacheco, C.J. (2022). Hydroinformatics and Water Data Science. HydroLearn. https://edx.hydrolearn.org/courses/course-v1:USU+CEE6110+2022/about..
This resources consists of 3 example notebooks and a SQLite database.
Notebooks:
1. Example 1: Querying databases using SQL in Python
2. Example 2: Python functions to query SQLite databases
3. Example 3: SQL join, aggregate, and subquery functions
Data files:
These examples use a SQLite database that uses the Observations Data Model structure and is pre-populated with Logan River temperature data.
Subject Keywords
Content
Related Resources
| Title | Owners | Sharing Status | My Permission |
|---|---|---|---|
| Hydroinformatics Instruction Modules Example Code | Amber Jones | Public & Shareable | Open Access |
Credits
Funding Agencies
This resource was created using funding from the following sources:
| Agency Name | Award Title | Award Number |
|---|---|---|
| National Science Foundation | Collaborative Research: Elements: Advancing Data Science and Analytics for Water (DSAW) | 1931297 |
How to Cite
This resource is shared under the Creative Commons Attribution CC BY.
http://creativecommons.org/licenses/by/4.0/
Comments
There are currently no comments
New Comment