Locations
A location is defined in Breedbase using a unique name and abbreviation. It can have one of the following types: Farm, Field, Greenhouse, Screenhouse, Lab, Storage, or Other. The location is saved with longitude and latitude coordinates, an altitude in meters, and is associated to a country and breeding program.
Locations are linked to many of the following concepts: field trials, genotyping plates, genotyping data experiments, crossing experiments, and seedlots.
A location is created as an entry of the nd_geolocation table with associated properties in the nd_geolocationprop table, following an entity-attribute-value (EAV) model. Property entries include the country and location type, and optionally, the address, continent, and administrative regions; they are stored in nd_geolocationprop using terms from the ‘geolocation_property’ controlled vocabulary. Controlled vocabulary is a fundamental part of the Chado database schema and to the Natural Diversity module on which Breedbase is built on. Only a submitter or curator on the system can create new locations in the database.
An interactive map can be used to add, edit, delete, and view locations. Apart from the interactive map, an Excel file can be uploaded to add locations in bulk.
