DROP TABLE centroid_capital_cities;
CREATE TABLE centroid_capital_cities AS 
SELECT name, cc, region, iso_alpha2, iso_alpha3, iso_num, tld, wc.name as country_name, ST_Centroid(wc.geom) geom FROM world_countries_work wc;

DROP TABLE center_circle_capital_cities;
CREATE TABLE center_circle_capital_cities AS
SELECT name, cc, region, iso_alpha2, iso_alpha3, iso_num, tld, wc.name as country_name, ST_Centroid(wc.geom) geom FROM world_countries_work wc;
