1
|
BEGIN;
|
2
|
|
3
|
--
|
4
|
-- insert additional custom name-scrub mappings
|
5
|
--
|
6
|
|
7
|
-- add some custom stateprovince alternate names that we need
|
8
|
INSERT INTO alt_stateprovince
|
9
|
(country, stateprovince, alternatename)
|
10
|
VALUES
|
11
|
('Canada', 'British Columbia', 'B.C.')
|
12
|
, ('Canada', 'Newfoundland and Labrador', 'Newfoundland & Labrador')
|
13
|
, ('Canada', 'Newfoundland and Labrador', 'New Foundland And Labrador')
|
14
|
, ('Canada', 'Newfoundland and Labrador', 'Labrador & Newfoundland')
|
15
|
, ('Canada', 'Northwest Territories', 'North West Territories')
|
16
|
, ('Canada', 'Northwest Territories', 'Northwest Territorie')
|
17
|
, ('Canada', 'Northwest Territories', 'NWT')
|
18
|
, ('Canada', 'Québec', 'Quebéc')
|
19
|
, ('Canada', 'Québec', 'Pq')
|
20
|
, ('Canada', 'Québec', 'PQ')
|
21
|
, ('United States', 'Hawaii', 'Hawai`i')
|
22
|
, ('United States', 'North Carolina', 'N. Carolina')
|
23
|
, ('United States', 'North Dakota', 'N. Dakota')
|
24
|
, ('United States', 'South Dakota', 'S. Dakota')
|
25
|
, ('Kenya', 'Coast Province', 'Coast')
|
26
|
, ('Mexico', 'Estado de Baja California', 'Baja California Norte')
|
27
|
, ('Mexico', 'Estado de Baja California', 'Baja California (Norte)')
|
28
|
, ('Mexico', 'Estado de Baja California', 'Baja California, Norte de')
|
29
|
, ('Mexico', 'Estado de Baja California', 'Baja California (state)')
|
30
|
, ('Mexico', 'Estado de Baja California Sur', 'Baja California, Sur de')
|
31
|
, ('Mexico', 'Estado de Baja California Sur', 'Baja California Sur (state)')
|
32
|
, ('Mexico', 'Estado de Baja California Sur', 'Baja Califronia')
|
33
|
, ('Mexico', 'Estado de Baja California Sur', 'Baja Cal. Sur')
|
34
|
, ('Ecuador', 'Provincia de Sucumbíos', 'Sucumbíos')
|
35
|
;
|
36
|
|
37
|
-- additions for mapping to gadm2 level 1 units
|
38
|
-- - Los Lagos -> Los Rios is imperfect but needed for gadm
|
39
|
-- - Orellana -> Napo is imperfect (wrong??) but needed for gadm
|
40
|
-- - Mapping both Concelho de Macau and Concelho das Ilhas to Ilhas
|
41
|
-- - Nassa seems to be a gadm misspelling? (Niassa)
|
42
|
-- not addressed:
|
43
|
-- - Bahamas: unmapped gadm level1 entities may be obsolete?
|
44
|
-- - French Guiana has arrondissements as adm0 in gadm, low level?
|
45
|
-- - French Polynesia has no adm1 in gadm
|
46
|
-- - Madagascar: Sava is (was?) inside gadm's Antsiranana province
|
47
|
-- - Philippines: GN has 17 regions at level1, gadm has 82 provinces
|
48
|
-- - Sri Lanka: GN ADM2 matches gadm level1; bien data side with GN
|
49
|
-- - Venezuela: Dependencias Federales don't seem to be in GADM
|
50
|
-- - Vietnam: GN ADM1 matches gadm level2; bien data side with GN?
|
51
|
INSERT INTO alt_stateprovince
|
52
|
(country, stateprovince, alternatename)
|
53
|
VALUES
|
54
|
('Cambodia', 'Khétt Siĕm Réab', 'Siemréab')
|
55
|
, ('Chile', 'Región del Biobío', 'Bío-Bío')
|
56
|
, ('Chile', 'Región del Libertador General Bernardo O’Higgins', 'Libertador General Bernardo O''Higgins')
|
57
|
, ('Chile', 'Región de Los Ríos', 'Los Lagos')
|
58
|
, ('Chile', 'Providencia y Santa Catalina, Departamento de Archipiélago de San Andrés', 'San Andrés y Providencia')
|
59
|
, ('Dominican Republic', 'Provincia de Baoruco', 'Bahoruco')
|
60
|
, ('Ecuador', 'Provincia de Morona Santiago', 'Morona Santiago')
|
61
|
, ('Ecuador', 'Provincia de Napo', 'Orellana')
|
62
|
, ('Ecuador', 'Provincia de Zamora Chinchipe', 'Zamora Chinchipe')
|
63
|
, ('Gabon', 'Province du Woleu-Ntem', 'Wouleu-Ntem')
|
64
|
, ('Ghana', 'Brong-Ahafo Region', 'Brong Ahafo')
|
65
|
, ('Guatemala', 'Departamento de Quetzaltenango', 'Quezaltenango')
|
66
|
, ('Haiti', 'Département de l''Artibonite', 'L''Artibonite')
|
67
|
, ('Liberia', 'Grand Bassa County', 'GrandBassa')
|
68
|
, ('Liberia', 'Grand Gedeh County', 'GrandGedeh')
|
69
|
, ('Macao', 'Concelho de Macau', 'Ilhas')
|
70
|
, ('Mozambique', 'Niassa Province', 'Nassa')
|
71
|
, ('Norway', 'Østfold fylke', 'Ãstfold')
|
72
|
, ('Peru', 'Región de Huánuco', 'Huánuco')
|
73
|
, ('Puerto Rico', 'Guánica Municipio', 'Guánica')
|
74
|
, ('Puerto Rico', 'Loíza Municipio', 'Loíza')
|
75
|
, ('Puerto Rico', 'Manatí Municipio', 'Manatí')
|
76
|
, ('Puerto Rico', 'Peñuelas Municipio', 'Peñuelas')
|
77
|
, ('Puerto Rico', 'Río Grande Municipio', 'Río Grande')
|
78
|
, ('Puerto Rico', 'San Germán Municipio', 'San Germán')
|
79
|
, ('Puerto Rico', 'San Sebastián Municipio', 'San Sebastián')
|
80
|
, ('Russia', 'Karachayevo-Cherkesskaya Respublika', 'Karachay-Cherkess')
|
81
|
, ('Syria', 'Muḩāfaz̧at al Lādhiqīyah', 'Lattakia')
|
82
|
, ('Togo', 'Région Centrale', 'Centre')
|
83
|
;
|
84
|
|
85
|
COMMIT;
|
86
|
|
87
|
|