ISO | Country | Street+ | Standard | |
---|---|---|---|---|
CA | Canada | $ 2957953,495 | $ 1493951,795 | |
MX | Mexico | $ 3959954,495 | $ 49129599 | |
US | United States | $ 1954952,495 | $ 2979349 |
ISO | Country | Street+ | Standard | |
---|---|---|---|---|
AD | Andorra | $ 2979349 | Free | |
AT | Austria | $ 1954952,495 | $ 49129599 | |
BE | BelgiumFR+NL | $ 1954952,495 | $ 3999499 | |
DK | Denmark | $ 1954952,495 | $ 3999499 | |
FI | FinlandFI+SV | $ 1954952,495 | $ 3999499 | |
FR | France | $ 2957953,495 | $ 49129599 | |
DE | Germany | $ 5951,4956,995 | $ 49129599 | |
GR | GreeceEN+EL | $ 3999499 | ||
IS | Iceland | $ 49129599 | $ 1949249 | |
IE | IrelandEN+GA | $ 2957953,495 | $ 3999499 | |
IT | Italy | $ 3959954,495 | $ 49129599 | |
LI | Liechtenstein | $ 2979349 | Free | |
LU | Luxembourg | $ 59149699 | $ 3999499 | |
MT | Malta | $ 79199995 | $ 3999499 | |
MC | Monaco | $ 1949249 | Free | |
NL | Netherlands | $ 1954952,495 | $ 992491,295 | |
NO | Norway | $ 1954952,495 | $ 3999499 | |
PT | Portugal | $ 1954952,495 | $ 79199995 | |
SM | San Marino | $ 2979349 | Free | |
ES | Spain | $ 2957953,495 | $ 59149699 | |
SE | Sweden | $ 4951,2955,995 | $ 49129599 | |
CH | SwitzerlandDE+FR+IT | $ 1954952,495 | $ 3999499 | |
GB | United Kingdom | $ 2957953,495 | $ 992491,295 | |
VA | Vatican | Free |
ISO | Country | Street+ | Standard | |
---|---|---|---|---|
AL | Albania | $ 3999499 | ||
AM | ArmeniaEN+HY | $ 3999499 | ||
AZ | AzerbaijanEN+AZ | $ 3999499 | ||
BY | BelarusEN+RU | $ 59149699 | ||
BA | Bosnia-Herzegovina | $ 2979349 | ||
BG | BulgariaEN+BG | $ 3999499 | ||
HR | Croatia | $ 49129599 | ||
CY | CyprusEN+EL | $ 3999499 | ||
CZ | Czechia | $ 1954952,495 | $ 49129599 | |
EE | Estonia | $ 1954952,495 | $ 3999499 | |
GE | Georgia | $ 49129599 | ||
HU | Hungary | $ 3999499 | ||
LV | Latvia | $ 49129599 | ||
LT | Lithuania | $ 3959954,495 | $ 49129599 | |
MK | MacedoniaEN+MK | $ 3999499 | ||
MD | Moldova | $ 3999499 | ||
ME | Montenegro | $ 3999499 | ||
PL | Poland | $ 1954952,495 | $ 59149699 | |
RO | Romania | $ 992491,295 | $ 49129599 | |
RU | RussiaEN+RU | $ 59149699 | ||
RS | Serbia | $ 3999499 | ||
SK | Slovakia | $ 3999499 | ||
SI | Slovenia | $ 49129599 | ||
UA | UkraineEN+UK | $ 59149699 |
ISO | Country | Street+ | Standard | |
---|---|---|---|---|
AF | Afghanistan | $ 59149699 | ||
BD | Bangladesh | $ 3999499 | ||
BT | Bhutan | $ 1949249 | ||
BN | Brunei | $ 2979349 | ||
KH | Cambodia | $ 59149699 | ||
CN | ChinaEN+ZH | $ 1954952,495 | ||
IN | India | $ 892291,095 | ||
ID | Indonesia | $ 892291,095 | ||
JP | JapanEN+JA+KT | $ 892291,095 | ||
KZ | KazakhstanEN+RU+KK | $ 5951,4956,995 | $ 59149699 | |
KG | KyrgyzstanEN+RU | $ 2979349 | ||
LA | Laos | $ 49129599 | ||
MY | Malaysia | $ 1954952,495 | $ 3999499 | |
MV | Maldives | $ 3999499 | ||
MN | MongoliaEN+MN | $ 3999499 | ||
MM | Myanmar (Burma) | $ 49129599 | ||
NP | Nepal | $ 2979349 | ||
KP | North Korea | $ 2979349 | ||
PK | Pakistan | $ 49129599 | ||
PH | Philippines | $ 59149699 | ||
SG | Singapore | $ 1954952,495 | $ 992491,295 | |
KR | South KoreaEN+KO | $ 1954952,495 | $ 59149699 | |
LK | Sri Lanka | $ 3999499 | ||
TJ | Tajikistan | $ 3999499 | ||
TH | ThailandEN+TH | $ 49129599 | ||
TL | Timor-Leste | $ 3999499 | ||
TM | Turkmenistan | Free | ||
UZ | UzbekistanEN+RU | $ 3999499 | ||
VN | Vietnam | $ 69169849 |
ISO | Country | Street+ | Standard | |
---|---|---|---|---|
AG | Antigua & Barbuda | Free | ||
AR | Argentina | $ 7951,9958,995 | $ 2957953,495 | |
BS | Bahamas | $ 1949249 | ||
BB | Barbados | $ 3999499 | ||
BZ | Belize | $ 2979349 | ||
BO | Bolivia | $ 49129599 | ||
BR | Brazil | $ 4951,2955,995 | $ 1493951,795 | |
CL | Chile | $ 2957953,495 | $ 2979349 | |
CO | Colombia | $ 59149699 | ||
CR | Costa Rica | $ 49129599 | ||
CU | Cuba | $ 2979349 | ||
DM | Dominica | Free | ||
DO | Dominican Republic | $ 2979349 | ||
EC | Ecuador | $ 1954952,495 | $ 3999499 | |
SV | El Salvador | $ 2979349 | ||
GD | Grenada | Free | ||
GT | Guatemala | $ 2979349 | ||
GY | Guyana | $ 2979349 | ||
HT | Haiti | $ 49129599 | ||
HN | Honduras | $ 3999499 | ||
JM | Jamaica | $ 1949249 | ||
NI | Nicaragua | $ 3999499 | ||
PA | Panama | $ 49129599 | ||
PY | Paraguay | $ 49129599 | ||
PE | Peru | $ 49129599 | ||
KN | Saint Kitts and Nevis | Free | ||
LC | Saint Lucia | $ 2979349 | ||
VC | St Vinc. & Grenadines | Free | ||
SR | Suriname | $ 2979349 | ||
TT | Trinidad & Tobago | $ 1949249 | ||
UY | Uruguay | $ 2979349 | ||
VE | Venezuela | $ 59149699 |
ISO | Country | Street+ | Standard | |
---|---|---|---|---|
BH | Bahrain | $ 2979349 | ||
IR | IranEN+AR | $ 2979349 | ||
IQ | Iraq | $ 49129599 | ||
IL | IsraelEN+HE | $ 3959954,495 | $ 992491,295 | |
JO | JordanEN+AR | $ 2979349 | ||
KW | KuwaitEN+AR | $ 69169849 | ||
LB | LebanonEN+AR | $ 49129599 | ||
OM | OmanEN+AR | $ 3999499 | ||
PS | PalestineEN+AR | $ 2979349 | ||
QA | QatarEN+AR | $ 2957953,495 | $ 2979349 | |
SA | Saudi ArabiaEN+AR | $ 49129599 | ||
SY | SyriaEN+AR | $ 49129599 | ||
TR | Turkey | $ 59149699 | ||
AE | United Arab Emirates | $ 3999499 | ||
YE | YemenEN+AR | $ 49129599 |
ISO | Country | Street+ | Standard | |
---|---|---|---|---|
DZ | Algeria | $ 3999499 | ||
AO | Angola | $ 2979349 | ||
BJ | Benin | $ 2979349 | ||
BW | Botswana | $ 2979349 | ||
BF | Burkina Faso | $ 3999499 | ||
BI | Burundi | $ 49129599 | ||
CM | Cameroon | $ 49129599 | ||
CV | Cape Verde | $ 2979349 | ||
CF | Central African Rep. | $ 49129599 | ||
TD | Chad | $ 49129599 | ||
KM | Comoros | $ 1949249 | ||
CG | Congo-Brazzaville | $ 49129599 | ||
CD | Congo D.R. | $ 49129599 | ||
CI | Côte d'Ivoire | $ 3999499 | ||
DJ | Djibouti | $ 2979349 | ||
EG | EgyptEN+AR | $ 49129599 | ||
GQ | Equatorial Guinea | $ 49129599 | ||
ER | Eritrea | $ 3999499 | ||
ET | Ethiopia | $ 49129599 | ||
GA | Gabon | $ 49129599 | ||
GM | Gambia | $ 3999499 | ||
GH | Ghana | $ 49129599 | ||
GN | Guinea | $ 49129599 | ||
GW | Guinea-Bissau | $ 49129599 | ||
KE | Kenya | $ 49129599 | ||
LS | Lesotho | $ 3999499 | ||
LR | Liberia | $ 49129599 | ||
LY | Libya | $ 3999499 | ||
MG | Madagascar | $ 49129599 | ||
MW | Malawi | $ 2979349 | ||
ML | Mali | $ 49129599 | ||
MR | Mauritania | $ 49129599 | ||
MU | Mauritius | $ 2979349 | ||
MA | Morocco | $ 3999499 | ||
MZ | Mozambique | $ 49129599 | ||
NA | Namibia | $ 3999499 | ||
NE | Niger | $ 49129599 | ||
NG | Nigeria | $ 49129599 | ||
RW | Rwanda | $ 49129599 | ||
ST | São Tomé & Príncipe | Free | ||
SN | Senegal | $ 49129599 | ||
SC | Seychelles | Free | ||
SL | Sierra Leone | $ 3999499 | ||
SO | Somalia | $ 49129599 | ||
ZA | South AfricaEN+AF | $ 49129599 | ||
SS | South Sudan | $ 49129599 | ||
SD | Sudan | $ 49129599 | ||
SZ | Swaziland | Free | ||
TZ | Tanzania | $ 49129599 | ||
TG | Togo | $ 49129599 | ||
TN | Tunisia | $ 3999499 | ||
UG | Uganda | $ 49129599 | ||
EH | Western Sahara | $ 3999499 | ||
ZM | Zambia | $ 49129599 | ||
ZW | Zimbabwe | $ 2979349 |
ISO | Country | Street+ | Standard | |
---|---|---|---|---|
AU | Australia | $ 1954952,495 | $ 3999499 | |
FJ | Fiji | $ 3999499 | ||
KI | Kiribati | $ 1949249 | ||
NR | Nauru | Free | ||
NZ | New Zealand | $ 992491,295 | $ 3999499 | |
PG | Papua New Guinea | $ 2979349 | ||
WS | Samoa | $ 1949249 | ||
SB | Solomon Islands | $ 1949249 | ||
TO | Tonga | $ 1949249 | ||
TV | Tuvalu | Free | ||
VU | Vanuatu | Free |
Name | Standard | |
---|---|---|
North America | $ 1954952,495 | |
European Union | $ 9952,4959,995 | |
Western Europe | $ 8952,1958,995 | |
Eastern Europe | $ 8952,1958,995 | |
Asia | $ 9952,4959,995 | |
South & Central America | $ 9952,4959,995 | |
Middle East | $ 2957953,495 | |
Africa | $ 1,2953,19512,995 | |
Oceania-Pacific | $ 992491,295 | |
All countries | $ 1,9954,99519,995 |
GeoPC_XX_Regions.csv | Administrative regions |
GeoPC_XX_Places.csv | Localities |
GeoPC_XX_Streets.csv | Streets (available with our Street+ product range) |
GeoPC_XX_Business.csv | Business, administrative codes, PO Boxes (for some countries) |
GeoPC_XX_Regions.asc | Administrative regions |
GeoPC_XX_Places.asc | Localities |
GeoPC_XX_Streets.asc | Streets (available with our Street+ product range) |
GeoPC_XX_Business.asc | Business, administrative codes, PO Boxes (for some countries) |
GeoPC_XX_Regions.dat | Administrative regions |
GeoPC_XX_Places.dat | Localities |
GeoPC_XX_Streets.dat | Streets (available with our Street+ product range) |
GeoPC_XX_Business.dat | Business, administrative codes, PO Boxes (for some countries) |
GeoPC_XX.shp | Geographic points table |
GeoPC_XX.dbf | Attributes table (in dBase IV format) |
GeoPC_XX.shx | Positional index |
GeoPC_XX.prj | Projection format |
GeoPC_XX_Places.kml | Geographic points and attributes |
GeoPC_XX_Streets.kml | Street geographic points (available with our Street+ product range) |
GeoPC_XX_Places.json | Geographic points and attributes |
GeoPC_XX_Streets.json | Street geographic points (available with our Street+ product range) |
GeoPC_XX_Places.gml | Geographic points and attributes |
GeoPC_XX_Streets.gml | Street geographic points (available with our Street+ product range) |
Field name | Field type | Description | STANDARD | STREET+ |
---|---|---|---|---|
ISO | Char(2) | ISO 3166-1 Country code | ![]() | ![]() |
Country | Char(50) | Country name | ![]() | ![]() |
Language | Char(2) | Language code | ![]() | ![]() |
Level | Integer | Administrative level | ![]() | ![]() |
Type | Char(50) | Type of administrative division | ![]() | ![]() |
Name | Char(80) | Administrative division name | ![]() | ![]() |
Region1 | Char(80) | Administrative division level 1 | ![]() | ![]() |
Region2 | Char(80) | Administrative division level 2 | ![]() | ![]() |
Region3 | Char(80) | Administrative division level 3 | ![]() | ![]() |
Region4 | Char(80) | Administrative division level 4 | ![]() | ![]() |
ISO2 | Char(10) | ISO 3166-2 Region code | ![]() | ![]() |
FIPS | Char(10) | NGA Geopolitical code (formerly FIPS PUB 10-4) | ![]() | ![]() |
NUTS | Char(10) | European statistical division code | ![]() | ![]() |
HASC | Char(10) | Hierarchical administrative subdivision code | ![]() | ![]() |
STAT | Char(20) | National statistics/census code | ![]() | ![]() |
Field name | Field type | Description | STANDARD | STREET+ |
---|---|---|---|---|
ISO | Char(2) | ISO 3166-1 Country code | ![]() | ![]() |
Country | Char(50) | Country name | ![]() | ![]() |
Language | Char(2) | Language code | ![]() | ![]() |
ID | Integer | Record identifier | ![]() | ![]() |
Region1 | Char(80) | Administrative division level 1 | ![]() | ![]() |
Region2 | Char(80) | Administrative division level 2 | ![]() | ![]() |
Region3 | Char(80) | Administrative division level 3 | ![]() | ![]() |
Region4 | Char(80) | Administrative division level 4 | ![]() | ![]() |
Locality | Char(80) | Locality name | ![]() | ![]() |
Postcode | Char(15) | ZIP / Postal code | ![]() | ![]() |
Suburb | Char(80) | Locality subdivision | ![]() | ![]() |
Latitude | Double | Place latitude (WGS84 coordinates) | ![]() | ![]() |
Longitude | Double | Place longitude (WGS84 coordinates) | ![]() | ![]() |
Elevation | Integer | Elevation in meters | ![]() | ![]() |
ISO2 | Char(10) | ISO 3166-2 Region code | ![]() | ![]() |
FIPS | Char(10) | NGA Geopolitical code (formerly FIPS PUB 10-4) | ![]() | ![]() |
NUTS | Char(12) | European statistical division code | ![]() | ![]() |
HASC | Char(12) | Hierarchical administrative subdivision code | ![]() | ![]() |
STAT | Char(20) | National statistics/census code | ![]() | ![]() |
Timezone | Char(30) | Time zone name (Olson) | ![]() | ![]() |
UTC | Char(10) | Coordinated Universal Time | ![]() | ![]() |
DST | Char(10) | Daylight saving time | ![]() | ![]() |
Field name | Field type | Description | STANDARD | STREET+ |
---|---|---|---|---|
ISO | Char(2) | ISO 3166-1 Country code | ![]() | |
Country | Char(50) | Country name | ![]() | |
Language | Char(2) | Language code | ![]() | |
ID | Integer | Record identifier | ![]() | |
Region1 | Char(80) | Administrative division level 1 | ![]() | |
Region2 | Char(80) | Administrative division level 2 | ![]() | |
Region3 | Char(80) | Administrative division level 3 | ![]() | |
Region4 | Char(80) | Administrative division level 4 | ![]() | |
Locality | Char(80) | Locality name | ![]() | |
Postcode | Char(15) | ZIP / Postal code | ![]() | |
Suburb | Char(80) | Locality subdivision | ![]() | |
Street | Char(100) | Street name | ![]() | |
Range | Char(50) | Street numbers range | ![]() | |
Building | Char(80) | Building name | ![]() | |
Latitude | Double | Street latitude (WGS84 coordinates) | ![]() | |
Longitude | Double | Street longitude (WGS84 coordinates) | ![]() | |
Elevation | Integer | Elevation in meters | ![]() | |
ISO2 | Char(10) | ISO 3166-2 Region code | ![]() | |
FIPS | Char(10) | NGA Geopolitical code (formerly FIPS PUB 10-4) | ![]() | |
NUTS | Char(12) | European statistical division code | ![]() | |
HASC | Char(12) | Hierarchical administrative subdivision code | ![]() | |
STAT | Char(20) | National statistics/census code | ![]() | |
Timezone | Char(30) | Time zone name (Olson) | ![]() | |
UTC | Char(10) | Coordinated Universal Time | ![]() | |
DST | Char(10) | Daylight saving time | ![]() |
Field name | Field type | Description | STANDARD | STREET+ |
---|---|---|---|---|
ISO | Char(2) | ISO 3166-1 Country code | ![]() | ![]() |
Country | Char(50) | Country name | ![]() | ![]() |
Language | Char(2) | Language code | ![]() | ![]() |
ID | Integer | Record identifier | ![]() | ![]() |
Region1 | Char(80) | Administrative division level 1 | ![]() | ![]() |
Region2 | Char(80) | Administrative division level 2 | ![]() | ![]() |
Region3 | Char(80) | Administrative division level 3 | ![]() | ![]() |
Region4 | Char(80) | Administrative division level 4 | ![]() | ![]() |
Entity | Char(100) | Entity name | ![]() | ![]() |
Postcode | Char(15) | ZIP / Postal code | ![]() | ![]() |
Info | Char(100) | Additional address information | ![]() | ![]() |
92 lines|3.07 KB |
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 | DROP TABLE IF EXISTS GeoPC_Places; DROP TABLE IF EXISTS GeoPC_Streets; DROP TABLE IF EXISTS GeoPC_Business; DROP TABLE IF EXISTS GeoPC_Regions; CREATE TABLE GeoPC_Places ( ISO varchar(2) NOT NULL, Country varchar(50) NOT NULL, Language varchar(2) NOT NULL, ID bigint(20) NOT NULL, Region1 varchar(80), Region2 varchar(80), Region3 varchar(80), Region4 varchar(80), Locality varchar(80), Postcode varchar(15), Suburb varchar(80), Latitude double, Longitude double, Elevation integer, ISO2 varchar(10), FIPS varchar(10), NUTS varchar(12), HASC varchar(12), STAT varchar(20), Timezone varchar(30), UTC varchar(10), DST varchar(10), PRIMARY KEY (Language, ID) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE GeoPC_Streets ( ISO varchar(2) NOT NULL, Country varchar(50) NOT NULL, Language varchar(2) NOT NULL, ID bigint(20) NOT NULL, Region1 varchar(80), Region2 varchar(80), Region3 varchar(80), Region4 varchar(80), Locality varchar(80), Postcode varchar(15), Suburb varchar(80), Street varchar(100), `Range` varchar(50), Building varchar(80), Latitude double, Longitude double, Elevation integer, ISO2 varchar(10), FIPS varchar(10), NUTS varchar(12), HASC varchar(12), STAT varchar(20), Timezone varchar(30), UTC varchar(10), DST varchar(10), PRIMARY KEY (Language, ID) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE GeoPC_Business ( ISO varchar(2) NOT NULL, Country varchar(50) NOT NULL, Language varchar(2) NOT NULL, ID bigint(20) NOT NULL, Region1 varchar(80), Region2 varchar(80), Region3 varchar(80), Region4 varchar(80), Entity varchar(100), Postcode varchar(15), Info varchar(100), PRIMARY KEY (Language, ID) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE GeoPC_Regions ( ISO varchar(2) NOT NULL, Country varchar(50) NOT NULL, Language varchar(2) NOT NULL, Level smallint(8) NOT NULL, Type varchar(50) NOT NULL, Name varchar(80) NOT NULL, Region1 varchar(80), Region2 varchar(80), Region3 varchar(80), Region4 varchar(80), ISO2 varchar(10), FIPS varchar(10), NUTS varchar(12), HASC varchar(12), STAT varchar(20) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
4 lines|0.83 KB |
1 2 3 4 | LOAD DATA INFILE '/path/GeoPC_xx_Places.csv' INTO TABLE GeoPC_Places FIELDS TERMINATED BY ';' ESCAPED BY '\\' IGNORE 1 LINES; LOAD DATA INFILE '/path/GeoPC_xx_Streets.csv' INTO TABLE GeoPC_Streets FIELDS TERMINATED BY ';' ESCAPED BY '\\' IGNORE 1 LINES; LOAD DATA INFILE '/path/GeoPC_xx_Business.csv' INTO TABLE GeoPC_Business FIELDS TERMINATED BY ';' ESCAPED BY '\\' IGNORE 1 LINES; LOAD DATA INFILE '/path/GeoPC_xx_Regions.csv' INTO TABLE GeoPC_Regions FIELDS TERMINATED BY ';' ESCAPED BY '\\' IGNORE 1 LINES; |
108 lines|3.80 KB |
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 | DROP TABLE IF EXISTS geopc_places; DROP TABLE IF EXISTS geopc_streets; DROP TABLE IF EXISTS geopc_business; DROP TABLE IF EXISTS geopc_regions; CREATE TABLE geopc_places ( iso character varying(2) NOT NULL, country character varying(50) NOT NULL, language character varying(2) NOT NULL, id integer NOT NULL, region1 character varying(80), region2 character varying(80), region3 character varying(80), region4 character varying(80), locality character varying(80), postcode character varying(15), suburb character varying(80), latitude double precision, longitude double precision, elevation integer, iso2 character varying(10), fips character varying(10), nuts character varying(12), hasc character varying(12), stat character varying(20), timezone character varying(30), utc character varying(10), dst character varying(10), CONSTRAINT geopc_places_pkey PRIMARY KEY (language, id) ) WITH ( OIDS=FALSE ); CREATE TABLE geopc_streets ( iso character varying(2) NOT NULL, country character varying(50) NOT NULL, language character varying(2) NOT NULL, id integer NOT NULL, region1 character varying(80), region2 character varying(80), region3 character varying(80), region4 character varying(80), locality character varying(80), postcode character varying(15), suburb character varying(80), street character varying(100), range character varying(50), building character varying(80), latitude double precision, longitude double precision, elevation integer, iso2 character varying(10), fips character varying(10), nuts character varying(12), hasc character varying(12), stat character varying(20), timezone character varying(30), utc character varying(10), dst character varying(10), CONSTRAINT geopc_streets_pkey PRIMARY KEY (language, id) ) WITH ( OIDS=FALSE ); CREATE TABLE geopc_business ( iso character varying(2) NOT NULL, country character varying(50) NOT NULL, language character varying(2) NOT NULL, id integer NOT NULL, region1 character varying(80), region2 character varying(80), region3 character varying(80), region4 character varying(80), entity character varying(100), postcode character varying(15), info character varying(100), CONSTRAINT geopc_business_pkey PRIMARY KEY (language, id) ) WITH ( OIDS=FALSE ); CREATE TABLE geopc_regions ( iso character varying(2) NOT NULL, country character varying(50) NOT NULL, language character varying(2) NOT NULL, level smallint NOT NULL, type character varying(50) NOT NULL, name character varying(80) NOT NULL, region1 character varying(80), region2 character varying(80), region3 character varying(80), region4 character varying(80), iso2 character varying(10), fips character varying(10), nuts character varying(12), hasc character varying(12), stat character varying(20) ) WITH ( OIDS=FALSE ); |
4 lines|0.63 KB |
1 2 3 4 | COPY geopc_places FROM '/path/GeoPC_xx_Places.csv' WITH DELIMITER AS ';' CSV HEADER ENCODING 'UTF-8'; COPY geopc_streets FROM '/path/GeoPC_xx_Streets.csv' WITH DELIMITER AS ';' CSV HEADER ENCODING 'UTF-8'; COPY geopc_business FROM '/path/GeoPC_xx_Business.csv' WITH DELIMITER AS ';' CSV HEADER ENCODING 'UTF-8'; COPY geopc_regions FROM '/path/GeoPC_xx_Regions.csv' WITH DELIMITER AS ';' CSV HEADER ENCODING 'UTF-8'; |
94 lines|3.46 KB |
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 | DROP TABLE GeoPC_Places, GeoPC_Streets, GeoPC_Business, GeoPC_Regions; GO CREATE TABLE GeoPC_Places ( ISO VARCHAR(2) NOT NULL, Country VARCHAR(50) NOT NULL, Language VARCHAR(2) NOT NULL, ID BIGINT NOT NULL, Region1 VARCHAR(80), Region2 VARCHAR(80), Region3 VARCHAR(80), Region4 VARCHAR(80), Locality VARCHAR(80), Postcode VARCHAR(15), Suburb VARCHAR(80), Latitude DECIMAL(10,6), Longitude DECIMAL(10,6), Elevation INT, ISO2 VARCHAR(10), FIPS VARCHAR(10), NUTS VARCHAR(12), HASC VARCHAR(12), STAT VARCHAR(20), Timezone VARCHAR(30), UTC VARCHAR(10), DST VARCHAR(10), CONSTRAINT GeoPC_Places_pkey PRIMARY KEY CLUSTERED (Language ASC, ID ASC) ON [PRIMARY] ); GO CREATE TABLE GeoPC_Streets ( ISO VARCHAR(2) NOT NULL, Country VARCHAR(50) NOT NULL, Language VARCHAR(2) NOT NULL, ID BIGINT NOT NULL, Region1 VARCHAR(80), Region2 VARCHAR(80), Region3 VARCHAR(80), Region4 VARCHAR(80), Locality VARCHAR(80), Postcode VARCHAR(15), Suburb VARCHAR(80), Street VARCHAR(100), [Range] VARCHAR(50), Building VARCHAR(80), Latitude DECIMAL(10,6), Longitude DECIMAL(10,6), Elevation INT, ISO2 VARCHAR(10), FIPS VARCHAR(10), NUTS VARCHAR(12), HASC VARCHAR(12), STAT VARCHAR(20), Timezone VARCHAR(30), UTC VARCHAR(10), DST VARCHAR(10), CONSTRAINT GeoPC_Streets_pkey PRIMARY KEY CLUSTERED (Language ASC, ID ASC) ON [PRIMARY] ); GO CREATE TABLE GeoPC_Business ( ISO VARCHAR(2) NOT NULL, Country VARCHAR(50) NOT NULL, Language VARCHAR(2) NOT NULL, ID BIGINT NOT NULL, Region1 VARCHAR(80), Region2 VARCHAR(80), Region3 VARCHAR(80), Region4 VARCHAR(80), Entity VARCHAR(100), Postcode VARCHAR(15), Info VARCHAR(100), CONSTRAINT GeoPC_Business_pkey PRIMARY KEY CLUSTERED (Language ASC, ID ASC) ON [PRIMARY] ); GO CREATE TABLE GeoPC_Regions ( ISO VARCHAR(2) NOT NULL, Country VARCHAR(50) NOT NULL, Language VARCHAR(2) NOT NULL, Level SMALLINT NOT NULL, Type VARCHAR(50) NOT NULL, Name VARCHAR(80) NOT NULL, Region1 VARCHAR(80), Region2 VARCHAR(80), Region3 VARCHAR(80), Region4 VARCHAR(80), ISO2 VARCHAR(10), FIPS VARCHAR(10), NUTS VARCHAR(12), HASC VARCHAR(12), STAT VARCHAR(20) ); GO |
4 lines|0.82 KB |
1 2 3 4 | BULK INSERT GeoPC_Places FROM 'Path\GeoPC_xx_Places.csv' WITH (FIRSTROW = 2, FIELDTERMINATOR = ';', ROWTERMINATOR = '\n', DATAFILETYPE = 'widechar') GO BULK INSERT GeoPC_Streets FROM 'Path\GeoPC_xx_Streets.csv' WITH (FIRSTROW = 2, FIELDTERMINATOR = ';', ROWTERMINATOR = '\n', DATAFILETYPE = 'widechar') GO BULK INSERT GeoPC_Business FROM 'Path\GeoPC_xx_Business.csv' WITH (FIRSTROW = 2, FIELDTERMINATOR = ';', ROWTERMINATOR = '\n', DATAFILETYPE = 'widechar') GO BULK INSERT GeoPC_Regions FROM 'Path\GeoPC_xx_Regions.csv' WITH (FIRSTROW = 2, FIELDTERMINATOR = ';', ROWTERMINATOR = '\n', DATAFILETYPE = 'widechar') GO |
124 lines|5.25 KB |
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 | DROP TABLE IF EXISTS GeoPC_Places; DROP TABLE IF EXISTS GeoPC_Streets; DROP TABLE IF EXISTS GeoPC_Business; DROP TABLE IF EXISTS GeoPC_Regions; CREATE TABLE GeoPC_Places ( ISO VARCHAR2(2 char) NOT NULL, Country VARCHAR2(50 char) NOT NULL, Language VARCHAR2(2 char) NOT NULL, ID INTEGER NOT NULL, Region1 VARCHAR2(80 char), Region2 VARCHAR2(80 char), Region3 VARCHAR2(80 char), Region4 VARCHAR2(80 char), Locality VARCHAR2(80 char), Postcode VARCHAR2(15 char), Suburb VARCHAR2(80 char), Latitude NUMBER(10,6), Longitude NUMBER(10,6), Elevation INTEGER, ISO2 VARCHAR2(10 char), FIPS VARCHAR2(10 char), NUTS VARCHAR2(12 char), HASC VARCHAR2(12 char), STAT VARCHAR2(20 char), Timezone VARCHAR2(30 char), UTC VARCHAR2(10 char), DST VARCHAR2(10 char), CONSTRAINT GeoPC_Places_pkey PRIMARY KEY (Language, ID) ) ORGANIZATION EXTERNAL ( DEFAULT DIRECTORY xtern_data_dir ACCESS PARAMETERS ( RECORDS DELIMITED BY NEWLINE FIELDS TERMINATED BY ';' ) LOCATION ('/path/GeoPC_xx_Places.csv') ); CREATE TABLE GeoPC_Streets ( ISO VARCHAR2(2 char) NOT NULL, Country VARCHAR2(50 char) NOT NULL, Language VARCHAR2(2 char) NOT NULL, ID INTEGER NOT NULL, Region1 VARCHAR2(80 char), Region2 VARCHAR2(80 char), Region3 VARCHAR2(80 char), Region4 VARCHAR2(80 char), Locality VARCHAR2(80 char), Postcode VARCHAR2(15 char), Suburb VARCHAR2(80 char), Street VARCHAR2(100 char), Range VARCHAR2(50 char), Building VARCHAR2(80 char), Latitude NUMBER(10,6), Longitude NUMBER(10,6), Elevation INTEGER, ISO2 VARCHAR2(10 char), FIPS VARCHAR2(10 char), NUTS VARCHAR2(12 char), HASC VARCHAR2(12 char), STAT VARCHAR2(20 char), Timezone VARCHAR2(30 char), UTC VARCHAR2(10 char), DST VARCHAR2(10 char), CONSTRAINT GeoPC_Streets_pkey PRIMARY KEY (Language, ID) ) ORGANIZATION EXTERNAL ( DEFAULT DIRECTORY xtern_data_dir ACCESS PARAMETERS ( RECORDS DELIMITED BY NEWLINE FIELDS TERMINATED BY ';' ) LOCATION ('/path/GeoPC_xx_Streets.csv') ); CREATE TABLE GeoPC_Business ( ISO VARCHAR2(2 char) NOT NULL, Country VARCHAR2(50 char) NOT NULL, Language VARCHAR2(2 char) NOT NULL, ID INTEGER NOT NULL, Region1 VARCHAR2(80 char), Region2 VARCHAR2(80 char), Region3 VARCHAR2(80 char), Region4 VARCHAR2(80 char), Entity VARCHAR2(100 char), Postcode VARCHAR2(15 char), Info VARCHAR2(100 char), CONSTRAINT GeoPC_Business_pkey PRIMARY KEY (Language, ID) ) ORGANIZATION EXTERNAL ( DEFAULT DIRECTORY xtern_data_dir ACCESS PARAMETERS ( RECORDS DELIMITED BY NEWLINE FIELDS TERMINATED BY ';' ) LOCATION ('/path/GeoPC_xx_Business.csv') ); CREATE TABLE GeoPC_Regions ( ISO VARCHAR2(2 char) NOT NULL, Country VARCHAR2(50 char), Language VARCHAR2(2 char) NOT NULL, Level INTEGER NOT NULL, Type VARCHAR2(50 char), Name VARCHAR2(80 char), Region1 VARCHAR2(80 char), Region2 VARCHAR2(80 char), Region3 VARCHAR2(80 char), Region4 VARCHAR2(80 char), ISO2 VARCHAR2(10 char), FIPS VARCHAR2(10 char), NUTS VARCHAR2(12 char), HASC VARCHAR2(12 char), STAT VARCHAR2(20 char) ) ORGANIZATION EXTERNAL ( DEFAULT DIRECTORY xtern_data_dir ACCESS PARAMETERS ( RECORDS DELIMITED BY NEWLINE FIELDS TERMINATED BY ';' ) LOCATION ('/path/GeoPC_xx_Regions.csv') ); |
92 lines|2.65 KB |
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 | DROP TABLE IF EXISTS GeoPC_Places; DROP TABLE IF EXISTS GeoPC_Streets; DROP TABLE IF EXISTS GeoPC_Business; DROP TABLE IF EXISTS GeoPC_Regions; CREATE TABLE GeoPC_Places ( ISO CHAR(2) NOT NULL, Country CHAR(50) NOT NULL, Language CHAR(2) NOT NULL, ID INTEGER NOT NULL, Region1 CHAR(80), Region2 CHAR(80), Region3 CHAR(80), Region4 CHAR(80), Locality CHAR(80), Postcode CHAR(15), Suburb CHAR(80), Latitude NUMERIC, Longitude NUMERIC, Elevation INTEGER, ISO2 CHAR(10), FIPS CHAR(10), NUTS CHAR(12), HASC CHAR(12), STAT CHAR(20), Timezone CHAR(30), UTC CHAR(10), DST CHAR(10), PRIMARY KEY (Language, ID) ); CREATE TABLE GeoPC_Streets ( ISO CHAR(2) NOT NULL, Country CHAR(50) NOT NULL, Language CHAR(2) NOT NULL, ID INTEGER NOT NULL, Region1 CHAR(80), Region2 CHAR(80), Region3 CHAR(80), Region4 CHAR(80), Locality CHAR(80), Postcode CHAR(15), Suburb CHAR(80), Street CHAR(100), Range CHAR(50), Building CHAR(80), Latitude NUMERIC, Longitude NUMERIC, Elevation INTEGER, ISO2 CHAR(10), FIPS CHAR(10), NUTS CHAR(12), HASC CHAR(12), STAT CHAR(20), Timezone CHAR(30), UTC CHAR(10), DST CHAR(10), PRIMARY KEY (Language, ID) ); CREATE TABLE GeoPC_Business ( ISO CHAR(2) NOT NULL, Country CHAR(50) NOT NULL, Language CHAR(2) NOT NULL, ID INTEGER NOT NULL, Region1 CHAR(80), Region2 CHAR(80), Region3 CHAR(80), Region4 CHAR(80), Entity CHAR(100), Postcode CHAR(15), Info CHAR(100), PRIMARY KEY (Language, ID) ); CREATE TABLE GeoPC_Regions ( ISO CHAR(2) NOT NULL, Country CHAR(50), Language CHAR(2) NOT NULL, Level INTEGER NOT NULL, Type CHAR(50), Name CHAR(80), Region1 CHAR(80), Region2 CHAR(80), Region3 CHAR(80), Region4 CHAR(80), ISO2 CHAR(10), FIPS CHAR(10), NUTS CHAR(12), HASC CHAR(12), STAT CHAR(20) ); |
4 lines|0.89 KB |
1 2 3 4 | LOAD DATA INLINE '/path/GeoPC_xx_Places.csv' INTO TABLE GeoPC_Places FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' IGNORE 1 LINES; LOAD DATA INLINE '/path/GeoPC_xx_Streets.csv' INTO TABLE GeoPC_Streets FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' IGNORE 1 LINES; LOAD DATA INLINE '/path/GeoPC_xx_Business.csv' INTO TABLE GeoPC_Business FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' IGNORE 1 LINES; LOAD DATA INLINE '/path/GeoPC_xx_Regions.csv' INTO TABLE GeoPC_Regions FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' IGNORE 1 LINES; |
7 lines|0.39 KB |
1 2 3 4 5 6 7 | Open or create a new Access database Open menu File/Get External Data/Import Select "Text Files (*.txt;*.csv;*.tab;*.asc)" as type of file Browse directories and select your file (GeoPC_*.csv) Select Delimited, click on Advanced and select Unicode (UTF-8) as Code Page Click Next, select Semicolon as delimiter and {none} as Text qualifier Tick First row contains field names and click on Finish |
6 lines|0.32 KB |
1 2 3 4 5 6 | Open the menu Data/Import External Data/Import data Select "Text Files (*.txt;*.prn;*.csv)" as type of file Browse directories and select your file (GeoPC_*.csv) In import wizard, select Delimited type and 65001: Unicode (UTF-8) encoding Click Next, select Semicolon as delimiter and {none} as Text qualifier Click on Finish |
Please note that the following limits applies to Excel sheets:
The Shapefile format contains the following files:
All GeoPostcodes datasets are encoded in UTF-8. The names of localities and regions are always available in local language but we also provide other versions:
Multiple languages
Some countries (eg. Belgium, Switzerland, ..) have several national languages, in this case we provide a specific version for each one of these languages. The selection can be done using the Language field in the table.
Non-Latin languages
For languages using a non-Latin alphabet (such as Chinese, Japanese, Russian, etc), an English version is available in addition to the local version. These versions have been translated as closely as possible from the original text. However, where it is not possible to make an accurate translation that is reliable or the translation does not exist, the closest alternative, a transliteration, is provided.
Normalized ASCII
A normalized ASCII version where all accents and diacritics have been removed is provided for all datasets. These files have the ASC extension and are in CSV (Comma-separated values) format.
Language codes
We use standard ISO 639-1 code to reference a language except for two cases:
- For Canada, we use the code EF as the place names can be either in English or French
- For Japan, we use the code KT for Katakana, which is a script form of the Japanese language.
Since there is no translation for most of the towns and villages in the world, it is advisable to do a transcription or a transliteration in English. The transcription is a replacement of each character or character group by an equivalent sound in English, it is therefore a phonetic translation. Transliteration (also called romanization) is a substitution of each character or character group by an other equivalent according to a matching table. This method does not take pronunciation into consideration.
Example :
Local Russian name : Санкт-ПетербургÅland (Swedish) Armenia (Armenian) Azerbaijan (Azerbaijani) Belarus (Russian) Belgium (Dutch) Bulgaria (Bulgarian) China (Chinese) Cyprus (Greek) Egypt (Arabic) Finland (Swedish) Greece (Greek) Hong Kong (Chinese) Iran (Arabic) Ireland (Irish) Israel (Hebrew) Japan (Japanese, Japanese (Katakana)) Jordan (Arabic) | Kazakhstan (Russian, Kazakh) Kuwait (Arabic) Kyrgyzstan (Russian) Lebanon (Arabic) Macau (Chinese) Macedonia (Macedonian) Mongolia (Mongolian) Oman (Arabic) Palestine (Arabic) Qatar (Arabic) Russia (Russian) Saudi Arabia (Arabic) South Africa (Afrikaans) South Korea (Korean) Switzerland (French, Italian) Syria (Arabic) Taiwan (Chinese) Thailand (Thai) Ukraine (Ukrainian) Uzbekistan (Russian) Yemen (Arabic) |
AZ : Azerbaijani (Azərbaycanca)
Used in the following countries : Azerbaijan
Uppercase | Lowercase | ||
UTF-8 | ASCII | UTF-8 | ASCII |
’ | ' | ||
Ç | C | ç | c |
Đ | D | đ | d |
Ǝ | E | ə | e |
Ə | A | ||
Ğ | G | ğ | g |
Ì | I | ì | i |
İ | I | ı | i |
Ñ | N | ñ | n |
Ŋ | N | ŋ | n |
Ö | O | ö | o |
Ş | S | ş | s |
Ü | U | ü | u |
Ƶ | Z | ƶ | z |
А | A | а | a |
Б | B | б | b |
В | V | в | v |
Г | G | г | g |
Ғ | Gh | ғ | gh |
Д | D | д | d |
Е | E | е | e |
Ә | A | ә | a |
Ж | Zh | ж | zh |
З | Z | з | z |
И | I | и | i |
Ј | Y | ј | y |
К | K | к | k |
Ҝ | G | ҝ | g |
Л | L | л | l |
М | M | м | m |
Н | N | н | n |
О | O | о | o |
Ө | O | ө | o |
П | P | п | p |
Р | R | р | r |
С | S | с | s |
Т | T | т | t |
У | U | у | u |
Ү | U | ү | u |
Ф | F | ф | f |
Х | Kh | х | kh |
Һ | H | һ | h |
Ч | Ch | ч | ch |
Ҹ | J | ҹ | j |
Ш | Sh | ш | sh |
Ы | Y | ы | y |
BG : Bulgarian (Български)
Used in the following countries : Bulgaria
Uppercase | Lowercase | ||
UTF-8 | ASCII | UTF-8 | ASCII |
А | A | а | a |
Б | B | б | b |
В | V | в | v |
Г | G | г | g |
Д | D | д | d |
Е | E | е | e |
Ж | Zh | ж | zh |
З | Z | з | z |
И | I | и | i |
Й | J | й | j |
К | K | к | k |
Л | L | л | l |
М | M | м | m |
Н | N | н | n |
О | O | о | o |
П | P | п | p |
Р | R | р | r |
С | S | с | s |
Т | T | т | t |
У | U | у | u |
Ф | F | ф | f |
Х | H | х | h |
Ц | C | ц | c |
Ч | Ch | ч | ch |
Ш | Sh | ш | sh |
Щ | Sht | щ | sht |
Ъ | U | ъ | u |
Ь | J | ь | j |
Ю | Ju | ю | ju |
Я | Ja | я | ja |
BS : Bosnian (Bosanski)
Used in the following countries : Bosnia-Herzegovina
Uppercase | Lowercase | ||
UTF-8 | ASCII | UTF-8 | ASCII |
Ć | C | ć | c |
Č | C | č | c |
Ð | D | đ | d |
Š | S | š | s |
Ž | Z | ž | z |
CA : Catalan (Català)
Used in the following countries : Andorra
Uppercase | Lowercase | ||
UTF-8 | ASCII | UTF-8 | ASCII |
À | A | à | a |
Ç | C | ç | c |
É | E | é | e |
È | E | è | e |
Í | I | í | i |
Ï | I | ï | i |
Ó | O | ó | o |
Ò | O | ò | o |
Ú | U | ú | u |
Ü | U | ü | u |
CS : Czech (Čeština)
Used in the following countries : Czechia
Uppercase | Lowercase | ||
UTF-8 | ASCII | UTF-8 | ASCII |
Á | A | á | a |
Ä | A | ä | a |
Č | C | č | c |
Ď | D | ď | d |
É | E | é | e |
Ě | E | ě | e |
Í | I | í | i |
Ĺ | L | ĺ | l |
Ľ | L | ľ | l |
Ň | N | ň | n |
Ó | O | ó | o |
Ô | O | ô | o |
Ŕ | R | ŕ | r |
Ř | R | ř | r |
Š | S | š | s |
Ť | T | ť | t |
Ú | U | ú | u |
Ů | U | ů | u |
Ý | Y | ý | y |
Ž | Z | ž | z |
DA : Danish (Dansk)
Used in the following countries : Denmark
Uppercase | Lowercase | ||
UTF-8 | ASCII | UTF-8 | ASCII |
Á | A | á | a |
Å | Aa | å | aa |
Æ | Ae | æ | ae |
Ð | D | ð | d |
É | E | é | e |
Í | I | í | i |
Ó | O | ó | o |
Ø | Oe | ø | oe |
Ú | U | ú | u |
Ü | Y | ü | y |
Ý | Y | ý | y |
DE : German (Deutsch)
Used in the following countries : Austria, Germany, Liechtenstein, Switzerland
Uppercase | Lowercase | ||
UTF-8 | ASCII | UTF-8 | ASCII |
Á | A | á | a |
À | A | à | a |
 | A | â | a |
Ä | Ae | ä | ae |
Ç | C | ç | c |
É | E | é | e |
É | E | é | e |
È | E | è | e |
Ê | E | ê | e |
Ë | E | ë | e |
Ì | I | ì | i |
Î | I | î | i |
Ï | I | ï | i |
Ô | O | ô | o |
Ö | Oe | ö | oe |
Œ | Oe | œ | oe |
ß | Ss | ß | ss |
Ù | U | ù | u |
Û | U | û | u |
Ü | Ue | ü | ue |
Ž | Z | ž | z |
EL : Greek (Ελληνικά)
Used in the following countries : Cyprus, Greece
Uppercase | Lowercase | ||
UTF-8 | ASCII | UTF-8 | ASCII |
Í | I | í | i |
Α | A | α | a |
Ά | A | ά | a |
Αυ | Av | αυ | av |
Β | V | β | v |
Γ | G | γ | g |
Γγ | Ng | γγ | ng |
Γξ | Nx | γξ | nx |
Γχ | Nch | γχ | nch |
Δ | D | δ | d |
Ε | E | ε | e |
Έ | E | έ | e |
Ευ | Ev | ευ | ev |
Ζ | Z | ζ | z |
Η | I | η | i |
Ή | I | ή | i |
Ηυ | Iv | ηυ | iv |
Θ | Th | θ | th |
Ι | I | ι | i |
Ί | I | ί | i |
Ϊ | I | ϊ | i |
ΐ | I | ΐ | i |
Κ | K | κ | k |
Λ | L | λ | l |
Μ | M | μ | m |
Μπ | Mp | μπ | mp |
Ν | N | ν | n |
Ξ | X | ξ | x |
Ο | O | ο | o |
Ό | O | ό | o |
Ου | Ou | ου | ou |
Π | P | π | p |
Ρ | R | ρ | r |
Σ | S | σ | s |
ς | S | ς | s |
Τ | T | τ | t |
Υ | Y | υ | y |
Ύ | U | ύ | u |
Φ | F | φ | f |
Χ | Ch | χ | ch |
Ψ | Ps | ψ | ps |
Ω | O | ω | o |
Ώ | O | ώ | o |
ES : Spanish (Español)
Used in the following countries : Argentina, Bolivia, Chile, Colombia, Costa Rica, Cuba, Dominican Republic, Ecuador, El Salvador, Guatemala, Honduras, Mexico, Nicaragua, Panama, Paraguay, Peru, Spain, Uruguay, Venezuela
Uppercase | Lowercase | ||
UTF-8 | ASCII | UTF-8 | ASCII |
° | O | ° | o |
Á | A | á | a |
À | A | à | a |
Ä | A | ä | a |
ª | A | ª | a |
Ç | C | ç | c |
É | E | é | e |
È | E | è | e |
Ë | E | ë | e |
Í | I | í | i |
Ì | I | ì | i |
Ï | I | ï | i |
Ñ | N | ñ | n |
Ó | O | ó | o |
Ò | O | ò | o |
Ö | O | ö | o |
Ú | U | ú | u |
Ü | U | ü | u |
Ý | Y | ý | y |
Ÿ | Y | ÿ | y |
ET : Estonian (Eesti)
Used in the following countries : Estonia
Uppercase | Lowercase | ||
UTF-8 | ASCII | UTF-8 | ASCII |
Ä | A | ä | a |
Ö | O | ö | o |
Õ | O | õ | o |
Š | S | š | s |
Ü | U | ü | u |
Ž | Z | ž | z |
FI : Finnish (Suomi)
Used in the following countries : Åland, Finland
Uppercase | Lowercase | ||
UTF-8 | ASCII | UTF-8 | ASCII |
Á | A | á | a |
Å | A | å | a |
Ä | A | ä | a |
É | E | é | e |
Ö | O | ö | o |
FR : French (Français)
Used in the following countries : Algeria, Belgium, Benin, Burkina Faso, Burundi, Cameroon, Central African Rep., Chad, Côte d'Ivoire, France, French Guiana, French Polynesia, French Southern Territories, Guadeloupe, Haiti, Luxembourg, Madagascar, Mali, Martinique, Mayotte, Monaco, Morocco, New Caledonia, Niger, Réunion, Saint Barthélemy, Saint Martin, Saint Pierre & Miquelon, Senegal, Switzerland, Tunisia, Wallis and Futuna
Uppercase | Lowercase | ||
UTF-8 | ASCII | UTF-8 | ASCII |
À | A | à | a |
 | A | â | a |
Ä | A | ä | a |
Ç | C | ç | c |
É | E | é | e |
È | E | è | e |
Ê | E | ê | e |
Ë | E | ë | e |
Ì | I | ì | i |
Î | I | î | i |
Ï | I | ï | i |
Ô | O | ô | o |
Ö | O | ö | o |
Œ | Oe | œ | oe |
Ù | U | ù | u |
Û | U | û | u |
Ü | U | ü | u |
Ÿ | Y | ÿ | y |
HR : Croatian (Hrvatski)
Used in the following countries : Croatia
Uppercase | Lowercase | ||
UTF-8 | ASCII | UTF-8 | ASCII |
Á | A | á | a |
Ć | C | ć | c |
Č | C | č | c |
Đ | D | đ | d |
Ó | O | ó | o |
Ö | O | ö | o |
Š | S | š | s |
Ú | U | ú | u |
Ž | Z | ž | z |
HU : Hungarian (Magyar)
Used in the following countries : Hungary
Uppercase | Lowercase | ||
UTF-8 | ASCII | UTF-8 | ASCII |
Á | A | á | a |
É | E | é | e |
Í | I | í | i |
Ó | O | ó | o |
Ö | O | ö | o |
Ő | O | ő | o |
Ú | U | ú | u |
Ü | U | ü | u |
Ű | U | ű | u |
IS : Icelandic (Íslenska)
Used in the following countries : Iceland
Uppercase | Lowercase | ||
UTF-8 | ASCII | UTF-8 | ASCII |
Æ | Ae | æ | ae |
Ð | D | ð | d |
É | E | é | e |
Í | I | í | i |
Ó | O | ó | o |
Ö | O | ö | o |
Ú | U | ú | u |
Ý | Y | ý | y |
Þ | Th | þ | th |
IT : Italian (Italiano)
Used in the following countries : Italy, San Marino, Switzerland, Vatican
Uppercase | Lowercase | ||
UTF-8 | ASCII | UTF-8 | ASCII |
À | A | à | a |
É | E | é | e |
È | E | è | e |
Ì | I | ì | i |
Ó | O | ó | o |
Ò | O | ò | o |
Ù | U | ù | u |
LT : Lithuanian (Lietuvių)
Used in the following countries : Lithuania
Uppercase | Lowercase | ||
UTF-8 | ASCII | UTF-8 | ASCII |
Ą | A | ą | a |
Č | C | č | c |
Ė | E | ė | e |
Ę | E | ę | e |
Į | I | į | i |
Š | S | š | s |
Ų | U | ų | u |
Ū | U | ū | u |
Ž | Z | ž | z |
LV : Latvian (Latviešu)
Used in the following countries : Latvia
Uppercase | Lowercase | ||
UTF-8 | ASCII | UTF-8 | ASCII |
Ā | A | ā | a |
Č | C | č | c |
Ē | E | ē | e |
Ģ | G | ģ | g |
Ī | I | ī | i |
Ķ | K | ķ | k |
Ļ | L | ļ | l |
Ņ | N | ņ | n |
Š | S | š | s |
Ū | U | ū | u |
Ž | Z | ž | z |
MK : Macedonian (Македонски)
Used in the following countries : Macedonia
Uppercase | Lowercase | ||
UTF-8 | ASCII | UTF-8 | ASCII |
Č | C | č | c |
Š | S | š | s |
А | A | а | a |
Б | B | б | b |
В | V | в | v |
Г | G | г | g |
Д | D | д | d |
Ѓ | G | ѓ | g |
Е | E | е | e |
Ё | E | ё | e |
Ж | Z | ж | z |
З | Z | з | z |
И | I | и | i |
Й | J | й | j |
Ј | J | ј | j |
К | K | к | k |
Л | L | л | l |
Љ | Lj | љ | lj |
М | M | м | m |
Н | N | н | n |
Њ | B | њ | b |
О | O | о | o |
П | P | п | p |
Р | R | р | r |
С | S | с | s |
Т | T | т | t |
Ќ | K | ќ | k |
У | U | у | u |
Ф | F | ф | f |
Х | H | х | h |
Ц | C | ц | c |
Ч | C | ч | c |
Џ | Zh | џ | zh |
Ш | S | ш | s |
Щ | Sc | щ | sc |
Ъ | '' | ъ | '' |
Ы | Y | ы | y |
Ь | ' | ь | ' |
Э | E | э | e |
Ю | Ju | ю | ju |
Я | Ja | я | ja |
MT : Maltese (Malti)
Used in the following countries : Malta
Uppercase | Lowercase | ||
UTF-8 | ASCII | UTF-8 | ASCII |
À | A | à | a |
Ċ | C | ċ | c |
È | E | è | e |
Ġ | G | ġ | g |
Ħ | H | ħ | h |
Ż | Z | ż | z |
NL : Dutch (Nederlands)
Used in the following countries : Belgium, Netherlands, Sint Maarten, Suriname
Uppercase | Lowercase | ||
UTF-8 | ASCII | UTF-8 | ASCII |
Á | A | á | a |
À | A | à | a |
 | A | â | a |
Ä | A | ä | a |
Ç | C | ç | c |
É | E | é | e |
È | E | è | e |
Ê | E | ê | e |
Ë | E | ë | e |
Í | I | í | i |
Ì | I | ì | i |
Î | I | î | i |
Ï | I | ï | i |
Ó | O | ó | o |
Ò | O | ò | o |
Ô | O | ô | o |
Ö | O | ö | o |
Ú | U | ú | u |
Ù | U | ù | u |
Û | U | û | u |
Ü | U | ü | u |
Ý | Y | ý | y |
Ÿ | Y | ÿ | y |
NO : Norwegian (Norsk)
Used in the following countries : Bouvet Island, Norway, Svalbard and Jan Mayen
Uppercase | Lowercase | ||
UTF-8 | ASCII | UTF-8 | ASCII |
Á | A | á | a |
Å | Aa | å | aa |
Ä | Ae | ä | ae |
Æ | Ae | æ | ae |
É | E | é | e |
È | E | è | e |
Ö | Oe | ö | oe |
Ø | Oe | ø | oe |
Ü | U | ü | u |
PL : Polish (Polski)
Used in the following countries : Poland
Uppercase | Lowercase | ||
UTF-8 | ASCII | UTF-8 | ASCII |
Á | A | á | a |
Ą | A | ą | a |
Ć | C | ć | c |
Ë | E | ë | e |
Ę | E | ę | e |
Ł | L | ł | l |
Ń | N | ń | n |
Ó | O | ó | o |
Ś | S | ś | s |
Ü | U | ü | u |
Ź | Z | ź | z |
Ż | Z | ż | z |
PT : Portuguese (Português)
Used in the following countries : Angola, Brazil, Cape Verde, Mozambique, Portugal
Uppercase | Lowercase | ||
UTF-8 | ASCII | UTF-8 | ASCII |
° | O | ° | o |
Á | A | á | a |
À | A | à | a |
 | A | â | a |
à | A | ã | a |
ª | A | ª | a |
Ç | C | ç | c |
É | E | é | e |
Ê | E | ê | e |
Í | I | í | i |
Ó | O | ó | o |
Ô | O | ô | o |
Õ | O | õ | o |
º | O | º | o |
Ú | U | ú | u |
Ü | U | ü | u |
RO : Romanian (Română)
Used in the following countries : Moldova, Romania
Uppercase | Lowercase | ||
UTF-8 | ASCII | UTF-8 | ASCII |
Á | A | á | a |
À | A | à | a |
Ă | A | ă | a |
 | A | â | a |
È | E | è | e |
Í | I | í | i |
Î | I | î | i |
Ó | O | ó | o |
Ò | O | ò | o |
Ö | O | ö | o |
Ş | S | ş | s |
Ţ | T | ţ | t |
RU : Russian (Русский)
Used in the following countries : Belarus, Kazakhstan, Kyrgyzstan, Russia, Uzbekistan
Uppercase | Lowercase | ||
UTF-8 | ASCII | UTF-8 | ASCII |
А | A | а | a |
Б | B | б | b |
В | V | в | v |
Г | G | г | g |
Д | D | д | d |
Е | E | е | e |
Ё | E | ё | e |
Ж | Z | ж | z |
З | Z | з | z |
И | I | и | i |
Й | J | й | j |
К | K | к | k |
Л | L | л | l |
М | M | м | m |
Н | N | н | n |
О | O | о | o |
П | P | п | p |
Р | R | р | r |
С | S | с | s |
Т | T | т | t |
У | U | у | u |
Ў | Y | ў | y |
Ф | F | ф | f |
Х | H | х | h |
Ц | C | ц | c |
Ч | C | ч | c |
Ш | S | ш | s |
Щ | Sc | щ | sc |
Ъ | '' | ъ | '' |
Ы | Y | ы | y |
Ь | ' | ь | ' |
Э | E | э | e |
Ю | Ju | ю | ju |
Я | Ja | я | ja |
SK : Slovak (Slovenčina)
Used in the following countries : Slovakia
Uppercase | Lowercase | ||
UTF-8 | ASCII | UTF-8 | ASCII |
Á | A | á | a |
Ä | A | ä | a |
Č | C | č | c |
Ď | D | ď | d |
É | E | é | e |
Ě | E | ě | e |
Í | I | í | i |
Ĺ | L | ĺ | l |
Ľ | L | ľ | l |
Ň | N | ň | n |
Ó | O | ó | o |
Ô | O | ô | o |
Ö | O | ö | o |
Ŕ | R | ŕ | r |
Ř | R | ř | r |
Š | S | š | s |
Ť | T | ť | t |
Ú | U | ú | u |
Ů | U | ů | u |
Ý | Y | ý | y |
Ž | Z | ž | z |
SL : Slovenian (Slovenščina)
Used in the following countries : Slovenia
Uppercase | Lowercase | ||
UTF-8 | ASCII | UTF-8 | ASCII |
Č | C | č | c |
Š | S | š | s |
Ž | Z | ž | z |
SQ : Albanian (Shqip)
Used in the following countries : Albania
Uppercase | Lowercase | ||
UTF-8 | ASCII | UTF-8 | ASCII |
Ç | C | ç | c |
Ë | E | ë | e |
SR : Serbian (Српски / Srpski)
Used in the following countries : Serbia
Uppercase | Lowercase | ||
UTF-8 | ASCII | UTF-8 | ASCII |
Ć | C | ć | c |
Č | C | č | c |
Đ | D | đ | d |
Ð | D | đ | d |
Š | S | š | s |
Ž | Z | ž | z |
SV : Swedish (Svenska)
Used in the following countries : Åland, Finland, Sweden
Uppercase | Lowercase | ||
UTF-8 | ASCII | UTF-8 | ASCII |
Á | A | á | a |
Å | Aa | å | aa |
Ä | A | ä | a |
Æ | Ae | æ | ae |
Ð | D | ð | d |
É | E | é | e |
Í | I | í | i |
Ó | O | ó | o |
Ö | O | ö | o |
Ø | Oe | ø | oe |
Ú | U | ú | u |
Ý | Y | ý | y |
Þ | Th | þ | th |
SZ : Montenegrin (Crnogorski)
Used in the following countries : Montenegro
Uppercase | Lowercase | ||
UTF-8 | ASCII | UTF-8 | ASCII |
Ć | C | ć | c |
Č | C | č | c |
Đ | D | đ | d |
Š | S | š | s |
Ž | Z | ž | z |
TR : Turkish (Türkçe)
Used in the following countries : Turkey
Uppercase | Lowercase | ||
UTF-8 | ASCII | UTF-8 | ASCII |
Ç | C | ç | c |
Ğ | G | ğ | g |
İ | I | ı | i |
Ö | O | ö | o |
Ş | S | ş | s |
Ü | U | ü | u |
UK : Ukrainian (Українська)
Used in the following countries : Ukraine
Uppercase | Lowercase | ||
UTF-8 | ASCII | UTF-8 | ASCII |
’ | ' | ||
А | A | а | a |
Б | B | б | b |
В | V | в | v |
Г | H | г | h |
Ґ | G | ґ | g |
Д | D | д | d |
Е | E | е | e |
Є | Ye | є | ye |
Ж | Zh | ж | zh |
З | Z | з | z |
И | Y | и | y |
І | I | і | i |
Ї | I | ї | i |
Й | I | й | i |
К | K | к | k |
Л | L | л | l |
М | M | м | m |
Н | N | н | n |
О | O | о | o |
П | P | п | p |
Р | R | р | r |
С | S | с | s |
Т | T | т | t |
У | U | у | u |
Ф | F | ф | f |
Х | Kh | х | kh |
Ц | Ts | ц | ts |
Ч | Ch | ч | ch |
Ш | Sh | ш | sh |
Щ | Sch | щ | sch |
Ь | ' | ь | ' |
Ю | Iu | ю | iu |
Я | Ia | я | ia |
UZ : Uzbek (O‘zbek)
Used in the following countries :
Uppercase | Lowercase | ||
UTF-8 | ASCII | UTF-8 | ASCII |
А | A | а | a |
Б | B | б | b |
В | V | в | v |
Г | G | г | g |
Ғ | G' | ғ | g' |
Д | D | д | d |
Е | E | е | e |
Ё | Yo | ё | yo |
Ж | J | ж | j |
З | Z | з | z |
И | I | и | i |
Й | Y | й | y |
К | K | к | k |
Қ | Q | қ | q |
Л | L | л | l |
М | M | м | m |
Н | N | н | n |
О | O | о | o |
П | P | п | p |
Р | R | р | r |
С | S | с | s |
Т | T | т | t |
У | U | у | u |
Ў | O' | ў | o' |
Ф | F | ф | f |
Х | X | х | x |
Ҳ | H | ҳ | h |
Ц | Ts | ц | ts |
Ч | Ch | ч | ch |
Ш | Sh | ш | sh |
Ъ | ’ | ъ | ’ |
Ь | ’ | ь | ’ |
Э | E | э | e |
Ю | Yu | ю | yu |
Я | Ya | я | ya |
VI : Vietnamese (Tiếng Việt)
Used in the following countries : Vietnam
Uppercase | Lowercase | ||
UTF-8 | ASCII | UTF-8 | ASCII |
¸ | A | ¸ | a |
Á | A | á | a |
À | A | à | a |
Ă | A | ă | a |
Ắ | A | ắ | a |
Ằ | A | ằ | a |
Ẵ | A | ẵ | a |
Ẳ | A | ẳ | a |
Ặ | A | ặ | a |
 | A | â | a |
Ấ | A | ấ | a |
Ầ | A | ầ | a |
Ẫ | A | ẫ | a |
Ẩ | A | ẩ | a |
Ậ | A | ậ | a |
å | A | å | a |
Ä | A | ä | a |
à | A | ã | a |
Ả | A | ả | a |
Ạ | A | ạ | a |
Đ | D | đ | d |
Ð | D | Ð | d |
É | E | é | e |
È | E | è | e |
Ê | E | ê | e |
Ế | E | ế | e |
Ề | E | ề | e |
Ễ | E | ễ | e |
Ể | E | ể | e |
Ệ | E | ệ | e |
Ë | E | ë | e |
Ẽ | E | ẽ | e |
Ẻ | E | ẻ | e |
Ẹ | E | ẹ | e |
Í | I | í | i |
Ì | I | ì | i |
Î | I | î | i |
Ĩ | I | ĩ | i |
Ỉ | I | ỉ | i |
Ị | I | ị | i |
Ó | O | ó | o |
Ò | O | ò | o |
Ô | O | ô | o |
Ố | O | ố | o |
Ồ | O | ồ | o |
Ỗ | O | ỗ | o |
Ổ | O | ổ | o |
Ộ | O | ộ | o |
Õ | O | õ | o |
Ỏ | O | ỏ | o |
Ọ | O | ọ | o |
Ơ | O | ơ | o |
Ớ | O | ớ | o |
Ờ | O | ờ | o |
Ỡ | O | ỡ | o |
Ở | O | ở | o |
Ợ | O | ợ | o |
ß | O | ß | o |
Ú | U | ú | u |
Ù | U | ù | u |
Û | U | û | u |
Ü | U | ü | u |
Ü | U | ü | u |
Ũ | U | ũ | u |
Ủ | U | ủ | u |
Ụ | U | ụ | u |
Ư | U | ư | u |
Ứ | U | ứ | u |
Ừ | U | ừ | u |
Ữ | U | ữ | u |
Ử | U | ử | u |
Ự | U | ự | u |
Ý | Y | ý | y |
Ỳ | Y | ỳ | y |
Ỹ | Y | ỹ | y |
Ỷ | Y | ỷ | y |
Ỵ | Y | ỵ | y |
A Standard Edition is available for all countries. For a selection of countries, we are proposing a Street+ Edition including on top the comprehensive list of streets and their geocoordinates. You can compare both Editions on this page.
The License you need to subscribe depends mainly on your business uses and your need in updates, please visit this page. We're detailing the main differences between our Basic, Business and Entreprise Licenses.
If you wish to integrate our product in yours (software, dataset, website), please contact us.
Yes. If you do not have, or do not wish to use, a credit card, you can still pay by bank transfer. In this case, simply select this option in the shopping cart, you will find our bank details on the invoice.
Online payments are processed by our payment gateway 2checkout. We are unable to process any order following a card declined by the gateway. Please contact 2checkout directly in case of any issue with a payment.
If your card is not accepted or if you do not have a credit card, you can try with another card or select the Paypal option available on the gateway. Please also note that most credit cards have a monthly or weekly limit. In any other case it is still possible to pay by bank transfer by selecting the relevant option in the shopping cart.
If you cannot purchase by any of the payment methods mentioned, please contact us and we will suggest an alternative. We reserve the right to refuse any order if we do not have enough elements which guarantee the payment.
Invoices are available in PDF format in your customer account along with your payments history. If any information is missing or misspelled, please contact us.
Absolutely. You can send us your request using our online contact form.
We are proposing different packages at discounted prices for our Standard Edition. If you're interested in another bulk purchase not proposed on our website, don't hesitate to send us a question using our online contact form. We'll then review your request and see if a discount can be granted.
The confirmation is sent to the email address registered with your account. Please also check your 'spam' folder since our message may have been filtered by mistake. If you are certain you have not received a confirmation message, please contact us.
The database will be available for download in your customer account after the purchase is completed and the payment processed. In case of online payment, the entire process usually takes just a few minutes. However, depending on your country and payment method, some transactions can take longer. If you still not receive your order after 24 hours, please contact us. Payments by bank transfer usually take 2-5 business days. For purchase above $1,000 we may request a signed purchase order before granting access to the dataset download.
No. Our databases are available by download only, we do not ship any physical items. Besides being faster to access, this method also allows us to keep our products at low prices.
The download link remains active in your account for 30 days in the case of a Basic License subscription, and for 1 year in the case of a Business License or Entreprise License subscription. After this period, it is no longer possible to access the file unless you place a new order.
First, please try again later as the server may be temporarily overloaded or have encountered a technical problem. You could also try with another browser and/or a different internet connection. If you then still cannot download the file, please contact us.
The date of the last update/review performed is available on each country page. This date indicates when a review has been performed. If no update is deemed necessary, the current version will remain unchanged.
We strive to keep the same record ID's when an update is performed. But it can happen that new record ID's have to be created when the administrative structure of the country is changing or for other maintenance purposes.
All our files are created using the World Geodetic System standard WGS 84. The corresponding SRID reference is EPSG:4326.
The geographical position (latitude, longitude) is precise to about one hundred meters and corresponds to the center of the locality (generally the historical center, and if not, the geographical center), or the street for the Street+ files. In some countries, the postal code may refer to a block or a street, in which case the coordinates point to that specific location.
The accuracy level of the coordinates may vary for each country or be less accurate in some regions. Please have a look at our coverage map for more details.
Our datasets are build by collecting and aggregating data from numerous sources. All the information is cross checked through multiple proprietary GIS tools especially developed to ensure the quality and accuracy of each record. We use only official and verified information like national statistical offices, postal offices, governmental and intergovernmental organizations, etc..
Our geographic files (Shapefiles, KML, GML and GeoJSON) include only points, no polygon. The points are the centroid point of the postal delivery zones. Depending on the country, it can be postcode centroid, city centroid or region centroid points.
It’s usually only very large and/or famous cities that have their name translated into several different languages. For most towns and villages, there isn’t a translation so only the local name is available. We do, however, have other solutions, such as a file containing exonyms and transliterated versions of non-Latin languages. For more information, please take a look at this this page.
Our files are encoded in Unicode UTF-8, the international multilingual format. You will have to manually set your software import configuration to this format if it is not recognized automatically.
The formula used to calculate the distance between two geographical points is called orthodromy, and is defined as follows:Distance(A,B) = 6371 * ACos( Cos(LatA) * Cos(LatB) * Cos(LngB - LngA) + Sin(LatA) * Sin(LatB) )The resulting number is the distance in kilometers between point A and point B. If you wish to return a result in miles (or any other unit), you must substitute the value 6371, which stands for the approximate radius of the Earth in km, by its equivalent in miles (or any other unit), that is, 3959 miles. Latitude and longitude values must be input in radians : radians = degrees * PI/180.
An Excel template is available here.
Having a database of localities with their latitudes (Lat) and longitudes (Lng) enables you to locate the closest cities to a set point (or within a radius of X) with the following query:SELECT Name, 6371 * ACos( Cos(RADIANS(Lat)) * Cos(RADIANS(UserLat)) * Cos(RADIANS(UserLng) - RADIANS(Lng)) + Sin(RADIANS(Lat)) * Sin(RADIANS(UserLat)) ) AS Distance FROM Cities ORDER BY DistanceThe UserLat and UserLng values must be replaced by the coordinates of the starting point. To limit the search to a given radius, you can add a WHERE clause to the distance. You can also specify a LIMIT clause to display only the n cities closest to your starting point.
We provide email support in English. All your questions and remarks can be sent via our contact form. One of our support agents will contact you within 48 hours. A priority support is available for customers with enterprise license.
We do have a prioritization system in place. Support requests that come from customers with an Enterprise license are considered in priority. If we have for instance 20 pending support requests, our support agents will always look and respond to priority ones first, no matter if they came in after 20 regular ones. This will lead to a faster response.
If you have lost your login or password, please click here. If you are still having problems accessing your account, please contact us and provide your name, email address and date of purchase.
We strive to keep our databases as accurate as possible. However if you were to come across any inaccurate information, we offer 2 reporting options. If the error is part of a dataset you purchased, we invite you to report the error via our support ticket system. For other mistakes, you can send us an email to support@geopostcodes.com. As a general comments, please note that any issue/error reported will be reviewed and corrected (if appropriate) during the next country update.
GeoPostcodes is a trademark of :
GeoPostcodes SRLNo results found.