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

Name		Name	Last commit message	Last commit date
Latest commit History 20 Commits
data		data
.gitignore		.gitignore
AQOLI ERD.jpg		AQOLI ERD.jpg
AQOLI_NextSteps.pptx		AQOLI_NextSteps.pptx
README.md		README.md
bulk_insert.sql		bulk_insert.sql
ckan_data_load.py		ckan_data_load.py
create_tables.sql		create_tables.sql
create_tables_mssql.sql		create_tables_mssql.sql
group_bad.py		group_bad.py
indicators.erd		indicators.erd
indicators_erd.PNG		indicators_erd.PNG
insert_data.sql		insert_data.sql
insert_data_mssql.sql		insert_data_mssql.sql
make_groups.py		make_groups.py
make_grp.py		make_grp.py
make_grp_py33.py		make_grp_py33.py
make_packages.py		make_packages.py
make_pkg.py		make_pkg.py
make_pkg_call.py		make_pkg_call.py
make_pkg_theme10.py		make_pkg_theme10.py
make_pkg_theme11.py		make_pkg_theme11.py
make_pkg_theme4.py		make_pkg_theme4.py
make_pkg_theme5.py		make_pkg_theme5.py
make_pkg_theme6.py		make_pkg_theme6.py
make_pkg_theme7.py		make_pkg_theme7.py
make_pkg_theme8.py		make_pkg_theme8.py
make_pkg_theme9.py		make_pkg_theme9.py
update_grp.py		update_grp.py
upload_pkgs.py		upload_pkgs.py

arkut/aqoli