-- Update studio coordinates (geocoded from addresses)
-- Run after studios are imported and after 008_add_google_place_id.sql

-- 1. Baltic Detailing — Lizuma iela 1, Rīga
UPDATE studios SET lat = 56.985792, lng = 24.204861 WHERE name LIKE '%Baltic Detailing%';

-- 2. Troks Detailing — Jūrkalnes iela 62, Rīga
UPDATE studios SET lat = 56.936967, lng = 24.016125 WHERE name LIKE '%Troks%Detailing%';

-- 3. DeCar Detailing — Latgales iela 82a, Rīga
UPDATE studios SET lat = 56.939278, lng = 24.132577 WHERE name LIKE '%DeCar%';

-- 4. polirovka.lv — Lubānas iela 129e, Rīga
UPDATE studios SET lat = 56.932583, lng = 24.208997 WHERE name LIKE '%polirovka%';

-- 5. Greenline Auto — Brīvības iela 116, Rīga
UPDATE studios SET lat = 56.962012, lng = 24.135015 WHERE name LIKE '%Greenline%';

-- 6. CeramicPro Latvia — Viestura iela 31, Jūrmala
UPDATE studios SET lat = 56.976569, lng = 23.859878 WHERE name LIKE '%CeramicPro%' OR name LIKE '%Carwash Granta%';

-- 7. AZ DETAIL — Jūrmalas iela 3A, Piņķi
UPDATE studios SET lat = 56.962041, lng = 23.627371 WHERE name LIKE '%AZ DETAIL%';

-- 8. Riga Car Detailing — Krustpils iela 6, Rīga
UPDATE studios SET lat = 56.927283, lng = 24.183501 WHERE name LIKE '%Riga Car Detailing%';

-- 9. AUTOESTETIKA — Brīvības gatve 193A, Rīga
UPDATE studios SET lat = 56.971116, lng = 24.155119 WHERE name LIKE '%AUTOESTETIKA%';

-- 10. BOLD Car Works — Jūrkalnes iela 15, Rīga
UPDATE studios SET lat = 56.943243, lng = 24.031150 WHERE name LIKE '%BOLD%Car%';

-- 11. AUTO ĶĪMISKĀ TĪRĪTAVA — Skanstes iela 70, Rīga
UPDATE studios SET lat = 56.971524, lng = 24.121205 WHERE name LIKE '%ĶĪMISKĀ TĪRĪTAVA%';

-- 12. Green Clean — Latgales iela 418, Rīga
UPDATE studios SET lat = 56.895535, lng = 24.211043 WHERE name LIKE '%Green Clean%';

-- 13. Vinylworks — Rēzeknes iela 4, Rīga
UPDATE studios SET lat = 56.934097, lng = 24.176621 WHERE name LIKE '%Vinylworks%';

-- 14. Riga Customs — Rencēnu iela 10A, Rīga
UPDATE studios SET lat = 56.921261, lng = 24.199340 WHERE name LIKE '%Riga Customs%';

-- 15. Paint Protect — Ventspils iela 53, Rīga
UPDATE studios SET lat = 56.932063, lng = 24.051677 WHERE name LIKE '%Paint Protect%';

-- 16. Restyling Workshop — Plieņciema iela 5, Mārupe
UPDATE studios SET lat = 56.927287, lng = 24.016448 WHERE name LIKE '%Restyling%Workshop%';

-- 17. NFD detailing studio — Stabu iela 76, Rīga
UPDATE studios SET lat = 56.951122, lng = 24.138833 WHERE name LIKE '%NFD%';

-- 18. AUTOTONĒŠANA — Biķernieku iela 162A, Rīga
UPDATE studios SET lat = 56.957040, lng = 24.256713 WHERE name LIKE '%AUTOTONĒŠANA%' OR name LIKE '%AUTOTONESANA%';

-- 19. Chromiq Riga Detail — Krimuldas iela 6, Rīga
UPDATE studios SET lat = 56.970709, lng = 24.155648 WHERE name LIKE '%Chromiq%';

-- 20. Level888 — Piedrujas iela 28, Rīga
UPDATE studios SET lat = 56.932526, lng = 24.177170 WHERE name LIKE '%Level888%';

-- 21. Caroscar.lv — Šmerļa iela 3, Rīga
UPDATE studios SET lat = 56.978198, lng = 24.211860 WHERE name LIKE '%Caroscar%';

-- 22. NEMO WASH — Lāčplēša iela 78a, Rīga
UPDATE studios SET lat = 56.947754, lng = 24.133589 WHERE name LIKE '%NEMO%WASH%';

-- 23. EA WRAP WORKS — Vienības gatve 18, Rīga
UPDATE studios SET lat = 56.931116, lng = 24.092928 WHERE name LIKE '%EA WRAP%';

-- 24. Gold Group — Dārzaugu iela 6, Rīga
UPDATE studios SET lat = 56.939300, lng = 24.128500 WHERE name LIKE '%Gold Group%';

-- 25. TonAuto — Brīvības gatve 116, Rīga
UPDATE studios SET lat = 56.969690, lng = 24.155170 WHERE name LIKE '%TonAuto%';
