项目作者: BONSAMURAIS

项目描述 :
Relational database schemas for BONSAI
高级语言: PLpgSQL
项目地址: git://github.com/BONSAMURAIS/schema.git
创建时间: 2020-02-25T14:30:26Z
项目社区:https://github.com/BONSAMURAIS/schema

开源协议:BSD 3-Clause "New" or "Revised" License

下载


Relational database schemas for BONSAI

A Postgres database schema for storing raw and processed BONSAI data.

schema graphic

See bonsai_raw_data_schema.sql and the issues for now.

Usage

Install Postgresql with the associated command line tools.

In a terminal, run the following:

  1. create_and_populate_database.sh

On Windows, you can also run a .bat file:

  1. create_and_populate_database.bat

Development

Python files (in the python directory of this repo) used to define the common metadata require the following dependencies:

  • pandas
  • psycopg2
  • pyarrow
  • pyshp
  • requests