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
);
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
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
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