SELECT
    osc.row_id,
    osc.geom_pt,
    osc.platform_id,
    pl.platform_handle,
    pl.long_name AS platform_lname,
    pl.obs_freq_type,
    osc.sensor_id,
    sn.short_name AS sensor_name,
    st.type_name AS sensor_type,
    osc.s_order AS sensor_order,
    osc.m_type_id,
    mt.num_types AS m_type_numtyp,
    vmsdd.obs_type_name,
    vmsdd.uom_type_disp,
    osc.loc_src_id,
    osc.loc_src,
    osc.longitude,
    osc.latitude,
    co.short_name AS loc_sname,
    co.long_name AS loc_lname,
    osc.z_min,
    osc.z_max,
    osc.dtime_start,
    osc.dtime_end,
    osc.m_value_cnt,
    osc.m_value_avg,
    osc.m_value_std,
    osc.m_value_min,
    osc.m_value_max
FROM obs_series_cat osc,
    platform pl,
    collection co,
    sensor sn,
    sensor_type st,
    m_type mt,
    v_m_scalar_dd vmsdd
WHERE osc.platform_id = pl.row_id
        AND osc.sensor_id = sn.row_id
        AND osc.sensor_type_id = st.row_id
        AND osc.loc_src_id = co.row_id
        AND osc.m_type_id = mt.row_id
        AND mt.m_scalar_type_id = vmsdd.row_id
ORDER BY osc.row_id