-- Verificación de atributos en la tabla maestra
SELECT 
    dpto, 
    dist, 
    count(*) as total, 
    count(NULLIF(snc_cuenta, '')) as con_cuenta_real,
    count(NULLIF(ccatastral, '')) as con_catastro
FROM public.snc_raw_lotes_activos 
WHERE dpto = 'F' AND dist = 1
GROUP BY dpto, dist;