Data are transferred into and out of the ACE and ACMO databases through the API using JSON objects, which consist of key:value pairs. Each key in a key:value pair corresponds to a variable in the ICASA Data Dictionary .
The JSON objects can be very unstructured and are ideally suited to our experimental data, which can vary considerably from one experiment to another. However, some structure in the objects is enforced as described in this section.The JSON object has the following sections:
- Top-level data (metadata, site description, location data)
None of the data are considered to be required. Each crop model may have model-specific minimum required data, and the data stored in the database are not guaranteed to run on every model. In many cases, the data translators must make assumptions about how to deal with incomplete data.
For sample JSON files, please visit: https://github.com/agmip/json-translation-samples
Compression of data (ACE Binary format)
The ACE Binary (*.aceb) format has been implemented to store the serialized JSON object.
- The ACE Binary format is used for the internet data transmission between ACE database and UI applications.
- It is a GZIP representation of the original JSON object with a descriptive file header.
- This compression reduces the size of the object by as much as 80%.
- The file header allows for versioning, which means the file will work correctly even we make changes to the internal structure in the future.
- QuadUI v1.2.1 and later will use this format.
Dates are always sent in the following format: YYYYMMDD
This is interpreted as May 17, 1978.
Sample top level data (metadata, site description, location data)
These data describe the experiment, researchers involved, field location and name, and general site-specific information. Only data which are supplied to the database are included in the JSON object.
Sample initial conditions data
Initial soil conditions are set for the soil profile (above the data array) and for the soil layers (within the data array). Data include the previous crop (soybean), date for initial conditions (1978-06-15), root residue (100 kg/ha), and surface residues (1000 kg/ha). Soil layer data include depth to bottom of layer, initial soil water content, initial ammonium and nitrate in ppm.
Sample weather data
In this sample weather data object, the entire weather station data is one structure, with a nested data structure for the daily weather records.
Sample soil data object
In this sample soil data object, the entire soil profile data is one structure, with a nested data structure for the soil layer records.
Sample management events object
The management section of the JSON object consists of a series of events. Each event has a date and an event name, such as "planting" or "fertilizer". Additional data supplied depend on the type of event.
Sample observed data object