Crop data reader SQLite
CLEM.FileSQLiteCrop
Reads external crop and forage data from a SQLite database
Description
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.
Parameters
The following parameters are used to define this component
Filename
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.
The specified file cannot be open some other applications (e.g. Excel) when you run your simulation.
Table name
Name of the table within the database containing the crop or forage data.
Missing data action
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.
Column name for crop name
The name of the column in the specified table identifying the crop to be used.
Default: CropName
Column name for Land ID
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
Column name for year
The name of the column in the specified table containing year data.
Default: Year
Column name for month
The name of the column in the specified table containing month data.
Default: Month
Amount
The amount (kg) produced or harvested in the month.
Default: AmtKg
Npct
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