There is a newer version of this record available.

Software Open Access

PecanProject/bety: BETYdb 4.18

Scott Rohde; Carl Crott; David LeBauer; mulroony; Jeremy Kemball; Rob Kooper; Jimmy Chen; andrewshirk; Zhengqi Yang; Max Burnette; MarvinJ; phenolphtalein; Uday Saraf; The Gitter Badger; Michael Dietze; Chris Black

Implements API query of sites by geographical coordinates; fixes constraints and sequence numbering of sites_cultivars table Changes Pertinent to PEcAn Users

Administrators will need to do a database migration.

Summary of Changes New Features
  • Querying sites by geographical coordinates

    It is now possibly to query sites by geographical coordinates. For example, a URL of the form [hostname]/api/beta/sites?containing=40.064,-88.195 will return the site or sites containing the point at latitude 40.064 and longitude -88.195.

Bug fixes
  • Issue #521 (Two bugs in sites_cultivars)

    The migration SitesCultivarsUniqueness guarantees that site_id is unique in the sites_cultivars table. This means sites referenced by that table uniquely determine a cultivar.

Steps Needed for Upgrade Database Changes

Administrators will need to do a database migration.

The database version for this release is 20170712171513.

Gem Installation

No new Gems need be installed.

Status of RSpec Tests

All non-pending tests pass when run in the default environment. (There is one pending test having to do with site-group editing permissions.) The tests can be run using the command

bundle exec rspec

Complete details for running the RSpec tests are at

Files (12.6 MB)
Name Size
12.6 MB Download
All versions This version
Views 28014
Downloads 336
Data volume 444.6 MB75.7 MB
Unique views 20413
Unique downloads 184


Cite as