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).
This will load the regions (admin1) from the latest shapefile.
$ foreman run rails carto:load_admin1
This results in 837 total regions imported.
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:
And here is admin3: