SELECT
    v_obsseriescat_expand.loc_src_id AS sta_id,
    v_obsseriescat_expand.loc_sname AS sta_sname,
    v_obsseriescat_expand.loc_lname AS sta_lname,
    v_obsseriescat_expand.longitude,
    v_obsseriescat_expand.latitude,
    min(v_obsseriescat_expand.z_min) AS z_min,
    min(v_obsseriescat_expand.dtime_start) AS dtime_start,
    max(v_obsseriescat_expand.dtime_end) AS dtime_end,
    count(*) AS sensor_cnt,
    v_obsseriescat_expand.platform_handle,
    v_obsseriescat_expand.platform_lname,
    'Washington'::character(25) AS state,
    'PRISM-UW'::character(25) AS provider
FROM v_obsseriescat_expand
WHERE v_obsseriescat_expand.platform_id = 5
        AND v_obsseriescat_expand.loc_src::text = 'station'::text
GROUP BY v_obsseriescat_expand.loc_src_id,
    v_obsseriescat_expand.loc_sname,
    v_obsseriescat_expand.loc_lname,
    v_obsseriescat_expand.longitude,
    v_obsseriescat_expand.latitude,
    v_obsseriescat_expand.platform_handle,
    v_obsseriescat_expand.platform_lname
ORDER BY v_obsseriescat_expand.loc_src_id