QUADICA — Opis kolumn plików danych / Column descriptions

Ebeling et al. (2022) · HydroShare DOI: 10.4211/hs.0ec5f43e43c349ff818a8d57699c0fe1

c_annual_with_coords.csv — roczne dane jakości wody / annual water quality data

Kolumna (oryginalna → globalna)PolskiEnglishJednostkaNazwa globalna / Global nameGrupa / Factor
n_Q→ n_Q_annualLiczba pomiarów przepływu w dniach poboru próbek (roczna)No. of discharge obs. on sampling days (annual)—No. of Discharge Observations on Sampling Days Annual [-]surface water quantity
median_Q→ median_Q_annualMediana przepływu w dniach poboru próbek (roczna)Median discharge on sampling days (annual)m³/sMedian Discharge on Sampling Days Annual [m³/s]surface water quantity
n_NO3Liczba obserwacji azotanówNo. of nitrate observations—No. of Nitrate Observations [-]surface water quality
median_NO3NMediana stężenia NO₃-NMedian nitrate concentration NO₃-Nmg N/LNitrate Concentration NO3-N [mg N/L]surface water quality
n_NminLiczba obserwacji azotu mineralnegoNo. of mineral nitrogen observations—No. of Mineral Nitrogen Observations [-]surface water quality
median_NminMediana stężenia N_minMedian mineral nitrogen concentrationmg N/LMineral Nitrogen Concentration Nmin [mg N/L]surface water quality
n_TNLiczba obserwacji azotu całkowitegoNo. of total nitrogen observations—No. of Total Nitrogen Observations [-]surface water quality
median_TNMediana stężenia TNMedian total nitrogen concentrationmg N/LTotal Nitrogen Concentration TN [mg N/L]surface water quality
n_PO4Liczba obserwacji fosforanówNo. of phosphate observations—No. of Phosphate Observations [-]surface water quality
median_PO4PMediana stężenia PO₄-PMedian phosphate concentration PO₄-Pmg P/LPhosphate Concentration PO4-P [mg P/L]surface water quality
n_TPLiczba obserwacji fosforu całkowitegoNo. of total phosphorus observations—No. of Total Phosphorus Observations [-]surface water quality
median_TPMediana stężenia TPMedian total phosphorus concentrationmg P/LTotal Phosphorus Concentration TP [mg P/L]surface water quality
n_DOCLiczba obserwacji DOCNo. of DOC observations—No. of DOC Observations [-]surface water quality
median_DOCMediana stężenia DOCMedian DOC concentrationmg C/LDissolved Organic Carbon Concentration DOC [mg C/L]surface water quality
n_TOCLiczba obserwacji TOCNo. of TOC observations—No. of TOC Observations [-]surface water quality
median_TOCMediana stężenia TOCMedian TOC concentrationmg C/LTotal Organic Carbon Concentration TOC [mg C/L]surface water quality

n_surplus_with_coords.csv — nadwyżka azotu (roczna) / nitrogen surplus (annual)

Kolumna (oryginalna → globalna)PolskiEnglishJednostkaNazwa globalna / Global nameGrupa / Factor
N_nonagriNadwyżka N ze źródeł nierolniczychN surplus from non-agricultural sourceskg N/ha/yrNon-Agricultural Nitrogen Surplus [kg N/ha/yr]surface water quality
N_agriNadwyżka N ze źródeł rolniczychN surplus from agricultural sourceskg N/ha/yrAgricultural Nitrogen Surplus [kg N/ha/yr]surface water quality
N_totalCałkowita nadwyżka NTotal N surpluskg N/ha/yrTotal Nitrogen Surplus [kg N/ha/yr]surface water quality
N_agri_fracUdział źródeł rolniczych w nadwyżce NFraction of agricultural N surplus0–1Agricultural Fraction of Nitrogen Surplus [-]surface water quality

pet_monthly_with_coords.csv — ewapotranspiracja potencjalna / potential evapotranspiration

Kolumna (oryginalna → globalna)PolskiEnglishJednostkaNazwa globalna / Global nameGrupa / Factor
petEwapotranspiracja potencjalna — miesięczna sumaPotential evapotranspiration — monthly summm/monthMonthly Potential Evaporation Total [mm/month]potential evaporation

per_monthly_with_coords.csv — opady / precipitation

Kolumna (oryginalna → globalna)PolskiEnglishJednostkaNazwa globalna / Global nameGrupa / Factor
preOpady atmosferyczne — miesięczna sumaPrecipitation — monthly summm/monthMonthly Precipitation Total [mm/month]precipitation

q_annual_with_coords.csv — roczny przepływ / annual discharge

Kolumna (oryginalna → globalna)PolskiEnglishJednostkaNazwa globalna / Global nameGrupa / Factor
n_QdailyLiczba dziennych pomiarów przepływu w rokuNo. of daily discharge measurements per year—No. of Daily Discharge Observations [-]surface water quantity
median_QdailyMediana dziennego przepływu w rokuMedian daily discharge per yearm³/sMedian Daily Discharge [m³/s]surface water quantity

