There are no notfications.

Database table of subdivisions of Iceland

Database table of subdivisions of Iceland
Initial release:
Current release:
Written in: SQL (UTF-8)
Size: 5890 bytes
Available in: English, Icelandic, Spanish
Licence: Database: ODbL
Database contents: DbCL
Documentation: CC BY 4.0
Download: Database-table-of-subdivisions-of-Iceland.zip

The database table of subdivisions of Iceland resource provides the municipalities, postal codes and regions of Iceland.

Tables

iceland_municipalities

The iceland_municipalities table contains the numbers and names of the municipalities and the regions within which they are located.

Table columns
Name Type Content Reference
number char(4) Municipality number.
municipality varchar(29) Municipality name.
region tinyint(3) iceland_regions.region

iceland_postal_codes

The iceland_postal_codes table contains the postal codes, the area which they serve and the region within which they are located. The area served can be a whole or partial municipality, post office box or the international mail sorting station.

Table columns
Name Type Content Reference
postal_code char(3) Postal code.
area_served varchar(39) Area served by the postal code.
region tinyint(3) iceland_regions.region

iceland_regions

The iceland_regions table contains the regions.

Table columns
Name Type Content Reference
region tinyint(3) Region code.

Directory contents

Directory listing
  • Database table of countries directory
    • Data directory
      • iceland_municipalities.sql file
      • iceland_postal_codes.sql file
      • iceland_regions.sql file
    • Testing directory
      • iceland_municipalities.sql file
      • iceland_postal_codes.sql file

Data (directory)

The Data directory contains all SQL scripts that create and modify the database tables.

iceland_municipalities.sql (file)

The iceland_municipalities.sql file contains the iceland_municipalities table.

iceland_postal_codes.sql (file)

The iceland_postal_codes.sql file contains the iceland_postal_codes table.

iceland_regions.sql (file)

The iceland_regions.sql file contains the iceland_regions table.

Testing (directory)

The Testing directory contains files used for testing the solution during development.

Licence

The database table of subdivisions of Iceland resource by eMedia Intellect is licensed under Open Database License. Any rights in individual contents of the database are licensed under Database Contents License.