njanakiev · August 4, 2020 08:58
diff --git a/natural_earth_voronoi.md b/natural_earth_voronoi.md
diff --git a/natural_earth_voronoi.png b/natural_earth_voronoi.png
diff --git a/natural_earth_voronoi.sql b/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
 );
	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
	);