-- 10 Registros de la Cartografía Local (SNC)
SELECT 'LOCAL_SNC' as fuente, ccatastral, snc_cuenta, ccc 
FROM public.e505_lotes_activos 
LIMIT 10;

-- 10 Registros del Sistema Municipal (SIGEM)
SELECT 'REMOTO_SIGEM' as fuente, inm_ctacatastral, REPLACE(inm_ctacatastral, '-', '') as join_esperado, trb_total_deuda 
FROM fdw_505.v_liq_entidad_totalxobjeto 
WHERE trb_total_deuda > 0
LIMIT 10;
