Basic version | Professional version | |
---|---|---|
Price | € 670,00 ex. VAT (per year) | € 1.115,00 ex. 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 and 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 en Postcode.nl) |
Coordinates | no | yes |
Number of records | Approximately 650,000 | Approximately 9,000,0000 |
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 file below is based on the same format, and should work in most systems. The demo file also contains a PCTMUTR file with mutations to test the processing of mutations. The PCTR demo file contains a selection of the following postcode areas: 1761, 2000, 2001, 2002, 2003, 3051 and 9084, time period January 2012.
Download PCTR demo file (Database Basic version)
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!