select distinct platform.platform_handle
    ,fixed_longitude
    ,fixed_latitude
    ,platform.description
    ,platform.url
    ,obs_type.standard_name
  from platform
    left join organization on platform.organization_id = organization.row_id
    left join sensor on platform.row_id=sensor.platform_id
    left join m_type on m_type.row_id=sensor.m_type_id
    left join m_scalar_type on m_scalar_type.row_id=m_type.m_scalar_type_id
    left join obs_type on obs_type.row_id=m_scalar_type.obs_type_id
where platform.active <=3 and fixed_longitude < -66 and fixed_longitude > -90 and fixed_latitude > 20 and fixed_latitude < 40
  order by platform_handle,obs_type.standard_name;
