search

weecology / pydataweaver

The Pydata Weaver: A data Integration platform
Other
9 stars 5 forks source link

Combine NEON vegetation structure to soilDB data #50

Open MarconiS opened 4 years ago

MarconiS commented 4 years ago

WHAT: Link NEON vegetation structure (csv format) to soilDB (csv) WHY: Collect information about soil type, organic matter, texture, water content and other pedological information for individual NEON field plots with geolocation. WHERE: SoilDB (https://github.com/ncss-tech/soilDB), NEON vegetation structure (https://data.neonscience.org/data-products/DP1.10098.001)

MarconiS commented 4 years ago

soilDB is a way to interface with a geodatabase I don't know exactly how to access to directly (the GitHub repo is for an R package that uses an API to interface with the USDA database). Some of these data can be directly downloaded in vectorial and raster form at https://gdg.sc.egov.usda.gov/GDGHome_DirectDownLoad.aspx (gSSURGO)

MarconiS commented 4 years ago

let's find out a way to load .gdb in python (possibly avoiding geopandas) and load NEON data from API using python

MarconiS commented 3 years ago

ok, we made it adding soil database in Postgres. Next step is to provide a few GPS points (e.g. NEON vegetation for 1 site) to get linked to the soil data, and figure it out which soil tables are informative