Products & licenses

We offer several licenses depending on your status and how you use the data:
We are happy to collaborate with resellers, do not hesitate to contact us should you have any questions.

PRODUCT RANGE

Standard Edition

Our standard datasets contain all administrative regions, localities and ZIP/postal codes* of a country, including business and administrative codes when available. Additional information such as neighborhoods, suburbs, time zones, elevations, administrative standard codes (ISO, FIPS, HASC, NUTS, National Statistics) are also provided. Please check our data design to get a list of all available fields.

All data are georeferenced using the WGS84 datum and can be easily imported into any software, database or GIS system.

This is the perfect product if you need to update your contact list, validate forms, build a store locator, display locations on a map, create statistics reports and much more.

Street+ Edition

The Street+ datasets contain all information from Standard datasets plus the comprehensive and geocoded list of street names for the whole country. This is the perfect tool to build a geocoder, check and improve the quality of your addresses or enhance your GIS system.

Please note that Street+ datasets are available for selected countries only.

Packages

If you need more data, we have bulk packages of our standard datasets. This is a great opportunity to get a complete region at a discounted price.

---

* Please note that for countries which have no postal code system, this field is left empty.

Product list

Pricing

Available file formats

Our data is provided in several text and GIS formats which can easily be imported into any software or database management system. All available formats are stored in a single zipped file.

CSV

CSV (Comma-separated values) data is one of the most ubiquitous file formats, most spreadsheets and databases can easily read native CSV files. Its simple format can be edited in a text editor. Many programming languages have special libraries to read and write CSV files, therefore making it a great medium for exchanging large quantities of data.

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)

ASC

We provide an alternative normalized ASCII version in CSV format where all accents and diacritics have been removed. This version can be used to facilitate searching or sorting.

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)

DAT

The DAT format is identical to the CSV format except that it is encoded in UTF-16. This format can be used with Microsoft SQL Server.

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)

Shapefile

ESRI Shapefile format (.shp) is a popular geospatial vector data format which can be imported into most geographic information system software (GIS) like ArcGIS, Grass, Quantum GIS, PostGIS and many others.

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

KML

The Keyhole Markup Language (.kml) is another popular geographic format using XML notation and maintained by Google. It can be used with Google products like Google Earth or Google Maps, as well as with many other software programs.

GeoPC_XX_Places.kml	Geographic points and attributes
GeoPC_XX_Streets.kml	Street geographic points (available with our Street+ product range)

GeoJSON

GeoJSON is an open standard format for encoding collections of geographical features along with their non-spatial attributes using JavaScript Object Notation.

GeoPC_XX_Places.json	Geographic points and attributes
GeoPC_XX_Streets.json	Street geographic points (available with our Street+ product range)

GML

The Geography Markup Language (.gml) is a XML grammar defined by the Open Geospatial Consortium (OGC) to express geographical features. GML serves as a modeling language for geographic systems as well as an open interchange format for geographic transactions on the Internet

GeoPC_XX_Places.gml	Geographic points and attributes
GeoPC_XX_Streets.gml	Street geographic points (available with our Street+ product range)

Tables and fields description

Our data is provided in the same consistent structure for all countries. Please note that Street+ files and some fields are not necessarily available for each country, we invite you to refer to the specific product sheet for more information.

Additional files are available in the Resources section.

Regions

This file defines the administrative divisions hierarchy of a country. An administrative division is a country subdivision with an official status. On top of the country level, we define up to 4 administrative divisions levels per country.

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

Places

This geocoded file is designed to store the postcodes which are used for regular mail delivery (standard house address).

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

Streets

This file is designed to store the comprehensive list of streets names for the whole country. It has a similar structure as the file "Places" and is geocoded.

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

Business & administrative

This file is designed to store specific postcodes which are not used for regular mail delivery (standard house address). It can be postcodes for governmental organizations, military operations centers, PO boxes, special codes for large companies, etc...

This file is not geocoded as these postcodes are not related to a geographical location.

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

Additional information

ISO

