Skip to main content

SQL Database software for SnowEx data

Project description

Welcome to snowexsql

Documentation Status Testing Status Code Coverage Code Coverage

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!

Our community follows the Contributor Covenant

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

  • SnowEx Hackweek 2022 - HW22

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

snowexsql-0.5.0.tar.gz (4.4 MB view details)

Uploaded Source

Built Distribution

snowexsql-0.5.0-py3-none-any.whl (24.5 kB view details)

Uploaded Python 3

File details

Details for the file snowexsql-0.5.0.tar.gz.

File metadata

  • Download URL: snowexsql-0.5.0.tar.gz
  • Upload date:
  • Size: 4.4 MB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/5.1.1 CPython/3.9.19

File hashes

Hashes for snowexsql-0.5.0.tar.gz
Algorithm Hash digest
SHA256 f94948aab57ed1488049f5d947c3d1f7bc4b998c7ec083d2c4d62278971e5e0b
MD5 668befaaed7dda5da28f03fe11912e00
BLAKE2b-256 053967f1ff43bff15474ae9d344a422136d2d897cf966a8cd2b33deb91e020dd

See more details on using hashes here.

File details

Details for the file snowexsql-0.5.0-py3-none-any.whl.

File metadata

  • Download URL: snowexsql-0.5.0-py3-none-any.whl
  • Upload date:
  • Size: 24.5 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/5.1.1 CPython/3.9.19

File hashes

Hashes for snowexsql-0.5.0-py3-none-any.whl
Algorithm Hash digest
SHA256 0453401df81b0b096c06a29bc6d399a9160e1773be35e5146db8e97458e21ced
MD5 471030687c7a8cfdf89f9698ddaa1ed6
BLAKE2b-256 b97f3e3adc3643b79c1ca9e3df3241d3f2bd51d20a45d200dca16480f795ff99

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page