Crop data reader SQLite

CLEM.FileSQLiteCrop

Reads external crop and forage data from a SQLite database

The Data reader components are used to read external data for use by CLEM. It is recommended that you place this component with the activities using them or below the CLEM component.

This Data reader is used to read crop and forage inputs from an SQLite database.

The following parameters are used to define this component

The name of the SQLite database including extension. Include the full path of the database if not contained in the same folder as the APSIMX file.

Name of the table within the database containing the crop or forage data.

The action to be taken when missing data is detected (e.g. a year without growth records) and allows for reporting an error and stopping, reporting a warning and continuing, or ignoring the warning and continuing.

The following columns are expected in the table. The column name referring to the data can be supplied such that any table can be used to provide data.

Each row of the table must contain a year and month column, with crop name and amount harvested columns.

The row must also contain a column to identify the land id. This column allows you to provide multiple instances of a crop in the table. For example there may be one for irrigated and one for fertilised that are used in different fields of your simulation farm.

Finally, the percent nitrogen is an optional column to provide the nitrogen content of the crop or left blank if not available.

The name of the column in the specified table identifying the crop to be used.

Default: CropName

The name of the column in the specified table containing the land id, or particular version of the crop data. This will be linked to the land id supplied for the selected Land type.

Default: SoilNum

The name of the column in the specified table containing year data.

Default: Year

The name of the column in the specified table containing month data.

Default: Month

The amount (kg) produced or harvested in the month.

Default: AmtKg

The nitrogen percent of the product produced. This is an optional column that will determine the changes in quality (Nitrogen content) of the harvested material.

Default: [Blank]

See also