The ISO 3166-1 standard is published by the International Organization for Standardization (ISO) and defines a unique code for the name of each country. The country codes are represented as a two-letter code (alpha-2).

Language

When there are several official languages in the country, or for countries using a non-Latin alphabet, we provide a specific version for each record. The field contains the language code and allows to select a specific version.

Level

This field contains a value ranked from 0 to 4 to define the administrative division level, from the largest to the smallest (0 for the country, 4 for the smallest division). Depending on the country, only some levels may be available.

Region1-4

These fields contain the name of administrative divisions for each available level. If not applicable, the value '-' will be indicated.

Locality

Contains the settlement name. The type of settlement may vary depending on the country (city, town, village, etc..).

Postcode

When applicable, this field contains the valid postal code for the specific record. In case there is no postal codes in use, this field remain blank. The postcode structure vary for each country.

Suburb

A suburb is a residential area or a mixed use area, either existing as part of a city or urban area or as a separate residential community within commuting distance of a city. The suburb is indicated if it is determinant for the postcode.

Street

Available in Street+ products, this field contains the full street name.

Range

Available in Street+ products, a street numbers range is provided in case it is determinant for the postal code (when a same street is spread across several postal codes). If the entire street is included within the same postcode area, usually this field is left empty.

When used, the ranges are described using the following notation:
- Continuous numbers : 1-10
- Odd numbers range : (1-9)
- Even numbers range : [2-8]
Block ranges are sperated by a comma, ex: (1-5),[2-8],(9-17)

Building

Available in Street+ products, a building name is provided in case it is determinant for the postal code. If not determinant, the field remains blank.

Entity

This field contains information related to a postal code provided in the Business & Administrative files such as an Organization, a Military location or a Company name.

Info

An additional information for Business & Administrative data such as PO Boxes or address details.

Latitude / Longitude

These fields contain the geographic coordinates related to the specific locality and postal code of the record. The geographical position is usually precise to about one hundred meters and corresponds to the center of the locality (generally the historical center, and if not, the geographical center). In some countries, the postal code may refer to a block or a street, in which case the coordinates point to that specific location. In case the georeference is not known precisely, a central point will be defined. Depending on the information available, the point can be defined as a central point of the locality, or as a central point of a higher administrative division. All our files are created using the World Geodetic System standard WGS 84. The corresponding SRID reference is EPSG:4326.

Elevation

This field contains the elevation in meters applicable for the specific locality defined in the record.

Timezone

The name of the time zone for a given record according the IANA tz database (sometimes called Olson database).

UTC

The Coordinated Universal Time (UTC) is the time standard commonly used across the world to keep time synchronized.

DST

The Daylight Saving Time (DST) is the practice of setting the clocks forward one hour from standard time during the summer months, and back again in the fall, in order to make better use of natural daylight.

ISO2

The ISO 3166-2 standard is published by the International Organization for Standardization (ISO) and defines codes for the names of the principal subdivisions of all countries. The codes for subdivisions are represented as the alpha-2 code for the country, followed by up to three characters.

FIPS

The NGA Geopolitical codes (Formerly known as FIPS PUB 10-4) is a standard published by the U.S. National Geospatial Intelligence Agency and contains countries, dependencies, areas of special sovereignty and their principal administrative divisions.

NUTS

The Nomenclature of Territorial Units for Statistics (NUTS) database is a standard provided by the European Commission for statistical purposes.

HASC

The Hierarchical administrative subdivision codes (HASC) are codes to represent names of country primary subdivisions, such as states, province, regions. The codes are alphabetic and have constant length for the first level subdivisions.

STAT

The statistical codes are codes defined by each National Statistical Offices.

How to import the data

Below you will find how to import GeoPostcodes datasets into the most common DBMS.

MySQL

Use the following SQL code to create the table structure and indexes in MySQL:

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;

Use the following SQL code to import the CSV data in MySQL:

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;

Postgres

Use the following SQL code to create the table structure and indexes in Postgres:

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 );

Use the following SQL code to import the CSV data in Postgres:

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';

