Skip to content

Instantly share code, notes, and snippets.

@staeff
Last active August 29, 2015 14:17
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save staeff/639889449053035b35d2 to your computer and use it in GitHub Desktop.
Save staeff/639889449053035b35d2 to your computer and use it in GitHub Desktop.
Data munging for Hackathon project "party haus"

Interesting data sets:

Einwohnerinnen und Einwohner in Berlin in LOR-Planungsräumen nach Wohndauer am 31.12.2014

  • How long are people living in an area? The data set provides the percentages of people living less the 5 years, between 5 years and 10 years, more then 10 years in an area. We expect areas with a higher percentage of people living there for a shorter time is more suited for parties!
  • also included in this data set: people younger than 5 or 10 years. So we have an indicator if there are a lot of children
  • the location is encoded in a number, which is resolved in this document: http://www.stadtentwicklung.berlin.de/planen/basisdaten_stadtentwicklung/lor/download/LOR-Schluesselsystematik.xls
  • After resolving the location key, we have a string saying, where it is. That still needs to be resolved to a map. Or we take info from the api as key.

data: https://www.statistik-berlin-brandenburg.de/opendata/Beschreibung_Wohndauer_Lage_Datenpool.pdf
description of data: https://www.statistik-berlin-brandenburg.de/opendata/Beschreibung_Wohndauer_Lage_Datenpool.pdf

Einwohnerinnen und Einwohner nach Wohnlagen in den LOR-Planungsräumen am 31.12.2014

  • What is the age structure of an area? We assume a certain structure with not many young children and old people is more tolerant to eventual party noises.
  • The data set also provides a differentiation between Germans and Non-Germans. I forgot, if we wanted to operationalise this.
  • data for 96 Ortsteile (finer level than Bezirke)
  • data is broken down to age group by 5 year steps, german/non-german, sex, in a certain Ortsteil. *

data: https://www.statistik-berlin-brandenburg.de/opendata/EWR_Ortsteile_2014-12-31.csv
description of data: https://www.statistik-berlin-brandenburg.de/opendata/Beschreibung_EWR_Ortsteile_2014.pdf

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment