Alexandria Quality of Life Indicators
Python
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
data
.gitignore
AQOLI ERD.jpg
AQOLI_NextSteps.pptx
README.md
ckan_data_load.py
group_bad.py
indicators.erd
make_groups.py
make_grp.py
make_grp_py33.py
make_packages.py
make_pkg.py
make_pkg_call.py
make_pkg_theme10.py
make_pkg_theme11.py
make_pkg_theme4.py
make_pkg_theme5.py
make_pkg_theme6.py
make_pkg_theme7.py
make_pkg_theme8.py
make_pkg_theme9.py
update_grp.py
upload_pkgs.py
warehouse_script.sql

README.md

aqoli

Alexandria Quality of Life Indicators

AQOLI ERD.jpg => diagram of data warehouse design, based on star schema

warehouse_script.sql => sample code to generate data warehouse in SQL-based RDBMS (syntax for PostgreSQL)

/data directory contains individual and bundled indicator files, in CSV format with consistent column headers:

  • all_annual_indic.csv => All annual indicators
  • all_indic.csv => All annual and monthly indicators
  • ind2_1_income_housing.csv => Data for indicator 2.1--housing costs as a percentage of income
  • and similar for the rest of the indicators in themes 2 through 11 (no data available yet for indicators in theme 1)
  • theme2_annual_indic.csv => All annual indicators for theme 2 (Basic Needs)
  • theme2_monthly_indic.csv => All monthly indicators for theme 2
  • theme4_annual_indic.csv - theme11_annual_indic.csv => All indicators for themes 4 through 11 (Theme 3 only has one indicator, contained in ind3_1_youthencourage.csv)

/data/metadata directory contains Excel metadata files describing the bundled indicator files:

  • AQOLI_indicator_metadata.xls => Metadata file for all_indic.csv
  • theme2_annual_metadata.xls => Metadata file for theme2_annual_indic.csv
  • theme2_monthly_metadata.xls => Metadata file for theme2_monthly_indic.csv
  • theme3_metadata.xls - theme11_metadata.xls => Metadata files for each theme's indicators