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:

1. **Validity Check:** Execution date must fall between `AVIDATA_VALSTART` and `AVIDATA_VALEND`.
2. **Activity Filter:** `tipologia_attivita` MUST be 'AL' (Breeding) or 'MS' (Mixed).
3. **Relational Joins:** #* **Inner Join:** `IZIADMIN.LUOGHI` (Filtered for valid/open sites).