Get started by visiting the [ODM Tools Documentation] (https://github.com/ODM2/ODMToolsPython/wiki/ODMTools-Python-Documentation) page.

ODMTools is a python application for managing observational data using the Observations Data Model. ODMTools allows you to query, visualize, and edit data stored in an Observations Data Model (ODM) database. ODMTools was originally developed as part of the CUAHSI Hydrologic Information System.

If you want to try ODM Tools, we have created a couple of testing databases that you can use.

ODM Tools Python is currenlty fully compatible with ODM Version 1.1.1. We are working on ODM2 compatibility, and should have it worked out this winter.

To make running ODMTools easier we have included installers. Please select the one that is appropriate for your operating system

Recommended Release:

• Window v1.2.8-beta

• Mac v1.2.8-beta

• Please run from source

• Matplotlib
• Pandas
• Pip
• PyMySQL
• Pyodbc
• Python-2.7.9 x64/x32 (Python 3 version isn't available)
• Psycopg2
• [Sqlalchemy] (http://pypi.python.org/pypi/SQLAlchemy/)
• wxpython
• Numpy
• Scipy

Install the following software/libraries. It is recommended to create an environment using 'Conda'. 'Conda' comes prepackaged in the Python Scientific Package Suite Anaconda (Available for Windows, OSX, Linux)

Example environment creation:

• conda create -n odmtools python=2.7.8 wxpython matplotlib pandas numpy scipy pyodbc sqlalchemy pip psycopg2

• pip install pymysql

if psycopg2 isn't found, download it manually and follow these directions

Once you have downloaded the source code and all the dependencies installed, run the main application:

python ODMTools.py

if installing pyodbc onto a Mac machine please follow these instructions:

pyodbc Configuration Download the source code ​here​. Unzip the directory where ever you want. Edit ​setup.py​ within the pyodbc directory. Look for the line that says “OS/X now ships with iODBC.” Right underneath that, remove the letter i from the statement:

settings[‘libraries’].append(‘iodbc’)

so that it reads:

settings[‘libraries’].append(‘odbc’)

Now that the setup.py file is configured correctly, pyodbc is ready to be installed. From your virtual environment, do a pip install of pyodbc and use the modified package.

pip install -e PATH_TO_PYODBC

This project is receiving or has received support from a number of agencies and complementary efforts including:

This material is based on work supported by the National Science Foundation Grants IIA-1208732, ACI-1339834, and EAR-1224638. Additional support was previously provided by National Science Foundation grant EAR-0622374. Any opinions, findings, and conclusions or recommendations expressed are those of the author(s) and do not necessarily reflect the views of the National Science Foundation.