Dataset: Belgium Addresses

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

19.87 MB
549802 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

169.92 MB
3876524 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

72.76 MB
1891124 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
);