Create the Cartographies table

CREATE TABLE dbo.Cartographies (
	id int NOT NULL IDENTITY(1,1),
	admin0 nvarchar(50) NULL,
	admin0_id int NULL,
	admin0_iso2 char(2) NULL,
	admin0_iso3 char(3) NULL,
	continent nvarchar(50) NULL,
	region nvarchar(50) NULL,
	who_region nvarchar(50) NULL,
	admin1 nvarchar(50) NULL,
	admin1_id int NULL,
	admin2 nvarchar(50) NULL,
	admin2_id int NULL,
	admin2_alias nvarchar(50) NULL,
	admin3 nvarchar(50) NULL,
	admin3_id int NULL,
	admin3_alias nvarchar(50) NULL,
	iu_id nvarchar(20) NULL,
	old_iu_id int NULL,
	admin_level char(6) NULL,
	update_type nvarchar(20) NULL,
	created_at datetime NULL,
	updated_at datetime NULL,
	parent_iu_id nvarchar(20) NULL,
	parent_iu_id_2 nvarchar(20) NULL,
	active int NULL,
	population int NULL,
	geojson nvarchar(max) NULL
);

Import Countries

This will load the countries (admin0) from the latest shapefile.

$ foreman run rails carto:load_admin0

This results in 53 total countries imported (AFRO and EMRO).

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1d820667-de66-4782-81d3-496b3572183e/untitled

Import Regions

This will load the regions (admin1) from the latest shapefile.

$ foreman run rails carto:load_admin1

This results in 837 total regions imported.

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/35aceb48-a9f4-45af-a2ca-55f711f8b638/untitled

Import IUs

This will load the IUs (admin2 or admin3) from the latest shapefile.

$ foreman run rails carto:load_ius

This results in 4,048 admin2 and 1,666 admin3 imported. This is 5,714 total IUs.

Here is admin2:

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/7bf80c88-15a7-49ae-8ce4-b19366fb7cd2/untitled

And here is admin3:

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/52a559cc-cf32-4ad9-84b5-0943b385d213/untitled