SQL Database software for SnowEx data
Project description
Welcome to snowexsql
About
Database access and tools for using the SnowEx database. This tool is simply a client for accessing the database using python
WARNING - This is under active development in preparation for SnowEx Hackweek. Use at your own risk. Data will change as it is QA/QC’d and the end goal is for all data in this database to be pulled from NSIDC. The goal is for this to become a community database open to all.
Features
Database access for SnowEx Database
Analysis tools
Useful conversions to pandas and geopandas
Lots of examples
Installing
If you are just planning on using the database, then only install the python package instructions below.
I just want to use it
Install using pip:
pip install snowexsql
I want data fast
A programmatic API has been created for fast and standard access to Point and Layer data. There are two examples covering the features and usage of the api. See the specific api documentation for detailed description.
from snowexsql.api import PointMeasurements, LayerMeasurements
# The main functions we will use are `from_area` and `from_filter` like this
df = PointMeasurements.from_filter(
date=date(2020, 5, 28), instrument='camera'
)
print(df.head())
I need help
Jump over to our discussion forum and get help from our community.
I want to contribute
Thank you for the interest!
Have a look at our contribution guide and see the many ways to get involved!
Documentation
There is a whole host of resources for users in the documentation. It has been setup for you to preview in your browser.
In there you will find:
Examples of database use
Database structure
API to the python package snowexsql
Links to other resources
Notes about the data uploaded
And more!
To see the documentation in your browser:
Warning: To see the examples/gallery, the snowex db needs to be up. Otherwise they will be left with the last image submitted to GitHub.
make docs
DOI
History
0.1.0 (2020-06-12)
Project Created.
Hack Week 2021 (2021-07-15)
Fully deployed database with around 100 users
Uploaded with fully reproducible DB using Snowex Data for Grand Mesa 2020
Timezones all in Mountain Standard
0.2.0 Repo Split (2022-06-20)
Repo was split into an access client and a db builder to reduce overhead
snowexsql is now an access client and python tools to make life easy
snowex_db is now a repo containing all necessary assets to build db.
0.3.0 (2022-07-6)
New columns were added to the LayerData table for flags
Converted surveyors to observers
Changed utm zone to be an integer
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for snowexsql-0.5.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0453401df81b0b096c06a29bc6d399a9160e1773be35e5146db8e97458e21ced |
|
MD5 | 471030687c7a8cfdf89f9698ddaa1ed6 |
|
BLAKE2b-256 | b97f3e3adc3643b79c1ca9e3df3241d3f2bd51d20a45d200dca16480f795ff99 |