Load CBS data into PostgreSQL database

load_cbs_pc4.py

# download file from https://www.cbs.nl/nl-nl/dossier/nederland-regionaal/geografische%20data/wijk-en-buurtkaart-2017
import shapefile
import pandas as pd
from sqlalchemy import create_engine


db = create_engine('postgresql://localhost:5432/opendata')
sf = shapefile.Reader("/Users/dkapitan/opendata/CBS_PC4_2017/CBS_PC4_2017_v1.shp")

shapes = sf.shapes()
records = sf.records()
cols = [field[0] for field in sf.fields][1:]
df = pd.DataFrame.from_records(records, columns=cols)
df.to_sql('pc4', db, schema='cbs', if_exists='replace', index=False, )