Voronoi Diagram of the World with Capitals as Centroids

natural_earth_voronoi.md

Natural Earth Data

• 110m Admin 0 Countries
• 110m Populated Places
• 110m Graticules

natural_earth_voronoi.png

natural_earth_voronoi.sql

CREATE TABLE ne_voronoi AS (
	WITH ne_voronoi_polygons AS (
		SELECT (ST_Dump(ST_VoronoiPolygons(ST_collect(geom)))).geom AS geom
		FROM ne_110m_populated_places
		WHERE featurecla = 'Admin-0 capital'
	)
	SELECT ST_Intersection(a.geom, b.geom) AS geom
	FROM (
		SELECT ST_Union(wkb_geometry) AS geom 
		FROM ne_110m_admin_0_countries
	) a
	CROSS JOIN ne_voronoi_polygons b
);