Database of subdivisions of Iceland
| Initial release: | |
|---|---|
| Current release: | |
| Written in: | SQL (UTF-8) |
| Size: | 8026 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.
| 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.
| 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.
| 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.
| Name | Type | Content | Reference |
|---|---|---|---|
| region | tinyint(3) | Region code. | – |
Directory contents
- 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
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.