Initial situation
The work on facilitating access to and use of the INVEKOS data has so far been carried out mainly by Department II/1 of the BMLRT. The current scope of the data offered is documented in the form of a description of the tables available in the respective year and their contents. Regular evaluations from the data pool are carried out, inter alia, for the preparation of the Green Report of the BMLRT, for the evaluation of the Austrian Rural Development Programme, for the preparation of the Economic Accounts for Agriculture and for the servicing of research projects. A new query and evaluation system for the retrieval of anonymised individual farm accountancy data was developed and presented to the BMLRT. It is used to provide data for research purposes.
Objective
Numerous surveys and data evaluations are carried out in the environment of the Federal Ministry of Agriculture or on its behalf, which provide certain data sets on a regular basis (annually, monthly, weekly). These include, among others, the agricultural structure surveys, surveys of cultivated areas, stocks, producer prices, the agricultural accounts and foreign trade statistics of Statistics Austria, IN-VEKOS and subsidy data of the AMA, accounting data of the LBG, GIS data of Department II/4 of the BML or farm and land registers of the LFRZ. In addition, the BML has extensive databases on groundwater quality, biodiversity and forestry. There are links and connections between some of these data sources, which make it possible to carry out concrete evaluations for a combination of data from several sources.
The aim of this project is to develop an overview of the different surveys and data sources and their content, to identify discrepancies between the data stock and the data needs and to establish compatibility between the available data stocks. All data available to the Federal Institute of Agricultural Economics and Mining Research (BAB) and the department are to be combined and made quickly and easily accessible via interfaces, while fully respecting data protection and data security.
In addition, monthly and annual data on the development of issues and markets relevant to agriculture are to be made available on the homepage of the Federal Institute of Agricultural Economics and Mining Research in up-to-date form.
Work 2022
- Municipal database made publicly accessible
- Data of the agricultural structure survey 2020 imported
- Correction of the municipality structure in the data pool
- Conversion of the advertising of bookkeeping farms from Access to PostgreS
- Construction of the database and interface for the transfer of auction data
- Forecasting tool in Python for IDB
- Incorporation of forecast data into ALFIS
- Reprogramming of ALFIS scripts
The following work is also planned for 2023:
- Conversion and programming of the previous online tables on the BAB homepage of agricultural and economic data and the Green Report into online tables.
- Ongoing improvements and error corrections in the newly programmed BAB-ALFIS
- Networking in the field of geodata with related institutions within the framework of the GIS-Jour-Fixe of the BML
- Extension of predefined evaluation options and reports of data from the Foreign Trade database. This is useful because it enables users to carry out periodic evaluations very quickly.
- Programming of a new tool for querying foreign trade data
- Reprogramming of the existing ALFIS scripts for the new BAB-ALFIS and extension of the code for the creation of forecast data for IDB and test runs.
- The description blocks (meta information) of the ALFIS characteristics are revised and adapted to the requirements
- Incorporation, conversion and updating of further data
- Updating the municipal database (GeDaBa) and incorporating new features
- Conception of an extension of the use of the PostGIS database
- Conception of further possibilities of use of the georeferenced aerial photographs together with the LFRZ
- Intersection of agricultural data with GIS data
- Programming of a new address database, which will then be kept evident by Dept. II/1
- Development of a project together with Dept. I/3 (protective water management) regarding flood data. In 2019, the AOD has already been tested for Department I/3. Since January 2020, the database has been replicated in real time to the AOD and enables Department I/3 to carry out internal evaluations. Operation will continue in 2023.
- Development of a data exchange concept with the Hydrographic Central Office. The Callisto water level database has been running in real operation at the BAB since 1 June 2021. It is being examined whether this data can also be implemented in the OpenDataCube. The water levels are interesting parameters for drought/precipitation monitoring.
- Organisation and technical implementation of the data transfer from the AMA from the beginning of 2023, after the AMA has ended all data flows and processing via the LFRZ and transferred them to the AMA's own system. In addition to these tasks, the LFRZ also provided the AMA with evaluation tools for exporting the data and automatically transferring it to ALFIS. With the Market Transpa-rency Regulation, the data to be collected will be expanded and newly regulated. The data requirements are also specified by the ROBVEK project.
- Evaluations and automatic data transfer of the auction data of the Central Working Group of Austrian Cattle Breeders (ZAR) into the ALFIS database. This is necessary because the BML has discontinued the service it used to provide regarding price reports for the marketing of breeding cattle and has transferred this task to the ZAR.
- Data exchange ALFIS-ROBVEK database
- Inclusion of agricultural structure characteristics in the municipal database
- Reporting of breeding cattle auction data including storage in BAB-ALFIS
- Further development of the data pool (Node-based concept, load-balanced queries, - GPU acceleration, machine learning and deep learning integration using TensorFlow and PyTorch, Integration of R_Studio into the JupyterHUB, OLAP Data Cubes creation and development, - Implement web-based data visualisation and reporting, Develop or migrate existing data pipelines to Apache Airflow)
In 2023, the special evaluations for the area of compensatory allowance for disadvantaged areas (AZ) will also be continued and the results analysed.
Further work in 2023
he area classifications (agricultural production areas, agricultural locations, alpine pasture regions) created annually by the FADN, as well as evaluations based on them, must be adapted to the new area status, as they are every year. The geodata of the area delineations must be harmonised in accordance with the INSPIRE Directive and made available via the national and European INSPIRE portal. In 2023, the presentation quality and usability of the har-monised INSPIRE datasets of the FADN will be improved. Various regional evaluations and map representations are to be prepared.
At the request of Department II/6, an abridged version (only relating to the livestock and meat sector) will be prepared monthly in addition to the online offer.
In 2023, the strategic orientation and further development of the data pool, which is subject to great dynamism in terms of its design and implementation due to ongoing technical innovations, will be further advanced and implemented.
Continuation of the restructuring and consolidation of all data available in both the FADN and the BML.
