search

terraref / drone-pipeline

Generalizing the TERRA REF pipelines for processing data from UAV's
BSD 3-Clause "New" or "Revised" License
2 stars 2 forks source link

Document what data's needed to put plot boundaries into BetyDB, and the SQL calls to populate the DB #29

Closed Chris-Schnaufer closed 5 years ago

Chris-Schnaufer commented 5 years ago

More information is needed on how to put plot boundaries from a shapefile into BetyDB for the drone pipeline

kimberlyh66 commented 5 years ago

I think you will need to use shp2pgsql to get postgis geometry from shapefile (unless you know of another method).

kimberlyh66 commented 5 years ago

To describe the experiment associated with a site, you will need to provide the experiment name. Start date, end date, design, and description are optional. The experiment can be associated with treatments. Minimum required information to describe a treatment is the treatment name.

To describe the site, you will need to provide the site name and geometry. Other fields such as city, state, country, and time zone are optional.

Sites should be associated with a citation. You will need to provide the author, title, and year.

dlebauer commented 5 years ago

should be a readme w/ code that demonstrates how to do this on a test instance of the database

put instructions for running test instances of database into our wiki

not sure where the rest of the instructions should be documented? but in the same place as the meta-data upload tutorials, so in tutorials/metadata-upload for now is fine.

dlebauer commented 5 years ago

Could go in the BETYdb data entry documentation https://pecan.gitbook.io/betydbdoc-dataentry but need to check with Scott Rhode about the status of migration to bookdown. (ask on the pecan bety slack channel)

kimberlyh66 commented 5 years ago

@Chris-Schnaufer see pull request: terraref/tutorials#145

Chris-Schnaufer commented 5 years ago

Chris needs to create ticket to get work done and then do the work