SELECT count(*) as total_lotes_locales FROM public.snc_raw_lotes_activos;