MATERIALIZED VIEW: APPS.CSF_MD_LAND_USES_MAT_V

Source

SELECT land.feature_code, land.park_type, land.area, land.geometry, names.NAME
   FROM csf_md_land_uses land, csf_md_names names
  WHERE land.landuse_id = names.landuse_id
    AND names.admin_bound_id IS NULL
    AND names.railroad_segment_id IS NULL
    AND names.hydrography_id IS NULL
 UNION ALL
 SELECT land.feature_code, land.park_type, land.area, land.geometry, NULL
   FROM csf_md_land_uses land
  WHERE NOT EXISTS (SELECT 1
                    FROM   csf_md_names names
                    WHERE  names.landuse_id  = land.landuse_id )