There are no notfications.

Database of subdivisions of Iceland

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

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

Tables

localities

The localities table contains the names of the localities and the regions within which they are located.

Table columns
Name Type Content Reference
identifier tinyint(3) Unique row identifier.
locality varchar(25) Locality name.
municipality char(4) municipalities.number

municipalities

The 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) regions.region

postal_codes

The postal_codes table contains the postal codes and the area that they serve.

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

regions

The regions table contains the regions.

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

Directory contents

Directory listing
  • Database of countries directory
    • Data directory
      • iceland_subdivisions.sql file
      • localities.sql file
      • municipalities.sql file
      • postal_codes.sql file
      • regions.sql file
    • Testing directory
      • localities.sql file
      • municipalities.sql file
      • postal_codes.sql file

Data (directory)

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

iceland_subdivisions.sql (file)

The iceland_subdivisions.sql file creates the iceland_subdivisions database.

localities.sql (file)

The localities.sql file contains the localities table.

municipalities.sql (file)

The municipalities.sql file contains the municipalities table.

postal_codes.sql (file)

The postal_codes.sql file contains the postal_codes table.

regions.sql (file)

The regions.sql file contains the regions table.

Testing (directory)

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

Licence

The database 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.