-
Notifications
You must be signed in to change notification settings - Fork 2
/
dbpedia_mappings.sql
executable file
·250 lines (249 loc) · 12.2 KB
/
dbpedia_mappings.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
INSERT INTO owl_sameas (gadm_level, gadm_id, uri) VALUES
(0,1,'http://dbpedia.org/resource/Aruba'),
(0,2,'http://dbpedia.org/resource/Afghanistan'),
(0,3,'http://dbpedia.org/resource/Angola'),
(0,4,'http://dbpedia.org/resource/Anguilla'),
(0,5,'http://dbpedia.org/resource/%C3%85land_Islands'),
(0,6,'http://dbpedia.org/resource/Albania'),
(0,7,'http://dbpedia.org/resource/Andorra'),
(0,8,'http://dbpedia.org/resource/Netherlands_Antilles'),
(0,9,'http://dbpedia.org/resource/United_Arab_Emirates'),
(0,10,'http://dbpedia.org/resource/Argentina'),
(0,11,'http://dbpedia.org/resource/Armenia'),
(0,12,'http://dbpedia.org/resource/American_Samoa'),
(0,13,'http://dbpedia.org/resource/Antarctica'),
(0,14,'http://dbpedia.org/resource/French_Southern_and_Antarctic_Lands'),
(0,15,'http://dbpedia.org/resource/Antigua_and_Barbuda'),
(0,16,'http://dbpedia.org/resource/Australia'),
(0,17,'http://dbpedia.org/resource/Austria'),
(0,18,'http://dbpedia.org/resource/Azerbaijan'),
(0,19,'http://dbpedia.org/resource/Burundi'),
(0,20,'http://dbpedia.org/resource/Belgium'),
(0,21,'http://dbpedia.org/resource/Benin'),
(0,22,'http://dbpedia.org/resource/Burkina_Faso'),
(0,23,'http://dbpedia.org/resource/Bangladesh'),
(0,24,'http://dbpedia.org/resource/Bulgaria'),
(0,25,'http://dbpedia.org/resource/Bahrain'),
(0,26,'http://dbpedia.org/resource/The_Bahamas'),
(0,27,'http://dbpedia.org/resource/Bosnia_and_Herzegovina'),
(0,28,'http://dbpedia.org/resource/Belarus'),
(0,29,'http://dbpedia.org/resource/Belize'),
(0,30,'http://dbpedia.org/resource/Bermuda'),
(0,31,'http://dbpedia.org/resource/Bolivia'),
(0,32,'http://dbpedia.org/resource/Brazil'),
(0,33,'http://dbpedia.org/resource/Barbados'),
(0,34,'http://dbpedia.org/resource/Brunei'),
(0,35,'http://dbpedia.org/resource/Bhutan'),
(0,36,'http://dbpedia.org/resource/Bouvet_Island'),
(0,37,'http://dbpedia.org/resource/Botswana'),
(0,38,'http://dbpedia.org/resource/Clipperton_Island'),
(0,39,'http://dbpedia.org/resource/Caspian_Sea'),
(0,40,'http://dbpedia.org/resource/Central_African_Republic'),
(0,41,'http://dbpedia.org/resource/Canada'),
(0,42,'http://dbpedia.org/resource/Cocos_%28Keeling%29_Islands'),
(0,43,'http://dbpedia.org/resource/Switzerland'),
(0,44,'http://dbpedia.org/resource/Chile'),
(0,45,'http://dbpedia.org/resource/People%27s_Republic_of_China'),
(0,46,'http://dbpedia.org/resource/C%C3%B4te_d%27Ivoire'),
(0,47,'http://dbpedia.org/resource/Cameroon'),
(0,48,'http://dbpedia.org/resource/Democratic_Republic_of_the_Congo'),
(0,49,'http://dbpedia.org/resource/Republic_of_the_Congo'),
(0,50,'http://dbpedia.org/resource/Cook_Islands'),
(0,51,'http://dbpedia.org/resource/Colombia'),
(0,52,'http://dbpedia.org/resource/Comoros'),
(0,53,'http://dbpedia.org/resource/Cape_Verde'),
(0,54,'http://dbpedia.org/resource/Costa_Rica'),
(0,55,'http://dbpedia.org/resource/Cuba'),
(0,56,'http://dbpedia.org/resource/Christmas_Island'),
(0,57,'http://dbpedia.org/resource/Cayman_Islands'),
(0,58,'http://dbpedia.org/resource/Cyprus'),
(0,59,'http://dbpedia.org/resource/Czech_Republic'),
(0,60,'http://dbpedia.org/resource/Germany'),
(0,61,'http://dbpedia.org/resource/Djibouti'),
(0,62,'http://dbpedia.org/resource/Dominica'),
(0,63,'http://dbpedia.org/resource/Denmark'),
(0,64,'http://dbpedia.org/resource/Dominican_Republic'),
(0,65,'http://dbpedia.org/resource/Algeria'),
(0,66,'http://dbpedia.org/resource/Ecuador'),
(0,67,'http://dbpedia.org/resource/Egypt'),
(0,68,'http://dbpedia.org/resource/Eritrea'),
(0,69,'http://dbpedia.org/resource/Western_Sahara'),
(0,70,'http://dbpedia.org/resource/Spain'),
(0,71,'http://dbpedia.org/resource/Estonia'),
(0,72,'http://dbpedia.org/resource/Ethiopia'),
(0,73,'http://dbpedia.org/resource/Finland'),
(0,74,'http://dbpedia.org/resource/Fiji'),
(0,75,'http://dbpedia.org/resource/Falkland_Islands'),
(0,76,'http://dbpedia.org/resource/France'),
(0,77,'http://dbpedia.org/resource/Faroe_Islands'),
(0,78,'http://dbpedia.org/resource/Federated_States_of_Micronesia'),
(0,79,'http://dbpedia.org/resource/Gabon'),
(0,80,'http://dbpedia.org/resource/United_Kingdom'),
(0,81,'http://dbpedia.org/resource/Georgia_%28country%29'),
(0,82,'http://dbpedia.org/resource/Guernsey'),
(0,83,'http://dbpedia.org/resource/Ghana'),
(0,84,'http://dbpedia.org/resource/Gibraltar'),
(0,85,'http://dbpedia.org/resource/Guinea'),
(0,86,'http://dbpedia.org/resource/Guadeloupe'),
(0,87,'http://dbpedia.org/resource/The_Gambia'),
(0,88,'http://dbpedia.org/resource/Guinea-Bissau'),
(0,89,'http://dbpedia.org/resource/Equatorial_Guinea'),
(0,90,'http://dbpedia.org/resource/Greece'),
(0,91,'http://dbpedia.org/resource/Grenada'),
(0,92,'http://dbpedia.org/resource/Greenland'),
(0,93,'http://dbpedia.org/resource/Guatemala'),
(0,94,'http://dbpedia.org/resource/French_Guiana'),
(0,95,'http://dbpedia.org/resource/Guam'),
(0,96,'http://dbpedia.org/resource/Guyana'),
(0,97,'http://dbpedia.org/resource/Hong_Kong'),
(0,98,'http://dbpedia.org/resource/Heard_Island_and_McDonald_Islands'),
(0,99,'http://dbpedia.org/resource/Honduras'),
(0,100,'http://dbpedia.org/resource/Croatia'),
(0,101,'http://dbpedia.org/resource/Haiti'),
(0,102,'http://dbpedia.org/resource/Hungary'),
(0,103,'http://dbpedia.org/resource/Indonesia'),
(0,104,'http://dbpedia.org/resource/Isle_of_Man'),
(0,105,'http://dbpedia.org/resource/India'),
(0,106,'http://dbpedia.org/resource/British_Indian_Ocean_Territory'),
(0,107,'http://dbpedia.org/resource/Republic_of_Ireland'),
(0,108,'http://dbpedia.org/resource/Iran'),
(0,109,'http://dbpedia.org/resource/Iraq'),
(0,110,'http://dbpedia.org/resource/Iceland'),
(0,111,'http://dbpedia.org/resource/Israel'),
(0,112,'http://dbpedia.org/resource/Italy'),
(0,113,'http://dbpedia.org/resource/Jamaica'),
(0,114,'http://dbpedia.org/resource/Jersey'),
(0,115,'http://dbpedia.org/resource/Jordan'),
(0,116,'http://dbpedia.org/resource/Japan'),
(0,117,'http://dbpedia.org/resource/Kosovo'),
(0,118,'http://dbpedia.org/resource/Kazakhstan'),
(0,119,'http://dbpedia.org/resource/Kenya'),
(0,120,'http://dbpedia.org/resource/Kyrgyzstan'),
(0,121,'http://dbpedia.org/resource/Cambodia'),
(0,122,'http://dbpedia.org/resource/Kiribati'),
(0,123,'http://dbpedia.org/resource/Saint_Kitts_and_Nevis'),
(0,124,'http://dbpedia.org/resource/South_Korea'),
(0,125,'http://dbpedia.org/resource/Kuwait'),
(0,126,'http://dbpedia.org/resource/Laos'),
(0,127,'http://dbpedia.org/resource/Lebanon'),
(0,128,'http://dbpedia.org/resource/Liberia'),
(0,129,'http://dbpedia.org/resource/Libya'),
(0,130,'http://dbpedia.org/resource/Saint_Lucia'),
(0,131,'http://dbpedia.org/resource/Liechtenstein'),
(0,132,'http://dbpedia.org/resource/Sri_Lanka'),
(0,133,'http://dbpedia.org/resource/Lesotho'),
(0,134,'http://dbpedia.org/resource/Lithuania'),
(0,135,'http://dbpedia.org/resource/Luxembourg'),
(0,136,'http://dbpedia.org/resource/Latvia'),
(0,137,'http://dbpedia.org/resource/Macau'),
(0,138,'http://dbpedia.org/resource/Morocco'),
(0,139,'http://dbpedia.org/resource/Monaco'),
(0,140,'http://dbpedia.org/resource/Moldova'),
(0,141,'http://dbpedia.org/resource/Madagascar'),
(0,142,'http://dbpedia.org/resource/Maldives'),
(0,143,'http://dbpedia.org/resource/Mexico'),
(0,144,'http://dbpedia.org/resource/Marshall_Islands'),
(0,145,'http://dbpedia.org/resource/Republic_of_Macedonia'),
(0,146,'http://dbpedia.org/resource/Mali'),
(0,147,'http://dbpedia.org/resource/Malta'),
(0,148,'http://dbpedia.org/resource/Burma'),
(0,149,'http://dbpedia.org/resource/Montenegro'),
(0,150,'http://dbpedia.org/resource/Mongolia'),
(0,151,'http://dbpedia.org/resource/Northern_Mariana_Islands'),
(0,152,'http://dbpedia.org/resource/Mozambique'),
(0,153,'http://dbpedia.org/resource/Mauritania'),
(0,154,'http://dbpedia.org/resource/Montserrat'),
(0,155,'http://dbpedia.org/resource/Martinique'),
(0,156,'http://dbpedia.org/resource/Mauritius'),
(0,157,'http://dbpedia.org/resource/Malawi'),
(0,158,'http://dbpedia.org/resource/Malaysia'),
(0,159,'http://dbpedia.org/resource/Mayotte'),
(0,160,'http://dbpedia.org/resource/Namibia'),
(0,161,'http://dbpedia.org/resource/New_Caledonia'),
(0,162,'http://dbpedia.org/resource/Niger'),
(0,163,'http://dbpedia.org/resource/Norfolk_Island'),
(0,164,'http://dbpedia.org/resource/Nigeria'),
(0,165,'http://dbpedia.org/resource/Nicaragua'),
(0,166,'http://dbpedia.org/resource/Niue'),
(0,167,'http://dbpedia.org/resource/Netherlands'),
(0,168,'http://dbpedia.org/resource/Norway'),
(0,169,'http://dbpedia.org/resource/Nepal'),
(0,170,'http://dbpedia.org/resource/Nauru'),
(0,171,'http://dbpedia.org/resource/New_Zealand'),
(0,172,'http://dbpedia.org/resource/Oman'),
(0,173,'http://dbpedia.org/resource/Pakistan'),
(0,174,'http://dbpedia.org/resource/Panama'),
(0,175,'http://dbpedia.org/resource/Pitcairn_Islands'),
(0,176,'http://dbpedia.org/resource/Peru'),
(0,177,'http://dbpedia.org/resource/Philippines'),
(0,178,'http://dbpedia.org/resource/Palau'),
(0,179,'http://dbpedia.org/resource/Papua_New_Guinea'),
(0,180,'http://dbpedia.org/resource/Poland'),
(0,181,'http://dbpedia.org/resource/Puerto_Rico'),
(0,182,'http://dbpedia.org/resource/North_Korea'),
(0,183,'http://dbpedia.org/resource/Portugal'),
(0,184,'http://dbpedia.org/resource/Paraguay'),
(0,185,'http://dbpedia.org/resource/Palestina'),
(0,186,'http://dbpedia.org/resource/French_Polynesia'),
(0,187,'http://dbpedia.org/resource/Qatar'),
(0,188,'http://dbpedia.org/resource/R%C3%A9union'),
(0,189,'http://dbpedia.org/resource/Romania'),
(0,190,'http://dbpedia.org/resource/Russia'),
(0,191,'http://dbpedia.org/resource/Rwanda'),
(0,192,'http://dbpedia.org/resource/Saudi_Arabia'),
(0,193,'http://dbpedia.org/resource/Sudan'),
(0,194,'http://dbpedia.org/resource/Senegal'),
(0,195,'http://dbpedia.org/resource/Singapore'),
(0,196,'http://dbpedia.org/resource/South_Georgia_and_the_South_Sandwich_Islands'),
(0,197,'http://dbpedia.org/resource/Saint_Helena'),
(0,198,'http://dbpedia.org/resource/Svalbard_and_Jan_Mayen'),
(0,199,'http://dbpedia.org/resource/Solomon_Islands'),
(0,200,'http://dbpedia.org/resource/Sierra_Leone'),
(0,201,'http://dbpedia.org/resource/El_Salvador'),
(0,202,'http://dbpedia.org/resource/San_Marino'),
(0,203,'http://dbpedia.org/resource/Somalia'),
(0,204,'http://dbpedia.org/resource/Spratly_Islands'),
(0,205,'http://dbpedia.org/resource/Saint_Pierre_and_Miquelon'),
(0,206,'http://dbpedia.org/resource/Serbia'),
(0,207,'http://dbpedia.org/resource/S%C3%A3o_Tom%C3%A9_and_Pr%C3%ADncipe'),
(0,208,'http://dbpedia.org/resource/Suriname'),
(0,209,'http://dbpedia.org/resource/Slovakia'),
(0,210,'http://dbpedia.org/resource/Slovenia'),
(0,211,'http://dbpedia.org/resource/Sweden'),
(0,212,'http://dbpedia.org/resource/Swaziland'),
(0,213,'http://dbpedia.org/resource/Seychelles'),
(0,214,'http://dbpedia.org/resource/Syria'),
(0,215,'http://dbpedia.org/resource/Turks_and_Caicos_Islands'),
(0,216,'http://dbpedia.org/resource/Chad'),
(0,217,'http://dbpedia.org/resource/Togo'),
(0,218,'http://dbpedia.org/resource/Thailand'),
(0,219,'http://dbpedia.org/resource/Tajikistan'),
(0,220,'http://dbpedia.org/resource/Tokelau'),
(0,221,'http://dbpedia.org/resource/Turkmenistan'),
(0,222,'http://dbpedia.org/resource/East_Timor'),
(0,223,'http://dbpedia.org/resource/Tonga'),
(0,224,'http://dbpedia.org/resource/Trinidad_and_Tobago'),
(0,225,'http://dbpedia.org/resource/Tunisia'),
(0,226,'http://dbpedia.org/resource/Turkey'),
(0,227,'http://dbpedia.org/resource/Tuvalu'),
(0,228,'http://dbpedia.org/resource/Republic_of_China'),
(0,229,'http://dbpedia.org/resource/Tanzania'),
(0,230,'http://dbpedia.org/resource/Uganda'),
(0,231,'http://dbpedia.org/resource/Ukraine'),
(0,232,'http://dbpedia.org/resource/United_States_Minor_Outlying_Islands'),
(0,233,'http://dbpedia.org/resource/Uruguay'),
(0,234,'http://dbpedia.org/resource/United_States'),
(0,235,'http://dbpedia.org/resource/Uzbekistan'),
(0,236,'http://dbpedia.org/resource/Vatican_City'),
(0,237,'http://dbpedia.org/resource/Saint_Vincent_and_the_Grenadines'),
(0,238,'http://dbpedia.org/resource/Venezuela'),
(0,239,'http://dbpedia.org/resource/British_Virgin_Islands'),
(0,240,'http://dbpedia.org/resource/United_States_Virgin_Islands'),
(0,241,'http://dbpedia.org/resource/Vietnam'),
(0,242,'http://dbpedia.org/resource/Vanuatu'),
(0,243,'http://dbpedia.org/resource/Wallis_and_Futuna'),
(0,244,'http://dbpedia.org/resource/Samoa'),
(0,245,'http://dbpedia.org/resource/Yemen'),
(0,246,'http://dbpedia.org/resource/South_Africa'),
(0,247,'http://dbpedia.org/resource/Zambia'),
(0,248,'http://dbpedia.org/resource/Zimbabwe');