Downloaden data:
select sta_site.stas_name_s SiteName,
STA_ATTR.STSV_VALUE_S stroomgebied,
sta_base.sta_name_s StationName,
bd_basicdata2.bd_shortname_s ParameterName,
par_object.PAR_NAME_S,
sta_site.stas_name_s
|| '.'
|| sta_base.sta_name_s
|| '.'
|| par_object.par_name_s
|| '.'
|| loc_language_text.txtl_text_s Label,
ts_timeseries.ts_shortname_s TS_ShortName,
loc_language_text.txtl_text_s ts_naam,
ts_timeseries.ts_ID TS_ID,
to_char(TS_INSTANCE.TS_MINTSTAMP_UTC,'YYYY-MM-DD') TS_MINTSTAMP_UTC,
to_char(TS_INSTANCE.TS_MAXTSTAMP_UTC,'YYYY-MM-DD') TS_MAXTSTAMP_UTC,
TS_TIMESERIES.TS_CLIENTVALUE1_S,
ref_position.rep_local_X_FL,
ref_position.rep_local_y_FL
FROM sta_site,
sta_base,
bd_basicdata bd_basicdata2,
loc_language_text,
par_object,
ts_timeseries,
ts_instance,
sta_site_type,
bd_basicdata,
ref_position,
(select *
from STA_SITE_MN_ATTR
where STSA_ID=11139
) sta_attr
WHERE
ts_instance.ts_id = ts_timeseries.ts_id
AND sta_site_type.stast_id(+) = sta_site.stast_id
AND sta_site.stas_id = sta_base.stas_id
AND bd_basicdata.bd_tca_refkey_l = sta_base.sta_id(+)
AND par_object.par_id = bd_basicdata2.bd_tca_refkey_l
AND loc_language_text.txt_id = ts_timeseries.txt_id_name
AND lang_id = 1042
AND bd_basicdata2.bd_id = ts_timeseries.bd_id
AND bd_basicdata.bd_id = bd_basicdata2.bd_id_parent
and ref_position.rep_id(+)=sta_site.rep_id
and sta_attr.stas_ID(+)=STA_SITE.STAS_ID
and ts_timeseries.TS_ID='50770042' AND sta_site.stas_id=
order by stroomgebied, LABEL