Unflagged sites?
Hi Andy,
ich habe meine queries jetzt "in order" at least thats what I think^^
Jetzt hat sich folgende Frage ergeben:
Kann es sein, dass dein flagging nicht für alle site durchgeführt wird?
Hier mal ein Beispiel:
qq = "SELECT signal.timestamp, value, unit, parameter.name, source_type.name,
source.name, signal_quality.quality_id
FROM signal
INNER JOIN site ON signal.site_id = site.site_id
INNER JOIN parameter ON signal.parameter_id = parameter.parameter_id
INNER JOIN source ON signal.source_id = source.source_id
INNER JOIN source_type ON source.source_type_id = source_type.source_type_id
INNER JOIN signals_signal_quality_association ON signals_signal_quality_association.signal_id = signal.signal_id
INNER JOIN signal_quality ON signals_signal_quality_association.signal_quality_id = signal_quality.signal_quality_id
WHERE site.name ='rohrbach_fehraltorferstr'
GROUP BY signal.signal_id, parameter.name, unit, source_type.name, source.name,signal_quality.quality_id
ORDER BY signal.timestamp ASC;"
qq_no_q = "SELECT signal.timestamp, value, unit, parameter.name, source_type.name,
source.name
FROM signal
INNER JOIN site ON signal.site_id = site.site_id
INNER JOIN parameter ON signal.parameter_id = parameter.parameter_id
INNER JOIN source ON signal.source_id = source.source_id
INNER JOIN source_type ON source.source_type_id = source_type.source_type_id
WHERE site.name ='rohrbach_fehraltorferstr'
GROUP BY signal.signal_id, parameter.name, unit, source_type.name, source.name
ORDER BY signal.timestamp ASC;"
Die erste query gibt jedoch leider nix wieder.
Die zweite query gibt mir daten für die site wieder.
Betroffene sites und damit verbundene sources sind:
sites
-------
450a_usterstr
rohrbach_fehraltorferstr
rubmorg_inflow
164_luppmenweg
outflow_ara
sources
---------
bt_plsABL1301_outflow_ara
bl_dl311_rubmorg_inflow
bl_lm076_rohrbach_fehraltorferstr
bl_ce465_rohrbach_fehraltorferstr
bf_plsABL1101_outflow_ara
bt_dl928_165_luppmenweg
bl_plsRKBM1201_rubmorg_inflow
bt_dl927_164_luppmenweg
bt_dl929_164_luppmenweg
bq_plsABL3701_outflow_ara
bx_ce792_450a_usterstr
bt_dl926_rubmorg_inflow
Grüße!
Christian