Project

General

Profile

1 11495 psarando
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