Reference Data

Data tables

• Bedding
• Carbon inputs
• Climate
• Country
• Crop type
• Dairy variety
• Direct energy type
• Energy category
• Factor
• Feed approach
• Feed components item
• Feed item region
• Fertiliser inhibition
• Fertiliser method
• Fertiliser nitrogen type
• Fertiliser nutrient
• Fertiliser production database
• Fertiliser source region
• Fertiliser type
• Forest type
• Grazing category
• Grazing quality
• Herd section
• Irrigation method
• Irrigation power source
• Irrigation water source
• Irrigation Calculation Type
• Land use
• Machine
• Management practice change
• Manure type
• Milk protein measure
• Month periods
• Oxygen demand
• Paddy water cultivation
• Paddy water preseason
• Pesticide category
• Pesticide type
• Processing type
• Protein measure
• Residue management type
• Soil Characteristics
• Soil drainage
• Soil moisture
• Soil moisture at sowing
• Soil organic matter
• Soil ph
• Soil texture
• Soil type
• Territory
• Tillage
• Transport type
• Tree type
• Unit
• Water treatment

Managing data

After making changes to any reference data, you need to re-generate these data tables:

$ django-admin.py export_sphinx_data

Overview of reference data in the CFT:

digraph { node [shape=record]; fixtures [ label="Fixtures|JSON" ] database [ label="Database|MariaDB" ] http [ label="HTTP client|JSON" ] spreadsheet [ label="Spreadsheet|CSV,XLS,..." ] "data tables" [ label="Data tables|CSV" ] "hard-coded values" [ label="Hard-coded values|Python" ] docs [ label="Documentation|RST" ] fixtures -> database[label="loaddata_auto"] database -> fixtures[label="dumpdata_auto"] database -> http[label="\"get\" API"] database -> spreadsheet[label="admin →"] spreadsheet -> database[label="admin ⬇"] database -> "data tables"[label="export_sphinx_data"] "data tables" -> docs[label="export_sphinx_data"] "hard-coded values" -> "data tables"[label="export_sphinx_data"] "hard-coded values" -> docs[label="export_sphinx_data"] docs -> HTML[label="Sphinx"] // <+ +> -> <+ +> }