search

EDIorg / ecocomDP

A dataset design pattern and R package for ecological community data.
https://ediorg.github.io/ecocomDP/
Other
32 stars 13 forks source link

Table sampling_location #6

Closed mobb closed 7 years ago

mobb commented 7 years ago

Table sampling_location sampling_location_id varchar not integer

mobb commented 7 years ago

needs a "z" Now I have tricked myself again the same way that the ODM has problems with water depth. The sampling_location_anillary can’t handle the third dimension – up or down at one site. Of course, I could stuff it all into the sampling_location_ancillary_id, but I am not sure that’s a good idea.

mobb commented 7 years ago

There is a column called "elevation". will this work? depths would be negative elevations. it has no unit, however. We presume that lat and lon are digital degrees. We could presume that elevation is in meters (negative is down), but that might be dangerous.

mobb commented 7 years ago

Note: for depth of a sample, use ... the event table, e.g., this row from examples dir: 4161,TBE01JUN05,sample_depth,5,meter