Skip to content
This repository was archived by the owner on Jul 15, 2024. It is now read-only.
This repository was archived by the owner on Jul 15, 2024. It is now read-only.

Add CBS dataset in dataverbinders-datamart #70

@dkapitan

Description

@dkapitan

For easy access, add cbs dataset in project dataverbinders-datamart with following tables:

Catalog

  • dataset_id
  • dataset_description
  • dataset_period_first_year: first year included in dataset
  • dataset_period_last_year: last year included in dataset

Kerncijfers wijken and buurten

Combine data from 2013 onwards for easy historical comparison. Taking 2013 here, because earlier data has different format, so we'll leave integration of those for later.
https://www.cbs.nl/nl-nl/dossier/nederland-regionaal/wijk-en-buurtstatistieken

Nabijheidsstatistieken

Same as above, but then for nabijheidsstatistieken from 2006 onwards
https://www.cbs.nl/nl-nl/reeksen/nabijheidsstatistieken-per-wijk-buurt

Bevolkingsstatistieken per pc4

https://opendata.cbs.nl/statline/portal.html?_la=nl&_catalog=CBS&tableId=83502NED&_theme=266

Mapping pc6huisnummer tot buurten and wijken

Using this SQL query

select
  gwb.PC6 as postcode,
  gwb.huisnummer,
  gwb.Buurt2019 as buurt_code,
  brt.Buurtnaam_2019 as buurt_naam,
  gwb.Wijk2019 as wijk_code,
  wijk.Wijknaam_2019K_NAAM as wijk_naam,
  gwb.Gemeente2019 as gemeente_code,
  gem.Gemeentenaam2019 as gemeente_naam
from `dk-open-data.cbs.pc6hnr20190801_gwb` as gwb
left join `dk-open-data.cbs.buurt2019` as brt on brt.Buurtcode_2019 = gwb.Buurt2019 
left join `dk-open-data.cbs.wijk2019` as wijk on wijk.Wijkcode2019 = gwb.Wijk2019 
left join `dk-open-data.cbs.gem2019` as gem on gem.Gemcode2019 = gwb.Gemeente2019 

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions