Map 0001
Map Documentation: Poultry Farm Discovery (BDN)
---
- General Details
- **Owner:** IZSVe - Istituto Zooprofilattico Sperimentale delle Venezie
- **Source:** National Data Bank (BDN) - DWH Fact: ALLEVAMENTI_AVICOLI
- **Publication Date:** 2017-01-01
- **Destination:** GIS Instance / WebGIS / Influenza Monitoring Portal
---
- Abstract
This dataset provides a comprehensive list of **valid**, **open**, and **closed** poultry farms registered in the National Data Bank (BDN). It specifically filters for farms categorized as 'Breeding' (AL) or 'Mixed' (MS) across Italy.
The data is processed through a join between the poultry breeding facts and the 'Places' (Luoghi) dimension (filtered for valid/open locations). It also incorporates owner/holder details via an outer join with the 'Registry' (Anagrafe) dimension and housing data via the 'Poultry Housing' (Accasamenti) dimension.
---
- Geographic Information
- **Coverage Area:** Italy (National territory)
- **Coordinate Reference System:** EPSG:32632 (WGS 84 / UTM zone 32N) - *Implicit in GIS Instance*
- **Geographic Unit:** Municipality (ISTAT) / ASL Competence Districts
|}
Lineage & Technical Logic
The dataset is extracted based on the following logic:
- **Validity Check:** Execution date must fall between `AVIDATA_VALSTART` and `AVIDATA_VALEND`.
- **Activity Filter:** `tipologia_attivita` MUST be 'AL' (Breeding) or 'MS' (Mixed).
- **Relational Joins:** #* **Inner Join:** `IZIADMIN.LUOGHI` (Filtered for valid/open sites).