aqoli's Introduction

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

Recommend Projects