-- =====================================================================
-- SEED 006 (Bloco 7) — Coordenadas aproximadas dos bairros de Uberlândia
-- Dado de REFERÊNCIA (não estrutura). Idempotente: só preenche bairro
-- sem coordenada, casando por nome+tenant. Coordenadas aproximadas por
-- setor (centro de Uberlândia ~ -18.9186, -48.2772).
-- Sem isto o mapa nasce vazio; com isto, demandas/cidadãos/visitas/
-- compromissos herdam a coordenada do bairro (fallback nas queries).
-- =====================================================================

-- Setor Central
UPDATE neighborhoods SET latitude=-18.9186, longitude=-48.2772 WHERE tenant_id=1 AND name='Centro'          AND latitude IS NULL;
UPDATE neighborhoods SET latitude=-18.9132, longitude=-48.2820 WHERE tenant_id=1 AND name='Fundinho'        AND latitude IS NULL;
UPDATE neighborhoods SET latitude=-18.9160, longitude=-48.2710 WHERE tenant_id=1 AND name='Lídice'          AND latitude IS NULL;
UPDATE neighborhoods SET latitude=-18.9230, longitude=-48.2740 WHERE tenant_id=1 AND name='Osvaldo Rezende' AND latitude IS NULL;
UPDATE neighborhoods SET latitude=-18.9300, longitude=-48.2560 WHERE tenant_id=1 AND name='Martins'         AND latitude IS NULL;

-- Setor Sul
UPDATE neighborhoods SET latitude=-18.9450, longitude=-48.2650 WHERE tenant_id=1 AND name='Santa Mônica'    AND latitude IS NULL;
UPDATE neighborhoods SET latitude=-18.9080, longitude=-48.2880 WHERE tenant_id=1 AND name='Saraiva'         AND latitude IS NULL;
UPDATE neighborhoods SET latitude=-18.9089, longitude=-48.2735 WHERE tenant_id=1 AND name='Tabajaras'       AND latitude IS NULL;
UPDATE neighborhoods SET latitude=-18.9520, longitude=-48.2720 WHERE tenant_id=1 AND name='Cidade Jardim'   AND latitude IS NULL;
UPDATE neighborhoods SET latitude=-18.9400, longitude=-48.2850 WHERE tenant_id=1 AND name='Gávea'           AND latitude IS NULL;

-- Setor Leste
UPDATE neighborhoods SET latitude=-18.9050, longitude=-48.2450 WHERE tenant_id=1 AND name='Tibery'          AND latitude IS NULL;
UPDATE neighborhoods SET latitude=-18.9150, longitude=-48.2400 WHERE tenant_id=1 AND name='Aparecida'       AND latitude IS NULL;
UPDATE neighborhoods SET latitude=-18.9250, longitude=-48.2350 WHERE tenant_id=1 AND name='Santa Rosa'      AND latitude IS NULL;
UPDATE neighborhoods SET latitude=-18.9350, longitude=-48.2300 WHERE tenant_id=1 AND name='Morumbi'         AND latitude IS NULL;

-- Setor Norte
UPDATE neighborhoods SET latitude=-18.8850, longitude=-48.2700 WHERE tenant_id=1 AND name='Roosevelt'           AND latitude IS NULL;
UPDATE neighborhoods SET latitude=-18.8780, longitude=-48.2650 WHERE tenant_id=1 AND name='Marta Helena'        AND latitude IS NULL;
UPDATE neighborhoods SET latitude=-18.8800, longitude=-48.2780 WHERE tenant_id=1 AND name='Presidente Roosevelt' AND latitude IS NULL;
UPDATE neighborhoods SET latitude=-18.8720, longitude=-48.2820 WHERE tenant_id=1 AND name='Jardim Brasília'     AND latitude IS NULL;

-- Setor Oeste
UPDATE neighborhoods SET latitude=-18.9300, longitude=-48.3050 WHERE tenant_id=1 AND name='Luizote de Freitas' AND latitude IS NULL;
UPDATE neighborhoods SET latitude=-18.9380, longitude=-48.3100 WHERE tenant_id=1 AND name='Tocantins'          AND latitude IS NULL;
UPDATE neighborhoods SET latitude=-18.9250, longitude=-48.2980 WHERE tenant_id=1 AND name='Planalto'           AND latitude IS NULL;
UPDATE neighborhoods SET latitude=-18.9450, longitude=-48.3150 WHERE tenant_id=1 AND name='Jardim Patrícia'    AND latitude IS NULL;
UPDATE neighborhoods SET latitude=-18.9180, longitude=-48.3020 WHERE tenant_id=1 AND name='Guarani'            AND latitude IS NULL;

-- Qualquer bairro restante sem coordenada: aproxima do centro (refina depois).
UPDATE neighborhoods SET latitude=-18.9186, longitude=-48.2772
  WHERE tenant_id=1 AND latitude IS NULL;