SQL Server

Use the following SQL code to create the table structure and indexes in SQL Server:

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

Use the following SQL code to import the CSV data in SQL Server. Please note that CSV file must first be converted in UTF-16 encoding format as BULK INSERT command does not support UTF-8.

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

Oracle

Use the following SQL code to create the table structure and import the CSV data in Oracle:

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') );

SQLite

Use the following SQL code to create the table structure and indexes in SQLite:

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) );

Use the following SQL code to import the CSV data in SQLite:

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;

MS-Access

Follow the steps below to import the CSV data in Access:

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

MS-Excel

Follow the steps below to import the CSV data in Excel:

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:

• Excel 2003 and earlier : 65536 rows
• Excel 2007/2010/2013 : 1048576 rows

CSV

GeoPostcodes CSV files (Comma-separated values) are encoded in UTF-8 and use a semicolon (;) as field separator. This standard raw file format can be imported in most applications.

We provide an alternative normalized ASCII version (files with .asc extension) where all accents and diacritics have been removed. This version can be used to facilitate searching or sorting.

The file structure is described here.

KML

The Keyhole Markup Language (.kml) is a standard geographic format using XML notation, it can be imported directly into Google Earth, used with Google Maps API or parsed with PHP, Javascript and many other languages and software programs.

More information on KML on Wikipedia.

Shapefile

The ESRI Shapefile format (.shp) is a another standard geographic format which can be imported into most geographic information system software (GIS): ArcGIS, Grass, Quantum GIS (QGIS), PostGIS and many others.

The Shapefile format contains the following files:

• GeoPC_XX.shp, the shape format; the feature geometry itself
• GeoPC_XX.shx, the shape index format; the positional index of the feature geometry
• GeoPC_XX.dbf, the attribute format; columnar attributes for each shape, in dBase IV format

More information on Shapefile on Wikipedia.

GeoJSON

GeoJSON is an open standard format for encoding collections of simple geographical features along with their non-spatial attributes using JavaScript Object Notation.

More information on Wikipedia.

Languages and characters encoding

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.

Translations, transcriptions, transliterations

Several methods can be used to produce a version in the English language of a name written in a foreign language, the most common one being the translation. In this case, we assume that there is already a commonly used English name which matches the locality, for example Lisboa in Portugal is called Lisbon in English, then we talk about an exonym..

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 : Санкт-Петербург
English translation : Saint Petersburg
Transcription : Sankt Petersburg
Transliteration : Sankt-Peterburg

Multi-language countries

Å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) Kuwait (Arabic) Kyrgyzstan (Russian) Lebanon (Arabic) Macau (Chinese) Macedonia (Macedonian) Mongolia (Mongolian) Oman (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)

ASCII Transliteration tables

AZ : Azerbaijani (Azərbaycanca) BG : Bulgarian (Български) BS : Bosnian (Bosanski) CA : Catalan (Català) CS : Czech (Čeština) DA : Danish (Dansk) DE : German (Deutsch) EL : Greek (Ελληνικά) ES : Spanish (Español) ET : Estonian (Eesti) FI : Finnish (Suomi) FR : French (Français) HR : Croatian (Hrvatski) HU : Hungarian (Magyar) IS : Icelandic (Íslenska) IT : Italian (Italiano) LT : Lithuanian (Lietuvių) LV : Latvian (Latviešu)

MK : Macedonian (Македонски) MT : Maltese (Malti) NL : Dutch (Nederlands) NO : Norwegian (Norsk) PL : Polish (Polski) PT : Portuguese (Português) RO : Romanian (Română) RU : Russian (Русский) SK : Slovak (Slovenčina) SL : Slovenian (Slovenščina) SQ : Albanian (Shqip) SR : Serbian (Српски / Srpski) SV : Swedish (Svenska) SZ : Montenegrin (Crnogorski) TR : Turkish (Türkçe) UK : Ukrainian (Українська) UZ : Uzbek (O‘zbek) VI : Vietnamese (Tiếng Việt)

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