busypowerful
Blog
Home
Av Voice Changer Software Free Version Activation Code
Radio Code Software Free Download
Keygen Free Download Bitdefender Antivirus Plus 2019 Activation Code
Free Unlock Code For Samsung Galaxy Y S5360
Samsung Galaxy A5 Network Unlock Code Free
Nokia Security Code Software Free Download
Free Unlock Code For A Alcatel A205g
Binary Code Vector Free Download
T Mobile Sim Card Unlock Code For Free
Lg Aristo Unlock Code Free
Qr Code Icon Free Download
Alcatel Mw40cj Unlock Code Generator Free
Free Itunes Code No Survey No Download 2015
Free Att Sim Unlock Code
Lumia 550 Unlock Code Free
Is 1343 Code 2012 Free Download
Cracking The Dream Code Free Download
Blackberry Z10 Unlock Code Generator Free Download
Lg A340 Unlock Code Free
Free Psn Card Code Generator Download
Wps Office 2016 Activation Code Free Download
Civil Procedure Code In Hindi Free Download
Ulead Activation Code Free Download
Free Corel Draw X4 Serial Number And Activation Code
Avast Secureline Vpn Activation Code Free Image
Bitdefender Total Security 2017 Activation Code Free
Zte Blade Unlock Code Generator Free Download
Winzip Registration Activation Code Free
New Super Luigi U Free Download Code
Samsung Galaxy S3 Unlock Code Free Uk
Iphone 4 Unlock Code Generator Free Download
Pckeeper Antivirus Activation Code Free
Camfrog Chat Room Pro Activation Code Free
Free Postal Code Database Download
Free Telus Unlock Code Generator
Code Of Honor Game Free Download
Css Navigation Menu Code Free Download
Honda Radio Code Unlock Free Uk
Avast Pro Antivirus Activation Code 2014 Free Download
Nokia E5 00 Unlock Code Free
Wizard101 Gift Card Code Generator Free Download
Blog
Home
Av Voice Changer Software Free Version Activation Code
Radio Code Software Free Download
Keygen Free Download Bitdefender Antivirus Plus 2019 Activation Code
Free Unlock Code For Samsung Galaxy Y S5360
Samsung Galaxy A5 Network Unlock Code Free
Nokia Security Code Software Free Download
Free Unlock Code For A Alcatel A205g
Binary Code Vector Free Download
T Mobile Sim Card Unlock Code For Free
Lg Aristo Unlock Code Free
Qr Code Icon Free Download
Alcatel Mw40cj Unlock Code Generator Free
Free Itunes Code No Survey No Download 2015
Free Att Sim Unlock Code
Lumia 550 Unlock Code Free
Is 1343 Code 2012 Free Download
Cracking The Dream Code Free Download
Blackberry Z10 Unlock Code Generator Free Download
Lg A340 Unlock Code Free
Free Psn Card Code Generator Download
Wps Office 2016 Activation Code Free Download
Civil Procedure Code In Hindi Free Download
Ulead Activation Code Free Download
Free Corel Draw X4 Serial Number And Activation Code
Avast Secureline Vpn Activation Code Free Image
Bitdefender Total Security 2017 Activation Code Free
Zte Blade Unlock Code Generator Free Download
Winzip Registration Activation Code Free
New Super Luigi U Free Download Code
Samsung Galaxy S3 Unlock Code Free Uk
Iphone 4 Unlock Code Generator Free Download
Pckeeper Antivirus Activation Code Free
Camfrog Chat Room Pro Activation Code Free
Free Postal Code Database Download
Free Telus Unlock Code Generator
Code Of Honor Game Free Download
Css Navigation Menu Code Free Download
Honda Radio Code Unlock Free Uk
Avast Pro Antivirus Activation Code 2014 Free Download
Nokia E5 00 Unlock Code Free
Wizard101 Gift Card Code Generator Free Download
Free Postal Code Database Download For Windows 8
8 May 2014
CPOL
The 'Canadian Postal Codes' package will provide you with the extended Canadian Postal Codes database as well as Canadian geographical data like latitude. Free to try Zip Postal Codes. Free download of USPS Zip Codes database in CSV format. Data points include Zip Code Type, City, State, and Primary City. Latest Update. ZIP Code Database. Immediately download the U.S. ZIP Code Database, licensed from the U.S. Postal Service, with free monthly updates. Geocoded ZIP Codes come with Population data, Area Code, Time Zone, FIPs, CBSA, Medicare, and 90+ other columns of data. Our ZIP Code Database is set of all U.S. ZIP code data put into row and column format for easy use and manipulation. The free version comes with 7 data fields for every ZIP code in the United States. Download UK Postcodes with Latitude and Longitude. Download a list of UK out code postcodes with their latitude and longitude coordinates. The UK postal system uses postcodes to help with automating the sorting and delivery of mail. This is made up of a 2-part code, an out code and an in code.
Generate a postalcode database for lookups from dutch national data BAG
Introduction
This short tip will tell you how you can create your own postal-code database(MS SQL) for the Netherlands. This database will use the official national addresses and buildings(BAG) files as a source.
Iphone 4 unlock code generator free download
. This tip is just a walk-through and contains no source code (yet). Be warned that this process will take up to 6 hours on a 'regular' desktop computer with slow hard disks. Excuse all the Dutch in the pictures and names but this is due to the nature of the tip.
Background
Due to past legal restrictions, the Dutch postal-code collection with addresses was only available under licence for quite some money (€2730). But since 2012, it is now legal to use the Dutch governmental registration of addresses and buildings as a source. Although some nice websites have come up with postal-code lookups like www.postcodeapi.nu, it seems that no one ever explains how they convert the raw BAG data to something useful..and usable for Windows users. ;-)
Steps to Import the Data
Free Postal Code Database Download For Windows 8
1. The Source
To be able to do anything, we must first get the raw data. This can be achieved by going to the government website nationaalgeoregister.nl and searching for the keyword '
adressen
'. Then you will find a link to the atom feed with a big zipfile (1.5 gig) located at: http://geodata.nationaalgeoregister.nl/inspireadressen/extract/inspireadressen.zip of course you should download this file on to a local hard disk.
2. Indexing and Generating shapefile
Next, we need to index and rearrange the data. This is done with a 3
rd
party tool called: Bag-extract from the company Geon that can be found here. This program can be executed and used in the 'freeware' mode for our purposes. The program is actually built to handle this entire importing process into a database, but due to restrictions or problems, it does not generate the required data and or format.
Import the zip file on step 1 of the UI, and select the checkbox to extract everything from the file.
Press the step 2 button to extract and index the data. Be sure to choose a location with enough free space, the process will generate a lot of 20MB XML files that will take around 50GB of data! This will take about an hour and a half or so to be ready.
As I mentioned before, the data cannot be directly imported usefully into a SQL server instance with the 3
rd
option from this tool.. but it can generate shapefiles with all the data. The shapefile will then be imported with another tool to SQL Server.
To export the data to a shapefile, choose the 3
rd
UI button 'Convert selection' (and be sure you have still selected all the regions). Choose the shapefile export and choose a location with about 15Gb of free disc-space.
Please be sure to first change the options before you export:
Shapemaximum
: UPDATE! Set this to a maximum value of 4000000 (due to import problems of the latest version) you will end up with 3 shapefile
.dbf
database files to import (this not a problem but it requires you to import the 3 shapefile
*.dbf
separately in the next step).
Projection
: Select the projection you want to use: WD is default but is useless for map purposes. You rather want to choose the WGS84 projection if you want to do anything online with the coordinates.
3. Import the shapefile into MS SQL
First be sure that you have an instance of SQL server available form your computer and expect about 4Gb of data to be transferred (9million records). I have a local instance running of MS SQL Server Express 2012 (this is the free edition) which is more than suitable for this purpose. Create a new database that can be filled with the data, I called mine
shapeimport
. Use this name if you want to use the next script without modifying.
Okay, now you have a folder with a lot of shapefiles of enormous size and we need to import the file called
nummer.shp
(and thus
nummer.dbf
) into our database. Therefore, we use the 3
rd
party tool called SQL Server spatial tools from Morten Nielsen. You can read more on the program here.
Once you have downloaded the zip extract and run
Shape2Sql.exe
, choose the
nummer.shp
file, choose the connection to your local server and database, and set the geometry properties as shown here below.
After the first import that will take up to 2 hours, select the 2
nd
file
mummer001.shp
. Be sure you
uncheck
the 'Replace existing table' and change the 'Table Name' value from
nummer001
back to
nummer
.
Repeat this process until you have imported all the 3
nummerxxx.dbf
files.
Binary code vector free download eps
.
You are now the proud owner of a huge table with all the unstructured data from BAG.
4. Rearrange the Data
Right now, we're almost done.
Create a second database on your SQL server instance called
postalcode
and run the following SQL query on it. (It will take about half an hour - Check out the download link at the top of this page.)
This script generates useful tables and some views with all the data from the first database.
It will also generate a table with possible postal-code problems (postal-codes that are not correct identified by their erroneous location).
You will end up with a useful database at about 2Gb with all the postalcodes, streets, house numbers and city's from all building objects in the Netherlands with their corresponding geolocation. If you have any improvements and/or comments, you are welcome to post them!
This is my second article on CodeProject!
Some Dutch keywords: postcode, straten, huisnummers, BAG, importeren, Nederlands, postcode database
10-05-2014:
Updated the
Shapemaximum
value to
4000000
due to import problems, you now need to import 3
.dbf
files