| Basic version | Professional version | |
|---|---|---|
| Price | € 790,00 excl. VAT (per year) | € 1.317,00 excl. VAT (per year) |
| Updates | Weekly, monthly, quarterly or yearly | Weekly, monthly, quarterly or yearly |
| Database | Merged | Merged and/or normalised |
| Database type | CSV, PCTR, Microsoft SQL, ANSI SQL (Oracle, Sybase, MySQL, etc.) | CSV, Microsoft SQL, ANSI SQL (Oracle, Sybase, MySQL, etc.) |
| UTF-8 | ASCII also available | ASCII also available |
| Detail | Postcode range | Postcode range and individual house number |
| Lot info | no | yes |
| Unique keys | no | yes (Governmental and Postcode.nl) |
| Coordinates | no | yes |
| Number of records | Approximately 650,000 | Approximately 9,000,000 |
Demo files
Below you will find the demo files for the Dutch Postcode database. A demo file consists of three parts: An initial file, a mutation file and the end file matching what the database should look like after the execution of the mutation file. The technical structure of the databases, the recorded data and possible processing methods are described in the Technical document for the Postcode database. A demo file contains all postal code data from the province of North Holland, in the period of week 17 and week 18 of 2012. Ordinary and applied SQL versions have different mutation formats. The applied version contains direct SQL statements.
| Database versions | ANSI SQL | ANSI SQL (applied) | MS SQL | MS SQL (applied) | CSV |
|---|---|---|---|---|---|
| Basic version | |||||
| Merged ASCII + UTF-8 | Download | Download | Download | Download | Download |
| Professional version | |||||
| Normalised ASCII + UTF-8 | Download | Download | Download | Download | Download |
| Merged ASCII + UTF-8 | Download | Download | Download | Download | Download |
Demo file PCTR (CRM compatible)
Some CRM systems (such as AX Dynamics) expect a specific fixed length columns format, also called the PCTR file format. The demo PCTR files below are based on the same format, and should work in most systems. The demo files also contains a PCTMUTR file with mutations to test the processing of mutations.
An extension of this format is the PCTP/PCTH format, which adds individual addresses. This format only adds house number and house number addition information, and does not add coordinates or other address level information.
The ASCII format is most compatible with existing systems and converts the official names into ASCII variants. The UTF-8 version keeps the official names as-is, but does require the system to be able to import the UTF-8 fixed code-point length format.
| Database versions | ASCII | UTF-8 |
|---|---|---|
| Basic version (PCTR) | Download | Download |
| Professional version (PCTP/PCTH) | Download | Download |
Update methods
The mutations for the Dutch Postcode database can be supplied on two methods:
- By mail as a download link or as an attachment, for manual transfer of mutations.
- Per JSON-REST API for automatic retrieval of mutations. The Data API documentation describes how the API works technically.
How to order
The Dutch Postcode database can be ordered online. On working days you will receive the Dutch Postcode database the same day!