tavg_monthly_with_coords.csv — temperatura powietrza / air temperature

Kolumna (oryginalna → globalna)PolskiEnglishJednostkaNazwa globalna / Global nameGrupa / Factor
tavgŚrednia temperatura powietrza — miesięczna medianaMean air temperature — monthly median°CMonthly Median Air Temperature [°C]temperature

wrtds_monthly_with_coords_date_merged.csv — model WRTDS (miesięczny) / WRTDS model (monthly)

Kolumna (oryginalna → globalna)PolskiEnglishJednostkaNazwa globalna / Global nameGrupa / Factor
n_Q→ n_Q_wrtdsLiczba obserwacji przepływu (WRTDS, miesięczna)No. of discharge observations (WRTDS, monthly)—WRTDS No. of Discharge Observations [-]surface water quantity
median_Q→ median_Q_wrtdsMediana przepływu miesięcznego (WRTDS)Median monthly discharge (WRTDS)m³/sWRTDS Median Monthly Discharge [m³/s]surface water quantity
n_C_NO3Liczba obserwacji NO₃No. of nitrate observations—WRTDS No. of Nitrate Observations [-]surface water quality
median_C_NO3Mediana obserwowanego stężenia NO₃-NMedian observed nitrate concentrationmg N/LWRTDS Median Nitrate Concentration NO3-N [mg N/L]surface water quality
n_C_PO4Liczba obserwacji PO₄No. of phosphate observations—WRTDS No. of Phosphate Observations [-]surface water quality
median_C_PO4Mediana obserwowanego stężenia PO₄-PMedian observed phosphate concentrationmg P/LWRTDS Median Phosphate Concentration PO4-P [mg P/L]surface water quality
n_C_NminLiczba obserwacji NminNo. of mineral nitrogen observations—WRTDS No. of Mineral Nitrogen Observations [-]surface water quality
median_C_NminMediana obserwowanego stężenia NminMedian observed mineral nitrogen concentrationmg N/LWRTDS Median Mineral Nitrogen Concentration Nmin [mg N/L]surface water quality
n_C_TNLiczba obserwacji TNNo. of total nitrogen observations—WRTDS No. of Total Nitrogen Observations [-]surface water quality
median_C_TNMediana obserwowanego stężenia TNMedian observed total nitrogen concentrationmg N/LWRTDS Median Total Nitrogen Concentration TN [mg N/L]surface water quality
n_C_TPLiczba obserwacji TPNo. of total phosphorus observations—WRTDS No. of Total Phosphorus Observations [-]surface water quality
median_C_TPMediana obserwowanego stężenia TPMedian observed total phosphorus concentrationmg P/LWRTDS Median Total Phosphorus Concentration TP [mg P/L]surface water quality
n_C_DOCLiczba obserwacji DOCNo. of DOC observations—WRTDS No. of DOC Observations [-]surface water quality
median_C_DOCMediana obserwowanego stężenia DOCMedian observed DOC concentrationmg C/LWRTDS Median DOC Concentration [mg C/L]surface water quality
n_C_TOCLiczba obserwacji TOCNo. of TOC observations—WRTDS No. of TOC Observations [-]surface water quality
median_C_TOCMediana obserwowanego stężenia TOCMedian observed TOC concentrationmg C/LWRTDS Median TOC Concentration [mg C/L]surface water quality
n_FNC_NO3Liczba wartości FNC NO₃No. of flow-normalized nitrate values—WRTDS No. of Flow-Normalized Nitrate Values [-]surface water quality
median_FNC_NO3Mediana stężenia znorm. NO₃-NMedian flow-normalized nitrate concentrationmg N/LWRTDS Flow-Normalized Nitrate Concentration NO3-N [mg N/L]surface water quality
n_FNC_PO4Liczba wartości FNC PO₄No. of flow-normalized phosphate values—WRTDS No. of Flow-Normalized Phosphate Values [-]surface water quality
median_FNC_PO4Mediana stężenia znorm. PO₄-PMedian flow-normalized phosphate concentrationmg P/LWRTDS Flow-Normalized Phosphate Concentration PO4-P [mg P/L]surface water quality
n_FNC_NminLiczba wartości FNC NminNo. of flow-normalized mineral nitrogen values—WRTDS No. of Flow-Normalized Mineral Nitrogen Values [-]surface water quality
median_FNC_NminMediana stężenia znorm. NminMedian flow-normalized mineral nitrogen concentrationmg N/LWRTDS Flow-Normalized Mineral Nitrogen Concentration Nmin [mg N/L]surface water quality
n_FNC_TNLiczba wartości FNC TNNo. of flow-normalized total nitrogen values—WRTDS No. of Flow-Normalized Total Nitrogen Values [-]surface water quality
median_FNC_TNMediana stężenia znorm. TNMedian flow-normalized total nitrogen concentrationmg N/LWRTDS Flow-Normalized Total Nitrogen Concentration TN [mg N/L]surface water quality
n_FNC_TPLiczba wartości FNC TPNo. of flow-normalized total phosphorus values—WRTDS No. of Flow-Normalized Total Phosphorus Values [-]surface water quality
median_FNC_TPMediana stężenia znorm. TPMedian flow-normalized total phosphorus concentrationmg P/LWRTDS Flow-Normalized Total Phosphorus Concentration TP [mg P/L]surface water quality
n_FNC_DOCLiczba wartości FNC DOCNo. of flow-normalized DOC values—WRTDS No. of Flow-Normalized DOC Values [-]surface water quality
median_FNC_DOCMediana stężenia znorm. DOCMedian flow-normalized DOC concentrationmg C/LWRTDS Flow-Normalized DOC Concentration [mg C/L]surface water quality
n_FNC_TOCLiczba wartości FNC TOCNo. of flow-normalized TOC values—WRTDS No. of Flow-Normalized TOC Values [-]surface water quality
median_FNC_TOCMediana stężenia znorm. TOCMedian flow-normalized TOC concentrationmg C/LWRTDS Flow-Normalized TOC Concentration [mg C/L]surface water quality
mean_Flux_NO3Średni ładunek NO₃-NMean nitrate fluxkg N/ha/moWRTDS Mean Nitrate Flux NO3-N [kg N/ha/month]surface water quality
mean_FNFlux_NO3Średni znorm. ładunek NO₃-NMean flow-normalized nitrate fluxkg N/ha/moWRTDS Mean Flow-Normalized Nitrate Flux NO3-N [kg N/ha/month]surface water quality
mean_Flux_PO4Średni ładunek PO₄-PMean phosphate fluxkg P/ha/moWRTDS Mean Phosphate Flux PO4-P [kg P/ha/month]surface water quality
mean_FNFlux_PO4Średni znorm. ładunek PO₄-PMean flow-normalized phosphate fluxkg P/ha/moWRTDS Mean Flow-Normalized Phosphate Flux PO4-P [kg P/ha/month]surface water quality
mean_Flux_NminŚredni ładunek NminMean mineral nitrogen fluxkg N/ha/moWRTDS Mean Mineral Nitrogen Flux Nmin [kg N/ha/month]surface water quality
mean_FNFlux_NminŚredni znorm. ładunek NminMean flow-normalized mineral nitrogen fluxkg N/ha/moWRTDS Mean Flow-Normalized Mineral Nitrogen Flux Nmin [kg N/ha/month]surface water quality
mean_Flux_TNŚredni ładunek TNMean total nitrogen fluxkg N/ha/moWRTDS Mean Total Nitrogen Flux TN [kg N/ha/month]surface water quality
mean_FNFlux_TNŚredni znorm. ładunek TNMean flow-normalized total nitrogen fluxkg N/ha/moWRTDS Mean Flow-Normalized Total Nitrogen Flux TN [kg N/ha/month]surface water quality
mean_Flux_TPŚredni ładunek TPMean total phosphorus fluxkg P/ha/moWRTDS Mean Total Phosphorus Flux TP [kg P/ha/month]surface water quality
mean_FNFlux_TPŚredni znorm. ładunek TPMean flow-normalized total phosphorus fluxkg P/ha/moWRTDS Mean Flow-Normalized Total Phosphorus Flux TP [kg P/ha/month]surface water quality
mean_Flux_DOCŚredni ładunek DOCMean DOC fluxkg C/ha/moWRTDS Mean DOC Flux [kg C/ha/month]surface water quality
mean_FNFlux_DOCŚredni znorm. ładunek DOCMean flow-normalized DOC fluxkg C/ha/moWRTDS Mean Flow-Normalized DOC Flux [kg C/ha/month]surface water quality
mean_Flux_TOCŚredni ładunek TOCMean TOC fluxkg C/ha/moWRTDS Mean TOC Flux [kg C/ha/month]surface water quality
mean_FNFlux_TOCŚredni znorm. ładunek TOCMean flow-normalized TOC fluxkg C/ha/moWRTDS Mean Flow-Normalized TOC Flux [kg C/ha/month]surface water quality

Oznaczenia związków (* w WRTDS) / Compound codes (* in WRTDS)

NO3Azotany — NO₃-N·Nitrate — NO₃-N
PO4Fosforany — PO₄-P·Phosphate — PO₄-P
NminMineralny azot (NO₃-N + NH₄-N)·Mineral nitrogen (NO₃-N + NH₄-N)
TNAzot całkowity·Total nitrogen
TPFosfor całkowity·Total phosphorus
DOCRozpuszczony węgiel organiczny·Dissolved organic carbon
TOCCałkowity węgiel organiczny·Total organic carbon

Legenda grup / Factor legend

temperatureTemperatura powietrza / Air temperature
precipitationOpady / Precipitation
potential evaporationEwapotranspiracja potencjalna / Potential evapotranspiration
surface water quantityIlość wód powierzchniowych / Surface water quantity
surface water qualityJakość wód powierzchniowych / Surface water quality
⚠️ Uwaga / Note: Kolumny oznaczone → nowa_nazwa zostały przemianowane ze względu na konflikt nazw między plikami. / Columns marked → new_name were renamed due to naming conflict between files. Verify against Metadata_QUADICA.pdf from the HydroShare repository.