Name: Belgium Addresses
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

Belgium Addresses

This dataset is taken from https://opendata.bosa.be/index.fr.html.

It contains 3 csv file for 3 regions in Belgium:

Brussels - openaddress-bebru.csv
Flandres -openaddress-bevlg.csv
Wallonie -openaddress-bewal.csv

It's part of modelling 3d houses in Belgium project that I undertook.

Tables

Openaddress Bebru

@kaggle.kaiyungtan_belgium_addresses.openaddress_bebru

20.84 MB
549,802 rows
20 columns

CREATE TABLE openaddress_bebru (
  "epsg_31370_x" DOUBLE,
  "epsg_31370_y" DOUBLE,
  "epsg_4326_lat" DOUBLE,
  "epsg_4326_lon" DOUBLE,
  "address_id" BIGINT,
  "box_number" VARCHAR,
  "house_number" VARCHAR,
  "municipality_id" BIGINT,
  "municipality_name_de" VARCHAR,
  "municipality_name_fr" VARCHAR,
  "municipality_name_nl" VARCHAR,
  "postcode" BIGINT,
  "postname_fr" VARCHAR,
  "postname_nl" VARCHAR,
  "street_id" BIGINT,
  "streetname_de" VARCHAR,
  "streetname_fr" VARCHAR,
  "streetname_nl" VARCHAR,
  "region_code" VARCHAR,
  "status" VARCHAR
);

Openaddress Bevlg

@kaggle.kaiyungtan_belgium_addresses.openaddress_bevlg

178.17 MB
3,876,524 rows
20 columns

CREATE TABLE openaddress_bevlg (
  "epsg_31370_x" DOUBLE,
  "epsg_31370_y" DOUBLE,
  "epsg_4326_lat" DOUBLE,
  "epsg_4326_lon" DOUBLE,
  "address_id" BIGINT,
  "box_number" VARCHAR,
  "house_number" VARCHAR,
  "municipality_id" BIGINT,
  "municipality_name_de" VARCHAR,
  "municipality_name_fr" VARCHAR,
  "municipality_name_nl" VARCHAR,
  "postcode" BIGINT,
  "postname_fr" VARCHAR,
  "postname_nl" VARCHAR,
  "street_id" BIGINT,
  "streetname_de" VARCHAR,
  "streetname_fr" VARCHAR,
  "streetname_nl" VARCHAR,
  "region_code" VARCHAR,
  "status" VARCHAR
);

Openaddress Bewal

@kaggle.kaiyungtan_belgium_addresses.openaddress_bewal

76.29 MB
1,891,124 rows
20 columns

CREATE TABLE openaddress_bewal (
  "epsg_31370_x" DOUBLE,
  "epsg_31370_y" DOUBLE,
  "epsg_4326_lat" DOUBLE,
  "epsg_4326_lon" DOUBLE,
  "address_id" BIGINT,
  "box_number" VARCHAR,
  "house_number" VARCHAR,
  "municipality_id" BIGINT,
  "municipality_name_de" VARCHAR,
  "municipality_name_fr" VARCHAR,
  "municipality_name_nl" VARCHAR,
  "postcode" BIGINT,
  "postname_fr" VARCHAR,
  "postname_nl" VARCHAR,
  "street_id" BIGINT,
  "streetname_de" VARCHAR,
  "streetname_fr" VARCHAR,
  "streetname_nl" VARCHAR,
  "region_code" VARCHAR,
  "status" VARCHAR
);